[jboss-user] Help

Tue Aug 4 16:45:17 EDT 2015

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 at 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>

<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>

<!-- <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>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20150804/3d0be5b8/attachment-0001.html 