Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hi what I am trying to do is simple. I am trying to just add records into the db. I have a sequence name PIA_SEQ . When I check the hibernate SQL it shows that it generates the id from dual and binds it to the id parameter of the table . After everything is done i go and check the table i see a constant value of 65439000000000000000000000000 generated for the id .If i run it again it gives me a unique key violation Can some please help and let me know what is happening. I have read the maunal for the id and am a little lost. Appreciate your time in helping me out
Thank you
-Reeve
Hibernate version: 1.2.7

Mapping documents:
===========================================
hibernate.cfg.xml
===========================================
!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">

<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration. -->
<hibernate-configuration>

<session-factory>
<!-- properties -->
<property name="connection.username">pda</property>
<property name="connection.url">jdbc:oracle:thin:@199.20.120.104:1521:nmd9i</property>
<property name="dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>
<property name="connection.password">pda007</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="show_sql">true</property>

<!-- mapping files -->
<mapping resource="org/njsp/invest/pvtdet/common/orm/PdAgencies.hbm.xml"/>
<mapping resource="org/njsp/invest/pvtdet/common/orm/PdAgenciesAddress.hbm.xml"/>
<mapping resource="org/njsp/invest/pvtdet/common/orm/PdUserGroups.hbm.xml"/>

</session-factory>

</hibernate-configuration>


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

<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration. -->
<!-- Created Fri Nov 05 11:55:01 EST 2004 -->
<hibernate-mapping package="org.njsp.invest.pvtdet.common.orm">

<class name="PdAgencies" table="PD_AGENCIES">
<id name="agyLicenseId" column="AGY_LICENSE_ID" type="java.lang.Long" unsaved-value="0">
<generator class="sequence">
<param name="sequence">PIA_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.String" />
<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" not-null="true" />
<property name="idLogonCreated" column="ID_LOGON_CREATED" type="java.lang.String" 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" />
</class>

</hibernate-mapping>



Code between sessionFactory.openSession() and session.close():
test.java
============================================
package test;

import java.util.Date;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Session;
import net.sf.hibernate.Transaction;

import org.apache.log4j.BasicConfigurator;
import org.apache.log4j.Logger;
import org.njsp.invest.pvtdet.common.orm.HibernateSessionFactory;
import org.njsp.invest.pvtdet.common.orm.PdAgencies;
import org.njsp.invest.pvtdet.common.util.Constant;

/**
* @author Admin
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class tester {
/**
*
*/
public tester() {

// TODO Auto-generated constructor stub
}

private Session session;
private Logger log = Logger.getLogger(this.getClass());
public static void main(String[] args) {

BasicConfigurator.configure();
try {
tester agency = new tester();
agency.setSession(HibernateSessionFactory.currentSession());
agency.createAgency();

agency.getSession().close();
} catch (HibernateException e) {}
}


/**
* creates a book and saves it to the db.
*
*/
private void createAgency()
{
System.out.println("############# creating agency");
try {
Transaction tx = session.beginTransaction();
PdAgencies agency = new PdAgencies();
agency.setNmeCorp("NAMECORP");
agency.setCdeAgyType("P");
agency.setCdeBusType("A");
agency.setDteCreated(new Date());
agency.setDteLastUpdated(new Date());
agency.setIdLogonCreated("dsadas");
agency.setIdLogonLastUpdated("dsadas");
agency.setMaxGroups(Constant.DEFAULT_MAX_GROUPS);
agency.setMaxUsers(Constant.DEFAULT_MAX_USERS);
session.save(agency);
tx.commit();
} catch (HibernateException e) {
e.printStackTrace();
}
}

/**
* @return Returns the session.
*/
public Session getSession() {
return session;
}
/**
* @param session The session to set.
*/
public void setSession(Session session) {
this.session = session;
}
}


=============================================
HibernateSessionFactory.java
=============================================
import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Session;
import net.sf.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.
* NOTICE: Location should be on the classpath as Hibernate uses
* #resourceAsStream style lookup for its configuration file. That
* is place the config file in a Java package - the default location
* is the default Java package.<br><br>
* Examples: <br>
* <code>CONFIG_FILE_LOCATION = "/hibernate.conf.xml".
* CONFIG_FILE_LOCATION = "/com/foo/bar/myhiberstuff.conf.xml".</code>
*/
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 net.sf.hibernate.SessionFactory sessionFactory;

/**
* Returns the ThreadLocal Session instance. Lazy initialize
* the <code>SessionFactory</code> 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;
}
*/

