Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Cannot Insert Colum Into Resultset Oracle

 
knock knock
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Friends,
Any help regarding this would be welcomed.
Please Help me.I am new to J2EE Programming.Our web project which we deploy on Tomcat 5.0.28 works perfectly fine when connected to Sybase ASA Database we have a new client requirement for which we have to connect it using Oracle 9i as the database.For doing the same i installed Oracle 9i(i have also tried with 8i)on my system copied the JDBC driver to the correct directory in Tomcat it got connected and is retriving data from the database perfectly.But when we try to insert a colum in the datbase using a result set it fails .The ResultSet rs is created properly(No Exception Thrown there) then the statement rs.moveToInsertRow(); also goes ahed without a problem but after taking the values when rs.insertRow(); is executed it throws an exception i.e. ORA-01732: data manipulation operation not legal on this view which I think is an exception from the oracle side whereas we are not manipulating any views we are inserting directly into the database tables. I would like to mention that to connect to oracle we are using the classes12.jar driver and the path for the same in the code is oracle.jdbc.driver.OracleDriver i have also tried it with the thin driver but same error reported.

[edited to remove "urgent" from subject]
[ July 22, 2005: Message edited by: Jeanne Boyarsky ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"knock knock",
We're pleased to have you here with us in the JDBC forum, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Note that questions from users with invalid display names are less likely to get answered.

Thanks,
Jeanne
Forum Bartender
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic