Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Insert/Update into MEMO datatype of MS-Access

Posted on 2001-09-09
2
Medium Priority
?
638 Views
Last Modified: 2008-03-06
Hi,..... :)

I am using MS-Access as my database with JBDC. I have a "MEMO" datatype for a field in a table. When I am insering/updating this field, which of the methods in the PreparedStatement class should I use? I tried setString(), but I get some truncation exception!!!

Seeking help!

Regards,
rajiv
0
Comment
Question by:rajivraj
2 Comments
 
LVL 6

Expert Comment

by:kotan
ID: 6469731
0
 

Accepted Solution

by:
ManojShetty earned 200 total points
ID: 6471018
It should work with setObject() method of PreparedStatement.

The MEMO datatype in MS-Access corresponds to LONGVARCHAR
in java.sql.Types (generic SQL type)
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
Suggested Courses
Course of the Month13 days, 13 hours left to enroll

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question