DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=9662>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=9662

JDBCRealm doesn't work with postgres 7.2 driver

           Summary: JDBCRealm doesn't work with postgres 7.2 driver
           Product: Tomcat 4
           Version: 4.0.3 Final
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: Blocker
          Priority: Other
         Component: Catalina
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


I've configured JDBCRealm to autenticate some resources.
I've created a database postgresql (7.2) and I've configured server.xml like 
example in documentation to confirm access in a application:

        <Context path="/AreaRiservata" docBase="AreaRiservata" debug="0">
              <Realm className="org.apache.catalina.realm.JDBCRealm"
                debug="99"
                driverName="org.postgresql.Driver"
                connectionURL="jdbc:postgresql://monolite/areariservata"
                connectionName="sysdba"
                userTable="users" userNameCol="user_name" 
                userCredCol="user_pass"
                userRoleTable="user_roles" roleNameCol="role_name" />
        </Context>

I've launched "./catalina.sh run" and in output I could see this error:


Catalina.start: LifecycleException:  Exception opening database connection:  
java.sql.SQLException: org.postgresql.Driver
LifecycleException:  Exception opening database connection:  
java.sql.SQLException: org.postgresql.Driver
        at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
        at org.apache.catalina.core.StandardContext.start
(StandardContext.java:3345)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
        at org.apache.catalina.core.StandardEngine.start
(StandardEngine.java:343)
        at org.apache.catalina.core.StandardService.start
(StandardService.java:388)
        at org.apache.catalina.core.StandardServer.start
(StandardServer.java:506)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
----- Root Cause -----
java.sql.SQLException: org.postgresql.Driver
        at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538)
        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:3345)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:614)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
        at org.apache.catalina.core.StandardEngine.start
(StandardEngine.java:343)
        at org.apache.catalina.core.StandardService.start
(StandardService.java:388)
        at org.apache.catalina.core.StandardServer.start
(StandardServer.java:506)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
        at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
        at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)


!!! Attention !!!

In Windows 2000 Pro platform this problem there aren't:
In Win there aren't any problem with only authentication.

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to