-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 posts ] 
  Previous topic | Next topic 
Author Message
dastardly75
 Post subject: Problem with id generation on postgreSQL
PostPosted: Thu Dec 14, 2006 7:42 am 
Newbie

Joined: Thu Dec 14, 2006 6:59 am
Posts: 2
Hi everybody,
I want to report a weird behaviour in id generation on a PostgreSQL 8.1.4 Linux database. I deployed my web application on other versions, PostgreSQL 8.1.3 Windows , with the same Hibernate configuration and there I can't reproduct the problem, everything seems to work fine.
The hibernate configuration is the right one (I presume) for Postgre, with class="sequence":

<class name="Version" table="GD_VERSION">

<id name="id" column="ID">
<generator class="sequence">
<param name="sequence">SEQ_GD_VERSION</param>
</generator>
</id>
<property name="description" length="4000"/>

...

The ddl for creating the sequence is the following:

CREATE SEQUENCE seq_gd_version start 1
INCREMENT 1
MINVALUE 1
CACHE 10;

The problem is: when I save Version objects in my application - only in this particular deployment - the Id generated from the sequence <b> sometimes (with an unpredictable frequency) </b> jumps forward (i.e. from 232 to 241 instead then 233) and then uses again the values contained in the space left (i.e. instead of 242 it gives me a 233!). Basing part of my application logic on the id order value this is a cause of almost fatal problems.

I want to add some more details that could help you:

1) the Application Server used is Tomcat 5.5.20 and Hibernate uses a JNDI datasource configured on Tomcat server.xml file, so the connection pool used is Apache DBCP. Could this be a cause instead of a PostgreSQL release problem?
2) when I check the alive threads with the ps -eaf command there are two postgres lines to the database implicated (the one with Hibernate on top of it).

The persistence Java code used is the standard for non-managed environments with the Transaction API and commit() and rollback() explicited.

