Re: JDBC Realm error on startup
What can you recommend to use as a driver (JDBC) for an Access/Tomcat/Apache/jdk 1.3.1 configuration?? thanks, dave Using the JDBC-ODBC Bridge can not lead to jar problems as is included on the default bootstrap classpath.., perhaps a incorrectly created ODBC? My point was not that the bridge would cause this problem but that it causes problems in general. Why add another layer to your code when it is unnecessary. The only reason I really see for Access is DB portability to other machine, and for most individuals this is not an issue. --- Michael Wentzel Software Developer Software As We Think - http://www.aswethink.com
Re: JDBC Realm error on startup
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(ContextManager.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
Re: JDBC Realm error on startup
Information: MS Access DB Tomcat 3.2.2 Apache 1.3.20 jdk 1.3.1 I only have the bare apps installed... examples, test, root, and admin. What would the missing JDBC jars be for these apps? dave -- From: Ignacio J. Ortega [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: JDBC Realm error on startup Date: Mon, Jul 9, 2001, 1:11 PM 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
RE: JDBC Realm error on startup
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
RE: JDBC Realm error on startup
Using the JDBC-ODBC Bridge can not lead to jar problems as is included on the default bootstrap classpath.., perhaps a incorrectly created ODBC? My point was not that the bridge would cause this problem but that it causes problems in general. Why add another layer to your code when it is unnecessary. The only reason I really see for Access is DB portability to other machine, and for most individuals this is not an issue. --- Michael Wentzel Software Developer Software As We Think - http://www.aswethink.com
RE: JDBC Realm error on startup
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