-->
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.  [ 3 posts ] 
Author Message
 Post subject: Mapping problem!
PostPosted: Thu Nov 13, 2008 2:14 am 
Newbie

Joined: Thu Nov 13, 2008 1:43 am
Posts: 2
Hi I m fairly new to Hibernate and I trying to create a hibernate mappring between 2 tables Cust_info and vehicle_detail, where a many to one relationship exists as follows: Cust_info(1) --> Vehicle_detail(Many)... when I try to insert a record in the vehicle table, I get the following error:

org.hibernate.PropertyAccessException: IllegalArgumentException occurred calling getter of com.epermits.capp.dto.Customer.customerId

Details follow. Any help to solve this would be appreciated! Thanks in advance!!

Hibernate version:
3.3.1.GA

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

<hibernate-mapping default-cascade="none" default-access="property" default-lazy="true" auto-import="true">

<class name="com.epermits.capp.dto.Customer"
schema="CUSTOM"
table="CUST_INFO"
mutable="true"
polymorphism="implicit"
dynamic-update="false"
dynamic-insert="false"
select-before-update="false"
optimistic-lock="version">

<id name="customerId" type="int" column="CUSTOMER_ID"> <generator class="assigned"/> </id>
<property name="custTypeId" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="CUST_TYPE_ID" />
</property>
<property name="customerName" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="CUSTOMER_NAME" />
</property>
<property name="phone" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="PHONE" />
</property>
<property name="roomNum" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="ROOM_NUM" />
</property>
<property name="fax" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="FAX" />
</property>
<property name="emailAddress" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="EMAIL_ADDRESS" />
</property>
<property name="shortName" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="SHORT_NAME" />
</property>
<property name="permitPrtName" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="PERMIT_PRT_NAME" />
</property>
<property name="paperFileInd" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="PAPER_FILE_IND" />
</property>
<property name="status" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="STATUS" />
</property>
<property name="fullCustomerName" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="FULL_CUSTOMER_NAME" />
</property>
</class>

<class name="com.epermits.capp.dto.Vehicle"
schema="CUSTOM"
table="VEHICLE_DETAIL"
mutable="true"
polymorphism="implicit"
dynamic-update="false"
dynamic-insert="false"
select-before-update="false"
optimistic-lock="version">

<id name="vehicleId" type="int" column="VEHICLE_ID"> <generator class="assigned"/> </id>
<many-to-one name="customerId" class="com.epermits.capp.dto.Customer" column="CUSTOMER_ID" foreign-key="FK_VEH_CUST"/>
<property name="ownershipType" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="OWNERSHIP_TYPE" />
</property>
<property name="divisionId" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="DIVISION_ID" />
</property>
<property name="plateNum" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="PLATE_NUM" />
</property>
<property name="state" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="STATE" />
</property>
<property name="status" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="STATUS" />
</property>
<property name="make" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="MAKE" />
</property>
<property name="model" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="MODEL" />
</property>
<property name="year" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="YEAR" />
</property>
<property name="vehicleType" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="VEHICLE_TYPE" />
</property>
<property name="numSeats" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="NUM_SEATS" />
</property>
<property name="plateType" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="PLATE_TYPE" />
</property>
<property name="restrictionCode" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="RESTRICTION_CODE" />
</property>
<property name="vin" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="VIN" />
</property>
<property name="plateTypeOther" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="PLATE_TYPE_OTHER" />
</property>
<property name="vehWeight" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="VEH_WEIGHT" />
</property>
<property name="ippsId" unique="false" optimistic-lock="true" lazy="false" generated="never">
<column name="IPPS_ID" />
</property>

</class>
</hibernate-mapping>

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

Vehicle vehicleUp = new Vehicle();

vehicleUp.setVehicleId(getRandomID());
vehicleUp.setCustomerId(customerID);
vehicleUp.setState(request.getParameter("state").toString());
vehicleUp.setStatus(request.getParameter("status").toString()) ;
vehicleUp.setMake(request.getParameter("make").toString()) ;
vehicleUp.setModel(request.getParameter("model").toString()) ;


Session session = null;
ServletContext context = request.getSession().getServletContext();

/*Retrieve Session Factory */
SessionFactory sessionFactory = (SessionFactory) context.getAttribute(HibernatePlugIn.SESSION_FACTORY_KEY);


session = sessionFactory.openSession();


Transaction tx = session.beginTransaction();
session.save(vehicleUp);
tx.commit();

Full stack trace of any exception that occurs:
11/13/08 0:25:44:033 EST] 00000044 SystemErr R org.hibernate.PropertyAccessException: IllegalArgumentException occurred calling getter of com.epermits.capp.dto.Customer.customerId
at org.hibernate.property.BasicPropertyAccessor$BasicGetter.get(BasicPropertyAccessor.java:195)
at org.hibernate.tuple.entity.AbstractEntityTuplizer.getIdentifier(AbstractEntityTuplizer.java:206)
at org.hibernate.persister.entity.AbstractEntityPersister.getIdentifier(AbstractEntityPersister.java:3619)
at org.hibernate.persister.entity.AbstractEntityPersister.isTransient(AbstractEntityPersister.java:3335)
at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:204)
at org.hibernate.engine.ForeignKeys$Nullifier.isNullifiable(ForeignKeys.java:160)
at org.hibernate.engine.ForeignKeys$Nullifier.nullifyTransientReferences(ForeignKeys.java:92)
at org.hibernate.engine.ForeignKeys$Nullifier.nullifyTransientReferences(ForeignKeys.java:70)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:311)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:144)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:562)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:550)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:546)
at com.epermits.capp.bs.CappMaintVehicleInfoBS.addVehicle(CappMaintVehicleInfoBS.java:246)
at com.epermits.capp.action.cappMaintVehicleInfoAction.add(cappMaintVehicleInfoAction.java:166)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.LookupDispatchAction.execute(LookupDispatchAction.java:252)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:673)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1878)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
Caused by: java.lang.IllegalArgumentException: object is not an instance of declaring class
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at org.hibernate.property.BasicPropertyAccessor$BasicGetter.get(BasicPropertyAccessor.java:169)
... 46 more


