Originally posted by Paul Sturrock:
Can we see your code?
sure...
my code is some what like
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@10.77.222.118:1521:StratosHearTest","sh_user","sh_user");
String query="insert into SH_Call_Logs (CALLERNUMBER,CALLEDNUMBER,ADCODESEXPOSED,DURATION,TIMEOFDAY,DTMF)values (?,?,?,?,to_date(?,'yyyy/mm/dd:hh:mi:ss am'),?)";
perstmtAnalytics=con.prepareStatement(query);
perstmtAnalytics.setInt(1,123445);
perstmtAnalytics.setInt(2,123445);
perstmtAnalytics.setInt(3,2);
perstmtAnalytics.setInt(4,10);
perstmtAnalytics.setString(5,"2007/08/12");
perstmtAnalytics.setInt(6,0);
perstmtAnalytics.addBatch();
perstmtAnalytics.setInt(1,2234456);
perstmtAnalytics.setInt(2,2234456);
perstmtAnalytics.setInt(3,3);
perstmtAnalytics.setInt(4,10);
perstmtAnalytics.setString(5,"2007/08/13");
perstmtAnalytics.setInt(6,0);
perstmtAnalytics.addBatch();
perstmtAnalytics.setInt(1,323447);
perstmtAnalytics.setInt(2,323447);
perstmtAnalytics.setInt(3,4);
perstmtAnalytics.setInt(4,10);
perstmtAnalytics.setString(5,"2007/08d/14"); // i put error condition with date manually
perstmtAnalytics.setInt(6,0);
perstmtAnalytics.addBatch();
int rows[]=perstmtAnalytics.executeBatch();
[ September 10, 2007: Message edited by: pravin karne ]