tools 3.0 alpha1 and boolean type

hsalameh · **Joined:** Sun Jul 25, 2004 11:15 pm **Posts:** 24

hi
i am using the tools 3.0 alpha1, with hsqldb
i have a boolean column, and when i do the reverse engineering, it is brought in as an Object object.
Shouldn't the reverse engineering tool automatically detect it as a Boolean object ? is there something i need to do to make that happen? or is this a bug?

another thing is the id. i have a primary key that is declared as IDENTITY. The mapping that is created by the reverse engineering tool was : <generator class="assigned" />, and this does not work right.
shouldn't that be created as <generator class="native" /> by default?

Thanks.

max · **Posted:** Wed Mar 16, 2005 3:26 am

identifier is at the moment hardcoded to assigned.

the boolean should work....put both in jira with examples of the ddl that it is "failing" with.

hsalameh · **Joined:** Sun Jul 25, 2004 11:15 pm **Posts:** 24

max wrote:

identifier is at the moment hardcoded to assigned.

the boolean should work....put both in jira with examples of the ddl that it is "failing" with.

Hi Max..
the boolean worked fine. actually it was probably my mistake.
I was using eclipse 3.1M5a when that happened.
I switched back to 3.1M4 and it worked fine. This also fixed couple of other problems I was running into.

Anyways, regarding the "assigned" identifier, I will create a report in jira as soon as i can.
Also there is a problem in the generation of the configuration file. It always generates the session-factory element as follows:
<session-factoryname=.....>
with no space between the name attribute and the session-factory element tag.
I will log this into jira as well when i have a chance.

thanks.

max · **Posted:** Wed Mar 16, 2005 4:41 am

the session-factory name bug is already in there and also fixed.

-max

hsalameh · **Joined:** Sun Jul 25, 2004 11:15 pm **Posts:** 24

Max....
actually the boolean problem still happens....for some reason i thought it was okay when i switched to eclipse 3.1M4 but it seems it is still the same.

is there something wrong i am doing?

i created a table in hsqldb as follows:

Code:

CREATE TABLE ABC (
ABC_ID      IDENTITY PRIMARY KEY, 
ABC_STR     VARCHAR(255),
ABC_BOOL    BOOLEAN
)

then when i reverse engineer it, i get the following in the hbm.xml:

<property
name="AbcBool"
type="java.lang.Object"
>
<column name="ABC_BOOL" not-null="false" sql-type="BOOLEAN" />
</property>

and this gets carried over to the java file as follows:

private java.lang.Object AbcBool;

so what do i need to do in order to get that in as Boolean type?

thanks

max · **Posted:** Wed Mar 16, 2005 2:01 pm

yes - it seems we are missing the boolean type that hsqldb reports back to us in the sqltypes 2 java property code. That is a bug (specific for hsqldb boolean type it seems) - please put it in jira if it isnt there already.