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) [EMAIL PROTECTED] > -----Original Message----- > From: Edson Alves Pereira [mailto:[EMAIL 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:[EMAIL 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
