-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 
Author Message
 Post subject: Query Probleme
PostPosted: Mon Dec 15, 2003 8:27 am 
Newbie

Joined: Wed Nov 19, 2003 5:30 am
Posts: 9
Please take a look at my query. Hibernate always throws a ClassCastException, but the generated SQL-Query is ok

the query:
Code:
from
    de.sigel.business.projektmanager.projekt.ProjektImpl as projekt
    join projekt.planKosten as planKosten
where
    planKosten.belegNr = '12345'


and the hibernate mapping:

Code:
...
        <set
            name="planKosten"
            lazy="true"
            inverse="false"
            cascade="all"
            sort="unsorted"
            where="type = 'P'"
            order-by="erfassungDatum"
        >

              <key
                  column="projektNr"
              />

              <one-to-many
                  class="de.sigel.business.projektmanager.projekt.PlanKostenImpl"
              />
        </set>
...


thx

andreas


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 15, 2003 8:31 am 
Hibernate Team
Hibernate Team

Joined: Sun Sep 14, 2003 3:54 am
Posts: 7256
Location: Paris, France
Full stacktrace and log, etc
http://www.hibernate.org/ForumMailinglists/HowToAskForHelp

_________________
Emmanuel


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 15, 2003 8:55 am 
Newbie

Joined: Wed Nov 19, 2003 5:30 am
Posts: 9
here it is:

Code:
2003-12-15 13:50:13,681 INFO  [net.sf.hibernate.cfg.Environment] Hibernate 2.1 final
2003-12-15 13:50:13,681 INFO  [net.sf.hibernate.cfg.Environment] hibernate.properties not found
2003-12-15 13:50:13,697 INFO  [net.sf.hibernate.cfg.Environment] using CGLIB reflection optimizer
2003-12-15 13:50:13,697 INFO  [net.sf.hibernate.cfg.Configuration] Mapping resource: de/sigel/business/projektmanager/projekt/ProjektImpl.hbm.xml
2003-12-15 13:50:13,806 DEBUG [net.sf.hibernate.util.DTDEntityResolver] trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
2003-12-15 13:50:13,806 DEBUG [net.sf.hibernate.util.DTDEntityResolver] found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
2003-12-15 13:50:14,072 INFO  [net.sf.hibernate.cfg.Binder] Mapping class: de.sigel.business.projektmanager.projekt.ProjektImpl -> mkz_projekt
2003-12-15 13:50:14,244 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: projektNr -> projektNr, type: long
2003-12-15 13:50:14,291 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: abschlussDatum -> abschlussDatum, type: timestamp
2003-12-15 13:50:14,291 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: beschreibung -> beschreibung, type: string
2003-12-15 13:50:14,291 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: besteller -> besteller, type: integer
2003-12-15 13:50:14,291 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: ekvNr -> ekvNr, type: integer
2003-12-15 13:50:14,291 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: erfassungDatum -> erfassungDatum, type: timestamp
2003-12-15 13:50:14,291 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: geplanterMonat -> geplanterMonat, type: integer
2003-12-15 13:50:14,291 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: geplantesJahr -> geplantesJahr, type: integer
2003-12-15 13:50:14,322 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: istKosten, type: java.util.Set
2003-12-15 13:50:14,322 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: kostenArtNr -> kostenArtNr, type: integer
2003-12-15 13:50:14,322 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: kundenNr -> kundenNr, type: integer
2003-12-15 13:50:14,322 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: lieferantenNr -> lieferantenNr, type: integer
2003-12-15 13:50:14,322 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: mgrNr -> mgrNr, type: integer
2003-12-15 13:50:14,322 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: planKosten, type: java.util.Set
2003-12-15 13:50:14,322 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: vertriebsBudget -> vertriebsBudget_id, type: de.sigel.business.projektmanager.projekt.MarketingkostenImpl
2003-12-15 13:50:14,322 INFO  [net.sf.hibernate.cfg.Configuration] Mapping resource: de/sigel/business/projektmanager/projekt/MarketingkostenImpl.hbm.xml
2003-12-15 13:50:14,322 DEBUG [net.sf.hibernate.util.DTDEntityResolver] trying to locate http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibernate/
2003-12-15 13:50:14,322 DEBUG [net.sf.hibernate.util.DTDEntityResolver] found http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd in classpath
2003-12-15 13:50:14,400 INFO  [net.sf.hibernate.cfg.Binder] Mapping class: de.sigel.business.projektmanager.projekt.MarketingkostenImpl -> mkz_marketingkosten
2003-12-15 13:50:14,400 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: id -> id, type: long
2003-12-15 13:50:14,400 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: erfassungDatum -> erfassungDatum, type: timestamp
2003-12-15 13:50:14,400 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: storno -> storno, type: boolean
2003-12-15 13:50:14,400 INFO  [net.sf.hibernate.cfg.Binder] Mapping collection: de.sigel.business.projektmanager.projekt.MarketingkostenImpl.teilBetraege -> mkz_teilbetraege
2003-12-15 13:50:14,400 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: teilBetraege, type: java.util.Map
2003-12-15 13:50:14,510 INFO  [net.sf.hibernate.cfg.Binder] Mapping subclass: de.sigel.business.projektmanager.projekt.IstKostenImpl -> mkz_marketingkosten
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: buchungsMonat -> buchungsMonat, type: integer
2003-12-15 13:50:14,510 INFO  [net.sf.hibernate.cfg.Binder] Mapping subclass: de.sigel.business.projektmanager.projekt.PlanKostenImpl -> mkz_marketingkosten
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: auftragsNr -> auftragsNr, type: integer
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: belegNr -> belegNr, type: integer
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Binder] Mapped property: beschreibung -> beschreibung, type: string
2003-12-15 13:50:14,510 INFO  [org.springframework.orm.hibernate.LocalSessionFactoryBean] Building new Hibernate SessionFactory for LocalSessionFactoryBean [org.springframework.orm.hibernate.LocalSessionFactoryBean@17753a8]
2003-12-15 13:50:14,510 INFO  [net.sf.hibernate.cfg.Configuration] processing one-to-many association mappings
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Binder] Second pass for collection: de.sigel.business.projektmanager.projekt.ProjektImpl.istKosten
2003-12-15 13:50:14,510 INFO  [net.sf.hibernate.cfg.Binder] Mapping collection: de.sigel.business.projektmanager.projekt.ProjektImpl.istKosten -> mkz_marketingkosten
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Binder] Mapped collection key: projektNr, one-to-many: de.sigel.business.projektmanager.projekt.IstKostenImpl
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Binder] Second pass for collection: de.sigel.business.projektmanager.projekt.ProjektImpl.planKosten
2003-12-15 13:50:14,510 INFO  [net.sf.hibernate.cfg.Binder] Mapping collection: de.sigel.business.projektmanager.projekt.ProjektImpl.planKosten -> mkz_marketingkosten
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Binder] Mapped collection key: projektNr, one-to-many: de.sigel.business.projektmanager.projekt.PlanKostenImpl
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Binder] Second pass for collection: de.sigel.business.projektmanager.projekt.MarketingkostenImpl.teilBetraege
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Binder] Mapped collection key: id, index: produktbereich, element: betrag, type: double
2003-12-15 13:50:14,510 INFO  [net.sf.hibernate.cfg.Configuration] processing one-to-one association property references
2003-12-15 13:50:14,510 INFO  [net.sf.hibernate.cfg.Configuration] processing foreign key constraints
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Configuration] resolving reference to class: de.sigel.business.projektmanager.projekt.MarketingkostenImpl
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Configuration] resolving reference to class: de.sigel.business.projektmanager.projekt.ProjektImpl
2003-12-15 13:50:14,510 DEBUG [net.sf.hibernate.cfg.Configuration] resolving reference to class: de.sigel.business.projektmanager.projekt.MarketingkostenImpl
2003-12-15 13:50:14,572 INFO  [net.sf.hibernate.dialect.Dialect] Using dialect: net.sf.hibernate.dialect.OracleDialect
2003-12-15 13:50:14,572 INFO  [net.sf.hibernate.cfg.SettingsFactory] Use outer join fetching: true
2003-12-15 13:50:14,588 INFO  [net.sf.hibernate.connection.ConnectionProviderFactory] Initializing connection provider: org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
2003-12-15 13:50:14,603 INFO  [net.sf.hibernate.transaction.TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
2003-12-15 13:50:15,744 INFO  [net.sf.hibernate.cfg.SettingsFactory] Use scrollable result sets: true
2003-12-15 13:50:15,744 INFO  [net.sf.hibernate.cfg.SettingsFactory] JDBC 2 max batch size: 15
2003-12-15 13:50:15,744 INFO  [net.sf.hibernate.cfg.SettingsFactory] echoing all SQL to stdout
2003-12-15 13:50:15,744 INFO  [net.sf.hibernate.cfg.SettingsFactory] Query language substitutions: {}
2003-12-15 13:50:15,744 INFO  [net.sf.hibernate.cfg.SettingsFactory] cache provider: net.sf.ehcache.hibernate.Provider
2003-12-15 13:50:15,760 INFO  [net.sf.hibernate.cfg.Configuration] instantiating and configuring caches
2003-12-15 13:50:15,994 INFO  [net.sf.hibernate.impl.SessionFactoryImpl] building session factory
2003-12-15 13:50:15,994 DEBUG [net.sf.hibernate.impl.SessionFactoryImpl] instantiating session factory with properties: {java.vendor=Sun Microsystems Inc., catalina.base=D:\jboss-3.2.2\server\default, catalina.useNaming=false, os.name=Windows XP, sun.boot.class.path=C:\j2sdk1.4.2\jre\lib\rt.jar;C:\j2sdk1.4.2\jre\lib\i18n.jar;C:\j2sdk1.4.2\jre\lib\sunrsasign.jar;C:\j2sdk1.4.2\jre\lib\jsse.jar;C:\j2sdk1.4.2\jre\lib\jce.jar;C:\j2sdk1.4.2\jre\lib\charsets.jar;C:\j2sdk1.4.2\jre\classes, sun.java2d.fontpath=, java.vm.specification.vendor=Sun Microsystems Inc., java.runtime.version=1.4.2-b28, user.name=Reitsam, jboss.bind.address=0.0.0.0, jboss.home.dir=D:\jboss-3.2.2, user.language=de, java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, sun.boot.library.path=C:\j2sdk1.4.2\jre\bin, jboss.home.url=file:/D:/jboss-3.2.2/, java.version=1.4.2, version=2.4.1, user.timezone=Europe/Berlin, jboss.server.home.dir=D:\jboss-3.2.2\server\default, sun.arch.data.model=32, hibernate.use_outer_join=true, java.endorsed.dirs=C:\j2sdk1.4.2\jre\lib\endorsed, jboss.server.home.url=file:/D:/jboss-3.2.2/server/default/, sun.cpu.isalist=pentium i486 i386, file.encoding.pkg=sun.io, file.separator=\, java.specification.name=Java Platform API Specification, hibernate.cglib.use_reflection_optimizer=true, java.class.version=48.0, jboss.server.config.url=file:/D:/jboss-3.2.2/server/default/conf/, user.country=DE, java.home=C:\j2sdk1.4.2\jre, java.vm.info=mixed mode, jboss.lib.url=file:/D:/jboss-3.2.2/lib/, os.version=5.1, path.separator=;, java.vm.version=1.4.2-b28, java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory, user.variant=, vendor-url=http://xml.apache.org/xalan-j, java.protocol.handler.pkgs=org.jboss.net.protocol, java.awt.printerjob=sun.awt.windows.WPrinterJob, vendor=Apache Software Foundation, sun.io.unicode.encoding=UnicodeLittle, awt.toolkit=sun.awt.windows.WToolkit, jboss.server.temp.dir=D:\jboss-3.2.2\server\default\tmp, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces, user.home=C:\Dokumente und Einstellungen\Reitsam, java.rmi.server.RMIClassLoaderSpi=org.jboss.system.JBossRMIClassLoader, java.specification.vendor=Sun Microsystems Inc., org.xml.sax.driver=org.apache.crimson.parser.XMLReaderImpl, java.library.path=C:\j2sdk1.4.2\bin;.;C:\WINDOWS\System32;C:\WINDOWS;C:\Programme\Oracle\bin;C:\Programme\Oracle\jre\1.1.7\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Programme\Rational\common;C:\Programme\Oracle\bin;C:\Programme\Oracle\jre\1.1.7\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Programme\Rational\common;D:\Development\tools\ant-1.5.4\bin;C:\j2sdk1.4.2\bin;D:\Development\Tools\jedit;d:\aspectj1.1\bin;D:\Development\tools\jikes-1.18\bin, java.vendor.url=http://java.sun.com/, program.name=run.cmd, java.vm.vendor=Sun Microsystems Inc., hibernate.dialect=net.sf.hibernate.dialect.OracleDialect, java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, java.class.path=;C:\j2sdk1.4.2\lib\tools.jar;D:\jboss-3.2.2\bin\\run.jar, jbossmx.loader.repository.class=org.jboss.mx.loading.UnifiedLoaderRepository3, java.vm.specification.name=Java Virtual Machine Specification, java.vm.specification.version=1.0, catalina.home=D:\jboss-3.2.2\server\default, sun.cpu.endian=little, sun.os.patch.level=, jboss.server.lib.url=file:/D:/jboss-3.2.2/server/default/lib/, hibernate.connection.provider_class=org.springframework.orm.hibernate.LocalDataSourceConnectionProvider, java.rmi.server.codebase=http://0.0.0.0:8083/, java.io.tmpdir=D:\temp\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, jboss.server.data.dir=D:\jboss-3.2.2\server\default\data, os.arch=x86, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.ext.dirs=C:\j2sdk1.4.2\jre\lib\ext, user.dir=D:\jboss-3.2.2\bin, line.separator=
, java.vm.name=Java HotSpot(TM) Client VM, jboss.server.base.dir=D:\jboss-3.2.2\server, jboss.server.base.url=file:/D:/jboss-3.2.2/server/, file.encoding=Cp1252, java.specification.version=1.4, jboss.server.name=default, hibernate.show_sql=true}
2003-12-15 13:50:16,447 DEBUG [net.sf.hibernate.impl.SessionFactoryObjectFactory] initializing class SessionFactoryObjectFactory
2003-12-15 13:50:16,447 DEBUG [net.sf.hibernate.impl.SessionFactoryObjectFactory] registered: 00e4e590f979efce00f979efd0ef0000 (unnamed)
2003-12-15 13:50:16,447 INFO  [net.sf.hibernate.impl.SessionFactoryObjectFactory] no JNDI name configured
2003-12-15 13:50:16,447 DEBUG [net.sf.hibernate.impl.SessionFactoryImpl] instantiated session factory
2003-12-15 13:50:16,447 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Bean with name 'sessionFactory' is a factory bean
2003-12-15 13:50:16,447 DEBUG [org.springframework.beans.BeanWrapperImpl] Final path in nested property value [sessionFactory] is [sessionFactory]
2003-12-15 13:50:16,447 DEBUG [org.springframework.beans.BeanWrapperImpl] About to invoke write method [public void org.springframework.orm.hibernate.HibernateAccessor.setSessionFactory(net.sf.hibernate.SessionFactory)] on object of class [org.springframework.orm.hibernate.HibernateInterceptor]
2003-12-15 13:50:16,447 DEBUG [org.springframework.beans.BeanWrapperImpl] Invoked write method [public void org.springframework.orm.hibernate.HibernateAccessor.setSessionFactory(net.sf.hibernate.SessionFactory)] ok
2003-12-15 13:50:16,447 DEBUG [org.springframework.aop.framework.ProxyFactoryBean] Adding pointcut or interceptor [org.springframework.orm.hibernate.HibernateInterceptor@19478c7] with name [hibernateInterceptor]
2003-12-15 13:50:16,463 DEBUG [org.springframework.aop.framework.ProxyFactoryBean] Configuring interceptor 'projektManagerTarget'
2003-12-15 13:50:16,463 INFO  [org.springframework.beans.factory.xml.XmlBeanFactory] Creating shared instance of singleton bean 'projektManagerTarget'
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Creating instance of bean 'projektManagerTarget' with merged definition [RootBeanDefinition for class 'de.sigel.business.projektmanager.projektmanager.ProjektManagerImpl'; org.springframework.beans.factory.support.RootBeanDefinition@fd981a]
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.CachedIntrospectionResults] Using cached introspection results for class class de.sigel.business.projektmanager.projektmanager.ProjektManagerImpl
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Resolving reference from property 'sessionFactory' in bean 'projektManagerTarget' to bean 'sessionFactory'
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Returning cached instance of singleton bean 'sessionFactory'
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Bean with name 'sessionFactory' is a factory bean
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Resolving reference from property 'projektDAO' in bean 'projektManagerTarget' to bean 'projektDAO'
2003-12-15 13:50:16,463 INFO  [org.springframework.beans.factory.xml.XmlBeanFactory] Creating shared instance of singleton bean 'projektDAO'
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Creating instance of bean 'projektDAO' with merged definition [RootBeanDefinition for class 'de.sigel.business.projektmanager.projekt.ProjektDAOImpl'; org.springframework.beans.factory.support.RootBeanDefinition@10cec16]
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.CachedIntrospectionResults] Using cached introspection results for class class de.sigel.business.projektmanager.projekt.ProjektDAOImpl
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Resolving reference from property 'sessionFactory' in bean 'projektDAO' to bean 'sessionFactory'
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Returning cached instance of singleton bean 'sessionFactory'
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Bean with name 'sessionFactory' is a factory bean
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.BeanWrapperImpl] Final path in nested property value [sessionFactory] is [sessionFactory]
2003-12-15 13:50:16,463 DEBUG [org.springframework.beans.BeanWrapperImpl] About to invoke write method [public final void org.springframework.orm.hibernate.support.HibernateDaoSupport.setSessionFactory(net.sf.hibernate.SessionFactory)] on object of class [de.sigel.business.projektmanager.projekt.ProjektDAOImpl]
2003-12-15 13:50:16,478 DEBUG [org.springframework.beans.BeanWrapperImpl] Invoked write method [public final void org.springframework.orm.hibernate.support.HibernateDaoSupport.setSessionFactory(net.sf.hibernate.SessionFactory)] ok
2003-12-15 13:50:16,478 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Calling afterPropertiesSet() on bean with name 'projektDAO'
2003-12-15 13:50:16,478 DEBUG [org.springframework.beans.BeanWrapperImpl] Final path in nested property value [sessionFactory] is [sessionFactory]
2003-12-15 13:50:16,478 DEBUG [org.springframework.beans.BeanWrapperImpl] About to invoke write method [public final void org.springframework.orm.hibernate.support.HibernateDaoSupport.setSessionFactory(net.sf.hibernate.SessionFactory)] on object of class [de.sigel.business.projektmanager.projektmanager.ProjektManagerImpl]
2003-12-15 13:50:16,478 DEBUG [org.springframework.beans.BeanWrapperImpl] Invoked write method [public final void org.springframework.orm.hibernate.support.HibernateDaoSupport.setSessionFactory(net.sf.hibernate.SessionFactory)] ok
2003-12-15 13:50:16,478 DEBUG [org.springframework.beans.BeanWrapperImpl] Final path in nested property value [projektDAO] is [projektDAO]
2003-12-15 13:50:16,478 DEBUG [org.springframework.beans.BeanWrapperImpl] About to invoke write method [public void de.sigel.business.projektmanager.projektmanager.ProjektManagerImpl.setProjektDAO(de.sigel.business.projektmanager.projekt.ProjektDAO)] on object of class [de.sigel.business.projektmanager.projektmanager.ProjektManagerImpl]
2003-12-15 13:50:16,478 DEBUG [org.springframework.beans.BeanWrapperImpl] Invoked write method [public void de.sigel.business.projektmanager.projektmanager.ProjektManagerImpl.setProjektDAO(de.sigel.business.projektmanager.projekt.ProjektDAO)] ok
2003-12-15 13:50:16,478 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Calling afterPropertiesSet() on bean with name 'projektManagerTarget'
2003-12-15 13:50:16,478 DEBUG [org.springframework.aop.framework.ProxyFactoryBean] Adding pointcut or interceptor [de.sigel.business.projektmanager.projektmanager.ProjektManagerImpl@fb1135] with name [projektManagerTarget]
2003-12-15 13:50:16,478 DEBUG [org.springframework.aop.framework.ProxyFactoryBean] Detected target when adding ProxyInterceptor to end of interceptor array
2003-12-15 13:50:16,494 INFO  [org.springframework.aop.framework.AopProxy] Creating J2SE proxy for [de.sigel.business.projektmanager.projektmanager.ProjektManagerImpl@fb1135]
2003-12-15 13:50:16,494 DEBUG [org.springframework.beans.factory.xml.XmlBeanFactory] Bean with name 'projektManager' is a factory bean
2003-12-15 13:50:16,588 DEBUG [org.springframework.orm.hibernate.SessionFactoryUtils] Opening Hibernate session
2003-12-15 13:50:16,681 DEBUG [net.sf.hibernate.impl.SessionImpl] opened session
2003-12-15 13:50:16,681 DEBUG [org.springframework.orm.hibernate.HibernateInterceptor] Using new session for Hibernate interceptor
2003-12-15 13:50:16,681 DEBUG [org.springframework.util.ThreadObjectManager] Bound value [org.springframework.orm.hibernate.SessionHolder@bed1fd] for key [net.sf.hibernate.impl.SessionFactoryImpl@1703484] to thread [Thread-8]
2003-12-15 13:50:16,681 DEBUG [org.springframework.orm.hibernate.HibernateInterceptor] Eagerly flushing Hibernate session in HibernateInterceptor
2003-12-15 13:50:16,681 DEBUG [net.sf.hibernate.impl.SessionImpl] flushing session
2003-12-15 13:50:16,681 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushing entities and processing referenced collections
2003-12-15 13:50:16,681 DEBUG [net.sf.hibernate.impl.SessionImpl] Processing unreferenced collections
2003-12-15 13:50:16,681 DEBUG [net.sf.hibernate.impl.SessionImpl] Scheduling collection removes/(re)creates/updates
2003-12-15 13:50:16,697 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
2003-12-15 13:50:16,697 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
2003-12-15 13:50:16,697 DEBUG [net.sf.hibernate.impl.SessionImpl] executing flush
2003-12-15 13:50:16,697 DEBUG [net.sf.hibernate.impl.SessionImpl] post flush
2003-12-15 13:50:16,697 DEBUG [org.springframework.util.ThreadObjectManager] Removed value [org.springframework.orm.hibernate.SessionHolder@bed1fd] for key [net.sf.hibernate.impl.SessionFactoryImpl@1703484] from thread [Thread-8]
2003-12-15 13:50:16,697 DEBUG [org.springframework.orm.hibernate.SessionFactoryUtils] Closing Hibernate session
2003-12-15 13:50:16,697 DEBUG [net.sf.hibernate.impl.SessionImpl] closing session
2003-12-15 13:50:16,697 INFO  [STDOUT] de.sigel.business.projektmanager.projektmanager.ProjektManagerImpl@fb1135
2003-12-15 13:50:16,697 DEBUG [org.springframework.orm.hibernate.SessionFactoryUtils] Opening Hibernate session
2003-12-15 13:50:16,697 DEBUG [net.sf.hibernate.impl.SessionImpl] opened session
2003-12-15 13:50:16,697 DEBUG [org.springframework.orm.hibernate.HibernateInterceptor] Using new session for Hibernate interceptor
2003-12-15 13:50:16,697 DEBUG [org.springframework.util.ThreadObjectManager] Bound value [org.springframework.orm.hibernate.SessionHolder@108ea49] for key [net.sf.hibernate.impl.SessionFactoryImpl@1703484] to thread [Thread-8]
2003-12-15 13:50:16,697 DEBUG [org.springframework.util.ThreadObjectManager] Retrieved value [org.springframework.orm.hibernate.SessionHolder@108ea49] for key [net.sf.hibernate.impl.SessionFactoryImpl@1703484] bound to thread [Thread-8]
2003-12-15 13:50:16,697 INFO  [STDOUT] Query: from de.sigel.business.projektmanager.projekt.ProjektImpl as projekt join projekt.planKosten as planKosten
2003-12-15 13:50:16,713 DEBUG [net.sf.hibernate.impl.SessionImpl] find: from de.sigel.business.projektmanager.projekt.ProjektImpl as projekt join projekt.planKosten as planKosten
2003-12-15 13:50:16,713 DEBUG [net.sf.hibernate.engine.QueryParameters] named parameters: {}
2003-12-15 13:50:16,744 DEBUG [net.sf.hibernate.hql.QueryTranslator] compiling query
2003-12-15 13:50:16,775 DEBUG [net.sf.hibernate.impl.SessionImpl] flushing session
2003-12-15 13:50:16,775 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushing entities and processing referenced collections
2003-12-15 13:50:16,775 DEBUG [net.sf.hibernate.impl.SessionImpl] Processing unreferenced collections
2003-12-15 13:50:16,775 DEBUG [net.sf.hibernate.impl.SessionImpl] Scheduling collection removes/(re)creates/updates
2003-12-15 13:50:16,775 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
2003-12-15 13:50:16,775 DEBUG [net.sf.hibernate.impl.SessionImpl] Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
2003-12-15 13:50:16,775 DEBUG [net.sf.hibernate.impl.SessionImpl] Dont need to execute flush
2003-12-15 13:50:16,775 DEBUG [net.sf.hibernate.hql.QueryTranslator] HQL: from de.sigel.business.projektmanager.projekt.ProjektImpl as projekt join projekt.planKosten as planKosten
2003-12-15 13:50:16,775 DEBUG [net.sf.hibernate.hql.QueryTranslator] SQL: select projektimp0_.projektNr as projektNr0_, plankosten1_.id as id1_, projektimp0_.abschlussDatum as abschlus2_0_, projektimp0_.beschreibung as beschrei3_0_, projektimp0_.besteller as besteller0_, projektimp0_.ekvNr as ekvNr0_, projektimp0_.erfassungDatum as erfassun6_0_, projektimp0_.geplanterMonat as geplante7_0_, projektimp0_.geplantesJahr as geplante8_0_, projektimp0_.kostenArtNr as kostenAr9_0_, projektimp0_.kundenNr as kundenNr0_, projektimp0_.lieferantenNr as liefera11_0_, projektimp0_.mgrNr as mgrNr0_, projektimp0_.vertriebsBudget_id as vertrie13_0_, plankosten1_.auftragsNr as auftragsNr1_, plankosten1_.belegNr as belegNr1_, plankosten1_.beschreibung as beschrei8_1_, plankosten1_.erfassungDatum as erfassun3_1_, plankosten1_.storno as storno1_ from mkz_projekt projektimp0_, mkz_marketingkosten plankosten1_ where projektimp0_.projektNr=plankosten1_.projektNr and plankosten1_.type = 'P'
2003-12-15 13:50:16,791 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to open: 0 open PreparedStatements, 0 open ResultSets
2003-12-15 13:50:16,791 DEBUG [net.sf.hibernate.impl.BatcherImpl] prepared statement get: select projektimp0_.projektNr as projektNr0_, plankosten1_.id as id1_, projektimp0_.abschlussDatum as abschlus2_0_, projektimp0_.beschreibung as beschrei3_0_, projektimp0_.besteller as besteller0_, projektimp0_.ekvNr as ekvNr0_, projektimp0_.erfassungDatum as erfassun6_0_, projektimp0_.geplanterMonat as geplante7_0_, projektimp0_.geplantesJahr as geplante8_0_, projektimp0_.kostenArtNr as kostenAr9_0_, projektimp0_.kundenNr as kundenNr0_, projektimp0_.lieferantenNr as liefera11_0_, projektimp0_.mgrNr as mgrNr0_, projektimp0_.vertriebsBudget_id as vertrie13_0_, plankosten1_.auftragsNr as auftragsNr1_, plankosten1_.belegNr as belegNr1_, plankosten1_.beschreibung as beschrei8_1_, plankosten1_.erfassungDatum as erfassun3_1_, plankosten1_.storno as storno1_ from mkz_projekt projektimp0_, mkz_marketingkosten plankosten1_ where projektimp0_.projektNr=plankosten1_.projektNr and plankosten1_.type = 'P'
2003-12-15 13:50:16,791 INFO  [STDOUT] Hibernate: select projektimp0_.projektNr as projektNr0_, plankosten1_.id as id1_, projektimp0_.abschlussDatum as abschlus2_0_, projektimp0_.beschreibung as beschrei3_0_, projektimp0_.besteller as besteller0_, projektimp0_.ekvNr as ekvNr0_, projektimp0_.erfassungDatum as erfassun6_0_, projektimp0_.geplanterMonat as geplante7_0_, projektimp0_.geplantesJahr as geplante8_0_, projektimp0_.kostenArtNr as kostenAr9_0_, projektimp0_.kundenNr as kundenNr0_, projektimp0_.lieferantenNr as liefera11_0_, projektimp0_.mgrNr as mgrNr0_, projektimp0_.vertriebsBudget_id as vertrie13_0_, plankosten1_.auftragsNr as auftragsNr1_, plankosten1_.belegNr as belegNr1_, plankosten1_.beschreibung as beschrei8_1_, plankosten1_.erfassungDatum as erfassun3_1_, plankosten1_.storno as storno1_ from mkz_projekt projektimp0_, mkz_marketingkosten plankosten1_ where projektimp0_.projektNr=plankosten1_.projektNr and plankosten1_.type = 'P'
2003-12-15 13:50:16,791 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
2003-12-15 13:50:16,791 DEBUG [net.sf.hibernate.impl.SessionImpl] running Session.finalize()
2003-12-15 13:50:16,853 DEBUG [net.sf.hibernate.loader.Loader] processing result set
2003-12-15 13:50:16,885 DEBUG [net.sf.hibernate.type.LongType] returning '4' as column: projektNr0_
2003-12-15 13:50:16,885 DEBUG [net.sf.hibernate.type.LongType] returning '5' as column: id1_
2003-12-15 13:50:16,885 DEBUG [net.sf.hibernate.loader.Loader] result row: 4, 5
2003-12-15 13:50:16,900 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: 4
2003-12-15 13:50:16,900 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: de.sigel.business.projektmanager.projekt.ProjektImpl#4
2003-12-15 13:50:16,900 DEBUG [net.sf.hibernate.type.TimestampType] returning null as column: abschlus2_0_
2003-12-15 13:50:16,900 DEBUG [net.sf.hibernate.type.StringType] returning 'TestProjekt' as column: beschrei3_0_
2003-12-15 13:50:16,900 DEBUG [net.sf.hibernate.type.IntegerType] returning '170' as column: besteller0_
2003-12-15 13:50:16,900 DEBUG [net.sf.hibernate.type.IntegerType] returning null as column: ekvNr0_
2003-12-15 13:50:16,900 DEBUG [net.sf.hibernate.type.TimestampType] returning '15 Dezember 2003 12:36:51' as column: erfassun6_0_
2003-12-15 13:50:16,900 DEBUG [net.sf.hibernate.type.IntegerType] returning '2' as column: geplante7_0_
2003-12-15 13:50:16,900 DEBUG [net.sf.hibernate.type.IntegerType] returning '2004' as column: geplante8_0_
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.type.IntegerType] returning '1' as column: kostenAr9_0_
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.type.IntegerType] returning '1188' as column: kundenNr0_
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.type.IntegerType] returning null as column: liefera11_0_
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.type.IntegerType] returning null as column: mgrNr0_
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.type.LongType] returning '4' as column: vertrie13_0_
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: 5
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: de.sigel.business.projektmanager.projekt.PlanKostenImpl#5
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.type.IntegerType] returning null as column: auftragsNr1_
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.type.IntegerType] returning '12345' as column: belegNr1_
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.type.StringType] returning 'TestProjekt' as column: beschrei8_1_
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.type.TimestampType] returning '15 Dezember 2003 12:41:49' as column: erfassun3_1_
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.type.BooleanType] returning 'false' as column: storno1_
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.loader.Loader] done processing result set (1 rows)
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.impl.BatcherImpl] done closing: 0 open PreparedStatements, 0 open ResultSets
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.impl.BatcherImpl] closing statement
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.loader.Loader] total objects hydrated: 2
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [de.sigel.business.projektmanager.projekt.ProjektImpl#4]
2003-12-15 13:50:16,916 DEBUG [net.sf.hibernate.impl.SessionImpl] collection not cached
2003-12-15 13:50:16,931 DEBUG [net.sf.hibernate.impl.SessionImpl] collection not cached
2003-12-15 13:50:16,931 DEBUG [net.sf.hibernate.impl.SessionImpl] loading [de.sigel.business.projektmanager.projekt.MarketingkostenImpl#4]
2003-12-15 13:50:16,931 DEBUG [net.sf.hibernate.impl.SessionImpl] attempting to resolve [de.sigel.business.projektmanager.projekt.MarketingkostenImpl#4]
2003-12-15 13:50:16,931 DEBUG [net.sf.hibernate.impl.SessionImpl] object not resolved in any cache [de.sigel.business.projektmanager.projekt.MarketingkostenImpl#4]
2003-12-15 13:50:16,931 DEBUG [net.sf.hibernate.persister.EntityPersister] Materializing entity: [de.sigel.business.projektmanager.projekt.MarketingkostenImpl#4]
2003-12-15 13:50:16,931 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to open: 0 open PreparedStatements, 0 open ResultSets
2003-12-15 13:50:16,931 DEBUG [net.sf.hibernate.impl.BatcherImpl] prepared statement get: select marketingk0_.id as id0_, marketingk0_.type as type0_, marketingk0_.erfassungDatum as erfassun3_0_, marketingk0_.storno as storno0_, marketingk0_.buchungsMonat as buchungs5_0_, marketingk0_.auftragsNr as auftragsNr0_, marketingk0_.belegNr as belegNr0_, marketingk0_.beschreibung as beschrei8_0_ from mkz_marketingkosten marketingk0_ where marketingk0_.id=?
2003-12-15 13:50:16,931 INFO  [STDOUT] Hibernate: select marketingk0_.id as id0_, marketingk0_.type as type0_, marketingk0_.erfassungDatum as erfassun3_0_, marketingk0_.storno as storno0_, marketingk0_.buchungsMonat as buchungs5_0_, marketingk0_.auftragsNr as auftragsNr0_, marketingk0_.belegNr as belegNr0_, marketingk0_.beschreibung as beschrei8_0_ from mkz_marketingkosten marketingk0_ where marketingk0_.id=?
2003-12-15 13:50:16,931 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.type.LongType] binding '4' to parameter: 1
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.loader.Loader] processing result set
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.loader.Loader] result row: 4
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.type.StringType] returning 'B' as column: type0_
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.loader.Loader] Initializing object from ResultSet: 4
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.loader.Loader] Hydrating entity: de.sigel.business.projektmanager.projekt.MarketingkostenImpl#4
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.type.TimestampType] returning '15 Dezember 2003 12:36:51' as column: erfassun3_0_
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.type.BooleanType] returning 'false' as column: storno0_
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.loader.Loader] done processing result set (1 rows)
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.BatcherImpl] done closing: 0 open PreparedStatements, 0 open ResultSets
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.BatcherImpl] closing statement
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.loader.Loader] total objects hydrated: 1
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [de.sigel.business.projektmanager.projekt.MarketingkostenImpl#4]
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.SessionImpl] collection not cached
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [de.sigel.business.projektmanager.projekt.MarketingkostenImpl#4]
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [de.sigel.business.projektmanager.projekt.ProjektImpl#4]
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.SessionImpl] resolving associations for [de.sigel.business.projektmanager.projekt.PlanKostenImpl#5]
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.SessionImpl] collection not cached
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.SessionImpl] done materializing entity [de.sigel.business.projektmanager.projekt.PlanKostenImpl#5]
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.SessionImpl] initializing non-lazy collections
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.SessionImpl] initializing collection [de.sigel.business.projektmanager.projekt.MarketingkostenImpl.teilBetraege#5]
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to open: 0 open PreparedStatements, 0 open ResultSets
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.BatcherImpl] prepared statement get: select teilbetrae0_.betrag as betrag__, teilbetrae0_.id as id__, teilbetrae0_.produktbereich as produktb3___ from mkz_teilbetraege teilbetrae0_ where teilbetrae0_.id=?
2003-12-15 13:50:16,947 INFO  [STDOUT] Hibernate: select teilbetrae0_.betrag as betrag__, teilbetrae0_.id as id__, teilbetrae0_.produktbereich as produktb3___ from mkz_teilbetraege teilbetrae0_ where teilbetrae0_.id=?
2003-12-15 13:50:16,947 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
2003-12-15 13:50:16,963 DEBUG [net.sf.hibernate.type.LongType] binding '5' to parameter: 1
2003-12-15 13:50:16,963 DEBUG [net.sf.hibernate.loader.Loader] result set contains (possibly empty) collection: [de.sigel.business.projektmanager.projekt.MarketingkostenImpl.teilBetraege#5]
2003-12-15 13:50:16,963 DEBUG [net.sf.hibernate.impl.SessionImpl] uninitialized collection: initializing
2003-12-15 13:50:16,963 DEBUG [net.sf.hibernate.loader.Loader] processing result set
2003-12-15 13:50:16,963 DEBUG [net.sf.hibernate.loader.Loader] result row:
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.type.LongType] returning '5' as column: id__
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.loader.Loader] found row of collection: [de.sigel.business.projektmanager.projekt.MarketingkostenImpl.teilBetraege#5]
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.impl.SessionImpl] reading row
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.type.DoubleType] returning '1000.0' as column: betrag__
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.type.StringType] returning 'F' as column: produktb3___
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.loader.Loader] result row:
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.type.LongType] returning '5' as column: id__
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.loader.Loader] found row of collection: [de.sigel.business.projektmanager.projekt.MarketingkostenImpl.teilBetraege#5]
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.impl.SessionImpl] reading row
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.type.DoubleType] returning '2000.0' as column: betrag__
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.type.StringType] returning 'SU' as column: produktb3___
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.loader.Loader] done processing result set (2 rows)
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.impl.BatcherImpl] done closing: 0 open PreparedStatements, 0 open ResultSets
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.impl.BatcherImpl] closing statement
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.impl.SessionImpl] 1 collections were found in result set
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.impl.SessionImpl] collection fully initialized: [de.sigel.business.projektmanager.projekt.MarketingkostenImpl.teilBetraege#5]
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.impl.SessionImpl] 1 collections initialized
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.impl.SessionImpl] initializing collection [de.sigel.business.projektmanager.projekt.MarketingkostenImpl.teilBetraege#4]
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.impl.BatcherImpl] about to open: 0 open PreparedStatements, 0 open ResultSets
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.impl.BatcherImpl] prepared statement get: select teilbetrae0_.betrag as betrag__, teilbetrae0_.id as id__, teilbetrae0_.produktbereich as produktb3___ from mkz_teilbetraege teilbetrae0_ where teilbetrae0_.id=?
2003-12-15 13:50:16,978 INFO  [STDOUT] Hibernate: select teilbetrae0_.betrag as betrag__, teilbetrae0_.id as id__, teilbetrae0_.produktbereich as produktb3___ from mkz_teilbetraege teilbetrae0_ where teilbetrae0_.id=?
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.impl.BatcherImpl] preparing statement
2003-12-15 13:50:16,978 DEBUG [net.sf.hibernate.type.LongType] binding '4' to parameter: 1
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.loader.Loader] result set contains (possibly empty) collection: [de.sigel.business.projektmanager.projekt.MarketingkostenImpl.teilBetraege#4]
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.impl.SessionImpl] uninitialized collection: initializing
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.loader.Loader] processing result set
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.loader.Loader] result row:
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.type.LongType] returning '4' as column: id__
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.loader.Loader] found row of collection: [de.sigel.business.projektmanager.projekt.MarketingkostenImpl.teilBetraege#4]
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.impl.SessionImpl] reading row
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.type.DoubleType] returning '1250.0' as column: betrag__
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.type.StringType] returning 'PW/DW' as column: produktb3___
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.loader.Loader] result row:
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.type.LongType] returning '4' as column: id__
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.loader.Loader] found row of collection: [de.sigel.business.projektmanager.projekt.MarketingkostenImpl.teilBetraege#4]
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.impl.SessionImpl] reading row
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.type.DoubleType] returning '500.0' as column: betrag__
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.type.StringType] returning 'SW' as column: produktb3___
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.loader.Loader] done processing result set (2 rows)
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.impl.BatcherImpl] done closing: 0 open PreparedStatements, 0 open ResultSets
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.impl.BatcherImpl] closing statement
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.impl.SessionImpl] 1 collections were found in result set
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.impl.SessionImpl] collection fully initialized: [de.sigel.business.projektmanager.projekt.MarketingkostenImpl.teilBetraege#4]
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.impl.SessionImpl] 1 collections initialized
2003-12-15 13:50:16,994 DEBUG [org.springframework.util.ThreadObjectManager] Removed value [org.springframework.orm.hibernate.SessionHolder@108ea49] for key [net.sf.hibernate.impl.SessionFactoryImpl@1703484] from thread [Thread-8]
2003-12-15 13:50:16,994 DEBUG [org.springframework.orm.hibernate.SessionFactoryUtils] Closing Hibernate session
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.impl.SessionImpl] closing session
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.impl.SessionImpl] disconnecting session
2003-12-15 13:50:16,994 DEBUG [net.sf.hibernate.impl.SessionImpl] transaction completion
2003-12-15 13:50:16,994 ERROR [org.jboss.ejb.plugins.LogInterceptor] RuntimeException:
java.lang.ClassCastException
   at de.sigel.business.projektmanager.projektmanager.ProjektManagerImpl.findProjekteByAttributes(ProjektManagerImpl.java:181)
   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.interceptor.AbstractReflectionInvokerInterceptor.invoke(AbstractReflectionInvokerInterceptor.java:54)
   at org.springframework.aop.framework.MethodInvocationImpl.proceed(MethodInvocationImpl.java:216)
   at org.springframework.orm.hibernate.HibernateInterceptor.invoke(HibernateInterceptor.java:81)
   at org.springframework.aop.framework.MethodInvocationImpl.proceed(MethodInvocationImpl.java:216)
   at org.springframework.aop.framework.AopProxy.invoke(AopProxy.java:102)
   at $Proxy35.findProjekteByAttributes(Unknown Source)
   at de.sigel.business.projektmanager.projektmanager.ProjektManagerBean.findProjekteByAttributes(ProjektManagerBean.java:112)
   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.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
   at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
   at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
   at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
   at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
   at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
   at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
   at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
   at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
   at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
   at org.jboss.ejb.Container.invoke(Container.java:700)
   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.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
   at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
   at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
   at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
   at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
   at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
   at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
   at $Proxy31.findProjekteByAttributes(Unknown Source)
   at de.sigel.business.projektmanager.projektmanager.ProjektManagerDeletage.findProjekteByAttributes(ProjektManagerDeletage.java:166)
   at de.sigel.presentation.projektmanagement.clientstate.ProjektAuswahlState$ProjekteSuchenTransition.doAction(ProjektAuswahlState.java:49)
   at org.arch4j.clientcontroller.StateMachine.handleExternalEvent(StateMachine.java:259)
   at org.arch4j.clientcontroller.StateMachine.handleExternalEvent(StateMachine.java:235)
   at org.arch4j.clientcontroller.StateMachine.handleEvent(StateMachine.java:189)
   at de.sigel.presentation.projektmanagement.clientview.StateMachineAction.execute(StateMachineAction.java:63)
   at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
   at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
   at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
   at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
   at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
   at java.lang.Thread.run(Thread.java:534)
