aspose file tools*
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: 248

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?

Sent from my IBM 360 mainframe
Carey Brown
Ranch Hand

Joined: Nov 19, 2001
Posts: 248

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