memo data type in ms access

[xue shen]

I have used the memo type in access to store a large string text thinking that memo data type does not have a character size limit(correct me if I am wrong). I do not have access to a help file at the moment. When I am trying to access the memo data from by using jdbc, resultset.getString(index), it does not work. What data type is memo corresponds to in Java, Do I need to use a characterStream, a Ascii stream, a binary stream to access it?
Do you guys have any suggestions on this?
Thanks
XS

[Asanka Nanayakkara]

Hi
did you try "resultset.getBlob(index)" ?
Asanka

[Jamie Robertson]

this is working code to update a memo field in MSAccess. Try reversing to read the data in. I'll try to find a link to the code you need.

PreparedStatement ps = con.prepareStatement( "Update table set memo_field = ? WHERE ..." )
String longString = "super duper long big...a couple thousand more characters...huge String"; 
int size = longString.length();
BufferedInputStream bais = new BufferedInputStream( new ByteArrayInputStream( longString.getBytes() ) );
ps.setAsciiStream( 1, bais, size );
ps.executeUpdate();

hope it works for you,
Jamie
[ August 14, 2002: Message edited by: Jamie Robertson ]

[Jamie Robertson]

found it! Lots of streaming examples here. It's on the oracle site so you might have to register.
Jamie
[ August 14, 2002: Message edited by: Jamie Robertson ]

[xue shen]

Jamie and Asanka;
Thanks very much for your suggestion. I will reply to you guys about the outcome.
X.S.