try {
session = HBMUtil.currentSession();
tx = session.beginTransaction();

session.update(document);
session.flush();

if (overrideVersion) {

session.update(version);
session.flush();

List oldIntegrationParamList = session.createCriteria(
IntegrationParameter.class).createCriteria(
DBConstants.ATTRIBUTE_VERSION).add(
Property.forName(DBConstants.ATTRIBUTE_ID).eq(
version.getId())).list();

if (oldIntegrationParamList != null) {
for (Iterator iter = oldIntegrationParamList.iterator(); iter
.hasNext();) {
IntegrationParameter integrationParam = (IntegrationParameter) iter
.next();

session.delete(integrationParam);
session.flush();
}
}

Collection integrationParamCollection = version
.getIntegrationParameters();
if (integrationParamCollection != null) {
for (Iterator iter = integrationParamCollection.iterator(); iter
.hasNext();) {
IntegrationParameter integrationParam = (IntegrationParameter) iter
.next();
session.save(integrationParam);
session.flush();

if (logger.isDebugEnabled()) {
logger
.debug("[updateDocument] Salvo il contenuto nel db");
}

updateContent(session, content);

}
}

} else {
session.save(version);
session.flush();

Collection integrationParamCollection = version
.getIntegrationParameters();
if (integrationParamCollection != null) {
for (Iterator iter = integrationParamCollection.iterator(); iter
.hasNext();) {
IntegrationParameter integrationParam = (IntegrationParameter) iter
.next();
session.save(integrationParam);
session.flush();
}
}

saveContent(session, content);

}

tx.commit();

return document;
} catch (HibernateException e) {
throw new GeDocException(e);
} catch (SQLException e) {
throw new GeDocException(e);
} catch (Throwable e) {
throw new GeDocException(e);
} finally {
if (tx.isActive()) {
tx.rollback();
}
HBMUtil.closeSession();



The following is the Hibernate debug:

[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[SessionImpl] opened session at timestamp: 4776343294148608
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[JDBCTransaction] begin
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[ConnectionManager] opening JDBC connection
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[JDBCTransaction] current autocommit status: false
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[JDBCContext] after transaction begin
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] object not resolved in any cache: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Fetching entity: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] loading entity: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] select document0_.id as ID0_2_, document0_1_.COMPONENT_NAME as COMPONENT2_0_2_, document0_1_.DESCRIPTION as DESCRIPT3_0_2_, document0_1_.CREATION_DATE as CREATION4_0_2_, document0_1_.USER_ID as USER5_0_2_, document0_1_.parent_id as parent6_0_2_, document0_.DOCUMENT_TYPE_ID as DOCUMENT2_5_2_, document0_.LOCK_OWNER as LOCK3_5_2_, document0_.LOCKED as LOCKED5_2_, composite1_.id as ID0_0_, composite1_1_.COMPONENT_NAME as COMPONENT2_0_0_, composite1_1_.DESCRIPTION as DESCRIPT3_0_0_, composite1_1_.CREATION_DATE as CREATION4_0_0_, composite1_1_.USER_ID as USER5_0_0_, composite1_1_.parent_id as parent6_0_0_, composite1_3_.ROOT_TYPE as ROOT2_3_0_, case when composite1_2_.id is not null then 2 when composite1_3_.id is not null then 3 when composite1_4_.id is not null then 4 when composite1_.id is not null then 1 end as clazz_0_, documentty2_.ID as ID11_1_, documentty2_.USER_ID as USER2_11_1_, documentty2_.description as descript3_11_1_, documentty2_.CREATION_DATE as CREATION4_11_1_, documentty2_.ASSOCIATED_ICON as ASSOCIATED5_11_1_, documentty2_.ASSOCIATED_ICON_LOCKED as ASSOCIATED6_11_1_, documentty2_.note as note11_1_ from GD_DOCUMENT document0_ inner join GD_BASE_COMPONENT document0_1_ on document0_.id=document0_1_.ID left outer join GD_COMPOSITE composite1_ on document0_1_.parent_id=composite1_.id left outer join GD_BASE_COMPONENT composite1_1_ on composite1_.id=composite1_1_.ID left outer join GD_FOLDER composite1_2_ on composite1_.id=composite1_2_.id left outer join GD_ROOT composite1_3_ on composite1_.id=composite1_3_.id left outer join GD_ARCHIVE composite1_4_ on composite1_.id=composite1_4_.id left outer join GD_DOCUMENT_TYPE documentty2_ on document0_.DOCUMENT_TYPE_ID=documentty2_.ID where document0_.id=?
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] preparing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] binding '191' to parameter: 1
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] processing result set
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result set row: 0
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '131' as column: ID0_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: ID11_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result row: EntityKey[it.noema.ged.model.Composite#131], EntityKey[it.noema.ged.model.DocumentType#1], EntityKey[it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2' as column: clazz_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.Folder#131]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.Folder#131]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'test ema' as column: COMPONENT2_0_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'cartella di test' as column: DESCRIPT3_0_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2006-11-23 12:23:52' as column: CREATION4_0_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'federicac' as column: USER5_0_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '3' as column: parent6_0_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.DocumentType#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.DocumentType#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'Admin' as column: USER2_11_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'Generico' as column: descript3_11_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2006-10-23 12:50:04' as column: CREATION4_11_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'c7c9c6b8b9e1948094802284804646468080800404047f7f7f7f7f7f808080808080808080a179848180808480ac80808080948094808083c9c83a5c7e7009c9eba4e2682d010899378143a715d5f62c47a9f2c06be494ba8d317bf6f2c3d7a8dc0f915a89cfb5e0eee664a1d321252ff9e4b625c400f64b45aed8607070c2aebf9280bb' as column: ASSOCIATED5_11_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'c7c9c6b8b9e1948094807780807f80808080800404047f8f8f7f7f7f4646467f73737ef9f97ea2a27f4e4e7ed4d47f36368080807f1e1e7ec8c87f5a5a7e05057ee1e17eeded7ebcbc7f6767808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080a179848180808180ac80808080948094808088308081889cc8302041808893aadc18d0a0c28190a3cae4b88040c38298b3e2aca0a021018388ac869020d1e381829d93a8d860f0a4ca09a49948ec6060c10016a4cbea04d093a14e17a4a39a08505327481ca50756e45070a84a86929e8898baa1c18126c6afbef0b061800183939690385a7422008593a6c0d0cb12ecd6179839ce0810516dcd279041564ce977a7c62894cce23dfb9123811dfd0f96d84c38f1e204b2a3cb16dc1621e50586b3eb8e8880bb' as column: ASSOCIATED6_11_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'Tipo documento di default' as column: note11_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'txt07.txt' as column: COMPONENT2_0_2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '' as column: DESCRIPT3_0_2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2006-12-13 20:54:22' as column: CREATION4_0_2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'federicac' as column: USER5_0_2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '131' as column: parent6_0_2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: DOCUMENT2_5_2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'federicac' as column: LOCK3_5_2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'true' as column: LOCKED5_2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] done processing result set (1 rows)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] closing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] total objects hydrated: 3
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] resolving associations for [it.noema.ged.model.Folder#131]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.Composite#3]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.Composite#3]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] object not resolved in any cache: [it.noema.ged.model.Composite#3]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Fetching entity: [it.noema.ged.model.Composite#3]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] loading entity: [it.noema.ged.model.Composite#3]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] select composite0_.id as ID0_1_, composite0_1_.COMPONENT_NAME as COMPONENT2_0_1_, composite0_1_.DESCRIPTION as DESCRIPT3_0_1_, composite0_1_.CREATION_DATE as CREATION4_0_1_, composite0_1_.USER_ID as USER5_0_1_, composite0_1_.parent_id as parent6_0_1_, composite0_3_.ROOT_TYPE as ROOT2_3_1_, case when composite0_2_.id is not null then 2 when composite0_3_.id is not null then 3 when composite0_4_.id is not null then 4 when composite0_.id is not null then 1 end as clazz_1_, composite1_.id as ID0_0_, composite1_1_.COMPONENT_NAME as COMPONENT2_0_0_, composite1_1_.DESCRIPTION as DESCRIPT3_0_0_, composite1_1_.CREATION_DATE as CREATION4_0_0_, composite1_1_.USER_ID as USER5_0_0_, composite1_1_.parent_id as parent6_0_0_, composite1_3_.ROOT_TYPE as ROOT2_3_0_, case when composite1_2_.id is not null then 2 when composite1_3_.id is not null then 3 when composite1_4_.id is not null then 4 when composite1_.id is not null then 1 end as clazz_0_ from GD_COMPOSITE composite0_ inner join GD_BASE_COMPONENT composite0_1_ on composite0_.id=composite0_1_.ID left outer join GD_FOLDER composite0_2_ on composite0_.id=composite0_2_.id left outer join GD_ROOT composite0_3_ on composite0_.id=composite0_3_.id left outer join GD_ARCHIVE composite0_4_ on composite0_.id=composite0_4_.id left outer join GD_COMPOSITE composite1_ on composite0_1_.parent_id=composite1_.id left outer join GD_BASE_COMPONENT composite1_1_ on composite1_.id=composite1_1_.ID left outer join GD_FOLDER composite1_2_ on composite1_.id=composite1_2_.id left outer join GD_ROOT composite1_3_ on composite1_.id=composite1_3_.id left outer join GD_ARCHIVE composite1_4_ on composite1_.id=composite1_4_.id where composite0_.id=?
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] preparing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] binding '3' to parameter: 1
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] processing result set
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result set row: 0
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning null as column: ID0_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result row: null, EntityKey[it.noema.ged.model.Composite#3]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '3' as column: clazz_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.Root#3]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.Root#3]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'Noema Demo' as column: COMPONENT2_0_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'root Noema Demo per i soli utenti interni a Noema. Per effettuare test in parallelo ai partner.' as column: DESCRIPT3_0_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2006-10-24 18:14:42' as column: CREATION4_0_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'admin' as column: USER5_0_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning null as column: parent6_0_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'ged' as column: ROOT2_3_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] done processing result set (1 rows)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] closing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] total objects hydrated: 1
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] resolving associations for [it.noema.ged.model.Root#3]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] creating collection wrapper:[it.noema.ged.model.Composite.children#3]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] done materializing entity [it.noema.ged.model.Root#3]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] done entity load
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] creating collection wrapper:[it.noema.ged.model.Composite.children#131]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] done materializing entity [it.noema.ged.model.Folder#131]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] resolving associations for [it.noema.ged.model.DocumentType#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] creating collection wrapper:[it.noema.ged.model.DocumentType.indexParameters#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] creating collection wrapper:[it.noema.ged.model.DocumentType.commonIndexes#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] done materializing entity [it.noema.ged.model.DocumentType#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] resolving associations for [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.Composite#131]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.Composite#131]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.Composite#131]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.DocumentType#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.DocumentType#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.DocumentType#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] creating collection wrapper:[it.noema.ged.model.Document.versions#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] creating collection wrapper:[it.noema.ged.model.Document.indexParamValues#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] creating collection wrapper:[it.noema.ged.model.Document.commonIndexValues#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] done materializing entity [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[StatefulPersistenceContext] initializing non-lazy collections
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] initializing collection [it.noema.ged.model.Document.commonIndexValues#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] checking second-level cache
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] collection not cached
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] loading collection: [it.noema.ged.model.Document.commonIndexValues#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] select commoninde0_.DOCUMENT_ID as DOCUMENT3_4_, commoninde0_.ID as ID4_, commoninde0_.ID as ID21_3_, commoninde0_.INDEX_VALUE as INDEX2_21_3_, commoninde0_.DOCUMENT_ID as DOCUMENT3_21_3_, commoninde0_.COMMON_INDEX_ID as COMMON4_21_3_, commoninde1_.ID as ID14_0_, commoninde1_.INDEX_KEY as INDEX2_14_0_, commoninde1_.VALIDATION_EXPRESSION as VALIDATION3_14_0_, commoninde1_.CREATION_DATE as CREATION4_14_0_, commoninde1_.description as descript5_14_0_, commoninde1_.USER_ID as USER6_14_0_, commoninde1_.PARAM_TYPE_ID as PARAM7_14_0_, commoninde1_.INPUT_TYPE_ID as INPUT8_14_0_, paramtype2_.ID as ID16_1_, paramtype2_.description as descript2_16_1_, inputtype3_.ID as ID18_2_, inputtype3_.description as descript2_18_2_ from GD_COMMON_INDEX_VALUE commoninde0_ inner join GD_COMMON_INDEX commoninde1_ on commoninde0_.COMMON_INDEX_ID=commoninde1_.ID left outer join GD_PARAM_TYPE paramtype2_ on commoninde1_.PARAM_TYPE_ID=paramtype2_.ID left outer join GD_INPUT_TYPE inputtype3_ on commoninde1_.INPUT_TYPE_ID=inputtype3_.ID where commoninde0_.DOCUMENT_ID=?
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] preparing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] binding '191' to parameter: 1
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result set contains (possibly empty) collection: [it.noema.ged.model.Document.commonIndexValues#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] uninitialized collection: initializing
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] processing result set
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] done processing result set (0 rows)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] closing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] total objects hydrated: 0
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] 1 collections were found in result set for role: it.noema.ged.model.Document.commonIndexValues
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] collection fully initialized: [it.noema.ged.model.Document.commonIndexValues#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] 1 collections initialized for role: it.noema.ged.model.Document.commonIndexValues
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] done loading collection
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] collection initialized
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] initializing collection [it.noema.ged.model.Document.indexParamValues#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] checking second-level cache
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] collection not cached
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] loading collection: [it.noema.ged.model.Document.indexParamValues#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] select indexparam0_.DOCUMENT_ID as DOCUMENT3_4_, indexparam0_.ID as ID4_, indexparam0_.ID as ID20_3_, indexparam0_.PARAM_VALUE as PARAM2_20_3_, indexparam0_.DOCUMENT_ID as DOCUMENT3_20_3_, indexparam0_.IDX_PARAM_ID as IDX4_20_3_, indexparam1_.ID as ID13_0_, indexparam1_.PARAM_KEY as PARAM2_13_0_, indexparam1_.VALIDATION_EXPRESSION as VALIDATION3_13_0_, indexparam1_.CREATION_DATE as CREATION4_13_0_, indexparam1_.description as descript5_13_0_, indexparam1_.USER_ID as USER6_13_0_, indexparam1_.DOCUMENT_TYPE_ID as DOCUMENT7_13_0_, indexparam1_.PARAM_TYPE_ID as PARAM8_13_0_, documentty2_.ID as ID11_1_, documentty2_.USER_ID as USER2_11_1_, documentty2_.description as descript3_11_1_, documentty2_.CREATION_DATE as CREATION4_11_1_, documentty2_.ASSOCIATED_ICON as ASSOCIATED5_11_1_, documentty2_.ASSOCIATED_ICON_LOCKED as ASSOCIATED6_11_1_, documentty2_.note as note11_1_, paramtype3_.ID as ID16_2_, paramtype3_.description as descript2_16_2_ from GD_INDEX_PARAM_VALUE indexparam0_ inner join GD_INDEX_PARAM indexparam1_ on indexparam0_.IDX_PARAM_ID=indexparam1_.ID left outer join GD_DOCUMENT_TYPE documentty2_ on indexparam1_.DOCUMENT_TYPE_ID=documentty2_.ID left outer join GD_PARAM_TYPE paramtype3_ on indexparam1_.PARAM_TYPE_ID=paramtype3_.ID where indexparam0_.DOCUMENT_ID=?
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] preparing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] binding '191' to parameter: 1
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result set contains (possibly empty) collection: [it.noema.ged.model.Document.indexParamValues#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] uninitialized collection: initializing
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] processing result set
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] done processing result set (0 rows)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] closing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] total objects hydrated: 0
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] 1 collections were found in result set for role: it.noema.ged.model.Document.indexParamValues
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] collection fully initialized: [it.noema.ged.model.Document.indexParamValues#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] 1 collections initialized for role: it.noema.ged.model.Document.indexParamValues
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] done loading collection
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] collection initialized
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] initializing collection [it.noema.ged.model.Document.versions#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] checking second-level cache
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] collection not cached
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] loading collection: [it.noema.ged.model.Document.versions#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] select versions0_.DOCUMENT_ID as DOCUMENT12_2_, versions0_.ID as ID2_, versions0_.ID as ID10_1_, versions0_.description as descript2_10_1_, versions0_.version as version10_1_, versions0_.CREATION_DATE as CREATION4_10_1_, versions0_.CONTENT_SIZE as CONTENT5_10_1_, versions0_.SIGNED as SIGNED10_1_, versions0_.INDEXED as INDEXED10_1_, versions0_.SUCCESSFULLY_INDEXED as SUCCESSF8_10_1_, versions0_.DOCUMENT_STATE_ID as DOCUMENT9_10_1_, versions0_.USER_ID as USER10_10_1_, versions0_.FILE_NAME as FILE11_10_1_, versions0_.DOCUMENT_ID as DOCUMENT12_10_1_, documentst1_.ID as ID19_0_, documentst1_.description as descript2_19_0_ from GD_VERSION versions0_ left outer join GD_DOCUMENT_STATE documentst1_ on versions0_.DOCUMENT_STATE_ID=documentst1_.ID where versions0_.DOCUMENT_ID=?
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] preparing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] binding '191' to parameter: 1
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result set contains (possibly empty) collection: [it.noema.ged.model.Document.versions#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] uninitialized collection: initializing
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] processing result set
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result set row: 0
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: ID19_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '153' as column: ID10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result row: EntityKey[it.noema.ged.model.DocumentState#1], EntityKey[it.noema.ged.model.Version#153]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'Approvato' as column: descript2_19_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.Version#153]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.Version#153]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '' as column: descript2_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '5' as column: version10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2006-12-13 20:57:03' as column: CREATION4_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '31' as column: CONTENT5_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'false' as column: SIGNED10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'true' as column: INDEXED10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'true' as column: SUCCESSF8_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: DOCUMENT9_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'federicac' as column: USER10_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'txt07.txt' as column: FILE11_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '191' as column: DOCUMENT12_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '191' as column: DOCUMENT12_2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] found row of collection: [it.noema.ged.model.Document.versions#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] reading row
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '153' as column: ID2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.Version#153]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.Version#153]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.Version#153]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result set row: 1
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: ID19_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '144' as column: ID10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result row: EntityKey[it.noema.ged.model.DocumentState#1], EntityKey[it.noema.ged.model.Version#144]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.Version#144]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.Version#144]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '' as column: descript2_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '6' as column: version10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2006-12-13 20:57:19' as column: CREATION4_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '31' as column: CONTENT5_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'false' as column: SIGNED10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'true' as column: INDEXED10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'true' as column: SUCCESSF8_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: DOCUMENT9_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'federicac' as column: USER10_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'txt07.txt' as column: FILE11_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '191' as column: DOCUMENT12_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '191' as column: DOCUMENT12_2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] found row of collection: [it.noema.ged.model.Document.versions#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] reading row
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '144' as column: ID2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.Version#144]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.Version#144]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.Version#144]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result set row: 2
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: ID19_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '302' as column: ID10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result row: EntityKey[it.noema.ged.model.DocumentState#1], EntityKey[it.noema.ged.model.Version#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.Version#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.Version#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '' as column: descript2_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '6' as column: version10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2006-12-14 13:28:43' as column: CREATION4_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '31' as column: CONTENT5_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'false' as column: SIGNED10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'true' as column: INDEXED10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'true' as column: SUCCESSF8_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: DOCUMENT9_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'federicac' as column: USER10_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'txt07.txt' as column: FILE11_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '191' as column: DOCUMENT12_10_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '191' as column: DOCUMENT12_2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] found row of collection: [it.noema.ged.model.Document.versions#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] reading row
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '302' as column: ID2_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.Version#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.Version#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.Version#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] done processing result set (3 rows)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] closing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] total objects hydrated: 4
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] resolving associations for [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] done materializing entity [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] resolving associations for [it.noema.ged.model.Version#153]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] creating collection wrapper:[it.noema.ged.model.Version.integrationParameters#153]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] done materializing entity [it.noema.ged.model.Version#153]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] resolving associations for [it.noema.ged.model.Version#144]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] creating collection wrapper:[it.noema.ged.model.Version.integrationParameters#144]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] done materializing entity [it.noema.ged.model.Version#144]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] resolving associations for [it.noema.ged.model.Version#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.DocumentState#1]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.Document#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] creating collection wrapper:[it.noema.ged.model.Version.integrationParameters#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] done materializing entity [it.noema.ged.model.Version#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] 1 collections were found in result set for role: it.noema.ged.model.Document.versions
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] collection fully initialized: [it.noema.ged.model.Document.versions#191]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] 1 collections initialized for role: it.noema.ged.model.Document.versions
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] done loading collection
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] collection initialized
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] initializing collection [it.noema.ged.model.Version.integrationParameters#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] checking second-level cache
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] collection not cached
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] loading collection: [it.noema.ged.model.Version.integrationParameters#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] select integratio0_.VERSION_ID as VERSION4_1_, integratio0_.ID as ID1_, integratio0_.ID as ID15_0_, integratio0_.INT_PARAM_KEY as INT2_15_0_, integratio0_.INT_PARAM_VALUE as INT3_15_0_, integratio0_.VERSION_ID as VERSION4_15_0_ from GD_INTEGRATION_PARAM integratio0_ where integratio0_.VERSION_ID=?
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] preparing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] binding '302' to parameter: 1
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result set contains (possibly empty) collection: [it.noema.ged.model.Version.integrationParameters#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] uninitialized collection: initializing
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] processing result set
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result set row: 0
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '272' as column: ID15_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result row: EntityKey[it.noema.ged.model.IntegrationParameter#272]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.IntegrationParameter#272]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.IntegrationParameter#272]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'ROOT_ID' as column: INT2_15_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '3' as column: INT3_15_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '302' as column: VERSION4_15_0_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '302' as column: VERSION4_1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] found row of collection: [it.noema.ged.model.Version.integrationParameters#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] reading row
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '272' as column: ID1_
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.IntegrationParameter#272]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.IntegrationParameter#272]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.IntegrationParameter#272]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] done processing result set (1 rows)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] closing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] total objects hydrated: 1
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] resolving associations for [it.noema.ged.model.IntegrationParameter#272]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] loading entity: [it.noema.ged.model.Version#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] attempting to resolve: [it.noema.ged.model.Version#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultLoadEventListener] resolved object in session cache: [it.noema.ged.model.Version#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] done materializing entity [it.noema.ged.model.IntegrationParameter#272]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] 1 collections were found in result set for role: it.noema.ged.model.Version.integrationParameters
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] collection fully initialized: [it.noema.ged.model.Version.integrationParameters#302]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[CollectionLoadContext] 1 collections initialized for role: it.noema.ged.model.Version.integrationParameters
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] done loading collection
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] collection initialized
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] initializing collection [it.noema.ged.model.Version.integrationParameters#144]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] checking second-level cache
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[DefaultInitializeCollectionEventListener] collection not cached
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] loading collection: [it.noema.ged.model.Version.integrationParameters#144]
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] select integratio0_.VERSION_ID as VERSION4_1_, integratio0_.ID as ID1_, integratio0_.ID as ID15_0_, integratio0_.INT_PARAM_KEY as INT2_15_0_, integratio0_.INT_PARAM_VALUE as INT3_15_0_, integratio0_.VERSION_ID as VERSION4_15_0_ from GD_INTEGRATION_PARAM integratio0_ where integratio0_.VERSION_ID=?
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] preparing statement
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] binding '144' to parameter: 1
[http-10020-Processor23]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[SessionImpl] opened session at timestamp: 4776343296983040
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 1)
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[ConnectionManager] opening JDBC connection
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] select this_.ID as ID10_4_, this_.description as descript2_10_4_, this_.version as version10_4_, this_.CREATION_DATE as CREATION4_10_4_, this_.CONTENT_SIZE as CONTENT5_10_4_, this_.SIGNED as SIGNED10_4_, this_.INDEXED as INDEXED10_4_, this_.SUCCESSFULLY_INDEXED as SUCCESSF8_10_4_, this_.DOCUMENT_STATE_ID as DOCUMENT9_10_4_, this_.USER_ID as USER10_10_4_, this_.FILE_NAME as FILE11_10_4_, this_.DOCUMENT_ID as DOCUMENT12_10_4_, documentst2_.ID as ID19_0_, documentst2_.description as descript2_19_0_, document3_.id as ID0_1_, document3_1_.COMPONENT_NAME as COMPONENT2_0_1_, document3_1_.DESCRIPTION as DESCRIPT3_0_1_, document3_1_.CREATION_DATE as CREATION4_0_1_, document3_1_.USER_ID as USER5_0_1_, document3_1_.parent_id as parent6_0_1_, document3_.DOCUMENT_TYPE_ID as DOCUMENT2_5_1_, document3_.LOCK_OWNER as LOCK3_5_1_, document3_.LOCKED as LOCKED5_1_, composite4_.id as ID0_2_, composite4_1_.COMPONENT_NAME as COMPONENT2_0_2_, composite4_1_.DESCRIPTION as DESCRIPT3_0_2_, composite4_1_.CREATION_DATE as CREATION4_0_2_, composite4_1_.USER_ID as USER5_0_2_, composite4_1_.parent_id as parent6_0_2_, composite4_3_.ROOT_TYPE as ROOT2_3_2_, case when composite4_2_.id is not null then 2 when composite4_3_.id is not null then 3 when composite4_4_.id is not null then 4 when composite4_.id is not null then 1 end as clazz_2_, documentty5_.ID as ID11_3_, documentty5_.USER_ID as USER2_11_3_, documentty5_.description as descript3_11_3_, documentty5_.CREATION_DATE as CREATION4_11_3_, documentty5_.ASSOCIATED_ICON as ASSOCIATED5_11_3_, documentty5_.ASSOCIATED_ICON_LOCKED as ASSOCIATED6_11_3_, documentty5_.note as note11_3_ from GD_VERSION this_ left outer join GD_DOCUMENT_STATE documentst2_ on this_.DOCUMENT_STATE_ID=documentst2_.ID inner join GD_DOCUMENT document3_ on this_.DOCUMENT_ID=document3_.id left outer join GD_BASE_COMPONENT document3_1_ on document3_.id=document3_1_.ID left outer join GD_COMPOSITE composite4_ on document3_1_.parent_id=composite4_.id left outer join GD_BASE_COMPONENT composite4_1_ on composite4_.id=composite4_1_.ID left outer join GD_FOLDER composite4_2_ on composite4_.id=composite4_2_.id left outer join GD_ROOT composite4_3_ on composite4_.id=composite4_3_.id left outer join GD_ARCHIVE composite4_4_ on composite4_.id=composite4_4_.id left outer join GD_DOCUMENT_TYPE documentty5_ on document3_.DOCUMENT_TYPE_ID=documentty5_.ID where this_.INDEXED=? and this_.SUCCESSFULLY_INDEXED=?
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] preparing statement
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] binding 'true' to parameter: 1
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] binding 'false' to parameter: 2
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] processing result set
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result set row: 0
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: ID19_0_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '51' as column: ID0_1_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '12' as column: ID0_2_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: ID11_3_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '41' as column: ID10_4_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] result row: EntityKey[it.noema.ged.model.DocumentState#1], EntityKey[it.noema.ged.model.Document#51], EntityKey[it.noema.ged.model.Composite#12], EntityKey[it.noema.ged.model.DocumentType#1], EntityKey[it.noema.ged.model.Version#41]
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.DocumentState#1]
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.DocumentState#1]
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'Approvato' as column: descript2_19_0_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.Document#51]
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.Document#51]
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'default_type.gif' as column: COMPONENT2_0_1_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '' as column: DESCRIPT3_0_1_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2006-10-26 13:32:07' as column: CREATION4_0_1_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'luigic' as column: USER5_0_1_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '12' as column: parent6_0_1_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: DOCUMENT2_5_1_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning null as column: LOCK3_5_1_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'false' as column: LOCKED5_1_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2' as column: clazz_2_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.Folder#12]
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.Folder#12]
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'Cliente 2' as column: COMPONENT2_0_2_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'gg-test2' as column: DESCRIPT3_0_2_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2006-10-24 19:03:57' as column: CREATION4_0_2_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'luigic' as column: USER5_0_2_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '3' as column: parent6_0_2_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.DocumentType#1]
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.DocumentType#1]
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'Admin' as column: USER2_11_3_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'Generico' as column: descript3_11_3_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2006-10-23 12:50:04' as column: CREATION4_11_3_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'c7c9c6b8b9e1948094802284804646468080800404047f7f7f7f7f7f808080808080808080a179848180808480ac80808080948094808083c9c83a5c7e7009c9eba4e2682d010899378143a715d5f62c47a9f2c06be494ba8d317bf6f2c3d7a8dc0f915a89cfb5e0eee664a1d321252ff9e4b625c400f64b45aed8607070c2aebf9280bb' as column: ASSOCIATED5_11_3_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'c7c9c6b8b9e1948094807780807f80808080800404047f8f8f7f7f7f4646467f73737ef9f97ea2a27f4e4e7ed4d47f36368080807f1e1e7ec8c87f5a5a7e05057ee1e17eeded7ebcbc7f6767808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080808080a179848180808180ac80808080948094808088308081889cc8302041808893aadc18d0a0c28190a3cae4b88040c38298b3e2aca0a021018388ac869020d1e381829d93a8d860f0a4ca09a49948ec6060c10016a4cbea04d093a14e17a4a39a08505327481ca50756e45070a84a86929e8898baa1c18126c6afbef0b061800183939690385a7422008593a6c0d0cb12ecd6179839ce0810516dcd279041564ce977a7c62894cce23dfb9123811dfd0f96d84c38f1e204b2a3cb16dc1621e50586b3eb8e8880bb' as column: ASSOCIATED6_11_3_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'Tipo documento di default' as column: note11_3_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] Initializing object from ResultSet: [it.noema.ged.model.Version#41]
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractEntityPersister] Hydrating entity: [it.noema.ged.model.Version#41]
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '' as column: descript2_10_4_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: version10_4_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '2006-10-26 13:32:07' as column: CREATION4_10_4_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '132' as column: CONTENT5_10_4_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'false' as column: SIGNED10_4_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'true' as column: INDEXED10_4_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'false' as column: SUCCESSF8_10_4_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '1' as column: DOCUMENT9_10_4_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'luigic' as column: USER10_10_4_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning 'default_type.gif' as column: FILE11_10_4_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[NullableType] returning '51' as column: DOCUMENT12_10_4_
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] done processing result set (1 rows)
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 2)
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[AbstractBatcher] closing statement
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[Loader] total objects hydrated: 5
[Thread-1]-[14-dic-2006 13:30:37]-[DEBUG]-[TwoPhaseLoad] resolving associations for [it.noema.ged.model.DocumentState#1]
[Threa
Top
 Profile  
 
ewade
 Post subject:
PostPosted: Thu Dec 14, 2006 4:38 pm 
Newbie

Joined: Tue Jul 25, 2006 6:40 pm
Posts: 6
Location: Plano, TX
So, if I understand you correctly, you have written application logic that depends on the sequencer in the database generating an id that only increases by one no matter what for a particular table. That is, if the last row in your table had an id of say 10, you must have an 11 for your next id number. If that is the case, the best solution is to change your application logic.

A database sequencer is only guaranteed to give you a number which has not been used before for an id. It does not know who is asking for the number or if the number even gets used. So, you CANNOT depend on getting numbers in sequence such as 10, 11, 12 ... Its perfectly normal to get something like 10, 11, 15, 16, 25.... Its probably showing up in the linux environment because more stuff is going on there than in your windows development envirnoment.

A simple fix is to insert your row right away then read it back to get the id number that is actually used.

Another fix is to generate your own id numbers in your application, but you'll have to check each one to be sure its not already used.

I hope I understood your issue and that this information is helpful.

Elise
Top
 Profile  
 
dastardly75
 Post subject: Problem with id generation on postgreSQL
PostPosted: Fri Dec 15, 2006 4:39 am 
Newbie

Joined: Thu Dec 14, 2006 6:59 am
Posts: 2
Thank you for the tip, I agree with that, my logic shouldn't be based upon the ids but the problem is slightly different from the one you're talking about.
My logic is not bound to a progression one by one (like 11,12,13...) but simply to an ascending progression. Also 11,15,25 would be good to me. The problem is that the sequence goes forward <b>and</b> backwards, generating a progression like 11,12,21,13,14 and this causes me a lot of problems.
Apart from the logic, this isn't a good situation and i'm trying to understand what is the cause and if it's due to that particular Postgres release because I can't reproduct the bug on any other deployment of my application as I said before.

Thanks in advance to anybody who can help me with this.
Bye

Emanuele
Top
 Profile  
 
ewade
 Post subject:
PostPosted: Mon Dec 18, 2006 11:55 am 
Newbie

Joined: Tue Jul 25, 2006 6:40 pm
Posts: 6
Location: Plano, TX
You might try setting your CACHE to 1 instead of 10 on the sequence and see if you still get the non-asending behavior. I'd suspect a transaction sequence issue. That is you are not getting commits in the order you expect.
I agree its very weird behavior!
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.