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
Clipper dbf transaction
Santiago
2008-06-23 16:21:48.0
Hi, i am evaluating the hxttf driver.

I do

1) set the connection auto commit to false
2) insert into a dbf
3) do a roolbak in the connecion object

The row inserted in the step 2 is visible in the dbf. What is my mistake?

Regards
Santiago
Re:Clipper dbf transaction
HXTT Support
2008-06-23 17:21:13.0
>The row inserted in the step 2 is visible in the dbf. What is my mistake?
You are using Read uncommitted. You can set Isolation Level to Read committed.
Re:Re:Clipper dbf transaction
Santiago
2008-06-24 04:32:28.0
Hi, thanks for the answer.
I set the isolation level, but still i can see the record in the dbf file.
I can see that the problem is the line
Connection con = DriverManager.getConnectio("jdbc:dbf:/c:/tablas/tabla1",prop);

if i call the DriverManager in this way
Connection con = DriverManager.getConnectio("jdbc:dbf:/c:/tablas/tabla1");
everything works fine.




This is my code:

Properties prop=new Properties();
prop.setProperty( "lockType", "CLIPPER" );
prop.setProperty("versionNumber", "03");
prop.setProperty("Default Index Suffix","NTX");
Connection con = DriverManager.getConnection("jdbc:dbf:/c:/tablas/tabla1",prop);
con.setAutoCommit(false);
con.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
try {
Statement stmt = con.createStatement();
stmt.executeUpdate("insert into funcio00 (funcod,funapedos) values
('19123','atom1')");
throw new SQLException();

} catch (SQLException ex) {
con.rollback();
con.close();
ex.printStackTrace();
}
Re:Re:Re:Clipper dbf transaction
HXTT Support
2008-06-24 06:23:33.0
>prop.setProperty( "lockType", "CLIPPER" );
If you haven't Clipper applications do concurrent access, you can remove that line. Because on Xbase compatible mode, transaction will be disabled automatically.
Re:Re:Re:Re:Clipper dbf transaction
Santiago
2008-06-24 08:05:51.0
Ok, but i have clipper applications doing concurrent access...
Is possible use the transaction capabilities in this environment?
Re:Re:Re:Re:Re:Clipper dbf transaction
HXTT Support
2008-06-24 18:28:17.0
>Ok, but i have clipper applications doing concurrent access...
>Is possible use the transaction capabilities in this environment?
If you need, we can provide Read uncommitted transaction for Xbase compatible mode.
Re:Re:Re:Re:Re:Re:Clipper dbf transaction
Santiago
2008-07-04 08:27:08.0
Hi i am still evaluating the driver.
I got an exception when this query is executed

String query = "select FUNCOD,FUNAPEUNO,FUNAPEDOS,FUNNOMUN,FUNNOMDOS from funcio00 ";
......
stmt.setMaxRows(25);
ResultSet rs = stmt.executeQuery(query);

java.sql.SQLException: Syntax error: Stopped parse at null
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.f(Unknown Source)
at com.hxtt.sql.bm.n(Unknown Source)
at com.hxtt.sql.ag.if(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.executeQuery(Unknown Source)

Re:Re:Re:Re:Re:Re:Clipper dbf transaction
Santiago
2008-07-04 08:32:34.0
Sorry thelast problem(syntax error) is solved .

Yes i need Read uncommitted transaction for Xbase compatible mode

Could you sent me the cost for that? I need this compatible mode and the driver license for one server.
Re:Re:Re:Re:Re:Re:Re:Re:Clipper dbf transaction
HXTT Support
2008-07-04 18:22:00.0
>Yes i need Read uncommitted transaction for Xbase compatible mode
>Could you sent me the cost for that?
It have enabled before one week. No fee. Please continue your evaluation test.


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