5:15 p.m.
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Affects Versions: 3.3.0.ga, 3.2.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile, ModifiedByUserID,
ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh, SOARetry, SOAWho,
ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState: 23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:24 p.m.
New subject: [Hibernate-JIRA] Commented: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Emmanuel Bernard commented on ANN-626:
--------------------------------------
can you try with <column not-null=true/> (which is the equivalent to the annotation
version
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:50 a.m.
New subject: [Hibernate-JIRA] Commented: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Rob commented on ANN-626:
-------------------------
I apologize for my late response. I do not have a suitable test bed to test this
currently. It will take me a few days to set something up since we are mid-stream
development.
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:12 p.m.
New subject: [Hibernate-JIRA] Updated: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Emmanuel Bernard updated ANN-626:
---------------------------------
Fix Version/s: 3.3.1
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
Fix For: 3.3.1
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:36 p.m.
New subject: [Hibernate-JIRA] Updated: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Diego Pires Plentz updated ANN-626:
-----------------------------------
Component/s: binder
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Components: binder
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
Fix For: 3.3.1
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:55 p.m.
New subject: [Hibernate-JIRA] Commented: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Emmanuel Bernard commented on ANN-626:
--------------------------------------
Hi Rob, did you get a change to follow up on this issue?
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Components: binder
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
Fix For: 3.3.1
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:31 a.m.
New subject: [Hibernate-JIRA] Commented: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Rob commented on ANN-626:
-------------------------
Hi Emmanuel,
I have worked around this issue, and have not put any time into looking at your
suggestion. I apologize, but with our current workaround, I wont be able to get to it.
Am I missing something, or are you just requesting to trying the non-annotated (.hbm.xml)
file version using the <column not-null=true> ?
ROb
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Components: binder
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
Fix For: 3.3.1
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:09 p.m.
New subject: [Hibernate-JIRA] Commented: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Emmanuel Bernard commented on ANN-626:
--------------------------------------
Yes, I believe that <column not-null=true> would lead to the same issue. But I
can't run on MSSQL
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Components: binder
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
Fix For: 3.3.1
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:08 p.m.
New subject: [Hibernate-JIRA] Commented: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Gail Badner commented on ANN-626:
---------------------------------
Hi Rob, what was your workaround?
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Components: binder
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
Fix For: 3.3.1
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:09 p.m.
New subject: [Hibernate-JIRA] Updated: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Emmanuel Bernard updated ANN-626:
---------------------------------
Fix Version/s: (was: 3.3.1.beta1)
3.3.1
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Components: binder
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
Fix For: 3.3.1
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:37 p.m.
New subject: [Hibernate-JIRA] Commented: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Ritesh patel commented on ANN-626:
----------------------------------
I'm in the similar boat where I need to dynamically insert the timestamp value through
hibernate, but only null is inserted in the database. Rob, what was your workaround? I
can't use obj.setDate() since all my hibernate session code is abstract where the
incoming object might be of different types. Is there any other way to generate DateTime
stamp in hibernate without using <timestamp>?
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Components: binder
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
Fix For: 3.3.1
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:44 p.m.
New subject: [Hibernate-JIRA] Commented: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
manav chauhan commented on ANN-626:
-----------------------------------
Hi,
One solution is to use a Save-Update listener and set the Time stamp or set the time
property at the constructor level.
Both suggestions above would require to remove @Generated annotations. Basically doing it
manually
Manav
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Components: binder
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
Fix For: 3.3.1
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:14 p.m.
New subject: [Hibernate-JIRA] Commented: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Emmanuel Bernard commented on ANN-626:
--------------------------------------
Someone seeing this issue, can you try my recommendation
(Yes, I believe that <column not-null=true> would lead to the same issue. But I
can't run on MSSQL
[ Show ยป ]
Emmanuel Bernard - [19/Jul/07 11:08 PM ] Yes, I believe that <column not-null=true>
would lead to the same issue. But I can't run on MSSQL
)
This would help to requalify the bug and move it to core.
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Components: binder
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
Fix For: 3.3.1
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:46 p.m.
New subject: [Hibernate-JIRA] Updated: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Emmanuel Bernard updated ANN-626:
---------------------------------
Fix Version/s: (was: 3.3.1)
downgrading the version, no user feedback
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Components: binder
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:31 p.m.
New subject: [Hibernate-JIRA] Commented: (ANN-626) @Generated annotation not inserting during insert
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Ritesh Patel commented on ANN-626:
----------------------------------
Hi Emmanuel
Yes I have tried <column not-null=true> which did in fact produce the same error
about inserting null values. I can try it out again just to make sure. Will report once
I've had the chance to test it.
-ritesh
@Generated annotation not inserting during insert
-------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Components: binder
Affects Versions: 3.2.0.ga, 3.3.0.ga
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Critical
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:29 p.m.
New subject: [Hibernate-JIRA] Updated: (ANN-626) @Generated annotation not inserting during insert if column is not-null=true
[
http://opensource.atlassian.com/projects/hibernate/browse/ANN-626?page=co...
]
Emmanuel Bernard updated ANN-626:
---------------------------------
Priority: Minor (was: Critical)
Summary: @Generated annotation not inserting during insert if column is not-null=true
(was: @Generated annotation not inserting during insert)
@Generated annotation not inserting during insert if column is
not-null=true
----------------------------------------------------------------------------
Key: ANN-626
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-626
Project: Hibernate Annotations
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Minor
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:29 p.m.
New subject: [Hibernate-JIRA] Moved: (HHH-3166) @Generated annotation not inserting during insert if column is not-null=true
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3166?page=c...
]
Emmanuel Bernard moved ANN-626 to HHH-3166:
-------------------------------------------
Affects Version/s: (was: 3.2.0.ga)
(was: 3.3.0.ga)
3.2.6
Component/s: (was: binder)
core
Key: HHH-3166 (was: ANN-626)
Project: Hibernate3 (was: Hibernate Annotations)
@Generated annotation not inserting during insert if column is
not-null=true
----------------------------------------------------------------------------
Key: HHH-3166
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3166
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Minor
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:31 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3166) @Generated annotation not inserting during insert if column is not-null=true
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3166?page=c...
]
Emmanuel Bernard commented on HHH-3166:
---------------------------------------
I suspect the we cannot do much and it's not a bug per se (need further analysis). We
should at least raise an exception early on if not-null=true is set on a generated
property.
@Generated annotation not inserting during insert if column is
not-null=true
----------------------------------------------------------------------------
Key: HHH-3166
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3166
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Minor
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:22 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3166) @Generated annotation not inserting during insert if column is not-null=true
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3166?page=c...
]
Ritesh Patel commented on HHH-3166:
-----------------------------------
but that's the thing, the "generated=true" is not generating any values and
tries to insert null, which fails the "not-null=true".
@Generated annotation not inserting during insert if column is
not-null=true
----------------------------------------------------------------------------
Key: HHH-3166
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3166
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Minor
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:02 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3166) @Generated annotation not inserting during insert if column is not-null=true
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3166?page=c...
]
Emmanuel Bernard commented on HHH-3166:
---------------------------------------
generated=true means "don't insert the data but read it from the database",
so of course we have to not insert it :)
I'm not sure skipping the column altogether will help but it worth a try.
@Generated annotation not inserting during insert if column is
not-null=true
----------------------------------------------------------------------------
Key: HHH-3166
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3166
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Minor
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:44 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3166) @Generated annotation not inserting during insert if column is not-null=true
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3166?page=c...
]
Paul Benedict commented on HHH-3166:
------------------------------------
One feature that I wish Hibernate supported is the ability to insert NULL for generated
columns. In particular, MySQL requires that if you want to have generate the current
timestamp with multiple timestamp columns:
* http://gusiev.com/2009/04/update-and-create-timestamps-with-mysql/
* http://dev.mysql.com/doc/refman/5.0/en/timestamp.html
By inserting NULL into the Created column, the create timestamp gets auto-generated. If
the column is left out of the insert statement (thus accepting the default), you will get
the default value. In either case, Hibernate needs to read back the value.
@Generated annotation not inserting during insert if column is
not-null=true
----------------------------------------------------------------------------
Key: HHH-3166
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3166
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.6
Environment: MSSQL 9.00.3042.00
Hibernate annotations version 3.2.0 GA and also tested 3.30 GA
Reporter: Rob
Priority: Minor
The @Generated annotation is not working similiar to the hbm generated tag.
Annotation Mapping:
@Generated(GenerationTime.INSERT)
@Column (name="CreatedOn", length=23, nullable=false, insertable=false,
updatable=false)
private Date mCreatedOn;
Mapping Document:
<property name="createdOn" generated="insert"
type="TimestampType">
<column name="CreatedOn" length="23"/>
</property>
The generated SQL (show_sql=true):
Hibernate: insert into Zone (CreatedByUserID, ZoneDescription, ZoneFile,
ModifiedByUserID, ModifiedOn, ZoneName, RowStatus, SOAExpire, SOAMinimum, SOARefresh,
SOARetry, SOAWho, ZoneTTL, ZoneType, ZoneClass) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
Debug level Hibernate log excerpt:
18:37:42 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 515, SQLState:
23000
18:37:42 ERROR org.hibernate.util.JDBCExceptionReporter 78 Cannot insert the value NULL
into column 'CreatedOn', table 'DB.dbo.Zone'; column does not allow nulls.
INSERT fails.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5390
days inactive
6221
days old
hibernate-issues@lists.jboss.org
20 comments
8 participants
participants (8)
-
Diego Pires Plentz (JIRA) -
Emmanuel Bernard (JIRA)
-
Gail Badner (JIRA)
-
manav chauhan (JIRA)
-
Paul Benedict (JIRA)
-
Ritesh patel (JIRA)
-
Ritesh Patel (JIRA)
-
Rob (JIRA)