I would like to create a query that returns a List of objects of Type Gallery.
This query leads to a HibernateQueryException:
Code:
SELECT new Gallery()
FROM com.vvdb.bus.gallery.Gallery AS gallery
JOIN gallery.models AS models,
com.vvdb.bus.gallery.Model AS model
WHERE gallery.title LIKE :title AND gallery.location = :location
AND gallery.activity = :activity AND model.modelState = :modelState
AND model.modelType = :modelType AND model.modelOrigin = :modelOrigin AND model IN elements(gallery.models)
(Full stack trace below)
When I change the query, leaving of the
Code:
"SELECT new Gallery()"
part, the query returns a List with objects of Type java.lang.Object.
I have another query:
Code:
return getHibernateTemplate().find("FROM com.vvdb.bus.gallery.Gallery");
that
does return a List with objects of Type Gallery.
I have two questions:
- how can I change the first query so that it returns a List with Objects of Type Gallery?
- is the documentation up-to-date concerning returing TypeSafe objects; I read in several places that one cannot call the constructor of the desired Type other than with primitive types, and that the select new Family(mother, mate, offspr) example does not work.
Your help is greatly appreciated.
Hibernate version: 2.1.6 Mapping documents:Code:
<hibernate-mapping default-cascade="save-update" >
<class name="com.vvdb.bus.metadata.Resource" table="RESOURCE">
<!-- A 32 hex character is our surrogate key. It's automatically
generated by Hibernate with the UUID pattern. -->
<id name="uniqueId" type="string" unsaved-value="null">
<column name="uniqueId" sql-type="char(32)" not-null="true"/>
<generator class="uuid.hex"/>
</id>
<property name="dateCreated"/>
<property name="dateModified"/>
<property name="title"/>
<property name="mediaType" type="com.vvdb.bus.metadata.MediaType"/>
<!-- associations -->
<many-to-one name="rights" column="rights_uniqueId"/>
<many-to-one name="rightsholder" column="rightsholder_uniqueId"/>
<!-- subclasses -->
<joined-subclass name="com.vvdb.bus.gallery.Gallery" table="GALLERY">
<key column="uniqueId"/>
<property name="location" type="com.vvdb.bus.gallery.Location"/>
<property name="activity" type="com.vvdb.bus.gallery.Activity"/>
<property name="category" type="com.vvdb.bus.gallery.Category"/>
<property name="thumbnailURL"/>
<property name="galleryURL"/>
<property name="thumbnail" type="org.springframework.orm.hibernate.support.BlobByteArrayType"/>
<!-- associations -->
<set name="models" table="MODEL">
<key column="gallery_uniqueId"/>
<one-to-many class="com.vvdb.bus.gallery.Model"/>
</set>
</joined-subclass>
</class>
</hibernate-mapping>
Code:
public List findByAttributes(Object[] values) throws DataAccessException {
Type[] types = {Hibernate.STRING,
Hibernate.INTEGER,
Hibernate.INTEGER,
Hibernate.INTEGER,
Hibernate.INTEGER,
Hibernate.INTEGER};
String[] paramNames = {"title", "location", "activity", "modelState", "modelType", "modelOrigin"};
StringBuffer query = new StringBuffer();
query.append("SELECT new Gallery() ");
query.append("FROM com.vvdb.bus.gallery.Gallery AS gallery ");
query.append("JOIN gallery.models AS models, ");
query.append("com.vvdb.bus.gallery.Model AS model ");
query.append("WHERE gallery.title LIKE :title AND gallery.location = :location ");
query.append("AND gallery.activity = :activity AND model.modelState = :modelState ");
query.append("AND model.modelType = :modelType AND model.modelOrigin = :modelOrigin ");
query.append("AND model IN elements(gallery.models)");
return getHibernateTemplate().findByNamedParam(query.toString(), paramNames, values, types);
}
Full stack trace of any exception that occurs:Code:
17 Nov 2004 10:09:54,046 ERROR DispatcherServlet:342 - Could not complete request
org.springframework.orm.hibernate.HibernateQueryException: ( expected before ) in select [SELECT new Gallery() FROM com.vvdb.bus.gallery.Gallery AS ga
llery JOIN gallery.models AS models, com.vvdb.bus.gallery.Model AS model WHERE gallery.title LIKE :title AND gallery.location = :location AND gallery.
activity = :activity AND model.modelState = :modelState AND model.modelType = :modelType AND model.modelOrigin = :modelOrigin AND model IN elements(g
allery.models)]; nested exception is net.sf.hibernate.QueryException: ( expected before ) in select [SELECT new Gallery() FROM com.vvdb.bus.gallery.Ga
llery AS gallery JOIN gallery.models AS models, com.vvdb.bus.gallery.Model AS model WHERE gallery.title LIKE :title AND gallery.location = :location A
ND gallery.activity = :activity AND model.modelState = :modelState AND model.modelType = :modelType AND model.modelOrigin = :modelOrigin AND model IN
elements(gallery.models)]
net.sf.hibernate.QueryException: ( expected before ) in select [SELECT new Gallery() FROM com.vvdb.bus.gallery.Gallery AS gallery JOIN gallery.models
AS models, com.vvdb.bus.gallery.Model AS model WHERE gallery.title LIKE :title AND gallery.location = :location AND gallery.activity = :activity AND m
odel.modelState = :modelState AND model.modelType = :modelType AND model.modelOrigin = :modelOrigin AND model IN elements(gallery.models)]
at net.sf.hibernate.hql.SelectParser.token(SelectParser.java:110)
at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
at net.sf.hibernate.hql.ClauseParser.end(ClauseParser.java:114)
at net.sf.hibernate.hql.PreprocessingParser.end(PreprocessingParser.java:143)
at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:30)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:294)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1562)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1533)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
at org.springframework.orm.hibernate.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:524)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:176)
at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:196)
at org.springframework.orm.hibernate.HibernateTemplate.findByNamedParam(HibernateTemplate.java:518)
at com.vvdb.db.gallery.HibernateGalleryDao.findByAttributes(HibernateGalleryDao.java:72)
at com.vvdb.bus.gallery.logic.GalleryService.doSearch(GalleryService.java:51)
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:324)
at org.springframework.aop.framework.AopProxyUtils.invokeJoinpointUsingReflection(AopProxyUtils.java:61)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:142)
at $Proxy2.doSearch(Unknown Source)
at com.vvdb.web.gallery.SearchController.onSubmit(SearchController.java:55)
at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:223)
at org.springframework.web.servlet.mvc.AbstractFormController.handleInvalidSubmit(AbstractFormController.java:412)
at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:232)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:121)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:495)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:321)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.vvdb.web.gallery.PerformanceLoggingFilter.doFilter(PerformanceLoggingFilter.java:25)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:536)
Name and version of the database you are using:
MySQL 4.1.7
The generated SQL (show_sql=true):
Debug level Hibernate log excerpt:
17 Nov 2004 10:16:54,599 INFO Environment:469 - Hibernate 2.1.6
17 Nov 2004 10:16:54,609 INFO Environment:503 - loaded properties from resource hibernate.properties: {hibernate.cglib.use_reflection_optimizer=true, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect}
17 Nov 2004 10:16:54,619 INFO Environment:529 - using CGLIB reflection optimizer
17 Nov 2004 10:16:54,739 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
17 Nov 2004 10:16:54,809 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
17 Nov 2004 10:16:55,010 INFO Binder:229 - Mapping class: com.vvdb.bus.metadata.Contributor -> CONTRIBUTOR
17 Nov 2004 10:16:55,210 DEBUG Binder:486 - Mapped property: name -> name, type: string
17 Nov 2004 10:16:55,220 DEBUG Binder:486 - Mapped property: lastname -> lastname, type: string
17 Nov 2004 10:16:55,300 INFO Binder:200 - Mapping joined-subclass: com.vvdb.bus.gallery.Model -> MODEL
17 Nov 2004 10:16:55,330 DEBUG Binder:486 - Mapped property: modelOrigin -> modelOrigin, type: com.vvdb.bus.gallery.ModelOrigin
17 Nov 2004 10:16:55,340 DEBUG Binder:486 - Mapped property: modelState -> modelState, type: com.vvdb.bus.gallery.ModelState
17 Nov 2004 10:16:55,350 DEBUG Binder:486 - Mapped property: modelType -> modelType, type: com.vvdb.bus.gallery.ModelType
17 Nov 2004 10:16:55,360 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
17 Nov 2004 10:16:55,360 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
17 Nov 2004 10:16:55,390 INFO Binder:229 - Mapping class: com.vvdb.bus.metadata.Resource -> RESOURCE
17 Nov 2004 10:16:55,390 DEBUG Binder:486 - Mapped property: uniqueId -> uniqueId, type: string
17 Nov 2004 10:16:55,410 DEBUG Binder:486 - Mapped property: dateCreated -> dateCreated, type: timestamp
17 Nov 2004 10:16:55,410 DEBUG Binder:486 - Mapped property: dateModified -> dateModified, type: timestamp
17 Nov 2004 10:16:55,420 DEBUG Binder:486 - Mapped property: title -> title, type: string
17 Nov 2004 10:16:55,420 DEBUG Binder:486 - Mapped property: mediaType -> mediaType, type: com.vvdb.bus.metadata.MediaType
17 Nov 2004 10:16:55,430 DEBUG Binder:486 - Mapped property: rights -> rights_uniqueId, type: com.vvdb.bus.rights.Rights
17 Nov 2004 10:16:55,430 DEBUG Binder:486 - Mapped property: rightsholder -> rightsholder_uniqueId, type: com.vvdb.bus.rights.Rightsholder
17 Nov 2004 10:16:55,440 INFO Binder:200 - Mapping joined-subclass: com.vvdb.bus.gallery.Gallery -> GALLERY
17 Nov 2004 10:16:55,450 DEBUG Binder:486 - Mapped property: location -> location, type: com.vvdb.bus.gallery.Location
17 Nov 2004 10:16:55,460 DEBUG Binder:486 - Mapped property: activity -> activity, type: com.vvdb.bus.gallery.Activity
17 Nov 2004 10:16:55,470 DEBUG Binder:486 - Mapped property: category -> category, type: com.vvdb.bus.gallery.Category
17 Nov 2004 10:16:55,470 DEBUG Binder:486 - Mapped property: thumbnailURL -> thumbnailURL, type: string
17 Nov 2004 10:16:55,470 DEBUG Binder:486 - Mapped property: galleryURL -> galleryURL, type: string
17 Nov 2004 10:16:55,500 DEBUG Binder:486 - Mapped property: thumbnail -> thumbnail, type: org.springframework.orm.hibernate.support.BlobByteArrayType
17 Nov 2004 10:16:55,520 DEBUG Binder:486 - Mapped property: models, type: java.util.Set
17 Nov 2004 10:16:55,530 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
17 Nov 2004 10:16:55,530 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
17 Nov 2004 10:16:55,540 INFO Binder:229 - Mapping class: com.vvdb.bus.rights.Rights -> RIGHTS
17 Nov 2004 10:16:55,540 DEBUG Binder:486 - Mapped property: dateCopyrighted -> dateCopyrighted, type: timestamp
17 Nov 2004 10:16:55,540 DEBUG Binder:486 - Mapped property: statement -> statement, type: string
17 Nov 2004 10:16:55,550 DEBUG DTDEntityResolver:20 - trying to locate
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath under net/sf/hibernate/
17 Nov 2004 10:16:55,550 DEBUG DTDEntityResolver:29 - found
http://hibernate.sourceforge.net/hibern ... ng-2.0.dtd in classpath
17 Nov 2004 10:16:55,561 INFO Binder:229 - Mapping class: com.vvdb.bus.rights.Rightsholder -> RIGHTSHOLDER
17 Nov 2004 10:16:55,561 DEBUG Binder:486 - Mapped property: uniqueId -> uniqueId, type: string
17 Nov 2004 10:16:55,561 DEBUG Binder:486 - Mapped property: name -> name, type: string
17 Nov 2004 10:16:55,571 DEBUG Binder:486 - Mapped property: contactEmail -> contactEmail, type: string
17 Nov 2004 10:16:55,571 DEBUG Binder:486 - Mapped property: contactName -> contactName, type: string
17 Nov 2004 10:16:55,571 DEBUG Binder:486 - Mapped property: contactLastname -> contactLastname, type: string
17 Nov 2004 10:16:55,571 DEBUG Binder:486 - Mapped property: bannerImage -> bannerImage, type: org.springframework.orm.hibernate.support.BlobByteArrayType
17 Nov 2004 10:16:55,581 INFO Configuration:627 - processing one-to-many association mappings
17 Nov 2004 10:16:55,581 DEBUG Binder:1353 - Second pass for collection: com.vvdb.bus.gallery.Gallery.models
17 Nov 2004 10:16:55,581 INFO Binder:1181 - Mapping collection: com.vvdb.bus.gallery.Gallery.models -> MODEL
17 Nov 2004 10:16:55,581 DEBUG Binder:1368 - Mapped collection key: gallery_uniqueId, one-to-many: com.vvdb.bus.gallery.Model
17 Nov 2004 10:16:55,581 INFO Configuration:636 - processing one-to-one association property references
17 Nov 2004 10:16:55,601 INFO Configuration:661 - processing foreign key constraints
17 Nov 2004 10:16:55,601 DEBUG Configuration:678 - resolving reference to class: com.vvdb.bus.metadata.Contributor
17 Nov 2004 10:16:55,601 DEBUG Configuration:678 - resolving reference to class: com.vvdb.bus.gallery.Gallery
17 Nov 2004 10:16:55,601 DEBUG Configuration:678 - resolving reference to class: com.vvdb.bus.rights.Rightsholder
17 Nov 2004 10:16:55,601 DEBUG Configuration:678 - resolving reference to class: com.vvdb.bus.rights.Rights
17 Nov 2004 10:16:55,601 DEBUG Configuration:678 - resolving reference to class: com.vvdb.bus.metadata.Resource
17 Nov 2004 10:16:55,651 INFO Dialect:82 - Using dialect: net.sf.hibernate.dialect.MySQLDialect
17 Nov 2004 10:16:55,651 INFO SettingsFactory:59 - Maximim outer join fetch depth: 2
17 Nov 2004 10:16:55,651 INFO SettingsFactory:63 - Use outer join fetching: true
17 Nov 2004 10:16:55,661 INFO ConnectionProviderFactory:53 - Initializing connection provider: org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
17 Nov 2004 10:16:55,681 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
17 Nov 2004 10:16:55,691 INFO SettingsFactory:103 - Use scrollable result sets: true
17 Nov 2004 10:16:55,691 INFO SettingsFactory:106 - Use JDBC3 getGeneratedKeys(): true
17 Nov 2004 10:16:55,701 INFO SettingsFactory:109 - Optimize cache for minimal puts: false
17 Nov 2004 10:16:55,701 INFO SettingsFactory:115 - echoing all SQL to stdout
17 Nov 2004 10:16:55,701 INFO SettingsFactory:118 - Query language substitutions: {}
17 Nov 2004 10:16:55,701 INFO SettingsFactory:129 - cache provider: net.sf.hibernate.cache.EhCacheProvider
17 Nov 2004 10:16:55,711 INFO Configuration:1116 - instantiating and configuring caches
17 Nov 2004 10:16:55,961 INFO SessionFactoryImpl:118 - building session factory
17 Nov 2004 10:16:55,961 DEBUG SessionFactoryImpl:124 - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=D:\Tools\j2sdk1.4.0_04\jre\bin, java.vm.version=1.4.0_04-b04, vendor-url=http://xml.apache.org/xalan-j, shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=US, sun.os.patch.level=Service Pack 1, java.vm.specification.name=Java Virtual Machine Specification, user.dir=D:\Tools\Tomcat5.0\bin, org.xml.sax.driver=org.apache.crimson.parser.XMLReaderImpl, java.runtime.version=1.4.0_04-b04, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=D:\Tools\Tomcat5.0\common\endorsed, os.arch=x86, java.io.tmpdir=D:\Tools\Tomcat5.0\temp, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, java.naming.factory.url.pkgs=org.apache.naming, os.name=Windows XP, sun.java2d.fontpath=, vendor=Apache Software Foundation, java.library.path=D:\Tools\j2sdk1.4.0_04\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\Program Files\Legato\nsr\bin;C:\WINDOWS\SYSTEM32;C:\WINDOWS;C:\WINDOWS\SYSTEM32\WBEM;C:\PROGRAM FILES\ATI TECHNOLOGIES\ATI CONTROL PANEL;C:\DMI\WIN32\BIN;C:\Program Files\Common Files\Adaptec Shared\System;C:\Compuware\OptimalJ-DE-intellij\dpj\bin;D:\Compuware\OptimalJ-DE-intellij\dpj\bin;D:\Tools\apache-ant-1.5.3-1\bin;D:\Tools\j2sdk1.4.2_05\bin;D:\IBM\Rational\common, java.specification.name=Java Platform API Specification, java.class.version=48.0, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, os.version=5.1, user.home=C:\Documents and Settings\cwnl-tdelnoij, user.timezone=Europe/Berlin, catalina.useNaming=true, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.4, catalina.home=D:\Tools\Tomcat5.0, java.class.path=D:\Tools\j2sdk1.4.0_04\lib\tools.jar;D:\Tools\Tomcat5.0\bin\bootstrap.jar, user.name=cwnl-tdelnoij, hibernate.show_sql=true, java.naming.factory.initial=org.apache.naming.java.javaURLContextFactory, package.definition=sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper., java.vm.specification.version=1.0, java.home=D:\Tools\j2sdk1.4.0_04\jre, sun.arch.data.model=32, hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect, user.language=en, java.specification.vendor=Sun Microsystems Inc., awt.toolkit=sun.awt.windows.WToolkit, hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode, java.version=1.4.0_04, java.ext.dirs=D:\Tools\j2sdk1.4.0_04\jre\lib\ext, sun.boot.class.path=D:\Tools\Tomcat5.0\common\endorsed\xercesImpl.jar;D:\Tools\Tomcat5.0\common\endorsed\xml-apis.jar;D:\Tools\j2sdk1.4.0_04\jre\lib\rt.jar;D:\Tools\j2sdk1.4.0_04\jre\lib\i18n.jar;D:\Tools\j2sdk1.4.0_04\jre\lib\sunrsasign.jar;D:\Tools\j2sdk1.4.0_04\jre\lib\jsse.jar;D:\Tools\j2sdk1.4.0_04\jre\lib\jce.jar;D:\Tools\j2sdk1.4.0_04\jre\lib\charsets.jar;D:\Tools\j2sdk1.4.0_04\jre\classes, server.loader=${catalina.home}/server/classes,${catalina.home}/server/lib/*.jar, java.vendor=Sun Microsystems Inc., catalina.base=D:\Tools\Tomcat5.0, file.separator=\, hibernate.connection.provider_class=org.springframework.orm.hibernate.LocalDataSourceConnectionProvider, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, common.loader=${catalina.home}/common/classes,${catalina.home}/common/endorsed/*.jar,${catalina.home}/common/lib/*.jar, version=2.2.D11, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, package.access=sun.,org.apache.catalina.,org.apache.coyote.,org.apache.tomcat.,org.apache.jasper.,sun.beans., sun.cpu.isalist=pentium i486 i386}
17 Nov 2004 10:16:56,392 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
17 Nov 2004 10:16:56,392 DEBUG SessionFactoryObjectFactory:76 - registered: 2c9099b20045d1f6010045d1f8be0000 (unnamed)
17 Nov 2004 10:16:56,392 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
17 Nov 2004 10:16:56,392 DEBUG SessionFactoryImpl:195 - instantiated session factory
17 Nov 2004 10:17:02,001 DEBUG SessionImpl:555 - opened session
17 Nov 2004 10:17:02,031 DEBUG SessionImpl:1527 - find: SELECT new Gallery() FROM com.vvdb.bus.gallery.Gallery AS gallery JOIN gallery.models AS models, com.vvdb.bus.gallery.Model AS model WHERE gallery.title LIKE :title AND gallery.location = :location AND gallery.activity = :activity AND model.modelState = :modelState AND model.modelType = :modelType AND model.modelOrigin = :modelOrigin AND model IN elements(gallery.models)
17 Nov 2004 10:17:02,041 DEBUG QueryParameters:112 - named parameters: {modelState=0, activity=0, modelOrigin=0, title=adore, location=0, modelType=0}
17 Nov 2004 10:17:02,061 DEBUG QueryTranslator:147 - compiling query
17 Nov 2004 10:17:02,111 DEBUG SessionImpl:573 - closing session
Login
FAQ
Search