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 jboss@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>
_______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user