Hello,
I have a problem witch hxtt paradox. When I use your driver with my code which select all data from a paradox table, check the data and delete the actually record if the record has the right shipmnt number for the first time it works. When I start my code again the table is empty for my application. I also checked the table wir RazorSQL based on your driver. The table is also empy. When I check the table with classical BDE and Borland dbExplorer the table is full whith data. I don't know what to do.
I think it's my code which block or something like that the table for you driver: My code looks like this:
Class.forName("com.hxtt.sql.paradox.ParadoxDriver").newInstance();
String url = "jdbc:Paradox:////" + args[0];
Connection conPrime = DriverManager.getConnection(url,"","");
Connection conSecond = DriverManager.getConnection(url,"","");
Statement stmtPrime = conPrime.createStatement();
Statement stmtSecond = conSecond.createStatement();
ResultSet rs = stmtPrime.executeQuery("SELECT * FROM dbObjects");
while(rs.next()){
if(rs.getInt("ShipmntNo") < 9900){
//Do something with the data
//than delete this record
stmtSecond.executeUpdate("DELETE FROM dbObjects WHERE ShipmntNo = '" + rs.getInt("ShipmntNo") + "'");
}
}
rs.close();
stmtPrime.close();
stmtSecond.close();
conPrime.close();
conSecond.close();
I suggest the problem is at the part where I make a second connection and delete the current record. But why it works for the first time and the next times it doesn't work? When I restore my table from my buckup it works again for the first time.
Has anyone an idea?
|
|
Please send use your db sample so that we ca recur your issue.
|
|
And how, I can't attach any files here.
|
|
You can send email to webmaster or support @ hxtt.com .
|
Main
webmaster@hxtt.com