Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem updating long records

 
Carey Brown
Ranch Hand
Posts: 1538
18
Eclipse IDE Firefox Browser Java MySQL Database VI Editor Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1538
18
Eclipse IDE Firefox Browser Java MySQL Database VI Editor Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm still looking for info on limits. Cany anyone help?
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
Jamie
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic