-->
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.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 
Author Message
 Post subject: Incorrect sql select formed with wrong mapping, help!!
PostPosted: Fri Apr 22, 2005 2:15 am 
Newbie

Joined: Thu Apr 21, 2005 11:34 am
Posts: 4
Hi,
I just upgraded to hibernate3 and for one of the mapping file the generated select sql is wrong so the values are mapped wrong in the class.
The logs bellow shows the data
What is happening here is that the value of coulmn COUNTRY_ROUTE_LOC_OID is in Country . and CountryRouteLocOid has COUNTRY_ROUTE_LOC_OID data also.
Though the data type of country is string and CountryRouteLocOid in integer, country is somehow getting the CountryRouteLocOid value as string.
Country column does not appear in any field. Very strange .
Not sure if it is a bug in hibernate3. It worked fine in hibernate2. Or is there something I am doing wrong.
Please help !!! Thanks in advance.

Oracle tables is as follow
BCT_COUNTRY_ROUTE_LOT_T
===================
COUNTRY_ROUTE_LOC_OID NUMBER
ROUTE_LOC VARCHAR2
COUNTRY_CODE VARCHAR2
COUNTRY VARCHAR2


Hibernate version:
Hibernate3

Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="net.idt.bct.db.vo">
<class name="BctCountryRouteLocT" table="BCT_COUNTRY_ROUTE_LOC_T" lazy="false">
<cache usage="read-only" />
<id
column="COUNTRY_ROUTE_LOC_OID"
name="CountryRouteLocOid"
type="integer"
>
<generator class="native" />
</id>
<property
column="COUNTRY"
length="60"
name="Country"
not-null="false"
type="string"
/>
<property
column="COUNTRY_CODE"
length="10"
name="CountryCode"
not-null="false"
type="string"
/>
<property
column="ROUTE_LOC"
length="60"
name="RouteLoc"
not-null="false"
type="string"
/>
</class>
</hibernate-mapping>


Code between sessionFactory.openSession() and session.close():
List routingLocs = sess.createQuery("from BctCountryRouteLocT").list();
Iterator it = routingLocs.iterator();

String ctry;
String route;

int count = 0;
while (it.hasNext()) {
BctCountryRouteLocT bcrl = (BctCountryRouteLocT) it.next();
System.out.println("Country= " + bcrl.getCountry()
+ " loc= " + bcrl.getRouteLoc()+ " id"+bcrl.getCountryRouteLocOid()+" bcr"+bcrl.getCountryCode());
}


Full stack trace of any exception that occurs:



Name and version of the database you are using:
oracle9i
The generated SQL (show_sql=true):

--- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (BCT_COUNTRY_ROUTE_LOC_T)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| +-[SELECT_EXPR] SelectExpressionImpl: 'bctcountry0_.COUNTRY_ROUTE_LOC_OID as COUNTRY1_' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=BCT_COUNTRY_ROUTE_LOC_T,tableAlias=bctcountry0_,colums={,className=net.idt.bct.db.vo.BctCountryRouteLocT}}}
| \-[SQL_TOKEN] SqlFragment: 'bctcountry0_.COUNTRY_CODE as COUNTRY3_1_, bctcountry0_.ROUTE_LOC as ROUTE4_1_'
\-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[], fromElementByTableAlias=[bctcountry0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
\-[FROM_FRAGMENT] FromElement: 'BCT_COUNTRY_ROUTE_LOC_T bctcountry0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=BCT_COUNTRY_ROUTE_LOC_T,tableAlias=bctcountry0_,colums={,className=net.idt.bct.db.vo.BctCountryRouteLocT}}

01:29:58,349 DEBUG ErrorCounter:72 - throwQueryException() : no errors
01:29:58,366 DEBUG QueryTranslatorImpl:177 - HQL: from net.idt.bct.db.vo.BctCountryRouteLocT
01:29:58,367 DEBUG QueryTranslatorImpl:178 - SQL: select bctcountry0_.COUNTRY_ROUTE_LOC_OID as COUNTRY1_, bctcountry0_.COUNTRY_CODE as COUNTRY3_1_, bctcountry0_.ROUTE_LOC as ROUTE4_1_ from BCT_COUNTRY_ROUTE_LOC_T bctcountry0_
01:29:58,368 DEBUG ErrorCounter:72 - throwQueryException() : no errors
01:29:58,374 DEBUG AbstractBatcher:276 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
01:29:58,375 DEBUG AbstractBatcher:414 - opening JDBC connection
01:29:58,375 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
01:29:58,376 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
01:29:58,376 DEBUG SQL:310 - select bctcountry0_.COUNTRY_ROUTE_LOC_OID as COUNTRY1_, bctcountry0_.COUNTRY_CODE as COUNTRY3_1_, bctcountry0_.ROUTE_LOC as ROUTE4_1_ from BCT_COUNTRY_ROUTE_LOC_T bctcountry0_
01:29:58,379 DEBUG AbstractBatcher:364 - preparing statement

Debug level Hibernate log excerpt:

62 - Mapping collection: net.idt.bct.db.vo.BctBulkTestT.bctTestSetT -> BCT_TEST_SET_T
01:29:55,337 DEBUG HbmBinder:2358 - Mapped collection key: BULK_TEST_OID, one-to-many: net.idt.bct.db.vo.BctTestSetT
01:29:55,339 INFO Configuration:865 - processing association property references
01:29:55,339 INFO Configuration:894 - processing foreign key constraints
01:29:55,340 DEBUG Configuration:941 - resolving reference to class: net.idt.bct.db.vo.BctSavedTestSetT
01:29:55,340 DEBUG Configuration:941 - resolving reference to class: net.idt.bct.db.vo.BctSavedTestSetT
01:29:55,341 DEBUG Configuration:941 - resolving reference to class: net.idt.bct.db.vo.BctSwitchCarrierT
01:29:55,341 DEBUG Configuration:941 - resolving reference to class: net.idt.bct.db.vo.BctResultCodeT
01:29:55,345 DEBUG Configuration:941 - resolving reference to class: net.idt.bct.db.vo.BctTestSetT
01:29:55,345 DEBUG Configuration:941 - resolving reference to class: net.idt.bct.db.vo.BctSipStatusCodeT
01:29:55,346 DEBUG Configuration:941 - resolving reference to class: net.idt.bct.db.vo.BctBulkTestT
01:29:55,690 INFO Dialect:91 - Using dialect: org.hibernate.dialect.Oracle9Dialect
01:29:55,695 DEBUG SQLExceptionConverterFactory:52 - Using dialect defined converter
01:29:55,701 INFO SettingsFactory:91 - Default batch fetch size: 1
01:29:55,703 INFO SettingsFactory:95 - Generate SQL with comments: disabled
01:29:55,704 INFO SettingsFactory:99 - Order SQL updates by primary key: disabled
01:29:55,704 INFO SettingsFactory:285 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
01:29:55,707 INFO ASTQueryTranslatorFactory:21 - Using ASTQueryTranslatorFactory
01:29:55,708 INFO SettingsFactory:107 - Query language substitutions: {}
01:29:55,712 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
01:29:55,713 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
01:29:55,714 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
01:29:55,756 INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.OracleDriver at URL: jdbc:oracle:thin:@pydev58b:1521:prod
01:29:55,757 INFO DriverManagerConnectionProvider:83 - connection properties: {user=bct, password=bct}
01:29:55,758 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
01:29:55,761 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC connection
01:29:56,867 DEBUG DriverManagerConnectionProvider:115 - created connection to: jdbc:oracle:thin:@pydev58b:1521:prod, Isolation Level: 2
01:29:56,885 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
01:29:56,886 INFO SettingsFactory:149 - JDBC batch size: 15
01:29:56,886 INFO SettingsFactory:152 - JDBC batch updates for versioned data: disabled
01:29:56,888 INFO SettingsFactory:157 - Scrollable result sets: enabled
01:29:56,888 DEBUG SettingsFactory:161 - Wrap result sets: disabled
01:29:56,889 INFO SettingsFactory:165 - JDBC3 getGeneratedKeys(): disabled
01:29:56,891 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
01:29:56,897 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
01:29:56,905 INFO SettingsFactory:177 - Automatic flush during beforeCompletion(): disabled
01:29:56,906 INFO SettingsFactory:180 - Automatic session close at end of transaction: disabled
01:29:56,906 INFO SettingsFactory:186 - Second-level cache: enabled
01:29:56,907 INFO SettingsFactory:190 - Query cache: enabled
01:29:56,908 INFO SettingsFactory:272 - Cache provider: org.hibernate.cache.EhCacheProvider
01:29:56,911 INFO SettingsFactory:205 - Optimize cache for minimal puts: disabled
01:29:56,912 INFO SettingsFactory:214 - Structured second-level cache entries: enabled
01:29:56,912 INFO SettingsFactory:259 - Query cache factory: org.hibernate.cache.StandardQueryCacheFactory
01:29:56,916 INFO SettingsFactory:226 - Statistics: disabled
01:29:56,917 INFO SettingsFactory:230 - Deleted entity synthetic identifier rollback: disabled
01:29:56,918 INFO SettingsFactory:244 - Default entity-mode: pojo
01:29:56,952 INFO SessionFactoryImpl:147 - building session factory
01:29:56,953 DEBUG SessionFactoryImpl:156 - Session factory constructed with filter configurations : {}
01:29:56,954 DEBUG SessionFactoryImpl:159 - instantiating session factory with properties: {hibernate.connection.password=bct, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider, sun.boot.library.path=/usr/lib/sun-j2sdk1.5.0/jre/lib/i386, java.vm.version=1.5.0_01-b08, hibernate.connection.username=bct, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, hibernate.cache.use_query_cache=true, path.separator=:, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=unknown, java.vm.specification.name=Java Virtual Machine Specification, user.dir=/home/gkrishna/workspace/BCT, java.runtime.version=1.5.0_01-b08, java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment, java.endorsed.dirs=/usr/lib/sun-j2sdk1.5.0/jre/lib/endorsed, os.arch=i386, java.io.tmpdir=/tmp, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., os.name=Linux, sun.jnu.encoding=ISO-8859-1, java.library.path=/usr/lib/sun-j2sdk1.5.0/jre/lib/i386/client:/usr/lib/sun-j2sdk1.5.0/jre/lib/i386:/usr/lib/sun-j2sdk1.5.0/jre/../lib/i386, java.specification.name=Java Platform API Specification, java.class.version=49.0, sun.management.compiler=HotSpot Client Compiler, os.version=2.6.8.1-3-386, user.home=/home/gkrishna, user.timezone=US/Eastern, java.awt.printerjob=sun.print.PSPrinterJob, file.encoding=ISO-8859-1, java.specification.version=1.5, hibernate.connection.driver_class=oracle.jdbc.OracleDriver, show_sql=true, user.name=gkrishna, java.class.path=/opt/eclipse/plugins/org.eclipse.jdt.junit_3.0.1/junitsupport.jar:/opt/eclipse/plugins/org.eclipse.jdt.junit.runtime_3.0.0/junitruntime.jar:/home/gkrishna/workspace/BCT/target/classes:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/commons-beanutils.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/commons-collections.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/commons-digester.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/commons-lang.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/commons-logging.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/commons-validator.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/cpJarFiles:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/display.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/dom4j-1.4.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/jakarta-regexp-1.3.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/jdom.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/log4j-1.2.8.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/odmg-3.0.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/ojdbc14.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/struts.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/taglibs-log.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/weblogic.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/xalan-2.4.0.jar:/home/gkrishna/workspace/r730/third_party/repository/idt-jars/jars/IdtEandO-1.0.jar:/opt/eclipse/sybaseconnector/jconn2.jar:/opt/hibernate-3.0/lib/cglib-2.1.jar:/opt/hibernate-3.0/lib/ehcache-1.1.jar:/opt/hibernate-3.0/hibernate3.jar:/opt/hibernate-3.0/lib/ant-1.6.2.jar:/opt/hibernate-3.0/lib/antlr-2.7.5H3.jar:/opt/eclipse/plugins/org.junit_3.8.1/junit.jar:/home/gkrishna/workspace/BCT/target/test-classes:/opt/quartz-1.4.5/lib/quartz.jar:/home/gkrishna/strutsmenu/WEB-INF/lib/struts-menu-2.3.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/classes:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/antlr-2.7.5.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/cglib-2.1.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/commons-beanutils-1.7.0.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/commons-collections-2.1.1.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/commons-digester-1.6.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/commons-fileupload-1.0.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/commons-lang-2.0.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/commons-logging-1.0.4.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/commons-validator-1.1.3.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/displaytag-1.0.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/dom4j-1.4.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/ehcache-1.1.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/hibernate3.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/jakarta-oro-2.0.8.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/jconn2.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/log4j-1.2.8.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/odmg-3.0.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/ojdbc14.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/poi-2.5.1-final-20040804.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/quartz.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/struts-1.2.4.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/struts-menu-2.3.jar:/home/gkrishna/workspace/BCT/target/bct/WEB-INF/lib/taglibs-application.jar:/opt/hibernate-3.0/lib/asm-attrs.jar:/opt/hibernate-3.0/lib/asm.jar, hibernate.show_sql=false, java.vm.specification.version=1.0, java.home=/usr/lib/sun-j2sdk1.5.0/jre, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, hibernate.connection.url=jdbc:oracle:thin:@pydev58b:1521:prod, user.language=en, java.specification.vendor=Sun Microsystems Inc., hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, sharing, java.version=1.5.0_01, java.ext.dirs=/usr/lib/sun-j2sdk1.5.0/jre/lib/ext, cache.use_query_cache=true, sun.boot.class.path=/usr/lib/sun-j2sdk1.5.0/jre/lib/rt.jar:/usr/lib/sun-j2sdk1.5.0/jre/lib/i18n.jar:/usr/lib/sun-j2sdk1.5.0/jre/lib/sunrsasign.jar:/usr/lib/sun-j2sdk1.5.0/jre/lib/jsse.jar:/usr/lib/sun-j2sdk1.5.0/jre/lib/jce.jar:/usr/lib/sun-j2sdk1.5.0/jre/lib/charsets.jar:/usr/lib/sun-j2sdk1.5.0/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, hibernate.use_outer_join=true, sun.desktop=gnome, dialect=org.hibernate.dialect.Oracle9Dialect, sun.cpu.isalist=}
01:29:56,958 DEBUG CacheManager:191 - Creating new CacheManager with default config
01:29:56,964 DEBUG CacheManager:164 - Configuring ehcache from classpath.
01:29:56,968 DEBUG Configurator:121 - Configuring ehcache from ehcache.xml found in the classpath: file:/home/gkrishna/workspace/BCT/target/classes/ehcache.xml
01:29:56,984 DEBUG MemoryStore:147 - net.idt.bct.db.vo.BctCountryRouteLocT Cache: Using SpoolingLinkedHashMap implementation
01:29:56,984 DEBUG MemoryStore:128 - initialized MemoryStore for net.idt.bct.db.vo.BctCountryRouteLocT
01:29:57,141 DEBUG Cache:277 - Initialised cache: net.idt.bct.db.vo.BctCountryRouteLocT
01:29:57,142 DEBUG MemoryStore:147 - net.idt.bct.db.vo.BctSwitchCarrierT Cache: Using SpoolingLinkedHashMap implementation
01:29:57,142 DEBUG MemoryStore:128 - initialized MemoryStore for net.idt.bct.db.vo.BctSwitchCarrierT
01:29:57,143 DEBUG Cache:277 - Initialised cache: net.idt.bct.db.vo.BctSwitchCarrierT
01:29:57,204 DEBUG CacheFactory:39 - instantiating cache region: net.idt.bct.db.vo.BctCountryRouteLocT usage strategy: read-only
01:29:57,204 WARN CacheFactory:43 - read-only cache configured for mutable class: net.idt.bct.db.vo.BctCountryRouteLocT
01:29:57,327 DEBUG BasicEntityPersister:2229 - Static SQL for entity: net.idt.bct.db.vo.BctCountryRouteLocT
01:29:57,328 DEBUG BasicEntityPersister:2231 - Version select: select COUNTRY_ROUTE_LOC_OID from BCT_COUNTRY_ROUTE_LOC_T where COUNTRY_ROUTE_LOC_OID =?
01:29:57,328 DEBUG BasicEntityPersister:2232 - Snapshot select: select bctcountry_.COUNTRY_ROUTE_LOC_OID, bctcountry_.COUNTRY as COUNTRY1_, bctcountry_.COUNTRY_CODE as COUNTRY3_1_, bctcountry_.ROUTE_LOC as ROUTE4_1_ from BCT_COUNTRY_ROUTE_LOC_T bctcountry_ where bctcountry_.COUNTRY_ROUTE_LOC_OID=?
01:29:57,329 DEBUG BasicEntityPersister:2234 - Insert 0: insert into BCT_COUNTRY_ROUTE_LOC_T (COUNTRY, COUNTRY_CODE, ROUTE_LOC, COUNTRY_ROUTE_LOC_OID) values (?, ?, ?, ?)
01:29:57,329 DEBUG BasicEntityPersister:2235 - Update 0: update BCT_COUNTRY_ROUTE_LOC_T set COUNTRY=?, COUNTRY_CODE=?, ROUTE_LOC=? where COUNTRY_ROUTE_LOC_OID=?
01:29:57,330 DEBUG BasicEntityPersister:2236 - Delete 0: delete from BCT_COUNTRY_ROUTE_LOC_T where COUNTRY_ROUTE_LOC_OID=?
01:29:57,347 DEBUG BasicEntityPersister:2229 - Static SQL for entity: net.idt.bct.db.vo.BctBulkTestT
01:29:57,347 DEBUG BasicEntityPersister:2231 - Version select: select BULK_TEST_OID from BCT_BULK_TEST_T where BULK_TEST_OID =?
01:29:57,348 DEBUG BasicEntityPersister:2232 - Snapshot select: select bctbulktes_.BULK_TEST_OID, bctbulktes_.COMMENTS as COMMENTS9_, bctbulktes_.FILE_NAME as FILE3_9_ from BCT_BULK_TEST_T bctbulktes_ where bctbulktes_.BULK_TEST_OID=?
01:29:57,348 DEBUG BasicEntityPersister:2234 - Insert 0: insert into BCT_BULK_TEST_T (COMMENTS, FILE_NAME, BULK_TEST_OID) values (?, ?, ?)
01:29:57,349 DEBUG BasicEntityPersister:2235 - Update 0: update BCT_BULK_TEST_T set COMMENTS=?, FILE_NAME=? where BULK_TEST_OID=?
01:29:57,349 DEBUG BasicEntityPersister:2236 - Delete 0: delete from BCT_BULK_TEST_T where BULK_TEST_OID=?
01:29:57,364 DEBUG BasicEntityPersister:2229 - Static SQL for entity: net.idt.bct.db.vo.BctSavedTestSetRoutesT
01:29:57,364 DEBUG BasicEntityPersister:2231 - Version select: select SAVED_TEST_SET_OID, ROUTING_LOC from BCT_SAVED_TEST_SET_ROUTES_T where SAVED_TEST_SET_OID =? and ROUTING_LOC =?
01:29:57,365 DEBUG BasicEntityPersister:2232 - Snapshot select: select bctsavedte_.SAVED_TEST_SET_OID, bctsavedte_.ROUTING_LOC from BCT_SAVED_TEST_SET_ROUTES_T bctsavedte_ where bctsavedte_.SAVED_TEST_SET_OID=? and bctsavedte_.ROUTING_LOC=?
01:29:57,365 DEBUG BasicEntityPersister:2234 - Insert 0: insert into BCT_SAVED_TEST_SET_ROUTES_T (SAVED_TEST_SET_OID, ROUTING_LOC) values (?, ?)
01:29:57,366 DEBUG BasicEntityPersister:2235 - Update 0: null
01:29:57,366 DEBUG BasicEntityPersister:2236 - Delete 0: delete from BCT_SAVED_TEST_SET_ROUTES_T where SAVED_TEST_SET_OID=? and ROUTING_LOC=?
01:29:57,378 DEBUG BasicEntityPersister:2229 - Static SQL for entity: net.idt.bct.db.vo.BctResultCodeT
01:29:57,378 DEBUG BasicEntityPersister:2231 - Version select: select RESULT_CODE from BCT_RESULT_CODE_T where RESULT_CODE =?
01:29:57,379 DEBUG BasicEntityPersister:2232 - Snapshot select: select bctresultc_.RESULT_CODE, bctresultc_.SUCCESS_FLAG as SUCCESS2_11_, bctresultc_.DESCR as DESCR11_ from BCT_RESULT_CODE_T bctresultc_ where bctresultc_.RESULT_CODE=?
01:29:57,379 DEBUG BasicEntityPersister:2234 - Insert 0: insert into BCT_RESULT_CODE_T (SUCCESS_FLAG, DESCR, RESULT_CODE) values (?, ?, ?)
01:29:57,380 DEBUG BasicEntityPersister:2235 - Update 0: update BCT_RESULT_CODE_T set SUCCESS_FLAG=?, DESCR=? where RESULT_CODE=?
01:29:57,380 DEBUG BasicEntityPersister:2236 - Delete 0: delete from BCT_RESULT_CODE_T where RESULT_CODE=?
01:29:57,391 DEBUG BasicEntityPersister:2229 - Static SQL for entity: net.idt.bct.db.vo.BctSavedTestSetNumT
01:29:57,392 DEBUG BasicEntityPersister:2231 - Version select: select SAVED_TEST_SET_OID, PHONE_NUM from BCT_SAVED_TEST_SET_NUM_T where SAVED_TEST_SET_OID =? and PHONE_NUM =?
01:29:57,392 DEBUG BasicEntityPersister:2232 - Snapshot select: select bctsavedte_.SAVED_TEST_SET_OID, bctsavedte_.PHONE_NUM, bctsavedte_.ROUTING_LOC as ROUTING3_6_ from BCT_SAVED_TEST_SET_NUM_T bctsavedte_ where bctsavedte_.SAVED_TEST_SET_OID=? and bctsavedte_.PHONE_NUM=?
01:29:57,393 DEBUG BasicEntityPersister:2234 - Insert 0: insert into BCT_SAVED_TEST_SET_NUM_T (ROUTING_LOC, SAVED_TEST_SET_OID, PHONE_NUM) values (?, ?, ?)
01:29:57,393 DEBUG BasicEntityPersister:2235 - Update 0: update BCT_SAVED_TEST_SET_NUM_T set ROUTING_LOC=? where SAVED_TEST_SET_OID=? and PHONE_NUM=?
01:29:57,394 DEBUG BasicEntityPersister:2236 - Delete 0: delete from BCT_SAVED_TEST_SET_NUM_T where SAVED_TEST_SET_OID=? and PHONE_NUM=?
01:29:57,396 DEBUG CacheFactory:39 - instantiating cache region: net.idt.bct.db.vo.BctSwitchCarrierT usage strategy: read-only
01:29:57,396 WARN CacheFactory:43 - read-only cache configured for mutable class: net.idt.bct.db.vo.BctSwitchCarrierT
01:29:57,407 DEBUG BasicEntityPersister:2229 - Static SQL for entity: net.idt.bct.db.vo.BctSwitchCarrierT
01:29:57,408 DEBUG BasicEntityPersister:2231 - Version select: select SWITCH_CARRIER_OID from BCT_SWITCH_CARRIER_T where SWITCH_CARRIER_OID =?
01:29:57,408 DEBUG BasicEntityPersister:2232 - Snapshot select: select bctswitchc_.SWITCH_CARRIER_OID, bctswitchc_.CARRIER_NAME as CARRIER2_2_, bctswitchc_.CLLI_CODE as CLLI3_2_, bctswitchc_.CLLI_PREFIX as CLLI4_2_, bctswitchc_.SWITCH_NAME as SWITCH5_2_ from BCT_SWITCH_CARRIER_T bctswitchc_ where bctswitchc_.SWITCH_CARRIER_OID=?
01:29:57,410 DEBUG BasicEntityPersister:2234 - Insert 0: insert into BCT_SWITCH_CARRIER_T (CARRIER_NAME, CLLI_CODE, CLLI_PREFIX, SWITCH_NAME, SWITCH_CARRIER_OID) values (?, ?, ?, ?, ?)
01:29:57,411 DEBUG BasicEntityPersister:2235 - Update 0: update BCT_SWITCH_CARRIER_T set CARRIER_NAME=?, CLLI_CODE=?, CLLI_PREFIX=?, SWITCH_NAME=? where SWITCH_CARRIER_OID=?
01:29:57,411 DEBUG BasicEntityPersister:2236 - Delete 0: delete from BCT_SWITCH_CARRIER_T where SWITCH_CARRIER_OID=?
01:29:57,488 DEBUG BasicEntityPersister:2229 - Static SQL for entity: net.idt.bct.db.vo.BctTestSetT
01:29:57,489 DEBUG BasicEntityPersister:2231 - Version select: select TEST_SET_OID from BCT_TEST_SET_T where TEST_SET_OID =?
01:29:57,491 DEBUG BasicEntityPersister:2232 - Snapshot select: select bcttestset_.TEST_SET_OID, bcttestset_.CREATED_DATE as CREATED2_3_, bcttestset_.MODIFIED_DATE as MODIFIED3_3_, bcttestset_.SWITCH_CARRIER_OID as SWITCH4_3_, bcttestset_.USER_ID_OID as USER5_3_, bcttestset_.NUMBER_OF_CALLS as NUMBER6_3_, bcttestset_.SCHEDULED_DATE as SCHEDULED7_3_, bcttestset_.BULK_TEST_OID as BULK8_3_, bcttestset_.PDD_COMPLETION as PDD9_3_, bcttestset_.SEARCH_WINDOW as SEARCH10_3_, bcttestset_.STATUS as STATUS3_, bcttestset_.REQUESTED_AMT_NUM as REQUESTED12_3_, bcttestset_.CLI as CLI3_ from BCT_TEST_SET_T bcttestset_ where bcttestset_.TEST_SET_OID=?
01:29:57,492 DEBUG BasicEntityPersister:2234 - Insert 0: insert into BCT_TEST_SET_T (CREATED_DATE, MODIFIED_DATE, SWITCH_CARRIER_OID, USER_ID_OID, NUMBER_OF_CALLS, SCHEDULED_DATE, BULK_TEST_OID, PDD_COMPLETION, SEARCH_WINDOW, STATUS, REQUESTED_AMT_NUM, CLI, TEST_SET_OID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
01:29:57,492 DEBUG BasicEntityPersister:2235 - Update 0: update BCT_TEST_SET_T set CREATED_DATE=?, MODIFIED_DATE=?, SWITCH_CARRIER_OID=?, USER_ID_OID=?, NUMBER_OF_CALLS=?, SCHEDULED_DATE=?, BULK_TEST_OID=?, PDD_COMPLETION=?, SEARCH_WINDOW=?, STATUS=?, REQUESTED_AMT_NUM=?, CLI=? where TEST_SET_OID=?
01:29:57,493 DEBUG BasicEntityPersister:2236 - Delete 0: delete from BCT_TEST_SET_T where TEST_SET_OID=?
01:29:57,511 DEBUG BasicEntityPersister:2229 - Static SQL for entity: net.idt.bct.db.vo.BctUserIdT
01:29:57,512 DEBUG BasicEntityPersister:2231 - Version select: select USER_ID_OID from BCT_USER_ID_T where USER_ID_OID =?
01:29:57,512 DEBUG BasicEntityPersister:2232 - Snapshot select: select bctuseridt_.USER_ID_OID, bctuseridt_.USERID as USERID0_, bctuseridt_.LAST_NAME as LAST3_0_, bctuseridt_.LOCALE as LOCALE0_, bctuseridt_.FIRST_NAME as FIRST5_0_, bctuseridt_.PHONE as PHONE0_, bctuseridt_.EMAIL as EMAIL0_, bctuseridt_.PASSWD as PASSWD0_ from BCT_USER_ID_T bctuseridt_ where bctuseridt_.USER_ID_OID=?
01:29:57,513 DEBUG BasicEntityPersister:2234 - Insert 0: insert into BCT_USER_ID_T (USERID, LAST_NAME, LOCALE, FIRST_NAME, PHONE, EMAIL, PASSWD, USER_ID_OID) values (?, ?, ?, ?, ?, ?, ?, ?)
01:29:57,513 DEBUG BasicEntityPersister:2235 - Update 0: update BCT_USER_ID_T set USERID=?, LAST_NAME=?, LOCALE=?, FIRST_NAME=?, PHONE=?, EMAIL=?, PASSWD=? where USER_ID_OID=?
01:29:57,514 DEBUG BasicEntityPersister:2236 - Delete 0: delete from BCT_USER_ID_T where USER_ID_OID=?
01:29:57,521 DEBUG BasicEntityPersister:2229 - Static SQL for entity: net.idt.bct.db.vo.BctSipStatusCodeT
01:29:57,522 DEBUG BasicEntityPersister:2231 - Version select: select STATUS_CODE from BCT_SIP_STATUS_CODE_T where STATUS_CODE =?
01:29:57,522 DEBUG BasicEntityPersister:2232 - Snapshot select: select bctsipstat_.STATUS_CODE, bctsipstat_.DESCR as DESCR10_ from BCT_SIP_STATUS_CODE_T bctsipstat_ where bctsipstat_.STATUS_CODE=?
01:29:57,523 DEBUG BasicEntityPersister:2234 - Insert 0: insert into BCT_SIP_STATUS_CODE_T (DESCR, STATUS_CODE) values (?, ?)
01:29:57,523 DEBUG BasicEntityPersister:2235 - Update 0: update BCT_SIP_STATUS_CODE_T set DESCR=? where STATUS_CODE=?
01:29:57,524 DEBUG BasicEntityPersister:2236 - Delete 0: delete from BCT_SIP_STATUS_CODE_T where STATUS_CODE=?
01:29:57,550 DEBUG BasicEntityPersister:2229 - Static SQL for entity: net.idt.bct.db.vo.BctSavedTestSetT
01:29:57,550 DEBUG BasicEntityPersister:2231 - Version select: select SAVED_TEST_SET_OID from BCT_SAVED_TEST_SET_T where SAVED_TEST_SET_OID =?
01:29:57,551 DEBUG BasicEntityPersister:2232 - Snapshot select: select bctsavedte_.SAVED_TEST_SET_OID, bctsavedte_.SEARCH_WINDOW as SEARCH2_5_, bctsavedte_.CREATED_DATE as CREATED3_5_, bctsavedte_.NUMBERS_FROM as NUMBERS4_5_, bctsavedte_.MODIFIED_DATE as MODIFIED5_5_, bctsavedte_.SWITCH_CARRIER_OID as SWITCH6_5_, bctsavedte_.USER_ID_OID as USER7_5_, bctsavedte_.TEST_NAME as TEST8_5_, bctsavedte_.NUMBER_OF_CALLS as NUMBER9_5_, bctsavedte_.REQUESTED_AMT_NUM as REQUESTED10_5_, bctsavedte_.PDD_COMPLETION as PDD11_5_, bctsavedte_.CLI as CLI5_ from BCT_SAVED_TEST_SET_T bctsavedte_ where bctsavedte_.SAVED_TEST_SET_OID=?
01:29:57,551 DEBUG BasicEntityPersister:2234 - Insert 0: insert into BCT_SAVED_TEST_SET_T (SEARCH_WINDOW, CREATED_DATE, NUMBERS_FROM, MODIFIED_DATE, SWITCH_CARRIER_OID, USER_ID_OID, TEST_NAME, NUMBER_OF_CALLS, REQUESTED_AMT_NUM, PDD_COMPLETION, CLI, SAVED_TEST_SET_OID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
01:29:57,552 DEBUG BasicEntityPersister:2235 - Update 0: update BCT_SAVED_TEST_SET_T set SEARCH_WINDOW=?, CREATED_DATE=?, NUMBERS_FROM=?, MODIFIED_DATE=?, SWITCH_CARRIER_OID=?, USER_ID_OID=?, TEST_NAME=?, NUMBER_OF_CALLS=?, REQUESTED_AMT_NUM=?, PDD_COMPLETION=?, CLI=? where SAVED_TEST_SET_OID=?
01:29:57,552 DEBUG BasicEntityPersister:2236 - Delete 0: delete from BCT_SAVED_TEST_SET_T where SAVED_TEST_SET_OID=?
01:29:57,604 DEBUG BasicEntityPersister:2229 - Static SQL for entity: net.idt.bct.db.vo.BctTestSetNumT
01:29:57,605 DEBUG BasicEntityPersister:2231 - Version select: select TEST_SET_OID, PHONE_NUM from BCT_TEST_SET_NUM_T where TEST_SET_OID =? and PHONE_NUM =?
01:29:57,605 DEBUG BasicEntityPersister:2232 - Snapshot select: select bcttestset_.TEST_SET_OID, bcttestset_.PHONE_NUM, bcttestset_.CALL_TIME as CALL3_4_, bcttestset_.SIGNALING_PDD as SIGNALING4_4_, bcttestset_.CALL_ID as CALL5_4_, bcttestset_.ROUTING_LOC as ROUTING6_4_, bcttestset_.RESULT as RESULT4_, bcttestset_.SIP_STATUS_CODE as SIP8_4_ from BCT_TEST_SET_NUM_T bcttestset_ where bcttestset_.TEST_SET_OID=? and bcttestset_.PHONE_NUM=?
01:29:57,606 DEBUG BasicEntityPersister:2234 - Insert 0: insert into BCT_TEST_SET_NUM_T (CALL_TIME, SIGNALING_PDD, CALL_ID, ROUTING_LOC, RESULT, SIP_STATUS_CODE, TEST_SET_OID, PHONE_NUM) values (?, ?, ?, ?, ?, ?, ?, ?)
01:29:57,606 DEBUG BasicEntityPersister:2235 - Update 0: update BCT_TEST_SET_NUM_T set CALL_TIME=?, SIGNALING_PDD=?, CALL_ID=?, ROUTING_LOC=?, RESULT=?, SIP_STATUS_CODE=? where TEST_SET_OID=? and PHONE_NUM=?
01:29:57,606 DEBUG BasicEntityPersister:2236 - Delete 0: delete from BCT_TEST_SET_NUM_T where TEST_SET_OID=? and PHONE_NUM=?
01:29:57,621 DEBUG BasicEntityPersister:2229 - Static SQL for entity: net.idt.bct.db.vo.BctCliT
01:29:57,622 DEBUG BasicEntityPersister:2231 - Version select: select CLI_OID from BCT_CLI_T where CLI_OID =?
01:29:57,622 DEBUG BasicEntityPersister:2232 - Snapshot select: select bctclit_.CLI_OID, bctclit_.DESCR as DESCR8_, bctclit_.CLI as CLI8_ from BCT_CLI_T bctclit_ where bctclit_.CLI_OID=?
01:29:57,623 DEBUG BasicEntityPersister:2234 - Insert 0: insert into BCT_CLI_T (DESCR, CLI, CLI_OID) values (?, ?, ?)
01:29:57,672 DEBUG BasicEntityPersister:2235 - Update 0: update BCT_CLI_T set DESCR=?, CLI=? where CLI_OID=?
01:29:57,672 DEBUG BasicEntityPersister:2236 - Delete 0: delete from BCT_CLI_T where CLI_OID=?
01:29:57,682 DEBUG AbstractCollectionPersister:479 - Static SQL for collection: net.idt.bct.db.vo.BctBulkTestT.bctTestSetT
01:29:57,682 DEBUG AbstractCollectionPersister:480 - Row insert: update BCT_TEST_SET_T set BULK_TEST_OID=? where TEST_SET_OID=?
01:29:57,683 DEBUG AbstractCollectionPersister:482 - Row delete: update BCT_TEST_SET_T set BULK_TEST_OID=null where BULK_TEST_OID=? and TEST_SET_OID=?
01:29:57,686 DEBUG AbstractCollectionPersister:483 - One-shot delete: update BCT_TEST_SET_T set BULK_TEST_OID=null where BULK_TEST_OID=?
01:29:57,687 DEBUG AbstractCollectionPersister:479 - Static SQL for collection: net.idt.bct.db.vo.BctSavedTestSetT.bctSavedTestSetRoutes
01:29:57,688 DEBUG AbstractCollectionPersister:480 - Row insert: update BCT_SAVED_TEST_SET_ROUTES_T set SAVED_TEST_SET_OID=? where SAVED_TEST_SET_OID=? and ROUTING_LOC=?
01:29:57,688 DEBUG AbstractCollectionPersister:482 - Row delete: update BCT_SAVED_TEST_SET_ROUTES_T set SAVED_TEST_SET_OID=null where SAVED_TEST_SET_OID=? and SAVED_TEST_SET_OID=? and ROUTING_LOC=?
01:29:57,689 DEBUG AbstractCollectionPersister:483 - One-shot delete: update BCT_SAVED_TEST_SET_ROUTES_T set SAVED_TEST_SET_OID=null where SAVED_TEST_SET_OID=?
01:29:57,689 DEBUG AbstractCollectionPersister:479 - Static SQL for collection: net.idt.bct.db.vo.BctSavedTestSetT.bctSavedTestSetNums
01:29:57,690 DEBUG AbstractCollectionPersister:480 - Row insert: update BCT_SAVED_TEST_SET_NUM_T set SAVED_TEST_SET_OID=? where SAVED_TEST_SET_OID=? and PHONE_NUM=?
01:29:57,690 DEBUG AbstractCollectionPersister:482 - Row delete: update BCT_SAVED_TEST_SET_NUM_T set SAVED_TEST_SET_OID=null where SAVED_TEST_SET_OID=? and SAVED_TEST_SET_OID=? and PHONE_NUM=?
01:29:57,691 DEBUG AbstractCollectionPersister:483 - One-shot delete: update BCT_SAVED_TEST_SET_NUM_T set SAVED_TEST_SET_OID=null where SAVED_TEST_SET_OID=?
01:29:57,693 DEBUG AbstractCollectionPersister:479 - Static SQL for collection: net.idt.bct.db.vo.BctTestSetT.bctTestSetNums
01:29:57,693 DEBUG AbstractCollectionPersister:480 - Row insert: update BCT_TEST_SET_NUM_T set TEST_SET_OID=? where TEST_SET_OID=? and PHONE_NUM=?
01:29:57,694 DEBUG AbstractCollectionPersister:482 - Row delete: update BCT_TEST_SET_NUM_T set TEST_SET_OID=null where TEST_SET_OID=? and TEST_SET_OID=? and PHONE_NUM=?
01:29:57,694 DEBUG AbstractCollectionPersister:483 - One-shot delete: update BCT_TEST_SET_NUM_T set TEST_SET_OID=null where TEST_SET_OID=?
01:29:57,723 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctCountryRouteLocT: select bctcountry0_.COUNTRY_ROUTE_LOC_OID as COUNTRY1_0_, bctcountry0_.COUNTRY_CODE as COUNTRY3_1_0_, bctcountry0_.ROUTE_LOC as ROUTE4_1_0_ from BCT_COUNTRY_ROUTE_LOC_T bctcountry0_ where bctcountry0_.COUNTRY_ROUTE_LOC_OID=?
01:29:57,726 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctCountryRouteLocT: select bctcountry0_.COUNTRY_ROUTE_LOC_OID as COUNTRY1_0_, bctcountry0_.COUNTRY_CODE as COUNTRY3_1_0_, bctcountry0_.ROUTE_LOC as ROUTE4_1_0_ from BCT_COUNTRY_ROUTE_LOC_T bctcountry0_ where bctcountry0_.COUNTRY_ROUTE_LOC_OID=?
01:29:57,726 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctCountryRouteLocT: select bctcountry0_.COUNTRY_ROUTE_LOC_OID as COUNTRY1_0_, bctcountry0_.COUNTRY_CODE as COUNTRY3_1_0_, bctcountry0_.ROUTE_LOC as ROUTE4_1_0_ from BCT_COUNTRY_ROUTE_LOC_T bctcountry0_ where bctcountry0_.COUNTRY_ROUTE_LOC_OID=? for update
01:29:57,728 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctCountryRouteLocT: select bctcountry0_.COUNTRY_ROUTE_LOC_OID as COUNTRY1_0_, bctcountry0_.COUNTRY_CODE as COUNTRY3_1_0_, bctcountry0_.ROUTE_LOC as ROUTE4_1_0_ from BCT_COUNTRY_ROUTE_LOC_T bctcountry0_ where bctcountry0_.COUNTRY_ROUTE_LOC_OID=? for update nowait
01:29:57,730 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSavedTestSetRoutesT: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_0_, bctsavedte0_.ROUTING_LOC as ROUTING2_0_ from BCT_SAVED_TEST_SET_ROUTES_T bctsavedte0_ where bctsavedte0_.SAVED_TEST_SET_OID=? and bctsavedte0_.ROUTING_LOC=?
01:29:57,730 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSavedTestSetRoutesT: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_0_, bctsavedte0_.ROUTING_LOC as ROUTING2_0_ from BCT_SAVED_TEST_SET_ROUTES_T bctsavedte0_ where bctsavedte0_.SAVED_TEST_SET_OID=? and bctsavedte0_.ROUTING_LOC=?
01:29:57,731 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSavedTestSetRoutesT: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_0_, bctsavedte0_.ROUTING_LOC as ROUTING2_0_ from BCT_SAVED_TEST_SET_ROUTES_T bctsavedte0_ where bctsavedte0_.SAVED_TEST_SET_OID=? and bctsavedte0_.ROUTING_LOC=? for update
01:29:57,732 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSavedTestSetRoutesT: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_0_, bctsavedte0_.ROUTING_LOC as ROUTING2_0_ from BCT_SAVED_TEST_SET_ROUTES_T bctsavedte0_ where bctsavedte0_.SAVED_TEST_SET_OID=? and bctsavedte0_.ROUTING_LOC=? for update nowait
01:29:57,735 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctBulkTestT: select bctbulktes0_.BULK_TEST_OID as BULK1_0_, bctbulktes0_.COMMENTS as COMMENTS9_0_, bctbulktes0_.FILE_NAME as FILE3_9_0_ from BCT_BULK_TEST_T bctbulktes0_ where bctbulktes0_.BULK_TEST_OID=?
01:29:57,736 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctBulkTestT: select bctbulktes0_.BULK_TEST_OID as BULK1_0_, bctbulktes0_.COMMENTS as COMMENTS9_0_, bctbulktes0_.FILE_NAME as FILE3_9_0_ from BCT_BULK_TEST_T bctbulktes0_ where bctbulktes0_.BULK_TEST_OID=?
01:29:57,737 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctBulkTestT: select bctbulktes0_.BULK_TEST_OID as BULK1_0_, bctbulktes0_.COMMENTS as COMMENTS9_0_, bctbulktes0_.FILE_NAME as FILE3_9_0_ from BCT_BULK_TEST_T bctbulktes0_ where bctbulktes0_.BULK_TEST_OID=? for update
01:29:57,737 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctBulkTestT: select bctbulktes0_.BULK_TEST_OID as BULK1_0_, bctbulktes0_.COMMENTS as COMMENTS9_0_, bctbulktes0_.FILE_NAME as FILE3_9_0_ from BCT_BULK_TEST_T bctbulktes0_ where bctbulktes0_.BULK_TEST_OID=? for update nowait
01:29:57,738 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSavedTestSetNumT: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_0_, bctsavedte0_.PHONE_NUM as PHONE2_0_, bctsavedte0_.ROUTING_LOC as ROUTING3_6_0_ from BCT_SAVED_TEST_SET_NUM_T bctsavedte0_ where bctsavedte0_.SAVED_TEST_SET_OID=? and bctsavedte0_.PHONE_NUM=?
01:29:57,739 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSavedTestSetNumT: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_0_, bctsavedte0_.PHONE_NUM as PHONE2_0_, bctsavedte0_.ROUTING_LOC as ROUTING3_6_0_ from BCT_SAVED_TEST_SET_NUM_T bctsavedte0_ where bctsavedte0_.SAVED_TEST_SET_OID=? and bctsavedte0_.PHONE_NUM=?
01:29:57,739 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSavedTestSetNumT: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_0_, bctsavedte0_.PHONE_NUM as PHONE2_0_, bctsavedte0_.ROUTING_LOC as ROUTING3_6_0_ from BCT_SAVED_TEST_SET_NUM_T bctsavedte0_ where bctsavedte0_.SAVED_TEST_SET_OID=? and bctsavedte0_.PHONE_NUM=? for update
01:29:57,741 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSavedTestSetNumT: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_0_, bctsavedte0_.PHONE_NUM as PHONE2_0_, bctsavedte0_.ROUTING_LOC as ROUTING3_6_0_ from BCT_SAVED_TEST_SET_NUM_T bctsavedte0_ where bctsavedte0_.SAVED_TEST_SET_OID=? and bctsavedte0_.PHONE_NUM=? for update nowait
01:29:57,742 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctResultCodeT: select bctresultc0_.RESULT_CODE as RESULT1_0_, bctresultc0_.SUCCESS_FLAG as SUCCESS2_11_0_, bctresultc0_.DESCR as DESCR11_0_ from BCT_RESULT_CODE_T bctresultc0_ where bctresultc0_.RESULT_CODE=?
01:29:57,743 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctResultCodeT: select bctresultc0_.RESULT_CODE as RESULT1_0_, bctresultc0_.SUCCESS_FLAG as SUCCESS2_11_0_, bctresultc0_.DESCR as DESCR11_0_ from BCT_RESULT_CODE_T bctresultc0_ where bctresultc0_.RESULT_CODE=?
01:29:57,743 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctResultCodeT: select bctresultc0_.RESULT_CODE as RESULT1_0_, bctresultc0_.SUCCESS_FLAG as SUCCESS2_11_0_, bctresultc0_.DESCR as DESCR11_0_ from BCT_RESULT_CODE_T bctresultc0_ where bctresultc0_.RESULT_CODE=? for update
01:29:57,744 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctResultCodeT: select bctresultc0_.RESULT_CODE as RESULT1_0_, bctresultc0_.SUCCESS_FLAG as SUCCESS2_11_0_, bctresultc0_.DESCR as DESCR11_0_ from BCT_RESULT_CODE_T bctresultc0_ where bctresultc0_.RESULT_CODE=? for update nowait
01:29:57,745 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSwitchCarrierT: select bctswitchc0_.SWITCH_CARRIER_OID as SWITCH1_0_, bctswitchc0_.CARRIER_NAME as CARRIER2_2_0_, bctswitchc0_.CLLI_CODE as CLLI3_2_0_, bctswitchc0_.CLLI_PREFIX as CLLI4_2_0_, bctswitchc0_.SWITCH_NAME as SWITCH5_2_0_ from BCT_SWITCH_CARRIER_T bctswitchc0_ where bctswitchc0_.SWITCH_CARRIER_OID=?
01:29:57,745 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSwitchCarrierT: select bctswitchc0_.SWITCH_CARRIER_OID as SWITCH1_0_, bctswitchc0_.CARRIER_NAME as CARRIER2_2_0_, bctswitchc0_.CLLI_CODE as CLLI3_2_0_, bctswitchc0_.CLLI_PREFIX as CLLI4_2_0_, bctswitchc0_.SWITCH_NAME as SWITCH5_2_0_ from BCT_SWITCH_CARRIER_T bctswitchc0_ where bctswitchc0_.SWITCH_CARRIER_OID=?
01:29:57,747 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSwitchCarrierT: select bctswitchc0_.SWITCH_CARRIER_OID as SWITCH1_0_, bctswitchc0_.CARRIER_NAME as CARRIER2_2_0_, bctswitchc0_.CLLI_CODE as CLLI3_2_0_, bctswitchc0_.CLLI_PREFIX as CLLI4_2_0_, bctswitchc0_.SWITCH_NAME as SWITCH5_2_0_ from BCT_SWITCH_CARRIER_T bctswitchc0_ where bctswitchc0_.SWITCH_CARRIER_OID=? for update
01:29:57,748 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSwitchCarrierT: select bctswitchc0_.SWITCH_CARRIER_OID as SWITCH1_0_, bctswitchc0_.CARRIER_NAME as CARRIER2_2_0_, bctswitchc0_.CLLI_CODE as CLLI3_2_0_, bctswitchc0_.CLLI_PREFIX as CLLI4_2_0_, bctswitchc0_.SWITCH_NAME as SWITCH5_2_0_ from BCT_SWITCH_CARRIER_T bctswitchc0_ where bctswitchc0_.SWITCH_CARRIER_OID=? for update nowait
01:29:57,753 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctTestSetT: select bcttestset0_.TEST_SET_OID as TEST1_1_, bcttestset0_.CREATED_DATE as CREATED2_3_1_, bcttestset0_.MODIFIED_DATE as MODIFIED3_3_1_, bcttestset0_.SWITCH_CARRIER_OID as SWITCH4_3_1_, bcttestset0_.USER_ID_OID as USER5_3_1_, bcttestset0_.NUMBER_OF_CALLS as NUMBER6_3_1_, bcttestset0_.SCHEDULED_DATE as SCHEDULED7_3_1_, bcttestset0_.BULK_TEST_OID as BULK8_3_1_, bcttestset0_.PDD_COMPLETION as PDD9_3_1_, bcttestset0_.SEARCH_WINDOW as SEARCH10_3_1_, bcttestset0_.STATUS as STATUS3_1_, bcttestset0_.REQUESTED_AMT_NUM as REQUESTED12_3_1_, bcttestset0_.CLI as CLI3_1_, bctbulktes1_.BULK_TEST_OID as BULK1_0_, bctbulktes1_.COMMENTS as COMMENTS9_0_, bctbulktes1_.FILE_NAME as FILE3_9_0_ from BCT_TEST_SET_T bcttestset0_ left outer join BCT_BULK_TEST_T bctbulktes1_ on bcttestset0_.BULK_TEST_OID=bctbulktes1_.BULK_TEST_OID where bcttestset0_.TEST_SET_OID=?
01:29:57,754 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctTestSetT: select bcttestset0_.TEST_SET_OID as TEST1_1_, bcttestset0_.CREATED_DATE as CREATED2_3_1_, bcttestset0_.MODIFIED_DATE as MODIFIED3_3_1_, bcttestset0_.SWITCH_CARRIER_OID as SWITCH4_3_1_, bcttestset0_.USER_ID_OID as USER5_3_1_, bcttestset0_.NUMBER_OF_CALLS as NUMBER6_3_1_, bcttestset0_.SCHEDULED_DATE as SCHEDULED7_3_1_, bcttestset0_.BULK_TEST_OID as BULK8_3_1_, bcttestset0_.PDD_COMPLETION as PDD9_3_1_, bcttestset0_.SEARCH_WINDOW as SEARCH10_3_1_, bcttestset0_.STATUS as STATUS3_1_, bcttestset0_.REQUESTED_AMT_NUM as REQUESTED12_3_1_, bcttestset0_.CLI as CLI3_1_, bctbulktes1_.BULK_TEST_OID as BULK1_0_, bctbulktes1_.COMMENTS as COMMENTS9_0_, bctbulktes1_.FILE_NAME as FILE3_9_0_ from BCT_TEST_SET_T bcttestset0_ left outer join BCT_BULK_TEST_T bctbulktes1_ on bcttestset0_.BULK_TEST_OID=bctbulktes1_.BULK_TEST_OID where bcttestset0_.TEST_SET_OID=?
01:29:57,755 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctTestSetT: select bcttestset0_.TEST_SET_OID as TEST1_0_, bcttestset0_.CREATED_DATE as CREATED2_3_0_, bcttestset0_.MODIFIED_DATE as MODIFIED3_3_0_, bcttestset0_.SWITCH_CARRIER_OID as SWITCH4_3_0_, bcttestset0_.USER_ID_OID as USER5_3_0_, bcttestset0_.NUMBER_OF_CALLS as NUMBER6_3_0_, bcttestset0_.SCHEDULED_DATE as SCHEDULED7_3_0_, bcttestset0_.BULK_TEST_OID as BULK8_3_0_, bcttestset0_.PDD_COMPLETION as PDD9_3_0_, bcttestset0_.SEARCH_WINDOW as SEARCH10_3_0_, bcttestset0_.STATUS as STATUS3_0_, bcttestset0_.REQUESTED_AMT_NUM as REQUESTED12_3_0_, bcttestset0_.CLI as CLI3_0_ from BCT_TEST_SET_T bcttestset0_ where bcttestset0_.TEST_SET_OID=? for update
01:29:57,757 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctTestSetT: select bcttestset0_.TEST_SET_OID as TEST1_0_, bcttestset0_.CREATED_DATE as CREATED2_3_0_, bcttestset0_.MODIFIED_DATE as MODIFIED3_3_0_, bcttestset0_.SWITCH_CARRIER_OID as SWITCH4_3_0_, bcttestset0_.USER_ID_OID as USER5_3_0_, bcttestset0_.NUMBER_OF_CALLS as NUMBER6_3_0_, bcttestset0_.SCHEDULED_DATE as SCHEDULED7_3_0_, bcttestset0_.BULK_TEST_OID as BULK8_3_0_, bcttestset0_.PDD_COMPLETION as PDD9_3_0_, bcttestset0_.SEARCH_WINDOW as SEARCH10_3_0_, bcttestset0_.STATUS as STATUS3_0_, bcttestset0_.REQUESTED_AMT_NUM as REQUESTED12_3_0_, bcttestset0_.CLI as CLI3_0_ from BCT_TEST_SET_T bcttestset0_ where bcttestset0_.TEST_SET_OID=? for update nowait
01:29:57,798 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctUserIdT: select bctuseridt0_.USER_ID_OID as USER1_0_, bctuseridt0_.USERID as USERID0_0_, bctuseridt0_.LAST_NAME as LAST3_0_0_, bctuseridt0_.LOCALE as LOCALE0_0_, bctuseridt0_.FIRST_NAME as FIRST5_0_0_, bctuseridt0_.PHONE as PHONE0_0_, bctuseridt0_.EMAIL as EMAIL0_0_, bctuseridt0_.PASSWD as PASSWD0_0_ from BCT_USER_ID_T bctuseridt0_ where bctuseridt0_.USER_ID_OID=?
01:29:57,799 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctUserIdT: select bctuseridt0_.USER_ID_OID as USER1_0_, bctuseridt0_.USERID as USERID0_0_, bctuseridt0_.LAST_NAME as LAST3_0_0_, bctuseridt0_.LOCALE as LOCALE0_0_, bctuseridt0_.FIRST_NAME as FIRST5_0_0_, bctuseridt0_.PHONE as PHONE0_0_, bctuseridt0_.EMAIL as EMAIL0_0_, bctuseridt0_.PASSWD as PASSWD0_0_ from BCT_USER_ID_T bctuseridt0_ where bctuseridt0_.USER_ID_OID=?
01:29:57,799 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctUserIdT: select bctuseridt0_.USER_ID_OID as USER1_0_, bctuseridt0_.USERID as USERID0_0_, bctuseridt0_.LAST_NAME as LAST3_0_0_, bctuseridt0_.LOCALE as LOCALE0_0_, bctuseridt0_.FIRST_NAME as FIRST5_0_0_, bctuseridt0_.PHONE as PHONE0_0_, bctuseridt0_.EMAIL as EMAIL0_0_, bctuseridt0_.PASSWD as PASSWD0_0_ from BCT_USER_ID_T bctuseridt0_ where bctuseridt0_.USER_ID_OID=? for update
01:29:57,800 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctUserIdT: select bctuseridt0_.USER_ID_OID as USER1_0_, bctuseridt0_.USERID as USERID0_0_, bctuseridt0_.LAST_NAME as LAST3_0_0_, bctuseridt0_.LOCALE as LOCALE0_0_, bctuseridt0_.FIRST_NAME as FIRST5_0_0_, bctuseridt0_.PHONE as PHONE0_0_, bctuseridt0_.EMAIL as EMAIL0_0_, bctuseridt0_.PASSWD as PASSWD0_0_ from BCT_USER_ID_T bctuseridt0_ where bctuseridt0_.USER_ID_OID=? for update nowait
01:29:57,801 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSavedTestSetT: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_1_, bctsavedte0_.SEARCH_WINDOW as SEARCH2_5_1_, bctsavedte0_.CREATED_DATE as CREATED3_5_1_, bctsavedte0_.NUMBERS_FROM as NUMBERS4_5_1_, bctsavedte0_.MODIFIED_DATE as MODIFIED5_5_1_, bctsavedte0_.SWITCH_CARRIER_OID as SWITCH6_5_1_, bctsavedte0_.USER_ID_OID as USER7_5_1_, bctsavedte0_.TEST_NAME as TEST8_5_1_, bctsavedte0_.NUMBER_OF_CALLS as NUMBER9_5_1_, bctsavedte0_.REQUESTED_AMT_NUM as REQUESTED10_5_1_, bctsavedte0_.PDD_COMPLETION as PDD11_5_1_, bctsavedte0_.CLI as CLI5_1_, bctswitchc1_.SWITCH_CARRIER_OID as SWITCH1_0_, bctswitchc1_.CARRIER_NAME as CARRIER2_2_0_, bctswitchc1_.CLLI_CODE as CLLI3_2_0_, bctswitchc1_.CLLI_PREFIX as CLLI4_2_0_, bctswitchc1_.SWITCH_NAME as SWITCH5_2_0_ from BCT_SAVED_TEST_SET_T bctsavedte0_ left outer join BCT_SWITCH_CARRIER_T bctswitchc1_ on bctsavedte0_.SWITCH_CARRIER_OID=bctswitchc1_.SWITCH_CARRIER_OID where bctsavedte0_.SAVED_TEST_SET_OID=?
01:29:57,803 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSavedTestSetT: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_1_, bctsavedte0_.SEARCH_WINDOW as SEARCH2_5_1_, bctsavedte0_.CREATED_DATE as CREATED3_5_1_, bctsavedte0_.NUMBERS_FROM as NUMBERS4_5_1_, bctsavedte0_.MODIFIED_DATE as MODIFIED5_5_1_, bctsavedte0_.SWITCH_CARRIER_OID as SWITCH6_5_1_, bctsavedte0_.USER_ID_OID as USER7_5_1_, bctsavedte0_.TEST_NAME as TEST8_5_1_, bctsavedte0_.NUMBER_OF_CALLS as NUMBER9_5_1_, bctsavedte0_.REQUESTED_AMT_NUM as REQUESTED10_5_1_, bctsavedte0_.PDD_COMPLETION as PDD11_5_1_, bctsavedte0_.CLI as CLI5_1_, bctswitchc1_.SWITCH_CARRIER_OID as SWITCH1_0_, bctswitchc1_.CARRIER_NAME as CARRIER2_2_0_, bctswitchc1_.CLLI_CODE as CLLI3_2_0_, bctswitchc1_.CLLI_PREFIX as CLLI4_2_0_, bctswitchc1_.SWITCH_NAME as SWITCH5_2_0_ from BCT_SAVED_TEST_SET_T bctsavedte0_ left outer join BCT_SWITCH_CARRIER_T bctswitchc1_ on bctsavedte0_.SWITCH_CARRIER_OID=bctswitchc1_.SWITCH_CARRIER_OID where bctsavedte0_.SAVED_TEST_SET_OID=?
01:29:57,804 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSavedTestSetT: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_0_, bctsavedte0_.SEARCH_WINDOW as SEARCH2_5_0_, bctsavedte0_.CREATED_DATE as CREATED3_5_0_, bctsavedte0_.NUMBERS_FROM as NUMBERS4_5_0_, bctsavedte0_.MODIFIED_DATE as MODIFIED5_5_0_, bctsavedte0_.SWITCH_CARRIER_OID as SWITCH6_5_0_, bctsavedte0_.USER_ID_OID as USER7_5_0_, bctsavedte0_.TEST_NAME as TEST8_5_0_, bctsavedte0_.NUMBER_OF_CALLS as NUMBER9_5_0_, bctsavedte0_.REQUESTED_AMT_NUM as REQUESTED10_5_0_, bctsavedte0_.PDD_COMPLETION as PDD11_5_0_, bctsavedte0_.CLI as CLI5_0_ from BCT_SAVED_TEST_SET_T bctsavedte0_ where bctsavedte0_.SAVED_TEST_SET_OID=? for update
01:29:57,805 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSavedTestSetT: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_0_, bctsavedte0_.SEARCH_WINDOW as SEARCH2_5_0_, bctsavedte0_.CREATED_DATE as CREATED3_5_0_, bctsavedte0_.NUMBERS_FROM as NUMBERS4_5_0_, bctsavedte0_.MODIFIED_DATE as MODIFIED5_5_0_, bctsavedte0_.SWITCH_CARRIER_OID as SWITCH6_5_0_, bctsavedte0_.USER_ID_OID as USER7_5_0_, bctsavedte0_.TEST_NAME as TEST8_5_0_, bctsavedte0_.NUMBER_OF_CALLS as NUMBER9_5_0_, bctsavedte0_.REQUESTED_AMT_NUM as REQUESTED10_5_0_, bctsavedte0_.PDD_COMPLETION as PDD11_5_0_, bctsavedte0_.CLI as CLI5_0_ from BCT_SAVED_TEST_SET_T bctsavedte0_ where bctsavedte0_.SAVED_TEST_SET_OID=? for update nowait
01:29:57,806 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSipStatusCodeT: select bctsipstat0_.STATUS_CODE as STATUS1_0_, bctsipstat0_.DESCR as DESCR10_0_ from BCT_SIP_STATUS_CODE_T bctsipstat0_ where bctsipstat0_.STATUS_CODE=?
01:29:57,806 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSipStatusCodeT: select bctsipstat0_.STATUS_CODE as STATUS1_0_, bctsipstat0_.DESCR as DESCR10_0_ from BCT_SIP_STATUS_CODE_T bctsipstat0_ where bctsipstat0_.STATUS_CODE=?
01:29:57,807 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSipStatusCodeT: select bctsipstat0_.STATUS_CODE as STATUS1_0_, bctsipstat0_.DESCR as DESCR10_0_ from BCT_SIP_STATUS_CODE_T bctsipstat0_ where bctsipstat0_.STATUS_CODE=? for update
01:29:57,809 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctSipStatusCodeT: select bctsipstat0_.STATUS_CODE as STATUS1_0_, bctsipstat0_.DESCR as DESCR10_0_ from BCT_SIP_STATUS_CODE_T bctsipstat0_ where bctsipstat0_.STATUS_CODE=? for update nowait
01:29:57,810 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctTestSetNumT: select bcttestset0_.TEST_SET_OID as TEST1_4_, bcttestset0_.PHONE_NUM as PHONE2_4_, bcttestset0_.CALL_TIME as CALL3_4_4_, bcttestset0_.SIGNALING_PDD as SIGNALING4_4_4_, bcttestset0_.CALL_ID as CALL5_4_4_, bcttestset0_.ROUTING_LOC as ROUTING6_4_4_, bcttestset0_.RESULT as RESULT4_4_, bcttestset0_.SIP_STATUS_CODE as SIP8_4_4_, bcttestset0_.TEST_SET_OID as TEST1_4_4_, bcttestset1_.TEST_SET_OID as TEST1_0_, bcttestset1_.CREATED_DATE as CREATED2_3_0_, bcttestset1_.MODIFIED_DATE as MODIFIED3_3_0_, bcttestset1_.SWITCH_CARRIER_OID as SWITCH4_3_0_, bcttestset1_.USER_ID_OID as USER5_3_0_, bcttestset1_.NUMBER_OF_CALLS as NUMBER6_3_0_, bcttestset1_.SCHEDULED_DATE as SCHEDULED7_3_0_, bcttestset1_.BULK_TEST_OID as BULK8_3_0_, bcttestset1_.PDD_COMPLETION as PDD9_3_0_, bcttestset1_.SEARCH_WINDOW as SEARCH10_3_0_, bcttestset1_.STATUS as STATUS3_0_, bcttestset1_.REQUESTED_AMT_NUM as REQUESTED12_3_0_, bcttestset1_.CLI as CLI3_0_, bctbulktes2_.BULK_TEST_OID as BULK1_1_, bctbulktes2_.COMMENTS as COMMENTS9_1_, bctbulktes2_.FILE_NAME as FILE3_9_1_, bctresultc3_.RESULT_CODE as RESULT1_2_, bctresultc3_.SUCCESS_FLAG as SUCCESS2_11_2_, bctresultc3_.DESCR as DESCR11_2_, bctsipstat4_.STATUS_CODE as STATUS1_3_, bctsipstat4_.DESCR as DESCR10_3_ from BCT_TEST_SET_NUM_T bcttestset0_ left outer join BCT_TEST_SET_T bcttestset1_ on bcttestset0_.TEST_SET_OID=bcttestset1_.TEST_SET_OID left outer join BCT_BULK_TEST_T bctbulktes2_ on bcttestset1_.BULK_TEST_OID=bctbulktes2_.BULK_TEST_OID left outer join BCT_RESULT_CODE_T bctresultc3_ on bcttestset0_.RESULT=bctresultc3_.RESULT_CODE left outer join BCT_SIP_STATUS_CODE_T bctsipstat4_ on bcttestset0_.SIP_STATUS_CODE=bctsipstat4_.STATUS_CODE where bcttestset0_.TEST_SET_OID=? and bcttestset0_.PHONE_NUM=?
01:29:57,811 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctTestSetNumT: select bcttestset0_.TEST_SET_OID as TEST1_4_, bcttestset0_.PHONE_NUM as PHONE2_4_, bcttestset0_.CALL_TIME as CALL3_4_4_, bcttestset0_.SIGNALING_PDD as SIGNALING4_4_4_, bcttestset0_.CALL_ID as CALL5_4_4_, bcttestset0_.ROUTING_LOC as ROUTING6_4_4_, bcttestset0_.RESULT as RESULT4_4_, bcttestset0_.SIP_STATUS_CODE as SIP8_4_4_, bcttestset0_.TEST_SET_OID as TEST1_4_4_, bcttestset1_.TEST_SET_OID as TEST1_0_, bcttestset1_.CREATED_DATE as CREATED2_3_0_, bcttestset1_.MODIFIED_DATE as MODIFIED3_3_0_, bcttestset1_.SWITCH_CARRIER_OID as SWITCH4_3_0_, bcttestset1_.USER_ID_OID as USER5_3_0_, bcttestset1_.NUMBER_OF_CALLS as NUMBER6_3_0_, bcttestset1_.SCHEDULED_DATE as SCHEDULED7_3_0_, bcttestset1_.BULK_TEST_OID as BULK8_3_0_, bcttestset1_.PDD_COMPLETION as PDD9_3_0_, bcttestset1_.SEARCH_WINDOW as SEARCH10_3_0_, bcttestset1_.STATUS as STATUS3_0_, bcttestset1_.REQUESTED_AMT_NUM as REQUESTED12_3_0_, bcttestset1_.CLI as CLI3_0_, bctbulktes2_.BULK_TEST_OID as BULK1_1_, bctbulktes2_.COMMENTS as COMMENTS9_1_, bctbulktes2_.FILE_NAME as FILE3_9_1_, bctresultc3_.RESULT_CODE as RESULT1_2_, bctresultc3_.SUCCESS_FLAG as SUCCESS2_11_2_, bctresultc3_.DESCR as DESCR11_2_, bctsipstat4_.STATUS_CODE as STATUS1_3_, bctsipstat4_.DESCR as DESCR10_3_ from BCT_TEST_SET_NUM_T bcttestset0_ left outer join BCT_TEST_SET_T bcttestset1_ on bcttestset0_.TEST_SET_OID=bcttestset1_.TEST_SET_OID left outer join BCT_BULK_TEST_T bctbulktes2_ on bcttestset1_.BULK_TEST_OID=bctbulktes2_.BULK_TEST_OID left outer join BCT_RESULT_CODE_T bctresultc3_ on bcttestset0_.RESULT=bctresultc3_.RESULT_CODE left outer join BCT_SIP_STATUS_CODE_T bctsipstat4_ on bcttestset0_.SIP_STATUS_CODE=bctsipstat4_.STATUS_CODE where bcttestset0_.TEST_SET_OID=? and bcttestset0_.PHONE_NUM=?
01:29:57,812 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctTestSetNumT: select bcttestset0_.TEST_SET_OID as TEST1_0_, bcttestset0_.PHONE_NUM as PHONE2_0_, bcttestset0_.CALL_TIME as CALL3_4_0_, bcttestset0_.SIGNALING_PDD as SIGNALING4_4_0_, bcttestset0_.CALL_ID as CALL5_4_0_, bcttestset0_.ROUTING_LOC as ROUTING6_4_0_, bcttestset0_.RESULT as RESULT4_0_, bcttestset0_.SIP_STATUS_CODE as SIP8_4_0_, bcttestset0_.TEST_SET_OID as TEST1_4_0_ from BCT_TEST_SET_NUM_T bcttestset0_ where bcttestset0_.TEST_SET_OID=? and bcttestset0_.PHONE_NUM=? for update
01:29:57,814 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctTestSetNumT: select bcttestset0_.TEST_SET_OID as TEST1_0_, bcttestset0_.PHONE_NUM as PHONE2_0_, bcttestset0_.CALL_TIME as CALL3_4_0_, bcttestset0_.SIGNALING_PDD as SIGNALING4_4_0_, bcttestset0_.CALL_ID as CALL5_4_0_, bcttestset0_.ROUTING_LOC as ROUTING6_4_0_, bcttestset0_.RESULT as RESULT4_0_, bcttestset0_.SIP_STATUS_CODE as SIP8_4_0_, bcttestset0_.TEST_SET_OID as TEST1_4_0_ from BCT_TEST_SET_NUM_T bcttestset0_ where bcttestset0_.TEST_SET_OID=? and bcttestset0_.PHONE_NUM=? for update nowait
01:29:57,815 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctCliT: select bctclit0_.CLI_OID as CLI1_0_, bctclit0_.DESCR as DESCR8_0_, bctclit0_.CLI as CLI8_0_ from BCT_CLI_T bctclit0_ where bctclit0_.CLI_OID=?
01:29:57,816 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctCliT: select bctclit0_.CLI_OID as CLI1_0_, bctclit0_.DESCR as DESCR8_0_, bctclit0_.CLI as CLI8_0_ from BCT_CLI_T bctclit0_ where bctclit0_.CLI_OID=?
01:29:57,817 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctCliT: select bctclit0_.CLI_OID as CLI1_0_, bctclit0_.DESCR as DESCR8_0_, bctclit0_.CLI as CLI8_0_ from BCT_CLI_T bctclit0_ where bctclit0_.CLI_OID=? for update
01:29:57,818 DEBUG EntityLoader:120 - Static select for entity net.idt.bct.db.vo.BctCliT: select bctclit0_.CLI_OID as CLI1_0_, bctclit0_.DESCR as DESCR8_0_, bctclit0_.CLI as CLI8_0_ from BCT_CLI_T bctclit0_ where bctclit0_.CLI_OID=? for update nowait
01:29:57,823 DEBUG OneToManyLoader:98 - Static select for one-to-many net.idt.bct.db.vo.BctBulkTestT.bctTestSetT: select bcttestset0_.BULK_TEST_OID as BULK8___, bcttestset0_.TEST_SET_OID as TEST1___, bcttestset0_.TEST_SET_OID as TEST1_0_, bcttestset0_.CREATED_DATE as CREATED2_3_0_, bcttestset0_.MODIFIED_DATE as MODIFIED3_3_0_, bcttestset0_.SWITCH_CARRIER_OID as SWITCH4_3_0_, bcttestset0_.USER_ID_OID as USER5_3_0_, bcttestset0_.NUMBER_OF_CALLS as NUMBER6_3_0_, bcttestset0_.SCHEDULED_DATE as SCHEDULED7_3_0_, bcttestset0_.BULK_TEST_OID as BULK8_3_0_, bcttestset0_.PDD_COMPLETION as PDD9_3_0_, bcttestset0_.SEARCH_WINDOW as SEARCH10_3_0_, bcttestset0_.STATUS as STATUS3_0_, bcttestset0_.REQUESTED_AMT_NUM as REQUESTED12_3_0_, bcttestset0_.CLI as CLI3_0_ from BCT_TEST_SET_T bcttestset0_ where bcttestset0_.BULK_TEST_OID=?
01:29:57,825 DEBUG OneToManyLoader:98 - Static select for one-to-many net.idt.bct.db.vo.BctSavedTestSetT.bctSavedTestSetRoutes: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1___, bctsavedte0_.ROUTING_LOC as ROUTING2___, bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_0_, bctsavedte0_.ROUTING_LOC as ROUTING2_0_ from BCT_SAVED_TEST_SET_ROUTES_T bctsavedte0_ where bctsavedte0_.SAVED_TEST_SET_OID=?
01:29:57,826 DEBUG OneToManyLoader:98 - Static select for one-to-many net.idt.bct.db.vo.BctSavedTestSetT.bctSavedTestSetNums: select bctsavedte0_.SAVED_TEST_SET_OID as SAVED1___, bctsavedte0_.PHONE_NUM as PHONE2___, bctsavedte0_.SAVED_TEST_SET_OID as SAVED1_0_, bctsavedte0_.PHONE_NUM as PHONE2_0_, bctsavedte0_.ROUTING_LOC as ROUTING3_6_0_ from BCT_SAVED_TEST_SET_NUM_T bctsavedte0_ where bctsavedte0_.SAVED_TEST_SET_OID=?
01:29:57,827 DEBUG OneToManyLoader:98 - Static select for one-to-many net.idt.bct.db.vo.BctTestSetT.bctTestSetNums: select bcttestset0_.TEST_SET_OID as TEST1___, bcttestset0_.PHONE_NUM as PHONE2___, bcttestset0_.TEST_SET_OID as TEST1_2_, bcttestset0_.PHONE_NUM as PHONE2_2_, bcttestset0_.CALL_TIME as CALL3_4_2_, bcttestset0_.SIGNALING_PDD as SIGNALING4_4_2_, bcttestset0_.CALL_ID as CALL5_4_2_, bcttestset0_.ROUTING_LOC as ROUTING6_4_2_, bcttestset0_.RESULT as RESULT4_2_, bcttestset0_.SIP_STATUS_CODE as SIP8_4_2_, bcttestset0_.TEST_SET_OID as TEST1_4_2_, bctresultc1_.RESULT_CODE as RESULT1_0_, bctresultc1_.SUCCESS_FLAG as SUCCESS2_11_0_, bctresultc1_.DESCR as DESCR11_0_, bctsipstat2_.STATUS_CODE as STATUS1_1_, bctsipstat2_.DESCR as DESCR10_1_ from BCT_TEST_SET_NUM_T bcttestset0_ left outer join BCT_RESULT_CODE_T bctresultc1_ on bcttestset0_.RESULT=bctresultc1_.RESULT_CODE left outer join BCT_SIP_STATUS_CODE_T bctsipstat2_ on bcttestset0_.SIP_STATUS_CODE=bctsipstat2_.STATUS_CODE where bcttestset0_.TEST_SET_OID=?
01:29:58,002 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
01:29:58,007 DEBUG SessionFactoryObjectFactory:76 - registered: ff80808103686237010368623b440000 (unnamed)
01:29:58,008 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
01:29:58,009 DEBUG SessionFactoryImpl:256 - instantiated session factory
01:29:58,013 INFO UpdateTimestampsCache:43 - starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
01:29:58,013 WARN EhCacheProvider:97 - Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
01:29:58,014 DEBUG MemoryStore:147 - org.hibernate.cache.UpdateTimestampsCache Cache: Using SpoolingLinkedHashMap implementation
01:29:58,014 DEBUG MemoryStore:128 - initialized MemoryStore for org.hibernate.cache.UpdateTimestampsCache
01:29:58,015 DEBUG Cache:277 - Initialised cache: org.hibernate.cache.UpdateTimestampsCache
01:29:58,015 DEBUG EhCacheProvider:100 - started EHCache region: org.hibernate.cache.UpdateTimestampsCache
01:29:58,018 INFO StandardQueryCache:50 - starting query cache at region: org.hibernate.cache.StandardQueryCache
01:29:58,018 WARN EhCacheProvider:97 - Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
01:29:58,019 DEBUG MemoryStore:147 - org.hibernate.cache.StandardQueryCache Cache: Using SpoolingLinkedHashMap implementation
01:29:58,019 DEBUG MemoryStore:128 - initialized MemoryStore for org.hibernate.cache.StandardQueryCache
01:29:58,021 DEBUG Cache:277 - Initialised cache: org.hibernate.cache.StandardQueryCache
01:29:58,022 DEBUG EhCacheProvider:100 - started EHCache region: org.hibernate.cache.StandardQueryCache
01:29:58,023 INFO SessionFactoryImpl:373 - Checking 0 named queries
01:29:58,095 DEBUG SessionImpl:237 - opened session at timestamp: 4563549380714496
01:29:58,108 DEBUG SessionImpl:777 - find: from BctCountryRouteLocT
01:29:58,110 DEBUG QueryParameters:220 - named parameters: {}
01:29:58,195 DEBUG QueryTranslatorImpl:207 - parse() - HQL: from net.idt.bct.db.vo.BctCountryRouteLocT
01:29:58,210 DEBUG AST:223 - --- HQL AST ---
\-[QUERY] 'query'
\-[SELECT_FROM] 'SELECT_FROM'
\-[FROM] 'from'
\-[RANGE] 'RANGE'
\-[DOT] '.'
+-[DOT] '.'
| +-[DOT] '.'
| | +-[DOT] '.'
| | | +-[DOT] '.'
| | | | +-[IDENT] 'net'
| | | | \-[IDENT] 'idt'
| | | \-[IDENT] 'bct'
| | \-[IDENT] 'db'
| \-[IDENT] 'vo'
\-[IDENT] 'BctCountryRouteLocT'

01:29:58,210 DEBUG ErrorCounter:72 - throwQueryException() : no errors
01:29:58,258 DEBUG HqlSqlBaseWalker:120 - query() << begin, level = 1
01:29:58,303 DEBUG FromElement:81 - FromClause{level=1} : net.idt.bct.db.vo.BctCountryRouteLocT (no alias) -> bctcountry0_
01:29:58,304 DEBUG HqlSqlBaseWalker:125 - query() : finishing up , level = 1
01:29:58,304 DEBUG HqlSqlWalker:331 - processQuery() : ( SELECT ( FromClause{level=1} BCT_COUNTRY_ROUTE_LOC_T bctcountry0_ ) )
01:29:58,316 DEBUG HqlSqlWalker:451 - Derived SELECT clause created.
01:29:58,327 DEBUG JoinProcessor:112 - Using FROM fragment [BCT_COUNTRY_ROUTE_LOC_T bctcountry0_]
01:29:58,327 DEBUG HqlSqlBaseWalker:128 - query() >> end, level = 1
01:29:58,348 DEBUG AST:193 - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (BCT_COUNTRY_ROUTE_LOC_T)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| +-[SELECT_EXPR] SelectExpressionImpl: 'bctcountry0_.COUNTRY_ROUTE_LOC_OID as COUNTRY1_' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=BCT_COUNTRY_ROUTE_LOC_T,tableAlias=bctcountry0_,colums={,className=net.idt.bct.db.vo.BctCountryRouteLocT}}}
| \-[SQL_TOKEN] SqlFragment: 'bctcountry0_.COUNTRY_CODE as COUNTRY3_1_, bctcountry0_.ROUTE_LOC as ROUTE4_1_'
\-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[], fromElementByTableAlias=[bctcountry0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
\-[FROM_FRAGMENT] FromElement: 'BCT_COUNTRY_ROUTE_LOC_T bctcountry0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=null,role=null,tableName=BCT_COUNTRY_ROUTE_LOC_T,tableAlias=bctcountry0_,colums={,className=net.idt.bct.db.vo.BctCountryRouteLocT}}

01:29:58,349 DEBUG ErrorCounter:72 - throwQueryException() : no errors
01:29:58,366 DEBUG QueryTranslatorImpl:177 - HQL: from net.idt.bct.db.vo.BctCountryRouteLocT
01:29:58,367 DEBUG QueryTranslatorImpl:178 - SQL: select bctcountry0_.COUNTRY_ROUTE_LOC_OID as COUNTRY1_, bctcountry0_.COUNTRY_CODE as COUNTRY3_1_, bctcountry0_.ROUTE_LOC as ROUTE4_1_ from BCT_COUNTRY_ROUTE_LOC_T bctcountry0_
01:29:58,368 DEBUG ErrorCounter:72 - throwQueryException() : no errors
01:29:58,374 DEBUG AbstractBatcher:276 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
01:29:58,375 DEBUG AbstractBatcher:414 - opening JDBC connection
01:29:58,375 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
01:29:58,376 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
01:29:58,376 DEBUG SQL:310 - select bctcountry0_.COUNTRY_ROUTE_LOC_OID as COUNTRY1_, bctcountry0_.COUNTRY_CODE as COUNTRY3_1_, bctcountry0_.ROUTE_LOC as ROUTE4_1_ from BCT_COUNTRY_ROUTE_LOC_T bctcountry0_
01:29:58,379 DEBUG AbstractBatcher:364 - preparing statement
01:29:58,565 DEBUG AbstractBatcher:292 - about to open ResultSet (open ResultSets: 0, globally: 0)
01:29:58,568 DEBUG Loader:382 - processing result set
01:29:58,569 DEBUG Loader:387 - result set row: 0
01:29:58,602 DEBUG IntegerType:86 - returning '4773' as column: COUNTRY1_
01:29:58,606 DEBUG Loader:762 - result row: EntityKey[net.idt.bct.db.vo.BctCountryRouteLocT#4773]
01:29:58,607 DEBUG Loader:912 - Initializing object from ResultSet: [net.idt.bct.db.vo.BctCountryRouteLocT#4773]
01:29:58,613 DEBUG BasicEntityPersister:1660 - Hydrating entity: [net.idt.bct.db.vo.


Top
 Profile  
 
 Post subject: problem gone
PostPosted: Fri Apr 22, 2005 9:43 am 
Newbie

Joined: Thu Apr 21, 2005 11:34 am
Posts: 4
After trying to debug this till 3 in the morning found nothing. Tried to debug later in the morning the removed all the other mapping entry in the hivernate.cfg.xml file . The problem went away. Reintroduced all the mappings again and the problem do not re-occur.
Strange but true. Maybe I was missing something.


Top
 Profile  
 
 Post subject: H3 SQL Select not requesting all columns but assigning PK.
PostPosted: Wed Jul 13, 2005 4:35 pm 
Newbie

Joined: Thu Jun 09, 2005 8:21 am
Posts: 3
I'm having a similar problem to gkrishna.

SQL: Select is not requesting all columns and assigning PK value to missing column in Hibernate3 that was working in Hibernate2.

I have a mapping file generated with MiddleGen for Hibernate2. I've changed the DTD for Hibernate3 and changed to lazy="false". The table looks like:

CATEGORY
CATEGORY_ID LONG PK
CATEGORY VARCHAR(?)
...

When I run the select the value for the primary key is assigned to both these fields even though they are different types.

CategoryDO.hbm.xml
<class
name="com.....CategoryDO"
table="CATEGORY"
schema="DB2ADMIN"
dynamic-update="true"
dynamic-insert="true"
lazy="false"
>
<meta attribute="class-description" inherit="false">
Generated by Middlegen/Hibernate - DO NOT EDIT!
</meta>
<meta attribute="extends" inherit="false">KCDataObject</meta>
<meta attribute="implement-equals" inherit="false">true</meta>

<id
name="categoryId"
type="java.lang.Long"
column="CATEGORY_ID"
>
<meta attribute="field-description" inherit="false">
Primary Key for table
</meta>

<meta attribute="use-in-equals">true</meta>
<generator class="sequence">
<param name="sequence">CATEGORY_SEQ</param>
</generator>
</id>

<property
name="category"
type="java.lang.String"
column="CATEGORY"
not-null="true"
length="80"
>
<meta attribute="use-in-tostring">true</meta>
<meta attribute="use-in-equals">true</meta>
</property>
...

Generated SQL:
select
this_.CATEGORY_ID as CATEGORY1_4_,
this_.DESCRIPTION as DESCRIPT3_1_4_,
this_.DISPLAY_ORDER as DISPLAY4_1_4_,
this_.HIERARCHY_LEVEL as HIERARCHY5_1_4_,
this_.PARENT_ID as PARENT6_1_4_,
this_.LOCALE_ID as LOCALE7_1_4_,
categorydo2_.CATEGORY_ID as CATEGORY1_0_,
categorydo2_.DESCRIPTION as DESCRIPT3_1_0_,
categorydo2_.DISPLAY_ORDER as DISPLAY4_1_0_,
categorydo2_.HIERARCHY_LEVEL as HIERARCHY5_1_0_,
categorydo2_.PARENT_ID as PARENT6_1_0_,
categorydo2_.LOCALE_ID as LOCALE7_1_0_,
localedo3_.LOCALE_ID as LOCALE1_1_,
localedo3_.CODE as CODE12_1_,
localedo3_.LANGUAGE_ID as LANGUAGE3_12_1_,
localedo3_.COUNTRY_ID as COUNTRY4_12_1_,
languagedo4_.LANGUAGE_ID as LANGUAGE1_2_,
languagedo4_.CODE as CODE11_2_,
languagedo4_.NAME as NAME11_2_,
countrydo5_.COUNTRY_ID as COUNTRY1_3_,
countrydo5_.CODE as CODE7_3_,
countrydo5_.NAME as NAME7_3_
from DB2ADMIN.CATEGORY this_
left outer join DB2ADMIN.CATEGORY categorydo2_ on this_.PARENT_ID=categorydo2_.CATEGORY_ID
left outer join DB2ADMIN.LOCALE localedo3_ on categorydo2_.LOCALE_ID=localedo3_.LOCALE_ID
left outer join DB2ADMIN.LANGUAGE languagedo4_ on localedo3_.LANGUAGE_ID=languagedo4_.LANGUAGE_ID
left outer join DB2ADMIN.COUNTRY countrydo5_ on localedo3_.COUNTRY_ID=countrydo5_.COUNTRY_ID

Note that there is no field name for CATEGORY only CATEGORY_ID.
Dump of the query:

CategoryDO{hierarchyLevel=2, categoryDO=com...CategoryDO#3, displayOrder=9999, description=null, category=6, localeDO=com...LocaleDO#1, categoryId=6}

CategoryDO{hierarchyLevel=2, categoryDO=com...CategoryDO#2, displayOrder=9999, description=null, category=4, localeDO=com...LocaleDO#1, categoryId=4}

CategoryDO{hierarchyLevel=1, categoryDO=com...CategoryDO#1, displayOrder=9999, description=null, category=2, localeDO=com...LocaleDO#1, categoryId=2}

CategoryDO{hierarchyLevel=1, categoryDO=com...CategoryDO#2, displayOrder=1, description=description, category=9, localeDO=com...LocaleDO#1, categoryId=9}

CategoryDO{hierarchyLevel=3, categoryDO=com...CategoryDO#6, displayOrder=9999, description=null, category=7, localeDO=com...LocaleDO#1, categoryId=7}

CategoryDO{hierarchyLevel=0, categoryDO=null, displayOrder=1, description=null, category=1, localeDO=com...LocaleDO#1, categoryId=1}

CategoryDO{hierarchyLevel=1, categoryDO=com...CategoryDO#1, displayOrder=9999, description=null, category=3, localeDO=com...LocaleDO#1, categoryId=3}

CategoryDO{hierarchyLevel=3, categoryDO=com...CategoryDO#4, displayOrder=9999, description=null, category=5, localeDO=com...LocaleDO#1, categoryId=5}

After the values from the database are assigned to the class and I dump the class with toString, the value for categoryId is also assigned to category.

I'm having essentially the same problem as gkrishna. I tried moving the problem column around in the hbm.xml file, but continued to have the problem.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 13, 2005 6:17 pm 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia
I have no idea what either of you are trying to communicate here.


Top
 Profile  
 
 Post subject: Summary of previous post, hopefully clarifying it.
PostPosted: Thu Jul 14, 2005 8:58 am 
Newbie

Joined: Thu Jun 09, 2005 8:21 am
Posts: 3
In summary of my previous post:
Hibernate3 fails to retrieve the value from all the columns in each record, but assigns the value of the primary key to the missing field.

For example:

this is the class and the corresponding table:
class Foo {
long primaryKey;
String field2;
int field3;
}

table FOO (
id LONG,
field2 VARCHAR(80),
field3 INTEGER)

Hibernate3 generates a select which is missing field2:
select id, field3 from foo;

Record in table FOO:
id = 3, field2 = 'this is an example', field3 = 9;

Hibernate3 creates an instance of class Foo and assigns values like
id = 3, field2 = "3", field3 = 9

Note that the select did not retrieve the value from the database for field2, but assigned it the value of the primary key, id.

I'm note sure why, but some interesting information that may be part of the reason, my table and the missing column have the same name. The name of the primary key is similar to the name of the missing column in the hbm.xml file. In my situation the mapping is:

<class
name="com.ibm...CategoryDO"
table="CATEGORY"
>
<id
name="categoryId"
type="java.lang.Long"
column="CATEGORY_ID"
>
...
<property
name="category"
type="java.lang.String"
column="CATEGORY"
not-null="true"
length="80"
>

corresponding class:
class CategoryDO {
Long categoryId;
String category;
...
}

table CATEGORY (
CATEGORY_ID LONG,
CATEGORY VARCHAR(80),
...
)

If this doesn't clarify the information it might be easier to handle it via email or directly instead of the public forum. We can post the conclusions later.

Regards,
John M. Evans
johnevans@us.ibm.com


Top
 Profile  
 
 Post subject: H3 SQL Select not requesting all columns but assigning PK.
PostPosted: Tue Jul 19, 2005 12:17 pm 
Newbie

Joined: Mon Sep 08, 2003 12:26 pm
Posts: 3
I'm experiencing the same problem as John.

Hibernate3.0.5 fails to retrieve the value from all columns in each record, but assigns the primary key to the missing field. Table and missing column have the same name.

Has their been any further resolutions?

John, I'm assuming you are using db2 from the DB2ADMIN schema.

I'm using the as400, wonder if there is a relation.

Dan


Last edited by deng01 on Wed Jun 16, 2010 2:10 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject: H3 SQL Select not requesting all columns but assigning PK.
PostPosted: Thu Jul 21, 2005 6:28 pm 
Newbie

Joined: Mon Sep 08, 2003 12:26 pm
Posts: 3
Hibernate 3.1 beta 1 has corrected the problem.

Thanks Hibernate team

Dan


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 

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.