9 replies to this topic

[rob_programmer]

i have a hard time in using insert query for database ibm db2 using java can u pls help me guys on how to use it using step by step process

[vachovsky]

What is query contain?

[rob_programmer]

import java.sql.*;

public class ConnectionSample
{
public static void main(String[] args)
{
// CONNECTION OF DATABASE ACCESS/IBM
try{
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");


String url = "jdbc:db2:sample";
String uname = "", psswrd = "";

Connection conn = DriverManager.getConnection(url, uname, psswrd);

Statement s = conn.createStatement();

//QUERY SIDE

s.executeQuery("SELECT FIRSTNME ,LASTNAME,MIDINIT FROM EMPLOYEE ");


ResultSet rset = s.getResultSet();

s.executeUpdate("INSERT INTO EMPLOYEE (FIRSTNME,LASTNAME,MIDINIT )VALUES('ROB','SEMB','R')");



System.out.print("FIRSTNAME: \t" );
System.out.print("LASTNAME: \t" );
System.out.println("MIDINIT: \t");






// EXECUTE
while(rset.next())
{

System.out.print(rset.getString(1) + " \t" );
System.out.print(rset.getString(2) + " \t" );
System.out.println(rset.getString(3)+ " ");

}

}
catch(ClassNotFoundException exp){

System.err.println(exp);
}
catch(SQLException exp)
{
System.err.println(exp);
}
}
}

//s.executeUpdate("INSERT INTO EMPLOYEE (FIRSTNME,LASTNAME,MIDINIT )VALUES('ROB','SEMB','R')");
this one ..cause it won't save in the database

[wim DC]

Try to close the connection in the end after a commit.

conn.commit();

conn.close();

Maybe it doesn't commit properly and rollbacks if the program ends without having closed the connection.

[WingedPanther]

Why are you getting a result set, and THEN executing the insert (obliterating the result set you just got)?

[wim DC]

He puts the result of the select statement in a ResultSet. So if the statement changes that resultset object should stay the same... unless it's by reference behind the scenes, which i doubt.

[rob_programmer]

what would be the right code,guys..

[wim DC]

add

conn.commit();
conn.close();

as final 2 lines.

[rob_programmer]

oxano said:

add

conn.commit();
conn.close();

as final 2 lines.

where do i put this?

[discomonk]

According to java doc:

public interface Statement
The object used for executing a static SQL statement and returning the results it produces.

By default, only one ResultSet object per Statement object can be open at the same time. Therefore, if the reading of one ResultSet object is interleaved with the reading of another, each must have been generated by different Statement objects. All execution methods in the Statement interface implicitly close a statment's current ResultSet object if an open one exists.

I suspect your resultset is open and holding up resources that prevents the statement from issuing insert. Try to use 2 statements, one for insert and one for select.