That's correct. (I am not actually doing this, you understand. Tomcat is supposed to do this for me!)

I took the password off the database and it works. It's good enough to keep going with jsp development, but I still need to know how to do this with the password. So, I do not understand what the problem with the password is. I know the password that I was supplying in server.xml was correct.

So, if anyone has any ideas as to how to get it to work, go ahead.

Thanks.

Yaakov Chaikin
Software Engineer
BAE SYSTEMS
301-838-6899 (phone)
301-838-6802 (fax)
yaakov.y.chaikin@(protected)


> -----Original Message-----
> From: Edson Alves Pereira [mailto:eapereira@(protected)]
> Sent: Friday, December 05, 2003 1:38 PM
> To: 'Tomcat Users List'
> Subject: RE: Database pool problem
>
>  So, correct if i´m wrong. To connect to you database is:
>
>  Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
>
>  Connection dbConn = DriverManager.getConnection( "jdbc:odbc:afec",
> "UserName", "UserPassword" );
>
> > ----------
> > De:  Chaikin, Yaakov Y (US SSA)[SMTP:yaakov.y.chaikin@(protected)]
> > Responder:  Tomcat Users List
> > Enviada:  sexta-feira, 5 de dezembro de 2003 14:17
> > Para:  Tomcat Users List
> > Assunto:  RE: Database pool problem
> >
> > >  Could you show us how you make a simple connection to that M$
> > Acess
> > > database to compare?
> >
> > Well, I sort of already did. The realm is working 100% using that
> > database. Here is my <Realm> tag:
> >
> > <Realm
> >   className="org.apache.catalina.realm.JDBCRealm"
> >  connectionName="default"
> >  connectionPassword="afecrelease2003"
> >  connectionURL="jdbc:odbc:afec" debug="0"
> >  driverName="sun.jdbc.odbc.JdbcOdbcDriver"
> >  roleNameCol="UserRole"
> >  userCredCol="UserPassword"
> >  userNameCol="UserName"
> >  userRoleTable="TestUsers"
> >  userTable="TestUsers" validate="true"/>
> >
> > This works and it's the same attributes, just with different names to
> > comply with Realm tag dtd.
> >
> > Any ideas?
> >
> > Thanks,
> > Yaakov.
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
> > For additional commands, e-mail: tomcat-user-help@(protected)
> >

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)