hi guys...
i am using an insert query which works fine when i run it on toad and shows one row inserted. But when i use the same query in my
java code using
jdbc,
the purpose fails and in the logs the error comes as "not enough values" that is a SQL exception.
I am not able to comprehend that a query that works fine on toad fails in jdbc.
The code which i use is as :
String insert_val2 = "insert into listing values (a huge array of values)";
DBPSaccess dbp2 = new DBPSaccess(insert_val2);
boolean y = dbp2.insert();
dbp2.close();
i have checked there is no problem in connection or statement object.
I need help quickly guys so please pour in your suggestions
Thanking in advance.