• 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

Configuring jTDS in WebSphere Application Server 6.0

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am trying to use jTDS to connect to sybase databse from WebSphere Application Server 6.0. I tried configring the data source with databasename,servername,port as custom properties. When I tried testing the connection I am getting the following error.

Test connection failed for data source sybase on server server1 at node wlp40837Node01 with the following exception: java.lang.Exception: java.sql.SQLException: I/O Error: DB server closed connection.DSRA0010E: SQL State = 08S01, Error Code = 0. View JVM logs for further details.

Can anyone help with the steps or tell me if I am missing someting.
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
After spending the better part of a day trying to solve this same situation (and wishing someone had responded to this old post), I finally figured it out.

The key seems to be setting a custom property named "serverType" to a value of "2". You would think a logical value like "sybase" or something would be valid, but apparently not. After digging through the jTDS code, I found that serverType 1 means SQL Server and serverType 2 means Sybase.

So my working config has the following 4 custom properties defined:
serverName = <dbserver_hostname_or_ip>
databaseName = <my_DB_name>
portNumber = <my_DB_server_port_number> (type is java.lang.Integer)
serverType = 2 (type is java.lang.String, but I don't know if this matters)

This is on WebSphere 6.0.0.2. Everything else is configured the way you would guess, no other surprises.

Perhaps by posting this here, I can save some other poor soul from spending as much time as I did.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic