-->
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
nahmed
 Post subject: Custom SQL for loading
PostPosted: Tue Jul 26, 2005 6:20 am 
Newbie

Joined: Fri Mar 25, 2005 3:07 pm
Posts: 11
Hi,

A newbie to HIbernate, and was hoping someone would be able to help.

I just want to basically use an SP to load from the db.

Could someone be kind enough to explain what the steps are?

Please have a look at my config and my code below. I have attached the whole output, but it seems it uses its own loading SQL somehow.

Pls advise.

Thanks in advance


Hibernate version: 3.0.5

Mapping documents:
<hibernate-mapping>
<class name="com.tds.refdata.admin.Group" table="T_GROUP">

<id name="groupId" type="integer" column="id_grp_key">
<generator class="increment"/>
</id>


<property name="groupVersion" type="integer" column="id_grp_ver"/>
<property name="active" type="boolean" column="is_actv"/>
<property name="dsRegion" type="integer" column="id_ds_rgn"/>
<property name="strLastModifiedDate" type="string" column="id_lst_upd"/>
<property name="lastModifiedBy" type="string" column="dt_lst_upd_gmt"/>
<property name="groupName" type="string" column="nm_grp"/>
<property name="groupDescription" type="string" column="nm_grp_desc"/>

<loader query-ref="LoadGroup"/>

</class>

<!-- Loading SP -->
<sql-query name="LoadGroup" callable="true">
<return alias="grp" class="com.tds.refdata.admin.Group">
<return-property name="groupId" column="id_grp_key"/>
<return-property name="groupVersion" column="id_grp_ver"/>
<return-property name="active" column="is_actv"/>
<return-property name="dsRegion" column="id_ds_rgn"/>
<return-property name="strLastModifiedDate" column="id_lst_upd"/>
<return-property name="lastModifiedBy" column="dt_lst_upd_gmt"/>
<return-property name="groupName" column="nm_grp"/>
<return-property name="groupDescription" column="nm_grp_desc"/>
</return>

{ call SEL_group() }
</sql-query>

<sql-query name="LoadGroup2">
<return alias="grp" class="com.tds.refdata.admin.Group" />
<return-scalar column="id_grp_key" type="integer"/>
<return-scalar column="nm_group" type="string"/>
SELECT grp.id_grp_key, grp.nm_grp FROM T_GROUP grp
</sql-query>


</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():
Session session = HibernateUtils.openSession();
Transaction tx = session.beginTransaction();
groupList = session.createQuery("from Group").list();
//groupList = session.getNamedQuery("LoadGroup2").list();
tx.commit();
HibernateUtils.closeSession();

Full stack trace of any exception that occurs:


Name and version of the database you are using: SQL Server 2000

The generated SQL (show_sql=true):
[2005-07-26 19:14:46,900] DEBUG [main] (QueryTranslatorImpl.java:207) - parse() - HQL: from com.tds.refdata.admin.Group
[2005-07-26 19:14:47,041] DEBUG [main] (HqlSqlWalker.java:331) - processQuery() : ( SELECT ( FromClause{level=1} dbo.T_GROUP group0_ ) )

