bug in hibernate3 tools and fix

Oturan Boga · **Joined:** Thu Feb 03, 2005 7:23 pm **Posts:** 23

Hello,

This is with hibernate3 tools. Under artifact generation when we create artifacts it generates us the mapping files and object. it is all working, but when we try to run schema export, (for oracle db) we get a missing left paranthesis error.

The reason is:

<column name="DEFINITION" not-null="false" sql-type="VARCHAR2" />

oracle does not like this, since one has to define the length of varchar 2.

<column name="DEFINITION" leghth="20" not-null="false" sql-type="VARCHAR2" />

does not work as well, but:

<column name="DEFINITION" not-null="false" sql-type="VARCHAR2(20)" />

works fine. I guess this qualifies as a bug.

gavin · **Posted:** Thu Feb 10, 2005 10:35 pm

This is correct functionality. You have to specify the *full* type in sql-type.

ie. sql-type="VARCHAR2(10)"

Why on earth would you ever specify VARCHAR2 explicitly??? that is the default!

Oturan Boga · **Joined:** Thu Feb 03, 2005 7:23 pm **Posts:** 23

Hello Gavin,

the mapping was generated by hibernate tools, I did not mean this as a bug in hibernate - but in hibernate tools. :)

I did the artifact generation with hibernate tools, and running schema export from hibernate console generated the error.

Best regards,
-O.B.

max · **Posted:** Fri Feb 11, 2005 5:52 am

please submit it as a bug to the jira.