[jboss-user] [Beginners Corner] - Re: Problem Connection to Sybase Adaptive Server using jndi

[mo_ctaylor]

I had problems with closed connections and a Sybase data store with JBoss. It seemed to happen after the connection was removed from the pool and I got "IdleRemover notifying pools, interval: 450000" in server.log. The work around I found from reading the wiki and other sources was to add the following to my data store configuration file (sybase_ds.xml):

<check-valid-connection-sql>select 1</check-valid-connection-sql>

see http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3987661#3987661

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3987661