public static Session currentSession() throws HibernateException {
Session session = (Session) threadLocal.get();
/* [laliluna] 20.12.2004
* we want to use the standard session.close() method and not the closeSession() from this class.
* For this we need the following line of code.
*/

if (session != null && !session.isOpen())
session = null;
if (session == null) {
if (sessionFactory == null) {
try {
cfg.configure(CONFIG_FILE_LOCATION);
sessionFactory = cfg.buildSessionFactory();
} catch (Exception e) {
System.err.println("%%%% Error Creating HibernateSessionFactory %%%%");
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:

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


The generated SQL (show_sql=true):
2984 [main] DEBUG net.sf.hibernate.impl.SessionFactoryObjectFactory - initializing class SessionFactoryObjectFactory
2984 [main] DEBUG net.sf.hibernate.impl.SessionFactoryObjectFactory - registered: 8a8b0d06023f87c401023f87c73f0000 (unnamed)
2984 [main] INFO net.sf.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
2984 [main] DEBUG net.sf.hibernate.impl.SessionFactoryImpl - instantiated session factory
3047 [main] DEBUG net.sf.hibernate.impl.SessionImpl - opened session
############# creating agency
3047 [main] DEBUG net.sf.hibernate.transaction.JDBCTransaction - begin
3047 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
3047 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - using pooled JDBC connection, pool size: 0
3047 [main] DEBUG net.sf.hibernate.transaction.JDBCTransaction - current autocommit status:false
3047 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - about to open: 0 open PreparedStatements, 0 open ResultSets
3047 [main] DEBUG net.sf.hibernate.SQL - select PIA_SEQ.nextval from dual
Hibernate: select PIA_SEQ.nextval from dual
3047 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - preparing statement
3141 [main] DEBUG net.sf.hibernate.id.SequenceGenerator - Sequence identifier generated: 21
3141 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - done closing: 0 open PreparedStatements, 0 open ResultSets
3141 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - closing statement
3141 [main] DEBUG net.sf.hibernate.impl.SessionImpl - generated identifier: 21
3141 [main] DEBUG net.sf.hibernate.impl.SessionImpl - saving [org.njsp.invest.pvtdet.common.orm.PdAgencies#21]
3156 [main] DEBUG net.sf.hibernate.transaction.JDBCTransaction - commit
3156 [main] DEBUG net.sf.hibernate.impl.SessionImpl - flushing session
3156 [main] DEBUG net.sf.hibernate.impl.SessionImpl - Flushing entities and processing referenced collections
3156 [main] DEBUG net.sf.hibernate.impl.SessionImpl - Processing unreferenced collections
3156 [main] DEBUG net.sf.hibernate.impl.SessionImpl - Scheduling collection removes/(re)creates/updates
3156 [main] DEBUG net.sf.hibernate.impl.SessionImpl - Flushed: 1 insertions, 0 updates, 0 deletions to 1 objects
3156 [main] DEBUG net.sf.hibernate.impl.SessionImpl - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
3156 [main] DEBUG net.sf.hibernate.impl.Printer - listing entities:
3187 [main] DEBUG net.sf.hibernate.impl.Printer - org.njsp.invest.pvtdet.common.orm.PdAgencies{idLogonLastUpdated=dsadas, flgLocked=null, nmeCorp=NAMECORP, bondExpDte=null, dteLastUpdated=2005-02-23 09:03:45, nmeTrade=null, flgLicRetInd=null, feinNum=null, faxNum=null, maxUsers=10, maxGroups=3, idLogonCreated=dsadas, dteCreated=2005-02-23 09:03:45, cdeAgyType=P, email=null, cdeBusType=A, agyLicenseId=21}
3187 [main] DEBUG net.sf.hibernate.impl.SessionImpl - executing flush
3187 [main] DEBUG net.sf.hibernate.persister.EntityPersister - Inserting entity: [org.njsp.invest.pvtdet.common.orm.PdAgencies#21]
3187 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - about to open: 0 open PreparedStatements, 0 open ResultSets
3187 [main] DEBUG net.sf.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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
3187 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - preparing statement
3187 [main] DEBUG net.sf.hibernate.persister.EntityPersister - Dehydrating entity: [org.njsp.invest.pvtdet.common.orm.PdAgencies#21]
3187 [main] DEBUG net.sf.hibernate.type.LongType - binding '10' to parameter: 1
3187 [main] DEBUG net.sf.hibernate.type.LongType - binding '3' to parameter: 2
3187 [main] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 3
3187 [main] DEBUG net.sf.hibernate.type.StringType - binding 'NAMECORP' to parameter: 4
3187 [main] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 5
3187 [main] DEBUG net.sf.hibernate.type.TimestampType - binding null to parameter: 6
3187 [main] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 7
3187 [main] DEBUG net.sf.hibernate.type.ByteType - binding null to parameter: 8
3187 [main] DEBUG net.sf.hibernate.type.StringType - binding 'A' to parameter: 9
3187 [main] DEBUG net.sf.hibernate.type.StringType - binding 'P' to parameter: 10
3187 [main] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 11
3187 [main] DEBUG net.sf.hibernate.type.StringType - binding null to parameter: 12
3187 [main] DEBUG net.sf.hibernate.type.TimestampType - binding '2005-02-23 09:03:45' to parameter: 13
3187 [main] DEBUG net.sf.hibernate.type.StringType - binding 'dsadas' to parameter: 14
3187 [main] DEBUG net.sf.hibernate.type.TimestampType - binding '2005-02-23 09:03:45' to parameter: 15
3187 [main] DEBUG net.sf.hibernate.type.StringType - binding 'dsadas' to parameter: 16
3187 [main] DEBUG net.sf.hibernate.type.LongType - binding '21' to parameter: 17
3187 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - Adding to batch
3187 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - Executing batch size: 1
3203 [main] DEBUG net.sf.hibernate.util.JDBCExceptionReporter - SQL Exception
java.sql.BatchUpdateException: ORA-00001: unique constraint (PDA.PA_AGYNME_UK) violated

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:459)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3907)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:127)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2441)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2391)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2260)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at test.tester.createAgency(tester.java:71)
at test.tester.main(tester.java:44)
3203 [main] WARN net.sf.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
3203 [main] ERROR net.sf.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (PDA.PA_AGYNME_UK) violated

3203 [main] WARN net.sf.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
3203 [main] ERROR net.sf.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (PDA.PA_AGYNME_UK) violated

3203 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - done closing: 0 open PreparedStatements, 0 open ResultSets
3219 [main] DEBUG net.sf.hibernate.impl.BatcherImpl - closing statement
3219 [main] DEBUG net.sf.hibernate.util.JDBCExceptionReporter - Could not execute JDBC batch update
java.sql.BatchUpdateException: ORA-00001: unique constraint (PDA.PA_AGYNME_UK) violated

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:459)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3907)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:127)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2441)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2391)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2260)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at test.tester.createAgency(tester.java:71)
at test.tester.main(tester.java:44)
3219 [main] WARN net.sf.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
3219 [main] ERROR net.sf.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (PDA.PA_AGYNME_UK) violated

3219 [main] WARN net.sf.hibernate.util.JDBCExceptionReporter - SQL Error: 1, SQLState: 23000
3219 [main] ERROR net.sf.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (PDA.PA_AGYNME_UK) violated

3219 [main] ERROR net.sf.hibernate.impl.SessionImpl - Could not synchronize database state with session
3219 [main] DEBUG net.sf.hibernate.impl.SessionImpl - closing session
3219 [main] DEBUG net.sf.hibernate.impl.SessionImpl - disconnecting session
3219 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - returning connection to pool, pool size: 1
net.sf.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:73)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:30)
at net.sf.hibernate.impl.BatcherImpl.convert(BatcherImpl.java:325)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:134)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2441)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2391)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2260)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at test.tester.createAgency(tester.java:71)
at test.tester.main(tester.java:44)
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (PDA.PA_AGYNME_UK) violated

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:459)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3907)
at net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:54)
at net.sf.hibernate.impl.BatcherImpl.executeBatch(BatcherImpl.java:127)
... 6 more



Debug level Hibernate log excerpt:
0 [main] INFO net.sf.hibernate.cfg.Environment - Hibernate 2.1.7
16 [main] INFO net.sf.hibernate.cfg.Environment - hibernate.properties not found
16 [main] INFO net.sf.hibernate.cfg.Environment - using CGLIB reflection optimizer
16 [main] INFO net.sf.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
31 [main] INFO net.sf.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
31 [main] INFO net.sf.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
359 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibern ... on-2.0.dtd in classpath under net/sf/hibernate/
359 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibern ... on-2.0.dtd in classpath
406 [main] DEBUG net.sf.hibernate.cfg.Configuration - connection.username=pda
406 [main] DEBUG net.sf.hibernate.cfg.Configuration - connection.url=jdbc:oracle:thin:@199.20.120.104:1521:nmd9i
406 [main] DEBUG net.sf.hibernate.cfg.Configuration - dialect=net.sf.hibernate.dialect.Oracle9Dialect
406 [main] DEBUG net.sf.hibernate.cfg.Configuration - connection.password=pda007
406 [main] DEBUG net.sf.hibernate.cfg.Configuration - connection.driver_class=oracle.jdbc.driver.OracleDriver
406 [main] DEBUG net.sf.hibernate.cfg.Configuration - show_sql=true
406 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@10655dd [Attribute: name resource value "org/njsp/invest/pvtdet/common/orm/PdAgencies.hbm.xml"]
406 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: org/njsp/invest/pvtdet/common/orm/PdAgencies.hbm.xml
422 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
422 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
562 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: org.njsp.invest.pvtdet.common.orm.PdAgencies -> PD_AGENCIES
625 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: agyLicenseId -> AGY_LICENSE_ID, type: long
625 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: maxUsers -> MAX_USERS, type: long
625 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: maxGroups -> MAX_GROUPS, type: long
625 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: nmeTrade -> NME_TRADE, type: string
625 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: nmeCorp -> NME_CORP, type: string
641 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: feinNum -> FEIN_NUM, type: string
641 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: bondExpDte -> BOND_EXP_DTE, type: timestamp
641 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: flgLicRetInd -> FLG_LIC_RET_IND, type: string
641 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: flgLocked -> FLG_LOCKED, type: byte
641 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: cdeBusType -> CDE_BUS_TYPE, type: string
641 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: cdeAgyType -> CDE_AGY_TYPE, type: string
641 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: faxNum -> FAX_NUM, type: string
641 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: email -> EMAIL, type: string
641 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: dteCreated -> DTE_CREATED, type: timestamp
641 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: idLogonCreated -> ID_LOGON_CREATED, type: string
641 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: dteLastUpdated -> DTE_LAST_UPDATED, type: timestamp
641 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: idLogonLastUpdated -> ID_LOGON_LAST_UPDATED, type: string
641 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@1bcc0bc [Attribute: name resource value "org/njsp/invest/pvtdet/common/orm/PdAgenciesAddress.hbm.xml"]
641 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: org/njsp/invest/pvtdet/common/orm/PdAgenciesAddress.hbm.xml
641 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
641 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
703 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: org.njsp.invest.pvtdet.common.orm.PdAgenciesAddress -> PD_AGENCIES_ADDRESS
703 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: agyAddrId -> AGY_ADDR_ID, type: long
703 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: cdeCounty -> CDE_COUNTY, type: string
703 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: cdeAddrType -> CDE_ADDR_TYPE, type: string
703 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: address -> ADDRESS, type: string
703 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: address2 -> ADDRESS2, type: string
703 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: city -> CITY, type: string
703 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: state -> STATE, type: string
703 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: zipCode -> ZIP_CODE, type: string
703 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: zip4 -> ZIP4, type: string
703 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: pdAgencies -> AGY_LICENSE_ID, type: org.njsp.invest.pvtdet.common.orm.PdAgencies
703 [main] DEBUG net.sf.hibernate.cfg.Configuration - null<-org.dom4j.tree.DefaultAttribute@13ad085 [Attribute: name resource value "org/njsp/invest/pvtdet/common/orm/PdUserGroups.hbm.xml"]
703 [main] INFO net.sf.hibernate.cfg.Configuration - Mapping resource: org/njsp/invest/pvtdet/common/orm/PdUserGroups.hbm.xml
719 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - trying to locate http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
719 [main] DEBUG net.sf.hibernate.util.DTDEntityResolver - found http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
750 [main] INFO net.sf.hibernate.cfg.Binder - Mapping class: org.njsp.invest.pvtdet.common.orm.PdUserGroups -> PD_USER_GROUPS
750 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: userGrpId -> USER_GRP_ID, type: long
750 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: grpName -> GRP_NAME, type: string
750 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: grpDesc -> GRP_DESC, type: string
750 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: dteCreated -> DTE_CREATED, type: timestamp
750 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: idLogonCreated -> ID_LOGON_CREATED, type: string
750 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: dteLastUpdated -> DTE_LAST_UPDATED, type: timestamp
750 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: idLogonLastUpdated -> ID_LOGON_LAST_UPDATED, type: string
750 [main] DEBUG net.sf.hibernate.cfg.Binder - Mapped property: pdAgencies -> AGY_LICENSE_ID, type: org.njsp.invest.pvtdet.common.orm.PdAgencies
750 [main] INFO net.sf.hibernate.cfg.Configuration - Configured SessionFactory: null
750 [main] DEBUG net.sf.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\hibernate, 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\hibernate\WebRoot\WEB-INF\classes;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-beanutils.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-collections.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-digester.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-fileupload.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-lang.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-logging.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-validator.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jakarta-oro.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\struts-legacy.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\struts.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\ant-1.5.3.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\ant-optional-1.5.3.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\c3p0-0.8.4.5.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\cglib-full-2.0.2.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\classes12.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-collections-2.1.1.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-dbcp-1.2.1.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-lang-1.0.1.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-logging-1.0.4.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-pool-1.2.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\concurrent-1.3.3.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\connector.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\dom4j-1.4.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\ehcache-0.9.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\hibernate2.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jaas.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jboss-cache.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jboss-common.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jboss-jmx.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jboss-system.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jcs-1.0-dev.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jdbc2_0-stdext.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jgroups-2.2.7.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jta.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\junit-3.8.1.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\log4j-1.2.8.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\odmg-3.0.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\oscache-2.0.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\proxool-0.8.3.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\swarmcache-1.0rc2.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\xalan-2.4.0.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\xerces-2.4.0.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\xml-apis.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\jdk142\jre, sun.arch.data.model=32, hibernate.dialect=net.sf.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=net.sf.hibernate.dialect.Oracle9Dialect, sun.cpu.isalist=pentium i486 i386}
750 [main] INFO net.sf.hibernate.cfg.Configuration - processing one-to-many association mappings
750 [main] INFO net.sf.hibernate.cfg.Configuration - processing one-to-one association property references
750 [main] INFO net.sf.hibernate.cfg.Configuration - processing foreign key constraints
750 [main] DEBUG net.sf.hibernate.cfg.Configuration - resolving reference to class: org.njsp.invest.pvtdet.common.orm.PdAgencies
750 [main] DEBUG net.sf.hibernate.cfg.Configuration - resolving reference to class: org.njsp.invest.pvtdet.common.orm.PdAgencies
781 [main] INFO net.sf.hibernate.dialect.Dialect - Using dialect: net.sf.hibernate.dialect.Oracle9Dialect
781 [main] DEBUG net.sf.hibernate.exception.SQLExceptionConverterFactory - Using dialect defined converter
797 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Use outer join fetching: true
797 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
797 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
875 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@199.20.120.104:1521:nmd9i
875 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=pda, password=pda007}
875 [main] INFO net.sf.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
875 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - total checked-out connections: 0
875 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - opening new JDBC connection
2312 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - created connection to: jdbc:oracle:thin:@199.20.120.104:1521:nmd9i, Isolation Level: 2
2344 [main] DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider - returning connection to pool, pool size: 1
2344 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Use scrollable result sets: true
2344 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Use JDBC3 getGeneratedKeys(): false
2344 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: false
2344 [main] INFO net.sf.hibernate.cfg.SettingsFactory - echoing all SQL to stdout
2344 [main] INFO net.sf.hibernate.cfg.SettingsFactory - Query language substitutions: {}
2344 [main] INFO net.sf.hibernate.cfg.SettingsFactory - cache provider: net.sf.hibernate.cache.EhCacheProvider
2344 [main] INFO net.sf.hibernate.cfg.Configuration - instantiating and configuring caches
2484 [main] INFO net.sf.hibernate.impl.SessionFactoryImpl - building session factory
2484 [main] DEBUG net.sf.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\hibernate, 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\hibernate\WebRoot\WEB-INF\classes;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-beanutils.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-collections.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-digester.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-fileupload.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-lang.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-logging.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-validator.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jakarta-oro.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\struts-legacy.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\struts.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\ant-1.5.3.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\ant-optional-1.5.3.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\c3p0-0.8.4.5.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\cglib-full-2.0.2.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\classes12.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-collections-2.1.1.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-dbcp-1.2.1.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-lang-1.0.1.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-logging-1.0.4.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\commons-pool-1.2.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\concurrent-1.3.3.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\connector.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\dom4j-1.4.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\ehcache-0.9.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\hibernate2.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jaas.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jboss-cache.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jboss-common.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jboss-jmx.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jboss-system.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jcs-1.0-dev.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jdbc2_0-stdext.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jgroups-2.2.7.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\jta.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\junit-3.8.1.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\log4j-1.2.8.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\odmg-3.0.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\oscache-2.0.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\proxool-0.8.3.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\swarmcache-1.0rc2.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\xalan-2.4.0.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\xerces-2.4.0.jar;C:\eclipse\workspace\hibernate\WebRoot\WEB-INF\lib\xml-apis.jar, hibernate.show_sql=true, java.vm.specification.version=1.0, java.home=C:\jdk142\jre, sun.arch.data.model=32, hibernate.dialect=net.sf.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=net.sf.hibernate.dialect.Oracle9Dialect, sun.cpu.isalist=pentium i486 i386}

i created the same table in another schema on my local machine and it works fine...