• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle Vs Access ! updateString isnt working

 
ram kumar
Ranch Hand
Posts: 146
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 !
 
Campbell Ritchie
Sheriff
Posts: 48374
56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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?
 
ram kumar
Ranch Hand
Posts: 146
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Posts: 146
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic