[sharonxchen]

I am new to Hibernate and myEclipse, I am trying to using “Hibernate reverse engineering” to generate code, however, both Blob and Raw type become String type? How can I generate Java DAO with the right type?

e.g.
CREATE TABLE TESTME
(
ID INTEGER NOT NULL,
DESCRIPTION BLOB

)

generated mapping file is:

<class name=”com.ssa.wex.dao.Testme” table=”TESTME” schema=”WEX”>
<id name=”id” type=”java.lang.Long”>
<column name=”ID” precision=”22″ scale=”0″ />
<generator class=”increment” />
</id>
<property name=”description” type=”java.lang.String”>
<column name=”DESCRIPTION” />
</property>
</class>

The description has been handled as “String” not “Blob”, what I should do?

[Loyal Water]

sharonxchen,
On the second page of the Hibernate Reverse engineering wizard there is a custom mapping option. You can use that to custom map your Blob field.

[sharonxchen]

I got an error when doing the followings:

On the second page, I have put JDBC type as “BLOB” and Hibernate type as “java.sql.Blob”.
after click Finish, I got an error, the error in the log file is:

org.hibernate.MappingException: Could not configure overrides from file: C:\sandbox\wex\hibernate.reveng.xml
at org.hibernate.cfg.reveng.OverrideRepository.addFile(OverrideRepository.java:106)

Caused by: org.hibernate.MappingException: jdbc-type: Integer is not a known JDBC Type nor a valid number

It seems did not like type “BLOB”, I am using Oracle 9.

Thanks!

[sharonxchen]

Hi, Nipun,

can you give me suggestions? Still does not work.

[Brian Fernandes]

Sharon,

It looks like you might have a stale setting in your hibernate.reveng.xml file which is somehow not being reported in the wizard. Can you please delete the file before invoking the wizard and then add the entry again? (the file will be created automatically). Alternatively you can use the wizard to specify a new reveng.xml file and make your change.

It would also help if you clear the error log before invoking the wizard. This makes it easier to analyze the problem.

Please let us know how it turns out. If it does not work, please paste your reveng.xml here.

[sharonxchen]

it worked, thanks!!

[Loyal Water]

Glad it worked.

[Author]

Posts