| Beginner |
 |
Joined: Wed Feb 23, 2005 10:26 am
Posts: 22
|
Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp
I have a Agency class that i am trying to save to the db. I have sequence that is used for the generation of the id. When I look through the debug stuff the hibernate generates i see that it gets the value from the sequence and binds it fine to the id and all the other values are being bound fine. But when i see the final result in the database after hibernate is done the id that is stored is completely different from the value bound by hibernate. The value that is generated by the sequence is 25 and teh value is see in the database is 4.0000E+48. Is this a bug ? or did i miss something. appreicate your help
Hibernate version: Hibernate 3.0rc1
Mapping documents:
Code: PdAgencies.hbm.xml ============= <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <!-- DO NOT EDIT: This is a generated file that is synchronized --> <!-- by MyEclipse Hibernate tool integration. --> <!-- Created Wed Mar 02 08:04:28 EST 2005 --> <hibernate-mapping package="orm"> <class name="PdAgencies" table="PD_AGENCIES"> <id name="agyLicenseId" column="AGY_LICENSE_ID" type="java.lang.Long"> <generator class="sequence"> <param name="sequence">PD_APPFNC_SEQ</param> </generator> </id> <property name="maxUsers" column="MAX_USERS" type="java.lang.Long" not-null="true" /> <property name="maxGroups" column="MAX_GROUPS" type="java.lang.Long" not-null="true" /> <property name="nmeTrade" column="NME_TRADE" type="java.lang.String" /> <property name="nmeCorp" column="NME_CORP" type="java.lang.String" not-null="true" /> <property name="feinNum" column="FEIN_NUM" type="java.lang.String" /> <property name="bondExpDte" column="BOND_EXP_DTE" type="java.util.Date" /> <property name="flgLicRetInd" column="FLG_LIC_RET_IND" type="java.lang.Byte" not-null="true" /> <property name="flgLocked" column="FLG_LOCKED" type="java.lang.Byte" /> <property name="cdeBusType" column="CDE_BUS_TYPE" type="java.lang.String" not-null="true" /> <property name="cdeAgyType" column="CDE_AGY_TYPE" type="java.lang.String" not-null="true" /> <property name="faxNum" column="FAX_NUM" type="java.lang.String" /> <property name="email" column="EMAIL" type="java.lang.String" /> <property name="dteCreated" column="DTE_CREATED" type="java.util.Date" update="false" not-null="true" /> <property name="idLogonCreated" column="ID_LOGON_CREATED" type="java.lang.String" update="false" not-null="true" /> <property name="dteLastUpdated" column="DTE_LAST_UPDATED" type="java.util.Date" not-null="true" /> <property name="idLogonLastUpdated" column="ID_LOGON_LAST_UPDATED" type="java.lang.String" not-null="true" /> <!-- Create a link from the agency to the user group <set name="groups" lazy="true" inverse="true" cascade="all"> <key column="AGY_LICENSE_ID"/> <one-to-many class="PdUserGroups"/> </set> --> </class> </hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
Driver
================
public class tester {
private static Session session;
private Logger log = Logger.getLogger(this.getClass());
public tester() {
// TODO Auto-generated constructor stub
}
public static void main(String[] args) {
BasicConfigurator.configure();
try {
tester test= new tester();
test.setSession(HibernateSessionFactory.currentSession());
Transaction tx = session.beginTransaction();
// create agency
PdAgencies agency = createAgency();
//save it
session.save(agency);
session.flush();
tx.commit();
test.getSession().close();
} catch (HibernateException e) {
e.printStackTrace();
}
}
private static PdAgencies createAgency()
{
System.out.println("############# creating agency #############");
PdAgencies agency = new PdAgencies();
// required attributes
agency.setCdeAgyType("DET");
agency.setCdeBusType("D");
agency.setDteCreated(new Date());
agency.setDteLastUpdated(new Date());
agency.setFlgLicRetInd(new Byte("0"));
agency.setIdLogonCreated("zxyz1234011");
agency.setIdLogonLastUpdated("zxyz1234011");
agency.setMaxGroups(new Long(3));
agency.setMaxUsers(new Long(5));
agency.setNmeCorp("CorpNm");
//nullable fileds
agency.setNmeTrade("TradeNm");
agency.setFeinNum("12345");
agency.setBondExpDte(new Date());
agency.setFlgLocked(new Byte("0"));
agency.setFaxNum("1234567890");
agency.setEmail("norton@yahoo.com");
return agency;
}
/**
* @return Returns the session.
*/
public Session getSession() {
return session;
}
/**
* @param session The session to set.
*/
public static void setSession(Session session) {
tester.session = session;
}
}
public class PdAgencies
implements Serializable
{
...
getter and setter methods for all the attributes
...
/**
* Simple constructor of PdAgencies instances.
*/
public PdAgencies()
{
}
/**
* Constructor of PdAgencies instances given a simple primary key.
* @param agyLicenseId
*/
public PdAgencies(java.lang.Long agyLicenseId)
{
super(agyLicenseId);
}
/* Add customized code below */
}
HibernateSessionFactory
=================
package orm;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
/**
* Configures and provides access to Hibernate sessions, tied to the
* current thread of execution. Follows the Thread Local Session
* pattern, see {@link http://hibernate.org/42.html}.
*/
public class HibernateSessionFactory {
/**
* Location of hibernate.cfg.xml file.
*/
private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";
/** Holds a single instance of Session */
private static final ThreadLocal threadLocal = new ThreadLocal();
/** The single instance of hibernate configuration */
private static final Configuration cfg = new Configuration();
/** The single instance of hibernate SessionFactory */
private static org.hibernate.SessionFactory sessionFactory;
/**
* Returns the ThreadLocal Session instance. Lazy initialize
* the SessionFactory if needed.
*
* @return Session
* @throws HibernateException
*/
public static Session currentSession() throws HibernateException {
Session session = (Session) threadLocal.get();
if (session == null) {
if (sessionFactory == null) {
try {
cfg.configure(CONFIG_FILE_LOCATION);
sessionFactory = cfg.buildSessionFactory();
}
catch (Exception e) {
System.err.println("%%%% Error Creating SessionFactory %%%%");
e.printStackTrace();
}
}
session = sessionFactory.openSession();
threadLocal.set(session);
}
return session;
}
/**
* Close the single hibernate session instance.
*
* @throws HibernateException
*/
public static void closeSession() throws HibernateException {
Session session = (Session) threadLocal.get();
threadLocal.set(null);
if (session != null) {
session.close();
}
}
/**
* Default constructor.
*/
private HibernateSessionFactory() {
}
}
Full stack trace of any exception that occurs:None everything works fine
Name and version of the database you are using:Oracle 9i
The generated SQL (show_sql=true):
############# creating agency #############
3297 [main] DEBUG org.hibernate.event.def.DefaultSaveOrUpdateEventListener - saving transient instance
3297 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
3297 [main] DEBUG org.hibernate.SQL - select PD_APPFNC_SEQ.nextval from dual
Hibernate: select PD_APPFNC_SEQ.nextval from dual
3297 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
3359 [main] DEBUG org.hibernate.id.SequenceGenerator - Sequence identifier generated: 25
3359 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
3359 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - closing statement
3359 [main] DEBUG org.hibernate.event.def.AbstractSaveEventListener - generated identifier: 25, using strategy: org.hibernate.id.SequenceGenerator
3359 [main] DEBUG org.hibernate.event.def.AbstractSaveEventListener - saving [orm.PdAgencies#25]
3406 [main] DEBUG org.hibernate.transaction.JDBCTransaction - commit
3406 [main] DEBUG org.hibernate.impl.SessionImpl - automatically flushing session
3406 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - flushing session
3406 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - processing flush-time cascades
3406 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - dirty checking collections
3406 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - Flushing entities and processing referenced collections
3406 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - Processing unreferenced collections
3406 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - Scheduling collection removes/(re)creates/updates
3406 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - Flushed: 1 insertions, 0 updates, 0 deletions to 1 objects
3406 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
3406 [main] DEBUG org.hibernate.pretty.Printer - listing entities:
3422 [main] DEBUG org.hibernate.pretty.Printer - orm.PdAgencies{idLogonLastUpdated=zxyz1234011, flgLocked=0, nmeCorp=CorpNm, bondExpDte=2005-03-02 11:37:07, dteLastUpdated=2005-03-02 11:37:07, nmeTrade=TradeNm, flgLicRetInd=0, feinNum=12345, faxNum=1234567890, maxUsers=5, maxGroups=3, idLogonCreated=zxyz1234011, dteCreated=2005-03-02 11:37:07, cdeAgyType=DET, email=norton@yahoo.com, cdeBusType=D, agyLicenseId=25}
3422 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - executing flush
3437 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Inserting entity: [orm.PdAgencies#25]
3437 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
3437 [main] DEBUG org.hibernate.SQL - insert into PD_AGENCIES (MAX_USERS, MAX_GROUPS, NME_TRADE, NME_CORP, FEIN_NUM, BOND_EXP_DTE, FLG_LIC_RET_IND, FLG_LOCKED, CDE_BUS_TYPE, CDE_AGY_TYPE, FAX_NUM, EMAIL, DTE_CREATED, ID_LOGON_CREATED, DTE_LAST_UPDATED, ID_LOGON_LAST_UPDATED, AGY_LICENSE_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into PD_AGENCIES (MAX_USERS, MAX_GROUPS, NME_TRADE, NME_CORP, FEIN_NUM, BOND_EXP_DTE, FLG_LIC_RET_IND, FLG_LOCKED, CDE_BUS_TYPE, CDE_AGY_TYPE, FAX_NUM, EMAIL, DTE_CREATED, ID_LOGON_CREATED, DTE_LAST_UPDATED, ID_LOGON_LAST_UPDATED, AGY_LICENSE_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
3437 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - preparing statement
3437 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Dehydrating entity: [orm.PdAgencies#25]
3437 [main] DEBUG org.hibernate.type.LongType - binding '5' to parameter: 1
3437 [main] DEBUG org.hibernate.type.LongType - binding '3' to parameter: 2
3437 [main] DEBUG org.hibernate.type.StringType - binding 'TradeNm' to parameter: 3
3437 [main] DEBUG org.hibernate.type.StringType - binding 'CorpNm' to parameter: 4
3437 [main] DEBUG org.hibernate.type.StringType - binding '12345' to parameter: 5
3437 [main] DEBUG org.hibernate.type.TimestampType - binding '2005-03-02 11:37:07' to parameter: 6
3437 [main] DEBUG org.hibernate.type.ByteType - binding '0' to parameter: 7
3437 [main] DEBUG org.hibernate.type.ByteType - binding '0' to parameter: 8
3437 [main] DEBUG org.hibernate.type.StringType - binding 'D' to parameter: 9
3437 [main] DEBUG org.hibernate.type.StringType - binding 'DET' to parameter: 10
3437 [main] DEBUG org.hibernate.type.StringType - binding '1234567890' to parameter: 11
3437 [main] DEBUG org.hibernate.type.StringType - binding 'norton@yahoo.com' to parameter: 12
3437 [main] DEBUG org.hibernate.type.TimestampType - binding '2005-03-02 11:37:07' to parameter: 13
3437 [main] DEBUG org.hibernate.type.StringType - binding 'zxyz1234011' to parameter: 14
3437 [main] DEBUG org.hibernate.type.TimestampType - binding '2005-03-02 11:37:07' to parameter: 15
3437 [main] DEBUG org.hibernate.type.StringType - binding 'zxyz1234011' to parameter: 16
3437 [main] DEBUG org.hibernate.type.LongType - binding '25' to parameter: 17
3437 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - Adding to batch
3437 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - Executing batch size: 1
3453 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - success of batch update unknown: 0
3453 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
3453 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - closing statement
3453 [main] DEBUG org.hibernate.event.def.AbstractFlushingEventListener - post flush
3453 [main] DEBUG org.hibernate.jdbc.JDBCContext - before transaction completion
3453 [main] DEBUG org.hibernate.impl.SessionImpl - before transaction completion
3453 [main] DEBUG org.hibernate.transaction.JDBCTransaction - committed JDBC Connection
3453 [main] DEBUG org.hibernate.jdbc.JDBCContext - after transaction completion
3453 [main] DEBUG org.hibernate.impl.SessionImpl - after transaction completion
3453 [main] DEBUG org.hibernate.impl.SessionImpl - closing session
3453 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - closing JDBC connection (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)
3453 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - returning connection to pool, pool size: 1
3453 [main] DEBUG org.hibernate.jdbc.JDBCContext - after transaction completion
3453 [main] DEBUG org.hibernate.impl.SessionImpl - after transaction completion
Debug level Hibernate log excerpt:
0 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.0rc1
16 [main] INFO org.hibernate.cfg.Environment - hibernate.properties not found
16 [main] INFO org.hibernate.cfg.Environment - using CGLIB reflection optimizer
16 [main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
16 [main] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
16 [main] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
375 [main] DEBUG org.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath under org/hibernate/
375 [main] DEBUG org.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibern ... on-3.0.dtd in classpath
422 [main] DEBUG org.hibernate.cfg.Configuration - connection.username=pda
422 [main] DEBUG org.hibernate.cfg.Configuration - connection.url=jdbc:oracle:thin:@199.20.120.104:1521:nmd9i
422 [main] DEBUG org.hibernate.cfg.Configuration - dialect=org.hibernate.dialect.Oracle9Dialect
422 [main] DEBUG org.hibernate.cfg.Configuration - connection.password=pda007
422 [main] DEBUG org.hibernate.cfg.Configuration - connection.driver_class=oracle.jdbc.driver.OracleDriver
422 [main] DEBUG org.hibernate.cfg.Configuration - show_sql=true
422 [main] DEBUG org.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@c8f6f8 [Attribute: name resource value "orm/PdAgencies.hbm.xml"]
422 [main] INFO org.hibernate.cfg.Configuration - Mapping resource: orm/PdAgencies.hbm.xml
453 [main] DEBUG org.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath under org/hibernate/
453 [main] DEBUG org.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibern ... ng-3.0.dtd in classpath
578 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: orm.PdAgencies -> PD_AGENCIES
594 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: agyLicenseId -> AGY_LICENSE_ID
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: maxUsers -> MAX_USERS
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: maxGroups -> MAX_GROUPS
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: nmeTrade -> NME_TRADE
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: nmeCorp -> NME_CORP
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: feinNum -> FEIN_NUM
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: bondExpDte -> BOND_EXP_DTE
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: flgLicRetInd -> FLG_LIC_RET_IND
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: flgLocked -> FLG_LOCKED
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: cdeBusType -> CDE_BUS_TYPE
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: cdeAgyType -> CDE_AGY_TYPE
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: faxNum -> FAX_NUM
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: email -> EMAIL
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: dteCreated -> DTE_CREATED
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: idLogonCreated -> ID_LOGON_CREATED
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: dteLastUpdated -> DTE_LAST_UPDATED
609 [main] DEBUG org.hibernate.cfg.HbmBinder - Mapped property: idLogonLastUpdated -> ID_LOGON_LAST_UPDATED
609 [main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
609 [main] DEBUG org.hibernate.cfg.Configuration - properties: {hibernate.connection.password=pda007, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\jdk142\jre\bin, java.vm.version=1.4.2_04-b05, hibernate.connection.username=pda, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\eclipse\workspace\hibernateEmp, java.runtime.version=1.4.2_04-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\jdk142\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\Admin\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.java2d.fontpath=, java.library.path=C:\jdk142\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\oracle\product\10.1.0\Db_1\bin;C:\oracle\product\10.1.0\Db_1\jre\1.4.2\bin\client;C:\oracle\product\10.1.0\Db_1\jre\1.4.2\bin;C:\JDK142\BIN;c:\ant\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Adaptec Shared\System;C:\WINDOWS\system32\nls;C:\WINDOWS\system32\nls\ENGLISH;;C:\Program Files\Starbase\StarGate SDK\Lib;C:\Program Files\SSH Communications Security\SSH Secure Shell, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.1, connection.password=pda007, user.home=C:\Documents and Settings\Admin, user.timezone=, connection.username=pda, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, show_sql=true, user.name=Admin, java.class.path=C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\classes;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-beanutils.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-collections.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-digester.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-fileupload.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-lang.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-logging.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-validator.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jakarta-oro.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\struts-legacy.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\struts.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\ant-1.5.3.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\ant-optional-1.5.3.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\c3p0-0.8.4.5.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\cglib-full-2.0.2.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\classes12.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-collections-2.1.1.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-dbcp-1.2.1.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-lang-1.0.1.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-logging-1.0.4.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-pool-1.2.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\concurrent-1.3.3.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\connector.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\dom4j-1.4.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\ehcache-0.9.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jaas.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jboss-cache.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jboss-common.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jboss-jmx.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jboss-system.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jcs-1.0-dev.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jdbc2_0-stdext.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jgroups-2.2.7.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jta.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\junit-3.8.1.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\log4j-1.2.8.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\odmg-3.0.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\oscache-2.0.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\proxool-0.8.3.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\swarmcache-1.0rc2.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\xalan-2.4.0.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\xerces-2.4.0.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\xml-apis.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\hibernate3.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\jdk142\jre, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, hibernate.connection.url=jdbc:oracle:thin:@199.20.120.104:1521:nmd9i, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.4.2_04, java.ext.dirs=C:\jdk142\jre\lib\ext, sun.boot.class.path=C:\jdk142\jre\lib\rt.jar;C:\jdk142\jre\lib\sunrsasign.jar;C:\jdk142\jre\lib\jsse.jar;C:\jdk142\jre\lib\jce.jar;C:\jdk142\jre\lib\charsets.jar;C:\jdk142\jre\lib\ext\dnsns.jar;C:\jdk142\jre\lib\ext\ldapsec.jar;C:\jdk142\jre\lib\ext\localedata.jar;C:\jdk142\jre\lib\ext\sunjce_provider.jar;C:\jdk142\lib\tools.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\activation.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\javax.servlet.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\javax.servlet.jsp.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\jboss-j2ee.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\jboss-jaxrpc.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\jboss-jsr77.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\jboss-saaj.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\mail.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\namespace.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\xml-apis.jar, java.vendor=Sun Microsystems Inc., connection.driver_class=oracle.jdbc.driver.OracleDriver, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, connection.url=jdbc:oracle:thin:@199.20.120.104:1521:nmd9i, dialect=org.hibernate.dialect.Oracle9Dialect, sun.cpu.isalist=pentium i486 i386}
609 [main] DEBUG org.hibernate.cfg.Configuration - Preparing to build session factory with filters : {}
609 [main] INFO org.hibernate.cfg.Configuration - processing extends queue
609 [main] INFO org.hibernate.cfg.Configuration - processing collection mappings
609 [main] INFO org.hibernate.cfg.Configuration - processing association property references
609 [main] INFO org.hibernate.cfg.Configuration - processing foreign key constraints
766 [main] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.Oracle9Dialect
781 [main] DEBUG org.hibernate.exception.SQLExceptionConverterFactory - Using dialect defined converter
781 [main] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
781 [main] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
781 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
781 [main] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
797 [main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
797 [main] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
797 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
797 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
797 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
875 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@199.20.120.104:1521:nmd9i
875 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=scott, password=tiger}
875 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
875 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC connection
2344 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - created connection to: jdbc:oracle:thin:@199.20.120.104:1521:nmd9i, Isolation Level: 2
2359 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - returning connection to pool, pool size: 1
2359 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
2359 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
2359 [main] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
2359 [main] DEBUG org.hibernate.cfg.SettingsFactory - Wrap result sets: disabled
2359 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
2359 [main] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
2375 [main] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2375 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
2375 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
2375 [main] INFO org.hibernate.cfg.SettingsFactory - Cache provider: org.hibernate.cache.EhCacheProvider
2391 [main] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
2391 [main] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
2391 [main] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: enabled
2391 [main] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
2391 [main] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
2391 [main] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
2391 [main] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
2391 [main] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
2656 [main] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
2656 [main] DEBUG org.hibernate.impl.SessionFactoryImpl - Session factory constructed with filter configurations : {}
2656 [main] DEBUG org.hibernate.impl.SessionFactoryImpl - instantiating session factory with properties: {hibernate.connection.password=pda007, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=C:\jdk142\jre\bin, java.vm.version=1.4.2_04-b05, hibernate.connection.username=pda, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=Service Pack 2, java.vm.specification.name=Java Virtual Machine Specification, user.dir=C:\eclipse\workspace\hibernateEmp, java.runtime.version=1.4.2_04-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\jdk142\jre\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\Admin\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows XP, sun.java2d.fontpath=, java.library.path=C:\jdk142\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\oracle\product\10.1.0\Db_1\bin;C:\oracle\product\10.1.0\Db_1\jre\1.4.2\bin\client;C:\oracle\product\10.1.0\Db_1\jre\1.4.2\bin;C:\JDK142\BIN;c:\ant\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\Adaptec Shared\System;C:\WINDOWS\system32\nls;C:\WINDOWS\system32\nls\ENGLISH;;C:\Program Files\Starbase\StarGate SDK\Lib;C:\Program Files\SSH Communications Security\SSH Secure Shell, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.1, connection.password=pda007, user.home=C:\Documents and Settings\Admin, user.timezone=, connection.username=pda, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver, show_sql=true, user.name=Admin, java.class.path=C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\classes;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-beanutils.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-collections.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-digester.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-fileupload.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-lang.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-logging.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-validator.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jakarta-oro.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\struts-legacy.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\struts.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\ant-1.5.3.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\ant-optional-1.5.3.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\c3p0-0.8.4.5.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\cglib-full-2.0.2.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\classes12.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-collections-2.1.1.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-dbcp-1.2.1.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-lang-1.0.1.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-logging-1.0.4.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\commons-pool-1.2.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\concurrent-1.3.3.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\connector.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\dom4j-1.4.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\ehcache-0.9.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jaas.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jboss-cache.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jboss-common.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jboss-jmx.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jboss-system.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jcs-1.0-dev.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jdbc2_0-stdext.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jgroups-2.2.7.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\jta.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\junit-3.8.1.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\log4j-1.2.8.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\odmg-3.0.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\oscache-2.0.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\proxool-0.8.3.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\swarmcache-1.0rc2.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\xalan-2.4.0.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\xerces-2.4.0.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\xml-apis.jar;C:\eclipse\workspace\hibernateEmp\WebRoot\WEB-INF\lib\hibernate3.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\jdk142\jre, sun.arch.data.model=32, hibernate.dialect=org.hibernate.dialect.Oracle9Dialect, hibernate.connection.url=jdbc:oracle:thin:@199.20.120.104:1521:nmd9i, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.4.2_04, java.ext.dirs=C:\jdk142\jre\lib\ext, sun.boot.class.path=C:\jdk142\jre\lib\rt.jar;C:\jdk142\jre\lib\sunrsasign.jar;C:\jdk142\jre\lib\jsse.jar;C:\jdk142\jre\lib\jce.jar;C:\jdk142\jre\lib\charsets.jar;C:\jdk142\jre\lib\ext\dnsns.jar;C:\jdk142\jre\lib\ext\ldapsec.jar;C:\jdk142\jre\lib\ext\localedata.jar;C:\jdk142\jre\lib\ext\sunjce_provider.jar;C:\jdk142\lib\tools.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\activation.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\javax.servlet.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\javax.servlet.jsp.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\jboss-j2ee.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\jboss-jaxrpc.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\jboss-jsr77.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\jboss-saaj.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\mail.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\namespace.jar;C:\Program Files\MyEclipse\eclipse\plugins\com.genuitec.eclipse.j2eedt.core_3.8.3\data\libraryset\1.4\xml-apis.jar, java.vendor=Sun Microsystems Inc., connection.driver_class=oracle.jdbc.driver.OracleDriver, file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, connection.url=jdbc:oracle:thin:@199.20.120.104:1521:nmd9i, dialect=org.hibernate.dialect.Oracle9Dialect, sun.cpu.isalist=pentium i486 i386}
2672 [main] DEBUG net.sf.ehcache.CacheManager - Creating new CacheManager with default config
2672 [main] DEBUG net.sf.ehcache.CacheManager - Configuring ehcache from classpath.
2672 [main] WARN net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/eclipse/workspace/hibernateEmp/WebRoot/WEB-INF/lib/ehcache-0.9.jar!/ehcache-failsafe.xml
2750 [main] DEBUG net.sf.ehcache.config.Configuration$DiskStore - Disk Store Path: C:\DOCUME~1\Admin\LOCALS~1\Temp\
3187 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Static SQL for entity: orm.PdAgencies
3187 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Version select: select AGY_LICENSE_ID from PD_AGENCIES where AGY_LICENSE_ID =?
3187 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Snapshot select: select pdagencies_.AGY_LICENSE_ID, pdagencies_.MAX_USERS as MAX2_0_, pdagencies_.MAX_GROUPS as MAX3_0_, pdagencies_.NME_TRADE as NME4_0_, pdagencies_.NME_CORP as NME5_0_, pdagencies_.FEIN_NUM as FEIN6_0_, pdagencies_.BOND_EXP_DTE as BOND7_0_, pdagencies_.FLG_LIC_RET_IND as FLG8_0_, pdagencies_.FLG_LOCKED as FLG9_0_, pdagencies_.CDE_BUS_TYPE as CDE10_0_, pdagencies_.CDE_AGY_TYPE as CDE11_0_, pdagencies_.FAX_NUM as FAX12_0_, pdagencies_.EMAIL as EMAIL0_, pdagencies_.DTE_LAST_UPDATED as DTE16_0_, pdagencies_.ID_LOGON_LAST_UPDATED as ID17_0_ from PD_AGENCIES pdagencies_ where pdagencies_.AGY_LICENSE_ID=?
3187 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Insert 0: insert into PD_AGENCIES (MAX_USERS, MAX_GROUPS, NME_TRADE, NME_CORP, FEIN_NUM, BOND_EXP_DTE, FLG_LIC_RET_IND, FLG_LOCKED, CDE_BUS_TYPE, CDE_AGY_TYPE, FAX_NUM, EMAIL, DTE_CREATED, ID_LOGON_CREATED, DTE_LAST_UPDATED, ID_LOGON_LAST_UPDATED, AGY_LICENSE_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
3187 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Update 0: update PD_AGENCIES set MAX_USERS=?, MAX_GROUPS=?, NME_TRADE=?, NME_CORP=?, FEIN_NUM=?, BOND_EXP_DTE=?, FLG_LIC_RET_IND=?, FLG_LOCKED=?, CDE_BUS_TYPE=?, CDE_AGY_TYPE=?, FAX_NUM=?, EMAIL=?, DTE_LAST_UPDATED=?, ID_LOGON_LAST_UPDATED=? where AGY_LICENSE_ID=?
3187 [main] DEBUG org.hibernate.persister.entity.BasicEntityPersister - Delete 0: delete from PD_AGENCIES where AGY_LICENSE_ID=?
3219 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity orm.PdAgencies: select pdagencies0_.AGY_LICENSE_ID as AGY1_0_, pdagencies0_.MAX_USERS as MAX2_0_0_, pdagencies0_.MAX_GROUPS as MAX3_0_0_, pdagencies0_.NME_TRADE as NME4_0_0_, pdagencies0_.NME_CORP as NME5_0_0_, pdagencies0_.FEIN_NUM as FEIN6_0_0_, pdagencies0_.BOND_EXP_DTE as BOND7_0_0_, pdagencies0_.FLG_LIC_RET_IND as FLG8_0_0_, pdagencies0_.FLG_LOCKED as FLG9_0_0_, pdagencies0_.CDE_BUS_TYPE as CDE10_0_0_, pdagencies0_.CDE_AGY_TYPE as CDE11_0_0_, pdagencies0_.FAX_NUM as FAX12_0_0_, pdagencies0_.EMAIL as EMAIL0_0_, pdagencies0_.DTE_CREATED as DTE14_0_0_, pdagencies0_.ID_LOGON_CREATED as ID15_0_0_, pdagencies0_.DTE_LAST_UPDATED as DTE16_0_0_, pdagencies0_.ID_LOGON_LAST_UPDATED as ID17_0_0_ from PD_AGENCIES pdagencies0_ where pdagencies0_.AGY_LICENSE_ID=?
3219 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity orm.PdAgencies: select pdagencies0_.AGY_LICENSE_ID as AGY1_0_, pdagencies0_.MAX_USERS as MAX2_0_0_, pdagencies0_.MAX_GROUPS as MAX3_0_0_, pdagencies0_.NME_TRADE as NME4_0_0_, pdagencies0_.NME_CORP as NME5_0_0_, pdagencies0_.FEIN_NUM as FEIN6_0_0_, pdagencies0_.BOND_EXP_DTE as BOND7_0_0_, pdagencies0_.FLG_LIC_RET_IND as FLG8_0_0_, pdagencies0_.FLG_LOCKED as FLG9_0_0_, pdagencies0_.CDE_BUS_TYPE as CDE10_0_0_, pdagencies0_.CDE_AGY_TYPE as CDE11_0_0_, pdagencies0_.FAX_NUM as FAX12_0_0_, pdagencies0_.EMAIL as EMAIL0_0_, pdagencies0_.DTE_CREATED as DTE14_0_0_, pdagencies0_.ID_LOGON_CREATED as ID15_0_0_, pdagencies0_.DTE_LAST_UPDATED as DTE16_0_0_, pdagencies0_.ID_LOGON_LAST_UPDATED as ID17_0_0_ from PD_AGENCIES pdagencies0_ where pdagencies0_.AGY_LICENSE_ID=?
3219 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity orm.PdAgencies: select pdagencies0_.AGY_LICENSE_ID as AGY1_0_, pdagencies0_.MAX_USERS as MAX2_0_0_, pdagencies0_.MAX_GROUPS as MAX3_0_0_, pdagencies0_.NME_TRADE as NME4_0_0_, pdagencies0_.NME_CORP as NME5_0_0_, pdagencies0_.FEIN_NUM as FEIN6_0_0_, pdagencies0_.BOND_EXP_DTE as BOND7_0_0_, pdagencies0_.FLG_LIC_RET_IND as FLG8_0_0_, pdagencies0_.FLG_LOCKED as FLG9_0_0_, pdagencies0_.CDE_BUS_TYPE as CDE10_0_0_, pdagencies0_.CDE_AGY_TYPE as CDE11_0_0_, pdagencies0_.FAX_NUM as FAX12_0_0_, pdagencies0_.EMAIL as EMAIL0_0_, pdagencies0_.DTE_CREATED as DTE14_0_0_, pdagencies0_.ID_LOGON_CREATED as ID15_0_0_, pdagencies0_.DTE_LAST_UPDATED as DTE16_0_0_, pdagencies0_.ID_LOGON_LAST_UPDATED as ID17_0_0_ from PD_AGENCIES pdagencies0_ where pdagencies0_.AGY_LICENSE_ID=? for update
3219 [main] DEBUG org.hibernate.loader.entity.EntityLoader - Static select for entity orm.PdAgencies: select pdagencies0_.AGY_LICENSE_ID as AGY1_0_, pdagencies0_.MAX_USERS as MAX2_0_0_, pdagencies0_.MAX_GROUPS as MAX3_0_0_, pdagencies0_.NME_TRADE as NME4_0_0_, pdagencies0_.NME_CORP as NME5_0_0_, pdagencies0_.FEIN_NUM as FEIN6_0_0_, pdagencies0_.BOND_EXP_DTE as BOND7_0_0_, pdagencies0_.FLG_LIC_RET_IND as FLG8_0_0_, pdagencies0_.FLG_LOCKED as FLG9_0_0_, pdagencies0_.CDE_BUS_TYPE as CDE10_0_0_, pdagencies0_.CDE_AGY_TYPE as CDE11_0_0_, pdagencies0_.FAX_NUM as FAX12_0_0_, pdagencies0_.EMAIL as EMAIL0_0_, pdagencies0_.DTE_CREATED as DTE14_0_0_, pdagencies0_.ID_LOGON_CREATED as ID15_0_0_, pdagencies0_.DTE_LAST_UPDATED as DTE16_0_0_, pdagencies0_.ID_LOGON_LAST_UPDATED as ID17_0_0_ from PD_AGENCIES pdagencies0_ where pdagencies0_.AGY_LICENSE_ID=? for update nowait
3219 [main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory - initializing class SessionFactoryObjectFactory
3219 [main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory - registered: 8a8b0d06026420b001026420b3090000 (unnamed)
3219 [main] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
3219 [main] DEBUG org.hibernate.impl.SessionFactoryImpl - instantiated session factory
3219 [main] INFO org.hibernate.impl.SessionFactoryImpl - Checking 0 named queries
3297 [main] DEBUG org.hibernate.impl.SessionImpl - opened session
3297 [main] DEBUG org.hibernate.transaction.JDBCTransaction - begin
3297 [main] DEBUG org.hibernate.jdbc.AbstractBatcher - opening JDBC connection
3297 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
3297 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider - using pooled JDBC connection, pool size: 0
3297 [main] DEBUG org.hibernate.transaction.JDBCTransaction - current autocommit status: false
|
|
Login
FAQ
Search
