Обсуждение: jdbc problems with tomcat
Hello to everybody, I am running postgresquel 6.5.3 and tomcat 4.0. Everything works fine when I access databases from servlets or JSP but I can't authenticate users with JDBCRealms in tomcat using postgresql databases. If I try to start Tomcat I get this error from the JDBC driver. I am using the driver jdbc6.5-1.2.jar java.lang.NullPointerException: at java.util.StringTokenizer.<init>(StringTokenizer.java:93) at postgresql.Driver.parseURL(Driver.java:240) at postgresql.Driver.connect(Driver.java:109) at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3334) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardHost.start(StandardHost.java:612) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:505) at org.apache.catalina.startup.Catalina.start(Catalina.java:776) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at java.lang.reflect.Method.invoke(Native Method) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) Is there a way to use Postgresql in JDBRealms? Thanks in advance Francesco Lunelli
Francesco I'm successfully using Postgresql 7.1.2 and Tomcat 4.0. I couldn't tell you why mine works and yours doesn't, but it may be worth upgrading your copy of Postgresql. Good luck Mark ----- Original Message ----- From: "Francesco Lunelli" <francesco@ifl.it> To: <pgsql-jdbc@postgresql.org> Sent: Tuesday, November 27, 2001 6:10 PM Subject: [JDBC] jdbc problems with tomcat > Hello to everybody, > I am running postgresquel 6.5.3 and tomcat 4.0. > Everything works fine when I access databases from servlets or JSP but I > can't authenticate users with JDBCRealms in tomcat using postgresql > databases. > If I try to start Tomcat I get this error from the JDBC driver. I am > using the driver jdbc6.5-1.2.jar > > java.lang.NullPointerException: > at java.util.StringTokenizer.<init>(StringTokenizer.java:93) > at postgresql.Driver.parseURL(Driver.java:240) > at postgresql.Driver.connect(Driver.java:109) > at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548) > at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) > at > org.apache.catalina.core.StandardContext.start(StandardContext.java:3334) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) > at > org.apache.catalina.core.StandardHost.start(StandardHost.java:612) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) > at > org.apache.catalina.core.StandardService.start(StandardService.java:388) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:505) > at org.apache.catalina.startup.Catalina.start(Catalina.java:776) > at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) > at org.apache.catalina.startup.Catalina.process(Catalina.java:179) > at java.lang.reflect.Method.invoke(Native Method) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) > > Is there a way to use Postgresql in JDBRealms? > Thanks in advance > Francesco Lunelli > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
Francesco, It is interesting to note that you are using the latest version of tomcat (4.0), but a version of postgres that is 3 years old. You really need to upgrade postgres to 7.1 (or if you wait a few weeks to 7.2). thanks, --Barry Francesco Lunelli wrote: > Hello to everybody, > I am running postgresquel 6.5.3 and tomcat 4.0. > Everything works fine when I access databases from servlets or JSP but I > can't authenticate users with JDBCRealms in tomcat using postgresql > databases. > If I try to start Tomcat I get this error from the JDBC driver. I am > using the driver jdbc6.5-1.2.jar > > java.lang.NullPointerException: > at java.util.StringTokenizer.<init>(StringTokenizer.java:93) > at postgresql.Driver.parseURL(Driver.java:240) > at postgresql.Driver.connect(Driver.java:109) > at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548) > at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) > at > org.apache.catalina.core.StandardContext.start(StandardContext.java:3334) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) > at org.apache.catalina.core.StandardHost.start(StandardHost.java:612) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) > at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) > at > org.apache.catalina.core.StandardService.start(StandardService.java:388) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:505) > at org.apache.catalina.startup.Catalina.start(Catalina.java:776) > at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) > at org.apache.catalina.startup.Catalina.process(Catalina.java:179) > at java.lang.reflect.Method.invoke(Native Method) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) > > Is there a way to use Postgresql in JDBRealms? > Thanks in advance > Francesco Lunelli > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >