ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher.Mathru...@sybase.com
Subject RE: Sybase *BLOB and iBatis
Date Mon, 23 Apr 2007 16:36:28 GMT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o = "urn:schemas-microsoft-com:office:office"><HEAD>
<META urn:content-classes:message Content-class: 
boundary="----_=_NextPart_001_01C785C4.68EC5CD9" alternative; multipart 
Content-Type:>
<META http-equiv=Content-Type content="text/html; charset=koi8-r" Content-Type: 
------_="_NextPart_001_01C785C4.68EC5CD9" html; text quoted-printable 
Content-Transfer-Encoding:>
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN 
class=262033416-23042007>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&nbsp;IMAGE data type when it comes to persisting 
XML.&nbsp;</SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> "Steven G. Sajous" 
&lt;SSajous@actionet.com&gt; [mailto:"Steven G. Sajous" 
&lt;SSajous@actionet.com&gt;] <BR><B>Sent:</B> Monday, April 23,
2007 9:28 
AM<BR><B>To:</B> &lt;Christopher.Mathrusse@sybase.com&gt;<BR><B>Subject:</B>
RE: 
Sybase *BLOB and iBatis<BR></FONT><BR></DIV>
<DIV></DIV>
<META>
<META content="MSHTML 6.00.5730.11" name=GENERATOR>
<DIV id=idOWAReplyText15423 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>My field type was text, I 
changed it to image, and apparently that is supposed to work. Thanks a lot for 
your help.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2></FONT>&nbsp;</DIV></DIV>
<DIV id=idSignature14236 dir=ltr><FONT face=Arial color=#000000 size=2>
<DIV class=MsoNormal 
style="MARGIN: 0pt; LINE-HEIGHT: 12pt; mso-layout-grid-align: none"><B><SPAN 
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Verdana">Steven 
Sajous<o:p></o:p></SPAN></B></DIV>
<DIV class=MsoNormal 
style="MARGIN: 0pt; LINE-HEIGHT: 12pt; mso-layout-grid-align: none"><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">Project 
Manager<o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal 
style="MARGIN: 0pt; LINE-HEIGHT: 12pt; mso-layout-grid-align: none"><B><I><SPAN

style="FONT-SIZE: 9pt; COLOR: #c20000; FONT-FAMILY: Verdana">ActioNet, 
Inc</SPAN></I></B><I><SPAN 
style="FONT-SIZE: 9pt; COLOR: #c20000; FONT-FAMILY: Verdana">.<o:p></o:p></SPAN></I></DIV>
<DIV class=MsoNormal 
style="MARGIN: 0pt; LINE-HEIGHT: 12pt; mso-layout-grid-align: none"><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">2750 Prosperity 
Avenue, Suite 520<o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal 
style="MARGIN: 0pt; LINE-HEIGHT: 12pt; mso-layout-grid-align: none"><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">Fairfax, VA 
22031<o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal 
style="MARGIN: 0pt; LINE-HEIGHT: 12pt; mso-layout-grid-align: none"><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">Phone: 
202.475.8696<o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal 
style="MARGIN: 0pt; LINE-HEIGHT: 12pt; mso-layout-grid-align: none"><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">Fax: 
703.204.4782<o:p></o:p></SPAN></DIV>
<DIV class=MsoNormal 
style="MARGIN: 0pt; LINE-HEIGHT: 12pt; mso-layout-grid-align: none"><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">Email: 
</SPAN><U><SPAN 
style="FONT-SIZE: 8pt; COLOR: blue; FONT-FAMILY: Verdana">ssajous@actionet.com</SPAN></U><SPAN

style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana"><o:p></o:p></SPAN></DIV>
<DIV><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Times
New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language:
EN-US; mso-bidi-language: AR-SA">Web:</SPAN><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family:
'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language:
AR-SA"> 
</SPAN><U><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Times
New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language:
EN-US; mso-bidi-language: AR-SA"><A 
href="http://www.actionet.com/">www.actionet.com</A></SPAN></U></DIV>
<DIV><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Times
New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language:
EN-US; mso-bidi-language: AR-SA"><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: black; FONT-FAMILY: Verdana">_____________________________________________________________________</SPAN><FONT

color=navy><SPAN style="COLOR: navy"></SPAN></FONT> 
<DIV class=MsoNormal><U><FONT face=Arial color=#cc0000 size=1><SPAN 
style="FONT-SIZE: 8pt; COLOR: #cc0000; FONT-FAMILY: Arial">■</SPAN></FONT><FONT

face=Verdana color=navy size=1><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana">CMMI&reg; SE/SW Level 
3</SPAN></FONT><FONT face=Arial color=#cc0000 size=1><SPAN 
style="FONT-SIZE: 8pt; COLOR: #cc0000; FONT-FAMILY: Arial">■</SPAN></FONT><FONT

face=Verdana color=black size=1><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: black; FONT-FAMILY: Verdana">ISO 
9001:2000</SPAN></FONT><FONT face=Arial color=#cc0000 size=1><SPAN 
style="FONT-SIZE: 8pt; COLOR: #cc0000; FONT-FAMILY: Arial">■</SPAN></FONT><FONT

face=Verdana color=black size=1><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: black; FONT-FAMILY: Verdana">8(a)</SPAN></FONT><FONT

face=Arial color=#cc0000 size=1><SPAN 
style="FONT-SIZE: 8pt; COLOR: #cc0000; FONT-FAMILY: Arial">■</SPAN></FONT><FONT

face=Verdana color=black size=1><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: black; FONT-FAMILY: Verdana">Woman-Owned 
Business</SPAN></FONT><FONT face=Arial color=#cc0000 size=1><SPAN 
style="FONT-SIZE: 8pt; COLOR: #cc0000; FONT-FAMILY: Arial">■</SPAN></FONT></U></DIV></SPAN></FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Christopher.Mathrusse@sybase.com 
[mailto:Christopher.Mathrusse@sybase.com]<BR><B>Sent:</B> Mon 4/23/2007
11:29 
AM<BR><B>To:</B> Steven G. Sajous; 
user-java@ibatis.apache.org<BR><B>Subject:</B> RE: Sybase *BLOB and 
iBatis<BR></FONT><BR></DIV>
<DIV>
<DIV dir=ltr align=left><SPAN class=002374514-23042007><FONT face=Arial 
color=#0000ff size=2>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&nbsp;you 
are attempting, I believe.&nbsp;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?</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> "Steven G. Sajous" 
&lt;SSajous@actionet.com&gt; [mailto:"Steven G. Sajous" 
&lt;SSajous@actionet.com&gt;] <BR><B>Sent:</B> Monday, April 23,
2007 6:24 
AM<BR><B>To:</B> &lt;user-java@ibatis.apache.org&gt;<BR><B>Subject:</B>
Sybase 
*BLOB and iBatis<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV id=idOWAReplyText64599 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>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.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT>&nbsp;</DIV>
<DIV dir=ltr><FONT face=Arial size=2>Anyone know where I can get some help on

this?</FONT></DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2></FONT>&nbsp;</DIV></DIV>
<DIV id=idSignature60278 dir=ltr><FONT face=Arial color=#000000 size=2>
<DIV class=MsoNormal style="MARGIN: 0pt; LINE-HEIGHT: 12pt"><B><SPAN 
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Verdana">Steven 
Sajous</SPAN></B></DIV>
<DIV class=MsoNormal style="MARGIN: 0pt; LINE-HEIGHT: 12pt"><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">Project 
Manager</SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0pt; LINE-HEIGHT: 12pt"><B><I><SPAN

style="FONT-SIZE: 9pt; COLOR: #c20000; FONT-FAMILY: Verdana">ActioNet, 
Inc</SPAN></I></B><I><SPAN 
style="FONT-SIZE: 9pt; COLOR: #c20000; FONT-FAMILY: Verdana">.</SPAN></I></DIV>
<DIV class=MsoNormal style="MARGIN: 0pt; LINE-HEIGHT: 12pt"><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">2750 Prosperity 
Avenue, Suite 520</SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0pt; LINE-HEIGHT: 12pt"><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">Fairfax, VA 
22031</SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0pt; LINE-HEIGHT: 12pt"><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">Phone: 
202.475.8696</SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0pt; LINE-HEIGHT: 12pt"><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">Fax: 
703.204.4782</SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0pt; LINE-HEIGHT: 12pt"><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">Email: 
</SPAN><U><SPAN 
style="FONT-SIZE: 8pt; COLOR: blue; FONT-FAMILY: Verdana">ssajous@actionet.com</SPAN></U><SPAN

style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana"></SPAN></DIV>
<DIV><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana">Web:</SPAN><SPAN 
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: 'Times New Roman'"> 
</SPAN><U><SPAN style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana"><A

href="http://www.actionet.com/">www.actionet.com</A></SPAN></U></DIV>
<DIV><SPAN style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana"><SPAN

style="FONT-SIZE: 7.5pt; COLOR: black; FONT-FAMILY: Verdana">_____________________________________________________________________</SPAN><FONT

color=navy><SPAN style="COLOR: navy"></SPAN></FONT> 
<DIV class=MsoNormal><U><FONT face=Arial color=#cc0000 size=1><SPAN 
style="FONT-SIZE: 8pt; COLOR: #cc0000; FONT-FAMILY: Arial">■</SPAN></FONT><FONT

face=Verdana color=navy size=1><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana">CMMI&reg; SE/SW Level 
3</SPAN></FONT><FONT face=Arial color=#cc0000 size=1><SPAN 
style="FONT-SIZE: 8pt; COLOR: #cc0000; FONT-FAMILY: Arial">■</SPAN></FONT><FONT

face=Verdana color=black size=1><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: black; FONT-FAMILY: Verdana">ISO 
9001:2000</SPAN></FONT><FONT face=Arial color=#cc0000 size=1><SPAN 
style="FONT-SIZE: 8pt; COLOR: #cc0000; FONT-FAMILY: Arial">■</SPAN></FONT><FONT

face=Verdana color=black size=1><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: black; FONT-FAMILY: Verdana">8(a)</SPAN></FONT><FONT

face=Arial color=#cc0000 size=1><SPAN 
style="FONT-SIZE: 8pt; COLOR: #cc0000; FONT-FAMILY: Arial">■</SPAN></FONT><FONT

face=Verdana color=black size=1><SPAN 
style="FONT-SIZE: 7.5pt; COLOR: black; FONT-FAMILY: Verdana">Woman-Owned 
Business</SPAN></FONT><FONT face=Arial color=#cc0000 size=1><SPAN 
style="FONT-SIZE: 8pt; COLOR: #cc0000; FONT-FAMILY: Arial">■</SPAN></FONT></U></DIV></SPAN></FONT></DIV></DIV></DIV></BODY></HTML>


Mime
View raw message