I post the DDL of the table and i attache table result
/******************************************************************************/
/**** Tables
****/
/******************************************************************************/
CREATE TABLE BUPDATERLINKS (
IDBUPDATERLINKS IDENT /* IDENT = VARCHAR(22) NOT NULL */,
BULREFPARENT REFERENCE /* REFERENCE = VARCHAR(22) DEFAULT '-1' */,
BULTYPE ENTIER /* ENTIER = INTEGER DEFAULT 0 */,
BULREFBYTYPE REFERENCE /* REFERENCE = VARCHAR(22) DEFAULT '-1' */,
BULDEST LIB500 /* LIB500 = VARCHAR(500) */,
BULJSON BLOBTEXT /* BLOBTEXT = BLOB SUB_TYPE 1 SEGMENT SIZE 80
*/,
BULSTATE ENTIER /* ENTIER = INTEGER DEFAULT 0 */,
BULDATEACTION DATECOMPLETE /* DATECOMPLETE = TIMESTAMP */,
BULACTIF ENTIER /* ENTIER = INTEGER DEFAULT 0 */,
FTPDATE DATECOMPLETE2 /* DATECOMPLETE2 = TIMESTAMP DEFAULT
'now' NOT NULL */,
CREATEDATE DATECOMPLETE2 /* DATECOMPLETE2 = TIMESTAMP DEFAULT
'now' NOT NULL */
);
/******************************************************************************/
/**** Primary Keys
****/
/******************************************************************************/
ALTER TABLE BUPDATERLINKS ADD CONSTRAINT PK_BUPDATERLINKS PRIMARY KEY
(IDBUPDATERLINKS);
/******************************************************************************/
/**** Triggers
****/
/******************************************************************************/
SET TERM ^ ;
/******************************************************************************/
/**** Triggers for tables
****/
/******************************************************************************/
/* Trigger: BUPDATERLINKS_BI */
CREATE OR ALTER TRIGGER BUPDATERLINKS_BI FOR BUPDATERLINKS
ACTIVE BEFORE INSERT POSITION 0
as
begin
IF (NEW.idbupdaterlinks IS NULL) THEN
BEGIN
EXECUTE PROCEDURE SYS_GET_UUID RETURNING_VALUES NEW.idbupdaterlinks;
END
end
^
Le vendredi 4 juillet 2014 16:49:52 UTC+2, [email protected] a écrit :
>
> i think the problem is in the mapping of table the definition of my
> primary key is :
>
> IDMYTABLE VARCHAR(22) NOT NULL via a domain
>
> but field.getDataType().nullable => returns true and field size is 88 ????
>
>
>
> Le vendredi 4 juillet 2014 16:15:46 UTC+2, [email protected] a écrit :
>>
>> I have debug a little bit and it try to do an update (i don't know why
>> for moment)
>>
>> Le vendredi 4 juillet 2014 16:09:07 UTC+2, [email protected] a écrit :
>>>
>>> Hi,
>>>
>>> my database is firebird and now when i doing that the insert don't work :
>>>
>>> record = getDsl().newRecord(MYTABLE);
>>> record.setState(0);
>>> record.store();
>>>
>>> no warning, no error but nothing is inserted and i have a primary key on
>>> MYTABLE.
>>>
>>> it works fine on 3.2.2.
>>>
>>> any sugestions ?
>>>
>>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
/**
* This class is generated by jOOQ.
*/
@javax.annotation.Generated(value = { "http://www.jooq.org";, "3.4.0" },
comments = "This class is generated by jOOQ")
@java.lang.SuppressWarnings({ "all", "unchecked", "rawtypes" })
public class Bupdaterlinks extends org.jooq.impl.TableImpl<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord> {
private static final long serialVersionUID = 50765030;
/**
* The singleton instance of <code>BUPDATERLINKS</code>
*/
public static final com.lrd.menlog.dao.tables.Bupdaterlinks BUPDATERLINKS = new com.lrd.menlog.dao.tables.Bupdaterlinks();
/**
* The class holding records for this type
*/
@Override
public java.lang.Class<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord> getRecordType() {
return com.lrd.menlog.dao.tables.records.BupdaterlinksRecord.class;
}
/**
* The column <code>BUPDATERLINKS.IDBUPDATERLINKS</code>.
*/
public final org.jooq.TableField<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord, java.lang.String> IDBUPDATERLINKS = createField("IDBUPDATERLINKS", org.jooq.impl.SQLDataType.VARCHAR.length(88), this, "");
/**
* The column <code>BUPDATERLINKS.BULREFPARENT</code>.
*/
public final org.jooq.TableField<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord, java.lang.String> BULREFPARENT = createField("BULREFPARENT", org.jooq.impl.SQLDataType.VARCHAR.length(88), this, "");
/**
* The column <code>BUPDATERLINKS.BULTYPE</code>.
*/
public final org.jooq.TableField<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord, java.lang.Integer> BULTYPE = createField("BULTYPE", org.jooq.impl.SQLDataType.INTEGER, this, "");
/**
* The column <code>BUPDATERLINKS.BULREFBYTYPE</code>.
*/
public final org.jooq.TableField<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord, java.lang.String> BULREFBYTYPE = createField("BULREFBYTYPE", org.jooq.impl.SQLDataType.VARCHAR.length(88), this, "");
/**
* The column <code>BUPDATERLINKS.BULDEST</code>.
*/
public final org.jooq.TableField<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord, java.lang.String> BULDEST = createField("BULDEST", org.jooq.impl.SQLDataType.VARCHAR.length(2000), this, "");
/**
* The column <code>BUPDATERLINKS.BULJSON</code>.
*/
public final org.jooq.TableField<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord, java.lang.String> BULJSON = createField("BULJSON", org.jooq.impl.SQLDataType.CLOB, this, "");
/**
* The column <code>BUPDATERLINKS.BULSTATE</code>.
*/
public final org.jooq.TableField<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord, java.lang.Integer> BULSTATE = createField("BULSTATE", org.jooq.impl.SQLDataType.INTEGER, this, "");
/**
* The column <code>BUPDATERLINKS.BULDATEACTION</code>.
*/
public final org.jooq.TableField<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord, java.sql.Timestamp> BULDATEACTION = createField("BULDATEACTION", org.jooq.impl.SQLDataType.TIMESTAMP, this, "");
/**
* The column <code>BUPDATERLINKS.BULACTIF</code>.
*/
public final org.jooq.TableField<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord, java.lang.Integer> BULACTIF = createField("BULACTIF", org.jooq.impl.SQLDataType.INTEGER, this, "");
/**
* The column <code>BUPDATERLINKS.FTPDATE</code>.
*/
public final org.jooq.TableField<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord, java.sql.Timestamp> FTPDATE = createField("FTPDATE", org.jooq.impl.SQLDataType.TIMESTAMP, this, "");
/**
* The column <code>BUPDATERLINKS.CREATEDATE</code>.
*/
public final org.jooq.TableField<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord, java.sql.Timestamp> CREATEDATE = createField("CREATEDATE", org.jooq.impl.SQLDataType.TIMESTAMP, this, "");
/**
* Create a <code>BUPDATERLINKS</code> table reference
*/
public Bupdaterlinks() {
this("BUPDATERLINKS", null);
}
/**
* Create an aliased <code>BUPDATERLINKS</code> table reference
*/
public Bupdaterlinks(java.lang.String alias) {
this(alias, com.lrd.menlog.dao.tables.Bupdaterlinks.BUPDATERLINKS);
}
private Bupdaterlinks(java.lang.String alias, org.jooq.Table<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord> aliased) {
this(alias, aliased, null);
}
private Bupdaterlinks(java.lang.String alias, org.jooq.Table<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord> aliased, org.jooq.Field<?>[] parameters) {
super(alias, com.lrd.menlog.dao.DefaultSchema.DEFAULT_SCHEMA, aliased, parameters, "");
}
/**
* {@inheritDoc}
*/
@Override
public org.jooq.UniqueKey<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord> getPrimaryKey() {
return com.lrd.menlog.dao.Keys.PK_BUPDATERLINKS;
}
/**
* {@inheritDoc}
*/
@Override
public java.util.List<org.jooq.UniqueKey<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord>> getKeys() {
return java.util.Arrays.<org.jooq.UniqueKey<com.lrd.menlog.dao.tables.records.BupdaterlinksRecord>>asList(com.lrd.menlog.dao.Keys.PK_BUPDATERLINKS);
}
/**
* {@inheritDoc}
*/
@Override
public com.lrd.menlog.dao.tables.Bupdaterlinks as(java.lang.String alias) {
return new com.lrd.menlog.dao.tables.Bupdaterlinks(alias, this);
}
/**
* Rename this table
*/
public com.lrd.menlog.dao.tables.Bupdaterlinks rename(java.lang.String name) {
return new com.lrd.menlog.dao.tables.Bupdaterlinks(name, null);
}
}
