Solved

Insert/Update into MEMO datatype of MS-Access

Posted on 2001-09-09
2
630 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 100 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
allswap challenge 6 96
Configure a Bean in an XML file 4 31
JavaFX TableView not displaying correctly 3 16
How to convert from xls to xlsx using java 7 37
For customizing the look of your lightweight component and making it look lucid like it was made of glass. Or: how to make your component more Apple-ish ;) This tip assumes your component to be of rectangular shape and completely opaque. (COD…
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…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

786 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