Tomcat4 JDBC Realm: Problem With Informix

["Skladovs, Victor" <Sk...@his.de>]

Dear Friends!

I use Tomcat4 authentication (JDBCRealm) in my  applications. It works
fine with ORACLE, but trying to use this with INFORMIX database, I get
the following error in stdout.log file when starting Tomcat:

Create Catalina server
Starting service Tomcat-Standalone
Apache Tomcat/4.0.4
Catalina.start: LifecycleException:  Exception opening database
connection:  java.sql.SQLException: Transactions not supported
LifecycleException:  Exception opening database connection:
java.sql.SQLException: Transactions not supported
	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:388)
	at
org.apache.catalina.core.StandardServer.start(StandardServer.java:506)
	at
org.apache.catalina.startup.CatalinaService.start(CatalinaService.java:2
61)
	at
org.apache.catalina.startup.CatalinaService.execute(CatalinaService.java
:172)
	at
org.apache.catalina.startup.Catalina.process(Catalina.java:179)
	at java.lang.reflect.Method.invoke(Native Method)
	at
org.apache.catalina.startup.BootstrapService.main(BootstrapService.java:
428)
----- Root Cause -----
java.sql.SQLException: Transactions not supported
	at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:348)
	at
com.informix.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java:1454)
	at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:549)
	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.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.CatalinaService.start(CatalinaService.java:2
61)
	at
org.apache.catalina.startup.CatalinaService.execute(CatalinaService.java
:172)
	at
org.apache.catalina.startup.Catalina.process(Catalina.java:179)
	at java.lang.reflect.Method.invoke(Native Method)
	at
org.apache.catalina.startup.BootstrapService.main(BootstrapService.java:
428)

JDBCRealm is configured in server.xml as follows:

<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" 
       driverName="com.informix.jdbc.IfxDriver" 
 
connectionURL="jdbc:informix-sqli://MyServer:1526/standard:INFORMIXSERVE
R=ice_wr" 
       connectionName="iceadmin" connectionPassword="le_puy" 
       userTable="user_table" userNameCol="anmeldung"
userCredCol="passwd" 
       userRoleTable="role_table" roleNameCol="role"/>

Has anybody already faced this problem? What could be the solution?

Thanx in advance

Regards,
Viktor


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>