aspose file tools*
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 Spring in Action this week in the Spring 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: 39393
    
  28
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle Vs Access ! updateString isnt working