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.


Google