I have retried it to check if the problem still show up. (I had a doubt that the problem always occur a each server launch). so : yes it show up again.
As it is a jdbc mysql problem : I use the latest version of Hibernate, ie 3.2.4sp1. see this post : http://www.jboss.com/index.html?module=bb&op=viewtopic&t=111530 And also : here some more information about the error, that may help you. The "caused by" second exception is: 18:32:28,796 WARN [ServiceController] Problem starting service portal.wsrp:service=ConsumerRegistry | org.hibernate.exception.GenericJDBCException: could not execute query using iterate | at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) | .... | .... | Caused by: java.sql.SQLException: Invalid value for getLong() - 'self' | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) | at com.mysql.jdbc.ResultSet.getLong(ResultSet.java:2768) | at com.mysql.jdbc.ResultSet.getLong(ResultSet.java:2666) | at com.mysql.jdbc.ResultSet.getLong(ResultSet.java:2791) | at org.jboss.resource.adapter.jdbc.WrappedResultSet.getLong(WrappedResultSet.java:718) | at org.hibernate.type.LongType.get(LongType.java:28) | at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163) | at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:154) | at org.hibernate.type.ManyToOneType.hydrate(ManyToOneType.java:103) | at org.hibernate.type.EntityType.nullSafeGet(EntityType.java:204) | at org.hibernate.impl.IteratorImpl.postNext(IteratorImpl.java:93) | at org.hibernate.impl.IteratorImpl.<init>(IteratorImpl.java:58) | at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:405) | ... 132 more | 18:32:29,828 INFO [NamingHelper] JNDI InitialContext properties:{} | 18:32:29,843 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS | 18:32:29,843 INFO [SettingsFactory] RDBMS: MySQL, version: 5.0.19-nt | 18:32:29,859 INFO [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +02 | 00 (Thu, 19 Oct 2006) $, $Revision: 5908 $ ) | 18:32:29,859 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect | 18:32:29,875 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.transaction.JTATransactionFactory | 18:32:29,875 INFO [NamingHelper] JNDI InitialContext properties:{} | 18:32:29,875 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManag | .... | and at the end of starting process : 18:33:32,656 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/ | 18:33:32,859 ERROR [URLDeploymentScanner] Incomplete Deployment listing: | | --- MBeans waiting for other MBeans --- | ObjectName: portal.wsrp:service=ConsumerRegistry | State: FAILED | Reason: org.hibernate.exception.GenericJDBCException: could not execute query using iterate | I Depend On: | portal:service=Hibernate,type=WSRPConsumer | portal:service=PortletInvoker,type=Federating | portal:service=ListenerRegistry | Depends On Me: | portal.wsrp:service=WSRPDeployer | | --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- | ObjectName: portal.wsrp:service=ConsumerRegistry | State: FAILED | Reason: org.hibernate.exception.GenericJDBCException: could not execute query using iterate | I Depend On: | portal:service=Hibernate,type=WSRPConsumer | portal:service=PortletInvoker,type=Federating | portal:service=ListenerRegistry | Depends On Me: | portal.wsrp:service=WSRPDeployer | | | 18:33:32,984 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080 | 18:33:33,093 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009 | 18:33:33,109 INFO [JkMain] Jk running ID=0 time=0/63 config=null | 18:33:33,140 INFO [Server] JBoss (MX MicroKernel) [4.0.5.GA (build: CVSTag=Branch_4_0 date=200610162339)] Started in 1m:47s:812ms | | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4056588#4056588 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4056588 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
