• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Correct JDBC Driver for Sybase 12.x in Websphere 6.1

 
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have configured a Sybase 12.x DataSource called 'jdbc/SybaseData' in Websphere 6.1.

The jar used is jtds-1.2.5.jar with following details:

Implementation class name: net.sourceforge.jtds.jdbcx.JtdsDataSource

Data store helper class name: com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper


I am using quartz scheduler in my application. It gives the following exception.

[2/14/11 11:02:06:831 EST] 00000030 FreePool E J2CA0045E: Connection not available while invoking method createOrWaitForConnection for resource jdbc/SybaseData.
[2/14/11 11:02:06:834 EST] 0000002f FreePool E J2CA0045E: Connection not available while invoking method createOrWaitForConnection for resource jdbc/SybaseData.
[2/14/11 11:02:21:779 EST] 00000032 FreePool E J2CA0045E: Connection not available while invoking method createOrWaitForConnection for resource jdbc/SybaseData.
[2/14/11 11:02:21:781 EST] 00000032 ErrorLogger E org.quartz.core.ErrorLogger schedulerError An error occured while marking executed job complete (will continue attempts). job= 'DEFAULT.RateServerJob'
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'MYDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SybaseData' com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180028 [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SybaseData' com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180028]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:690)
at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:69)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3753)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3725)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.triggeredJobComplete(JobStoreSupport.java:2957)
at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1789)
at org.quartz.core.JobRunShell.completeTriggerRetryLoop(JobRunShell.java:416)
at org.quartz.core.JobRunShell.run(JobRunShell.java:293)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
Caused by: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SybaseData' com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180028
at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:163)
at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:109)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:687)
... 8 more

[2/14/11 11:02:26:539 EST] 0000003f FreePool E J2CA0045E: Connection not available while invoking method createOrWaitForConnection for resource jdbc/SybaseData.
[2/14/11 11:02:26:571 EST] 00000040 FreePool E J2CA0045E: Connection not available while invoking method createOrWaitForConnection for resource jdbc/SybaseData.
[2/14/11 11:02:44:682 EST] 0000003e FreePool E J2CA0045E: Connection not available while invoking method createOrWaitForConnection for resource jdbc/SybaseData.
[2/14/11 11:02:53:749 EST] 0000002d FreePool E J2CA0045E: Connection not available while invoking method createOrWaitForConnection for resource jdbc/SybaseData.


Will be happy to provide any more information required.
Please help me ..... this is urgent ...
Thanks !
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
How did you fix this issue?? Any updates.. please. Am also stuck with the same issue
 
Priyadarshan Kelkar
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I used JTA transaction in my Spring configuration instead of Datasource transaction and the issue was resolved.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic