File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Problem updating long records Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem updating long records" Watch "Problem updating long records" New topic

Problem updating long records

Carey Brown
Ranch Hand

Joined: Nov 19, 2001
Posts: 170

I'm using a jdbc/odbc bridge to MS Access. I'm having trouble updating all the fields of a record at one time. Some of the fields are 254 chars long.
1) is there a length limit to updates? What is it?
2) is there a suggested work around?
Carey Brown
Ranch Hand

Joined: Nov 19, 2001
Posts: 170

I'm still looking for info on limits. Cany anyone help?
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

is it throwing a SQLException? what was the error message? If there is no error message, explain what is happening or post the code that is creating the problem.
I wouldn't be surprised if this was a limitation of the bridge, but I've not heard specifically of this problem yet.
I agree. Here's the link:
subject: Problem updating long records
Similar Threads
Interface implementation B&S
Identifying changed fileds
[B & S] Create and Delete Record
Reminder document for the exam
Another NullPointerException question