Re: 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(at)ifl(dot)it>
To: <pgsql-jdbc(at)postgresql(dot)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(at)postgresql(dot)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(at)postgresql(dot)org
>