Here is the generated repository info:
<class-descriptor
class="bean.Account"
table="account"
>
<field-descriptor
name="id"
column="account_id"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
>
</field-descriptor>
<field-descriptor
name="username"
column="username"
jdbc-type="VARCHAR"
length="12"
>
</field-descriptor>
<field-descriptor
name="password"
column="password"
jdbc-type="VARCHAR"
length="64"
>
</field-descriptor>
<field-descriptor
name="firstName"
column="fname"
jdbc-type="VARCHAR"
length="32"
>
</field-descriptor>
<field-descriptor
name="lastName"
column="lname"
jdbc-type="VARCHAR"
length="32"
>
</field-descriptor>
<field-descriptor
name="email"
column="email"
jdbc-type="VARCHAR"
length="64"
>
</field-descriptor>
<field-descriptor
name="age"
column="age"
jdbc-type="INTEGER"
>
</field-descriptor>
<field-descriptor
name="gender"
column="gender"
jdbc-type="INTEGER"
>
</field-descriptor>
<field-descriptor
name="birthdate"
column="birthdate"
jdbc-type="TIMESTAMP"
conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlTimest
ampFieldConversion"
>
</field-descriptor>
<field-descriptor
name="address"
column="address1"
jdbc-type="VARCHAR"
length="64"
>
</field-descriptor>
<field-descriptor
name="address2"
column="address2"
jdbc-type="VARCHAR"
length="64"
>
</field-descriptor>
<field-descriptor
name="city"
column="city"
jdbc-type="VARCHAR"
length="64"
>
</field-descriptor>
<field-descriptor
name="state"
column="state"
jdbc-type="VARCHAR"
length="2"
>
</field-descriptor>
<field-descriptor
name="zip"
column="zip"
jdbc-type="VARCHAR"
length="10"
>
</field-descriptor>
<field-descriptor
name="interests"
column="interests"
jdbc-type="VARCHAR"
length="256"
>
</field-descriptor>
<collection-descriptor
name="roles"
element-class-ref="bean.Role"
indirection-table="account_role"
auto-retrieve="true"
auto-update="false"
auto-delete="false"
>
<fk-pointing-to-this-class column="account_id"/>
<fk-pointing-to-element-class column="role_id"/>
</collection-descriptor>
</class-descriptor>
And here's the DDL:
CREATE TABLE ACCOUNT(
ACCOUNT_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,
USERNAME VARCHAR(12) NOT NULL,
PASSWORD VARCHAR(64) NOT NULL,
FNAME VARCHAR(32) NOT NULL,
LNAME VARCHAR(32) NOT NULL,
EMAIL VARCHAR(64) NOT NULL,
AGE INTEGER NOT NULL,
GENDER INTEGER NOT NULL,
BIRTHDATE DATE NOT NULL,
ADDRESS1 VARCHAR(64) NOT NULL,
ADDRESS2 VARCHAR(64),
CITY VARCHAR(64) NOT NULL,
STATE CHAR(2) NOT NULL,
ZIP VARCHAR(10) NOT NULL,
INTERESTS VARCHAR(256)
)
Could you post the generated repository descriptor and database definition
(torque schema or hibernate sql) ?
BTW, there was a little issue with the autoincrement='database' setting
that I fixed in CVS, which is not present in RC6.
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
