-->
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.  [ 5 posts ] 
Author Message
 Post subject: Session Binding issue
PostPosted: Wed Oct 05, 2005 7:47 am 
Newbie

Joined: Wed Feb 23, 2005 2:08 pm
Posts: 17
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

We have implemented a custom naming strategy for our application, it works fine. We would like to only invoke hibernate.hbbm2ddl.auto as
a stand alone application. I have gone over chapter 4 and still get the following binding exception when running it as a standalone.
Any help would be greatly appreciated.

Scott

Hibernate version:3.05

Mapping documents:
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory name="java:hibernate/SessionFactory">
<property name="show_sql">false</property>

<!-- database settings -->
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>

<property name="connection.username">cldomain</property>
<property name="connection.password">cldomain</property>
<property name="hibernate.hbbm2ddl.auto">create</property>

<property name="connection.driver_class">oracle.jdbc.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:cldomain</property>
<property name="c3p0.min_size">5</property>
<property name="c3p0.max_size">20</property>
<property name="c3p0.timeout">1800</property>
<property name="c3p0.max_statements">50</property>



<mapping resource="com/cl/entity/action/vo/Action.hbm.xml" />
<mapping resource="com/cl/entity/action/vo/BusinessAction.hbm.xml" />
<mapping resource="com/cl/entity/application/vo/Application.hbm.xml" />
<mapping resource="com/cl/entity/application/vo/AutoLoanAppProduct.hbm.xml" />
<mapping resource="com/cl/entity/businessentity/vo/BusinessEntity.hbm.xml" />
<mapping resource="com/cl/entity/common/vo/Address.hbm.xml" />
<mapping resource="com/cl/entity/common/vo/Contact.hbm.xml" />
<mapping resource="com/cl/entity/common/vo/Person.hbm.xml" />
<mapping resource="com/cl/entity/consumer/vo/Consumer.hbm.xml" />
<mapping resource="com/cl/entity/consumer/vo/EmploymentDetail.hbm.xml" />
<mapping resource="com/cl/entity/decision/vo/Outcome.hbm.xml" />
<mapping resource="com/cl/entity/order/vo/Contract.hbm.xml" />
<mapping resource="com/cl/entity/order/vo/Order.hbm.xml" />
<mapping resource="com/cl/entity/order/vo/Offer.hbm.xml" />
<mapping resource="com/cl/entity/product/vo/Product.hbm.xml" />
<mapping resource="com/cl/entity/product/vo/ProductBundle.hbm.xml" />
<mapping resource="com/cl/entity/product/vo/ProductCategory.hbm.xml" />
<mapping resource="com/cl/entity/referencedata/vo/ReferenceData.hbm.xml" />
<mapping resource="com/cl/entity/system/vo/LoginInfo.hbm.xml" />
<mapping resource="com/cl/entity/system/vo/Privilege.hbm.xml" />
<mapping resource="com/cl/entity/system/vo/Role.hbm.xml" />

</session-factory>
</hibernate-configuration>



Code between sessionFactory.openSession() and session.close():


Configuration config = new Configuration();
config.setNamingStrategy(new CLPropertyNamingStrategy());
config.configure("/hibernate.cfg.xml");
config.buildSessionFactory();



Full stack trace of any exception that occurs:

Name and version of the database you are using:Oracle 9i

The generated SQL (show_sql=true):

