[prev in list] [next in list] [prev in thread] [next in thread]
List: jboss-user
Subject: [jboss-user] Help
From: "Giuseppa Cefalu" <giuseppa.cefalu () verizon ! net>
Date: 2015-08-04 20:45:17
Message-ID: 000701d0cef6$7c4aadd0$74e00970$ () verizon ! net
[Download RAW message or body]
This is a multipart message in MIME format.
[Attachment #2 (multipart/alternative)]
This is a multipart message in MIME format.
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>
[Attachment #5 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type \
content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 \
(filtered medium)"><style><!-- /* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div \
class=WordSection1><p class=MsoNormal>Hi,<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have solved the previous \
issue. Now, I have a different one, Could you please help with \
this?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal>Giuseppa<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal><span lang=EN>I created a user name<o:p></o:p></span></p><p \
class=MsoNormal><span lang=EN>mysql> GRANT ALL PRIVILEGES ON jboss.* TO \
jboss@localhost IDENTIFIED BY 'password'<o:p></o:p></span></p><p \
class=MsoNormal><span lang=EN>I checked that everyting was going \
smoothly:<o:p></o:p></span></p><p class=MsoNormal>mysql> select \
User,Host,Password from mysql.User;<o:p></o:p></p><p \
class=MsoNormal>+-------+-----------+-------------------------------------------+<o:p></o:p></p><p \
class=MsoNormal>| User | Host | \
Password \
\
|<o:p></o:p></p><p class=MsoNormal>+-------+-----------+-------------------------------------------+<o:p></o:p></p><p \
class=MsoNormal>| root | localhost | *7B9CB6FF820F8EB2569BBC05BF1F871CE258444F \
|<o:p></o:p></p><p class=MsoNormal>| jboss | localhost | \
*7B9CB6FF820F8EB2569BBC05BF1F871CE258444F |<o:p></o:p></p><p class=MsoNormal>| \
root | % | \
*7B9CB6FF820F8EB2569BBC05BF1F871CE258444F |<o:p></o:p></p><p \
class=MsoNormal>+-------+-----------+-------------------------------------------+<o:p></o:p></p><p \
class=MsoNormal>3 rows in set (0.00 sec)<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>This is my mysql-ds.xml file, \
which is in C:\jboss-6.1.0.Final\server\default\deploy<o:p></o:p></p><p \
class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New \
Roman","serif";color:blue'><?xml version="1.0" \
encoding="UTF-8"?><o:p></o:p></span></p><p class=MsoNormal><a \
href="file:///C:\jboss-6.1.0.Final\server\default\deploy\mysql-ds.xml"><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><</span><span \
style='font-size:12.0pt;font-family:"Times New \
Roman","serif";color:#990000'>datasources</span><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>></span></a><a \
href="file:///C:\jboss-6.1.0.Final\server\default\deploy\mysql-ds.xml"><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><</span><span \
style='font-size:12.0pt;font-family:"Times New \
Roman","serif";color:#990000'>local-tx-datasource</span><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>></span></a><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><<span \
style='color:#990000'>jndi-name</span>>MySqlTitanDS<span \
style='color:blue'></</span><span style='color:#990000'>jndi-name</span><span \
style='color:blue'>></span><<span \
style='color:#990000'>connection-url</span>>jdbc:mysql://localhost:3306/Titan<span \
style='color:blue'></</span><span style='color:#990000'>connection-url</span><span \
style='color:blue'>></span><<span \
style='color:#990000'>driver-class</span>>com.mysql.jdbc.Driver<span \
style='color:blue'></</span><span style='color:#990000'>driver-class</span><span \
style='color:blue'>></span><o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:12.0pt;font-family:"Times New \
Roman","serif";color:blue'><!--</span><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#888888'> \
1.Comment out user-name/password if you are using anonymous account 2. Adjust \
user-name/password if you are using different values </span><span \
style='font-size:12.0pt;font-family:"Times New \
Roman","serif";color:blue'>--><o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><<span \
style='color:#990000'>user-name</span>>jboss<span \
style='color:blue'></</span><span style='color:#990000'>user-name</span><span \
style='color:blue'>></span><<span \
style='color:#990000'>password</span>>giuseppa<span \
style='color:blue'></</span><span style='color:#990000'>password</span><span \
style='color:blue'>></span><<span \
style='color:#990000'>min-pool-size</span>>5<span \
style='color:blue'></</span><span style='color:#990000'>min-pool-size</span><span \
style='color:blue'>></span><<span \
style='color:#990000'>max-pool-size</span>>30<span \
style='color:blue'></</span><span style='color:#990000'>max-pool-size</span><span \
style='color:blue'>></span><<span \
style='color:#990000'>exception-sorter-class-name</span>> \
org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter <span \
style='color:blue'></</span><span \
style='color:#990000'>exception-sorter-class-name</span><span \
style='color:blue'>></span></span><a \
href="file:///C:\jboss-6.1.0.Final\server\default\deploy\mysql-ds.xml"><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><</span><span \
style='font-size:12.0pt;font-family:"Times New \
Roman","serif";color:#990000'>metadata</span><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>></span></a><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><<span \
style='color:#990000'>type-mapping</span>>mySQL<span \
style='color:blue'></</span><span style='color:#990000'>type-mapping</span><span \
style='color:blue'>></</span><span style='color:#990000'>metadata</span><span \
style='color:blue'>></</span><span \
style='color:#990000'>local-tx-datasource</span><span \
style='color:blue'>></span></span><a \
href="file:///C:\jboss-6.1.0.Final\server\default\deploy\mysql-ds.xml"><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><</span><span \
style='font-size:12.0pt;font-family:"Times New \
Roman","serif";color:#990000'>local-tx-datasource</span><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>></span></a><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><<span \
style='color:#990000'>jndi-name</span>>MySqlSamplesDS<span \
style='color:blue'></</span><span style='color:#990000'>jndi-name</span><span \
style='color:blue'>></span><<span \
style='color:#990000'>connection-url</span>>jdbc:mysql://localhost:3306/Samples<span \
style='color:blue'></</span><span style='color:#990000'>connection-url</span><span \
style='color:blue'>></span><<span \
style='color:#990000'>driver-class</span>>com.mysql.jdbc.Driver<span \
style='color:blue'></</span><span style='color:#990000'>driver-class</span><span \
style='color:blue'>></span><o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:12.0pt;font-family:"Times New \
Roman","serif";color:blue'><!--</span><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#888888'> \
1.Comment out user-name/password if you are using anonymous account 2. Adjust \
user-name/password if you are using different values </span><span \
style='font-size:12.0pt;font-family:"Times New \
Roman","serif";color:blue'>--><o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:12.0pt;font-family:"Times New \
Roman","serif";color:blue'><!--</span><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#888888'> \
<user-name>jboss</user-name> <password>giuseppa</password> \
</span><span style='font-size:12.0pt;font-family:"Times New \
Roman","serif";color:blue'>--><o:p></o:p></span></p><p class=MsoNormal><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><<span \
style='color:#990000'>min-pool-size</span>>5<span \
style='color:blue'></</span><span style='color:#990000'>min-pool-size</span><span \
style='color:blue'>></span><<span \
style='color:#990000'>max-pool-size</span>>30<span \
style='color:blue'></</span><span style='color:#990000'>max-pool-size</span><span \
style='color:blue'>></span><<span \
style='color:#990000'>exception-sorter-class-name</span>> \
org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter <span \
style='color:blue'></</span><span \
style='color:#990000'>exception-sorter-class-name</span><span \
style='color:blue'>></span></span><a \
href="file:///C:\jboss-6.1.0.Final\server\default\deploy\mysql-ds.xml"><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><</span><span \
style='font-size:12.0pt;font-family:"Times New \
Roman","serif";color:#990000'>metadata</span><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>></span></a><span \
style='font-size:12.0pt;font-family:"Times New Roman","serif"'><<span \
style='color:#990000'>type-mapping</span>>mySQL<span \
style='color:blue'></</span><span style='color:#990000'>type-mapping</span><span \
style='color:blue'>></</span><span style='color:#990000'>metadata</span><span \
style='color:blue'>></</span><span \
style='color:#990000'>local-tx-datasource</span><span \
style='color:blue'>></</span><span \
style='color:#990000'>datasources</span><span \
style='color:blue'>></span></span><o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal>Mysql-connector-java-5.1.36.jar is in \
C:\jboss-6.1.0.Final\server\default\lib<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>FirstBeansTitan.jar is in \
<o:p></o:p></p><p class=MsoNormal>C:\jboss-6.1.0.Final\server\default\deploy\applications<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I follow these steps to run \
my application:<o:p></o:p></p><p class=MsoNormal>Turn off jboss<o:p></o:p></p><p \
class=MsoNormal>In the home directory of the application, run the following \
commands:<o:p></o:p></p><p class=MsoNormal>Ant clean<o:p></o:p></p><p \
class=MsoNormal>Ant ejbjar<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal>C:\FirstBeans>ant clean<o:p></o:p></p><p \
class=MsoNormal>Buildfile: C:\FirstBeans\build.xml<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>clean:<o:p></o:p></p><p \
class=MsoNormal> [delete] Deleting directory \
C:\FirstBeans\build<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal>BUILD SUCCESSFUL<o:p></o:p></p><p class=MsoNormal>Total time: 0 \
seconds<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal>C:\FirstBeans>ant ejbjar<o:p></o:p></p><p \
class=MsoNormal>Buildfile: C:\FirstBeans\build.xml<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>prepare:<o:p></o:p></p><p \
class=MsoNormal> [mkdir] Created dir: \
C:\FirstBeans\build<o:p></o:p></p><p class=MsoNormal> [mkdir] \
Created dir: C:\FirstBeans\build\classrues<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>compile:<o:p></o:p></p><p \
class=MsoNormal> [javac] Compiling 4 source files to \
C:\FirstBeans\build\classrues<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>ejbjar:<o:p></o:p></p><p \
class=MsoNormal> [jar] Building jar: \
C:\FirstBeans\build\FirstBeansTitan.jar<o:p></o:p></p><p \
class=MsoNormal> [copy] Copying 1 file to \
C:\jboss-6.1.0.Final\server\default\deploy\applica<o:p></o:p></p><p \
class=MsoNormal>tions<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal>BUILD SUCCESSFUL<o:p></o:p></p><p class=MsoNormal>Total time: 2 \
seconds<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal>Start Jboss server again<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>C:\FirstBeans> ant \
run.client<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I \
get the following:<o:p></o:p></p><p class=MsoNormal> \
[java] at \
org.jboss.ejb3.interceptor.EJB3TCCLInterceptor.invoke(EJB3TCC<o:p></o:p></p><p \
class=MsoNormal>LInterceptor.java:86)<o:p></o:p></p><p \
class=MsoNormal> [java] at \
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInv<o:p></o:p></p><p \
class=MsoNormal>ocation.java:102)<o:p></o:p></p><p \
class=MsoNormal> [java] at \
org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(Sta<o:p></o:p></p><p \
class=MsoNormal>telessContainer.java:392)<o:p></o:p></p><p \
class=MsoNormal> [java] at \
org.jboss.ejb3.session.InvokableContextClassProxyHack._dynami<o:p></o:p></p><p \
class=MsoNormal>cInvoke(InvokableContextClassProxyHack.java:53)<o:p></o:p></p><p \
class=MsoNormal> [java] at \
org.jboss.aop.Dispatcher.invoke(Dispatcher.java:91)<o:p></o:p></p><p \
class=MsoNormal> [java] at \
org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invok<o:p></o:p></p><p \
class=MsoNormal>e(AOPRemotingInvocationHandler.java:82)<o:p></o:p></p><p \
class=MsoNormal> [java] at \
org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:96<o:p></o:p></p><p \
class=MsoNormal>7)<o:p></o:p></p><p class=MsoNormal> \
[java] at \
org.jboss.remoting.transport.socket.ServerThread.completeInvo<o:p></o:p></p><p \
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic