Solved

Insert/Update into MEMO datatype of MS-Access

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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
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 practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now