This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: memo data type in ms access
 
It's not a secret anymore!