IMAGE will work and maps easily to byte[]. TEXT should
map easily to String. I've used both and they both work very well. I do however
prefer to use IMAGE data type when it comes to persisting
XML.
From: "Steven G. Sajous" <[EMAIL PROTECTED]> [mailto:"Steven G. Sajous" <[EMAIL PROTECTED]>]
Sent: Monday, April 23, 2007 9:28 AM
To: <[EMAIL PROTECTED]>
Subject: RE: Sybase *BLOB and iBatis
My field type was text, I
changed it to image, and apparently that is supposed to work. Thanks a lot for
your help.
Steven
Sajous
Project
Manager
ActioNet,
Inc.
2750 Prosperity
Avenue, Suite 520
Fairfax, VA
22031
Phone:
202.475.8696
Fax:
703.204.4782
Email:
[EMAIL PROTECTED]
_____________________________________________________________________
■CMMI® SE/SW Level
3■ISO
9001:2000■8(a)■Woman-Owned
Business■
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Mon 4/23/2007 11:29 AM
To: Steven G. Sajous; [email protected]
Subject: RE: Sybase *BLOB and iBatis
I'm using Sybase ASE and iBatis with an IMAGE field and I
have no problems. I'm assigning the data to a byte[] which is what I you
are attempting, I believe. Sybase does not have BLOB data type but does
have IMAGE and TEXT data types so you should be covered with what you are
attempting. Can you give us some code examples and exception messages pertaining
to your problem?
From: "Steven G. Sajous" <[EMAIL PROTECTED]> [mailto:"Steven G. Sajous" <[EMAIL PROTECTED]>]
Sent: Monday, April 23, 2007 6:24 AM
To: <[email protected]>
Subject: Sybase *BLOB and iBatis
Has the issue with Sybase
BLOBs and iBatis been resolved. I read a lot of postings about people asking for
help but I did not find any that indicates that it was fixed. I followed
examples from the documentation, I even got some code from someone at my office
on another team who is doing the same thing I am trying to do -- get a file
upload to work with iBatis -- but on Oracle, his works fine, mine does
not.
Anyone know where I can get some help on
this?
Steven
Sajous
Project
Manager
ActioNet,
Inc.
2750 Prosperity
Avenue, Suite 520
Fairfax, VA
22031
Phone:
202.475.8696
Fax:
703.204.4782
Email:
[EMAIL PROTECTED]
_____________________________________________________________________
■CMMI® SE/SW Level
3■ISO
9001:2000■8(a)■Woman-Owned
Business■
