Hi, it works now. :-) The reconnect function of Tomcat 4.1.29 works, when there is really no jdbc-connection from tomcat to the database. Therefore we changed the timeout settings in the firewall that the 'connction' timeout has the same value as the 'absolute' timeout an the 'half-close' timeout was modified to 0 seconds. After this changes the JDBCRealm became able to check if there is a jdbc-connection available or not and can try to reconnect. > I think 4.1.29's JDBCRealm tried to reconnect on failure. > > > > > > our firewall (Cisco PIX 506) seems to be the reason for a > > 'java.sql.Exception' given by the JDBCRealm: > > ------------------------------------------------------------------------- > >-------------------------- 2003-11-13 09:46:28 JDBCRealm[<dmz.domain>]: > > Exception performing authentication > > java.sql.SQLException: System or internal error > > ... > > ------------------------------------------------------------------------- > >-------------------------- The Tomcat 4.1.24 with our webapplication stays > > on the DMZ outside the firewall. The Database (the server for our > > JDBCRealm) stays behind the firewall, which let pass the TCP-Requests > > through the Port 'myport', we set in the > > 'connectionURL'. > > <Realm className="org.apache.catalina.realm.JDBCRealm" > > debug="99" driverName="com.informix.jdbc.IfxDriver" > > connectionURL="jdbc:informix-sqli://<ip-address-inside>:<myport>/upload:i > >nformixserver=<myserver>" connectionName="tomcat" > > connectionPassword="tomcat" > > userTable="users" > > userNameCol="user_name" > > userCredCol="user_pass" > > userRoleTable="user_roles" > > roleNameCol="role_name" /> > > > > If the Servlet-Engine on the DMZ don't get any authentication-requests > > for about one hour, the Cisco Pix doesn't detect any traffic on this > > established connection. Therefore (security reasons) the Pix kills the > > Realm-Connection from the DMZ to the Database, what is the only reason > > for a broken and unusable JDBCRealm. > > > > How can we force the Servlet-Engine to establish a new Realm-Connection > > to the Database without a restarting the complete Tomcat-Server ?
-- Holger de Wall LKV-SH, Steenbeker Weg 151, Kiel 24106 Tel. : +049 431-33987-38 Fax : +049 431-33987-20 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
