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

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 10 posts ] 
  Previous topic | Next topic 
Author Message
avinashb
 Post subject: facing problem while fetching data from more than one class
PostPosted: Wed Dec 28, 2005 8:51 am 
Beginner
Beginner

Joined: Fri Dec 23, 2005 3:26 am
Posts: 21
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp



I am trying to convert the jetstore application of spring framework work with hibernate through the use of HibernateDaoSupport.

I am trying to fetch data from more than one class object.
i.e some columns from item class & some from the product class.
item & product are POJO classes.

its equivalent sql query is as follows which gives proper results.

select i.itemId, i.listPrice, i.unitCost, i.supplier,i.productId,p.name,p.descn,p.category,i.status, i.attr1, i.attr2, i.attr3, i.attr4, i.attr5 from Item as i ,Product as p where p.productId=i.productId and i.productId like 'FI-FW-01'

I want to know what should be the hql for this.




Hibernate version: 3.0

Mapping documents:

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


<hibernate-mapping>

<class name = "org.springframework.samples.jpetstore.domain.Account" table = "account" >


<id name="id" type="string" unsaved-value="null" >
<column name="userid" sql-type="char(32)" not-null="true"/>
<generator class="uuid.hex"/>
</id>

<property name = "username"/>
<property name = "password" />
<property name = "email"/>
<property name = "firstName"/>
<property name = "lastName"/>
<property name = "status"/>
<property name = "address1" column="addr1"/>
<property name = "address2" column="addr2"/>
<property name = "city"/>
<property name = "state"/>
<property name = "zip"/>
<property name = "country"/>
<property name = "phone"/>
<property name = "favouriteCategoryId" column="favcategory" />
<property name = "languagePreference" column="langpref"/>
<property name = "listOption" column="mylistopt"/>
<property name = "bannerOption" column="banneropt"/>
<property name = "bannerName" column="bannername" />

</class>


<class name = "org.springframework.samples.jpetstore.domain.Category" lazy="false" table = "category" >


<id name="categoryId" type="string" unsaved-value="null" >
<column name="catid" sql-type="varchar" not-null="true"/>
<generator class="uuid.hex"/>
</id>

<property name = "name"/>
<property name = "description" column="descn"/>
</class>

<class name = "org.springframework.samples.jpetstore.domain.Product" table = "product" >

<id name="productId" type="string" unsaved-value="null" >
<column name="productid" sql-type="varchar" not-null="true"/>
<generator class="uuid.hex"/>
</id>


<property name = "categoryId" column="category"/>
<property name = "name" />
<property name = "description" column="descn" />

</class>

<class name = "org.springframework.samples.jpetstore.domain.Item" table = "item">


<id name="itemId" type="string" unsaved-value="null" >
<column name="itemid" sql-type="varchar" not-null="true"/>
<generator class="uuid.hex"/>
</id>


<many-to-one name="productId"
column="productid"
class="org.springframework.samples.jpetstore.domain.Product"/>



<!-- <property name = "quantity" />-->

<one-to-one name="product" foreign-key="productId"
class="org.springframework.samples.jpetstore.domain.Product"/>

<many-to-one name="supplierId"
column="supplier"
class="org.springframework.samples.jpetstore.domain.Item" />


<property name = "listPrice" column="listprice" />
<property name = "unitCost" column="unitcost" />
<property name = "status" />
<property name = "attribute1" column="attr1"/>
<property name = "attribute2" column="attr2"/>
<property name = "attribute3" column="attr3"/>
<property name = "attribute4" column="attr4"/>
<property name = "attribute5" column="attr5"/>

</class>

<class name = "org.springframework.samples.jpetstore.domain.Order" table = "orders" >


<id name="orderId" type="string" unsaved-value="null" >
<column name="orderid" sql-type="integer" not-null="true"/>
<generator class="uuid.hex"/>
</id>

<!-- <property name = "orderid"/> -->
<property name = "username" />
<property name = "orderDate" column="orderdate"/>
<property name = "shipAddress1" column="shipaddr1"/>
<property name = "shipAddress2" column="shipaddr2"/>
<property name = "shipCity" column="shipcity"/>
<property name = "shipState" column="shipstate"/>
<property name = "shipZip" column="shipzip"/>
<property name = "shipCountry" column="shipcountry"/>
<property name = "billAddress1" column="billaddr1"/>
<property name = "billAddress2" column="billaddr2"/>
<property name = "billCity" column="billcity"/>
<property name = "billState" column="billstate"/>
<property name = "billZip" column="billzip"/>
<property name = "billCountry" column="billcountry"/>
<property name = "courier" />
<property name = "totalPrice" />
<property name = "billToFirstName" column="billtofirstname"/>
<property name = "shipToFirstName" column="shiptofirstname"/>
<property name = "shipToLastName" column="shiptolastname"/>
<property name = "creditCard" column="creditcard"/>
<property name = "expiryDate" column="exprdate"/>
<property name = "cardType" column="cardtype"/>
<property name = "locale"/>
<property name = "status"/>

</class>


</hibernate-mapping>



 petstore.hbm.xml

Code between sessionFactory.openSession() and session.close():
This is not required when hibernate is used with spring
We can use

List list = getHibernateTemplate().find("select i.itemId, i.listPrice, i.unitCost, i.supplierId,i.productId,p.name,p.description,p.categoryId,i.status, i.attribute1, i.attribute2, i.attribute3, i.attribute4, i.attribute5 from Item as i ,Product as p where p.productId=i.productId and i.productId like \'"+productId+"\'");

Full stack trace of any exception that occurs:



NFO: In ViewProductController.handleRequest::::
ec 28, 2005 6:02:56 PM org.springframework.samples.jpetstore.web.spring.ViewProductController handleRequest
NFO: ViewProductController.productId ::::::::::::FI-FW-01
ec 28, 2005 6:02:56 PM org.springframework.samples.jpetstore.web.spring.ViewProductController handleRequest
NFO: ViewCategoryController.category in handleRequest@ ::::::::::::
ec 28, 2005 6:02:56 PM org.springframework.samples.jpetstore.domain.logic.PetStoreImpl getItemListByProduct
NFO: In PetStoreImpl.getItemListByProduct:::: FI-FW-01
ec 28, 2005 6:02:56 PM org.springframework.samples.jpetstore.dao.hibernate.HibernateImplItemDao getItemListByProduct
NFO: In HibernateImplItemDao.getItemListByProduct(String productId) :::::::::::::
ibernate: select item0_.itemid as itemid0_, product1_.productid as productid1_, item0_.productid as productid3_0_, item0_.supplier as supplier3_0_, item0_.listprice as listprice3_0_, item0_.unitcost as unitcost3_0_, item0_.status as status3_0_, item0_.attr1 as attr7_3_0_, item0_.attr2 as attr8_3_0_, item0_.attr3 as attr9
ec 28, 2005 6:02:56 PM org.springframework.samples.jpetstore.domain.Item setItemId
NFO: In Item.setItemId::::
n Product.setProductId::::::::FI-FW-01
ec 28, 2005 6:02:56 PM org.springframework.samples.jpetstore.domain.Item setItemId
NFO: In Item.setItemId::::
ibernate: select product0_.productid as productid0_, product0_.category as category2_0_, product0_.name as name2_0_, product0_.descn as descn2_0_ from product product0_ where product0_.productid=?
ec 28, 2005 6:02:56 PM org.springframework.web.servlet.FrameworkServlet serviceWrapper
EVERE: Could not complete request
rg.springframework.orm.hibernate3.HibernateSystemException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of org.springframework.samples.jpetstore.domain.Item.setProductId; nested exception is org.hibernate.PropertyAccessException: exception setting
rg.hibernate.PropertyAccessException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of org.springframework.samples.jpetstore.domain.Item.setProductId
at org.hibernate.tuple.PojoTuplizer.setPropertyValuesWithOptimizer(PojoTuplizer.java:203)
at org.hibernate.tuple.PojoTuplizer.setPropertyValues(PojoTuplizer.java:173)
at org.hibernate.persister.entity.BasicEntityPersister.setPropertyValues(BasicEntityPersister.java:2919)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:113)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:523)
at org.hibernate.loader.Loader.doQuery(Loader.java:429)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:211)
at org.hibernate.loader.Loader.doList(Loader.java:1588)
at org.hibernate.loader.Loader.list(Loader.java:1571)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:751)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:312)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:742)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:734)
at org.springframework.samples.jpetstore.dao.hibernate.HibernateImplItemDao.getItemListByProduct(HibernateImplItemDao.java:62)
at org.springframework.samples.jpetstore.domain.logic.PetStoreImpl.getItemListByProduct(PetStoreImpl.java:169)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy1.getItemListByProduct(Unknown Source)
at org.springframework.samples.jpetstore.web.spring.ViewProductController.handleRequest(ViewProductController.java:43)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:386)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:346)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
aused by: net.sf.cglib.beans.BulkBeanException: org.springframework.samples.jpetstore.domain.Product
at org.springframework.samples.jpetstore.domain.Item$$BulkBeanByCGLIB$$c4f80dfb.setPropertyValues(<generated>)
at org.hibernate.tuple.PojoTuplizer.setPropertyValuesWithOptimizer(PojoTuplizer.java:200)
... 51 more
aused by: java.lang.ClassCastException: org.springframework.samples.jpetstore.domain.Product
... 53 more

Name and version of the database you are using: mysql4.0.17

The generated SQL (show_sql=true):

select item0_.itemid as itemid0_, product1_.productid as productid1_, item0_.productid as productid3_0_, item0_.supplier as supplier3_0_, item0_.listprice as listprice3_0_, item0_.unitcost as unitcost3_0_, item0_.status as status3_0_, item0_.attr1 as attr7_3_0_, item0_.attr2 as attr8_3_0_, item0_.attr3 as attr9_3_0_, item0_.attr4 as attr10_3_0_, item0_.attr5 as attr11_3_0_, product1_.category as category2_1_, product1_.name as name2_1_, product1_.descn as descn2_1_ from item item0_, product product1_ where product1_.productid=item0_.productid and (item0_.productid like 'FI-FW-01')

[b]Debug level Hibernate log excerpt:

