Using the JDBC-ODBC Bridge can not lead to jar problems as is included
on the default bootstrap classpath.., perhaps a incorrectly created
ODBC? i dont know,but can you access your config with a plain vanilla
main java program..?? having and answer for this question probably will
help in resolve your issue..
Saludos ,
Ignacio J. Ortega
> -----Mensaje original-----
> De: Ignacio J. Ortega [mailto:[EMAIL PROTECTED]]
> Enviado el: lunes 9 de julio de 2001 19:12
> Para: '[EMAIL PROTECTED]'
> Asunto: RE: JDBC Realm error on startup
>
>
> This is a bug in JDBCRealm, that is trying to use a non existing
> resource string in localstrigs.properties, this bug is corrected ( a
> will be out ) on 3.2.2 / currently in CVS.
>
> But apart from that, the bug is only surfaced when you are trying to
> connect to an incorrect JDBC URL, beccause missing
> drivers..or whatever
> other propblem you have in your config.. look for missing JDBC Jars or
> alike..
>
> Saludos ,
> Ignacio J. Ortega
>
>
> > -----Mensaje original-----
> > De: David Herder [mailto:[EMAIL PROTECTED]]
> > Enviado el: lunes 9 de julio de 2001 18:23
> > Para: [EMAIL PROTECTED]
> > Asunto: Re: JDBC Realm error on startup
> > Importancia: Alta
> >
> >
> > I am still a little perplexed about which .jar file I should
> > use?? How do I
> > determine which library is needed from the following error message:
> >
> > 2001-07-06 02:49:01 - ContextManager: JDBCRealm: Starting
> > JDBCRealm, trying
> > to acquire JDBC Driver class and DB Connection
> > java.util.MissingResourceException: Can't find resource for bundle
> > java.util.PropertyResourceBundle, key
> > jdbcRealm.checkConnectionSQLException
> >
> > at java.util.ResourceBundle.getObject(ResourceBundle.java:382)
> > at java.util.ResourceBundle.getString(ResourceBundle.java:354)
> > at
> >
> org.apache.tomcat.util.StringManager.getString(StringManager.java:136)
> > at
> > org.apache.tomcat.request.JDBCRealm.checkConnection(JDBCRealm.
> > java:528)
> > at
> org.apache.tomcat.request.JDBCRealm.contextInit(JDBCRealm.java:407)
> > at
> > org.apache.tomcat.core.ContextManager.initContext(ContextManag
> > er.java:491)
> > at
> org.apache.tomcat.core.ContextManager.init(ContextManager.java:453)
> > at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:195)
> > at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:235)
> >
> > My server.xml file contains the following:
> > <RequestInterceptor
> className='org.apache.tomcat.request.JDBCRealm'
> > debug='99' driverName='sun.jdbc.odbc.JdbcOdbcDriver'
> > connectionURL='jdbc:odbc:TOMCAT' userTable='users'
> > userNameCol='user_name'
> > userCredCol='user_pass' userRoleTable='user_roles'
> > roleNameCol='role_name'/>
> >
> > I have the following .jars in my TOMCAT_HOME/lib dir:
> > ant.jar
> > dt.jar
> > htmlconvert.jar
> > i18n.jar
> > jasper.jar
> > jaws.jar
> > jaxp.jar
> > parser.jar
> > RmiJdbc.jar
> > rt.jar
> > servlet.jar
> > sunrassign.jar
> > tools.jar
> > webserver.jar
> >
> > I suspect that I would have to have the .jar file for the
> > JdbcOdbcDriver but
> > I dont know where this is or if I can compile it from .class
> > files. Any help
> > is appreciated.
> >
> > dave
> >
> > ----------
> > >From: Michael Wentzel <[EMAIL PROTECTED]>
> > >To: "'[EMAIL PROTECTED]'"
> > <[EMAIL PROTECTED]>
> > >Subject: RE: JDBC Realm error on startup
> > >Date: Fri, Jul 6, 2001, 3:21 PM
> > >
> >
> > >> I am getting the following error on startup of Tomcat:
> > >>
> > >> 2001-07-06 02:49:01 - ContextManager: JDBCRealm: Starting
> > >> JDBCRealm, trying
> > >> to acquire JDBC Driver class and DB Connection
> > >
> > > You need your libraries in TOMCAT_HOME/lib to be able to make
> > > the connection. Although JDBCRealm has been mentioned to work
> > > like "magic" in that it does all the work for you, you still have
> > > to have some library for communicating with the appropriate DB.
> > >
> > >> java.util.MissingResourceException: Can't find resource
> for bundle
> > >> java.util.PropertyResourceBundle, key
> > >> jdbcRealm.checkConnectionSQLException
> > >
> > > These are from the LocalString.properties files. If you open
> > > webserver.jar you will find several properties files. The one in
> > > org.apache.tomcat.request is the one this property should
> be in(the
> > > package which contains JDBCRealm).
> > >
> > > My copy does not have a key for
> > jdbcRealm.checkConnectionSQLException.
> > >
> > > ---
> > > Michael Wentzel
> > > Software Developer
> > > Software As We Think - http://www.aswethink.com
> > >
> >
>