aspose file tools*
The moose likes JDBC and the fly likes memo data type in ms access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "memo data type in ms access" Watch "memo data type in ms access" New topic
Author

memo data type in ms access

xue shen
Greenhorn

Joined: Jul 05, 2002
Posts: 23
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
Greenhorn

Joined: Aug 13, 2002
Posts: 10
Hi
did you try "resultset.getBlob(index)" ?
Asanka
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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.
hope it works for you,
Jamie
[ August 14, 2002: Message edited by: Jamie Robertson ]
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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
Greenhorn

Joined: Jul 05, 2002
Posts: 23
Jamie and Asanka;
Thanks very much for your suggestion. I will reply to you guys about the outcome.
X.S.
 
 
subject: memo data type in ms access