Link to home
Start Free TrialLog in
Avatar of SubhaBabu
SubhaBabu

asked on

Sybase Image column gets truncated to 16K

We have  two environments Test and Development. Both running on same version of Sybase server  --Adaptive Server Enterprise/12.5.1/EBF 11559 ESD#1/P/Sun_svr4/OS 5.8/ase1251/1831/32-bit/FBO/Sat Nov 2--

We have a Table with one of the column defined as Image. We are storing pdf documents in that column. But for some reason , the pdf documents gets truncated to 16k in our Test environment whereas the same works on  Development.

Our project is a typical j2EE project. so we use hibernate from the java layer to handle all database operations. We are using jconn2.jar as the database driver.

Listes below are our findings.

1)  IF we use a different driver jar file , like the one that comes along with weblogic for Sybase, we could successfully insert the pdf document even in our test environment.




Thanks
ASKER CERTIFIED SOLUTION
Avatar of ChrisKing
ChrisKing

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SubhaBabu
SubhaBabu

ASKER

Nope i don't have any like that.  I am using  pure java driver (jconn2.jar) to talk to database from  my java tier.
you might have to post a cut down version of the code
SOLUTION
Avatar of Joe Woodhouse
Joe Woodhouse

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
(hi joe)