dbTalk Databases Forums  

common jdbc and jConnect 4.5

comp.databases.sybase comp.databases.sybase


Discuss common jdbc and jConnect 4.5 in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Simon Bieri
 
Posts: n/a

Default common jdbc and jConnect 4.5 - 11-11-2003 , 03:40 AM






Hi all

I have Sybase 12.5 and JConnect 4.5


I have a table with a varchar column. When I insert data of more than
255 bytes with the JConnect4.5's jdbc driver there's no problem. If I
try to get the data of this column, the same jdbc driver cuts the data
after 255 bytes.

To fix that, I had to add the code:
SybDriver drv =
(SybDriver)Class.forName("com.sybase.jdbc2.jdbc.Sy bDriver").newInstance();
drv.setVersion(drv.VERSION_LATEST);
DriverManager.registerDriver(drv);

The problem is, I cannot add this, because my db connection is in a
framework which uses common, platform independend jdbc connection.

Is there a path from Sybase for jConnect 4.5 or do I have to upgrade to
jConnect 5 or higher?

Many thanks

Simon


Reply With Quote
  #2  
Old   
Michael Peppler
 
Posts: n/a

Default Re: common jdbc and jConnect 4.5 - 11-11-2003 , 09:51 AM






On Tue, 11 Nov 2003 10:40:36 +0100, Simon Bieri wrote:

Quote:
Hi all

I have Sybase 12.5 and JConnect 4.5


I have a table with a varchar column. When I insert data of more than 255
bytes with the JConnect4.5's jdbc driver there's no problem. If I try to
get the data of this column, the same jdbc driver cuts the data after 255
bytes.

Is there a path from Sybase for jConnect 4.5 or do I have to upgrade to
jConnect 5 or higher?
You need to upgrade.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html



Reply With Quote
  #3  
Old   
Simon Bieri
 
Posts: n/a

Default Re: common jdbc and jConnect 4.5 - 11-11-2003 , 11:11 AM




Michael Peppler schrieb:

Quote:
You need to upgrade.
To which version? 5.0 or 5.5 or ...?

Thanks
Simon



Reply With Quote
  #4  
Old   
Michael Peppler
 
Posts: n/a

Default Re: common jdbc and jConnect 4.5 - 11-11-2003 , 02:00 PM



On Tue, 11 Nov 2003 18:11:48 +0100, Simon Bieri wrote:

Quote:
Michael Peppler schrieb:

You need to upgrade.

To which version? 5.0 or 5.5 or ...?
I'm not sure, but I suspect that you'll need to go to 5.5. You should
probably check the docs - they should have more information on the issue.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.