Re: mysql issue...

Hi, this is kind of a mysql "feature". Connections that are not used for some time are automatically closed. If you are using spring you can workaround this with the following datasource configuration: Regards Kai --- Original Nachricht --- Absender: pady Datum: 21.12

mysql issue...

Hi, ibatis 2.3 mysql 5.0.29 mysql-connector 5.0.4 After a few hours of my web app being idle, when I try to connect I get this exception, when i try to connect through ibatis: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid o

Re: Oracle SQL DATE conversion problem using iBATIS via Java JDBC

Richard, I rediscovered some of what you have reported here. That was an extraordinary marshalling of info to explain things in detail! I also found a happy way to solve this in context of using iBATIS and JDBC. I posted my fix back on stackoverflow: using iBATIS custom type handler to address O

Re: Oracle SQL DATE conversion problem using iBATIS via Java JDBC

Roger, See: http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html#08_01 Specifically: Simple Data Types What is going on with DATE and TIMESTAMP? This section is on *simple* data types. :-) Prior to 9.2, the Oracle JDBC drivers mapped the DATE SQL type to java.sql.Timesta

Re: Oracle SQL DATE conversion problem using iBATIS via Java JDBC

Roger, Sorry about my last post. I'm sure I've used TIMESTAMP before with Oracle and iBATIS and it has returned the date and time fine. I'll check the version of the driver and version of iBATIS that I'm using when I get back to my office on Monday. -Richard Roger Voss wrote: I posted follo

Re: Oracle SQL DATE conversion problem using iBATIS via Java JDBC

Perhaps you should use TIMESTAMP instead of DATE. -R Roger Voss wrote: I posted following question/problem on stackoverflow, so if anyone knows a resolution, would be good to see it answered there: Oracle SQL DATE conversion problem using iBATIS via Java JDBC