2003-12-15 13:50:17,088 INFO  [STDOUT] org.arch4j.clientcontroller.StateMachineException: null; nested exception is:
   de.sigel.business.projektmanager.projektmanager.ProjektManagerException: RuntimeException; nested exception is:
   java.lang.ClassCastException
de.sigel.business.projektmanager.projektmanager.ProjektManagerException: RuntimeException; nested exception is:
   java.lang.ClassCastException
   at de.sigel.business.projektmanager.projektmanager.ProjektManagerDeletage.findProjekteByAttributes(ProjektManagerDeletage.java:168)
   at de.sigel.presentation.projektmanagement.clientstate.ProjektAuswahlState$ProjekteSuchenTransition.doAction(ProjektAuswahlState.java:49)
   at org.arch4j.clientcontroller.StateMachine.handleExternalEvent(StateMachine.java:259)
   at org.arch4j.clientcontroller.StateMachine.handleExternalEvent(StateMachine.java:235)
   at org.arch4j.clientcontroller.StateMachine.handleEvent(StateMachine.java:189)
   at de.sigel.presentation.projektmanagement.clientview.StateMachineAction.execute(StateMachineAction.java:63)
   at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
   at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
   at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
   at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:553)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
   at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
   at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
   at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
   at java.lang.Thread.run(Thread.java:534)


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 15, 2003 9:08 am 
Expert
Expert