Name and version of the database you are using:

DB2/AIX64 8.2.5

The generated SQL (show_sql=true):
2008-11-13-00.11.15.000012 - INFO - Using datasource: jdbc/ePermitsDS
2008-11-13-00.11.15.000043 - INFO - RDBMS: DB2/AIX64, version: SQL08025
2008-11-13-00.11.15.000043 - INFO - JDBC driver: IBM DB2 JDBC Universal Driver Architecture, version: 2.9.31
2008-11-13-00.11.15.000090 - INFO - Using dialect: org.hibernate.dialect.DB2Dialect
2008-11-13-00.11.15.000106 - INFO - Transaction strategy: org.hibernate.transaction.JTATransactionFactory
2008-11-13-00.11.15.000122 - INFO - JNDI InitialContext properties:{}
2008-11-13-00.11.15.000122 - INFO - instantiating TransactionManagerLookup: org.hibernate.transaction.WebSphereExtendedJTATransactionLookup
2008-11-13-00.11.15.000122 - INFO - instantiated TransactionManagerLookup
2008-11-13-00.11.15.000122 - INFO - Automatic flush during beforeCompletion(): disabled
2008-11-13-00.11.15.000122 - INFO - Automatic session close at end of transaction: disabled
2008-11-13-00.11.15.000137 - INFO - Scrollable result sets: enabled
2008-11-13-00.11.15.000137 - DEBUG - Wrap result sets: disabled
2008-11-13-00.11.15.000137 - INFO - JDBC3 getGeneratedKeys(): disabled
2008-11-13-00.11.15.000137 - INFO - Connection release mode: auto
2008-11-13-00.11.15.000137 - INFO - Default batch fetch size: 1
2008-11-13-00.11.15.000137 - INFO - Generate SQL with comments: disabled
2008-11-13-00.11.15.000137 - INFO - Order SQL updates by primary key: disabled
2008-11-13-00.11.15.000137 - INFO - Order SQL inserts for batching: disabled
2008-11-13-00.11.15.000137 - INFO - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2008-11-13-00.11.15.000137 - INFO - Using ASTQueryTranslatorFactory
2008-11-13-00.11.15.000137 - INFO - Query language substitutions: {}
2008-11-13-00.11.15.000137 - INFO - JPA-QL strict compliance: disabled
2008-11-13-00.11.15.000137 - INFO - Second-level cache: enabled
2008-11-13-00.11.15.000137 - INFO - Query cache: disabled
2008-11-13-00.11.15.000137 - INFO - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
2008-11-13-00.11.15.000137 - INFO - Optimize cache for minimal puts: disabled
2008-11-13-00.11.15.000137 - INFO - Structured second-level cache entries: disabled
2008-11-13-00.11.15.000168 - INFO - Echoing all SQL to stdout
2008-11-13-00.11.15.000168 - INFO - Statistics: disabled
2008-11-13-00.11.15.000168 - INFO - Deleted entity synthetic identifier rollback: disabled
2008-11-13-00.11.15.000168 - INFO - Default entity-mode: pojo
2008-11-13-00.11.15.000168 - INFO - Named query checking : enabled
2008-11-13-00.11.15.000309 - INFO - building session factory
2008-11-13-00.11.15.000309 - DEBUG - Session factory constructed with filter configurations : {}
2008-11-13-00.11.15.000309 - DEBUG - instantiating session factory with properties: {java.vendor=IBM Corporation, show_sql=true, com.ibm.SOAP.requestTimeout=600, com.ibm.ejs.jts.processType=server, os.name=Windows XP, cmLibraryServer=ICMSYSDB, sun.boot.class.path=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/java/jre/lib/ext/ibmorb.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/java/jre/lib/ext/ibmext.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\core.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\graphics.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\security.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\server.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\xml.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\charsets.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\ibmcertpathprovider.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\ibmjaasactivelm.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\ibmjaaslm.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\ibmjcefw.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\ibmjgssprovider.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\ibmjssefips.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\ibmjsseprovider.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\ibmorb.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\ibmorbapi.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\ibmpkcs.jar, sun.java2d.fontpath=, java.vm.specification.vendor=Sun Microsystems Inc., java.runtime.version=1.4.2, user.name=UmbrajkarU, java.compiler=jitc, was.install.root=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6, hibernate.session_factory_name=HibernateSessionFactory, db2j.system.home=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/cloudscape, user.language=en, derby.system.home=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/derby, was.repository.temp=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\profiles\EPermits_Profile\config\temp\, sun.boot.library.path=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\bin, dialect=org.hibernate.dialect.DB2Dialect, java.version=1.4.2, java.util.logging.manager=com.ibm.ws.bootstrap.WsLogManager, user.timezone=America/New_York, server.root=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\profiles\EPermits_Profile, sun.arch.data.model=32, javax.rmi.CORBA.UtilClass=com.ibm.ws.orb.WSUtilDelegateImpl, java.endorsed.dirs=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\endorsed, file.encoding.pkg=sun.io, file.separator=\, java.specification.name=Java Platform API Specification, starsServerURL=http://10.157.24.151:8090/NYCServWeb/NYCSERVMain, java.class.version=48.0, cmPassword=Y200bnljc2Vydg==, user.country=US, java.home=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre, java.vm.info=J2RE 1.4.2 IBM Windows 32 build cn142ifx-20060307 (142SR4-1 + 98226) (JIT enabled: jitc), os.version=5.1, hibernate.transaction.factory_class=org.hibernate.transaction.JTATransactionFactory, hibernate.connection.datasource=jdbc/ePermitsDS, java.awt.fonts=, path.separator=;, java.vm.version=1.4.2, com.ibm.security.useFIPS=false, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, hibernate.connection.password=perm3dba, user.variant=, console.encoding=Cp850, java.awt.printerjob=sun.awt.windows.WPrinterJob, java.security.policy=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\profiles\EPermits_Profile/properties/server.policy, sun.io.unicode.encoding=UnicodeLittle, awt.toolkit=sun.awt.windows.WToolkit, was.repository.root=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\profiles\EPermits_Profile\config, epermits.properties=c:/ePermits/epermits.properties, hibernate.connection.username=permdba, java.assistive=ON, DataSourceName=jdbc/ePermitsDS, java.naming.factory.url.pkgs=com.ibm.ws.runtime, user.home=C:\Documents and Settings\UmbrajkarU, java.specification.vendor=Sun Microsystems Inc., invokedviajava=, hibernate.hbm2ddl.auto=update, java.library.path=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\bin;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\bin;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\bin;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\bin;C:\Program Files\IBM\Rational\SDP\6.0\eclipse\jre\bin;C:\FRNROOT\HELP;C:\CMBROOT;C:\CMBROOT\DLL;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\FRNROOT;C:\FRNROOT\DLL;C:\Program Files\IBM\db2cmv8\inso;C:\Program Files\IBM\db2cmv8;C:\Program Files\IBM\db2cmv8\bin;C:\Program Files\IBM\db2cmv8\dll;C:\PROGRA~1\F-Secure\Ssh;C:\Program Files\Rational\ClearCase\bin;C:\Program Files\Rational\common;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL, java.vendor.url=http://www.ibm.com/, java.vm.vendor=IBM Corporation, hibernate.dialect=org.hibernate.dialect.DB2Dialect, java.fullversion=J2RE 1.4.2 IBM Windows 32 build cn142ifx-20060307 (142SR4-1 + 98226) (JIT enabled: jitc), java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, java.class.path=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\profiles\EPermits_Profile/properties;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/properties;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/lib/bootstrap.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/lib/j2ee.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/lib/lmproxy.jar;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/lib/urlprotocols.jar;c:\Program Files\IBM\db2cmv8\cmgmt;;C:\CC_Work\ePERMITS\CAPP\EPERMITSII_SOURCE\ePermits\WebContent\WEB-INF\displaytag-el.tld;, hibernate.bytecode.use_reflection_optimizer=false, ws.ext.dirs=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/java/lib;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\profiles\EPermits_Profile/classes;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/classes;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/lib;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/installedChannels;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/lib/ext;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/web/help;C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime, java.vm.specification.name=Java Virtual Machine Specification, java.util.logging.configureByServer=true, java.vm.specification.version=1.0, sun.os.patch.level=Service Pack 2, user.install.root=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\profiles\EPermits_Profile, java.io.tmpdir=C:\DOCUME~1\UMBRAJ~1\LOCALS~1\Temp\, java.vendor.url.bug=, ibm.system.encoding=Cp1252, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, os.arch=x86, ibm.websphere.preload.classes=true, java.ext.dirs=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\java\jre\lib\ext, user.dir=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\profiles\EPermits_Profile, DBPassword=webadm, com.ibm.itp.location=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6/bin, line.separator=
, java.vm.name=Classic VM, DBUser=webadm, java.security.auth.login.config=C:\Program Files\IBM\Rational\SDP\6.0\runtimes\base_v6\profiles\EPermits_Profile/properties/wsjaas.conf, com.ibm.vm.bitmode=32, HostPubServer=localhost:9081, java.naming.provider.url=corbaloc:rir:/NameServiceServerRoot, DOTLOGO=c:/ePermits/image/pdf_dot_logo.jpg, file.encoding=Cp1252, jta.UserTransaction=java:comp/UserTransaction, hibernate.transaction.manager_lookup_class=org.hibernate.transaction.WebSphereExtendedJTATransactionLookup, hibernate.jta.UserTransaction=java:comp/UserTransaction, java.specification.version=1.4, hibernate.show_sql=true}
2008-11-13-00.11.15.000918 - DEBUG - Static SQL for entity: com.epermits.capp.dto.Vehicle
2008-11-13-00.11.15.000918 - DEBUG - Version select: select VEHICLE_ID from CUSTOM.VEHICLE_DETAIL where VEHICLE_ID =?
2008-11-13-00.11.15.000918 - DEBUG - Snapshot select: select vehicle_.VEHICLE_ID, vehicle_.CUSTOMER_ID as CUSTOMER2_1_, vehicle_.OWNERSHIP_TYPE as OWNERSHIP3_1_, vehicle_.DIVISION_ID as DIVISION4_1_, vehicle_.PLATE_NUM as PLATE5_1_, vehicle_.STATE as STATE1_, vehicle_.STATUS as STATUS1_, vehicle_.MAKE as MAKE1_, vehicle_.MODEL as MODEL1_, vehicle_.YEAR as YEAR1_, vehicle_.VEHICLE_TYPE as VEHICLE11_1_, vehicle_.NUM_SEATS as NUM12_1_, vehicle_.PLATE_TYPE as PLATE13_1_, vehicle_.RESTRICTION_CODE as RESTRIC14_1_, vehicle_.VIN as VIN1_, vehicle_.PLATE_TYPE_OTHER as PLATE16_1_, vehicle_.VEH_WEIGHT as VEH17_1_, vehicle_.IPPS_ID as IPPS18_1_ from CUSTOM.VEHICLE_DETAIL vehicle_ where vehicle_.VEHICLE_ID=?
2008-11-13-00.11.15.000918 - DEBUG - Insert 0: insert into CUSTOM.VEHICLE_DETAIL (CUSTOMER_ID, OWNERSHIP_TYPE, DIVISION_ID, PLATE_NUM, STATE, STATUS, MAKE, MODEL, YEAR, VEHICLE_TYPE, NUM_SEATS, PLATE_TYPE, RESTRICTION_CODE, VIN, PLATE_TYPE_OTHER, VEH_WEIGHT, IPPS_ID, VEHICLE_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-11-13-00.11.15.000918 - DEBUG - Update 0: update CUSTOM.VEHICLE_DETAIL set CUSTOMER_ID=?, OWNERSHIP_TYPE=?, DIVISION_ID=?, PLATE_NUM=?, STATE=?, STATUS=?, MAKE=?, MODEL=?, YEAR=?, VEHICLE_TYPE=?, NUM_SEATS=?, PLATE_TYPE=?, RESTRICTION_CODE=?, VIN=?, PLATE_TYPE_OTHER=?, VEH_WEIGHT=?, IPPS_ID=? where VEHICLE_ID=?
2008-11-13-00.11.15.000918 - DEBUG - Delete 0: delete from CUSTOM.VEHICLE_DETAIL where VEHICLE_ID=?
2008-11-13-00.11.15.000934 - DEBUG - Static SQL for entity: com.epermits.capp.dto.Customer
2008-11-13-00.11.15.000934 - DEBUG - Version select: select CUSTOMER_ID from CUSTOM.CUST_INFO where CUSTOMER_ID =?
2008-11-13-00.11.15.000934 - DEBUG - Snapshot select: select customer_.CUSTOMER_ID, customer_.CUST_TYPE_ID as CUST2_0_, customer_.CUSTOMER_NAME as CUSTOMER3_0_, customer_.PHONE as PHONE0_, customer_.ROOM_NUM as ROOM5_0_, customer_.FAX as FAX0_, customer_.EMAIL_ADDRESS as EMAIL7_0_, customer_.SHORT_NAME as SHORT8_0_, customer_.PERMIT_PRT_NAME as PERMIT9_0_, customer_.PAPER_FILE_IND as PAPER10_0_, customer_.STATUS as STATUS0_, customer_.FULL_CUSTOMER_NAME as FULL12_0_ from CUSTOM.CUST_INFO customer_ where customer_.CUSTOMER_ID=?
2008-11-13-00.11.15.000934 - DEBUG - Insert 0: insert into CUSTOM.CUST_INFO (CUST_TYPE_ID, CUSTOMER_NAME, PHONE, ROOM_NUM, FAX, EMAIL_ADDRESS, SHORT_NAME, PERMIT_PRT_NAME, PAPER_FILE_IND, STATUS, FULL_CUSTOMER_NAME, CUSTOMER_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2008-11-13-00.11.15.000934 - DEBUG - Update 0: update CUSTOM.CUST_INFO set CUST_TYPE_ID=?, CUSTOMER_NAME=?, PHONE=?, ROOM_NUM=?, FAX=?, EMAIL_ADDRESS=?, SHORT_NAME=?, PERMIT_PRT_NAME=?, PAPER_FILE_IND=?, STATUS=?, FULL_CUSTOMER_NAME=? where CUSTOMER_ID=?
2008-11-13-00.11.15.000934 - DEBUG - Delete 0: delete from CUSTOM.CUST_INFO where CUSTOMER_ID=?
2008-11-13-00.11.15.000981 - DEBUG - Static select for entity com.epermits.capp.dto.Vehicle: select vehicle0_.VEHICLE_ID as VEHICLE1_1_0_, vehicle0_.CUSTOMER_ID as CUSTOMER2_1_0_, vehicle0_.OWNERSHIP_TYPE as OWNERSHIP3_1_0_, vehicle0_.DIVISION_ID as DIVISION4_1_0_, vehicle0_.PLATE_NUM as PLATE5_1_0_, vehicle0_.STATE as STATE1_0_, vehicle0_.STATUS as STATUS1_0_, vehicle0_.MAKE as MAKE1_0_, vehicle0_.MODEL as MODEL1_0_, vehicle0_.YEAR as YEAR1_0_, vehicle0_.VEHICLE_TYPE as VEHICLE11_1_0_, vehicle0_.NUM_SEATS as NUM12_1_0_, vehicle0_.PLATE_TYPE as PLATE13_1_0_, vehicle0_.RESTRICTION_CODE as RESTRIC14_1_0_, vehicle0_.VIN as VIN1_0_, vehicle0_.PLATE_TYPE_OTHER as PLATE16_1_0_, vehicle0_.VEH_WEIGHT as VEH17_1_0_, vehicle0_.IPPS_ID as IPPS18_1_0_ from CUSTOM.VEHICLE_DETAIL vehicle0_ where vehicle0_.VEHICLE_ID=?
2008-11-13-00.11.15.000981 - DEBUG - Static select for entity com.epermits.capp.dto.Vehicle: select vehicle0_.VEHICLE_ID as VEHICLE1_1_0_, vehicle0_.CUSTOMER_ID as CUSTOMER2_1_0_, vehicle0_.OWNERSHIP_TYPE as OWNERSHIP3_1_0_, vehicle0_.DIVISION_ID as DIVISION4_1_0_, vehicle0_.PLATE_NUM as PLATE5_1_0_, vehicle0_.STATE as STATE1_0_, vehicle0_.STATUS as STATUS1_0_, vehicle0_.MAKE as MAKE1_0_, vehicle0_.MODEL as MODEL1_0_, vehicle0_.YEAR as YEAR1_0_, vehicle0_.VEHICLE_TYPE as VEHICLE11_1_0_, vehicle0_.NUM_SEATS as NUM12_1_0_, vehicle0_.PLATE_TYPE as PLATE13_1_0_, vehicle0_.RESTRICTION_CODE as RESTRIC14_1_0_, vehicle0_.VIN as VIN1_0_, vehicle0_.PLATE_TYPE_OTHER as PLATE16_1_0_, vehicle0_.VEH_WEIGHT as VEH17_1_0_, vehicle0_.IPPS_ID as IPPS18_1_0_ from CUSTOM.VEHICLE_DETAIL vehicle0_ where vehicle0_.VEHICLE_ID=?
2008-11-13-00.11.15.000981 - DEBUG - Static select for entity com.epermits.capp.dto.Vehicle: select vehicle0_.VEHICLE_ID as VEHICLE1_1_0_, vehicle0_.CUSTOMER_ID as CUSTOMER2_1_0_, vehicle0_.OWNERSHIP_TYPE as OWNERSHIP3_1_0_, vehicle0_.DIVISION_ID as DIVISION4_1_0_, vehicle0_.PLATE_NUM as PLATE5_1_0_, vehicle0_.STATE as STATE1_0_, vehicle0_.STATUS as STATUS1_0_, vehicle0_.MAKE as MAKE1_0_, vehicle0_.MODEL as MODEL1_0_, vehicle0_.YEAR as YEAR1_0_, vehicle0_.VEHICLE_TYPE as VEHICLE11_1_0_, vehicle0_.NUM_SEATS as NUM12_1_0_, vehicle0_.PLATE_TYPE as PLATE13_1_0_, vehicle0_.RESTRICTION_CODE as RESTRIC14_1_0_, vehicle0_.VIN as VIN1_0_, vehicle0_.PLATE_TYPE_OTHER as PLATE16_1_0_, vehicle0_.VEH_WEIGHT as VEH17_1_0_, vehicle0_.IPPS_ID as IPPS18_1_0_ from CUSTOM.VEHICLE_DETAIL vehicle0_ where vehicle0_.VEHICLE_ID=? for read only with rs
2008-11-13-00.11.15.000981 - DEBUG - Static select for entity com.epermits.capp.dto.Vehicle: select vehicle0_.VEHICLE_ID as VEHICLE1_1_0_, vehicle0_.CUSTOMER_ID as CUSTOMER2_1_0_, vehicle0_.OWNERSHIP_TYPE as OWNERSHIP3_1_0_, vehicle0_.DIVISION_ID as DIVISION4_1_0_, vehicle0_.PLATE_NUM as PLATE5_1_0_, vehicle0_.STATE as STATE1_0_, vehicle0_.STATUS as STATUS1_0_, vehicle0_.MAKE as MAKE1_0_, vehicle0_.MODEL as MODEL1_0_, vehicle0_.YEAR as YEAR1_0_, vehicle0_.VEHICLE_TYPE as VEHICLE11_1_0_, vehicle0_.NUM_SEATS as NUM12_1_0_, vehicle0_.PLATE_TYPE as PLATE13_1_0_, vehicle0_.RESTRICTION_CODE as RESTRIC14_1_0_, vehicle0_.VIN as VIN1_0_, vehicle0_.PLATE_TYPE_OTHER as PLATE16_1_0_, vehicle0_.VEH_WEIGHT as VEH17_1_0_, vehicle0_.IPPS_ID as IPPS18_1_0_ from CUSTOM.VEHICLE_DETAIL vehicle0_ where vehicle0_.VEHICLE_ID=? for read only with rs
2008-11-13-00.11.15.000981 - DEBUG - Static select for entity com.epermits.capp.dto.Vehicle: select vehicle0_.VEHICLE_ID as VEHICLE1_1_0_, vehicle0_.CUSTOMER_ID as CUSTOMER2_1_0_, vehicle0_.OWNERSHIP_TYPE as OWNERSHIP3_1_0_, vehicle0_.DIVISION_ID as DIVISION4_1_0_, vehicle0_.PLATE_NUM as PLATE5_1_0_, vehicle0_.STATE as STATE1_0_, vehicle0_.STATUS as STATUS1_0_, vehicle0_.MAKE as MAKE1_0_, vehicle0_.MODEL as MODEL1_0_, vehicle0_.YEAR as YEAR1_0_, vehicle0_.VEHICLE_TYPE as VEHICLE11_1_0_, vehicle0_.NUM_SEATS as NUM12_1_0_, vehicle0_.PLATE_TYPE as PLATE13_1_0_, vehicle0_.RESTRICTION_CODE as RESTRIC14_1_0_, vehicle0_.VIN as VIN1_0_, vehicle0_.PLATE_TYPE_OTHER as PLATE16_1_0_, vehicle0_.VEH_WEIGHT as VEH17_1_0_, vehicle0_.IPPS_ID as IPPS18_1_0_ from CUSTOM.VEHICLE_DETAIL vehicle0_ where vehicle0_.VEHICLE_ID=? for read only with rs
2008-11-13-00.11.16.000012 - DEBUG - Static select for action ACTION_MERGE on entity com.epermits.capp.dto.Vehicle: select vehicle0_.VEHICLE_ID as VEHICLE1_1_0_, vehicle0_.CUSTOMER_ID as CUSTOMER2_1_0_, vehicle0_.OWNERSHIP_TYPE as OWNERSHIP3_1_0_, vehicle0_.DIVISION_ID as DIVISION4_1_0_, vehicle0_.PLATE_NUM as PLATE5_1_0_, vehicle0_.STATE as STATE1_0_, vehicle0_.STATUS as STATUS1_0_, vehicle0_.MAKE as MAKE1_0_, vehicle0_.MODEL as MODEL1_0_, vehicle0_.YEAR as YEAR1_0_, vehicle0_.VEHICLE_TYPE as VEHICLE11_1_0_, vehicle0_.NUM_SEATS as NUM12_1_0_, vehicle0_.PLATE_TYPE as PLATE13_1_0_, vehicle0_.RESTRICTION_CODE as RESTRIC14_1_0_, vehicle0_.VIN as VIN1_0_, vehicle0_.PLATE_TYPE_OTHER as PLATE16_1_0_, vehicle0_.VEH_WEIGHT as VEH17_1_0_, vehicle0_.IPPS_ID as IPPS18_1_0_ from CUSTOM.VEHICLE_DETAIL vehicle0_ where vehicle0_.VEHICLE_ID=?
2008-11-13-00.11.16.000012 - DEBUG - Static select for action ACTION_REFRESH on entity com.epermits.capp.dto.Vehicle: select vehicle0_.VEHICLE_ID as VEHICLE1_1_0_, vehicle0_.CUSTOMER_ID as CUSTOMER2_1_0_, vehicle0_.OWNERSHIP_TYPE as OWNERSHIP3_1_0_, vehicle0_.DIVISION_ID as DIVISION4_1_0_, vehicle0_.PLATE_NUM as PLATE5_1_0_, vehicle0_.STATE as STATE1_0_, vehicle0_.STATUS as STATUS1_0_, vehicle0_.MAKE as MAKE1_0_, vehicle0_.MODEL as MODEL1_0_, vehicle0_.YEAR as YEAR1_0_, vehicle0_.VEHICLE_TYPE as VEHICLE11_1_0_, vehicle0_.NUM_SEATS as NUM12_1_0_, vehicle0_.PLATE_TYPE as PLATE13_1_0_, vehicle0_.RESTRICTION_CODE as RESTRIC14_1_0_, vehicle0_.VIN as VIN1_0_, vehicle0_.PLATE_TYPE_OTHER as PLATE16_1_0_, vehicle0_.VEH_WEIGHT as VEH17_1_0_, vehicle0_.IPPS_ID as IPPS18_1_0_ from CUSTOM.VEHICLE_DETAIL vehicle0_ where vehicle0_.VEHICLE_ID=?
2008-11-13-00.11.16.000012 - DEBUG - Static select for entity com.epermits.capp.dto.Customer: select customer0_.CUSTOMER_ID as CUSTOMER1_0_0_, customer0_.CUST_TYPE_ID as CUST2_0_0_, customer0_.CUSTOMER_NAME as CUSTOMER3_0_0_, customer0_.PHONE as PHONE0_0_, customer0_.ROOM_NUM as ROOM5_0_0_, customer0_.FAX as FAX0_0_, customer0_.EMAIL_ADDRESS as EMAIL7_0_0_, customer0_.SHORT_NAME as SHORT8_0_0_, customer0_.PERMIT_PRT_NAME as PERMIT9_0_0_, customer0_.PAPER_FILE_IND as PAPER10_0_0_, customer0_.STATUS as STATUS0_0_, customer0_.FULL_CUSTOMER_NAME as FULL12_0_0_ from CUSTOM.CUST_INFO customer0_ where customer0_.CUSTOMER_ID=?
2008-11-13-00.11.16.000012 - DEBUG - Static select for entity com.epermits.capp.dto.Customer: select customer0_.CUSTOMER_ID as CUSTOMER1_0_0_, customer0_.CUST_TYPE_ID as CUST2_0_0_, customer0_.CUSTOMER_NAME as CUSTOMER3_0_0_, customer0_.PHONE as PHONE0_0_, customer0_.ROOM_NUM as ROOM5_0_0_, customer0_.FAX as FAX0_0_, customer0_.EMAIL_ADDRESS as EMAIL7_0_0_, customer0_.SHORT_NAME as SHORT8_0_0_, customer0_.PERMIT_PRT_NAME as PERMIT9_0_0_, customer0_.PAPER_FILE_IND as PAPER10_0_0_, customer0_.STATUS as STATUS0_0_, customer0_.FULL_CUSTOMER_NAME as FULL12_0_0_ from CUSTOM.CUST_INFO customer0_ where customer0_.CUSTOMER_ID=?
2008-11-13-00.11.16.000012 - DEBUG - Static select for entity com.epermits.capp.dto.Customer: select customer0_.CUSTOMER_ID as CUSTOMER1_0_0_, customer0_.CUST_TYPE_ID as CUST2_0_0_, customer0_.CUSTOMER_NAME as CUSTOMER3_0_0_, customer0_.PHONE as PHONE0_0_, customer0_.ROOM_NUM as ROOM5_0_0_, customer0_.FAX as FAX0_0_, customer0_.EMAIL_ADDRESS as EMAIL7_0_0_, customer0_.SHORT_NAME as SHORT8_0_0_, customer0_.PERMIT_PRT_NAME as PERMIT9_0_0_, customer0_.PAPER_FILE_IND as PAPER10_0_0_, customer0_.STATUS as STATUS0_0_, customer0_.FULL_CUSTOMER_NAME as FULL12_0_0_ from CUSTOM.CUST_INFO customer0_ where customer0_.CUSTOMER_ID=? for read only with rs
2008-11-13-00.11.16.000012 - DEBUG - Static select for entity com.epermits.capp.dto.Customer: select customer0_.CUSTOMER_ID as CUSTOMER1_0_0_, customer0_.CUST_TYPE_ID as CUST2_0_0_, customer0_.CUSTOMER_NAME as CUSTOMER3_0_0_, customer0_.PHONE as PHONE0_0_, customer0_.ROOM_NUM as ROOM5_0_0_, customer0_.FAX as FAX0_0_, customer0_.EMAIL_ADDRESS as EMAIL7_0_0_, customer0_.SHORT_NAME as SHORT8_0_0_, customer0_.PERMIT_PRT_NAME as PERMIT9_0_0_, customer0_.PAPER_FILE_IND as PAPER10_0_0_, customer0_.STATUS as STATUS0_0_, customer0_.FULL_CUSTOMER_NAME as FULL12_0_0_ from CUSTOM.CUST_INFO customer0_ where customer0_.CUSTOMER_ID=? for read only with rs
2008-11-13-00.11.16.000012 - DEBUG - Static select for entity com.epermits.capp.dto.Customer: select customer0_.CUSTOMER_ID as CUSTOMER1_0_0_, customer0_.CUST_TYPE_ID as CUST2_0_0_, customer0_.CUSTOMER_NAME as CUSTOMER3_0_0_, customer0_.PHONE as PHONE0_0_, customer0_.ROOM_NUM as ROOM5_0_0_, customer0_.FAX as FAX0_0_, customer0_.EMAIL_ADDRESS as EMAIL7_0_0_, customer0_.SHORT_NAME as SHORT8_0_0_, customer0_.PERMIT_PRT_NAME as PERMIT9_0_0_, customer0_.PAPER_FILE_IND as PAPER10_0_0_, customer0_.STATUS as STATUS0_0_, customer0_.FULL_CUSTOMER_NAME as FULL12_0_0_ from CUSTOM.CUST_INFO customer0_ where customer0_.CUSTOMER_ID=? for read only with rs
2008-11-13-00.11.16.000012 - DEBUG - Static select for action ACTION_MERGE on entity com.epermits.capp.dto.Customer: select customer0_.CUSTOMER_ID as CUSTOMER1_0_0_, customer0_.CUST_TYPE_ID as CUST2_0_0_, customer0_.CUSTOMER_NAME as CUSTOMER3_0_0_, customer0_.PHONE as PHONE0_0_, customer0_.ROOM_NUM as ROOM5_0_0_, customer0_.FAX as FAX0_0_, customer0_.EMAIL_ADDRESS as EMAIL7_0_0_, customer0_.SHORT_NAME as SHORT8_0_0_, customer0_.PERMIT_PRT_NAME as PERMIT9_0_0_, customer0_.PAPER_FILE_IND as PAPER10_0_0_, customer0_.STATUS as STATUS0_0_, customer0_.FULL_CUSTOMER_NAME as FULL12_0_0_ from CUSTOM.CUST_INFO customer0_ where customer0_.CUSTOMER_ID=?
2008-11-13-00.11.16.000012 - DEBUG - Static select for action ACTION_REFRESH on entity com.epermits.capp.dto.Customer: select customer0_.CUSTOMER_ID as CUSTOMER1_0_0_, customer0_.CUST_TYPE_ID as CUST2_0_0_, customer0_.CUSTOMER_NAME as CUSTOMER3_0_0_, customer0_.PHONE as PHONE0_0_, customer0_.ROOM_NUM as ROOM5_0_0_, customer0_.FAX as FAX0_0_, customer0_.EMAIL_ADDRESS as EMAIL7_0_0_, customer0_.SHORT_NAME as SHORT8_0_0_, customer0_.PERMIT_PRT_NAME as PERMIT9_0_0_, customer0_.PAPER_FILE_IND as PAPER10_0_0_, customer0_.STATUS as STATUS0_0_, customer0_.FULL_CUSTOMER_NAME as FULL12_0_0_ from CUSTOM.CUST_INFO customer0_ where customer0_.CUSTOMER_ID=?
2008-11-13-00.11.16.000028 - DEBUG - initializing class SessionFactoryObjectFactory
2008-11-13-00.11.16.000028 - DEBUG - registered: 8a04e40c1d9442a6011d9442a92c0000 (HibernateSessionFactory)
2008-11-13-00.11.16.000028 - INFO - Factory name: HibernateSessionFactory
2008-11-13-00.11.16.000028 - INFO - JNDI InitialContext properties:{}
2008-11-13-00.11.16.000028 - DEBUG - Returning a Reference to the SessionFactory
2008-11-13-00.11.16.000028 - DEBUG - Bound name: HibernateSessionFactory
2008-11-13-00.11.16.000028 - INFO - Bound factory to JNDI name: HibernateSessionFactory
2008-11-13-00.11.16.000028 - WARN - InitialContext did not implement EventContext
2008-11-13-00.11.16.000028 - DEBUG - instantiated session factory
2008-11-13-00.11.16.000059 - INFO - Running hbm2ddl schema update
2008-11-13-00.11.16.000059 - INFO - fetching database metadata
2008-11-13-00.11.16.000059 - INFO - updating schema
2008-11-13-00.11.16.000059 - DEBUG - processing extends queue
2008-11-13-00.11.16.000059 - DEBUG - processing collection mappings
2008-11-13-00.11.16.000059 - DEBUG - processing native query and ResultSetMapping mappings
2008-11-13-00.11.16.000059 - DEBUG - processing association property references
2008-11-13-00.11.16.000059 - DEBUG - processing foreign key constraints
2008-11-13-00.11.16.000059 - DEBUG - resolving reference to class: com.epermits.capp.dto.Customer
2008-11-13-00.11.16.000090 - INFO - table not found: CUST_INFO
2008-11-13-00.11.16.000122 - INFO - table not found: VEHICLE_DETAIL
2008-11-13-00.11.16.000122 - INFO - table not found: CUST_INFO
2008-11-13-00.11.16.000137 - INFO - table not found: VEHICLE_DETAIL
2008-11-13-00.11.16.000137 - DEBUG - create table CUSTOM.CUST_INFO (CUSTOMER_ID integer not null, CUST_TYPE_ID integer, CUSTOMER_NAME varchar(255), PHONE varchar(255), ROOM_NUM varchar(255), FAX varchar(255), EMAIL_ADDRESS varchar(255), SHORT_NAME varchar(255), PERMIT_PRT_NAME varchar(255), PAPER_FILE_IND varchar(255), STATUS varchar(255), FULL_CUSTOMER_NAME varchar(255), primary key (CUSTOMER_ID))
2008-11-13-00.11.16.000278 - DEBUG - create table CUSTOM.VEHICLE_DETAIL (VEHICLE_ID integer not null, CUSTOMER_ID integer, OWNERSHIP_TYPE varchar(255), DIVISION_ID integer, PLATE_NUM varchar(255), STATE varchar(255), STATUS varchar(255), MAKE varchar(255), MODEL varchar(255), YEAR smallint, VEHICLE_TYPE varchar(255), NUM_SEATS smallint, PLATE_TYPE varchar(255), RESTRICTION_CODE integer, VIN varchar(255), PLATE_TYPE_OTHER varchar(255), VEH_WEIGHT integer, IPPS_ID varchar(255), primary key (VEHICLE_ID))
2008-11-13-00.11.16.000325 - DEBUG - alter table CUSTOM.VEHICLE_DETAIL add constraint FK_VEH_CUST foreign key (CUSTOMER_ID) references CUSTOM.CUST_INFO
2008-11-13-00.11.16.000356 - INFO - schema update complete
2008-11-13-00.11.16.000356 - DEBUG - obtaining JTA TransactionManager
2008-11-13-00.11.16.000356 - DEBUG - Checking 0 named HQL queries
2008-11-13-00.11.16.000356 - DEBUG - Checking 0 named SQL queries

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html


Top
 Profile  
 
 Post subject:
PostPosted: Thu Nov 13, 2008 4:17 am 
Expert
Expert

Joined: Wed Mar 03, 2004 6:35 am
Posts: 1240
Location: Lund, Sweden
In your mapping for Vehicle you have:

Code:
<many-to-one name="customerId" class="com.epermits.capp.dto.Customer" column="CUSTOMER_ID" foreign-key="FK_VEH_CUST"/>


and in your code you are doing:
Code:
vehicleUp.setCustomerId(customerID);


I think the error happens because the customerID is not a Customer object, which Hibernate expects since that is what you are saying in the <many-to-one> mapping.

Below is a better approach:

Code:
<many-to-one name="customer" class="com.epermits.capp.dto.Customer" column="CUSTOMER_ID" foreign-key="FK_VEH_CUST"/>


Code:
vehicleUp.setCustomer(customer);


Top
 Profile  
 
 Post subject:
PostPosted: Thu Nov 13, 2008 4:50 am 
Newbie

Joined: Thu Nov 13, 2008 1:43 am
Posts: 2
that fixed the problem!!thanks a lot!

Are there any good tutorials for understanding o/r mapping that walk through simple examples with code(hbm files,java code etc) from end to end? (other than the CaveatEmptor application)


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