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: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>