Hello 
I had created a table with JDataStore (JBuilder4 Pro),I can insert and read data using SQL query.
But i have trouble when inserting the same data many times, i have noted that inserting <20 times i have no trouble, but >20 my prog stop brutally!!! without intercepting my exception (in my exemple print in console "Oups..."
I suppose i had omited something? !!!
thaks for all
NB : i am using RedHat6.2+JBuilder4 pro
my test program :--------------------
import java.sql.*;
import java.math.*;
public class test {
public test() {
}
public static void main(String[] args) {
test test1 = new test();
String resultat=null;
Statement Requete = null;
ResultSet ResultatSet = null;
try{
Class.forName("com.borland.datastore.jdbc.DataStoreDriver"
Connection Contact = DriverManager.getConnection("jdbc:borland:dslocal:/root/essai/BD/projet/projet.jds","kerbachi","kerbachi"
System.out.println("Contact with JDataSore OK!"
Requete = Contact.createStatement();
}catch(SQLException e){
System.out.println(e.getMessage() );}
catch(ClassNotFoundException e){);}
try{
/*
HERE IS THE PROBLEM
*/
for (int c=0; c<27;c++){
String valeur = "'AKB','002','012525','FF','DAAADEVE','013636','DDDDDDDD','COUCOU'";
Requete.executeUpdate("INSERT INTO \"MESSAGES_RSFTA\" values ("+valeur+""
System.out.println("INSERT INTO \"MESSAGES_RSFTA\" values ("+valeur+""
}
Requete.close();
}catch(SQLException e){
System.out.println("Oups..."}
System.exit(0);
}
}
I had created a table with JDataStore (JBuilder4 Pro),I can insert and read data using SQL query.
But i have trouble when inserting the same data many times, i have noted that inserting <20 times i have no trouble, but >20 my prog stop brutally!!! without intercepting my exception (in my exemple print in console "Oups..."
I suppose i had omited something? !!!
thaks for all
NB : i am using RedHat6.2+JBuilder4 pro
my test program :--------------------
import java.sql.*;
import java.math.*;
public class test {
public test() {
}
public static void main(String[] args) {
test test1 = new test();
String resultat=null;
Statement Requete = null;
ResultSet ResultatSet = null;
try{
Class.forName("com.borland.datastore.jdbc.DataStoreDriver"
;Connection Contact = DriverManager.getConnection("jdbc:borland:dslocal:/root/essai/BD/projet/projet.jds","kerbachi","kerbachi"
;System.out.println("Contact with JDataSore OK!"
;Requete = Contact.createStatement();
}catch(SQLException e){
System.out.println(e.getMessage() );}
catch(ClassNotFoundException e){);}
try{
/*
HERE IS THE PROBLEM
*/
for (int c=0; c<27;c++){
String valeur = "'AKB','002','012525','FF','DAAADEVE','013636','DDDDDDDD','COUCOU'";
Requete.executeUpdate("INSERT INTO \"MESSAGES_RSFTA\" values ("+valeur+"
;"System.out.println("INSERT INTO \"MESSAGES_RSFTA\" values ("+valeur+"
;"}
Requete.close();
}catch(SQLException e){
System.out.println("Oups..."
;}System.exit(0);
}
}