Sidebar

How do I setup a Sybase JDBC connection?

0 votes
272 views
asked Jun 29, 2022 by lewis-s-9714 (1,020 points)
I'm trying to setup a Sybase connection but having trouble. I received a driver file "jtds-1.3.1.jar" from http://jtds.sourceforge.net/index.html that I added to our library folder and added the external library in System Configuration with Update. The system has been restarted also. In database connections I used the "Driver" "Custom" and tried to specify the Driver Class as net.sourceforge.jtds.jdbc.Driver (as suggested here: http://jtds.sourceforge.net/faq.html), but I get this error:

org.h2.message.DbException: Class "net.sourceforge.jtds.jdbc.Driver" not found [90086-175]

Am I missing a step? Am I specifying the Driver Class wrong?

1 Answer

+1 vote
 
Best answer

I tested this on my instance. Here is the setup of the db connection:

I am getting an error that "sybasedbserver is not found". So the driver class does appear to be correct. Verify the jar is really loaded into qie:

 

answered Jun 29, 2022 by brandon-w-8204 (33,170 points)
selected Jun 29, 2022 by lewis-s-9714
commented Jun 29, 2022 by lewis-s-9714 (1,020 points)
I do see that jar listed in the Manage External Libraries. I think I know where I went wrong... I hit "Update" and it asked to restart, however I wasn't ready for the service to restart so I clicked no and expected it take effect after the service automatically reboots each night. Sounds like I need to explicitly tell it to restart to update, yeah?
commented Jun 29, 2022 by brandon-w-8204 (33,170 points)
the service does not restart by default at night. DO you have a process that restarts it. If not then that has not been loaded.
commented Jun 29, 2022 by lewis-s-9714 (1,020 points)
That's my understanding, but maybe I have that wrong. I'll manually restart during off hours and see if that does the trick. Thanks!
commented Jun 29, 2022 by lewis-s-9714 (1,020 points)
Restarting manually did the trick. Thanks!
...