Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT DBF
Unknown Source at insert
Oscar San Martin
2010-10-01 14:33:37.0
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.0
>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.0
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.0
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.0
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.0
>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.0
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.0
>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.0
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.0
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.0
Because server side doesn't use lockType=FOXPRO4UNIX, your index file corrupted:) Any new issue. Please let us know.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap