[jboss-user] [JBoss Portal] - Re: JBP 2.6 RC2 : Pb starting service portal.wsrp:service=Co

[Antoine_h]

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