Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Insert/Update into MEMO datatype of MS-Access

Posted on 2001-09-09
2
Medium Priority
?
636 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

730 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