Joined: Fri Nov 07, 2003 4:24 am
Posts: 315
Location: Cape Town, South Africa
Can we see your code, in particular the affected areas of :

ProjektManagerImpl (+- 181) and
ProjektManagerDeletage (+- 168).

... and the bean definitions (applicationcontext.xml?) for the interceptors and classes that you are proxying (related to this problem).

It appears you are using the springframework's HibernateInterceptor. Perhaps the interface that you are proxying is incorrect

Justin


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 15, 2003 9:19 am 
Newbie

Joined: Wed Nov 19, 2003 5:30 am
Posts: 9
Springframwork works very well.
The error occurs only when using a join.

ProjektManagerDelegate.java
Code:
...
   public Collection findProjekteByAttributes(Map attributes)
      throws ProjektManagerException {

      try {
         ProjektManagerRemote projektManagerRemote =
            projektManagerHome.create();
         return projektManagerRemote.findProjekteByAttributes(attributes);
      } catch (Exception e) {
         throw new ProjektManagerException(e.getMessage());
      }
   }
...


ProjektManagerImpl.java
Code:
...
   public Collection findProjekteByAttributes(Map attributes)
      throws ProjektManagerException {

      List projektDataList = new ArrayList();
      Iterator projekteIter = projektDAO.findByAttributes(attributes).iterator();
      while(projekteIter.hasNext()) {
         Projekt projekt = (Projekt) projekteIter.next();
         ProjektData projektData = ProjektDataAssembler.createProjektData(projekt);
         projektDataList.add(projektData);
      }
      return projektDataList;
   }
