JDBCRealm with Informix DB

[Richard Li <rl...@amll.com>]

Hi all,

I just downloaded tomcat4.0.6 and modified the JDBCRealm for Informix
database.

When I use in
java.sql.DriverManager.getConnection("jdbc:informix-sqli://192.1.8.7:1536/Db
/customer:informixserver=leonov_net;
dbdate=MDY4-","cdr","cdr"), it works fine.

But when I used this in JDBCRealm in server.xml,
<Realm  className="org.apache.catalina.realm.JDBCRealm" debug="99"
        driverName="com.informix.jdbc.IfxDriver"

connectionURL="jdbc:informix-sqli://192.1.8.7:1536/Db/customer:informixserve
r=leonov_net;dbdate=MDY4-?user=cdr;password=cdr"
        userTable="users" userNameCol="user_name" userCredCol="user_pass"
        userRoleTable="user_roles" roleNameCol="role_name" />
and make sure there is user=cdr, passwd=cdr in table users and user_roles
it gave the following
**************************************************************************
Starting service Tomcat-Standalone
Apache Tomcat/4.0.6
Catalina.start: LifecycleException:  Exception opening database connection:
jav
a.sql.SQLException: Invalid ASF API input parameters.
LifecycleException:  Exception opening database connection:
java.sql.SQLExcepti
on: Invalid ASF API input parameters.
        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.StandardEngine.start(StandardEngine.java:343
)
        at
org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
        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 java.lang.reflect.Method.invoke(Native Method)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)

What do I miss ? Please advise.

Thanks,
Richard


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org