Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem with Java/Sybase Connectvity

0 views
Skip to first unread message

brunofpimenta

unread,
Jul 18, 2008, 9:44:11 AM7/18/08
to
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,

Keith

unread,
Jul 19, 2008, 11:33:24 AM7/19/08
to


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

0 new messages