on updation of any data of any of the field it giving error like:
//error
Driver loaded
statement is created
java.sql.SQLException: General error
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6986)
...
|
Here is a problem I am facing:-
I am trying to run an update statement (preparedStatement) with multiple values but only if they are not null.
Example:
String x, y,z; //initialized to some value
final ...
|
I am using the statement.executeUpdate(String sql). The sql is a simple update statement such as UPDATE t_test set test_col='xx' where test_col='yy' The problem is there are trigger(s) on the above table. When I execute the above query in a SQL Query analyzer the output will look like : 0 row(s) affected 0 row(s) affected 0 row(s) affected 1 row(s) affected; Actually ... |
Hi, I am trying to do an update to an Oracle 9i table. Code looks like: Statement stmtUpdate = conn_data.createStatement(); try { int UpdateResult = stmtUpdate.executeUpdate(sqlUpdateProduct); if ( UpdateResult == 1) { When I execute the update it hangs. I can at a DB level that it is done processing but seems to hang upon finishing. I made sure AutoCommit is ... |
Hi all, I've run into a case in which I'm unsure how to write the SQL to accomplish what I need. Here's a quick breakdown of the tables in question: +--------------------+ | A | +--------------------+ | RecordNumber | | UniqueRecordID | +--------------------+ +--------------------+ | B | +--------------------+ | RecordNumber | +--------------------+ So, in table A, I have a number that goes ... |
Originally posted by Aaron Ting: Greetings rathi ji, Depending on how you are actually updating your database, is it through a java program or otherwise? Do state the mode of updating you are adopting in your project, and, what type of database you are using in order to let the ranchers advise you more accurately.. On the other hand, if you ... |
|
|
I am wondering how other people handle this situation. I have a jsp where I let a user edit a database record. Lets say there are 10 fields in my table. The data is stored in a JavaBean that corresponds to the table structure (getters and setters for each field). Lets say the user only wants to change one field. The ... |
|
|
|
|
|
|
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connection=DriverManager.getConnection("jdbc:odbc:TestOnlineOffline"); connection.setAutoCommit(false); statement=connection.createStatement(); rs=statement.executeQuery("select * from Test_data where Flag='p'"); while(rs.next()) { int id=rs.getInt(1); String asset=rs.getString(2); String name=rs.getString(3); String flag=rs.getString(4); System.out.println("id "+id+" name "+name); int val = statement.executeUpdate("INSERT into Sample VALUES("+id+",'"+asset+"'," +name+"','"+flag+"')"); int val1=statement.executeUpdate("Update Test_data set Flag='c' where id="+id); } } catch (Exception e) { e.printStackTrace(); } finally { try{ connection.commit();} catch(Exception e){e.printStackTrace();} } |
Dear Ranchers, I am developing a simple JDBC application simulating the four basic operations performed on a database. The insert,delete, and retrieve operations are working fine but for the update operation the executeUpdate() method is executed but no effects reflect on the database.The database on which the application is developed is MS-Access. Here is the code i am using : if(ae.getSource()==b6) ... |
I made this code which simply fetches the data and each row has a Edit link Besides it... When i click on Edit, the record appears perfectly, but when i make changes and click on save, it refreshes and shows null values in every Text Box. However, It makes changes to the Table. This is the Code For EDIT page # ... |
When I run the program, there seems to be a problem in the PreparedStatement s2=con.prepareStatement(query+" where "+condition); s2.execute(); part. Until then everything seems fine. The System.out.println(query+" where "+condition); prints just what I want it to print. Only, it doesn't seem to be getting executed. It just gets stuck and I get no error. I have to stop it manually outside the ... |
Java Code: public void setSettings(int gebruikersNr, String wachtwoord, boolean notRunning) { Connect(); System.out.println("700"); try { System.out.println("701"); PreparedStatement stmt = con.prepareStatement ( "UPDATE Werknemer " + "SET password = ?,nietLopend = ?" + "WHERE userID = ?" ); System.out.println("702"); int[] rows; for(int i = 0; i < 35;i++) { stmt.setString(1, wachtwoord); stmt.setBoolean(2, notRunning); stmt.setInt(3, gebruikersNr); stmt.addBatch(); } System.out.println("703"); rows = stmt.executeBatch(); } ... |