[JBoss-user] [JBoss Portal] - Re: Hibernate Failing
I have MySQL 4.1.12a. I'm not sure that this is where the problem is since I tried removing the Protal sar file and starting everything up. I can start the server and when I go to the JMX console page, I can see the datasource. So the datasource seems to be getting created OK. I'm just not experienced enough with Hibernate to figure out what the problem is there. I'm pulling what little hair I have left out with this one! Rick Price View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3881409#3881409 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3881409 --- This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput a projector? How fast can you ride your desk chair down the office luge track? If you want to score the big prize, get to know the little guy. Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss Portal] - Hibernate Failing
Jboss 4.0.2
Portal RC3
MySQL JConnector 3.1.8 (com.mysql.jdbc.driver)
My MySQL seems to be doing alright now but Hibernate is failing. Here is what
I get when I first see Hibernate startup.
class org.jboss.cache.interceptors.UnlockInterceptor
10:05:14,827 INFO [TreeImpl$FixedTreeCache] cache mode is local, will not
create the channel
10:05:14,921 INFO [Environment] Hibernate 3.0.2
10:05:14,936 INFO [Environment] hibernate.properties not found
10:05:14,936 INFO [Environment] using CGLIB reflection optimizer
10:05:14,936 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling
10:05:15,046 INFO [Configuration] configuring from url:
file:/C:/jboss-4.0.2/server/default/deploy/jboss-portal.sar/conf/hibernate/hibernate.cfg.xml
10:05:15,061 INFO [Configuration] Mapping resource:
org/jboss/portal/core/impl/role/RoleImpl.hbm.xml
Here is what I see for MySQL:
10:05:15,405 INFO [NamingHelper] JNDI InitialContext properties:{}
10:05:15,405 INFO [DatasourceConnectionProvider] Using datasource:
java:PortalDS
10:05:15,483 INFO [STDOUT] Mon Jun 13 10:05:15 EDT 2005 TRACE: -->
NonRegisteringDriver.java:223
com.mysql.jdbc.NonRegisteringDriver.acceptsURL("jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false")
10:05:15,483 INFO [STDOUT] Mon Jun 13 10:05:15 EDT 2005 TRACE: -->
NonRegisteringDriver.java:339
com.mysql.jdbc.NonRegisteringDriver.parseURL("jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false",
null)
10:05:15,499 INFO [STDOUT] Mon Jun 13 10:05:15 EDT 2005 TRACE:-->
StringUtils.java:722
com.mysql.jdbc.StringUtils.startsWithIgnoreCase("jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false",
"jdbc:mysql://")
10:05:15,499 INFO [STDOUT] Mon Jun 13 10:05:15 EDT 2005 TRACE: -->
StringUtils.java:738
com.mysql.jdbc.StringUtils.startsWithIgnoreCase("jdbc:mysql://local
host:3306/jbossportal?useServerPrepStmts=false", 0, "jdbc:mysql://")
10:05:15,499 INFO [STDOUT] Mon Jun 13 10:05:15 EDT 2005 TRACE: <--
StringUtils.java:738 com.mysql.jdbc.StringUtils.startsWithIgnoreCase(..)
returning true
10:05:15,499 INFO [STDOUT] Mon Jun 13 10:05:15 EDT 2005 TRACE:<--
StringUtils.java:722 com.mysql.jdbc.StringUtils.startsWithIgnoreCase(..)
returning true
10:05:15,499 INFO [STDOUT] Mon Jun 13 10:05:15 EDT 2005 TRACE: <--
NonRegisteringDriver.java:339 com.mysql.jdbc.NonRegisteringDriver.parseURL(..)
returning {HOST=localhost:3306, DBNAME=jbossportal, useServerPrepStmts=false}
Many more INFO lines follow this.
10:05:21,311 INFO [STDOUT] Mon Jun 13 10:05:21 EDT 2005 TRACE: <--
ResultSet.java:7079 com.mysql.jdbc.ResultSet.finalize(..) returning null
10:05:21,311 INFO [SettingsFactory] RDBMS: MySQL, version: 4.1.12a-nt
10:05:21,311 INFO [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver,
version: mysql-connector-java-3.1.8 ( $Date: 2005/04/14 20:36:13 $, $Revision:
1.27.4.64 $ )
10:05:21,374 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
10:05:21,374 INFO [SettingsFactory] JDBC batch size: 15
10:05:21,374 INFO [SettingsFactory] JDBC batch updates for versioned data:
disabled
10:05:21,374 INFO [SettingsFactory] Scrollable result sets: enabled
10:05:21,374 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): enabled
10:05:21,374 INFO [SettingsFactory] Aggressive release : disabled
10:05:21,374 INFO [SettingsFactory] Maximum outer join fetch depth: 2
10:05:21,374 INFO [SettingsFactory] Default batch fetch size: 1
10:05:21,374 INFO [SettingsFactory] Generate SQL with comments: disabled
10:05:21,374 INFO [SettingsFactory] Order SQL updates by primary key: disabled
10:05:21,374 INFO [SettingsFactory] Query translator:
org.hibernate.hql.ast.ASTQueryTranslatorFactory
10:05:21,390 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
10:05:21,390 INFO [SettingsFactory] Query language substitutions: {}
10:05:21,390 INFO [TransactionFactoryFactory] Using default transaction
strategy (direct JDBC transactions)
10:05:21,405 INFO [TransactionManagerLookupFactory] instantiating
TransactionManagerLookup:
org.hibernate.transaction.JBossTransactionManagerLookup
Here's the error I get:
10:05:22,358 INFO [SessionFactoryObjectFactory] Bound factory to JNDI name:
java:portal/SessionFactory
10:05:22,358 WARN [SessionFactoryObjectFactory] InitialContext did not
implement EventContext
10:05:22,358 INFO [NamingHelper] JNDI InitialContext properties:{}
10:05:22,358 INFO [SessionFactoryImpl] Checking 0 named queries
10:05:22,358 INFO [SessionFactoryBinder] Hibernate dialect used
org.hibernate.dialect.MySQLDialect
10:05:22,780 ERROR [SessionFactoryBinder] Starting failed
portal:service=Hibernate java.lang.NullPointerException
at com.mysql.jdbc.PreparedStatement.asSql(PreparedStatement.java:1845)
at com.mysql.jdbc.PreparedStatement.toString(PreparedStatement.java:1770
)
at java.lang.String.valueOf(String.java:2577)
at java.lang.StringBuffer.append(StringBuffer.java:220)
[JBoss-user] [JBoss Portal] - Re: Initial Portal config problems with MySQL
This problem is solved. Seems that the com folder in the Connector J release (3.8.1) is incomplete. You need to extract the one from the jar file and put it in the classpath. You also need to add aspectjrt.jar to the folder where you put the driver. Now have a hibernate issue ... but that is another post entirely. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3881283#3881283 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3881283 --- This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput a projector? How fast can you ride your desk chair down the office luge track? If you want to score the big prize, get to know the little guy. Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss Portal] - Re: Initial Portal config problems with MySQL
Removed the sar and the forums ear and now get this exception: 08:21:05,061 INFO [ex] Bound to JNDI name: queue/ex 08:21:05,108 INFO [testTopic] Bound to JNDI name: topic/testTopic 08:21:05,124 INFO [securedTopic] Bound to JNDI name: topic/securedTopic 08:21:05,124 INFO [testDurableTopic] Bound to JNDI name: topic/testDurableTopic 08:21:05,124 INFO [testQueue] Bound to JNDI name: queue/testQueue 08:21:05,265 INFO [UILServerILService] JBossMQ UIL service available at : /0.0. 0.0:8093 08:21:05,390 INFO [DLQ] Bound to JNDI name: queue/DLQ 08:21:06,046 INFO [ConnectionFactoryBindingService] Bound connection factory fo r resource adapter for ConnectionManager 'jboss.jca:service=ConnectionFactoryBin ding,name=JmsXA to JNDI name 'java:JmsXA' 08:21:06,390 INFO [WrapperDataSourceService] Bound connection factory for resou rce adapter for ConnectionManager 'jboss.jca:service=DataSourceBinding,name=Port alDS to JNDI name 'java:PortalDS' 08:21:06,452 ERROR [MainDeployer] could not create deployment: file:/C:/jboss-4. 0.2/server/default/deploy/portal-mysql-ds.xml org.jboss.deployment.DeploymentException: Trying to install an already registere d mbean: jboss.jca:service=LocalTxCM,name=PortalDS at org.jboss.system.ServiceCreator.install(ServiceCreator.java:70) at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigura tor.java:153) at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java :118) at org.jboss.system.ServiceController.install(ServiceController.java:202 ) at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch er.java:141) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker. java:249) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) at $Proxy4.install(Unknown Source) at org.jboss.deployment.SARDeployer.create(SARDeployer.java:220) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch er.java:141) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept or.java:121) at org.jboss.mx.server.Invocation.invoke(Invocation.java:74) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM BeanOperationInterceptor.java:127) at org.jboss.mx.server.Invocation.invoke(Invocation.java:74) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker. java:249) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644) at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.ja va:273) at $Proxy35.create(Unknown Source) at org.jboss.deployment.XSLSubDeployer.create(XSLSubDeployer.java:224) at org.jboss.deployment.MainDeployer.create(MainDeployer.java:918) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:774) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:738) at sun.reflect.GeneratedMethodAccessor48.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch er.java:141) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept or.java:121) at org.jboss.mx.server.Invocation.invoke(Invocation.java:74) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM BeanOperationInterceptor.java:127) at org.jboss.mx.server.Invocation.invoke(Invocation.java:74) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker. java:249) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644) at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177) at $Proxy8.deploy(Unknown Source) at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymen tScanner.java:325) at org.jboss.deployment.scanner.URLDeploymentSc
[JBoss-user] [JBoss Portal] - Re: Initial Portal config problems with MySQL
I checked the file and the XML tags are there. I'm not sure what happened when I pasted it up there. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3881194#3881194 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3881194 --- This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput a projector? How fast can you ride your desk chair down the office luge track? If you want to score the big prize, get to know the little guy. Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss Portal] - Re: Initial Portal config problems with MySQL
The password was set to 'password' so this should work. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3881177#3881177 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3881177 --- This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput a projector? How fast can you ride your desk chair down the office luge track? If you want to score the big prize, get to know the little guy. Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JBoss Portal] - Initial Portal config problems with MySQL
I am having a problem getting the Portals setup on my Windows box. Jboss is
running well on this and my Linux machines.
Jboss is 4.0.2
Portal is RC2
mysql-connector-java-3.1.8-bin.jar located in the server\default\lib directory
Windows XP
MySQL 4.1.12a
I copied the sar and ear to the server\default\deploy folder along with the XML
files for mysql:
PortalDS
jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false
com.mysql.jdbc.Driver
portal
password
The driver jar is in the classpath as are the com and org directories.
The stack trace for the error is:
13:49:36,968 INFO [HbmBinder] Mapping collection: org.jboss.portlet.forums.impl
.ForumImpl.watches -> jbp_forums_forumswatch
13:49:36,968 INFO [HbmBinder] Mapping collection: org.jboss.portlet.forums.impl
.TopicImpl.watches -> jbp_forums_topicswatch
13:49:36,968 INFO [Configuration] processing association property references
13:49:36,968 INFO [Configuration] processing foreign key constraints
13:49:37,390 INFO [NamingHelper] JNDI InitialContext properties:{}
13:49:37,405 INFO [DatasourceConnectionProvider] Using datasource:
java:PortalDS
13:49:37,405 WARN [JBossManagedConnectionPool] Throwable while attempting to
get a new connection: null
java.lang.NoClassDefFoundError: org/aspectj/lang/Signature
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:242)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.g
etDriver(LocalManagedConnectionFactory.java:266)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
reateManagedConnection(LocalManagedConnectionFactory.java:150)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr
eateConnectionEventListener(InternalManagedConnectionPool.java:508)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.ge
tConnection(InternalManagedConnectionPool.java:207)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BaseP
ool.getConnection(JBossManagedConnectionPool.java:534)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManage
dConnection(BaseConnectionManager2.java:395)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedCo
nnection(TxConnectionManager.java:297)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
onnection(BaseConnectionManager2.java:447)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
nManagerProxy.allocateConnection(BaseConnectionManager2.java:874)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(Wrapp
erDataSource.java:103)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(D
atasourceConnectionProvider.java:59)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:
67)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1509
)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav
a:1054)
at org.jboss.portal.core.hibernate.SessionFactoryBinder.createSessionFac
tory(SessionFactoryBinder.java:261)
at org.jboss.portal.core.hibernate.SessionFactoryBinder.startService(Ses
sionFactoryBinder.java:127)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS
upport.java:272)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:1
73)
Again, JBoss is workinig just fine as is MySQL (from the MySQL Clients - not
JDBC). Can anyone see what I've overlooked??
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3881174#3881174
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3881174
---
This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput
a projector? How fast can you ride your desk chair down the office luge track?
If you want to score the big prize, get to know the little guy.
Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20
___
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