Dec 28, 2005 6:09:08 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Dec 28, 2005 6:09:08 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1141 ms
Dec 28, 2005 6:09:08 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Dec 28, 2005 6:09:08 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.9
Dec 28, 2005 6:09:08 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Dec 28, 2005 6:09:11 PM org.springframework.web.context.ContextLoader initWebApplicationContext
INFO: Root WebApplicationContext: initialization started
Dec 28, 2005 6:09:11 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from ServletContext resource [/WEB-INF/dataAccessContext-local.xml]
Dec 28, 2005 6:09:11 PM org.springframework.core.CollectionFactory <clinit>
INFO: JDK 1.4+ collections available
Dec 28, 2005 6:09:11 PM org.springframework.core.CollectionFactory <clinit>
INFO: Commons Collections 3.x available
Dec 28, 2005 6:09:11 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext-hibernate.xml]
Dec 28, 2005 6:09:11 PM org.springframework.context.support.AbstractRefreshableApplicationContext refreshBeanFactory
INFO: Bean factory for application context [Root WebApplicationContext]: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [propertyConfigurer,sessionFactory,transactionManager,dataSource,accountDao,categoryDao,productDao,itemDao,orderDao,accountValidator,orderValidator,petStore,petstore:service=hibernateStatistics,jmxExporter]; root of BeanFactory hierarchy
Dec 28, 2005 6:09:11 PM org.springframework.context.support.AbstractApplicationContext refresh
INFO: 14 beans defined in application context [Root WebApplicationContext]
Dec 28, 2005 6:09:11 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'propertyConfigurer'
Dec 28, 2005 6:09:11 PM org.springframework.core.io.support.PropertiesLoaderSupport loadProperties
INFO: Loading properties file from ServletContext resource [/WEB-INF/jdbc.properties]
Dec 28, 2005 6:09:11 PM org.springframework.context.support.AbstractApplicationContext initMessageSource
INFO: Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@d16fc1]
Dec 28, 2005 6:09:11 PM org.springframework.context.support.AbstractApplicationContext initApplicationEventMulticaster
INFO: Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@1dee400]
Dec 28, 2005 6:09:11 PM org.springframework.ui.context.support.UiApplicationContextUtils initThemeSource
INFO: No ThemeSource found for [Root WebApplicationContext]: using ResourceBundleThemeSource
Dec 28, 2005 6:09:11 PM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
INFO: Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [propertyConfigurer,sessionFactory,transactionManager,dataSource,accountDao,categoryDao,productDao,itemDao,orderDao,accountValidator,orderValidator,petStore,petstore:service=hibernateStatistics,jmxExporter]; root of BeanFactory hierarchy]
Dec 28, 2005 6:09:11 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'sessionFactory'
Dec 28, 2005 6:09:12 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'dataSource'
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.0.4
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.Environment <clinit>
INFO: using CGLIB reflection optimizer
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: org.springframework.samples.jpetstore.domain.Account -> account
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: org.springframework.samples.jpetstore.domain.Category -> category
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: org.springframework.samples.jpetstore.domain.Product -> product
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: org.springframework.samples.jpetstore.domain.Item -> item
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: org.springframework.samples.jpetstore.domain.Order -> orders
Dec 28, 2005 6:09:12 PM org.springframework.orm.hibernate3.LocalSessionFactoryBean afterPropertiesSet
INFO: Building new Hibernate SessionFactory
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.Configuration secondPassCompile
INFO: processing extends queue
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.Configuration secondPassCompile
INFO: processing collection mappings
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.Configuration secondPassCompile
INFO: processing association property references
Dec 28, 2005 6:09:12 PM org.hibernate.cfg.Configuration secondPassCompile
INFO: processing foreign key constraints
Dec 28, 2005 6:09:12 PM org.hibernate.connection.ConnectionProviderFactory newConnectionProvider
INFO: Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: MySQL, version: 4.0.17-nt
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.2.0-alpha ( $Date: 2004/12/13 22:22:04 $, $Revision: 1.27.4.35.2.9 $ )
Dec 28, 2005 6:09:13 PM org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
Dec 28, 2005 6:09:13 PM org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
Dec 28, 2005 6:09:13 PM org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: null
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
Dec 28, 2005 6:09:13 PM org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.EhCacheProvider
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: enabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
Dec 28, 2005 6:09:13 PM org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
Dec 28, 2005 6:09:14 PM org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
Dec 28, 2005 6:09:14 PM net.sf.ehcache.config.Configurator configure
WARNING: No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/E:/Tomcat/jakarta-tomcat-5.5.9/webapps/jpetstore/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item getProductId
INFO: In Item.isInStock::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item getProduct
INFO: In Item.getProduct::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item getSupplierId
INFO: In Item.getSupplierId::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item getListPrice
INFO: In Item.getListPrice::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item getUnitCost
INFO: In Item.getUnitCost::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item getStatus
INFO: In Item.getStatus::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item getAttribute1
INFO: In Item.getAttribute1::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item getAttribute2
INFO: In Item.getAttribute2::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item getAttribute3
INFO: In Item.getAttribute3::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item getAttribute4
INFO: In Item.getAttribute4::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item getAttribute5
INFO: In Item.getAttribute5::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item setProductId
INFO: In Item.getProductId::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item setProduct
INFO: In Item.setProduct::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item setSupplierId
INFO: In Item.setSupplierId::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item setListPrice
INFO: In Item.setListPrice::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item setUnitCost
INFO: In Item.setUnitCost::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item setStatus
INFO: In Item.setStatus::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item setAttribute1
INFO: In Item.setAttribute1::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item setAttribute2
INFO: In Item.setAttribute2::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item setAttribute3
INFO: In Item.setAttribute3::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item setAttribute4
INFO: In Item.setAttribute4::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Item setAttribute5
INFO: In Item.setAttribute5::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getUsername
INFO: In Order.getUsername::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getOrderDate
INFO: In Order.getOrderDate::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getShipAddress1
INFO: In Order.getShipAddress1::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getShipAddress2
INFO: In Order.getShipAddress2::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getShipCity
INFO: In Order.getShipCity::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getShipState
INFO: In Order.getShipState::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getShipZip
INFO: In Order.getShipZip::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getShipCountry
INFO: In Order.getShipCountry::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getBillAddress1
INFO: In Order.getBillAddress1::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getBillAddress2
INFO: In Order.getBillAddress2::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getBillCity
INFO: In Order.getBillCity::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getBillState
INFO: In Order.getBillState::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getBillZip
INFO: In Order.getBillZip::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getBillCountry
INFO: In Order.getBillCountry::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getCourier
INFO: In Order.getCourier::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getTotalPrice
INFO: In Order.getTotalPrice::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getBillToFirstName
INFO: In Order.getBillToFirstName::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getShipToFirstName
INFO: In Order.getShipToFirstName::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getShipToLastName
INFO: In Order.getShipToLastName::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getCreditCard
INFO: In Order.getCreditCard::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getExpiryDate
INFO: In Order.getExpiryDate::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getCardType
INFO: In Order.getCardType::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getLocale
INFO: In Order.getLocale::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order getStatus
INFO: In Order.getStatus::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setUsername
INFO: In Order.setUsername::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setOrderDate
INFO: In Order.setOrderDate::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setShipAddress1
INFO: In Order.setShipAddress1::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setShipAddress2
INFO: In Order.setShipAddress2::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setShipCity
INFO: In Order.setShipCity::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setShipState
INFO: In Order.setShipState::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setShipZip
INFO: In Order.setShipZip::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setShipCountry
INFO: In Order.setShipCountry::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setBillAddress1
INFO: In Order.setBillAddress1::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setBillAddress2
INFO: In Order.setBillAddress2::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setBillCity
INFO: In Order.setBillCity::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setBillState
INFO: In Order.setBillState::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setBillZip
INFO: In Order.setBillZip::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setBillCountry
INFO: In Order.setBillCountry::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setCourier
INFO: In Order.setCourier::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setTotalPrice
INFO: In Order.setTotalPrice::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setBillToFirstName
INFO: In Order.setBillToFirstName::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setShipToFirstName
INFO: In Order.setShipToFirstName::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setShipToLastName
INFO: In Order.setShipToLastName::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setCreditCard
INFO: In Order.setCreditCard::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setExpiryDate
INFO: In Order.setExpiryDate::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setCardType
INFO: In Order.setCardType::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setLocale
INFO: In Order.setLocale::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Order setStatus
INFO: In Order.setStatus::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getUsername
INFO: In Account.getUsername::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getPassword
INFO: In Account.getPassword::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getEmail
INFO: In Account.getEmail::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getFirstName
INFO: In Account.getFirstName::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getLastName
INFO: In Account.getLastName::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getStatus
INFO: In Account.getStatus::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getAddress1
INFO: In Account.getAddress1::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getAddress2
INFO: In Account.getAddress2::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getCity
INFO: In Account.getCity::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getState
INFO: In Account.getState::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getZip
INFO: In Account.getZip::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getCountry
INFO: In Account.getCountry::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getPhone
INFO: In Account.getPhone::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getFavouriteCategoryId
INFO: In Account.getFavouriteCategoryId::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getLanguagePreference
INFO: In Account.getLanguagePreference::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account isListOption
INFO: In Account.isListOption::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account isBannerOption
INFO: In Account.isBannerOption::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account getBannerName
INFO: In Account.getBannerName::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account setUsername
INFO: In Account.setUsername::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account setPassword
INFO: In Account.setPassword::::
Dec 28, 2005 6:09:14 PM org.springframework.samples.jpetstore.domain.Account setEmail
INFO: In Account.setEmail::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setFirstName
INFO: In Account.setFirstName::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setLastName
INFO: In Account.setLastName::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setStatus
INFO: In Account.setStatus::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setAddress1
INFO: In Account.setAddress1::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setAddress2
INFO: In Account.setAddress2::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setCity
INFO: In Account.setCity::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setState
INFO: In Account.setState::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setZip
INFO: In Account.setZip::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setCountry
INFO: In Account.setCountry::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setPhone
INFO: In Account.setPhone::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setFavouriteCategoryId
INFO: In Account.setFavouriteCategoryId::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setLanguagePreference
INFO: In Account.setLanguagePreference::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setListOption
INFO: In Account.setListOption::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setBannerOption
INFO: In Account.setBannerOption::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.Account setBannerName
INFO: In Account.setBannerName::::
Dec 28, 2005 6:09:15 PM org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
Dec 28, 2005 6:09:15 PM org.hibernate.impl.SessionFactoryImpl checkNamedQueries
INFO: Checking 0 named queries
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'transactionManager'
Dec 28, 2005 6:09:15 PM org.springframework.orm.hibernate3.HibernateTransactionManager afterPropertiesSet
INFO: Using DataSource [org.apache.commons.dbcp.BasicDataSource@2bccb2] of Hibernate SessionFactory for HibernateTransactionManager
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'accountDao'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'categoryDao'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'productDao'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'itemDao'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'orderDao'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'accountValidator'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'orderValidator'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'petStore'
Dec 28, 2005 6:09:15 PM org.springframework.aop.framework.DefaultAopProxyFactory <clinit>
INFO: CGLIB2 available: proxyTargetClass feature enabled
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.logic.PetStoreImpl setAccountDao
INFO: In PetStoreImpl.setAccountDao::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.logic.PetStoreImpl setCategoryDao
INFO: In PetStoreImpl.setCategoryDao::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.logic.PetStoreImpl setProductDao
INFO: In PetStoreImpl.setProductDao::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.logic.PetStoreImpl setItemDao
INFO: In PetStoreImpl.setItemDao::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.domain.logic.PetStoreImpl setOrderDao
INFO: In PetStoreImpl.setOrderDao::::
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'petstore:service=hibernateStatistics'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'jmxExporter'
Dec 28, 2005 6:09:15 PM org.springframework.jmx.export.MBeanExporter registerBeans
INFO: Autodetecting user-defined JMX MBeans
Dec 28, 2005 6:09:15 PM org.springframework.jmx.export.MBeanExporter autodetect
INFO: Bean with name 'petstore:service=hibernateStatistics' has been autodetected for JMX exposure
Dec 28, 2005 6:09:15 PM org.springframework.web.context.ContextLoader initWebApplicationContext
INFO: Using context class [org.springframework.web.context.support.XmlWebApplicationContext] for root WebApplicationContext
Dec 28, 2005 6:09:15 PM org.springframework.web.context.ContextLoader initWebApplicationContext
INFO: Root WebApplicationContext: initialization completed in 4188 ms
Dec 28, 2005 6:09:15 PM org.springframework.web.servlet.HttpServletBean init
INFO: Initializing servlet 'petstore'
Dec 28, 2005 6:09:15 PM org.springframework.web.servlet.FrameworkServlet initServletBean
INFO: FrameworkServlet 'petstore': initialization started
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from ServletContext resource [/WEB-INF/petstore-servlet.xml]
Dec 28, 2005 6:09:15 PM org.springframework.context.support.AbstractRefreshableApplicationContext refreshBeanFactory
INFO: Bean factory for application context [WebApplicationContext for namespace 'petstore-servlet']: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [viewResolver,defaultHandlerMapping,/shop/addItemToCart.do,/shop/checkout.do,/shop/index.do,/shop/newAccount.do,/shop/removeItemFromCart.do,/shop/signoff.do,/shop/searchProducts.do,/shop/signon.do,/shop/signonForm.do,/shop/updateCartQuantities.do,/shop/viewCart.do,/shop/viewCategory.do,/shop/viewItem.do,/shop/viewProduct.do,secureHandlerMapping,signonInterceptor,secure_editAccount,secure_listOrders,secure_newOrder,secure_viewOrder]; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [propertyConfigurer,sessionFactory,transactionManager,dataSource,accountDao,categoryDao,productDao,itemDao,orderDao,accountValidator,orderValidator,petStore,petstore:service=hibernateStatistics,jmxExporter]; root of BeanFactory hierarchy
Dec 28, 2005 6:09:15 PM org.springframework.context.support.AbstractApplicationContext refresh
INFO: 22 beans defined in application context [WebApplicationContext for namespace 'petstore-servlet']
Dec 28, 2005 6:09:15 PM org.springframework.context.support.AbstractApplicationContext initMessageSource
INFO: Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@9be2b5]
Dec 28, 2005 6:09:15 PM org.springframework.context.support.AbstractApplicationContext initApplicationEventMulticaster
INFO: Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@40ece0]
Dec 28, 2005 6:09:15 PM org.springframework.ui.context.support.UiApplicationContextUtils initThemeSource
INFO: No ThemeSource found for [WebApplicationContext for namespace 'petstore-servlet']: using ResourceBundleThemeSource
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
INFO: Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [viewResolver,defaultHandlerMapping,/shop/addItemToCart.do,/shop/checkout.do,/shop/index.do,/shop/newAccount.do,/shop/removeItemFromCart.do,/shop/signoff.do,/shop/searchProducts.do,/shop/signon.do,/shop/signonForm.do,/shop/updateCartQuantities.do,/shop/viewCart.do,/shop/viewCategory.do,/shop/viewItem.do,/shop/viewProduct.do,secureHandlerMapping,signonInterceptor,secure_editAccount,secure_listOrders,secure_newOrder,secure_viewOrder]; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [propertyConfigurer,sessionFactory,transactionManager,dataSource,accountDao,categoryDao,productDao,itemDao,orderDao,accountValidator,orderValidator,petStore,petstore:service=hibernateStatistics,jmxExporter]; root of BeanFactory hierarchy]
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'viewResolver'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'defaultHandlerMapping'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/addItemToCart.do'
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.web.spring.AddItemToCartController setPetStore
INFO: In AddItemToCartController.setPetStore::::
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/checkout.do'
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.web.spring.ViewCartController setSuccessView
INFO: In ViewCartController.setSuccessView::::
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/index.do'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/newAccount.do'
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.web.spring.AccountFormController <init>
INFO: In AccountFormController.AccountFormController():::::::::::::
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.web.spring.AccountFormController setPetStore
INFO: In AccountFormController.setPetStore:::::::::::::
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/removeItemFromCart.do'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/signoff.do'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/searchProducts.do'
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.web.spring.SearchProductsController setPetStore
INFO: In SearchProductsController.setPetStore::::
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/signon.do'
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.web.spring.SignonController setPetStore
INFO: In SignonController.setPetStore:::::::::::::
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/signonForm.do'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/updateCartQuantities.do'
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/viewCart.do'
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.web.spring.ViewCartController setSuccessView
INFO: In ViewCartController.setSuccessView::::
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/viewCategory.do'
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.web.spring.ViewCategoryController setPetStore
INFO: In ViewCategoryController.setPetStore ::::::::::::
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/viewItem.do'
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.web.spring.ViewItemController setPetStore
INFO: In ViewItemController.setPetStore::::
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/shop/viewProduct.do'
Dec 28, 2005 6:09:15 PM org.springframework.samples.jpetstore.web.spring.ViewProductController setPetStore
INFO: In ViewProductController.setPetStore::::
Dec 28, 2005 6:09:15 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'secureHandlerMapping'
Dec 28, 2005 6:09:16 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'signonInterceptor'
Dec 28, 2005 6:09:16 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'secure_editAccount'
Dec 28, 2005 6:09:16 PM org.springframework.samples.jpetstore.web.spring.AccountFormController <init>
INFO: In AccountFormController.AccountFormController():::::::::::::
Dec 28, 2005 6:09:16 PM org.springframework.samples.jpetstore.web.spring.AccountFormController setPetStore
INFO: In AccountFormController.setPetStore:::::::::::::
Dec 28, 2005 6:09:16 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'secure_listOrders'
Dec 28, 2005 6:09:16 PM org.springframework.samples.jpetstore.web.spring.ListOrdersController setPetStore
INFO: In ListOrdersController.setPetStore::::
Dec 28, 2005 6:09:16 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'secure_newOrder'
Dec 28, 2005 6:09:16 PM org.springframework.samples.jpetstore.web.spring.OrderFormController <init>
INFO: In OrderFormController.OrderFormController()::::
Dec 28, 2005 6:09:16 PM org.springframework.samples.jpetstore.web.spring.OrderFormController setPetStore
INFO: In OrderFormController.setPetStore::::
Dec 28, 2005 6:09:16 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'secure_viewOrder'
Dec 28, 2005 6:09:16 PM org.springframework.samples.jpetstore.web.spring.ViewOrderController setPetStore
INFO: In ViewOrderController.setPetStore::::
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.FrameworkServlet initWebApplicationContext
INFO: Using context class [org.springframework.web.context.support.XmlWebApplicationContext] for servlet 'petstore'
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.DispatcherServlet initMultipartResolver
INFO: Unable to locate MultipartResolver with name 'multipartResolver': no multipart request handling provided
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.DispatcherServlet initLocaleResolver
INFO: Unable to locate LocaleResolver with name 'localeResolver': using default [org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolver@1321f5]
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.DispatcherServlet initThemeResolver
INFO: Unable to locate ThemeResolver with name 'themeResolver': using default [org.springframework.web.servlet.theme.FixedThemeResolver@13e4a5a]
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.DispatcherServlet initHandlerAdapters
INFO: No HandlerAdapters found in servlet 'petstore': using default
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.FrameworkServlet initServletBean
INFO: FrameworkServlet 'petstore': initialization completed in 453 ms
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.HttpServletBean init
INFO: Servlet 'petstore' configured successfully
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.HttpServletBean init
INFO: Initializing servlet 'remoting'
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.FrameworkServlet initServletBean
INFO: FrameworkServlet 'remoting': initialization started
Dec 28, 2005 6:09:16 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from ServletContext resource [/WEB-INF/remoting-servlet.xml]
Dec 28, 2005 6:09:16 PM org.springframework.context.support.AbstractRefreshableApplicationContext refreshBeanFactory
INFO: Bean factory for application context [WebApplicationContext for namespace 'remoting-servlet']: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [/OrderService-hessian,/OrderService-burlap,/OrderService-httpinvoker]; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [propertyConfigurer,sessionFactory,transactionManager,dataSource,accountDao,categoryDao,productDao,itemDao,orderDao,accountValidator,orderValidator,petStore,petstore:service=hibernateStatistics,jmxExporter]; root of BeanFactory hierarchy
Dec 28, 2005 6:09:16 PM org.springframework.context.support.AbstractApplicationContext refresh
INFO: 3 beans defined in application context [WebApplicationContext for namespace 'remoting-servlet']
Dec 28, 2005 6:09:16 PM org.springframework.context.support.AbstractApplicationContext initMessageSource
INFO: Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@e0f0ad]
Dec 28, 2005 6:09:16 PM org.springframework.context.support.AbstractApplicationContext initApplicationEventMulticaster
INFO: Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@1d8f162]
Dec 28, 2005 6:09:16 PM org.springframework.ui.context.support.UiApplicationContextUtils initThemeSource
INFO: No ThemeSource found for [WebApplicationContext for namespace 'remoting-servlet']: using ResourceBundleThemeSource
Dec 28, 2005 6:09:16 PM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
INFO: Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [/OrderService-hessian,/OrderService-burlap,/OrderService-httpinvoker]; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [propertyConfigurer,sessionFactory,transactionManager,dataSource,accountDao,categoryDao,productDao,itemDao,orderDao,accountValidator,orderValidator,petStore,petstore:service=hibernateStatistics,jmxExporter]; root of BeanFactory hierarchy]
Dec 28, 2005 6:09:16 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/OrderService-hessian'
Dec 28, 2005 6:09:16 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/OrderService-burlap'
Dec 28, 2005 6:09:16 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean '/OrderService-httpinvoker'
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.FrameworkServlet initWebApplicationContext
INFO: Using context class [org.springframework.web.context.support.XmlWebApplicationContext] for servlet 'remoting'
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.DispatcherServlet initMultipartResolver
INFO: Unable to locate MultipartResolver with name 'multipartResolver': no multipart request handling provided
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.DispatcherServlet initLocaleResolver
INFO: Unable to locate LocaleResolver with name 'localeResolver': using default [org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolver@1536eec]
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.DispatcherServlet initThemeResolver
INFO: Unable to locate ThemeResolver with name 'themeResolver': using default [org.springframework.web.servlet.theme.FixedThemeResolver@9770a3]
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.DispatcherServlet initHandlerMappings
INFO: No HandlerMappings found in servlet 'remoting': using default
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.DispatcherServlet initHandlerAdapters
INFO: No HandlerAdapters found in servlet 'remoting': using default
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.DispatcherServlet initViewResolvers
INFO: No ViewResolvers found in servlet 'remoting': using default
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.FrameworkServlet initServletBean
INFO: FrameworkServlet 'remoting': initialization completed in 109 ms
Dec 28, 2005 6:09:16 PM org.springframework.web.servlet.HttpServletBean init
INFO: Servlet 'remoting' configured successfully
Dec 28, 2005 6:09:17 PM org.apache.axis.utils.JavaUtils isAttachmentSupported
WARNING: Unable to find required classes (javax.activation.DataHandler and javax.mail.internet.MimeMultipart). Attachment support is disabled.
Dec 28, 2005 6:09:18 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Dec 28, 2005 6:09:18 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Dec 28, 2005 6:09:18 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/62 config=null
Dec 28, 2005 6:09:18 PM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Dec 28, 2005 6:09:19 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 10625 ms
Dec 28, 2005 6:09:31 PM org.springframework.samples.jpetstore.web.spring.ViewCategoryController handleRequest
INFO: In ViewCategoryController.handleRequest ::::::::::::
Dec 28, 2005 6:09:31 PM org.springframework.samples.jpetstore.web.spring.ViewCategoryController handleRequest
INFO: ViewCategoryController.categoryId in handleRequest ::::::::::::FISH
Dec 28, 2005 6:09:31 PM org.springframework.jdbc.datasource.JdbcTransactionObjectSupport <clinit>
INFO: JDBC 3.0 Savepoint class is available
Dec 28, 2005 6:09:31 PM org.springframework.samples.jpetstore.domain.logic.PetStoreImpl getCategory
INFO: In PetStoreImpl.getCategory::::
Dec 28, 2005 6:09:31 PM org.springframework.samples.jpetstore.dao.hibernate.HibernateImplCategoryDao getCategory
INFO: In HibernateImplCategoryDao.getCategory(String categoryId):::::::::::::FISH
Dec 28, 2005 6:09:31 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
Dec 28, 2005 6:09:32 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'DB2'
Dec 28, 2005 6:09:32 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'HSQL'
Dec 28, 2005 6:09:32 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'MS-SQL'
Dec 28, 2005 6:09:32 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'MySQL'
Dec 28, 2005 6:09:32 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'Oracle'
Dec 28, 2005 6:09:32 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'Informix'
Dec 28, 2005 6:09:32 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'PostgreSQL'
Dec 28, 2005 6:09:32 PM org.springframework.beans.factory.support.AbstractBeanFactory getBean
INFO: Creating shared instance of singleton bean 'Sybase'
Dec 28, 2005 6:09:32 PM org.springframework.jdbc.support.SQLErrorCodesFactory <init>
INFO: SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase]
Dec 28, 2005 6:09:32 PM org.springframework.samples.jpetstore.dao.hibernate.HibernateImplCategoryDao getCategory
INFO: load is working fine:::::::::
Dec 28, 2005 6:09:32 PM org.springframework.samples.jpetstore.dao.hibernate.HibernateImplCategoryDao getCategory
INFO: exit HibernateImplCategoryDao.getCategory(String categoryId):::::::::::::FISH
Dec 28, 2005 6:09:32 PM org.springframework.samples.jpetstore.dao.hibernate.HibernateImplCategoryDao getCategory
INFO: exit HibernateImplCategoryDao.getCategory(String categoryId):::::::::::::Fish
Dec 28, 2005 6:09:32 PM org.springframework.samples.jpetstore.domain.logic.PetStoreImpl getCategory
INFO: Exit PetStoreImpl.getCategory::::
Dec 28, 2005 6:09:32 PM org.springframework.samples.jpetstore.web.spring.ViewCategoryController handleRequest
INFO: ViewCategoryController.category in handleRequest@ ::::::::::::
Dec 28, 2005 6:09:32 PM org.springframework.samples.jpetstore.domain.logic.PetStoreImpl getProductListByCategory
INFO: In PetStoreImpl.getProductListByCategory::::
Dec 28, 2005 6:09:32 PM org.springframework.samples.jpetstore.dao.hibernate.HibernateImplProductDao getProductListByCategory
INFO: In HibernateImplProductDao.getProductListByCategory:::::::::::::FISH
Dec 28, 2005 6:09:32 PM org.springframework.samples.jpetstore.web.spring.ViewCategoryController handleRequest
INFO: ViewCategoryController.productList in handleRequest ::::::::::::org.springframework.beans.support.PagedListHolder@992fa5
Dec 28, 2005 6:09:33 PM org.springframework.samples.jpetstore.web.spring.ViewProductController handleRequest
INFO: In ViewProductController.handleRequest::::
Dec 28, 2005 6:09:33 PM org.springframework.samples.jpetstore

_________________
avinashb@cybage.com

Top
 Profile  
 
ramnath
 Post subject:
PostPosted: Thu Dec 29, 2005 1:39 am 
Expert
Expert

Joined: Thu May 26, 2005 9:19 am
Posts: 262
Location: Oak Creek, WI
Hi,

Did u note this?

caused by: java.lang.ClassCastException: org.springframework.samples.jpetstore.domain.Product

Let us try to split the query as to a simple one and then we will solve it.
like

select item, product from Item item, Product product where item.productId=product.productId

or

Use Criteria with Restrictions.

_________________
RamnathN
Senior Software Engineer
http://www.linkedin.com/in/ramnathn
Don't forget to rate.

Top
 Profile  
 
avinashb
 Post subject: facing problem while fetching data from more than one class
PostPosted: Mon Jan 02, 2006 1:45 am 
Beginner
Beginner

Joined: Fri Dec 23, 2005 3:26 am
Posts: 21
Hi RamnathN,

I have corrected the class cast exception but still the problem persists while fetching selected columns from two different classes


My simple hql is now as follows

List list = getHibernateTemplate().find(select item.itemid, product.name from Item item, Product product where item.productId=product.productId and i.productId like \'"+productId+"\'");

My itemid is already mapped in petstore.hbm.xml




I am getting following exception in tomcat

org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: itemid of: org.springframework.samples.jpetstore.domain.Item [select item.itemid, product.name from org.springframework.samples.jpetstore.domain.Item item, org.springframework.samples.jpetstore.domain.Product product where item.productId=product.productId and i.productId like 'FI-FW-01']; nested exc
org.hibernate.QueryException: could not resolve property: itemid of: org.springframework.samples.jpetstore.domain.Item [select item.itemid, product.name from org.springframework.samples.jpetstore.domain.Item item, org.springframework.samples.jpetstore.domain.Product product where item.productId=product.productId and i.productId like 'FI-FW-01']
at org.hibernate.persister.entity.AbstractPropertyMapping.throwPropertyException(AbstractPropertyMapping.java:43)
at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:37)
at org.hibernate.persister.entity.BasicEntityPersister.toType(BasicEntityPersister.java:1094)
at org.hibernate.hql.ast.FromElementType.getPropertyType(FromElementType.java:273)
at org.hibernate.hql.ast.FromElement.getPropertyType(FromElement.java:349)
at org.hibernate.hql.ast.DotNode.getDataType(DotNode.java:474)
at org.hibernate.hql.ast.DotNode.prepareLhs(DotNode.java:208)
at org.hibernate.hql.ast.DotNode.resolve(DotNode.java:166)
at org.hibernate.hql.ast.FromReferenceNode.resolve(FromReferenceNode.java:87)
at org.hibernate.hql.ast.FromReferenceNode.resolve(FromReferenceNode.java:83)
at org.hibernate.hql.ast.DotNode.resolveSelectExpression(DotNode.java:534)
at org.hibernate.hql.ast.HqlSqlWalker.resolveSelectExpression(HqlSqlWalker.java:474)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectExpr(HqlSqlBaseWalker.java:1527)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectExprList(HqlSqlBaseWalker.java:1467)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectClause(HqlSqlBaseWalker.java:1041)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:380)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:201)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:151)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:189)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:130)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:427)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:884)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:834)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(HibernateTemplate.java:751)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:312)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:742)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:734)
at org.springframework.samples.jpetstore.dao.hibernate.HibernateImplItemDao.getItemListByProduct(HibernateImplItemDao.java:61)
at org.springframework.samples.jpetstore.domain.logic.PetStoreImpl.getItemListByProduct(PetStoreImpl.java:169)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy1.getItemListByProduct(Unknown Source)
at org.springframework.samples.jpetstore.web.spring.ViewProductController.handleRequest(ViewProductController.java:43)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:386)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:346)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)



