Help regarding insertion in the database

[Aditya Vasudeva]

I am using DB2 as my database manager.

The problem I am facing is that I cannot insert data into multiple tables at the same time. The code is given below:

    
 
Connection conn = null;
Statement stmt=null;


try 
{
//Register driver.
InitialContext ctx = new InitialContext();
                DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/MyDataSource");
                conn = ds.getConnection();

conn.setAutoCommit(false);

String cType=ct;
String cDate=c+"/"+a+"/"+b;
String cTime=d+":"+e+":00";
String cAddress=g+" "+h;
String cArea=f;
String cctvCoverage=i;
String cctvCaptured=j;
String cctvLocation="N"; //CHANGE!!
String stillHappening=l;
String cInjury="N"; //CHANGE!!
String cIPlocation="192.168.168.45";
String cOtherDetails=ot;

String st="INSERT INTO DB2.CRIMEDETAILS (CRIMETYPE, CRIMEDATE, CRIMETIME, CRIMEADDRESS, CRIMEAREA, CCTVCOVERAGE, CCTVCAPTURED, CCTVLOCATION, STILLHAPPENING, INJURY, IPLOCATION, OTHERDETAILS) VALUES ('"+cType+"','"+cDate+"','"+cTime+"','"+cAddress+"','"+ cArea+"','"+cctvCoverage+"','"+cctvCaptured+"','"+cctvLocation+"','"+stillHappening+"','"+cInjury+"','"+cIPlocation+"','"+cOtherDetails+"')";
stmt=conn.createStatement();
stmt.executeUpdate(st);



String ifwitness="a";
String conName="aa";
String conSurname="a";
String conGender="a";
String conDob="10/11/2007";
String conAddr="a";
String conArea="aa";
String conContact="a";
String conEmail="123";

String s1="INSERT INTO DB2.COMPLAINANTDETAILS (IFWITNESSED, FIRSTNAME, LASTNAME, GENDER, DATEOFBIRTH, ADDRESS, AREA, CONTACTNO, EMAIL) VALUES ('"+ifwitness+"','"+conName+"','"+conSurname+"','"+conGender+"','"+conDob+"','"+conAddr+"','"+conArea+"','"+conContact+"','"+conEmail+"')";
stmt=conn.createStatement();
stmt.executeUpdate(s1);
conn.commit();
 
} 
catch(Exception se) 
{

se.printStackTrace();
}  
finally 
{
try 
{
if(conn!=null)
conn.close();
} 
catch(SQLException se) 
{
se.printStackTrace();
}
}

 

 

The data gets inserted into the first table but doesnt get inserted into the 2nd one. It throws an SQLException saying that there is NULL value.

Please help...!!
Waiting for a reply......

[Campbell Ritchie]

You ought to believe the Exception; you are obviously passing null to a NOT NULL column.

[Aditya Vasudeva]

the problem is that i have tried inserting data into both the tables seperately. The insertion works fine when inserting into each table seperately!!

It doesnt work when inserting into both tables one after the other.

What do i do now???

Please help !!

[Campbell Ritchie]

Are you passing the data in the correct format? If there is any checking for formats (with CHECK CONSTRAINTs or similar) that might convert the data to null.
You appear to have a severely denormalised table, with columns like e-mail which don't depend directly on the primary key. Don't know whether that affects it.

Have you tried passing that String from the command line?

Sorry, can't think of any more suggestions.