Database Software

Hi,

I don't know if anyone has seen an error like this, but I thought I would throw this out here and see if anyone has....

I have a Websphere server (WAS) and a Times Ten server (they are separate).

I have setup and verified that I can connect from the WAS to the Times Ten database (this was done via the Times Ten demo application included with the TT installation). I have also verified that on the WAS server the DSN setup was able to connect to the Times Ten database.

However the application developers are having issues running their "code" through the WAS server. They are using Hibernate?? and they get the following error:

[6/5/08 15:03:11:943 CDT] 00000027 SystemOut O 2008-06-05 15:03:11,943 ERROR [org.hibernate.transaction.JDBCTransaction] - Could not toggle autocommit com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.

It is possible that this occurs because of the following which works outside of WebSphere but is treated by the WebSpere container as a fatal error:

[6/5/08 15:39:13:273 CDT] 0000001e ConnectionEve A J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adapter for resource jdbc/ECATTTRDS. The exception which was received is com.ibm.websphere.ce.cm.StaleConnectionException: [TimesTen][TimesTen 7.0.4.0.0 CLIENT]Query Timeout must be numeric; if the Network Timeout is non-zero, the Query Timeout must be greater than zero and less than the Network Timeout, else if the Network Timeout is zero, the Query Timeout must be greater than or equal to zero.:java.sql.SQLException: [TimesTen][TimesTen 7.0.4.0.0 CLIENT]Query Timeout must be numeric; if the Network Timeout is non-zero, the Query Timeout must be greater than zero and less than the Network Timeout, else if the Network Timeout is zero, the Query Timeout must be greater than or equal to zero.

I originally had the Times Ten parameter SQLQueryTimeout set to zero. I have tried setting this value to 10 and 3. I have gotten the above error all times. I know my network time out is greater that 10 seconds but I don't know the exact time.

Any help or suggestions here would be greatly appreciated.

Regards,

Chris