But If I select all columns from both the classes I do not get any exception.


The hql for that is as follows

List list = getHibernateTemplate().find("from Item i, Product p where p.productId=i.productId and i.productId like \'"+productId+"\'");


Regards,
Avinash

_________________
avinashb@cybage.com

Top
 Profile  
 
ramnath
 Post subject:
PostPosted: Tue Jan 03, 2006 1:12 am 
Expert
Expert

Joined: Thu May 26, 2005 9:19 am
Posts: 262
Location: Oak Creek, WI
Hi,

I feel the problem is with the item.itemid, show me your mapping file and the Item class.

It will work without the above.

_________________
RamnathN
Senior Software Engineer
http://www.linkedin.com/in/ramnathn
Don't forget to rate.

Top
 Profile  
 
avinashb
 Post subject: facing problem while fetching data from more than one class
PostPosted: Tue Jan 03, 2006 2:17 am 
Beginner
Beginner

Joined: Fri Dec 23, 2005 3:26 am
Posts: 21
Hi ,

My mapping file is already present in the discussion.
It is petstore.hbm,xml

My Item class is as follows


Item.java

package org.springframework.samples.jpetstore.domain;

import java.io.Serializable;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class Item implements Serializable {

/* Private Fields */

private String itemId;
private String productId;
private double listPrice;
private double unitCost;
private int supplierId;
private String status;
private String attribute1;
private String attribute2;
private String attribute3;
private String attribute4;
private String attribute5;
private Product product;
private int quantity;
protected final Log logger=LogFactory.getLog(getClass());


public Item()
{
}


/* JavaBeans Properties */

public String getItemId() {
logger.info("In Item.getItemId:::: ");
return itemId;
}
public void setItemId(String itemId) {
logger.info("In Item.setItemId:::: ");
this.itemId = itemId.trim();
}

public int getQuantity() {
logger.info("In Item.isInStock:::: ");
return quantity;
}
public void setQuantity(int quantity) {
logger.info("In Item.getQuantity:::: ");
this.quantity = quantity;
}

public Product getProduct() {
logger.info("In Item.getProduct:::: ");
return product;
}
public void setProduct(Product product) {
logger.info("In Item.setProduct:::: ");
this.product = product;
}

public String getProductId() {
logger.info("In Item.isInStock:::: ");
return productId;
}
public void setProductId(String productId) {
logger.info("In Item.getProductId:::: ");
this.productId = productId;
}

public int getSupplierId() {
logger.info("In Item.getSupplierId:::: ");
return supplierId;
}
public void setSupplierId(int supplierId) {
logger.info("In Item.setSupplierId:::: ");
this.supplierId = supplierId;

}

public double getListPrice() {
logger.info("In Item.getListPrice:::: ");
return listPrice;
}
public void setListPrice(double listPrice) {
logger.info("In Item.setListPrice:::: ");
this.listPrice = listPrice;
}

public double getUnitCost() {
logger.info("In Item.getUnitCost:::: ");
return unitCost;
}
public void setUnitCost(double unitCost) {
logger.info("In Item.setUnitCost:::: ");
this.unitCost = unitCost;
}

public String getStatus() {
logger.info("In Item.getStatus:::: ");
return status;
}
public void setStatus(String status) {
logger.info("In Item.setStatus:::: ");
this.status = status;
}

public String getAttribute1() {
logger.info("In Item.getAttribute1:::: ");
return attribute1;
}
public void setAttribute1(String attribute1) {
logger.info("In Item.setAttribute1:::: ");
this.attribute1 = attribute1;
}

public String getAttribute2() {
logger.info("In Item.getAttribute2:::: ");
return attribute2;

}
public void setAttribute2(String attribute2) {
logger.info("In Item.setAttribute2:::: ");
this.attribute2 = attribute2;
}

public String getAttribute3() {
logger.info("In Item.getAttribute3:::: ");
return attribute3;

}
public void setAttribute3(String attribute3) {
logger.info("In Item.setAttribute3:::: ");
this.attribute3 = attribute3;
}

public String getAttribute4() {
logger.info("In Item.getAttribute4:::: ");
return attribute4;
}
public void setAttribute4(String attribute4) {
logger.info("In Item.setAttribute4:::: ");
this.attribute4 = attribute4;
}

public String getAttribute5() {
logger.info("In Item.getAttribute5:::: ");
return attribute5;
}
public void setAttribute5(String attribute5) {
logger.info("In Item.setAttribute5:::: ");
this.attribute5 = attribute5;
}

/* Public Methods */

public String toString() {
logger.info("In Item.toString:::: ");
return "(" + getItemId().trim() + "-" + getProductId().trim() + ")";
}

}