[b]Debug level Hibernate log excerpt:
05 Oct 2005 07:33:37,767 [INFO] Environment.<clinit> - Hibernate 3.0.5
05 Oct 2005 07:33:37,767 [INFO] Environment.<clinit> - hibernate.properties not found
05 Oct 2005 07:33:37,777 [INFO] Environment.<clinit> - using CGLIB reflection optimizer
05 Oct 2005 07:33:37,777 [INFO] Environment.<clinit> - using JDK 1.4 java.sql.Timestamp handling
05 Oct 2005 07:33:37,867 [DEBUG] CLPropertyNamingStrategy.<init> - instance created
05 Oct 2005 07:33:37,867 [INFO] Configuration.configure - configuring from resource: /hibernate.cfg.xml
05 Oct 2005 07:33:37,867 [INFO] Configuration.getConfigurationInputStream - Configuration resource: /hibernate.cfg.xml
05 Oct 2005 07:33:37,927 [DEBUG] DTDEntityResolver.resolveEntity - trying to locate http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath under org/hibernate/
05 Oct 2005 07:33:37,927 [DEBUG] DTDEntityResolver.resolveEntity - found http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath
05 Oct 2005 07:33:37,977 [DEBUG] Configuration.addProperties - show_sql=false
05 Oct 2005 07:33:37,977 [DEBUG] Configuration.addProperties - dialect=org.hibernate.dialect.Oracle9Dialect
05 Oct 2005 07:33:37,977 [DEBUG] Configuration.addProperties - connection.username=cldomain
05 Oct 2005 07:33:37,977 [DEBUG] Configuration.addProperties - connection.password=cldomain
05 Oct 2005 07:33:37,977 [DEBUG] Configuration.addProperties - connection.driver_class=oracle.jdbc.OracleDriver
05 Oct 2005 07:33:37,977 [DEBUG] Configuration.addProperties - connection.url=jdbc:oracle:thin:@localhost:1521:cldomain
05 Oct 2005 07:33:37,977 [DEBUG] Configuration.addProperties - c3p0.min_size=5
05 Oct 2005 07:33:37,987 [DEBUG] Configuration.addProperties - c3p0.max_size=20
05 Oct 2005 07:33:37,987 [DEBUG] Configuration.addProperties - c3p0.timeout=1800
05 Oct 2005 07:33:37,987 [DEBUG] Configuration.addProperties - c3p0.max_statements=50
05 Oct 2005 07:33:37,987 [DEBUG] Configuration.parseMappingElement - java:hibernate/SessionFactory<-org.dom4j.tree.DefaultAttribute@1f54c5f [Attribute: name resource value "com/cl/entity/action/vo/Action.hbm.xml"]
05 Oct 2005 07:33:37,987 [INFO] Configuration.addResource - Mapping resource: com/cl/entity/action/vo/Action.hbm.xml
05 Oct 2005 07:33:37,987 [DEBUG] DTDEntityResolver.resolveEntity - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
05 Oct 2005 07:33:37,987 [DEBUG] DTDEntityResolver.resolveEntity - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
05 Oct 2005 07:33:39,359 [DEBUG] HbmBinder.doSecondPass - Mapped collection key: role_id, element: privilege_id
05 Oct 2005 07:33:39,359 [INFO] Configuration.secondPassCompile - processing association property references
05 Oct 2005 07:33:39,359 [INFO] Configuration.secondPassCompile - processing foreign key constraints
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.businessentity.vo.BusinessEntity
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.common.vo.Address
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.product.vo.Product
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.application.vo.Application
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.product.vo.AutomobileProduct
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.product.vo.AutomobileProduct
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.application.vo.AutoLoanApp
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.common.vo.Address
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.common.vo.Address
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.consumer.vo.Consumer
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.common.vo.Address
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.consumer.vo.Consumer
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.application.vo.Application
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.common.vo.Contact
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.consumer.vo.Consumer
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.consumer.vo.EmploymentDetail
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.consumer.vo.Consumer
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.order.vo.Offer
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.application.vo.Application
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.common.vo.Contact
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.common.vo.Address
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.product.vo.Product
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.order.vo.Offer
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.application.vo.Application
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.order.vo.Order
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.action.vo.Action
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.businessentity.vo.BusinessEntity
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.consumer.vo.Consumer
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.common.vo.Person
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.businessentity.vo.BusinessEntity
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.consumer.vo.Consumer
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.system.vo.LoginInfo
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.consumer.vo.Consumer
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.common.vo.Person
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.product.vo.ProductBundle
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.product.vo.Product
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.product.vo.ProductCategory
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.product.vo.Product
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.consumer.vo.Consumer
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.common.vo.Person
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.system.vo.Role
05 Oct 2005 07:33:39,359 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.consumer.vo.Consumer
05 Oct 2005 07:33:39,369 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.common.vo.Person
05 Oct 2005 07:33:39,369 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.system.vo.Role
05 Oct 2005 07:33:39,369 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.system.vo.Privilege
05 Oct 2005 07:33:39,369 [DEBUG] Configuration.secondPassCompileForeignKeys - resolving reference to class: com.cl.entity.action.vo.Action
05 Oct 2005 07:33:39,379 [INFO] C3P0ConnectionProvider.configure - C3P0 using driver: oracle.jdbc.OracleDriver at URL: jdbc:oracle:thin:@localhost:1521:cldomain
05 Oct 2005 07:33:39,379 [INFO] C3P0ConnectionProvider.configure - Connection properties: {user=cldomain, password=****}
05 Oct 2005 07:33:39,379 [INFO] C3P0ConnectionProvider.configure - autocommit mode: false
05 Oct 2005 07:33:40,891 [DEBUG] SettingsFactory.getDatabaseMajorVersion - could not get database version from JDBC metadata
05 Oct 2005 07:33:40,891 [INFO] SettingsFactory.buildSettings - RDBMS: Oracle, version: Personal Oracle9i Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
05 Oct 2005 07:33:40,891 [INFO] SettingsFactory.buildSettings - JDBC driver: Oracle JDBC driver, version: 9.2.0.5.0
05 Oct 2005 07:33:40,971 [INFO] Dialect.<init> - Using dialect: org.hibernate.dialect.Oracle9Dialect
05 Oct 2005 07:33:40,981 [INFO] TransactionFactoryFactory.buildTransactionFactory - Using default transaction strategy (direct JDBC transactions)
05 Oct 2005 07:33:40,991 [INFO] TransactionManagerLookupFactory.getTransactionManagerLookup - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
05 Oct 2005 07:33:40,991 [INFO] SettingsFactory.buildSettings - Automatic flush during beforeCompletion(): disabled
05 Oct 2005 07:33:40,991 [INFO] SettingsFactory.buildSettings - Automatic session close at end of transaction: disabled
05 Oct 2005 07:33:40,991 [INFO] SettingsFactory.buildSettings - JDBC batch size: 15
05 Oct 2005 07:33:40,991 [INFO] SettingsFactory.buildSettings - JDBC batch updates for versioned data: disabled
05 Oct 2005 07:33:41,001 [INFO] SettingsFactory.buildSettings - Scrollable result sets: enabled
05 Oct 2005 07:33:41,001 [DEBUG] SettingsFactory.buildSettings - Wrap result sets: disabled
05 Oct 2005 07:33:41,001 [INFO] SettingsFactory.buildSettings - JDBC3 getGeneratedKeys(): disabled
05 Oct 2005 07:33:41,001 [INFO] SettingsFactory.buildSettings - Connection release mode: null
05 Oct 2005 07:33:41,001 [INFO] SettingsFactory.buildSettings - Default batch fetch size: 1
05 Oct 2005 07:33:41,001 [INFO] SettingsFactory.buildSettings - Generate SQL with comments: disabled
05 Oct 2005 07:33:41,001 [INFO] SettingsFactory.buildSettings - Order SQL updates by primary key: disabled
05 Oct 2005 07:33:41,001 [INFO] SettingsFactory.createQueryTranslatorFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
05 Oct 2005 07:33:41,001 [INFO] ASTQueryTranslatorFactory.<init> - Using ASTQueryTranslatorFactory
05 Oct 2005 07:33:41,001 [INFO] SettingsFactory.buildSettings - Query language substitutions: {}
05 Oct 2005 07:33:41,001 [INFO] SettingsFactory.buildSettings - Second-level cache: enabled
05 Oct 2005 07:33:41,001 [INFO] SettingsFactory.buildSettings - Query cache: disabled
05 Oct 2005 07:33:41,001 [INFO] SettingsFactory.createCacheProvider - Cache provider: org.hibernate.cache.EhCacheProvider
05 Oct 2005 07:33:41,022 [INFO] SettingsFactory.buildSettings - Optimize cache for minimal puts: disabled
05 Oct 2005 07:33:41,022 [INFO] SettingsFactory.buildSettings - Structured second-level cache entries: disabled
05 Oct 2005 07:33:41,022 [DEBUG] SQLExceptionConverterFactory.buildSQLExceptionConverter - Using dialect defined converter
05 Oct 2005 07:33:41,032 [INFO] SettingsFactory.buildSettings - Statistics: disabled
05 Oct 2005 07:33:41,032 [INFO] SettingsFactory.buildSettings - Deleted entity synthetic identifier rollback: disabled
05 Oct 2005 07:33:41,032 [INFO] SettingsFactory.buildSettings - Default entity-mode: pojo
05 Oct 2005 07:33:41,252 [INFO] SessionFactoryImpl.<init> - building session factory
05 Oct 2005 07:33:41,252 [DEBUG] SessionFactoryImpl.<init> - Session factory constructed with filter configurations : {}
05 Oct 2005 07:33:41,252 [DEBUG] SessionFactoryImpl.<init> - instantiating session factory with properties: {java.vendor=Sun Microsystems Inc., show_sql=false, hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:cldomain, sun.management.compiler=HotSpot Client Compiler, c3p0.min_size=5, os.name=Windows XP, sun.boot.class.path=C:\Program Files\Java\jre1.5.0_04\lib\rt.jar;C:\Program Files\Java\jre1.5.0_04\lib\i18n.jar;C:\Program Files\Java\jre1.5.0_04\lib\sunrsasign.jar;C:\Program Files\Java\jre1.5.0_04\lib\jsse.jar;C:\Program Files\Java\jre1.5.0_04\lib\jce.jar;C:\Program Files\Java\jre1.5.0_04\lib\charsets.jar;C:\Program Files\Java\jre1.5.0_04\classes, sun.desktop=windows, hibernate.c3p0.max_size=20, java.vm.specification.vendor=Sun Microsystems Inc., c3p0.max_size=20, java.runtime.version=1.5.0_04-b05, hibernate.c3p0.min_size=5, user.name=sburns, hibernate.session_factory_name=java:hibernate/SessionFactory, connection.driver_class=oracle.jdbc.OracleDriver, hibernate.c3p0.timeout=1800, user.language=en, sun.boot.library.path=C:\Program Files\Java\jre1.5.0_04\bin, dialect=org.hibernate.dialect.Oracle9Dialect, java.version=1.5.0_04, user.timezone=America/New_York, sun.arch.data.model=32, java.endorsed.dirs=C:\Program Files\Java\jre1.5.0_04\lib\endorsed, sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86, sun.jnu.encoding=Cp1252, file.encoding.pkg=sun.io, file.separator=\, java.specification.name=Java Platform API Specification, hibernate.cglib.use_reflection_optimizer=true, java.class.version=49.0, user.country=US, connection.url=jdbc:oracle:thin:@localhost:1521:cldomain, java.home=C:\Program Files\Java\jre1.5.0_04, java.vm.info=mixed mode, os.version=5.1, path.separator=;, connection.password=cldomain, java.vm.version=1.5.0_04-b05, hibernate.connection.password=cldomain, user.variant=, java.awt.printerjob=sun.awt.windows.WPrinterJob, sun.io.unicode.encoding=UnicodeLittle, awt.toolkit=sun.awt.windows.WToolkit, hibernate.connection.username=cldomain, user.home=C:\Documents and Settings\sburns, java.specification.vendor=Sun Microsystems Inc., java.library.path=C:\Program Files\Java\jre1.5.0_04\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jre1.5.0_04\bin;C:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Attachmate\EXTRA!\;C:\PROGRA~1\CA\Common\SCANEN~1;C:\Inoculan;c:\unixtools\bin, java.vendor.url=http://java.sun.com/, hibernate.connection.driver_class=oracle.jdbc.OracleDriver, connection.username=cldomain, java.vm.vendor=Sun Microsystems Inc., hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, java.class.path=C:\eclipse_workspace\dfsp_vo\bin;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\spring.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\axis.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\c3p0-0.8.4.5.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\commons-beanutils.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\commons-digester.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\commons-discovery-0.2.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\commons-lang.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\commons-logging.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\commons-validator.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\dom4j-1.4.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\hibernate3.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\wsdl4j-1.5.1.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\jaxrpc.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\junit.jar;C:\Programs\Tomcat5.5\common\lib\servlet-api.jar;C:\Programs\Tomcat5.5\server\lib\catalina-ant.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\log4j-1.2.8.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\axis-ant.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\saaj.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\aopalliance.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\ojdbc14.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\jta.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\odmg-3.0.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\cglib-full-2.0.1.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\commons-collections-2.0.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\commons-collections.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\hibernate-tools.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\antlr-2.7.5H3.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\ehcache-1.1.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\jms-1.1.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\xalan.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\xercesImpl.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\xml-apis.jar;C:\oracle\ora92\jdbc\lib\classes12.jar;C:\Programs\Tomcat5.5\common\lib\jsp-api.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\tibjms.jar;C:\eclipse_workspace\dfsp_vo\web\WEB-INF\lib\spring-beans.jar, c3p0.timeout=1800, java.vm.specification.name=Java Virtual Machine Specification, java.vm.specification.version=1.0, sun.cpu.endian=little, sun.os.patch.level=Service Pack 2, java.io.tmpdir=C:\DOCUME~1\sburns\LOCALS~1\Temp\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, os.arch=x86, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.ext.dirs=C:\Program Files\Java\jre1.5.0_04\lib\ext, user.dir=C:\eclipse_workspace\dfsp_vo, line.separator=
, java.vm.name=Java HotSpot(TM) Client VM, file.encoding=Cp1252, java.specification.version=1.5, c3p0.max_statements=50, hibernate.c3p0.max_statements=50, hibernate.show_sql=false}
05 Oct 2005 07:33:41,262 [DEBUG] CacheManager.create - Creating new CacheManager with default config
05 Oct 2005 07:33:41,262 [DEBUG] CacheManager.configure - Configuring ehcache from classpath.
05 Oct 2005 07:33:41,272 [WARN] Configurator.configure - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/eclipse_workspace/dfsp_vo/web/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
05 Oct 2005 07:33:41,282 [DEBUG] Configuration$DiskStore.setPath - Disk Store Path: C:\DOCUME~1\sburns\LOCALS~1\Temp\
05 Oct 2005 07:33:41,542 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.product.vo.ProductCategory
05 Oct 2005 07:33:41,542 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from PRODUCT_CATEGORY where oid =?
05 Oct 2005 07:33:41,542 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select productcat_.oid, productcat_.name as name33_, productcat_.description as descript3_33_, productcat_.created_by as created4_33_, productcat_.created_on as created5_33_, productcat_.updated_by as updated6_33_, productcat_.updated_on as updated7_33_ from PRODUCT_CATEGORY productcat_ where productcat_.oid=?
05 Oct 2005 07:33:41,542 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into PRODUCT_CATEGORY (name, description, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:41,542 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update PRODUCT_CATEGORY set name=?, description=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:41,542 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from PRODUCT_CATEGORY where oid=?
05 Oct 2005 07:33:41,562 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.product.vo.ProductBundle
05 Oct 2005 07:33:41,572 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from PRODUCT_BUNDLE where oid =?
05 Oct 2005 07:33:41,572 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select productbun_.oid, productbun_.iso_currency_code as iso2_31_, productbun_.price as price31_, productbun_.created_by as created4_31_, productbun_.created_on as created5_31_, productbun_.updated_by as updated6_31_, productbun_.updated_on as updated7_31_ from PRODUCT_BUNDLE productbun_ where productbun_.oid=?
05 Oct 2005 07:33:41,572 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into PRODUCT_BUNDLE (iso_currency_code, price, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:41,572 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update PRODUCT_BUNDLE set iso_currency_code=?, price=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:41,572 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from PRODUCT_BUNDLE where oid=?
05 Oct 2005 07:33:41,602 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.application.vo.Application
05 Oct 2005 07:33:41,602 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from APPLICATION where oid =?
05 Oct 2005 07:33:41,602 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select applicatio_.oid, applicatio_.category_code as category2_3_, applicatio_.channel_code as channel3_3_, applicatio_.comments as comments3_, applicatio_.point_of_sale_id as point5_3_, applicatio_.sales_person_id as sales6_3_, applicatio_.status_code as status7_3_, applicatio_.type_code as type8_3_, applicatio_.created_by as created9_3_, applicatio_.created_on as created10_3_, applicatio_.updated_by as updated11_3_, applicatio_.updated_on as updated12_3_ from APPLICATION applicatio_ where applicatio_.oid=?
05 Oct 2005 07:33:41,602 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into APPLICATION (category_code, channel_code, comments, point_of_sale_id, sales_person_id, status_code, type_code, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:41,602 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update APPLICATION set category_code=?, channel_code=?, comments=?, point_of_sale_id=?, sales_person_id=?, status_code=?, type_code=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:41,602 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from APPLICATION where oid=?
05 Oct 2005 07:33:41,652 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.order.vo.InstallmentLoanOffer
05 Oct 2005 07:33:41,652 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from OFFER where oid =?
05 Oct 2005 07:33:41,652 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select installmen_.installment_loan_offer, installmen_1_.application_id as applicat2_26_, installmen_1_.status_code as status3_26_, installmen_1_.created_by as created4_26_, installmen_1_.created_on as created5_26_, installmen_1_.updated_by as updated6_26_, installmen_1_.updated_on as updated7_26_, installmen_.financed_amt as financed2_27_, installmen_.iso_currency_code as iso3_27_, installmen_.max_amt as max4_27_, installmen_.monthly_payment as monthly5_27_, installmen_.rate as rate27_, installmen_.term_in_months as term7_27_ from INSTALLMENT_LOAN_OFFER installmen_ inner join OFFER installmen_1_ on installmen_.installment_loan_offer=installmen_1_.oid where installmen_.installment_loan_offer=?
05 Oct 2005 07:33:41,652 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into OFFER (application_id, status_code, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:41,652 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update OFFER set application_id=?, status_code=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:41,652 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from OFFER where oid=?
05 Oct 2005 07:33:41,652 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 1: insert into INSTALLMENT_LOAN_OFFER (financed_amt, iso_currency_code, max_amt, monthly_payment, rate, term_in_months, installment_loan_offer) values (?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:41,652 [DEBUG] BasicEntityPersister.logStaticSQL - Update 1: update INSTALLMENT_LOAN_OFFER set financed_amt=?, iso_currency_code=?, max_amt=?, monthly_payment=?, rate=?, term_in_months=? where installment_loan_offer=?
05 Oct 2005 07:33:41,652 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 1: delete from INSTALLMENT_LOAN_OFFER where installment_loan_offer=?
05 Oct 2005 07:33:41,682 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.system.vo.Role
05 Oct 2005 07:33:41,682 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from ROLE where oid =?
05 Oct 2005 07:33:41,682 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select role_.oid, role_.description as descript2_38_ from ROLE role_ where role_.oid=?
05 Oct 2005 07:33:41,682 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into ROLE (description, oid) values (?, ?)
05 Oct 2005 07:33:41,682 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update ROLE set description=? where oid=?
05 Oct 2005 07:33:41,682 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from ROLE where oid=?
05 Oct 2005 07:33:41,703 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.action.vo.SystemAction
05 Oct 2005 07:33:41,703 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from ACTION where oid =?
05 Oct 2005 07:33:41,703 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select systemacti_.system_action, systemacti_1_.created_by as created2_0_, systemacti_1_.created_on as created3_0_, systemacti_1_.updated_by as updated4_0_, systemacti_1_.updated_on as updated5_0_ from SYSTEM_ACTION systemacti_ inner join ACTION systemacti_1_ on systemacti_.system_action=systemacti_1_.oid where systemacti_.system_action=?
05 Oct 2005 07:33:41,713 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into ACTION (created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?)
05 Oct 2005 07:33:41,713 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update ACTION set created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:41,713 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from ACTION where oid=?
05 Oct 2005 07:33:41,713 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 1: insert into SYSTEM_ACTION (system_action) values (?)
05 Oct 2005 07:33:41,713 [DEBUG] BasicEntityPersister.logStaticSQL - Update 1: null
05 Oct 2005 07:33:41,713 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 1: delete from SYSTEM_ACTION where system_action=?
05 Oct 2005 07:33:41,783 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.decision.vo.Outcome
05 Oct 2005 07:33:41,783 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from OUTCOME where oid =?
05 Oct 2005 07:33:41,783 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select outcome_.oid, outcome_.created_by as created2_22_, outcome_.created_on as created3_22_, outcome_.updated_by as updated4_22_, outcome_.updated_on as updated5_22_ from OUTCOME outcome_ where outcome_.oid=?
05 Oct 2005 07:33:41,783 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into OUTCOME (created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?)
05 Oct 2005 07:33:41,783 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update OUTCOME set created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:41,783 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from OUTCOME where oid=?
05 Oct 2005 07:33:41,823 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.consumer.vo.EmploymentDetail
05 Oct 2005 07:33:41,823 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from EMPLOYMENT_DETAIL where oid =?
05 Oct 2005 07:33:41,823 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select employment_.oid, employment_.address_id as address2_21_, employment_.annual_gross_income as annual3_21_, employment_.contact_id as contact4_21_, employment_.employer_name as employer5_21_, employment_.end_date as end6_21_, employment_.manager_name as manager7_21_, employment_.num_of_months as num8_21_, employment_.start_date as start9_21_ from EMPLOYMENT_DETAIL employment_ where employment_.oid=?
05 Oct 2005 07:33:41,823 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into EMPLOYMENT_DETAIL (address_id, annual_gross_income, contact_id, employer_name, end_date, manager_name, num_of_months, start_date, oid) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:41,823 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update EMPLOYMENT_DETAIL set address_id=?, annual_gross_income=?, contact_id=?, employer_name=?, end_date=?, manager_name=?, num_of_months=?, start_date=? where oid=?
05 Oct 2005 07:33:41,823 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from EMPLOYMENT_DETAIL where oid=?
05 Oct 2005 07:33:41,863 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.common.vo.Contact
05 Oct 2005 07:33:41,863 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from CONTACT where oid =?
05 Oct 2005 07:33:41,863 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select contact_.oid, contact_.email as email13_, contact_.first_name as first3_13_, contact_.full_name as full4_13_, contact_.last_name as last5_13_, contact_.phone as phone13_ from CONTACT contact_ where contact_.oid=?
05 Oct 2005 07:33:41,863 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into CONTACT (email, first_name, full_name, last_name, phone, oid) values (?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:41,863 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update CONTACT set email=?, first_name=?, full_name=?, last_name=?, phone=? where oid=?
05 Oct 2005 07:33:41,863 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from CONTACT where oid=?
05 Oct 2005 07:33:41,933 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.common.vo.Person
05 Oct 2005 07:33:41,933 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from PERSON where oid =?
05 Oct 2005 07:33:41,933 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select person_.oid, person_.cell_phone as cell2_14_, person_.first_name as first3_14_, person_.full_name as full4_14_, person_.home_phone as home5_14_, person_.last_name as last6_14_, person_.middle_name as middle7_14_, person_.prefix as prefix14_, person_.suffix as suffix14_, person_.work_phone as work10_14_, person_.created_by as created11_14_, person_.created_on as created12_14_, person_.updated_by as updated13_14_, person_.updated_on as updated14_14_ from PERSON person_ where person_.oid=?
05 Oct 2005 07:33:41,933 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into PERSON (cell_phone, first_name, full_name, home_phone, last_name, middle_name, prefix, suffix, work_phone, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:41,933 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update PERSON set cell_phone=?, first_name=?, full_name=?, home_phone=?, last_name=?, middle_name=?, prefix=?, suffix=?, work_phone=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:41,933 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from PERSON where oid=?
05 Oct 2005 07:33:41,983 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.order.vo.Offer
05 Oct 2005 07:33:41,983 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from OFFER where oid =?
05 Oct 2005 07:33:41,993 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select offer_.oid, offer_.application_id as applicat2_26_, offer_.status_code as status3_26_, offer_.created_by as created4_26_, offer_.created_on as created5_26_, offer_.updated_by as updated6_26_, offer_.updated_on as updated7_26_ from OFFER offer_ where offer_.oid=?
05 Oct 2005 07:33:41,993 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into OFFER (application_id, status_code, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:41,993 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update OFFER set application_id=?, status_code=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:41,993 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from OFFER where oid=?
05 Oct 2005 07:33:42,023 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.product.vo.Product
05 Oct 2005 07:33:42,023 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from PRODUCT where oid =?
05 Oct 2005 07:33:42,033 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select product_.oid, product_.description as descript2_28_, product_.name as name28_, product_.created_by as created4_28_, product_.created_on as created5_28_, product_.updated_by as updated6_28_, product_.updated_on as updated7_28_ from PRODUCT product_ where product_.oid=?
05 Oct 2005 07:33:42,033 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into PRODUCT (description, name, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,033 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update PRODUCT set description=?, name=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:42,033 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from PRODUCT where oid=?
05 Oct 2005 07:33:42,083 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.consumer.vo.ConsumerAddress
05 Oct 2005 07:33:42,083 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from ADDRESS where oid =?
05 Oct 2005 07:33:42,083 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select consumerad_.consumer_address, consumerad_1_.addresstype_code as addresst2_11_, consumerad_1_.country_code as country3_11_, consumerad_1_.house_number as house4_11_, consumerad_1_.postal_code as postal5_11_, consumerad_1_.state as state11_, consumerad_1_.street_direction as street7_11_, consumerad_1_.street_name as street8_11_, consumerad_1_.street_type as street9_11_, consumerad_1_.unit_number as unit10_11_, consumerad_.end_date as end2_12_, consumerad_.housing_status as housing3_12_, consumerad_.monthly_payment as monthly4_12_, consumerad_.num_of_months as num5_12_, consumerad_.start_date as start6_12_ from CONSUMER_ADDRESS consumerad_ inner join ADDRESS consumerad_1_ on consumerad_.consumer_address=consumerad_1_.oid where consumerad_.consumer_address=?
05 Oct 2005 07:33:42,083 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into ADDRESS (addresstype_code, country_code, house_number, postal_code, state, street_direction, street_name, street_type, unit_number, oid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,083 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update ADDRESS set addresstype_code=?, country_code=?, house_number=?, postal_code=?, state=?, street_direction=?, street_name=?, street_type=?, unit_number=? where oid=?
05 Oct 2005 07:33:42,083 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from ADDRESS where oid=?
05 Oct 2005 07:33:42,083 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 1: insert into CONSUMER_ADDRESS (end_date, housing_status, monthly_payment, num_of_months, start_date, consumer_address) values (?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,083 [DEBUG] BasicEntityPersister.logStaticSQL - Update 1: update CONSUMER_ADDRESS set end_date=?, housing_status=?, monthly_payment=?, num_of_months=?, start_date=? where consumer_address=?
05 Oct 2005 07:33:42,083 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 1: delete from CONSUMER_ADDRESS where consumer_address=?
05 Oct 2005 07:33:42,133 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.product.vo.AutomobileProduct
05 Oct 2005 07:33:42,133 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from PRODUCT where oid =?
05 Oct 2005 07:33:42,133 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select automobile_.automobile_product, automobile_1_.description as descript2_28_, automobile_1_.name as name28_, automobile_1_.created_by as created4_28_, automobile_1_.created_on as created5_28_, automobile_1_.updated_by as updated6_28_, automobile_1_.updated_on as updated7_28_, automobile_.iso_currency_code as iso2_29_, automobile_.list_price as list3_29_, automobile_.make as make29_, automobile_.model as model29_, automobile_.year as year29_ from AUTOMOBILE_PRODUCT automobile_ inner join PRODUCT automobile_1_ on automobile_.automobile_product=automobile_1_.oid where automobile_.automobile_product=?
05 Oct 2005 07:33:42,133 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into PRODUCT (description, name, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,133 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update PRODUCT set description=?, name=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:42,133 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from PRODUCT where oid=?
05 Oct 2005 07:33:42,133 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 1: insert into AUTOMOBILE_PRODUCT (iso_currency_code, list_price, make, model, year, automobile_product) values (?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,133 [DEBUG] BasicEntityPersister.logStaticSQL - Update 1: update AUTOMOBILE_PRODUCT set iso_currency_code=?, list_price=?, make=?, model=?, year=? where automobile_product=?
05 Oct 2005 07:33:42,133 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 1: delete from AUTOMOBILE_PRODUCT where automobile_product=?
05 Oct 2005 07:33:42,163 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.system.vo.Privilege
05 Oct 2005 07:33:42,163 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from PRIVILEGE where oid =?
05 Oct 2005 07:33:42,163 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select privilege_.oid, privilege_.description as descript2_37_ from PRIVILEGE privilege_ where privilege_.oid=?
05 Oct 2005 07:33:42,173 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into PRIVILEGE (description, oid) values (?, ?)
05 Oct 2005 07:33:42,173 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update PRIVILEGE set description=? where oid=?
05 Oct 2005 07:33:42,173 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from PRIVILEGE where oid=?
05 Oct 2005 07:33:42,193 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.businessentity.vo.BusinessEntity
05 Oct 2005 07:33:42,193 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from BUSINESS_ENTITY where oid =?
05 Oct 2005 07:33:42,223 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select businessen_.oid, businessen_.address_id as address2_8_, businessen_.business_roles_code as business3_8_, businessen_.name as name8_, businessen_.created_by as created5_8_, businessen_.created_on as created6_8_, businessen_.updated_by as updated7_8_, businessen_.updated_on as updated8_8_ from BUSINESS_ENTITY businessen_ where businessen_.oid=?
05 Oct 2005 07:33:42,223 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into BUSINESS_ENTITY (address_id, business_roles_code, name, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,223 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update BUSINESS_ENTITY set address_id=?, business_roles_code=?, name=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:42,223 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from BUSINESS_ENTITY where oid=?
05 Oct 2005 07:33:42,263 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.common.vo.Address
05 Oct 2005 07:33:42,263 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from ADDRESS where oid =?
05 Oct 2005 07:33:42,263 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select address_.oid, address_.addresstype_code as addresst2_11_, address_.country_code as country3_11_, address_.house_number as house4_11_, address_.postal_code as postal5_11_, address_.state as state11_, address_.street_direction as street7_11_, address_.street_name as street8_11_, address_.street_type as street9_11_, address_.unit_number as unit10_11_ from ADDRESS address_ where address_.oid=?
05 Oct 2005 07:33:42,273 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into ADDRESS (addresstype_code, country_code, house_number, postal_code, state, street_direction, street_name, street_type, unit_number, oid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,273 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update ADDRESS set addresstype_code=?, country_code=?, house_number=?, postal_code=?, state=?, street_direction=?, street_name=?, street_type=?, unit_number=? where oid=?
05 Oct 2005 07:33:42,273 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from ADDRESS where oid=?
05 Oct 2005 07:33:42,303 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.order.vo.Order
05 Oct 2005 07:33:42,303 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from ORDERS where oid =?
05 Oct 2005 07:33:42,303 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select order_.oid, order_.created_by as created2_24_, order_.created_on as created3_24_, order_.updated_by as updated4_24_, order_.updated_on as updated5_24_ from ORDERS order_ where order_.oid=?
05 Oct 2005 07:33:42,303 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into ORDERS (created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,303 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update ORDERS set created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:42,303 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from ORDERS where oid=?
05 Oct 2005 07:33:42,343 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.application.vo.AutoLoanAppProduct
05 Oct 2005 07:33:42,363 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from AUTO_LOAN_APP_PRODUCT where oid =?
05 Oct 2005 07:33:42,363 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select autoloanap_.oid, autoloanap_.auto_product_id as auto2_7_, autoloanap_.down_payment as down3_7_, autoloanap_.product_condition_code as product4_7_, autoloanap_.promotion as promotion7_, autoloanap_.purchase_price as purchase6_7_, autoloanap_.trade_in_amt as trade7_7_, autoloanap_.vehicle_identification_num as vehicle8_7_ from AUTO_LOAN_APP_PRODUCT autoloanap_ where autoloanap_.oid=?
05 Oct 2005 07:33:42,363 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into AUTO_LOAN_APP_PRODUCT (auto_product_id, down_payment, product_condition_code, promotion, purchase_price, trade_in_amt, vehicle_identification_num, oid) values (?, ?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,363 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update AUTO_LOAN_APP_PRODUCT set auto_product_id=?, down_payment=?, product_condition_code=?, promotion=?, purchase_price=?, trade_in_amt=?, vehicle_identification_num=? where oid=?
05 Oct 2005 07:33:42,363 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from AUTO_LOAN_APP_PRODUCT where oid=?
05 Oct 2005 07:33:42,404 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.referencedata.vo.ReferenceData
05 Oct 2005 07:33:42,404 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from REFERENCE_DATA where oid =?
05 Oct 2005 07:33:42,404 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select referenced_.oid, referenced_.category as category35_, referenced_.code as code35_, referenced_.description as descript4_35_, referenced_.created_by as created5_35_, referenced_.created_on as created6_35_, referenced_.updated_by as updated7_35_, referenced_.updated_on as updated8_35_ from REFERENCE_DATA referenced_ where referenced_.oid=?
05 Oct 2005 07:33:42,404 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into REFERENCE_DATA (category, code, description, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,404 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update REFERENCE_DATA set category=?, code=?, description=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:42,404 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from REFERENCE_DATA where oid=?
05 Oct 2005 07:33:42,444 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.system.vo.LoginInfo
05 Oct 2005 07:33:42,444 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from LOGIN_INFO where oid =?
05 Oct 2005 07:33:42,444 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select logininfo_.oid, logininfo_.answer as answer36_, logininfo_.login as login36_, logininfo_.password as password36_, logininfo_.secret_question as secret5_36_ from LOGIN_INFO logininfo_ where logininfo_.oid=?
05 Oct 2005 07:33:42,444 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into LOGIN_INFO (answer, login, password, secret_question, oid) values (?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,444 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update LOGIN_INFO set answer=?, login=?, password=?, secret_question=? where oid=?
05 Oct 2005 07:33:42,444 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from LOGIN_INFO where oid=?
05 Oct 2005 07:33:42,474 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.action.vo.BusinessAction
05 Oct 2005 07:33:42,474 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from BUSINESS_ACTION where oid =?
05 Oct 2005 07:33:42,474 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select businessac_.oid, businessac_.created_by as created2_2_, businessac_.created_on as created3_2_, businessac_.updated_by as updated4_2_, businessac_.updated_on as updated5_2_ from BUSINESS_ACTION businessac_ where businessac_.oid=?
05 Oct 2005 07:33:42,474 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into BUSINESS_ACTION (created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,474 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update BUSINESS_ACTION set created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:42,474 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from BUSINESS_ACTION where oid=?
05 Oct 2005 07:33:42,494 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.action.vo.Action
05 Oct 2005 07:33:42,494 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from ACTION where oid =?
05 Oct 2005 07:33:42,494 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select action_.oid, action_.created_by as created2_0_, action_.created_on as created3_0_, action_.updated_by as updated4_0_, action_.updated_on as updated5_0_ from ACTION action_ where action_.oid=?
05 Oct 2005 07:33:42,494 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into ACTION (created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,494 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update ACTION set created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:42,494 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from ACTION where oid=?
05 Oct 2005 07:33:42,534 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.product.vo.FinancialProduct
05 Oct 2005 07:33:42,534 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from PRODUCT where oid =?
05 Oct 2005 07:33:42,534 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select financialp_.financial_product, financialp_1_.description as descript2_28_, financialp_1_.name as name28_, financialp_1_.created_by as created4_28_, financialp_1_.created_on as created5_28_, financialp_1_.updated_by as updated6_28_, financialp_1_.updated_on as updated7_28_ from FINANCIAL_PRODUCT financialp_ inner join PRODUCT financialp_1_ on financialp_.financial_product=financialp_1_.oid where financialp_.financial_product=?
05 Oct 2005 07:33:42,534 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into PRODUCT (description, name, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,534 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update PRODUCT set description=?, name=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:42,534 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from PRODUCT where oid=?
05 Oct 2005 07:33:42,534 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 1: insert into FINANCIAL_PRODUCT (financial_product) values (?)
05 Oct 2005 07:33:42,534 [DEBUG] BasicEntityPersister.logStaticSQL - Update 1: null
05 Oct 2005 07:33:42,534 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 1: delete from FINANCIAL_PRODUCT where financial_product=?
05 Oct 2005 07:33:42,614 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.consumer.vo.Consumer
05 Oct 2005 07:33:42,614 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from CONSUMER where oid =?
05 Oct 2005 07:33:42,614 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select consumer_.oid, consumer_.bank_account_code as bank2_18_, consumer_.date_of_birth as date3_18_, consumer_.drivers_license_num as drivers4_18_, consumer_.drivers_license_state_code as drivers5_18_, consumer_.social_security_num as social6_18_, consumer_.us_resident_code as us7_18_, consumer_.cell_phone as cell8_18_, consumer_.first_name as first9_18_, consumer_.full_name as full10_18_, consumer_.home_phone as home11_18_, consumer_.last_name as last12_18_, consumer_.middle_name as middle13_18_, consumer_.prefix as prefix18_, consumer_.suffix as suffix18_, consumer_.work_phone as work16_18_, consumer_.created_by as created17_18_, consumer_.created_on as created18_18_, consumer_.updated_by as updated19_18_, consumer_.updated_on as updated20_18_ from CONSUMER consumer_ where consumer_.oid=?
05 Oct 2005 07:33:42,614 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into CONSUMER (bank_account_code, date_of_birth, drivers_license_num, drivers_license_state_code, social_security_num, us_resident_code, cell_phone, first_name, full_name, home_phone, last_name, middle_name, prefix, suffix, work_phone, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,614 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update CONSUMER set bank_account_code=?, date_of_birth=?, drivers_license_num=?, drivers_license_state_code=?, social_security_num=?, us_resident_code=?, cell_phone=?, first_name=?, full_name=?, home_phone=?, last_name=?, middle_name=?, prefix=?, suffix=?, work_phone=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:42,614 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from CONSUMER where oid=?
05 Oct 2005 07:33:42,644 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.order.vo.Contract
05 Oct 2005 07:33:42,644 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from CONTRACT where oid =?
05 Oct 2005 07:33:42,644 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select contract_.oid, contract_.application_id as applicat2_23_, contract_.offer_id as offer3_23_, contract_.created_by as created4_23_, contract_.created_on as created5_23_, contract_.updated_by as updated6_23_, contract_.updated_on as updated7_23_ from CONTRACT contract_ where contract_.oid=?
05 Oct 2005 07:33:42,644 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into CONTRACT (application_id, offer_id, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,644 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update CONTRACT set application_id=?, offer_id=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:42,644 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from CONTRACT where oid=?
05 Oct 2005 07:33:42,694 [DEBUG] BasicEntityPersister.logStaticSQL - Static SQL for entity: com.cl.entity.application.vo.AutoLoanApp
05 Oct 2005 07:33:42,694 [DEBUG] BasicEntityPersister.logStaticSQL - Version select: select oid from APPLICATION where oid =?
05 Oct 2005 07:33:42,694 [DEBUG] BasicEntityPersister.logStaticSQL - Snapshot select: select autoloanap_.auto_loan_app, autoloanap_1_.category_code as category2_3_, autoloanap_1_.channel_code as channel3_3_, autoloanap_1_.comments as comments3_, autoloanap_1_.point_of_sale_id as point5_3_, autoloanap_1_.sales_person_id as sales6_3_, autoloanap_1_.status_code as status7_3_, autoloanap_1_.type_code as type8_3_, autoloanap_1_.created_by as created9_3_, autoloanap_1_.created_on as created10_3_, autoloanap_1_.updated_by as updated11_3_, autoloanap_1_.updated_on as updated12_3_, autoloanap_.down_pymt_amt as down2_5_, autoloanap_.financing_amt as financing3_5_, autoloanap_.iso_currency_code as iso4_5_, autoloanap_.photo_id_check_code as photo5_5_, autoloanap_.trade_in_amt as trade6_5_ from AUTO_LOAN_APP autoloanap_ inner join APPLICATION autoloanap_1_ on autoloanap_.auto_loan_app=autoloanap_1_.oid where autoloanap_.auto_loan_app=?
05 Oct 2005 07:33:42,694 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 0: insert into APPLICATION (category_code, channel_code, comments, point_of_sale_id, sales_person_id, status_code, type_code, created_by, created_on, updated_by, updated_on, oid) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,694 [DEBUG] BasicEntityPersister.logStaticSQL - Update 0: update APPLICATION set category_code=?, channel_code=?, comments=?, point_of_sale_id=?, sales_person_id=?, status_code=?, type_code=?, created_by=?, created_on=?, updated_by=?, updated_on=? where oid=?
05 Oct 2005 07:33:42,694 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 0: delete from APPLICATION where oid=?
05 Oct 2005 07:33:42,694 [DEBUG] BasicEntityPersister.logStaticSQL - Insert 1: insert into AUTO_LOAN_APP (down_pymt_amt, financing_amt, iso_currency_code, photo_id_check_code, trade_in_amt, auto_loan_app) values (?, ?, ?, ?, ?, ?)
05 Oct 2005 07:33:42,694 [DEBUG] BasicEntityPersister.logStaticSQL - Update 1: update AUTO_LOAN_APP set down_pymt_amt=?, financing_amt=?, iso_currency_code=?, photo_id_check_code=?, trade_in_amt=? where auto_loan_app=?
05 Oct 2005 07:33:42,694 [DEBUG] BasicEntityPersister.logStaticSQL - Delete 1: delete from AUTO_LOAN_APP where auto_loan_app=?
05 Oct 2005 07:33:42,704 [DEBUG] AbstractCollectionPersister.logStaticSQL - Static SQL for collection: com.cl.entity.businessentity.vo.BusinessEntity.addresses
05 Oct 2005 07:33:42,704 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row insert: insert into ADDRESS_BUSINESSENTITY (businessentity_id, address_id) values (?, ?)
05 Oct 2005 07:33:42,704 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row update: update ADDRESS_BUSINESSENTITY set address_id=? where businessentity_id=? and address_id=?
05 Oct 2005 07:33:42,704 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row delete: delete from ADDRESS_BUSINESSENTITY where businessentity_id=? and address_id=?
05 Oct 2005 07:33:42,704 [DEBUG] AbstractCollectionPersister.logStaticSQL - One-shot delete: delete from ADDRESS_BUSINESSENTITY where businessentity_id=?
05 Oct 2005 07:33:42,704 [DEBUG] AbstractCollectionPersister.logStaticSQL - Static SQL for collection: com.cl.entity.consumer.vo.Consumer.businessEntity
05 Oct 2005 07:33:42,704 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row insert: insert into PERSON_BUSINESSENTITY (person_id, business_entity_id) values (?, ?)
05 Oct 2005 07:33:42,704 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row update: update PERSON_BUSINESSENTITY set business_entity_id=? where person_id=? and business_entity_id=?
05 Oct 2005 07:33:42,704 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row delete: delete from PERSON_BUSINESSENTITY where person_id=? and business_entity_id=?
05 Oct 2005 07:33:42,704 [DEBUG] AbstractCollectionPersister.logStaticSQL - One-shot delete: delete from PERSON_BUSINESSENTITY where person_id=?
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - Static SQL for collection: com.cl.entity.consumer.vo.Consumer.applications
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row insert: insert into CONSUMER_APPLICATION (consumer_id, application_id) values (?, ?)
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row update: update CONSUMER_APPLICATION set application_id=? where consumer_id=? and application_id=?
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row delete: delete from CONSUMER_APPLICATION where consumer_id=? and application_id=?
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - One-shot delete: delete from CONSUMER_APPLICATION where consumer_id=?
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - Static SQL for collection: com.cl.entity.system.vo.Role.privileges
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row insert: insert into ROLE_PRIVILEGE (role_id, privilege_id) values (?, ?)
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row update: update ROLE_PRIVILEGE set privilege_id=? where role_id=? and privilege_id=?
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row delete: delete from ROLE_PRIVILEGE where role_id=? and privilege_id=?
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - One-shot delete: delete from ROLE_PRIVILEGE where role_id=?
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - Static SQL for collection: com.cl.entity.product.vo.ProductCategory.products
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row insert: insert into PRODUCTCATEGORY_PRODUCT (productcategory_id, product_id) values (?, ?)
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row update: update PRODUCTCATEGORY_PRODUCT set product_id=? where productcategory_id=? and product_id=?
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - Row delete: delete from PRODUCTCATEGORY_PRODUCT where productcategory_id=? and product_id=?
05 Oct 2005 07:33:42,714 [DEBUG] AbstractCollectionPersister.logStaticSQL - One


Top
 Profile  
 
 Post subject: Re: Session Binding issue
PostPosted: Wed Oct 05, 2005 8:07 am 
Expert
Expert

Joined: Mon Feb 14, 2005 12:32 pm
Posts: 609
Location: Atlanta, GA - USA
Am I missing something ? I don't see an Exception here anywhere.

_________________
Preston

Please don't forget to give credit if/when you get helpful information.


Top
 Profile  
 
 Post subject: here is the exception
PostPosted: Wed Oct 05, 2005 11:33 am 
Newbie

Joined: Wed Feb 23, 2005 2:08 pm
Posts: 17
sorry about that :(

Scott

05 Oct 2005 11:31:26,935 [DEBUG] SessionFactoryObjectFactory.<clinit> - initializing class SessionFactoryObjectFactory
05 Oct 2005 11:31:26,935 [DEBUG] SessionFactoryObjectFactory.addInstance - registered: 8a88c88506c1688c0106c16890570000 (java:hibernate/SessionFactory)
05 Oct 2005 11:31:26,935 [INFO] SessionFactoryObjectFactory.addInstance - Factory name: java:hibernate/SessionFactory
05 Oct 2005 11:31:26,935 [INFO] NamingHelper.getInitialContext - JNDI InitialContext properties:{}
05 Oct 2005 11:31:26,955 [DEBUG] NamingHelper.bind - binding: java:hibernate/SessionFactory
05 Oct 2005 11:31:26,955 [WARN] SessionFactoryObjectFactory.addInstance - Could not bind factory to JNDI
javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
at javax.naming.InitialContext.getURLOrDefaultInitCtx(Unknown Source)
at javax.naming.InitialContext.getNameParser(Unknown Source)
at org.hibernate.util.NamingHelper.bind(NamingHelper.java:52)
at org.hibernate.impl.SessionFactoryObjectFactory.addInstance(SessionFactoryObjectFactory.java:90)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:260)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1005)
at com.cl.util.ant.ExportSchemaTask.main(ExportSchemaTask.java:21)


Top
 Profile  
 
 Post subject: Re: here is the exception
PostPosted: Wed Oct 05, 2005 2:59 pm 
Expert
Expert

Joined: Mon Feb 14, 2005 12:32 pm
Posts: 609
Location: Atlanta, GA - USA
When you run the code outside of an AppServer, there's no Naming server running so there's no place for Hibernate to bind the java:hibernate/SessionFactory attribute.

If you have a NamingServer running, you need to provide a jndi.properties file that tells Hibernate how to find it.

A sample jndi.properties file might look something like this.

Code:
java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory
java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces
java.naming.provider.url=jnp://localhost:1099


This assumes that the NamingServer is running on the local machine, port 1099 (The default NamingServer port)

_________________
Preston

Please don't forget to give credit if/when you get helpful information.


Top
 Profile  
 
 Post subject: resolution
PostPosted: Wed Oct 05, 2005 9:11 pm 
Newbie

Joined: Wed Feb 23, 2005 2:08 pm
Posts: 17
thanks for the help Preston!!!

http://www.hibernate.org/119.html#A7

package com.cl.util.ant;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.tools.ant.Task;
import org.hibernate.cfg.Configuration;
import org.hibernate.tool.hbm2ddl.SchemaExport;

import com.cl.entity.common.CLPropertyNamingStrategy;


public class ExportSchemaTask extends Task{



private static Log log = LogFactory.getLog(JmsClient.class);

public void execute() {
Configuration config = new Configuration();
config.setNamingStrategy(new CLPropertyNamingStrategy());
config.configure("/hibernate.cfg.xml");
new SchemaExport(config).create(true,true);


}
}






<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory name="java:hibernate/SessionFactory">
<property name="show_sql">false</property>

<!-- database settings -->
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>

<property name="connection.username">cldomain</property>
<property name="connection.password">cldomain</property>
<property name="hibernate.hbbm2ddl.auto">create</property>

<property name="connection.driver_class">oracle.jdbc.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:cldomain</property>
<property name="c3p0.min_size">5</property>
<property name="c3p0.max_size">20</property>
<property name="c3p0.timeout">1800</property>
<property name="c3p0.max_statements">50</property>



<mapping resource="......

</session-factory>
</hibernate-configuration>


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 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.