JDBCProxy "No database connection" on 'SELECT *'?
Posted in 2009
Hello, We've kind of hit a wall again with the IfxJDBCProxy around here. Last week, our tests worked find (or at least seemed to), and all of a sudden we have problems with any 'SELECT * FROM table' we try on the damned thing. At the same time, the tomcat (5.5) log throws: """ Nov 25, 2009 2:30:49 PM org.apache.catalina.core.ApplicationContext log INFO: org.apache.catalina.INVOKER.IfxJDBCProxy: getManager: null Nov 25, 2009 2:30:49 PM org.apache.catalina.core.ApplicationContext log INFO: org.apache.catalina.INVOKER.IfxJDBCProxy: doPost: JDBC_REQUEST=SESSION_ERR;JDBC_SESSION=Proxy Error: No database connection. : Proxy Error: No database connection. """ The strange thing is: Every other request made is executed without problem, even say a 'SELECT COUNT(*) FROM table' gives the expected result, it's just 'SELECT *' on any table that makes the thing go nuts. Has anyone of you ever had this problem, or does anyone have an explanation or a solution idea for this? Thanks, Felix