...


ProjektDAOImpl.java
Code:
...
   public Collection findByAttributes(Map attributes) throws ProjektDAOException {
      Session session =
         SessionFactoryUtils.getSession(getSessionFactory(), false);

      String queryString = "from " + ProjektImpl.class.getName() + " as projekt"
         + " join projekt.planKosten as planKosten";
   
      if(!attributes.isEmpty()) {
         queryString += " where ";
      }
      Iterator keyIter = attributes.keySet().iterator();
      while(keyIter.hasNext()) {
         String key = (String) keyIter.next();
         if(!"belegNr".equals(key)) {
            queryString += "projekt." + key + " = '" + attributes.get(key) + "'";
         } else {
            queryString += "planKosten.belegNr = '" + attributes.get(key) + "'";
         }

         if(keyIter.hasNext()) {
            queryString += " and ";
         }
      }
      
      try {
         return session.createQuery(queryString).list();
      } catch (ObjectNotFoundException e) {
         return new ArrayList();
      } catch (HibernateException e) {
         e.printStackTrace();
         throw new ProjektDAOException(e.getMessage());
      }
   }
...


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 15, 2003 9:38 am 
Expert
Expert

Joined: Fri Nov 07, 2003 4:24 am
Posts: 315
Location: Cape Town, South Africa
You are executing a join:
Code:

      String queryString = "from " + ProjektImpl.class.getName() + " as projekt"
         + " join projekt.planKosten as planKosten";


... and then expecting a single object back:

Code:
Iterator projekteIter = projektDAO.findByAttributes(attributes).iterator();
      while(projekteIter.hasNext()) {
         Projekt projekt = (Projekt) projekteIter.next();


You are going to get a List of Object [] back.

Justin


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 16, 2003 8:02 am 
Newbie

Joined: Wed Nov 19, 2003 5:30 am
Posts: 9
thx for all.

best regards,

andreas


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

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.