Debug level Hibernate log excerpt:
init:
deps-module-jar:
deps-ear-jar:
deps-jar:
compile-single:
run-main:
[2005-07-26 19:19:58,208] DEBUG [main] (GroupAdmin.java:48) - Loading group
[2005-07-26 19:19:58,255] INFO [main] (Environment.java:464) - Hibernate 3.0.5
[2005-07-26 19:19:58,255] INFO [main] (Environment.java:477) - hibernate.properties not found
[2005-07-26 19:19:58,255] INFO [main] (Environment.java:510) - using CGLIB reflection optimizer
[2005-07-26 19:19:58,255] INFO [main] (Environment.java:540) - using JDK 1.4 java.sql.Timestamp handling
[2005-07-26 19:19:58,317] INFO [main] (Configuration.java:1110) - configuring from resource: /hibernate.cfg.xml
[2005-07-26 19:19:58,317] INFO [main] (Configuration.java:1081) - Configuration resource: /hibernate.cfg.xml
[2005-07-26 19:19:58,552] DEBUG [main] (DTDEntityResolver.java:42) - trying to locate http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath under org/hibernate/
[2005-07-26 19:19:58,552] DEBUG [main] (DTDEntityResolver.java:53) - found http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath
[2005-07-26 19:19:58,598] DEBUG [main] (Configuration.java:1067) - hibernate.connection.driver_class=com.microsoft.jdbc.sqlserver.SQLServerDriver
[2005-07-26 19:19:58,598] DEBUG [main] (Configuration.java:1067) - hibernate.dialect=org.hibernate.dialect.SQLServerDialect
[2005-07-26 19:19:58,598] DEBUG [main] (Configuration.java:1067) - hibernate.connection.url=jdbc:microsoft:sqlserver://localhost:1433
[2005-07-26 19:19:58,598] DEBUG [main] (Configuration.java:1067) - hibernate.connection.username=saRef
[2005-07-26 19:19:58,598] DEBUG [main] (Configuration.java:1067) - hibernate.connection.password=saRef
[2005-07-26 19:19:58,614] DEBUG [main] (Configuration.java:1067) - hibernate.connection.DatabaseName=REF
[2005-07-26 19:19:58,614] DEBUG [main] (Configuration.java:1067) - hibernate.jdbc.fetch_size=200
[2005-07-26 19:19:58,614] DEBUG [main] (Configuration.java:1067) - hibernate.connection.selectMethod=cursor
[2005-07-26 19:19:58,614] DEBUG [main] (Configuration.java:1067) - hibernate.default_schema=dbo
[2005-07-26 19:19:58,614] DEBUG [main] (Configuration.java:1067) - hibernate.show_sql=false
[2005-07-26 19:19:58,614] DEBUG [main] (Configuration.java:1067) - hibernate.use_sql_comments=false
[2005-07-26 19:19:58,614] DEBUG [main] (Configuration.java:1067) - hibernate.c3p0.max_size=5
[2005-07-26 19:19:58,614] DEBUG [main] (Configuration.java:1067) - hibernate.c3p0.min_size=1
[2005-07-26 19:19:58,614] DEBUG [main] (Configuration.java:1262) - null<-org.dom4j.tree.DefaultAttribute@3e89c3 [Attribute: name resource value "Group.hbm.xml"]
[2005-07-26 19:19:58,630] INFO [main] (Configuration.java:444) - Mapping resource: Group.hbm.xml
[2005-07-26 19:19:58,630] DEBUG [main] (DTDEntityResolver.java:42) - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
[2005-07-26 19:19:58,630] DEBUG [main] (DTDEntityResolver.java:53) - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
[2005-07-26 19:19:58,755] INFO [main] (HbmBinder.java:260) - Mapping class: com.tds.refdata.admin.Group -> T_GROUP
[2005-07-26 19:19:58,770] DEBUG [main] (HbmBinder.java:1099) - Mapped property: groupId -> id_grp_key
[2005-07-26 19:19:58,802] DEBUG [main] (HbmBinder.java:1099) - Mapped property: groupVersion -> id_grp_ver
[2005-07-26 19:19:58,802] DEBUG [main] (HbmBinder.java:1099) - Mapped property: active -> is_actv
[2005-07-26 19:19:58,802] DEBUG [main] (HbmBinder.java:1099) - Mapped property: dsRegion -> id_ds_rgn
[2005-07-26 19:19:58,817] DEBUG [main] (HbmBinder.java:1099) - Mapped property: strLastModifiedDate -> id_lst_upd
[2005-07-26 19:19:58,833] DEBUG [main] (HbmBinder.java:1099) - Mapped property: lastModifiedBy -> dt_lst_upd_gmt
[2005-07-26 19:19:58,833] DEBUG [main] (HbmBinder.java:1099) - Mapped property: groupName -> nm_grp
[2005-07-26 19:19:58,848] DEBUG [main] (HbmBinder.java:1099) - Mapped property: groupDescription -> nm_grp_desc
[2005-07-26 19:19:58,880] DEBUG [main] (HbmBinder.java:2432) - Named SQL query: LoadGroup -> { call SEL_group() }
[2005-07-26 19:19:58,927] DEBUG [main] (HbmBinder.java:2432) - Named SQL query: LoadGroup2 -> SELECT grp.id_grp_key, grp.nm_grp FROM T_GROUP grp
[2005-07-26 19:19:58,927] INFO [main] (Configuration.java:1222) - Configured SessionFactory: null
[2005-07-26 19:19:58,927] DEBUG [main] (Configuration.java:1223) - properties: {hibernate.connection.password=saRef, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.default_schema=dbo, sun.boot.library.path=C:\Apps\jdk\1.5.0_02\jre\bin, java.vm.version=1.5.0_02-b09, hibernate.connection.username=saRef, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=GB, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Naz\Projects\CPGConfig, java.runtime.version=1.5.0_02-b09, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Apps\jdk\1.5.0_02\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\nahmed\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, hibernate.connection.selectMethod=cursor, hibernate.jdbc.fetch_size=200, sun.jnu.encoding=Cp1252, java.library.path=C:\Apps\jdk\1.5.0_02\jre\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Intel\Wireless\Bin\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Apps\Sun\jwsdp\1.5\jwsdp-shared\bin;C:\Apps\Sun\AppServer\8.1.01_2005Q1\bin;C:\Apps\jdk\1.5.0_02\bin;C:\Apps\GTK\2.6.7\bin, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, user.home=C:\Documents and Settings\nahmed, user.timezone=Asia/Tokyo, java.awt.printerjob=sun.awt.windows.WPrinterJob, hibernate.connection.DatabaseName=REF, file.encoding=Cp1252, java.specification.version=1.5, hibernate.c3p0.min_size=1, hibernate.connection.driver_class=com.microsoft.jdbc.sqlserver.SQLServerDriver, user.name=nahmed, java.class.path=C:\Naz\Projects\CPGConfig\build\web\WEB-INF\classes;C:\Apps\JavaLibs\log4j\1.2.9\dist\lib\log4j-1.2.9.jar;C:\Apps\JavaLibs\SqlServerJdbc\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Apps\JavaLibs\SqlServerJdbc\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Apps\JavaLibs\SqlServerJdbc\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;C:\Apps\NetBeans\4.1\enterprise1\config\TagLibraries\JSTL11\standard.jar;C:\Apps\NetBeans\4.1\enterprise1\config\TagLibraries\JSTL11\jstl.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-beanutils-1.6.1.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-codec-1.2.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-collections-3.0.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-digester-1.5.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-el.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-fileupload-1.0.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-logging.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-validator.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\jakarta-oro.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\jstl.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\myfaces-extensions.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\myfaces-impl.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\myfaces-jsf-api.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\myfaces.jar;C:\Naz\Projects\CPGConfig\src\conf;C:\Apps\JavaLibs\hibernate\3.0.5\hibernate3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\ant-1.6.3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\ant-antlr-1.6.3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\ant-junit-1.6.3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\ant-launcher-1.6.3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\ant-swing-1.6.3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\antlr-2.7.5H3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\asm-attrs.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\asm.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\c3p0-0.8.5.2.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\cglib-2.1.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\cleanimports.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\commons-collections-2.1.1.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\commons-logging-1.0.4.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\concurrent-1.3.2.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\connector.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\dom4j-1.6.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\ehcache-1.1.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jaas.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jacc-1_0-fr.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jaxen-1.1-beta-4.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jboss-cache.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jboss-common.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jboss-jmx.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jboss-system.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jdbc2_0-stdext.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jgroups-2.2.7.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jta.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\junit-3.8.1.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\log4j-1.2.9.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\oscache-2.1.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\proxool-0.8.3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\swarmcache-1.0rc2.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\versioncheck.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\xerces-2.6.2.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\xml-apis.jar;C:\Apps\Tomcat\5.5.9\common\lib\jsp-api.jar;C:\Apps\Tomcat\5.5.9\common\lib\servlet-api.jar, hibernate.use_sql_comments=false, hibernate.show_sql=false, java.vm.specification.version=1.0, java.home=C:\Apps\jdk\1.5.0_02\jre, sun.arch.data.model=32, hibernate.connection.url=jdbc:microsoft:sqlserver://localhost:1433, hibernate.dialect=org.hibernate.dialect.SQLServerDialect, user.language=en, java.specification.vendor=Sun Microsystems Inc., hibernate.c3p0.max_size=5, awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.5.0_02, java.ext.dirs=C:\Apps\jdk\1.5.0_02\jre\lib\ext, sun.boot.class.path=C:\Apps\jdk\1.5.0_02\jre\lib\rt.jar;C:\Apps\jdk\1.5.0_02\jre\lib\i18n.jar;C:\Apps\jdk\1.5.0_02\jre\lib\sunrsasign.jar;C:\Apps\jdk\1.5.0_02\jre\lib\jsse.jar;C:\Apps\jdk\1.5.0_02\jre\lib\jce.jar;C:\Apps\jdk\1.5.0_02\jre\lib\charsets.jar;C:\Apps\jdk\1.5.0_02\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86}
Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@f47bf5 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@79ed7f [ acquireIncrement -> 1, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, idleConnectionTestPeriod -> 0, initialPoolSize -> 1, maxIdleTime -> 0, maxPoolSize -> 5, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 1, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@16921fd [ description -> null, driverClass -> null, factoryClassLocation -> null, jdbcUrl -> jdbc:microsoft:sqlserver://localhost:1433, properties -> {user=******, password=******, selectMethod=cursor, DatabaseName=REF} ] , preferredTestQuery -> null, propertyCycle -> 300, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, usesTraditionalReflectiveProxies -> false ] , factoryClassLocation -> null, numHelperThreads -> 3, poolOwnerIdentityToken -> f47bf5 ]
[2005-07-26 19:19:58,942] DEBUG [main] (Configuration.java:998) - Preparing to build session factory with filters : {}
[2005-07-26 19:19:58,942] INFO [main] (Configuration.java:875) - processing extends queue
[2005-07-26 19:19:58,942] INFO [main] (Configuration.java:879) - processing collection mappings
[2005-07-26 19:19:58,942] INFO [main] (Configuration.java:888) - processing association property references
[2005-07-26 19:19:58,942] INFO [main] (Configuration.java:917) - processing foreign key constraints
[2005-07-26 19:19:58,989] INFO [main] (C3P0ConnectionProvider.java:50) - C3P0 using driver: com.microsoft.jdbc.sqlserver.SQLServerDriver at URL: jdbc:microsoft:sqlserver://localhost:1433
[2005-07-26 19:19:58,989] INFO [main] (C3P0ConnectionProvider.java:51) - Connection properties: {user=saRef, password=****, selectMethod=cursor, DatabaseName=REF}
[2005-07-26 19:19:58,989] INFO [main] (C3P0ConnectionProvider.java:54) - autocommit mode: false
[2005-07-26 19:19:59,380] DEBUG [main] (SettingsFactory.java:295) - could not get database version from JDBC metadata
[2005-07-26 19:19:59,489] INFO [main] (SettingsFactory.java:77) - RDBMS: Microsoft SQL Server, version: Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

[2005-07-26 19:19:59,489] INFO [main] (SettingsFactory.java:78) - JDBC driver: SQLServer, version: 2.2.0040
[2005-07-26 19:19:59,505] INFO [main] (Dialect.java:92) - Using dialect: org.hibernate.dialect.SQLServerDialect
[2005-07-26 19:19:59,598] INFO [main] (TransactionFactoryFactory.java:31) - Using default transaction strategy (direct JDBC transactions)
[2005-07-26 19:19:59,598] INFO [main] (TransactionManagerLookupFactory.java:33) - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
[2005-07-26 19:19:59,598] INFO [main] (SettingsFactory.java:125) - Automatic flush during beforeCompletion(): disabled
[2005-07-26 19:19:59,598] INFO [main] (SettingsFactory.java:129) - Automatic session close at end of transaction: disabled
[2005-07-26 19:19:59,708] INFO [main] (SettingsFactory.java:144) - Scrollable result sets: enabled
[2005-07-26 19:19:59,708] DEBUG [main] (SettingsFactory.java:148) - Wrap result sets: disabled
[2005-07-26 19:19:59,708] INFO [main] (SettingsFactory.java:152) - JDBC3 getGeneratedKeys(): disabled
[2005-07-26 19:19:59,708] INFO [main] (SettingsFactory.java:156) - JDBC result set fetch size: 200
[2005-07-26 19:19:59,708] INFO [main] (SettingsFactory.java:160) - Connection release mode: null
[2005-07-26 19:19:59,708] INFO [main] (SettingsFactory.java:178) - Default schema: dbo
[2005-07-26 19:19:59,770] INFO [main] (SettingsFactory.java:187) - Default batch fetch size: 1
[2005-07-26 19:19:59,770] INFO [main] (SettingsFactory.java:191) - Generate SQL with comments: disabled
[2005-07-26 19:19:59,770] INFO [main] (SettingsFactory.java:195) - Order SQL updates by primary key: disabled
[2005-07-26 19:19:59,770] INFO [main] (SettingsFactory.java:334) - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
[2005-07-26 19:19:59,770] INFO [main] (ASTQueryTranslatorFactory.java:21) - Using ASTQueryTranslatorFactory
[2005-07-26 19:19:59,848] INFO [main] (SettingsFactory.java:203) - Query language substitutions: {}
[2005-07-26 19:19:59,848] INFO [main] (SettingsFactory.java:209) - Second-level cache: enabled
[2005-07-26 19:19:59,848] INFO [main] (SettingsFactory.java:213) - Query cache: disabled
[2005-07-26 19:19:59,848] INFO [main] (SettingsFactory.java:321) - Cache provider: org.hibernate.cache.EhCacheProvider
[2005-07-26 19:19:59,848] INFO [main] (SettingsFactory.java:228) - Optimize cache for minimal puts: disabled
[2005-07-26 19:19:59,911] INFO [main] (SettingsFactory.java:237) - Structured second-level cache entries: disabled
[2005-07-26 19:19:59,911] DEBUG [main] (SQLExceptionConverterFactory.java:52) - Using dialect defined converter
[2005-07-26 19:19:59,911] INFO [main] (SettingsFactory.java:261) - Statistics: disabled
[2005-07-26 19:19:59,911] INFO [main] (SettingsFactory.java:265) - Deleted entity synthetic identifier rollback: disabled
[2005-07-26 19:19:59,911] INFO [main] (SettingsFactory.java:279) - Default entity-mode: pojo
[2005-07-26 19:20:00,067] INFO [main] (SessionFactoryImpl.java:152) - building session factory
[2005-07-26 19:20:00,067] DEBUG [main] (SessionFactoryImpl.java:161) - Session factory constructed with filter configurations : {}
[2005-07-26 19:20:00,067] DEBUG [main] (SessionFactoryImpl.java:164) - instantiating session factory with properties: {hibernate.connection.password=saRef, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.default_schema=dbo, sun.boot.library.path=C:\Apps\jdk\1.5.0_02\jre\bin, java.vm.version=1.5.0_02-b09, hibernate.connection.username=saRef, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=GB, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\Naz\Projects\CPGConfig, java.runtime.version=1.5.0_02-b09, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\Apps\jdk\1.5.0_02\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\nahmed\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, hibernate.connection.selectMethod=cursor, hibernate.jdbc.fetch_size=200, sun.jnu.encoding=Cp1252, java.library.path=C:\Apps\jdk\1.5.0_02\jre\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Intel\Wireless\Bin\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Apps\Sun\jwsdp\1.5\jwsdp-shared\bin;C:\Apps\Sun\AppServer\8.1.01_2005Q1\bin;C:\Apps\jdk\1.5.0_02\bin;C:\Apps\GTK\2.6.7\bin, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=5.1, user.home=C:\Documents and Settings\nahmed, user.timezone=Asia/Tokyo, java.awt.printerjob=sun.awt.windows.WPrinterJob, hibernate.connection.DatabaseName=REF, file.encoding=Cp1252, java.specification.version=1.5, hibernate.c3p0.min_size=1, hibernate.connection.driver_class=com.microsoft.jdbc.sqlserver.SQLServerDriver, user.name=nahmed, java.class.path=C:\Naz\Projects\CPGConfig\build\web\WEB-INF\classes;C:\Apps\JavaLibs\log4j\1.2.9\dist\lib\log4j-1.2.9.jar;C:\Apps\JavaLibs\SqlServerJdbc\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Apps\JavaLibs\SqlServerJdbc\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Apps\JavaLibs\SqlServerJdbc\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;C:\Apps\NetBeans\4.1\enterprise1\config\TagLibraries\JSTL11\standard.jar;C:\Apps\NetBeans\4.1\enterprise1\config\TagLibraries\JSTL11\jstl.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-beanutils-1.6.1.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-codec-1.2.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-collections-3.0.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-digester-1.5.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-el.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-fileupload-1.0.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-logging.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\commons-validator.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\jakarta-oro.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\jstl.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\myfaces-extensions.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\myfaces-impl.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\myfaces-jsf-api.jar;C:\Apps\JavaLibs\MyFaces\1.0.9\lib\myfaces.jar;C:\Naz\Projects\CPGConfig\src\conf;C:\Apps\JavaLibs\hibernate\3.0.5\hibernate3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\ant-1.6.3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\ant-antlr-1.6.3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\ant-junit-1.6.3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\ant-launcher-1.6.3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\ant-swing-1.6.3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\antlr-2.7.5H3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\asm-attrs.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\asm.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\c3p0-0.8.5.2.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\cglib-2.1.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\cleanimports.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\commons-collections-2.1.1.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\commons-logging-1.0.4.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\concurrent-1.3.2.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\connector.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\dom4j-1.6.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\ehcache-1.1.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jaas.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jacc-1_0-fr.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jaxen-1.1-beta-4.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jboss-cache.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jboss-common.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jboss-jmx.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jboss-system.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jdbc2_0-stdext.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jgroups-2.2.7.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\jta.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\junit-3.8.1.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\log4j-1.2.9.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\oscache-2.1.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\proxool-0.8.3.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\swarmcache-1.0rc2.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\versioncheck.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\xerces-2.6.2.jar;C:\Apps\JavaLibs\hibernate\3.0.5\lib\xml-apis.jar;C:\Apps\Tomcat\5.5.9\common\lib\jsp-api.jar;C:\Apps\Tomcat\5.5.9\common\lib\servlet-api.jar, hibernate.use_sql_comments=false, hibernate.show_sql=false, java.vm.specification.version=1.0, java.home=C:\Apps\jdk\1.5.0_02\jre, sun.arch.data.model=32, hibernate.connection.url=jdbc:microsoft:sqlserver://localhost:1433, hibernate.dialect=org.hibernate.dialect.SQLServerDialect, user.language=en, java.specification.vendor=Sun Microsystems Inc., hibernate.c3p0.max_size=5, awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.5.0_02, java.ext.dirs=C:\Apps\jdk\1.5.0_02\jre\lib\ext, sun.boot.class.path=C:\Apps\jdk\1.5.0_02\jre\lib\rt.jar;C:\Apps\jdk\1.5.0_02\jre\lib\i18n.jar;C:\Apps\jdk\1.5.0_02\jre\lib\sunrsasign.jar;C:\Apps\jdk\1.5.0_02\jre\lib\jsse.jar;C:\Apps\jdk\1.5.0_02\jre\lib\jce.jar;C:\Apps\jdk\1.5.0_02\jre\lib\charsets.jar;C:\Apps\jdk\1.5.0_02\jre\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86}
[2005-07-26 19:20:00,130] DEBUG [main] (CacheManager.java:191) - Creating new CacheManager with default config
[2005-07-26 19:20:00,130] DEBUG [main] (CacheManager.java:164) - Configuring ehcache from classpath.
[2005-07-26 19:20:00,130] WARN [main] (Configurator.java:126) - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/Apps/JavaLibs/hibernate/3.0.5/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
[2005-07-26 19:20:00,145] DEBUG [main] (Configuration.java:185) - Disk Store Path: C:\DOCUME~1\nahmed\LOCALS~1\Temp\
[2005-07-26 19:20:00,427] DEBUG [main] (BasicEntityPersister.java:2220) - Static SQL for entity: com.tds.refdata.admin.Group
[2005-07-26 19:20:00,427] DEBUG [main] (BasicEntityPersister.java:2222) - Version select: select id_grp_key from dbo.T_GROUP where id_grp_key =?
[2005-07-26 19:20:00,427] DEBUG [main] (BasicEntityPersister.java:2223) - Snapshot select: select group_.id_grp_key, group_.id_grp_ver as id2_0_, group_.is_actv as is3_0_, group_.id_ds_rgn as id4_0_, group_.id_lst_upd as id5_0_, group_.dt_lst_upd_gmt as dt6_0_, group_.nm_grp as nm7_0_, group_.nm_grp_desc as nm8_0_ from dbo.T_GROUP group_ where group_.id_grp_key=?
[2005-07-26 19:20:00,505] DEBUG [main] (BasicEntityPersister.java:2225) - Insert 0: insert into dbo.T_GROUP (id_grp_ver, is_actv, id_ds_rgn, id_lst_upd, dt_lst_upd_gmt, nm_grp, nm_grp_desc, id_grp_key) values (?, ?, ?, ?, ?, ?, ?, ?)
[2005-07-26 19:20:00,505] DEBUG [main] (BasicEntityPersister.java:2226) - Update 0: update dbo.T_GROUP set id_grp_ver=?, is_actv=?, id_ds_rgn=?, id_lst_upd=?, dt_lst_upd_gmt=?, nm_grp=?, nm_grp_desc=? where id_grp_key=?
[2005-07-26 19:20:00,505] DEBUG [main] (BasicEntityPersister.java:2227) - Delete 0: delete from dbo.T_GROUP where id_grp_key=?
[2005-07-26 19:20:00,567] DEBUG [main] (EntityLoader.java:95) - Static select for entity com.tds.refdata.admin.Group: select group0_.id_grp_key as id1_0_, group0_.id_grp_ver as id2_0_0_, group0_.is_actv as is3_0_0_, group0_.id_ds_rgn as id4_0_0_, group0_.id_lst_upd as id5_0_0_, group0_.dt_lst_upd_gmt as dt6_0_0_, group0_.nm_grp as nm7_0_0_, group0_.nm_grp_desc as nm8_0_0_ from dbo.T_GROUP group0_ where group0_.id_grp_key=?
[2005-07-26 19:20:00,567] DEBUG [main] (EntityLoader.java:95) - Static select for entity com.tds.refdata.admin.Group: select group0_.id_grp_key as id1_0_, group0_.id_grp_ver as id2_0_0_, group0_.is_actv as is3_0_0_, group0_.id_ds_rgn as id4_0_0_, group0_.id_lst_upd as id5_0_0_, group0_.dt_lst_upd_gmt as dt6_0_0_, group0_.nm_grp as nm7_0_0_, group0_.nm_grp_desc as nm8_0_0_ from dbo.T_GROUP group0_ where group0_.id_grp_key=?
[2005-07-26 19:20:00,630] DEBUG [main] (EntityLoader.java:95) - Static select for entity com.tds.refdata.admin.Group: select group0_.id_grp_key as id1_0_, group0_.id_grp_ver as id2_0_0_, group0_.is_actv as is3_0_0_, group0_.id_ds_rgn as id4_0_0_, group0_.id_lst_upd as id5_0_0_, group0_.dt_lst_upd_gmt as dt6_0_0_, group0_.nm_grp as nm7_0_0_, group0_.nm_grp_desc as nm8_0_0_ from dbo.T_GROUP group0_ where group0_.id_grp_key=?
[2005-07-26 19:20:00,630] DEBUG [main] (EntityLoader.java:95) - Static select for entity com.tds.refdata.admin.Group: select group0_.id_grp_key as id1_0_, group0_.id_grp_ver as id2_0_0_, group0_.is_actv as is3_0_0_, group0_.id_ds_rgn as id4_0_0_, group0_.id_lst_upd as id5_0_0_, group0_.dt_lst_upd_gmt as dt6_0_0_, group0_.nm_grp as nm7_0_0_, group0_.nm_grp_desc as nm8_0_0_ from dbo.T_GROUP group0_ where group0_.id_grp_key=?
[2005-07-26 19:20:00,661] DEBUG [main] (SessionFactoryObjectFactory.java:39) - initializing class SessionFactoryObjectFactory
[2005-07-26 19:20:00,677] DEBUG [main] (SessionFactoryObjectFactory.java:76) - registered: b18b8d420552a7e8010552a7eb150000 (unnamed)
[2005-07-26 19:20:00,677] INFO [main] (SessionFactoryObjectFactory.java:82) - Not binding factory to JNDI, no JNDI name configured
[2005-07-26 19:20:00,677] DEBUG [main] (SessionFactoryImpl.java:262) - instantiated session factory
[2005-07-26 19:20:00,677] INFO [main] (SessionFactoryImpl.java:379) - Checking 0 named queries
[2005-07-26 19:20:00,786] DEBUG [main] (SessionImpl.java:250) - opened session at timestamp: 4597240630292480
[2005-07-26 19:20:00,786] DEBUG [main] (JDBCTransaction.java:46) - begin
[2005-07-26 19:20:00,786] DEBUG [main] (ConnectionManager.java:296) - opening JDBC connection
[2005-07-26 19:20:00,786] DEBUG [main] (JDBCTransaction.java:50) - current autocommit status: false
[2005-07-26 19:20:00,802] DEBUG [main] (SessionImpl.java:829) - find: from Group
[2005-07-26 19:20:00,802] DEBUG [main] (QueryParameters.java:224) - named parameters: {}
[2005-07-26 19:20:00,911] DEBUG [main] (QueryTranslatorImpl.java:207) - parse() - HQL: from com.tds.refdata.admin.Group
[2005-07-26 19:20:00,911] DEBUG [main] (HqlParser.java:277) - weakKeywords() : new LT(1) token - ["Group",<115> previously: <24>,line=1,col=28,possibleID=true]
[2005-07-26 19:20:00,911] DEBUG [main] (QueryTranslatorImpl.java:223) - --- HQL AST ---
\-[QUERY] 'query'
\-[SELECT_FROM] 'SELECT_FROM'
\-[FROM] 'from'
\-[RANGE] 'RANGE'
\-[DOT] '.'
+-[DOT] '.'
| +-[DOT] '.'
| | +-[DOT] '.'
| | | +-[IDENT] 'com'
| | | \-[IDENT] 'tds'
| | \-[IDENT] 'refdata'
| \-[IDENT] 'admin'
\-[IDENT] 'Group'

[2005-07-26 19:20:00,973] DEBUG [main] (ErrorCounter.java:72) - throwQueryException() : no errors
[2005-07-26 19:20:01,067] DEBUG [main] (HqlSqlBaseWalker.java:120) - query() << begin, level = 1
[2005-07-26 19:20:01,083] DEBUG [main] (FromElement.java:88) - FromClause{level=1} : com.tds.refdata.admin.Group (no alias) -> group0_
[2005-07-26 19:20:01,083] DEBUG [main] (HqlSqlBaseWalker.java:125) - query() : finishing up , level = 1
[2005-07-26 19:20:01,083] DEBUG [main] (HqlSqlWalker.java:331) - processQuery() : ( SELECT ( FromClause{level=1} dbo.T_GROUP group0_ ) )
[2005-07-26 19:20:01,239] DEBUG [main] (HqlSqlWalker.java:451) - Derived SELECT clause created.
[2005-07-26 19:20:01,255] DEBUG [main] (JoinProcessor.java:112) - Using FROM fragment [dbo.T_GROUP group0_]
[2005-07-26 19:20:01,255] DEBUG [main] (HqlSqlBaseWalker.java:128) - query() >> end, level = 1
[2005-07-26 19:20:01,255] DEBUG [main] (QueryTranslatorImpl.java:193) - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (dbo.T_GROUP)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| +-[SELECT_EXPR] SelectExpressionImpl: 'group0_.id_grp_key as id1_' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=dbo.T_GROUP,tableAlias=group0_,colums={,className=com.tds.refdata.admin.Group}}}
| \-[SQL_TOKEN] SqlFragment: 'group0_.id_grp_ver as id2_0_, group0_.is_actv as is3_0_, group0_.id_ds_rgn as id4_0_, group0_.id_lst_upd as id5_0_, group0_.dt_lst_upd_gmt as dt6_0_, group0_.nm_grp as nm7_0_, group0_.nm_grp_desc as nm8_0_'
\-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[], fromElementByTableAlias=[group0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
\-[FROM_FRAGMENT] FromElement: 'dbo.T_GROUP group0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=dbo.T_GROUP,tableAlias=group0_,colums={,className=com.tds.refdata.admin.Group}}

[2005-07-26 19:20:01,317] DEBUG [main] (ErrorCounter.java:72) - throwQueryException() : no errors
[2005-07-26 19:20:01,317] DEBUG [main] (QueryTranslatorImpl.java:177) - HQL: from com.tds.refdata.admin.Group
[2005-07-26 19:20:01,317] DEBUG [main] (QueryTranslatorImpl.java:178) - SQL: select group0_.id_grp_key as id1_, group0_.id_grp_ver as id2_0_, group0_.is_actv as is3_0_, group0_.id_ds_rgn as id4_0_, group0_.id_lst_upd as id5_0_, group0_.dt_lst_upd_gmt as dt6_0_, group0_.nm_grp as nm7_0_, group0_.nm_grp_desc as nm8_0_ from dbo.T_GROUP group0_
[2005-07-26 19:20:01,427] DEBUG [main] (ErrorCounter.java:72) - throwQueryException() : no errors
[2005-07-26 19:20:01,427] DEBUG [main] (AbstractBatcher.java:290) - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
[2005-07-26 19:20:01,427] DEBUG [main] (AbstractBatcher.java:324) - select group0_.id_grp_key as id1_, group0_.id_grp_ver as id2_0_, group0_.is_actv as is3_0_, group0_.id_ds_rgn as id4_0_, group0_.id_lst_upd as id5_0_, group0_.dt_lst_upd_gmt as dt6_0_, group0_.nm_grp as nm7_0_, group0_.nm_grp_desc as nm8_0_ from dbo.T_GROUP group0_
[2005-07-26 19:20:01,473] DEBUG [main] (AbstractBatcher.java:378) - preparing statement
[2005-07-26 19:20:01,520] DEBUG [main] (AbstractBatcher.java:306) - about to open ResultSet (open ResultSets: 0, globally: 0)
[2005-07-26 19:20:01,520] DEBUG [main] (Loader.java:405) - processing result set
[2005-07-26 19:20:01,520] DEBUG [main] (Loader.java:410) - result set row: 0
[2005-07-26 19:20:01,536] DEBUG [main] (NullableType.java:86) - returning '0' as column: id1_
[2005-07-26 19:20:01,536] DEBUG [main] (Loader.java:828) - result row: EntityKey[com.tds.refdata.admin.Group#0]
[2005-07-26 19:20:01,567] DEBUG [main] (Loader.java:978) - Initializing object from ResultSet: [com.tds.refdata.admin.Group#0]
[2005-07-26 19:20:01,567] DEBUG [main] (BasicEntityPersister.java:1651) - Hydrating entity: [com.tds.refdata.admin.Group#0]
[2005-07-26 19:20:01,567] DEBUG [main] (NullableType.java:86) - returning '0' as column: id2_0_
[2005-07-26 19:20:01,567] DEBUG [main] (NullableType.java:86) - returning 'true' as column: is3_0_
[2005-07-26 19:20:01,567] DEBUG [main] (NullableType.java:86) - returning '3' as column: id4_0_
[2005-07-26 19:20:01,630] DEBUG [main] (NullableType.java:86) - returning 'saRef' as column: id5_0_
[2005-07-26 19:20:01,645] DEBUG [main] (NullableType.java:86) - returning '2005-07-26 02:16:17.237' as column: dt6_0_
[2005-07-26 19:20:01,645] DEBUG [main] (NullableType.java:86) - returning 'IT' as column: nm7_0_
[2005-07-26 19:20:01,645] DEBUG [main] (NullableType.java:86) - returning 'Technology Team' as column: nm8_0_
[2005-07-26 19:20:01,645] DEBUG [main] (Loader.java:410) - result set row: 1
[2005-07-26 19:20:01,645] DEBUG [main] (NullableType.java:86) - returning '1' as column: id1_
[2005-07-26 19:20:01,692] DEBUG [main] (Loader.java:828) - result row: EntityKey[com.tds.refdata.admin.Group#1]
[2005-07-26 19:20:01,692] DEBUG [main] (Loader.java:978) - Initializing object from ResultSet: [com.tds.refdata.admin.Group#1]
[2005-07-26 19:20:01,692] DEBUG [main] (BasicEntityPersister.java:1651) - Hydrating entity: [com.tds.refdata.admin.Group#1]
[2005-07-26 19:20:01,692] DEBUG [main] (NullableType.java:86) - returning '0' as column: id2_0_
[2005-07-26 19:20:01,692] DEBUG [main] (NullableType.java:86) - returning 'true' as column: is3_0_
[2005-07-26 19:20:01,770] DEBUG [main] (NullableType.java:86) - returning '3' as column: id4_0_
[2005-07-26 19:20:01,770] DEBUG [main] (NullableType.java:86) - returning 'saRef' as column: id5_0_
[2005-07-26 19:20:01,770] DEBUG [main] (NullableType.java:86) - returning '2005-07-26 02:16:17.237' as column: dt6_0_
[2005-07-26 19:20:01,770] DEBUG [main] (NullableType.java:86) - returning 'FO' as column: nm7_0_
[2005-07-26 19:20:01,770] DEBUG [main] (NullableType.java:86) - returning 'Credit Deriv. Front Office' as column: nm8_0_
[2005-07-26 19:20:01,817] DEBUG [main] (Loader.java:410) - result set row: 2
[2005-07-26 19:20:01,817] DEBUG [main] (NullableType.java:86) - returning '2' as column: id1_
[2005-07-26 19:20:01,817] DEBUG [main] (Loader.java:828) - result row: EntityKey[com.tds.refdata.admin.Group#2]
[2005-07-26 19:20:01,817] DEBUG [main] (Loader.java:978) - Initializing object from ResultSet: [com.tds.refdata.admin.Group#2]
[2005-07-26 19:20:01,817] DEBUG [main] (BasicEntityPersister.java:1651) - Hydrating entity: [com.tds.refdata.admin.Group#2]
[2005-07-26 19:20:01,864] DEBUG [main] (NullableType.java:86) - returning '0' as column: id2_0_
[2005-07-26 19:20:01,864] DEBUG [main] (NullableType.java:86) - returning 'true' as column: is3_0_
[2005-07-26 19:20:01,864] DEBUG [main] (NullableType.java:86) - returning '3' as column: id4_0_
[2005-07-26 19:20:01,864] DEBUG [main] (NullableType.java:86) - returning 'saRef' as column: id5_0_
[2005-07-26 19:20:01,864] DEBUG [main] (NullableType.java:86) - returning '2005-07-26 02:16:17.237' as column: dt6_0_
[2005-07-26 19:20:01,911] DEBUG [main] (NullableType.java:86) - returning 'MO' as column: nm7_0_
[2005-07-26 19:20:01,911] DEBUG [main] (NullableType.java:86) - returning 'Credit Deriv Middle Office' as column: nm8_0_
[2005-07-26 19:20:01,911] DEBUG [main] (Loader.java:410) - result set row: 3
[2005-07-26 19:20:01,911] DEBUG [main] (NullableType.java:86) - returning '3' as column: id1_
[2005-07-26 19:20:01,911] DEBUG [main] (Loader.java:828) - result row: EntityKey[com.tds.refdata.admin.Group#3]
[2005-07-26 19:20:01,911] DEBUG [main] (Loader.java:978) - Initializing object from ResultSet: [com.tds.refdata.admin.Group#3]
[2005-07-26 19:20:01,958] DEBUG [main] (BasicEntityPersister.java:1651) - Hydrating entity: [com.tds.refdata.admin.Group#3]
[2005-07-26 19:20:01,958] DEBUG [main] (NullableType.java:86) - returning '0' as column: id2_0_
[2005-07-26 19:20:01,958] DEBUG [main] (NullableType.java:86) - returning 'true' as column: is3_0_
[2005-07-26 19:20:01,958] DEBUG [main] (NullableType.java:86) - returning '3' as column: id4_0_
[2005-07-26 19:20:01,958] DEBUG [main] (NullableType.java:86) - returning 'saRef' as column: id5_0_
[2005-07-26 19:20:02,020] DEBUG [main] (NullableType.java:86) - returning '2005-07-26 02:16:17.237' as column: dt6_0_
[2005-07-26 19:20:02,020] DEBUG [main] (NullableType.java:86) - returning 'BO' as column: nm7_0_
[2005-07-26 19:20:02,020] DEBUG [main] (NullableType.java:86) - returning 'Credit Deriv Back Offcie' as column: nm8_0_
[2005-07-26 19:20:02,020] DEBUG [main] (Loader.java:410) - result set row: 4
[2005-07-26 19:20:02,020] DEBUG [main] (NullableType.java:86) - returning '4' as column: id1_
[2005-07-26 19:20:02,020] DEBUG [main] (Loader.java:828) - result row: EntityKey[com.tds.refdata.admin.Group#4]
[2005-07-26 19:20:02,052] DEBUG [main] (Loader.java:978) - Initializing object from ResultSet: [com.tds.refdata.admin.Group#4]
[2005-07-26 19:20:02,052] DEBUG [main] (BasicEntityPersister.java:1651) - Hydrating entity: [com.tds.refdata.admin.Group#4]
[2005-07-26 19:20:02,052] DEBUG [main] (NullableType.java:86) - returning '0' as column: id2_0_
[2005-07-26 19:20:02,052] DEBUG [main] (NullableType.java:86) - returning 'true' as column: is3_0_
[2005-07-26 19:20:02,052] DEBUG [main] (NullableType.java:86) - returning '3' as column: id4_0_
[2005-07-26 19:20:02,130] DEBUG [main] (NullableType.java:86) - returning 'saRef' as column: id5_0_
[2005-07-26 19:20:02,130] DEBUG [main] (NullableType.java:86) - returning '2005-07-26 02:16:17.253' as column: dt6_0_
[2005-07-26 19:20:02,130] DEBUG [main] (NullableType.java:86) - returning 'LnC' as column: nm7_0_
[2005-07-26 19:20:02,130] DEBUG [main] (NullableType.java:86) - returning 'Credit Deriv Legal & Compliance' as column: nm8_0_
[2005-07-26 19:20:02,130] DEBUG [main] (Loader.java:429) - done processing result set (5 rows)
[2005-07-26 19:20:02,161] DEBUG [main] (AbstractBatcher.java:313) - about to close ResultSet (open ResultSets: 1, globally: 1)
[2005-07-26 19:20:02,161] DEBUG [main] (AbstractBatcher.java:298) - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
[2005-07-26 19:20:02,161] DEBUG [main] (AbstractBatcher.java:416) - closing statement
[2005-07-26 19:20:02,161] DEBUG [main] (Loader.java:528) - total objects hydrated: 5
[2005-07-26 19:20:02,177] DEBUG [main] (TwoPhaseLoad.java:96) - resolving associations for [com.tds.refdata.admin.Group#0]
[2005-07-26 19:20:02,224] DEBUG [main] (TwoPhaseLoad.java:167) - done materializing entity [com.tds.refdata.admin.Group#0]
[2005-07-26 19:20:02,239] DEBUG [main] (TwoPhaseLoad.java:96) - resolving associations for [com.tds.refdata.admin.Group#1]
[2005-07-26 19:20:02,239] DEBUG [main] (TwoPhaseLoad.java:167) - done materializing entity [com.tds.refdata.admin.Group#1]
[2005-07-26 19:20:02,239] DEBUG [main] (TwoPhaseLoad.java:96) - resolving associations for [com.tds.refdata.admin.Group#2]
[2005-07-26 19:20:02,239] DEBUG [main] (TwoPhaseLoad.java:167) - done materializing entity [com.tds.refdata.admin.Group#2]
[2005-07-26 19:20:02,286] DEBUG [main] (TwoPhaseLoad.java:96) - resolving associations for [com.tds.refdata.admin.Group#3]
[2005-07-26 19:20:02,286] DEBUG [main] (TwoPhaseLoad.java:167) - done materializing entity [com.tds.refdata.admin.Group#3]
[2005-07-26 19:20:02,286] DEBUG [main] (TwoPhaseLoad.java:96) - resolving associations for [com.tds.refdata.admin.Group#4]
[2005-07-26 19:20:02,286] DEBUG [main] (TwoPhaseLoad.java:167) - done materializing entity [com.tds.refdata.admin.Group#4]
[2005-07-26 19:20:02,286] DEBUG [main] (PersistenceContext.java:789) - initializing non-lazy collections
[2005-07-26 19:20:02,349] DEBUG [main] (JDBCTransaction.java:83) - commit
[2005-07-26 19:20:02,349] DEBUG [main] (SessionImpl.java:323) - automatically flushing session
[2005-07-26 19:20:02,349] DEBUG [main] (AbstractFlushingEventListener.java:52) - flushing session
[2005-07-26 19:20:02,349] DEBUG [main] (AbstractFlushingEventListener.java:102) - processing flush-time cascades
[2005-07-26 19:20:02,349] DEBUG [main] (AbstractFlushingEventListener.java:150) - dirty checking collections
[2005-07-26 19:20:02,349] DEBUG [main] (AbstractFlushingEventListener.java:167) - Flushing entities and processing referenced collections
[2005-07-26 19:20:02,411] DEBUG [main] (AbstractFlushingEventListener.java:203) - Processing unreferenced collections
[2005-07-26 19:20:02,411] DEBUG [main] (AbstractFlushingEventListener.java:217) - Scheduling collection removes/(re)creates/updates
[2005-07-26 19:20:02,411] DEBUG [main] (AbstractFlushingEventListener.java:79) - Flushed: 0 insertions, 0 updates, 0 deletions to 5 objects
[2005-07-26 19:20:02,411] DEBUG [main] (AbstractFlushingEventListener.java:85) - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
[2005-07-26 19:20:02,474] DEBUG [main] (Printer.java:83) - listing entities:
[2005-07-26 19:20:02,474] DEBUG [main] (Printer.java:90) - com.tds.refdata.admin.Group{active=true, groupId=4, dsRegion=3, strLastModifiedDate=saRef, groupName=LnC, groupDescription=Credit Deriv Legal & Compliance, lastModifiedBy=2005-07-26 02:16:17.253, groupVersion=0}
[2005-07-26 19:20:02,474] DEBUG [main] (Printer.java:90) - com.tds.refdata.admin.Group{active=true, groupId=1, dsRegion=3, strLastModifiedDate=saRef, groupName=FO, groupDescription=Credit Deriv. Front Office, lastModifiedBy=2005-07-26 02:16:17.237, groupVersion=0}
[2005-07-26 19:20:02,505] DEBUG [main] (Printer.java:90) - com.tds.refdata.admin.Group{active=true, groupId=0, dsRegion=3, strLastModifiedDate=saRef, groupName=IT, groupDescription=Technology Team, lastModifiedBy=2005-07-26 02:16:17.237, groupVersion=0}
[2005-07-26 19:20:02,520] DEBUG [main] (Printer.java:90) - com.tds.refdata.admin.Group{active=true, groupId=3, dsRegion=3, strLastModifiedDate=saRef, groupName=BO, groupDescription=Credit Deriv Back Offcie, lastModifiedBy=2005-07-26 02:16:17.237, groupVersion=0}
[2005-07-26 19:20:02,552] DEBUG [main] (Printer.java:90) - com.tds.refdata.admin.Group{active=true, groupId=2, dsRegion=3, strLastModifiedDate=saRef, groupName=MO, groupDescription=Credit Deriv Middle Office, lastModifiedBy=2005-07-26 02:16:17.237, groupVersion=0}
[2005-07-26 19:20:02,552] DEBUG [main] (AbstractFlushingEventListener.java:267) - executing flush
[2005-07-26 19:20:02,552] DEBUG [main] (AbstractFlushingEventListener.java:294) - post flush
[2005-07-26 19:20:02,552] DEBUG [main] (JDBCContext.java:278) - before transaction completion
[2005-07-26 19:20:02,567] DEBUG [main] (SessionImpl.java:372) - before transaction completion
[2005-07-26 19:20:02,567] DEBUG [main] (JDBCTransaction.java:96) - committed JDBC Connection
[2005-07-26 19:20:02,567] DEBUG [main] (JDBCContext.java:283) - after transaction completion
[2005-07-26 19:20:02,567] DEBUG [main] (SessionImpl.java:403) - after transaction completion
[2005-07-26 19:20:02,567] DEBUG [main] (SessionImpl.java:269) - closing session
[2005-07-26 19:20:02,567] DEBUG [main] (ConnectionManager.java:317) - closing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
[2005-07-26 19:20:02,614] DEBUG [main] (JDBCExceptionReporter.java:40) - SQL Warning
java.sql.SQLWarning: [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to REF
at com.microsoft.jdbc.base.BaseWarnings.createSQLWarning(Unknown Source)
at com.microsoft.jdbc.base.BaseWarnings.get(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getWarnings(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.getWarnings(NewProxyConnection.java:731)
at org.hibernate.util.JDBCExceptionReporter.logAndClearWarnings(JDBCExceptionReporter.java:22)
at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:325)
at org.hibernate.jdbc.ConnectionManager.cleanup(ConnectionManager.java:262)
at org.hibernate.jdbc.ConnectionManager.close(ConnectionManager.java:194)
at org.hibernate.impl.SessionImpl.close(SessionImpl.java:289)
at com.tds.refdata.utils.HibernateUtils.closeSession(HibernateUtils.java:67)
at com.tds.refdata.admin.GroupAdmin.loadGroup(GroupAdmin.java:57)
at com.tds.refdata.admin.GroupAdmin.<init>(GroupAdmin.java:35)
at com.tds.refdata.admin.GroupAdmin.<clinit>(GroupAdmin.java:27)
[2005-07-26 19:20:02,677] WARN [main] (JDBCExceptionReporter.java:48) - SQL Warning: 0, SQLState:
[2005-07-26 19:20:02,677] WARN [main] (JDBCExceptionReporter.java:49) - [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to REF
[2005-07-26 19:20:02,677] WARN [main] (JDBCExceptionReporter.java:48) - SQL Warning: 5701, SQLState: 01000
[2005-07-26 19:20:02,677] WARN [main] (JDBCExceptionReporter.java:49) - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed database context to 'REF'.
[2005-07-26 19:20:02,864] WARN [main] (JDBCExceptionReporter.java:48) - SQL Warning: 0, SQLState:
[2005-07-26 19:20:02,864] WARN [main] (JDBCExceptionReporter.java:49) - [Microsoft][SQLServer 2000 Driver for JDBC]Language changed to us_english
[2005-07-26 19:20:02,864] WARN [main] (JDBCExceptionReporter.java:48) - SQL Warning: 5703, SQLState: 01000
[2005-07-26 19:20:02,880] WARN [main] (JDBCExceptionReporter.java:49) - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed language setting to us_english.
[2005-07-26 19:20:02,927] DEBUG [main] (JDBCContext.java:283) - after transaction completion
[2005-07-26 19:20:02,927] DEBUG [main] (SessionImpl.java:403) - after transaction completion
[2005-07-26 19:20:02,927] DEBUG [main] (GroupAdmin.java:36) - XXXXXXXXXXXXXXXX 5
groupId[0], groupVersion[0], isActive[true], dsRegion[3], strLastModifiedDate[saRef], lastModifiedBy[2005-07-26 02:16:17.237], groupName[IT], groupDescription[Technology Team]
[2005-07-26 19:20:02,927] DEBUG [main] (GroupAdmin.java:67) - Getting instance!
BUILD SUCCESSFUL (total time: 5 seconds)
Top
 Profile  
 
max
 Post subject:
PostPosted: Tue Jul 26, 2005 7:12 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
you are using HQL to load your object - not get/load nor native sql.

if you want to use the stored procedure you must use get/load or getNamedQuery

_________________
Max
Don't forget to rate

Top
 Profile  
 
nahmed
 Post subject:
PostPosted: Tue Jul 26, 2005 9:57 am 
Newbie

Joined: Fri Mar 25, 2005 3:07 pm
Posts: 11
Would be kind enough to tell me how to do that.

I simply want to load into an array list a set of groups via an SP.

Eg somling along the lines of

List ArrayList<Groups> = session.load().list()

//or is there somthing along these lines to basically use an SP to return a resultset which populates a colleciton of a particular class.


Thanks in advance.

Naz
Top
 Profile  
 
max
 Post subject:
PostPosted: Tue Jul 26, 2005 10:16 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
yes objects with colleciton loading via SP is possible with hibernate 3.1

see the docs about collection loading.

_________________
Max
Don't forget to rate

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.