Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 Text(CSV)
Using Text/CSV Driver with Hibernate
Mike Brown
2006-06-14 14:45:01.0
I am trying to convert an existing application using Hibernate and MySQL to using your CSV driver.

I was using ant tasks to generate the schema. When I try to do this with your driver, I get the following:

java.lang.UnsupportedOperationException: No drop foreigh key syntax supported by HxttTEXTDialect

Is there a way to do this using your driver?

If not, do I need to create csv files with a header only?

Any help you can give me or links to examples on using the driver with Hibernate including mapping associations would be appreciated.

-- Mike
Re:Using Text/CSV Driver with Hibernate
HXTT Support
2006-06-14 22:32:51.0
You should visit HXTT Hibernate Support Package and use com.hxtt.support.hibernate.HxttTextDialect . HXTT CSV doesn't support foreign key syntax.
Re:Re:Using Text/CSV Driver with Hibernate
Mike Brown
2006-06-15 04:53:33.0
I have been to that page already. I am interested in learning if you support one to many relationships with hibernate.

Consider an address definition similar to the following:

"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">



















I want to add a relationship to your person definition like this:








The goal is to have hibernate manage the relationships. Has anyone done this with the Text driver?

Re:Re:Re:Using Text/CSV Driver with Hibernate
Mike Brown
2006-06-15 04:55:00.0
I see the xml I pasted in the above reply was lost.
Re:Re:Re:Re:Using Text/CSV Driver with Hibernate
HXTT Support
2006-06-15 05:14:36.0
We will try to provide foreign key soon.
Re:Re:Re:Re:Re:Using Text/CSV Driver with Hibernate
HXTT Support
2006-06-20 05:54:24.0
The latest v2.3.019 supports PIVOT and UNPIVOT operation. We're designing an appropriate foreign key support now. Thanks for your patience.
Re:Re:Re:Re:Re:Re:Using Text/CSV Driver with Hibernate
Martin Ross
2006-06-21 07:53:56.0
Hi Mike,

Why on earth would you want to go from MySQL to CSV? You will lose alot of type information in the process. Not to mention that your performance for any large datasets will suck.

Just curious,

Martin
Re:Re:Re:Re:Re:Re:Re:Using Text/CSV Driver with Hibernate
Mike Brown
2006-06-23 11:55:27.0
I did't want to; my customer wanted data saved in csv file format.

I decided to implement it myself and I'm not using Hibernate at all.
Re:Re:Re:Re:Re:Re:Re:Re:Using Text/CSV Driver with Hibernate
HXTT Support
2006-06-23 19:00:45.0
>>If not, do I need to create csv files with a header only?
Yeah.
>I did't want to; my customer wanted data saved in csv file format.
>I decided to implement it myself and I'm not using Hibernate at all.
I see.

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