Unknown Source at insert |
Oscar San Martin |
2010-10-01 14:33:37 |
I can select and update DBF tables on SCO UNIX FoxPRo, but when I tried insert new record, I receive this message "at com.hxtt.sql.dbf.r.int(Unknown Source)" many times.....in DOS window when DBF_JDBC30 is running....
Thanks.
|
Re:Unknown Source at insert |
HXTT Support |
2010-10-01 18:35:37 |
>but when I tried insert new record, I receive this message "
>at com.hxtt.sql.dbf.r.int(Unknown Source)" many times.....
You can use
catch (SQLException sqle) {
do {
System.out.println(sqle.getMessage());
System.out.println("Error Code:" + sqle.getErrorCode());
System.out.println("SQL State:" + sqle.getSQLState());
sqle.printStackTrace();
}
while ( (sqle = sqle.getNextException()) != null);
}
to know what's your error?
>I can select and update DBF tables on SCO UNIX FoxPRo,
>....in DOS window when DBF_JDBC30 is running....
SCO Foxpro and DOS Foxpro use different lock mechanism. You need still to use lockType=FOXPRO4UNIX in your DOS window, if it access database files which belong to SCO.
|
Re:Re:Unknown Source at insert |
Oscar San Martin |
2010-10-01 22:22:24 |
When I run in cmd windows : "java -jar DBF_JDBC30.jar", and server's are started, error "at com.hxtt.sql.dbf.r.int(Unknown Source)" is show here.....not in my application..., in my application "insert into ...." line is hang.....
lockType property is set to FOXPRO4UNIX when client is connect to server....
|
Re:Re:Re:Unknown Source at insert |
HXTT Support |
2010-10-01 22:38:27 |
|
What's your jdbc url setting? What's the detailed error message of "at com.hxtt.sql.dbf.r.int(Unknown Source)"?
|
Re:Re:Re:Re:Unknown Source at insert |
Oscar San Martin |
2010-10-02 06:16:59 |
The url setting : jdbc:dbf://127.0.0.1:8029/d:/FoxDBF
The error full DOS window like :
at com.hxtt.sql.dbf.r.int(Unknown Source)
at com.hxtt.sql.dbf.r.int(Unknown Source)
at com.hxtt.sql.dbf.r.int(Unknown Source)
at com.hxtt.sql.dbf.r.int(Unknown Source)
at com.hxtt.sql.dbf.r.int(Unknown Source)
at com.hxtt.sql.dbf.r.int(Unknown Source)
at com.hxtt.sql.dbf.r.int(Unknown Source)
at com.hxtt.sql.dbf.r.int(Unknown Source)
......
......
......
and I can't see the first error......
Thanks.
|
Re:Re:Re:Re:Re:Unknown Source at insert |
HXTT Support |
2010-10-02 06:27:44 |
>The url setting : jdbc:dbf://127.0.0.1:8029/d:/FoxDBF
You should use jdbc:dbf://127.0.0.1:8029/d:/FoxDBF?lockType=FOXPRO4UNIX on both of server and client side.
>and I can't see the first error......
It seems to be an index error. You can try run once "reindex all on thattable". Suggest that you upgrade to the latest version.
|
Re:Re:Re:Re:Re:Re:Unknown Source at insert |
Oscar San Martin |
2010-10-02 06:44:07 |
I develop in windows environment.....so, when I put FOXPRO4UNIX property in server side and client side( my own machine ), client ( in same machine ) can't connect and return :
java.sql.SQLException: Failed to connect to remote database: java.sql.SQLException: Remote service for jdbc:dbf://127.0.0.1:8029/D:/FoxDBF hasn't been started. You should click Start Server button or use Auto Run parameter.
But if I define server side without FOXPRO4UNIX, client can connect...but at insert record, in server side return an fill DOS Windows where I run server : at com.hxtt.sql.dbf.r.int(Unknown Source) and can't see original or first returnes error....in log nathings appers about this error....
"Suggest that you upgrade to the latest version."... I like this idea, but our SCO Unix only support JRE 1.4.xx....
Thanks...
|
Re:Re:Re:Re:Re:Re:Re:Unknown Source at insert |
HXTT Support |
2010-10-02 06:51:38 |
>when I put FOXPRO4UNIX property in server side and client side( my own machine ),
>client ( in same machine ) can't connect and return :
You should revmove the old jdbc:dbf://127.0.0.1:8029/d:/FoxDBF service url on server side, than add jdbc:dbf://127.0.0.1:8029/d:/FoxDBF?lockType=FOXPRO4UNIX as new service url.
>I like this idea, but our SCO Unix only support JRE 1.4.xx....
The latest version provides DBF_JDBC30.jar which support JRE1.4.X also.
|
Re:Re:Re:Re:Re:Re:Re:Re:Unknown Source at insert |
Oscar San Martin |
2010-10-02 07:10:20 |
Last version downloaded...
I remove old url and add new url, in log server :
2010-10-02 10:05:06|server|stopped|1804241828|//127.0.0.1:8029/DBFTCPServer/D:/FOXDBF|jdbc:dbf://127.0.0.1:8029/d:/FoxDBF?lockType=FOXPRO4UNIX
In client connect I define this properties :
p.setProperty( "maxIdleTime", "1440" );
p.setProperty( "lockType ", "FOXPRO4UNIX" );
p.setProperty( "lockTimeout ", "90000" );
When client try to connect :
java.sql.SQLException: Failed to connect to remote database: java.sql.SQLException: Remote service for jdbc:dbf://127.0.0.1:8029/D:/FoxDBF hasn't been started. You should click Start Server button or use Auto Run parameter.
Thanks.
|
Re:Re:Re:Re:Re:Re:Re:Re:Unknown Source at insert |
Oscar San Martin |
2010-10-02 07:14:49 |
Problem solved.....thanks very much for your support !
Oscar
|
Re:Re:Re:Re:Re:Re:Re:Re:Unknown Source at insert |
HXTT Support |
2010-10-02 07:19:59 |
|
Because server side doesn't use lockType=FOXPRO4UNIX, your index file corrupted:) Any new issue. Please let us know.
|
Main
webmaster@hxtt.com