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 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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 36453
    
  15
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
 
Similar Threads
SQL Exception Connection is busy with results for another hstmt.
Basic Questions...Please help
javax.naming.NameNotFoundException:Name comp is not bound in this Context
Statement.getGeneratedKeys() with Sybase not working
Problem with the "where" query.