In my application I have only changed the DAO's which are specific to hibernate.
Rest all the things are all same as jpetstore application of Spring Framework 1.2.2
this is an attempt to integrate spring & hibernate through jpetstore application of spring.


Regards
Avinash

_________________
avinashb@cybage.com

Top
 Profile  
 
ramnath
 Post subject:
PostPosted: Tue Jan 03, 2006 4:23 am 
Expert
Expert

Joined: Thu May 26, 2005 9:19 am
Posts: 262
Location: Oak Creek, WI
Hi,

List list = getHibernateTemplate().find(select item.itemId, product.name from Item item, Product product where item.productId=product.productId and item.productId like \'"+productId+"\'");


Check the bold part it should refer to java class variable instead it refers to column name. You used item.itemid which is column name.

_________________
RamnathN
Senior Software Engineer
http://www.linkedin.com/in/ramnathn
Don't forget to rate.

Top
 Profile  
 
avinashb
 Post subject: facing problem while fetching data from more than one class
PostPosted: Tue Jan 03, 2006 4:53 am 
Beginner
Beginner

Joined: Fri Dec 23, 2005 3:26 am
Posts: 21
Hi,

My simple query is working.

But when I modify the query to this, I do not get any data.

My Query is as follows:-

List list = getHibernateTemplate().find("select i.itemId, i.listPrice, i.unitCost, i.supplierId,i.productId,p.name,p.description,p.categoryId,i.status, i.attribute1, i.attribute2, i.attribute3, i.attribute4, i.attribute5 from Item as i ,Product as p where p.productId=i.productId and i.productId like \'"+productId+"\'"); // getting only column heading & no data


My generated query in Tomact is as folows--

select item0_.itemid as col_0_0_, item0_.listprice as col_1_0_, item0_.unitcost as col_2_0_, item0_.supplier as col_3_0_, item0_.productid as col_4_0_, product1_.name as col_5_0_, product1_.descn as col_6_0_, product1_.category as col_7_0_, item0_.status as col_8_0_, item0_.attr1 as col_9_0_, item0_.attr2 as col_10_0_, item0_.attr3 as col_11_0_, item0_.attr4 as col_12_0_, item0_.attr5 as col_13_0_, item2_.itemid as itemid0_, item0_.itemid as itemid1_, item2_.productid as productid3_0_, item2_.supplier as supplier3_0_, item2_.listprice as listprice3_0_, item2_.unitcost as unitcost3_0_, item2_.status as status3_0_, item2_.attr1 as attr7_3_0_, item2_.attr2 as attr8_3_0_, item2_.attr3 as attr9_3_0_, item2_.attr4 as attr10_3_0_, item2_.attr5 as attr11_3_0_, item0_.productid as productid3_1_, item0_.supplier as supplier3_1_, item0_.listprice as listprice3_1_, item0_.unitcost as unitcost3_1_, item0_.status as status3_1_, item0_.attr1 as attr7_3_1_, item0_.attr2 as attr8_3_1_, item0_.attr3 as attr9_3_1_, item0_.attr4 as attr10_3_1_, item0_.attr5 as attr11_3_1_ from item item0_, item item2_, product product1_ where item0_.supplier=item2_.itemid and product1_.productid=item0_.productid and (item0_.productid like 'FI-FW-01')

Here also the column heading for itemId is coming as col_0_0_ & so on.


So can you guide what is the mistake I am making here.


Regards,
Avinash

_________________
avinashb@cybage.com

Top
 Profile  
 
ramnath
 Post subject:
PostPosted: Tue Jan 03, 2006 5:15 am 
Expert
Expert

Joined: Thu May 26, 2005 9:19 am
Posts: 262
Location: Oak Creek, WI
Hi,

I think you have problem here i.supplierId. I dont have a solution after seeing your mapping it has an many-to-one relation but point to the same class.

I think you should be having all the values in the list.
you have type cast it to the corresponding classes and take the value.

Or try using Criteria.
http://www.hibernate.org/hib_docs/v3/re ... teria.html


This is the max i know.

_________________
RamnathN
Senior Software Engineer
http://www.linkedin.com/in/ramnathn
Don't forget to rate.

Top
 Profile  
 
avinashb
 Post subject: facing problem while fetching data from more than one class
PostPosted: Tue Jan 03, 2006 6:58 am 
Beginner
Beginner

Joined: Fri Dec 23, 2005 3:26 am
Posts: 21
Thanks RamnathN,

You are right.
I do have a problem with the supplierId.
I had given the mapping with the Item Class itself because I do not have a Supplier Class in my application but I do have a supplier table in database.

<many-to-one name="supplierId"
column="supplier"
class="org.springframework.samples.jpetstore.domain.Item" />


alter table item add foreign key (supplier)
references supplier(suppid)
on delete restrict
on update restrict;

This was the relation expected.(i.e with the supplier class).
Ideally this should have been the relationship
<many-to-one name="supplierId"
column="suppid"
class="org.springframework.samples.jpetstore.domain.Supplier" />

But I cannot do that as I do not have Supplier Class.

Anyhow Thanks Again,

Regards,
Avinash

_________________
avinashb@cybage.com

Top
 Profile  
 
ramnath
 Post subject:
PostPosted: Tue Jan 03, 2006 8:16 am 
Expert
Expert

Joined: Thu May 26, 2005 9:19 am
Posts: 262
Location: Oak Creek, WI
Avinash don't forget to give credit, If my posting helped you.

_________________
RamnathN
Senior Software Engineer
http://www.linkedin.com/in/ramnathn
Don't forget to rate.

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

Board index » Hibernate & Java Persistence » Hibernate Users

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.