Problem with Java/Sybase Connectvity

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brunofpimenta - 18 Jul 2008 14:44 GMT

Hi,

I have a problem to connect to Sybase with Java. The Java's DataSource
identify the schemas, but don't identify the tables.

Anyone had this problem or knows how to solve it?

Cheers,

Reply to this Message

Keith - 19 Jul 2008 16:33 GMT

> Hi,
>
[quoted text clipped - 4 lines]
>
> Cheers,

By Sybase I assume that you mean ASE? If you're hosting on Unix /
Linux, you can cd $SYBASE and find:

bash-2.05$ find . -name sql_server\* -ls
7749634 236 -r--r--r-- 1 sybase sybase 234984 Oct 10 2001 ./
jConnect-4_5/sp/sql_server.sql
7749636 240 -r--r--r-- 1 sybase sybase 241266 Oct 10 2001 ./
jConnect-4_5/sp/sql_server12.5.sql
7749637 240 -r--r--r-- 1 sybase sybase 240000 Oct 10 2001 ./
jConnect-4_5/sp/sql_server12.sql
8175618 256 -rwxr-xr-x 1 sybase sybase 257686 Mar 5 2005 ./
jConnect-5_5/sp/sql_server.sql
8175620 268 -rwxr-xr-x 1 sybase sybase 266739 Mar 5 2005 ./
jConnect-5_5/sp/sql_server12.5.sql
8175621 264 -rwxr-xr-x 1 sybase sybase 262864 Mar 5 2005 ./
jConnect-5_5/sp/sql_server12.sql
3850245 256 -rwxr-xr-x 1 sybase sybase 257686 Feb 27 2004 ./
jConnect-6_0/sp/sql_server.sql
3850246 264 -rwxr-xr-x 1 sybase sybase 262864 Feb 27 2004 ./
jConnect-6_0/sp/sql_server12.sql
3850247 268 -rwxr-xr-x 1 sybase sybase 266739 Feb 27 2004 ./
jConnect-6_0/sp/sql_server12.5.sql

Run the one right for your environment. Also, pick a version
(JConnect4, 5...) and stick with it; the PATHs
change between the two and the .JAR's are therefore not compatible
without a bit of trickery.

Good luck.

Keith

Reply to this Message