dbTalk Databases Forums  

jdbcs cuts string longer than 255 bytes

comp.databases.sybase comp.databases.sybase


Discuss jdbcs cuts string longer than 255 bytes in the comp.databases.sybase forum.



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

Default jdbcs cuts string longer than 255 bytes - 11-06-2003 , 04:28 AM






Hi all

I have Sybase 12.5 with jConnect4.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.

Does anybody know why?

Simon


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

Default Re: jdbcs cuts string longer than 255 bytes - 11-06-2003 , 04:52 AM






Hi all again

I mayby found a reason for that problem. It seems to be that I have
especially write that code:
SybDriver drv =
(SybDriver)Class.forName("com.sybase.jdbc2.jdbc.Sy bDriver").newInstance();
drv.setVersion(drv.VERSION_LATEST);
DriverManager.registerDriver(drv);

which is no jdbc standard.

Does Sybase provide's a patch for that problem, so that the jdbc
standard is supported?

Simon

Simon Bieri schrieb:

Quote:
Hi all

I have Sybase 12.5 with jConnect4.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.

Does anybody know why?

Simon

--
I believe the entire IQ of mankind is a constant
while the count of human being is constantly increasing.
(As you can see in the governments of the world)

-!Please only use the Reply-to address!-



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

Default Re: jdbcs cuts string longer than 255 bytes - 11-06-2003 , 09:32 AM



On Thu, 06 Nov 2003 11:28:34 +0100, Simon Bieri wrote:

Quote:
Hi all

I have Sybase 12.5 with jConnect4.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.
I'm pretty sure that you need jConnect 5.x to handle wide varchars, and
you may need to configure it (at run-time) to allow wide varchars. I'd go
check the jConnect 5.x documentation for details.

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.