File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes problem with updateXXX() methods Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem with updateXXX() methods" Watch "problem with updateXXX() methods" New topic
Author

problem with updateXXX() methods

Tim Hysniu
Greenhorn

Joined: Dec 01, 2003
Posts: 1
Hello group,
I just started working on this project --my first time with databases.
Im connecting to a database using this:
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc dbc:records");
stat = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
res = stat.executeQuery("Select * from records");
res.next();
} catch(Exception e) {
System.out.println("Error " + e);
}
Reading the everything using getXXX() methods works great. I'm having problems with writing to the database.
// column 1 in database is String
res.updateString(1, "Some string");
res.updateRow();
looks like updateString() and all updateXXX() are not doing anything.
updateRow() then, I believe, gives me an error msg:
"[Microsoft][ODBC Microsoft Access Driver]Error in row"
what am I doing wrong here? Error in row???
All I want is read and write on each row from a single table. No complexity is needed in my program. Can tell me what does this error mean and how do I fix it?
Thanks Very much,
Tim
P.S. This Looks like a great site. I hope people check this frequently though because my assignment is due this friday
Anurag Gupta
Ranch Hand

Joined: Dec 13, 2001
Posts: 40
The JDBC Specs may or may not be FULLY implemented by all the Database driver vendors - hence the issue.
It would be better to stick to the standard/basic functions to avoid such PitFalls.
I would use 2 Queries :
One to select the Records. Other to update the Record.
The question may arise on the Application Performance. But If your Database is designed correctly, there would not be much performance impact. Its a trade off between Vendor Independent Code and Performance.


Anurag Gupta
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: problem with updateXXX() methods
 
Similar Threads
cast a date from an access date/time field
Exception while inserting a row with resultSet.insertRow()
Handling Instances in my Servlet...
Problem connecting to Access database. Help needed..
insert to database...