Hello,
Using the following test table, I could not reproduce the issue:
CREATE TABLE t_1531 (
id numeric(10,0) IDENTITY PRIMARY KEY NOT NULL
)
Can you provide me with the full DDL leading to this issue? I suspect
that you are using some special data type ("TypCounter") that is
currently not supported by jOOQ. Where did that type come from?
Cheers
Lukas
2012/7/5 <[email protected]>:
> One of the classes generated contains an error in this method:
>
> @Override
> public
> org.jooq.Identity<test.migraene.tables.records.AuftragmatrixRecord,
> java.lang.Object> getIdentity() {
> return test.migraene.Keys.IDENTITY_AUFTRAGMATRIX;
> }
>
> The error happens because in AbstractTable the method is defined like this:
> @Override
> public Identity<R, ? extends Number> getIdentity() {
> return null;
> }
>
> The primary key is defined something like this:
> artikel_id numeric(10,0) PRIMARY KEY NOT NULL
>
> I guess the problem comes form here:
> /**
> * An uncommented item
> *
> * The SQL type of this item (TypCounter) could not be mapped.<br/>
> * Deserialising this field might not work!
> *
> * PRIMARY KEY
> */
> public final
> org.jooq.TableField<test.migraene.tables.records.AuftragmatrixRecord,
> java.lang.Object> ARTIKEL_ID = createField("artikel_id",
> org.jooq.util.ase.ASEDataType.getDefaultDataType("TypCounter"), this);
>
> Is there a way to fix this?
> 10x