-
1. Re: Error in delete and update (unknow column)
onezzstt Feb 8, 2006 8:48 PM (in response to onezzstt)first, please see the erro out in JBoss:
02:40:32,156 INFO [Server] Starting JBoss (MX MicroKernel)... 02:40:32,156 INFO [Server] Release ID: JBoss [Zion] 4.0.3SP1 (build: CVSTag=JBoss_4_0_3_SP1 date=200510231751) 02:40:32,171 INFO [Server] Home Dir: D:\server\jboss-4.0.3SP1 02:40:32,171 INFO [Server] Home URL: file:/D:/server/jboss-4.0.3SP1/ 02:40:32,171 INFO [Server] Patch URL: null 02:40:32,171 INFO [Server] Server Name: default 02:40:32,171 INFO [Server] Server Home Dir: D:\server\jboss-4.0.3SP1\server\default 02:40:32,171 INFO [Server] Server Home URL: file:/D:/server/jboss-4.0.3SP1/server/default/ 02:40:32,171 INFO [Server] Server Temp Dir: D:\server\jboss-4.0.3SP1\server\default\tmp 02:40:32,171 INFO [Server] Root Deployment Filename: jboss-service.xml 02:40:32,781 INFO [ServerInfo] Java version: 1.5.0_06,Sun Microsystems Inc. 02:40:32,781 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM 1.5.0_06-b05,Sun Microsystems Inc. 02:40:32,781 INFO [ServerInfo] OS-System: Windows XP 5.1,x86 02:40:33,359 INFO [Server] Core system initialized 02:40:34,687 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml 02:40:37,750 INFO [EJB3Deployer] Default persistence.properties: {hibernate.transaction.flush_before_completion=false, hibernate.jndi.java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces, hibernate.transaction.auto_close_session=false, hibernate.jndi.java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, hibernate.transaction.manager_lookup_class=org.hibernate.transaction.JBossTransactionManagerLookup, hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect, hibernate.query.factory_class=org.hibernate.hql.ast.ASTQueryTranslatorFactory, hibernate.connection.datasource=java:/infonds2, hibernate.show_sql=true, hibernate.connection.release_mode=after_statement} 02:40:37,765 INFO [SocketServerInvoker] Invoker started for locator: InvokerLocator [socket://10.150.181.116:3873/?socketTimeout=360000] 02:40:39,187 INFO [AspectDeployer] Deployed AOP: file:/D:/server/jboss-4.0.3SP1/server/default/deploy/ejb3-interceptors-aop.xml 02:40:42,656 INFO [WebService] Using RMI server codebase: http://himmel:8083/ 02:40:43,062 INFO [TreeCache] setting cluster properties from xml to: UDP(ip_mcast=true;ip_ttl=64;loopback=false;mcast_addr=228.1.2.3;mcast_port=45551;mcast_recv_buf_size=80000;mcast_send_buf_size=150000;ucast_recv_buf_size=80000;ucast_send_buf_size=150000):PING(down_thread=false;num_initial_members=3;timeout=2000;up_thread=false):MERGE2(max_interval=20000;min_interval=10000):FD(down_thread=true;shun=true;up_thread=true):VERIFY_SUSPECT(down_thread=false;timeout=1500;up_thread=false):pbcast.NAKACK(down_thread=false;gc_lag=50;max_xmit_size=8192;retransmit_timeout=600,1200,2400,4800;up_thread=false):UNICAST(down_thread=false;min_threshold=10;timeout=600,1200,2400;window_size=100):pbcast.STABLE(desired_avg_gossip=20000;down_thread=false;up_thread=false):FRAG(down_thread=false;frag_size=8192;up_thread=false):pbcast.GMS(join_retry_timeout=2000;join_timeout=5000;print_local_addr=true;shun=true):pbcast.STATE_TRANSFER(down_thread=false;up_thread=false) 02:40:43,093 INFO [TreeCache] setEvictionPolicyConfig(): [config: null] 02:40:43,109 WARN [TreeCache] No transaction manager lookup class has been defined. Transactions cannot be used 02:40:43,156 INFO [TreeCache] interceptor chain is: class org.jboss.cache.interceptors.CallInterceptor class org.jboss.cache.interceptors.LockInterceptor class org.jboss.cache.interceptors.CacheLoaderInterceptor class org.jboss.cache.interceptors.UnlockInterceptor class org.jboss.cache.interceptors.ReplicationInterceptor class org.jboss.cache.interceptors.CacheStoreInterceptor 02:40:43,296 INFO [TreeCache] cache mode is REPL_SYNC 02:40:43,734 INFO [STDOUT] ------------------------------------------------------- GMS: address is himmel:3185 ------------------------------------------------------- 02:40:45,750 INFO [TreeCache] state could not be retrieved (must be first member in group) 02:40:45,750 INFO [LRUPolicy] Starting eviction policy using the provider: org.jboss.ejb3.cache.tree.StatefulEvictionPolicy 02:40:45,750 INFO [LRUPolicy] Starting a eviction timer with wake up interval of (secs) 1 02:40:45,765 INFO [TreeCache] new cache is null (maybe first member in cluster) 02:40:45,781 INFO [TreeCache] viewAccepted(): new members: [himmel:3185] 02:40:45,890 INFO [TreeCache] setting cluster properties from xml to: UDP(ip_mcast=true;ip_ttl=2;loopback=false;mcast_addr=228.1.2.3;mcast_port=43333;mcast_recv_buf_size=80000;mcast_send_buf_size=150000;ucast_recv_buf_size=80000;ucast_send_buf_size=150000):PING(down_thread=false;num_initial_members=3;timeout=2000;up_thread=false):MERGE2(max_interval=20000;min_interval=10000):FD(down_thread=true;shun=true;up_thread=true):VERIFY_SUSPECT(down_thread=false;timeout=1500;up_thread=false):pbcast.NAKACK(down_thread=false;gc_lag=50;max_xmit_size=8192;retransmit_timeout=600,1200,2400,4800;up_thread=false):UNICAST(down_thread=false;min_threshold=10;timeout=600,1200,2400;window_size=100):pbcast.STABLE(desired_avg_gossip=20000;down_thread=false;up_thread=false):FRAG(down_thread=false;frag_size=8192;up_thread=false):pbcast.GMS(join_retry_timeout=2000;join_timeout=5000;print_local_addr=true;shun=true):pbcast.STATE_TRANSFER(down_thread=false;up_thread=false) 02:40:45,906 INFO [TreeCache] setEvictionPolicyConfig(): [config: null] 02:40:49,109 INFO [MailService] Mail Service bound to java:/Mail 02:40:49,718 INFO [NamingService] Started jndi bootstrap jnpPort=1099, rmiPort=1098, backlog=50, bindAddress=/0.0.0.0, Client SocketFactory=null, Server SocketFactory=org.jboss.net.sockets.DefaultSocketFactory@ad093076 02:40:49,765 INFO [DefaultPartition] Initializing 02:40:49,859 INFO [STDOUT] ------------------------------------------------------- GMS: address is himmel:3188 (additional data: 19 bytes) ------------------------------------------------------- 02:40:51,890 INFO [DefaultPartition] Number of cluster members: 1 02:40:51,890 INFO [DefaultPartition] Other members: 0 02:40:51,890 INFO [DefaultPartition] Fetching state (will wait for 30000 milliseconds): 02:40:51,953 INFO [HANamingService] Started ha-jndi bootstrap jnpPort=1100, backlog=50, bindAddress=/0.0.0.0 02:40:51,968 INFO [DetachedHANamingService$AutomaticDiscovery] Listening on /0.0.0.0:1102, group=230.0.0.4, HA-JNDI address=10.150.181.116:1100 02:40:52,484 INFO [TreeCache] interceptor chain is: class org.jboss.cache.interceptors.CallInterceptor class org.jboss.cache.interceptors.LockInterceptor class org.jboss.cache.interceptors.UnlockInterceptor class org.jboss.cache.interceptors.ReplicationInterceptor 02:40:52,484 INFO [TreeCache] cache mode is REPL_SYNC 02:40:52,562 INFO [STDOUT] ------------------------------------------------------- GMS: address is himmel:3191 ------------------------------------------------------- 02:40:54,562 INFO [TreeCache] viewAccepted(): new members: [himmel:3191] 02:40:54,562 INFO [TreeCache] state could not be retrieved (must be first member in group) 02:40:54,562 INFO [LRUPolicy] Starting eviction policy using the provider: org.jboss.cache.eviction.LRUPolicy 02:40:54,562 INFO [LRUPolicy] Starting a eviction timer with wake up interval of (secs) 5 02:40:54,562 INFO [TreeCache] new cache is null (maybe first member in cluster) 02:40:56,187 INFO [Embedded] Catalina naming disabled 02:40:56,890 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080 02:40:56,890 INFO [Catalina] Initialization processed in 578 ms 02:40:56,906 INFO [StandardService] Starting service jboss.web 02:40:56,906 INFO [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.5 02:40:56,968 INFO [StandardHost] XML validation disabled 02:40:57,031 INFO [Catalina] Server startup in 141 ms 02:40:57,234 INFO [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=.../deploy/http-invoker.sar/invoker.war/ 02:40:57,750 INFO [WebappLoader] Dual registration of jndi stream handler: factory already defined 02:40:58,484 INFO [TomcatDeployer] deploy, ctxPath=/ws4ee, warUrl=.../tmp/deploy/tmp14825jboss-ws4ee-exp.war/ 02:40:58,703 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/ 02:40:58,921 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=.../deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/ 02:40:59,156 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../deploy/management/console-mgr.sar/web-console.war/ 02:41:01,453 INFO [TreeCache] setting cluster properties from xml to: UDP(ip_mcast=true;ip_ttl=8;loopback=false;mcast_addr=230.1.2.7;mcast_port=45577;mcast_recv_buf_size=80000;mcast_send_buf_size=150000;ucast_recv_buf_size=80000;ucast_send_buf_size=150000):PING(down_thread=false;num_initial_members=3;timeout=2000;up_thread=false):MERGE2(max_interval=20000;min_interval=10000):FD_SOCK:VERIFY_SUSPECT(down_thread=false;timeout=1500;up_thread=false):pbcast.NAKACK(down_thread=false;gc_lag=50;max_xmit_size=8192;retransmit_timeout=600,1200,2400,4800;up_thread=false):UNICAST(down_thread=false;min_threshold=10;timeout=600,1200,2400;window_size=100):pbcast.STABLE(desired_avg_gossip=20000;down_thread=false;up_thread=false):FRAG(down_thread=false;frag_size=8192;up_thread=false):pbcast.GMS(join_retry_timeout=2000;join_timeout=5000;print_local_addr=true;shun=true):pbcast.STATE_TRANSFER(down_thread=true;up_thread=true) 02:41:01,484 INFO [TreeCache] interceptor chain is: class org.jboss.cache.interceptors.CallInterceptor class org.jboss.cache.interceptors.LockInterceptor class org.jboss.cache.interceptors.UnlockInterceptor class org.jboss.cache.interceptors.ReplicationInterceptor 02:41:01,484 INFO [TreeCache] cache mode is REPL_ASYNC 02:41:01,546 INFO [STDOUT] ------------------------------------------------------- GMS: address is himmel:3195 ------------------------------------------------------- 02:41:03,578 INFO [TreeCache] state could not be retrieved (must be first member in group) 02:41:03,593 INFO [TreeCache] new cache is null (maybe first member in cluster) 02:41:03,609 INFO [TreeCache] viewAccepted(): new members: [himmel:3195] 02:41:04,171 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar 02:41:04,390 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar 02:41:04,578 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar 02:41:04,781 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar 02:41:04,968 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jms/jms-ra.rar 02:41:05,156 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/mail-ra.rar 02:41:07,375 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS' 02:41:07,843 INFO [A] Bound to JNDI name: queue/A 02:41:07,843 INFO [B] Bound to JNDI name: queue/B 02:41:07,843 INFO [C] Bound to JNDI name: queue/C 02:41:07,859 INFO [D] Bound to JNDI name: queue/D 02:41:07,859 INFO [ex] Bound to JNDI name: queue/ex 02:41:07,906 INFO [testTopic] Bound to JNDI name: topic/testTopic 02:41:07,906 INFO [securedTopic] Bound to JNDI name: topic/securedTopic 02:41:07,921 INFO [testDurableTopic] Bound to JNDI name: topic/testDurableTopic 02:41:07,921 INFO [testQueue] Bound to JNDI name: queue/testQueue 02:41:08,015 INFO [UILServerILService] JBossMQ UIL service available at : /0.0.0.0:8093 02:41:08,109 INFO [DLQ] Bound to JNDI name: queue/DLQ 02:41:08,437 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA' 02:41:08,593 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=infonds2' to JNDI name 'java:infonds2' 02:41:08,656 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/ 02:41:08,921 INFO [EARDeployer] Init J2EE application: file:/D:/server/jboss-4.0.3SP1/server/default/deploy/infonds2.ear 02:41:09,093 INFO [JaccHelper] Initialising JACC Context for deployment: infonds2.ejb3 02:41:09,453 INFO [Ejb3AnnotationHandler] found EJB3: ejbName=eu.cleversoft.infonds2.business.InfondsErrorBean, class=eu.cleversoft.infonds2.business.InfondsErrorBean, type=STATEFUL 02:41:09,843 INFO [JaccHelper] eu.cleversoft.infonds2.business.InfondsErrorBean has no @SecurityDomain - skipping JACC configuration 02:41:09,859 INFO [Ejb3AnnotationHandler] found EJB3: ejbName=eu.cleversoft.infonds2.business.InfondsLoginBean, class=eu.cleversoft.infonds2.business.InfondsLoginBean, type=STATEFUL 02:41:09,906 INFO [JaccHelper] eu.cleversoft.infonds2.business.InfondsLoginBean has no @SecurityDomain - skipping JACC configuration 02:41:09,937 INFO [Ejb3AnnotationHandler] found EJB3: ejbName=eu.cleversoft.infonds2.business.InfondsPersistenceBean, class=eu.cleversoft.infonds2.business.InfondsPersistenceBean, type=STATEFUL 02:41:10,031 INFO [JaccHelper] eu.cleversoft.infonds2.business.InfondsPersistenceBean has no @SecurityDomain - skipping JACC configuration 02:41:10,062 INFO [Ejb3AnnotationHandler] found EJB3: ejbName=eu.cleversoft.infonds2.business.InfondsQueryBean, class=eu.cleversoft.infonds2.business.InfondsQueryBean, type=STATELESS 02:41:10,140 INFO [JaccHelper] eu.cleversoft.infonds2.business.InfondsQueryBean has no @SecurityDomain - skipping JACC configuration 02:41:10,171 INFO [Ejb3AnnotationHandler] found EJB3: ejbName=eu.cleversoft.infonds2.business.InfondsSecurityBean, class=eu.cleversoft.infonds2.business.InfondsSecurityBean, type=STATEFUL 02:41:10,312 INFO [JaccHelper] eu.cleversoft.infonds2.business.InfondsSecurityBean has no @SecurityDomain - skipping JACC configuration 02:41:10,343 INFO [JaccHelper] JACC Policy Configuration for deployment has been put in service 02:41:10,359 INFO [Ejb3Deployment] EJB3 deployment time took: 1266 02:41:10,375 INFO [JaccHelper] Initialising JACC Context for deployment: infonds2.par 02:41:10,609 INFO [Ejb3Deployment] Found persistence.xml file in EJB3 jar 02:41:10,750 INFO [Environment] Hibernate 3.1 02:41:10,765 INFO [Environment] hibernate.properties not found 02:41:10,765 INFO [Environment] using CGLIB reflection optimizer 02:41:10,765 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling 02:41:11,015 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsAbrechnung 02:41:11,031 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsAbrechnungAbschluss 02:41:11,031 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsAbrechnungFreeze 02:41:11,031 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsAbrechnungProvision 02:41:11,031 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsAbrechnungSonderzahlung 02:41:11,046 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsAbrechnungStorno 02:41:11,046 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsAbrechnungStornoGrund 02:41:11,046 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsAbrechnungStornoProvision 02:41:11,046 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsAnredeStatus 02:41:11,046 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsBestandClearing 02:41:11,062 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsBestandMeldung 02:41:11,062 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsBestandMeldungDokument 02:41:11,062 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsClearingTransaktion 02:41:11,062 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsClearstreamKonto 02:41:11,062 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsContact 02:41:11,062 INFO [Ejb3Configuration] found EJB3 @Embeddable: eu.cleversoft.infonds2.entities.InfondsCurrencyRates 02:41:11,078 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsDokument 02:41:11,078 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsExcelImportLog 02:41:11,078 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsExternalId 02:41:11,078 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsExternalIdValue 02:41:11,078 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFunds 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsBenchmark 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsCarry 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsDokument 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsFactsheet 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsFactsheetInfo 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsFactsheetInfoBranche 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsFactsheetInfoHolding 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsFactsheetInfoKennzahl 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsFactsheetInfoLand 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsFactsheetInfoRanking 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsFactsheetInfoVermoegen 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsFactsheetInfoWaehrung 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsKurs 02:41:11,093 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsMV 02:41:11,109 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsMVSatz 02:41:11,109 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsPosten 02:41:11,109 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsSMV 02:41:11,109 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsFundsSMVSatz 02:41:11,109 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsGespraech 02:41:11,109 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsGutschriftVergeben 02:41:11,109 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsImage 02:41:11,109 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsIndex 02:41:11,109 INFO [Ejb3Configuration] found EJB3 @Embeddable: eu.cleversoft.infonds2.entities.InfondsIndexWert 02:41:11,109 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsKag 02:41:11,109 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsKonto 02:41:11,125 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsKunde 02:41:11,125 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsKundeExternalId 02:41:11,125 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsKundeExternalIdValue 02:41:11,125 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsLoginPermission 02:41:11,140 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsMandant 02:41:11,140 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsMandantContact 02:41:11,140 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsMandantZahlungEingang 02:41:11,140 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPartner 02:41:11,140 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPartnerBestandsDokument 02:41:11,140 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPartnerContact 02:41:11,140 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPartnerDokument 02:41:11,156 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPartnerExternalId 02:41:11,156 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPartnerExternalIdValue 02:41:11,156 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPartnerGespraech 02:41:11,156 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPartnerKonto 02:41:11,156 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPermission 02:41:11,156 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPrognose 02:41:11,156 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPrognoseBestand 02:41:11,156 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPrognoseBuchung 02:41:11,156 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsPrognoseProvision 02:41:11,171 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsRechnungTemplate 02:41:11,171 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsReportTemplate 02:41:11,171 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsSettings 02:41:11,171 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsSettlementKontoType 02:41:11,171 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsStornoGrund 02:41:11,171 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsSubmanager 02:41:11,171 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsSubmanagerAbrechnung 02:41:11,187 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsSubmanagerAbrechnungVerguetung 02:41:11,187 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsSubmanagerContact 02:41:11,187 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsUeberweisung 02:41:11,187 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsVV 02:41:11,187 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsVVDokument 02:41:11,187 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsVVGesamtBestand 02:41:11,203 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsVVProvision 02:41:11,218 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsVVProvisionAbschluss 02:41:11,218 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsVVProvisionOverwrite 02:41:11,218 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsVVVertriebsweg 02:41:11,218 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsVermittler 02:41:11,218 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsVermittlerExternalId 02:41:11,218 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsVermittlerExternalIdValue 02:41:11,218 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsZahlung 02:41:11,218 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsZahlungFunds 02:41:11,234 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.InfondsZeichnung 02:41:11,234 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.SodiaxCountry 02:41:11,234 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.SodiaxCurrency 02:41:11,234 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.SodiaxEntityChangeEntry 02:41:11,234 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.SodiaxErrorLog 02:41:11,234 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.SodiaxExchangeRate 02:41:11,234 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.SodiaxFieldChangeEntry 02:41:11,234 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.SodiaxHoliday 02:41:11,234 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.SodiaxLogin 02:41:11,234 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.SodiaxLoginLog 02:41:11,234 INFO [Ejb3Configuration] found EJB3 Entity bean: eu.cleversoft.infonds2.entities.SodiaxTransactionLog 02:41:13,953 INFO [Configuration] processing extends queue 02:41:13,953 INFO [Configuration] processing collection mappings 02:41:13,968 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.SodiaxTransactionLog.entityChanges -> sodiax_entity_change_entry 02:41:13,968 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.SodiaxLogin.permission -> infonds_login_permission 02:41:13,968 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsZahlung.fundsZahlungen -> infonds_zahlung_funds 02:41:13,968 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsVermittler.externalIdValues -> InfondsExternalIdValue 02:41:13,984 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsVV.provisionenOverwrite -> infonds_vv_provision_overwrite 02:41:13,984 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsVV.dokumente -> infonds_dokument 02:41:13,984 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsSubmanagerAbrechnung.verguetungen -> infonds_submanager_abrechnung_verguetung 02:41:13,984 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPrognose.buchungen -> infonds_prognose_buchung 02:41:13,984 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPrognose.bestaende -> infonds_prognose_bestand 02:41:13,984 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPrognose.provisionen -> infonds_prognose_provision 02:41:13,984 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPartner.clearstreamKonten -> infonds_partner_clearstream_konto 02:41:13,984 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPartner.konten -> infonds_konto 02:41:13,984 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPartner.externalIdValues -> InfondsExternalIdValue 02:41:13,984 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPartner.ansprechpartner -> infonds_contact 02:41:13,984 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsMandant.ansprechpartner -> infonds_contact 02:41:13,984 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsMandant.rechnungTemplate -> infonds_rechnung_template 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsKunde.externalIdValues -> InfondsExternalIdValue 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsFundsSMV.saetze -> infonds_funds_smv_satz 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsFundsMV.saetze -> infonds_funds_mv_satz 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsFundsFactsheet.kennzahlen -> infonds_funds_factsheet_info 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsFundsFactsheet.rankings -> infonds_funds_factsheet_info 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsFunds.factsheets -> infonds_funds_factsheet 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsFunds.submanagerVereinbarung -> infonds_funds_smv 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsFunds.benchmarks -> infonds_funds_benchmark 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsFunds.dokumente -> infonds_dokument 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsBestandMeldung.dokumente -> infonds_bestand_meldung_dokument 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsAbrechnungStorno.stornierteAbrechnungProvisionen -> infonds_abrechnung_storno_provision 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsAbrechnungStorno.stornoGruende -> infonds_abrechnung_storno_grund 02:41:14,000 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsAbrechnung.zahlungen -> infonds_zahlung 02:41:14,015 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsAbrechnung.provisionenAbschluss -> infonds_abrechnung_abschluss 02:41:14,015 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsAbrechnung.sonderzahlungen -> infonds_abrechnung_sonderzahlung 02:41:14,015 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsAbrechnung.provisionen -> infonds_abrechnung_provision 02:41:14,015 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsFunds.managerVereinbarung -> infonds_funds_mv 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsFunds.kurse -> infonds_funds_kurs 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsKunde.zeichnungen -> infonds_zeichnung 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsMandant.logos -> infonds_image 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPartner.dokumente -> infonds_dokument 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPartner.bestandsDokumente -> infonds_dokument 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPartner.gespraeche -> infonds_gespraech 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPartner.tochterPartner -> infonds_partner 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPartner.vvs -> infonds_vv 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsPartnerContact.gespraeche -> infonds_gespraech 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsSubmanager.ansprechpartner -> infonds_contact 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsVV.provisionenOverwriteAufBestand -> infonds_vv_provision_overwrite 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsVV.alleProvisionen -> infonds_vv_provision 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsVV.alleAbschlussProvisionen -> infonds_vv_provision_abschluss 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsVV.vertriebswege -> infonds_vv_vertriebsweg 02:41:14,031 INFO [CollectionBinder] Mapping collection: eu.cleversoft.infonds2.entities.InfondsVV.gesamtBestand -> infonds_vv_gesamt_bestand 02:41:14,031 INFO [Configuration] processing association property references 02:41:14,031 INFO [Configuration] processing foreign key constraints 02:41:14,843 INFO [Configuration] processing extends queue 02:41:14,843 INFO [Configuration] processing collection mappings 02:41:14,843 INFO [Configuration] processing association property references 02:41:14,843 INFO [Configuration] processing foreign key constraints 02:41:14,906 INFO [ConnectionProviderFactory] Initializing connection provider: org.hibernate.ejb.InjectedDataSourceConnectionProvider 02:41:14,921 INFO [InjectedDataSourceConnectionProvider] Using provided datasource 02:41:15,265 INFO [SettingsFactory] RDBMS: MySQL, version: 4.1.15-nt 02:41:15,265 INFO [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.1.10 ( $Date: 2005/05/19 15:52:23 $, $Revision: 1.1.2.2 $ ) 02:41:15,343 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLInnoDBDialect 02:41:15,359 INFO [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions) 02:41:15,375 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup 02:41:15,390 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup 02:41:15,390 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled 02:41:15,390 INFO [SettingsFactory] Automatic session close at end of transaction: disabled 02:41:15,390 INFO [SettingsFactory] JDBC batch size: 15 02:41:15,390 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled 02:41:15,390 INFO [SettingsFactory] Scrollable result sets: enabled 02:41:15,390 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): enabled 02:41:15,390 INFO [SettingsFactory] Connection release mode: after_statement 02:41:15,406 INFO [SettingsFactory] Maximum outer join fetch depth: 2 02:41:15,406 INFO [SettingsFactory] Default batch fetch size: 1 02:41:15,406 INFO [SettingsFactory] Generate SQL with comments: disabled 02:41:15,406 INFO [SettingsFactory] Order SQL updates by primary key: disabled 02:41:15,406 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 02:41:15,406 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory 02:41:15,406 INFO [SettingsFactory] Query language substitutions: {} 02:41:15,406 INFO [SettingsFactory] Second-level cache: enabled 02:41:15,406 INFO [SettingsFactory] Query cache: disabled 02:41:15,406 INFO [SettingsFactory] Cache provider: org.hibernate.cache.HashtableCacheProvider 02:41:15,421 INFO [SettingsFactory] Optimize cache for minimal puts: disabled 02:41:15,421 INFO [SettingsFactory] Structured second-level cache entries: disabled 02:41:15,453 INFO [SettingsFactory] Echoing all SQL to stdout 02:41:15,453 INFO [SettingsFactory] Statistics: disabled 02:41:15,453 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: enabled 02:41:15,453 INFO [SettingsFactory] Default entity-mode: POJO 02:41:15,968 INFO [SessionFactoryImpl] building session factory 02:41:23,000 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured 02:41:23,000 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces} 02:41:23,000 INFO [SessionFactoryImpl] Checking 0 named queries 02:41:23,000 INFO [Ejb3Deployment] Create EntityManager with JNDI name: infonds2 02:41:23,015 INFO [JaccHelper] JACC Policy Configuration for deployment has been put in service 02:41:23,031 INFO [Ejb3Deployment] EJB3 deployment time took: 12656 02:41:23,265 INFO [ProxyDeployer] no declared remote bindings for : eu.cleversoft.infonds2.business.InfondsErrorBean 02:41:23,281 INFO [ProxyDeployer] there is remote interfaces for eu.cleversoft.infonds2.business.InfondsErrorBean 02:41:23,281 INFO [ProxyDeployer] default remote binding has jndiName of eu.cleversoft.infonds2.remote.IInfondsError 02:41:23,515 INFO [ProxyDeployer] no declared remote bindings for : eu.cleversoft.infonds2.business.InfondsLoginBean 02:41:23,515 INFO [ProxyDeployer] there is remote interfaces for eu.cleversoft.infonds2.business.InfondsLoginBean 02:41:23,515 INFO [ProxyDeployer] default remote binding has jndiName of eu.cleversoft.infonds2.remote.IInfondsLogin 02:41:23,609 INFO [ProxyDeployer] no declared remote bindings for : eu.cleversoft.infonds2.business.InfondsPersistenceBean 02:41:23,609 INFO [ProxyDeployer] there is remote interfaces for eu.cleversoft.infonds2.business.InfondsPersistenceBean 02:41:23,609 INFO [ProxyDeployer] default remote binding has jndiName of eu.cleversoft.infonds2.remote.IInfondsPersistence 02:41:23,671 INFO [ProxyDeployer] no declared remote bindings for : eu.cleversoft.infonds2.business.InfondsQueryBean 02:41:23,671 INFO [ProxyDeployer] there is remote interfaces for eu.cleversoft.infonds2.business.InfondsQueryBean 02:41:23,671 INFO [ProxyDeployer] default remote binding has jndiName of eu.cleversoft.infonds2.remote.IInfondsQuery 02:41:23,859 INFO [ProxyDeployer] no declared remote bindings for : eu.cleversoft.infonds2.business.InfondsSecurityBean 02:41:23,859 INFO [ProxyDeployer] there is remote interfaces for eu.cleversoft.infonds2.business.InfondsSecurityBean 02:41:23,859 INFO [ProxyDeployer] default remote binding has jndiName of eu.cleversoft.infonds2.remote.IInfondsSecurity 02:41:23,890 INFO [EJB3Deployer] Deployed: file:/D:/server/jboss-4.0.3SP1/server/default/tmp/deploy/tmp14895infonds2.ear-contents/infonds2.ejb3 02:41:23,890 INFO [EJB3Deployer] Deployed: file:/D:/server/jboss-4.0.3SP1/server/default/tmp/deploy/tmp14895infonds2.ear-contents/infonds2.par 02:41:23,921 INFO [EARDeployer] Started J2EE application: file:/D:/server/jboss-4.0.3SP1/server/default/deploy/infonds2.ear 02:41:24,046 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080 02:41:24,375 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009 02:41:24,406 INFO [JkMain] Jk running ID=0 time=0/78 config=null 02:41:24,421 INFO [Server] JBoss (MX MicroKernel) [4.0.3SP1 (build: CVSTag=JBoss_4_0_3_SP1 date=200510231751)] Started in 52s:234ms 02:42:07,312 INFO [STDOUT] Hibernate: select infondsman0_.mandant_id as mandant1_42_, infondsman0_.name as name42_, infondsman0_.country_id as country23_42_, infondsman0_.konto_id as konto24_42_, infondsman0_.strasse as strasse42_, infondsman0_.plz as plz42_, infondsman0_.ort as ort42_, infondsman0_.vat_id as vat6_42_, infondsman0_.steuer_nr as steuer7_42_, infondsman0_.bemerkungen as bemerkun8_42_, infondsman0_.aktiv as aktiv42_, infondsman0_.konstenstelle as konsten10_42_, infondsman0_.provisionsaufwandskonto as provisi11_42_, infondsman0_.rechnung_contact_id as rechnung25_42_, infondsman0_.vertrag_contact_id as vertrag26_42_, infondsman0_.abrechnung_contact_id as abrechnung27_42_, infondsman0_.abrechnung2_contact_id as abrechnung28_42_, infondsman0_.default_rechnung_template_id as default29_42_, infondsman0_.gutschrift_nr_prefix as gutschrift12_42_, infondsman0_.bundesbank_firmen_nr as bundesbank13_42_, infondsman0_.bundesbank_bundesland as bundesbank14_42_, infondsman0_.registergericht as registe15_42_, infondsman0_.vorstand as vorstand42_, infondsman0_.aufsichtsrat as aufsich17_42_, infondsman0_.fusszeilen_zusatz as fusszeilen18_42_, infondsman0_.internet as internet42_, infondsman0_.logo as logo42_, infondsman0_.logo_file_name as logo21_42_, infondsman0_.logo_type as logo22_42_ from infonds_mandant infondsman0_ 02:42:14,250 INFO [STDOUT] Hibernate: select infondsman0_.mandant_id as mandant1_42_0_, infondsman0_.name as name42_0_, infondsman0_.country_id as country23_42_0_, infondsman0_.konto_id as konto24_42_0_, infondsman0_.strasse as strasse42_0_, infondsman0_.plz as plz42_0_, infondsman0_.ort as ort42_0_, infondsman0_.vat_id as vat6_42_0_, infondsman0_.steuer_nr as steuer7_42_0_, infondsman0_.bemerkungen as bemerkun8_42_0_, infondsman0_.aktiv as aktiv42_0_, infondsman0_.konstenstelle as konsten10_42_0_, infondsman0_.provisionsaufwandskonto as provisi11_42_0_, infondsman0_.rechnung_contact_id as rechnung25_42_0_, infondsman0_.vertrag_contact_id as vertrag26_42_0_, infondsman0_.abrechnung_contact_id as abrechnung27_42_0_, infondsman0_.abrechnung2_contact_id as abrechnung28_42_0_, infondsman0_.default_rechnung_template_id as default29_42_0_, infondsman0_.gutschrift_nr_prefix as gutschrift12_42_0_, infondsman0_.bundesbank_firmen_nr as bundesbank13_42_0_, infondsman0_.bundesbank_bundesland as bundesbank14_42_0_, infondsman0_.registergericht as registe15_42_0_, infondsman0_.vorstand as vorstand42_0_, infondsman0_.aufsichtsrat as aufsich17_42_0_, infondsman0_.fusszeilen_zusatz as fusszeilen18_42_0_, infondsman0_.internet as internet42_0_, infondsman0_.logo as logo42_0_, infondsman0_.logo_file_name as logo21_42_0_, infondsman0_.logo_type as logo22_42_0_ from infonds_mandant infondsman0_ where infondsman0_.mandant_id=? 02:42:14,593 INFO [STDOUT] Hibernate: select sodiaxlogi0_.pers_id as pers1_85_, sodiaxlogi0_.password as password85_, sodiaxlogi0_.initials as initials85_, sodiaxlogi0_.login as login85_, sodiaxlogi0_.access_type as access5_85_, sodiaxlogi0_.active_from as active6_85_, sodiaxlogi0_.active_until as active7_85_, sodiaxlogi0_.fontsize as fontsize85_, sodiaxlogi0_.vorname as vorname85_, sodiaxlogi0_.nachname as nachname85_, sodiaxlogi0_.anrede as anrede85_, sodiaxlogi0_.email as email85_, sodiaxlogi0_.telephone as telephone85_, sodiaxlogi0_.telefax as telefax85_, sodiaxlogi0_.phone_line as phone14_85_, sodiaxlogi0_.phone_password as phone15_85_, sodiaxlogi0_.phone_username as phone16_85_ from sodiax_login sodiaxlogi0_ where login=? and password=? 02:42:14,687 INFO [STDOUT] Hibernate: select infondslog0_.login_permission_id as col_0_0_ from infonds_login_permission infondslog0_ inner join infonds_permission infondsper1_ on infondslog0_.permission_id=infondsper1_.permission_id inner join sodiax_login sodiaxlogi2_ on infondslog0_.pers_id=sodiaxlogi2_.pers_id where sodiaxlogi2_.pers_id=? and infondsper1_.code=? and (infondslog0_.mandant_id=? or infondslog0_.mandant_id is null or infondsper1_.mandant_link=0) 02:42:14,921 INFO [STDOUT] Hibernate: select infondsman0_.mandant_id as mandant1_42_0_, infondsman0_.name as name42_0_, infondsman0_.country_id as country23_42_0_, infondsman0_.konto_id as konto24_42_0_, infondsman0_.strasse as strasse42_0_, infondsman0_.plz as plz42_0_, infondsman0_.ort as ort42_0_, infondsman0_.vat_id as vat6_42_0_, infondsman0_.steuer_nr as steuer7_42_0_, infondsman0_.bemerkungen as bemerkun8_42_0_, infondsman0_.aktiv as aktiv42_0_, infondsman0_.konstenstelle as konsten10_42_0_, infondsman0_.provisionsaufwandskonto as provisi11_42_0_, infondsman0_.rechnung_contact_id as rechnung25_42_0_, infondsman0_.vertrag_contact_id as vertrag26_42_0_, infondsman0_.abrechnung_contact_id as abrechnung27_42_0_, infondsman0_.abrechnung2_contact_id as abrechnung28_42_0_, infondsman0_.default_rechnung_template_id as default29_42_0_, infondsman0_.gutschrift_nr_prefix as gutschrift12_42_0_, infondsman0_.bundesbank_firmen_nr as bundesbank13_42_0_, infondsman0_.bundesbank_bundesland as bundesbank14_42_0_, infondsman0_.registergericht as registe15_42_0_, infondsman0_.vorstand as vorstand42_0_, infondsman0_.aufsichtsrat as aufsich17_42_0_, infondsman0_.fusszeilen_zusatz as fusszeilen18_42_0_, infondsman0_.internet as internet42_0_, infondsman0_.logo as logo42_0_, infondsman0_.logo_file_name as logo21_42_0_, infondsman0_.logo_type as logo22_42_0_ from infonds_mandant infondsman0_ where infondsman0_.mandant_id=? 02:42:16,937 INFO [STDOUT] Hibernate: select infondslog0_.login_permission_id as col_0_0_ from infonds_login_permission infondslog0_ inner join infonds_permission infondsper1_ on infondslog0_.permission_id=infondsper1_.permission_id inner join sodiax_login sodiaxlogi2_ on infondslog0_.pers_id=sodiaxlogi2_.pers_id where sodiaxlogi2_.pers_id=? and infondsper1_.code=? and (infondslog0_.mandant_id=? or infondslog0_.mandant_id is null or infondsper1_.mandant_link=0) 02:42:17,000 INFO [STDOUT] Hibernate: select sodiaxlogi0_.login_log_id as login1_86_0_, sodiaxlogi0_.mandant_id as mandant6_86_0_, sodiaxlogi0_.pers_id as pers7_86_0_, sodiaxlogi0_.login_entered as login2_86_0_, sodiaxlogi0_.login_am as login3_86_0_, sodiaxlogi0_.logout_am as logout4_86_0_, sodiaxlogi0_.ergebnis as ergebnis86_0_ from sodiax_login_log sodiaxlogi0_ where sodiaxlogi0_.login_log_id=? 02:42:20,234 INFO [STDOUT] Hibernate: select infondspar0_.partner_id as partner1_44_, infondspar0_.name as name44_, infondspar0_.country_id as country15_44_, infondspar0_.v_id as v3_44_, infondspar0_.mandant_id as mandant16_44_, infondspar0_.strasse as strasse44_, infondspar0_.plz as plz44_, infondspar0_.ort as ort44_, infondspar0_.vat_id as vat7_44_, infondspar0_.steuer_nr as steuer8_44_, infondspar0_.bemerkungen as bemerkun9_44_, infondspar0_.aktiv as aktiv44_, infondspar0_.rechnung_partner_contact_id as rechnung17_44_, infondspar0_.juristischer_name as juristi11_44_, infondspar0_.mutter_konzern_partner_id as mutter18_44_, infondspar0_.konzern_mutter as konzern12_44_, infondspar0_.full_partner as full13_44_, infondspar0_.hat_clearstream_konten as hat14_44_, infondspar0_.vertraege_partner_contact_id as vertraege19_44_, infondspar0_.default_konto_id as default20_44_, (select (p.hat_clearstream_konten or (not isnull(ck.partner_id))) from infonds_partner p left join infonds_partner_clearstream_konto ck on p.partner_id=ck.partner_id where p.partner_id=infondspar0_.partner_id limit 1) as formula6_ from infonds_partner infondspar0_ 02:42:26,921 INFO [STDOUT] Hibernate: select infondspar0_.partner_id as partner1_44_0_, infondspar0_.name as name44_0_, infondspar0_.country_id as country15_44_0_, infondspar0_.v_id as v3_44_0_, infondspar0_.mandant_id as mandant16_44_0_, infondspar0_.strasse as strasse44_0_, infondspar0_.plz as plz44_0_, infondspar0_.ort as ort44_0_, infondspar0_.vat_id as vat7_44_0_, infondspar0_.steuer_nr as steuer8_44_0_, infondspar0_.bemerkungen as bemerkun9_44_0_, infondspar0_.aktiv as aktiv44_0_, infondspar0_.rechnung_partner_contact_id as rechnung17_44_0_, infondspar0_.juristischer_name as juristi11_44_0_, infondspar0_.mutter_konzern_partner_id as mutter18_44_0_, infondspar0_.konzern_mutter as konzern12_44_0_, infondspar0_.full_partner as full13_44_0_, infondspar0_.hat_clearstream_konten as hat14_44_0_, infondspar0_.vertraege_partner_contact_id as vertraege19_44_0_, infondspar0_.default_konto_id as default20_44_0_, (select (p.hat_clearstream_konten or (not isnull(ck.partner_id))) from infonds_partner p left join infonds_partner_clearstream_konto ck on p.partner_id=ck.partner_id where p.partner_id=infondspar0_.partner_id limit 1) as formula6_0_ from infonds_partner infondspar0_ where infondspar0_.partner_id=? 02:42:27,078 INFO [STDOUT]Hibernate: select ansprechpa0_.partner_id as partner24_1_, ansprechpa0_.contact_id as contact1_1_, ansprechpa0_.contact_id as contact1_16_0_, ansprechpa0_.country_id as country21_16_0_, ansprechpa0_.position as position16_0_, ansprechpa0_.strasse as strasse16_0_, ansprechpa0_.plz as plz16_0_, ansprechpa0_.ort as ort16_0_, ansprechpa0_.bemerkungen as bemerkun7_16_0_, ansprechpa0_.vorname as vorname16_0_, ansprechpa0_.nachname as nachname16_0_, ansprechpa0_.anrede as anrede16_0_, ansprechpa0_.email as email16_0_, ansprechpa0_.titel as titel16_0_, ansprechpa0_.kuerzel as kuerzel16_0_, ansprechpa0_.zusatz as zusatz16_0_, ansprechpa0_.unterschrift as untersc14_16_0_, ansprechpa0_.tel_buero as tel15_16_0_, ansprechpa0_.tel_home as tel16_16_0_, ansprechpa0_.tel_mobil as tel17_16_0_, ansprechpa0_.fax as fax16_0_, ansprechpa0_.communication as communi19_16_0_, ansprechpa0_.own_address as own20_16_0_, ansprechpa0_.partner_id as partner24_16_0_ from infonds_contact ansprechpa0_ where ansprechpa0_.partner_id=? 02:42:27,140 WARN [JDBCExceptionReporter] SQL Error: 1054, SQLState: 42S22 02:42:27,140 ERROR [JDBCExceptionReporter] Unknown column 'ansprechpa0_.partner_id' in 'field list'02:42:27,140 ERROR [InfondsPersistenceBean] remove failed org.hibernate.exception.SQLGrammarException: could not initialize a collection: [eu.cleversoft.infonds2.entities.InfondsPartner.ansprechpartner#390] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.loadCollection(Loader.java:1923) at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:71) at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:520) at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60) at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1593) at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344) at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86) at org.hibernate.collection.PersistentSet.iterator(PersistentSet.java:138) at org.hibernate.type.CollectionType.getElementsIterator(CollectionType.java:196) at org.hibernate.type.CollectionType.getElementsIterator(CollectionType.java:188) at org.hibernate.engine.CascadingAction.getAllElementsIterator(CascadingAction.java:266) at org.hibernate.engine.CascadingAction.access$100(CascadingAction.java:21) at org.hibernate.engine.CascadingAction$2.getCascadableChildrenIterator(CascadingAction.java:52) at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:288) at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185) at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160) at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108) at org.hibernate.engine.Cascade.cascade(Cascade.java:248) at org.hibernate.engine.Cascade.cascade(Cascade.java:223) at org.hibernate.event.def.DefaultDeleteEventListener.cascadeBeforeDelete(DefaultDeleteEventListener.java:220) at org.hibernate.event.def.DefaultDeleteEventListener.deleteEntity(DefaultDeleteEventListener.java:169) at org.hibernate.event.def.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:110) at org.hibernate.impl.SessionImpl.fireDelete(SessionImpl.java:711) at org.hibernate.impl.SessionImpl.delete(SessionImpl.java:691) at org.hibernate.ejb.AbstractEntityManagerImpl.remove(AbstractEntityManagerImpl.java:150) at org.jboss.ejb3.entity.ExtendedEntityManager.remove(ExtendedEntityManager.java:126) at eu.cleversoft.infonds2.business.InfondsPersistenceBean.remove(InfondsPersistenceBean.java:43) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:109) at org.jboss.ejb3.entity.ExtendedPersistenceContextPropagationInterceptor.invoke(ExtendedPersistenceContextPropagationInterceptor.java:70) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) at org.jboss.ejb3.entity.FlushModeInterceptor.invoke(FlushModeInterceptor.java:58) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:32) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) at org.jboss.ejb3.stateful.StatefulInstanceInterceptor.invoke(StatefulInstanceInterceptor.java:133) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:66) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:134) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:61) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) at org.jboss.ejb3.entity.BeforeTxFlushModeInterceptor.invoke(BeforeTxFlushModeInterceptor.java:33) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:63) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:32) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:91) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98) at org.jboss.ejb3.stateful.StatefulContainer.dynamicInvoke(StatefulContainer.java:239) at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:107) at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:69) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:566) at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:436) at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:247) at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:299) at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:169) Caused by: java.sql.SQLException: Unknown column 'ansprechpa0_.partner_id' in 'field list' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:2978) at com.mysql.jdbc.Connection.execSQL(Connection.java:2902) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:930) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1024) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:137) at org.hibernate.loader.Loader.getResultSet(Loader.java:1676) at org.hibernate.loader.Loader.doQuery(Loader.java:662) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223) at org.hibernate.loader.Loader.loadCollection(Loader.java:1916) ... 60 more
-
2. Re: Error in delete and update (unknow column)
onezzstt Feb 8, 2006 8:52 PM (in response to onezzstt)the to be deleted EntityBean:
package eu.cleversoft.infonds2.entities; // Generated 20.01.2006 00:36:01 by Hibernate Tools 3.1.0 beta3 import java.util.HashSet; import java.util.Set; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.GeneratorType; import javax.persistence.Id; import javax.persistence.JoinColumn; import javax.persistence.ManyToOne; import javax.persistence.OneToMany; import javax.persistence.Table; import org.hibernate.annotations.Cascade; import org.hibernate.annotations.CascadeType; import org.hibernate.annotations.Formula; /** * InfondsPartner generated by hbm2java */ @Entity @Table(name="infonds_partner" ) public class InfondsPartner implements java.io.Serializable { // Fields private Integer partnerId; private Integer vid; private String name; private String juristischerName; private String strasse; private String plz; private String ort; private String vatId; private String steuerNr; private SodiaxCountry country; private String bemerkungen; private InfondsPartner mutterKonzern; private boolean hatKonzernVereinbarung; private Boolean aktiv; private Boolean fullPartner; private Boolean hatClearstreamKonten; private Boolean hatClearstreamKontenCalculated; private InfondsPartnerContact rechnungContact; private InfondsPartnerContact vertraegeContact; /** * Default Konto (Abschlussprovisionen, Overwrite und Geschlossene Fonds). * */ private InfondsKonto defaultKonto; /** * Der Mandant dem dieser VP geh?rt. D.h. nur wenn man für diesen Mandanten eingeloggt ist kann man darauf zugreifen. * */ private InfondsMandant mandant; private Set<InfondsPartnerKonto> konten = new HashSet<InfondsPartnerKonto>(0); private Set<InfondsPartnerContact> ansprechpartner = new HashSet<InfondsPartnerContact>(0); private Set<InfondsPartnerDokument> dokumente = new HashSet<InfondsPartnerDokument>(0); private Set<InfondsPartnerBestandsDokument> bestandsDokumente = new HashSet<InfondsPartnerBestandsDokument>(0); private Set<InfondsPartnerGespraech> gespraeche = new HashSet<InfondsPartnerGespraech>(0); private Set<InfondsPartner> tochterPartner = new HashSet<InfondsPartner>(0); private Set<InfondsVV> vvs = new HashSet<InfondsVV>(0); private Set<InfondsClearstreamKonto> clearstreamKonten = new HashSet<InfondsClearstreamKonto>(0); private Set<InfondsPartnerExternalIdValue> externalIdValues = new HashSet<InfondsPartnerExternalIdValue>(0); // Constructors /** default constructor */ public InfondsPartner() { } /** minimal constructor */ public InfondsPartner(String name, String juristischerName, Boolean aktiv, Boolean fullPartner, Boolean hatClearstreamKonten) { this.name = name; this.juristischerName = juristischerName; this.aktiv = aktiv; this.fullPartner = fullPartner; this.hatClearstreamKonten = hatClearstreamKonten; } /** full constructor */ public InfondsPartner(Integer vid, String name, String juristischerName, String strasse, String plz, String ort, String vatId, String steuerNr, SodiaxCountry country, String bemerkungen, InfondsPartner mutterKonzern, boolean hatKonzernVereinbarung, Boolean aktiv, Boolean fullPartner, Boolean hatClearstreamKonten, Boolean hatClearstreamKontenCalculated, InfondsPartnerContact rechnungContact, InfondsPartnerContact vertraegeContact, InfondsKonto defaultKonto, InfondsMandant mandant, Set<InfondsPartnerKonto> konten, Set<InfondsPartnerContact> ansprechpartner, Set<InfondsPartnerDokument> dokumente, Set<InfondsPartnerBestandsDokument> bestandsDokumente, Set<InfondsPartnerGespraech> gespraeche, Set<InfondsPartner> tochterPartner, Set<InfondsVV> vvs, Set<InfondsClearstreamKonto> clearstreamKonten, Set<InfondsPartnerExternalIdValue> externalIdValues) { this.vid = vid; this.name = name; this.juristischerName = juristischerName; this.strasse = strasse; this.plz = plz; this.ort = ort; this.vatId = vatId; this.steuerNr = steuerNr; this.country = country; this.bemerkungen = bemerkungen; this.mutterKonzern = mutterKonzern; this.hatKonzernVereinbarung = hatKonzernVereinbarung; this.aktiv = aktiv; this.fullPartner = fullPartner; this.hatClearstreamKonten = hatClearstreamKonten; this.hatClearstreamKontenCalculated = hatClearstreamKontenCalculated; this.rechnungContact = rechnungContact; this.vertraegeContact = vertraegeContact; this.defaultKonto = defaultKonto; this.mandant = mandant; this.konten = konten; this.ansprechpartner = ansprechpartner; this.dokumente = dokumente; this.bestandsDokumente = bestandsDokumente; this.gespraeche = gespraeche; this.tochterPartner = tochterPartner; this.vvs = vvs; this.clearstreamKonten = clearstreamKonten; this.externalIdValues = externalIdValues; } // Property accessors @Id( generate=GeneratorType.AUTO) @Column(name="partner_id", unique=false, nullable=false, insertable=true, updatable=true) public Integer getPartnerId() { return this.partnerId; } public void setPartnerId(Integer partnerId) { this.partnerId = partnerId; } @Column(name="v_id", unique=false, nullable=true, insertable=true, updatable=true) public Integer getVid() { return this.vid; } public void setVid(Integer vid) { this.vid = vid; } @Column(name="name", unique=false, nullable=false, insertable=true, updatable=true, length=50) public String getName() { return this.name; } public void setName(String name) { this.name = name; } @Column(name="juristischer_name", unique=false, nullable=false, insertable=true, updatable=true, length=50) public String getJuristischerName() { return this.juristischerName; } public void setJuristischerName(String juristischerName) { this.juristischerName = juristischerName; } @Column(name="strasse", unique=false, nullable=true, insertable=true, updatable=true, length=100) public String getStrasse() { return this.strasse; } public void setStrasse(String strasse) { this.strasse = strasse; } @Column(name="plz", unique=false, nullable=true, insertable=true, updatable=true, length=5) public String getPlz() { return this.plz; } public void setPlz(String plz) { this.plz = plz; } @Column(name="ort", unique=false, nullable=true, insertable=true, updatable=true, length=100) public String getOrt() { return this.ort; } public void setOrt(String ort) { this.ort = ort; } @Column(name="vat_id", unique=false, nullable=true, insertable=true, updatable=true, length=14) public String getVatId() { return this.vatId; } public void setVatId(String vatId) { this.vatId = vatId; } @Column(name="steuer_nr", unique=false, nullable=true, insertable=true, updatable=true, length=100) public String getSteuerNr() { return this.steuerNr; } public void setSteuerNr(String steuerNr) { this.steuerNr = steuerNr; } @ManyToOne(cascade={}, fetch=FetchType.LAZY) @JoinColumn(name="country_id", unique=false, nullable=true, insertable=true, updatable=true) public SodiaxCountry getCountry() { return this.country; } public void setCountry(SodiaxCountry country) { this.country = country; } @Column(name="bemerkungen", unique=false, nullable=true, insertable=true, updatable=true) public String getBemerkungen() { return this.bemerkungen; } public void setBemerkungen(String bemerkungen) { this.bemerkungen = bemerkungen; } @ManyToOne(cascade={}, fetch=FetchType.LAZY) @JoinColumn(name="mutter_konzern_partner_id", unique=false, nullable=true, insertable=true, updatable=true) public InfondsPartner getMutterKonzern() { return this.mutterKonzern; } public void setMutterKonzern(InfondsPartner mutterKonzern) { this.mutterKonzern = mutterKonzern; } @Column(name="konzern_mutter", unique=false, nullable=true, insertable=true, updatable=true) public boolean isHatKonzernVereinbarung() { return this.hatKonzernVereinbarung; } public void setHatKonzernVereinbarung(boolean hatKonzernVereinbarung) { this.hatKonzernVereinbarung = hatKonzernVereinbarung; } @Column(name="aktiv", unique=false, nullable=false, insertable=true, updatable=true) public Boolean getAktiv() { return this.aktiv; } public void setAktiv(Boolean aktiv) { this.aktiv = aktiv; } @Column(name="full_partner", unique=false, nullable=false, insertable=true, updatable=true) public Boolean getFullPartner() { return this.fullPartner; } public void setFullPartner(Boolean fullPartner) { this.fullPartner = fullPartner; } @Column(name="hat_clearstream_konten", unique=false, nullable=false, insertable=true, updatable=true) public Boolean getHatClearstreamKonten() { return this.hatClearstreamKonten; } public void setHatClearstreamKonten(Boolean hatClearstreamKonten) { this.hatClearstreamKonten = hatClearstreamKonten; } @Formula(value="(select (p.hat_clearstream_konten or (not isnull(ck.partner_id))) from infonds_partner p left join infonds_partner_clearstream_konto ck on p.partner_id=ck.partner_id where p.partner_id=partner_id limit 1)") public Boolean getHatClearstreamKontenCalculated() { return this.hatClearstreamKontenCalculated; } public void setHatClearstreamKontenCalculated(Boolean hatClearstreamKontenCalculated) { this.hatClearstreamKontenCalculated = hatClearstreamKontenCalculated; } @ManyToOne(cascade={}, fetch=FetchType.LAZY) @JoinColumn(name="rechnung_partner_contact_id", unique=false, nullable=true, insertable=true, updatable=true) public InfondsPartnerContact getRechnungContact() { return this.rechnungContact; } public void setRechnungContact(InfondsPartnerContact rechnungContact) { this.rechnungContact = rechnungContact; } @ManyToOne(cascade={}, fetch=FetchType.LAZY) @JoinColumn(name="vertraege_partner_contact_id", unique=false, nullable=true, insertable=true, updatable=true) public InfondsPartnerContact getVertraegeContact() { return this.vertraegeContact; } public void setVertraegeContact(InfondsPartnerContact vertraegeContact) { this.vertraegeContact = vertraegeContact; } /** * * Default Konto (Abschlussprovisionen, Overwrite und Geschlossene Fonds). * */ @ManyToOne(cascade={}, fetch=FetchType.LAZY) @JoinColumn(name="default_konto_id", unique=false, nullable=true, insertable=true, updatable=true) public InfondsKonto getDefaultKonto() { return this.defaultKonto; } public void setDefaultKonto(InfondsKonto defaultKonto) { this.defaultKonto = defaultKonto; } /** * * Der Mandant dem dieser VP geh?rt. D.h. nur wenn man für diesen Mandanten eingeloggt ist kann man darauf zugreifen. * */ @ManyToOne(cascade={}, fetch=FetchType.LAZY) @JoinColumn(name="mandant_id", unique=false, nullable=true, insertable=true, updatable=true) public InfondsMandant getMandant() { return this.mandant; } public void setMandant(InfondsMandant mandant) { this.mandant = mandant; } @OneToMany(cascade={}, fetch=FetchType.LAZY) @JoinColumn(name="partner_id", unique=false, nullable=true, insertable=true, updatable=false) @Cascade( {CascadeType.ALL, CascadeType.DELETE_ORPHAN} ) public Set<InfondsPartnerKonto> getKonten() { return this.konten; } public void setKonten(Set<InfondsPartnerKonto> konten) { this.konten = konten; } @OneToMany(cascade={}, fetch=FetchType.LAZY) @JoinColumn(name="partner_id", unique=false, nullable=true, insertable=true, updatable=false) @Cascade( {CascadeType.ALL, CascadeType.DELETE_ORPHAN} ) public Set<InfondsPartnerContact> getAnsprechpartner() { return this.ansprechpartner; } public void setAnsprechpartner(Set<InfondsPartnerContact> ansprechpartner) { this.ansprechpartner = ansprechpartner; } @OneToMany(cascade={}, fetch=FetchType.LAZY, mappedBy="partner") @Cascade( {CascadeType.ALL, CascadeType.DELETE_ORPHAN} ) public Set<InfondsPartnerDokument> getDokumente() { return this.dokumente; } public void setDokumente(Set<InfondsPartnerDokument> dokumente) { this.dokumente = dokumente; } @OneToMany(cascade={}, fetch=FetchType.LAZY, mappedBy="partner") public Set<InfondsPartnerBestandsDokument> getBestandsDokumente() { return this.bestandsDokumente; } public void setBestandsDokumente(Set<InfondsPartnerBestandsDokument> bestandsDokumente) { this.bestandsDokumente = bestandsDokumente; } @OneToMany(cascade={}, fetch=FetchType.LAZY, mappedBy="partner") @Cascade( {CascadeType.ALL, CascadeType.DELETE_ORPHAN} ) public Set<InfondsPartnerGespraech> getGespraeche() { return this.gespraeche; } public void setGespraeche(Set<InfondsPartnerGespraech> gespraeche) { this.gespraeche = gespraeche; } @OneToMany(cascade={}, fetch=FetchType.LAZY, mappedBy="mutterKonzern") public Set<InfondsPartner> getTochterPartner() { return this.tochterPartner; } public void setTochterPartner(Set<InfondsPartner> tochterPartner) { this.tochterPartner = tochterPartner; } @OneToMany(cascade={}, fetch=FetchType.LAZY, mappedBy="partner") public Set<InfondsVV> getVvs() { return this.vvs; } public void setVvs(Set<InfondsVV> vvs) { this.vvs = vvs; } @OneToMany(cascade={}, fetch=FetchType.LAZY) @JoinColumn(name="partner_id", unique=false, nullable=true, insertable=true, updatable=false) @Cascade( {CascadeType.ALL, CascadeType.DELETE_ORPHAN} ) public Set<InfondsClearstreamKonto> getClearstreamKonten() { return this.clearstreamKonten; } public void setClearstreamKonten(Set<InfondsClearstreamKonto> clearstreamKonten) { this.clearstreamKonten = clearstreamKonten; } @OneToMany(cascade={}, fetch=FetchType.LAZY) @JoinColumn(name="partner_id", unique=false, nullable=true, insertable=true, updatable=false) @Cascade( {CascadeType.ALL, CascadeType.DELETE_ORPHAN} ) public Set<InfondsPartnerExternalIdValue> getExternalIdValues() { return this.externalIdValues; } public void setExternalIdValues(Set<InfondsPartnerExternalIdValue> externalIdValues) { this.externalIdValues = externalIdValues; } }
-
3. Re: Error in delete and update (unknow column)
onezzstt Feb 8, 2006 8:57 PM (in response to onezzstt)the EntityBean is auto-created with hibernate code generation:
<hbm2java jdk5="true" ejb3="true"></hbm2java>
the hbm.xml file:<?xml version="1.0"?> <!DOCTYPE hibernate-mapping SYSTEM "file:D:/eclipse/eclipse_3.1.1_jboss_dali/workspace/infonds_hibernate/db/dtd/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="eu.cleversoft.infonds.ejb3.entities"> <class name="InfondsPartner" table="infonds_partner"> <meta attribute="implement-equals">true</meta> <id name="partnerId" column="partner_id" type="java.lang.Integer"> <generator class="native"/> </id> <property name="vid" column="v_id" type="java.lang.Integer"/> <property name="name" column="name" type="java.lang.String" length="50" not-null="true"/> <property name="juristischerName" column="juristischer_name" type="java.lang.String" length="50" not-null="true"/> <property name="strasse" column="strasse" type="java.lang.String" length="100"/> <property name="plz" column="plz" type="java.lang.String" length="5"/> <property name="ort" column="ort" type="java.lang.String" length="100"/> <property name="vatId" column="vat_id" type="java.lang.String" length="14"/> <property name="steuerNr" column="steuer_nr" type="java.lang.String" length="100"/> <many-to-one cascade="none" name="country" class="eu.cleversoft.infonds.ejb3.entities.SodiaxCountry" column="country_id"/> <property name="bemerkungen" column="bemerkungen" type="text"/> <many-to-one cascade="none" name="mutterKonzern" class="eu.cleversoft.infonds.ejb3.entities.InfondsPartner" column="mutter_konzern_partner_id"/> <property name="hatKonzernVereinbarung" column="konzern_mutter" type="boolean"/> <property name="aktiv" column="aktiv" type="java.lang.Boolean" not-null="true"/> <property name="fullPartner" column="full_partner" type="java.lang.Boolean" not-null="true"/> <property name="hatClearstreamKonten" column="hat_clearstream_konten" type="java.lang.Boolean" not-null="true"/> <property update="false" insert="false" name="hatClearstreamKontenCalculated" access="field" type="java.lang.Boolean" formula="(select (p.hat_clearstream_konten or (not isnull(ck.partner_id))) from infonds_partner p left join infonds_partner_clearstream_konto ck on p.partner_id=ck.partner_id where p.partner_id=partner_id limit 1)" /> <many-to-one name="rechnungContact" class="eu.cleversoft.infonds.ejb3.entities.InfondsPartnerContact"> <column name="rechnung_partner_contact_id"/> </many-to-one> <many-to-one name="vertraegeContact" class="eu.cleversoft.infonds.ejb3.entities.InfondsPartnerContact"> <column name="vertraege_partner_contact_id"/> </many-to-one> <many-to-one name="defaultKonto" class="eu.cleversoft.infonds.ejb3.entities.InfondsKonto"> <meta attribute="field-description"> Default Konto (Abschlussprovisionen, Overwrite und Geschlossene Fonds). </meta> <column name="default_konto_id"/> </many-to-one> <many-to-one cascade="none" name="mandant" class="eu.cleversoft.infonds.ejb3.entities.InfondsMandant"> <meta attribute="field-description"> Der Mandant dem dieser VP geh?rt. D.h. nur wenn man für diesen Mandanten eingeloggt ist kann man darauf zugreifen. </meta> <column name="mandant_id"/> </many-to-one> <set name="konten" table="infonds_partner_konto" inverse="false" lazy="true" cascade="all-delete-orphan"> <key column="partner_id"/> <one-to-many class="eu.cleversoft.infonds.ejb3.entities.InfondsPartnerKonto"/> </set> <set name="ansprechpartner" table="infonds_partner_contact" inverse="false" lazy="true" cascade="all-delete-orphan"> <key column="partner_id"/> <one-to-many class="eu.cleversoft.infonds.ejb3.entities.InfondsPartnerContact"/> </set> <set name="dokumente" table="infonds_partner_dokument" inverse="true" lazy="true" cascade="all-delete-orphan"> <key column="partner_id"/> <one-to-many class="eu.cleversoft.infonds.ejb3.entities.InfondsPartnerDokument"/> </set> <set name="bestandsDokumente" table="infonds_partner_bestands_dokument" inverse="true" lazy="true"> <key column="partner_id"/> <one-to-many class="eu.cleversoft.infonds.ejb3.entities.InfondsPartnerBestandsDokument"/> </set> <set name="gespraeche" table="infonds_partner_gespraech" cascade="all-delete-orphan" inverse="true"> <key column="partner_id"/> <one-to-many class="eu.cleversoft.infonds.ejb3.entities.InfondsPartnerGespraech"/> </set> <set name="tochterPartner" inverse="true" cascade="none"> <key column="mutter_konzern_partner_id"/> <one-to-many class="eu.cleversoft.infonds.ejb3.entities.InfondsPartner"/> </set> <set name="vvs" inverse="true" table="infonds_vv" cascade="none"> <key column="partner_id"/> <one-to-many class="eu.cleversoft.infonds.ejb3.entities.InfondsVV"/> </set> <set name="clearstreamKonten" cascade="all-delete-orphan"> <key column="partner_id"/> <one-to-many class="eu.cleversoft.infonds.ejb3.entities.InfondsClearstreamKonto"/> </set> <set name="externalIdValues" table="infonds_partner_external_id" cascade="all-delete-orphan"> <key column="partner_id"/> <one-to-many class="eu.cleversoft.infonds.ejb3.entities.InfondsPartnerExternalIdValue"/> </set> <filter name="mandantFilter" condition="mandant_id=:mandantId"/> </class> </hibernate-mapping>
-
4. Re: Error in delete and update (unknow column)
onezzstt Feb 8, 2006 9:06 PM (in response to onezzstt)If i try to delete this EntityBean(or update e.g. my easy testing by setName("...")), the auto created SQL in JBossAS Hibernate is not correct. It creats always a unknow column(see up the JBoss Error Out), which is neither in the EntityBean nor in the database table.
Thanks alot for your feedbacks!
Juan -
5. Re: Error in delete and update (unknow column)
onezzstt Feb 8, 2006 9:11 PM (in response to onezzstt)supplement:
This problem happens not only in this EntityBean but also in some other EntityBeans. -
6. Re: Error in delete and update (unknow column)
epbernard Feb 9, 2006 3:48 PM (in response to onezzstt)There is no way we can help you on a such huge log file and meterial. You'll need to simplify your code until you isolate the issue
-
7. Re: Error in delete and update (unknow column)
onezzstt Feb 10, 2006 8:49 AM (in response to onezzstt)I get it:
With hibernate code generation "hbm2java(ejb3)" creates codes like:@OneToMany(cascade={}, fetch=FetchType.LAZY) @JoinColumn(name="funds_id", unique=false, nullable=true, insertable=true, updatable=false) //@Cascade( {CascadeType.ALL, CascadeType.DELETE_ORPHAN} ) public Set<InfondsFundsBenchmark> getBenchmarks() { return this.benchmarks; } public void setBenchmarks(Set<InfondsFundsBenchmark> benchmarks) { this.benchmarks = benchmarks; } @OneToMany(cascade={}, fetch=FetchType.LAZY) @JoinColumn(name="funds_id", unique=false, nullable=true, insertable=true, updatable=false) //@Cascade( {CascadeType.ALL, CascadeType.DELETE_ORPHAN} ) public Set<InfondsFundsDokument> getDokumente() { return this.dokumente; }
the red-color texts are auto-created "hibernate annotations", and the other annotations are auto-created "ejb3 annotations". So i discomment the auto-created "hibernate annotations", and it runs now without problem with deleting and updating.
Is this a bug of hbm2java or is it something -
8. Re: Error in delete and update (unknow column)
onezzstt Feb 10, 2006 9:06 AM (in response to onezzstt)Is it a bug of hbm2java or is it my mistake? Can man use both ejb3 annotation and hibernate annotation together in a method? If jboss supports it, what should i do in jboss?
Thanks alot! -
9. Re: Error in delete and update (unknow column)
epbernard Feb 12, 2006 9:45 AM (in response to onezzstt)it creates a commented @Cascade?
Then yes that's a bug.
please report http://opensource2.atlassian.com/projects/hibernate/secure/Dashboard.jspa -
10. Re: Error in delete and update (unknow column)
onezzstt Feb 12, 2006 10:27 AM (in response to onezzstt)the link of my bug's report:
http://opensource2.atlassian.com/projects/hibernate/browse/HBX-586 -
11. Re: Error in delete and update (unknow column)
onezzstt Feb 12, 2006 10:29 AM (in response to onezzstt)the link of my bug's report:
http://opensource2.atlassian.com/projects/hibernate/browse/HBX-586