Solved

Insert/Update into MEMO datatype of MS-Access

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:

820 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