This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Oracle Vs Access ! updateString isnt working 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 "Oracle Vs Access ! updateString isnt working" Watch "Oracle Vs Access ! updateString isnt working" New topic
Author

Oracle Vs Access ! updateString isnt working

ram kumar
Ranch Hand

Joined: May 22, 2008
Posts: 146
Am using the same code for oracle and access.

while, oracle is working fine and access is not working

Whats the problem?

objResultSet1.updateString("ROW_STATUS","Y");

objResultSet1.updateRow();


Do these methods work for access.

Its not updating the table rather it shows an exception :

it fails to execute

objResultSet1.updateString("ROW_STATUS","Y");

what i am doing is just i will read all the columns from that row and update the last column as set rowstatus = 'y';




code here :

Please help me out !


Discussion - the powerfull way to excellence!
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38045
    
  22
What's Access? It has restricted functionality compared to Oracle. But we usually discuss database-associated questions on a different forum, so I shall try moving this topic.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


while, oracle is working fine and access is not working

Whats the problem?

Probably Access

My guess is your Access driver (or Access itself) doesn't support updatable ResultsSets. Which driver are you using?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
ram kumar
Ranch Hand

Joined: May 22, 2008
Posts: 146
Originally posted by Paul Sturrock:

Probably Access

My guess is your Access driver (or Access itself) doesn't support updatable ResultsSets. Which driver are you using?


Hey, Both of you campbell / Sturrock thanks for the response.

Yes ! Campbell its Microsoft Access DB.

As per the forum norms you may move this topic to jdbc !


Am speaking about MS-Access, Am using the default driver for ms access found in the odbc in the control panel :

Please suggest me some valid point for that code whih is not working with ms-access !

Provide me a better way of implementing that functionality in ms-access !

else

i would just explain my boss that this isn't possible for this reason !
[ September 10, 2008: Message edited by: ram kumar ]
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


Please suggest me some valid point for that code whih is not working with ms-access !

Access isn't a very good bit of software? The only (free) way to connect to Access from Java is via the JDBC-ODBC bridge and, as the documentation states, this isn't production quality code.


But before I get carried away criticising Access, what is the Exception message you see?
ram kumar
Ranch Hand

Joined: May 22, 2008
Posts: 146
Originally posted by Paul Sturrock:

Access isn't a very good bit of software? The only (free) way to connect to Access from Java is via the JDBC-ODBC bridge and, as the documentation states, this isn't production quality code.


But before I get carried away criticising Access, what is the Exception message you see?


java.sql.SQLException : Too few Parameters : Expected 1


[ September 10, 2008: Message edited by: ram kumar ]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Oracle Vs Access ! updateString isnt working
 
Similar Threads
Statement.getGeneratedKeys() with Sybase not working
Basic Questions...Please help
SQL Exception Connection is busy with results for another hstmt.
Problem with the "where" query.
javax.naming.NameNotFoundException:Name comp is not bound in this Context