Hi,
I have solved the previous issue. Now, I have a different one, Could you
please help with this?
Thanks,
Giuseppa
I created a user name
mysql> GRANT ALL PRIVILEGES ON jboss.* TO ***@localhost IDENTIFIED BY
'password'
I checked that everyting was going smoothly:
mysql> select User,Host,Password from mysql.User;
+-------+-----------+-------------------------------------------+
| User | Host | Password |
+-------+-----------+-------------------------------------------+
| root | localhost | *7B9CB6FF820F8EB2569BBC05BF1F871CE258444F |
| jboss | localhost | *7B9CB6FF820F8EB2569BBC05BF1F871CE258444F |
| root | % | *7B9CB6FF820F8EB2569BBC05BF1F871CE258444F |
+-------+-----------+-------------------------------------------+
3 rows in set (0.00 sec)
This is my mysql-ds.xml file, which is in
C:\jboss-6.1.0.Final\server\default\deploy
<?xml version="1.0" encoding="UTF-8"?>
<file:///C:\jboss-6.1.0.Final\server\default\deploy\mysql-ds.xml>
<datasources>
<file:///C:\jboss-6.1.0.Final\server\default\deploy\mysql-ds.xml>
<local-tx-datasource><jndi-name>MySqlTitanDS</jndi-name><connection-url>jdbc
:mysql://localhost:3306/Titan</connection-url><driver-class>com.mysql.jdbc.D
river</driver-class>
<!-- 1.Comment out user-name/password if you are using anonymous account 2.
Adjust user-name/password if you are using different values -->
<user-name>jboss</user-name><password>giuseppa</password><min-pool-size>5</m
in-pool-size><max-pool-size>30</max-pool-size><exception-sorter-class-name>
org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
</exception-sorter-class-name>
<file:///C:\jboss-6.1.0.Final\server\default\deploy\mysql-ds.xml>
<metadata><type-mapping>mySQL</type-mapping></metadata></local-tx-datasource
<file:///C:\jboss-6.1.0.Final\server\default\deploy\mysql-ds.xml>
<local-tx-datasource><jndi-name>MySqlSamplesDS</jndi-name><connection-url>jd
bc:mysql://localhost:3306/Samples</connection-url><driver-class>com.mysql.jd
bc.Driver</driver-class>
<!-- 1.Comment out user-name/password if you are using anonymous account 2.
Adjust user-name/password if you are using different values -->
<!-- <user-name>jboss</user-name> <password>giuseppa</password> -->
<min-pool-size>5</min-pool-size><max-pool-size>30</max-pool-size><exception-
sorter-class-name>
org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
</exception-sorter-class-name>
<file:///C:\jboss-6.1.0.Final\server\default\deploy\mysql-ds.xml>
<metadata><type-mapping>mySQL</type-mapping></metadata></local-tx-datasource
</datasources>
Mysql-connector-java-5.1.36.jar is in
C:\jboss-6.1.0.Final\server\default\lib
FirstBeansTitan.jar is in
C:\jboss-6.1.0.Final\server\default\deploy\applications
I follow these steps to run my application:
Turn off jboss
In the home directory of the application, run the following commands:
Ant clean
Ant ejbjar
C:\FirstBeans>ant clean
Buildfile: C:\FirstBeans\build.xml
clean:
[delete] Deleting directory C:\FirstBeans\build
BUILD SUCCESSFUL
Total time: 0 seconds
C:\FirstBeans>ant ejbjar
Buildfile: C:\FirstBeans\build.xml
prepare:
[mkdir] Created dir: C:\FirstBeans\build
[mkdir] Created dir: C:\FirstBeans\build\classrues
compile:
[javac] Compiling 4 source files to C:\FirstBeans\build\classrues
ejbjar:
[jar] Building jar: C:\FirstBeans\build\FirstBeansTitan.jar
[copy] Copying 1 file to
C:\jboss-6.1.0.Final\server\default\deploy\applica
tions
BUILD SUCCESSFUL
Total time: 2 seconds
Start Jboss server again
C:\FirstBeans> ant run.client
I get the following:
[java] at
org.jboss.ejb3.interceptor.EJB3TCCLInterceptor.invoke(EJB3TCC
LInterceptor.java:86)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(Sta
telessContainer.java:392)
[java] at
org.jboss.ejb3.session.InvokableContextClassProxyHack._dynami
cInvoke(InvokableContextClassProxyHack.java:53)
[java] at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:91)
[java] at
org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invok
e(AOPRemotingInvocationHandler.java:82)
[java] at
org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:96
7)
[java] at
org.jboss.remoting.transport.socket.ServerThread.completeInvo
cation(ServerThread.java:791)
[java] at
org.jboss.remoting.transport.socket.ServerThread.processInvoc
ation(ServerThread.java:744)
[java] at
org.jboss.remoting.transport.socket.ServerThread.dorun(Server
Thread.java:548)
[java] at
org.jboss.remoting.transport.socket.ServerThread.run(ServerTh
read.java:234)
[java] at
org.jboss.remoting.MicroRemoteClientInvoker.invoke(MicroRemot
eClientInvoker.java:218)
[java] at org.jboss.remoting.Client.invoke(Client.java:2070)
[java] at org.jboss.remoting.Client.invoke(Client.java:879)
[java] at
org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(Inv
okeRemoteInterceptor.java:60)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.aspects.tx.ClientTxPropagationInterceptor.invoke(Cl
ientTxPropagationInterceptor.java:61)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.security.client.SecurityClientInterceptor.invo
ke(SecurityClientInterceptor.java:65)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInte
rceptor.java:77)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.async.impl.interceptor.AsynchronousClientInter
ceptor.invoke(AsynchronousClientInterceptor.java:143)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.aspects.remoting.PojiProxy.invoke(PojiProxy.java:62
)
[java] at $Proxy4.invoke(Unknown Source)
[java] at
org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocat
ionHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:185)
[java] at $Proxy3.createCabin(Unknown Source)
[java] at titan.clients.Client.main(Client.java:27)
[java] at
org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(Inv
okeRemoteInterceptor.java:72)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.aspects.tx.ClientTxPropagationInterceptor.invoke(Cl
ientTxPropagationInterceptor.java:61)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.security.client.SecurityClientInterceptor.invo
ke(SecurityClientInterceptor.java:65)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInte
rceptor.java:77)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.async.impl.interceptor.AsynchronousClientInter
ceptor.invoke(AsynchronousClientInterceptor.java:143)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.aspects.remoting.PojiProxy.invoke(PojiProxy.java:62
)
[java] at $Proxy4.invoke(Unknown Source)
[java] at
org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocat
ionHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:185)
[java] at $Proxy3.createCabin(Unknown Source)
[java] at titan.clients.Client.main(Client.java:27)
[java] Caused by: javax.persistence.PersistenceException:
org.hibernate.exc
eption.GenericJDBCException: Cannot open connection
[java] at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractE
ntityManagerImpl.java:1215)
[java] at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractE
ntityManagerImpl.java:1148)
[java] at
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractE
ntityManagerImpl.java:1154)
[java] at
org.hibernate.ejb.AbstractEntityManagerImpl$3.mapManagedFlush
Failure(AbstractEntityManagerImpl.java:1068)
[java] at
org.hibernate.transaction.synchronization.CallbackCoordinator
.beforeCompletion(CallbackCoordinator.java:122)
[java] at
org.hibernate.transaction.synchronization.HibernateSynchroniz
ationImpl.beforeCompletion(HibernateSynchronizationImpl.java:51)
[java] at
com.arjuna.ats.internal.jta.resources.arjunacore.Synchronizat
ionImple.beforeCompletion(SynchronizationImple.java:97)
[java] at
com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeC
ompletion(TwoPhaseCoordinator.java:274)
[java] at
com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(Two
PhaseCoordinator.java:94)
[java] at
com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:1
59)
[java] at
com.arjuna.ats.internal.jta.transaction.arjunacore.Transactio
nImple.commitAndDisassociate(TransactionImple.java:1158)
[java] at
com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransa
ction.commit(BaseTransaction.java:119)
[java] at
com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit
(BaseTransactionManagerDelegate.java:75)
[java] at
org.jboss.ejb3.tx2.impl.CMTTxInterceptor.endTransaction(CMTTx
Interceptor.java:82)
[java] at
org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invokeInOurTx(CMTTxI
nterceptor.java:255)
[java] at
org.jboss.ejb3.tx2.impl.CMTTxInterceptor.required(CMTTxInterc
eptor.java:349)
[java] at
org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invoke(CMTTxIntercep
tor.java:209)
[java] at
org.jboss.ejb3.tx2.aop.CMTTxInterceptorWrapper.invoke(CMTTxIn
terceptorWrapper.java:52)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropag
ationInterceptor.java:76)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java
:42)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invok
e(Ejb3AuthenticationInterceptorv2.java:182)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagatio
nInterceptor.java:41)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(Block
ContainerShutdownInterceptor.java:67)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.core.context.CurrentInvocationContextIntercept
or.invoke(CurrentInvocationContextInterceptor.java:47)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.aspects.currentinvocation.CurrentInvocationIntercep
tor.invoke(CurrentInvocationInterceptor.java:67)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.interceptor.EJB3TCCLInterceptor.invoke(EJB3TCC
LInterceptor.java:86)
[java] at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv
ocation.java:102)
[java] at
org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(Sta
telessContainer.java:392)
[java] at
org.jboss.ejb3.session.InvokableContextClassProxyHack._dynami
cInvoke(InvokableContextClassProxyHack.java:53)
[java] at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:91)
[java] at
org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invok
e(AOPRemotingInvocationHandler.java:82)
[java] at
org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:96
7)
[java] at
org.jboss.remoting.transport.socket.ServerThread.completeInvo
cation(ServerThread.java:791)
[java] at
org.jboss.remoting.transport.socket.ServerThread.processInvoc
ation(ServerThread.java:744)
[java] at
org.jboss.remoting.transport.socket.ServerThread.dorun(Server
Thread.java:548)
[java] at
org.jboss.remoting.transport.socket.ServerThread.run(ServerTh
read.java:234)
[java] Caused by: org.hibernate.exception.GenericJDBCException: Cannot
open
connection
[java] at
org.hibernate.exception.SQLStateConverter.handledNonSpecificE
xception(SQLStateConverter.java:140)
[java] at
org.hibernate.exception.SQLStateConverter.convert(SQLStateCon
verter.java:128)
[java] at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep
tionHelper.java:66)
[java] at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep
tionHelper.java:52)
[java] at
org.hibernate.jdbc.ConnectionManager.openConnection(Connectio
nManager.java:449)
[java] at
org.hibernate.jdbc.ConnectionManager.getConnection(Connection
Manager.java:167)
[java] at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractB
atcher.java:116)
[java] at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractB
atcher.java:109)
[java] at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(Abst
ractBatcher.java:244)
[java] at
org.hibernate.persister.entity.AbstractEntityPersister.insert
(AbstractEntityPersister.java:2411)
[java] at
org.hibernate.persister.entity.AbstractEntityPersister.insert
(AbstractEntityPersister.java:2874)
[java] at
org.hibernate.action.EntityInsertAction.execute(EntityInsertA
ction.java:79)
[java] at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273
)
[java] at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.j
ava:265)
[java] at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.j
ava:184)
[java] at
org.hibernate.event.def.AbstractFlushingEventListener.perform
Executions(AbstractFlushingEventListener.java:321)
[java] at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(Def
aultFlushEventListener.java:51)
[java] at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
[java] at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:
383)
[java] at
org.hibernate.transaction.synchronization.CallbackCoordinator
.beforeCompletion(CallbackCoordinator.java:117)
[java] ... 39 more
[java] Caused by: org.jboss.util.NestedSQLException: Unable to get
managed
connection for MySqlTitanDS; - nested throwable:
(javax.resource.ResourceExcepti
on: Unable to get managed connection for MySqlTitanDS)
[java] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnecti
on(WrapperDataSource.java:95)
[java] at
org.hibernate.ejb.connection.InjectedDataSourceConnectionProv
ider.getConnection(InjectedDataSourceConnectionProvider.java:71)
[java] at
org.hibernate.jdbc.ConnectionManager.openConnection(Connectio
nManager.java:446)
[java] ... 54 more
[java] Caused by: javax.resource.ResourceException: Unable to get
managed c
onnection for MySqlTitanDS
[java] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.g
etManagedConnection(BaseConnectionManager2.java:441)
[java] at
org.jboss.resource.connectionmanager.TxConnectionManager.getM
anagedConnection(TxConnectionManager.java:414)
[java] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.a
llocateConnection(BaseConnectionManager2.java:496)
[java] at
org.jboss.resource.connectionmanager.BaseConnectionManager2$C
onnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
[java] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnecti
on(WrapperDataSource.java:89)
[java] ... 56 more
[java] Caused by: org.jboss.resource.JBossResourceException: Could not
crea
te connection; - nested throwable:
(com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxE
rrorException: Access denied for user 'jboss'@'localhost' to database
'titan')
[java] at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionF
actory.getLocalManagedConnection(LocalManagedConnectionFactory.java:261)
[java] at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionF
actory.createManagedConnection(LocalManagedConnectionFactory.java:215)
[java] at
org.jboss.resource.connectionmanager.InternalManagedConnectio
nPool.createConnectionEventListener(InternalManagedConnectionPool.java:648)
[java] at
org.jboss.resource.connectionmanager.InternalManagedConnectio
nPool.getConnection(InternalManagedConnectionPool.java:272)
[java] at
org.jboss.resource.connectionmanager.JBossManagedConnectionPo
ol$BasePool.getConnection(JBossManagedConnectionPool.java:747)
[java] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.g
etManagedConnection(BaseConnectionManager2.java:403)
[java] ... 60 more
[java] Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
: Access denied for user 'jboss'@'localhost' to database 'titan'
[java] at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
[java] at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC
onstructorAccessorImpl.java:39)
[java] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del
egatingConstructorAccessorImpl.java:27)
[java] at
java.lang.reflect.Constructor.newInstance(Constructor.java:51
3)
[java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
[java] at com.mysql.jdbc.Util.getInstance(Util.java:383)
[java] at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
[java] at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
[java] at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
[java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
[java] at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4292)
[java] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1259)
[java] at
com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java
:2249)
[java] at
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImp
l.java:2280)
[java] at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java
:2079)
[java] at
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
[java] at
com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44
)
[java] at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
[java] at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC
onstructorAccessorImpl.java:39)
[java] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del
egatingConstructorAccessorImpl.java:27)
[java] at
java.lang.reflect.Constructor.newInstance(Constructor.java:51
3)
[java] at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
[java] at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java
:399)
[java] at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:325)
[java] at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionF
actory.getLocalManagedConnection(LocalManagedConnectionFactory.java:229)
[java] ... 65 more
[java] Java Result: 1
BUILD SUCCESSFUL
Total time: 2 seconds
C:\FirstBeans>