RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

Michael Klem Tue, 07 Oct 2003 13:43:14 -0700

At 9:24 PM +0100 10/7/03, Adrian Brock wrote:

On Tue, 2003-10-07 at 19:37, Comtois, Pierre wrote:
Finally resolved the exception issue:

1. I created the tables manually and for my appl. Made them of type InnoDB

From MySQL version 4.0, InnoDB is enabled by default. So sql used to create a db table will default to being an InnoDB table. To explicitly create a table as InnoDB do this: CREATE TABLE CUSTOMER (A INT, B CHAR (20), INDEX (A)) TYPE = InnoDB;

To see the type of a table use this:
  SHOW TABLE STATUS FROM test LIKE 'CUSTOMER'

More info can be found here:
<http://www.mysql.com/doc/en/Using_InnoDB_tables.html>
<http://www.mysql.com/doc/en/InnoDB_in_MySQL_3.23.html>
<http://www.mysql.com/doc/en/InnoDB_start.html>

What is the sql for InnoDB, I would like to include a version in
docs/examples/jca

 2. I gave SELECT permission to my user to the mysql database so it could
 access its permission table. I'm a novice at MySql as well so I might have
 messed that up myself :-)

Doesn't a user get this right for tables they create?

 3. I had put my computer name in the mysql-ds connection-url attribute ... I
 put it back to localhost

 ps: I would have thought that it would be better to specify a computer name
 as opposed to localhost ... ?


 Next item up for bid ... I want to access the newly configured DB using the
 JBoss console ( http://localhost:8080/jmx-console/index.jsp ). Seems that
 now I have no link in jmx-console to access the Hypwersonic service ... The
 link to it is gone ...


It will be in the jboss.jca section.
If you didn't deploy hsqldb-ds.xml, of course you won't see it on the
console.

Regards,
Adrian

 Is this normal ? Am I missing something ? My thought is that I have to
 configures the jmx ...

 Looking at displayMBeans.jsp, that the mbean is missing in the MBeanData
 array ...
 <%
       MBeanData[] data = domainData.getData();
       for(int d = 0; d < data.length; d ++)
       {
          String name = data[d].getObjectName().toString();
          String properties = data[d].getNameProperties();
 %>
       <li><a href="HtmlAdaptor?action=inspectMBean&name=<%=
 URLEncoder.encode(name) %>"><%= URLDecoder.decode(properties) %></a></li>
 <%

Ideas ?

 >Pierre Comtois
 >Business Acceleration Services, Solutions Consulting
 >45 O'Connor Street, Suite 500    *    Ottawa, Ontario K1P 1A4
 >Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:  [EMAIL PROTECTED]
 >
 >


 -----Original Message-----
 From: Adrian Brock [mailto:[EMAIL PROTECTED]
 Sent: October 7, 2003 11:01 AM
 To: [EMAIL PROTECTED]
 Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

Some guy had the same problem last week and resolved it,

> but he seems to have vanished from this list when somebody

else has a problem. :-(

 On Tue, 2003-10-07 at 15:34, Comtois, Pierre wrote:
 > Making progress ... but ever s-o-o-o-o slowly !
 >
 > It would seem that the persistence tables specified by the
 > mysql-jdbc2-service.xml file are not getting creating resulting in
 > connection errors on startup. I found nothing in the archives that
 > helped ...
 >
 >       CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID
 > INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER,
 > TXOP CHAR(1), MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
 >       CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
 >       CREATE_TABLES_ON_STARTUP = TRUE
 >
 > What could be preventing these from getting created ... I've now
 > changed user temporarily to root to remove authorization issues from
 > the equation. If I have to, I'll create them by hand, but this likely
 > indicates another problem.
 >

 Please wait... I'm trying to hack your machine so I can see the error
 message. :-)

> P.S. Is there an up-to-date document anywhere that details how to

> > integrate MySQL 4.x with JBOSS 3.2.2RC4? I've found stuff with Google

 > but haven't found anything up-to-date and accurate. I'm setting up a
 > pc with around 12 different development modules/tools and this piece
 > is taking much more time than it should/can afford to get going on the
 > actual development phase. Maybe what I want to do is a rarity, but I
 > don't think it is. A short white paper would cost cycles initially,
 > but would likely pay off over the long haul.
 >
 Remove mysql-jdbc2.xml and use the file version.
 Come back to it when you are sure mysql works.
 I'm currently preparing an enhanced jbossmq section for the admin docs with
 the 3.2.2 release.
 Regards,
 Adrian
> > >Pierre Comtois > >Business Acceleration Services, Solutions Consulting > >45 O'Connor Street, Suite 500 * Ottawa, Ontario K1P 1A4 > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: > >[EMAIL PROTECTED] > > > > > > > -----Original Message----- > From: Adrian Brock [mailto:[EMAIL PROTECTED] > Sent: October 6, 2003 7:40 PM > To: [EMAIL PROTECTED] > Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS > > > On Mon, 2003-10-06 at 22:23, Comtois, Pierre wrote: > > Default install puts it in ... It's dated June 10/2003 ... > > > > Ok, so you are using 3.2.1? > > Copy the SQL Properties from the mysql-jdbc2-service.xml > into jbossmq-service.xml - replacing the hsqldb sql properties. > > Where is the difficulty? > There is an MBean called the PersistenceManager that > takes a parameter called SQLProperties. > By default it references DefaultDS and uses hsqldb sql. > You need to change it to match your jndi name and mysql sql statements. > > It is harder with 3.2.1 > > With 3.2.2 it will be to just delete hsqldb-jdbc2-service.xml > and replace it with mysql-jdbc2-service.xml > > Regards, > Adrian > > > > > >Pierre Comtois > > >Business Acceleration Services, Solutions Consulting > > >45 O'Connor Street, Suite 500 * Ottawa, Ontario K1P 1A4 > > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: > [EMAIL PROTECTED] > > > > > > > > > > > > -----Original Message----- > > From: Adrian Brock [mailto:[EMAIL PROTECTED] > > Sent: October 6, 2003 4:56 PM > > To: [EMAIL PROTECTED] > > Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS > > > > > > Where did you get jbossmq-service.xml from? > > > > The persistence manager has been removed from that file. > > It is now in x-jdbc2-service.xml > > > > Supposedly to make it easier to drop in a different implementation > > like you are trying :-) > > > > Regards, > > Adrian > > > > On Mon, 2003-10-06 at 21:47, Comtois, Pierre wrote: > > > I've also copied mysql-jdbc2-service.xml from the examples to the

> > > > deploy/jms folder and deleted the hsql version.

 > > >
 > > > I'm still getting an error:
 > > >
 > > > 16:41:14,011 INFO  [MainDeployer] Starting deployment of package:
 > > > file:/C:/jboss-3.2.2RC4/server/default/deploy/jms/jbossmq-service.xml
 > > > 16:41:14,322 INFO  [ServiceConfigurator] Problem configuring service
 > > > jboss.mq:service=PersistenceManager
 > > > org.jboss.deployment.DeploymentException: Exception setting attribute
 > > > javax.management.Attribute: name=MessageCache
 > > > value=jboss.mq:service=MessageCache on mbean
 > > > jboss.mq:service=PersistenceManager; - nested throwable:
 > > > (java.lang.UnsupportedOperationException: This is now set on the
 > > > destination
 > > > manager)
 > > > at
 > > >
 > >
 > org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurator.
 > java:4
 > > > 78)
 > > >
 > > >
 > > > Sounds like I should remove name=MessageCache
 > > > value=jboss.mq:service=MessageCache attribute .. Would that be right ?
 > > >
 > > >
 > > > >Pierre Comtois
 > > > >Business Acceleration Services, Solutions Consulting
 > > > >45 O'Connor Street, Suite 500    *    Ottawa, Ontario K1P 1A4

> > > > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail:

 > > > >[EMAIL PROTECTED]
 > > > >
 > > > >
 > > >
 > > >
 > > > -----Original Message-----
 > > > From: Comtois, Pierre
 > > > Sent: October 6, 2003 4:13 PM
 > > > To: '[EMAIL PROTECTED]'
 > > > Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
 > > >
 > > >
 > > > I deleted hsqldb-ds.xml and changed jndi name.
 > > > I'm looking at what I'd need to change ...
 > > >
 > > > My install didn't have any reference to persistence in
 > > > jbossmq-service.xmlso copied the one I found at
 > > > http://www.jboss.org/thread.jsp?forum=48&thread=39416&message=3803454&;
 > > > q=jbos
 > > > smq-service.xml#3803454 and put it in the default/deploy/jms folder.
 > > >
 > > > I found a section to :
 > > >
 > > > <mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager"
 > > >  name="jboss.mq:service=PersistenceManager">
 > > >     <depends
 > > > optional-attribute-name="MessageCache">jboss.mq:service=MessageCache</
 > > > depend
 > > > s>
 > > >     <depends
 > > > optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxC
 > > > M,name
 > > > =DefaultDS</depends>
 > > >     <attribute name="SqlProperties">
 > > >
 > > > But it only includes SQL statements that do not seem to be
 > > > configurable specifically for my DB. Likely there are other attribs,
 > > > but can't find any mention of any in the archives.
 > > >
 > > > Can you point me where ?
 > > >
 > > > Thx ...
 > > >
 > > >
 > > > >Pierre Comtois
 > > > >Business Acceleration Services, Solutions Consulting
 > > > >45 O'Connor Street, Suite 500    *    Ottawa, Ontario K1P 1A4
 > > > >Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:
 > > > >[EMAIL PROTECTED]
 > > > >
 > > > >
 > > >
 > > >
 > > > -----Original Message-----
 > > > From: Adrian Brock [mailto:[EMAIL PROTECTED]
 > > > Sent: October 6, 2003 2:24 PM
 > > > To: [EMAIL PROTECTED]
 > > > Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
 > > >
 > > >
 > > > If you want it to be the default db you should
 > > > remove hsqldb-ds.xml
 > > > change the jndi name in your mysql-ds.xml to DefaultDS
 > > >
 > > > You will also need to modify the sql properties in
 > > > jms/jbossmq-service.xml as discussed last week on this list.
 > > >
 > > > Regards,
 > > > Adrian
 > > >
 > > > On Mon, 2003-10-06 at 19:15, Comtois, Pierre wrote:
 > > > > Thx. I can load JBOSS without error using the sample file
 > > > > modified
 > > > > for my settings, but I still cannot set MySQL as the default DB for
 > > > > JBOSS nor do I see my 3.0.8 driver in the connection list in the
 > > > > Hypersonic->File-Connect dropdown. Maybe I misunderstand the
 > > > > Hypersonic->expected
 > > > > result from http://www.dodtechnology.ie/jboss.htm . I am

> > > > > expecting

 > > > > that when starting the JMX console and clicking the Hypersonic
 > > > > service, that my MySql DB is the one that gets loaded by default ...

 > > > > Is this a wrong assumption ?
 > > > >
 > > > > P.S.: I can attach to my MySql DB by selecting MMM.MySql and
 > > > > modifying the driver, host/port/db and credential settings.
 > > > >
 > > > >
 > > > > >Pierre Comtois
 > > > > >Business Acceleration Services, Solutions Consulting
 > > > > >45 O'Connor Street, Suite 500    *    Ottawa, Ontario K1P 1A4
 > > > > >Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:
 > > > > >[EMAIL PROTECTED]
 > > > > >
 > > > > >
 > > > >
 > > > >
 > > > > -----Original Message-----
 > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 > > > > Sent: October 6, 2003 10:51 AM
 > > > > To: [EMAIL PROTECTED]
 > > > > Subject: RE: FW: [JBoss-user] Problem integrating MySql with
 > > > > JBOSS
 > > > >
 > > > >
 > > > > Hi,
 > > > >    i am able to connect successfully to MySQL usign JBoss. Here

 > > > > are
 > > > > the steps that u shoud follow:
 > > > >
 > > > > 1) copy the .xml file from examples and rename it mysql-ds.xml

> > > > >

> > > > Here is my data 4 example > > > > > > > > <?xml version="1.0" encoding="UTF-8"?> > > > >  > > > >  > > > >  > > > >  > > > >  > > > > > > > >  > > > >  > > > >  > > > >  <datasources> > > > > <local-tx-datasource> > > > > <jndi-name>MySqlDS</jndi-name> > > > > > > <connection-url>jdbc:mysql://localhost:3306/menagerie</connection-ur > > l> > > > > <driver-class>org.gjt.mm.mysql.Driver</driver-class> > > > > <user-name>dummy</user-name> > > > > <password>PASSWORD</password> > > > > <min-pool-size>5</min-pool-size> > > > > <security-domain>MySqlDbRealm</security-domain> > > > > </local-tx-datasource> > > > > > > > > </datasources> > > > > > > > > > > > > 2) edit the login-conf.xml . u should make an entry like this. > > > > > > > > <application-policy name = "MySqlDbRealm"> > > > > <authentication> > > > > <login-module code = > > > > "org.jboss.resource.security.ConfiguredIdentityLoginModule" > > > > flag = "required"> > > > > <module-option name = "principal">dummy</module-option> > > > > <module-option name = "userName">dummy</module-option> > > > > <module-option name = "password">PASSWORD</module-option> > > > > <module-option name = > > > > "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlD > > > > S</mod > > > > ule-option> > > > > </login-module> > > > > </authentication> > > > > </application-policy> > > > > > > > > > > > > 3) of course place mysql jdbc driver in the lib directory and make > > > > sure that the username&pwd mentioned above will work... > > > > > > > > hope this helps..it worked for me, and i have took data from > > > > samples.. > > > > > > > > hope will work also for you > > > > > > > > regards > > > > marco > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > From: ext Adrian Brock [mailto:[EMAIL PROTECTED] > > > > > Sent: 06 October, 2003 16:34 > > > > > To: [EMAIL PROTECTED] > > > > > Subject: Re: FW: [JBoss-user] Problem integrating MySql with

> > > > > > JBOSS

 > > > > >
 > > > > >
 > > > > > Please keep discussions on jboss-user.
 > > > > >
 > > > > > Re-read what I wrote last time. You can find an example
 > > > > > mysql-ds.xml in ${jboss.home}/docs/examples/jca
 > > > > >
 > > > > > Regards,
 > > > > > Adrian
 > > > > >
 > > > > > On Mon, 2003-10-06 at 14:27, Comtois, Pierre wrote:
 > > > > > > Thx for fielding my question.
 > > > > > >
 > > > > > > I did as you suggested and renamed the mysql-service.xml
 > > > > > > file to mysql-ds.xml but I still get the following error.
 > > > > > > JBOSS
 > > > > > still complains
 > > > > > > about JndiName and ManagedConnectionFactoryName attributes
 > > > > > not being found.
 > > > > > > I'm new to all this so don't know the implication of using
 > > > > > the different
 > > > > > > name, only that it's what is used in newer releases. I'm
 > > > > > using the current
 > > > > > > configuration because I'm trying to have JBOSS use my
 > > > > > TestAppDb as the
 > > > > > > default DB as detailed at:
 > > > > > http://www.dodtechnology.ie/jboss.htm . Maybe
 > > > > > > it's out of date for the versions I have.
 > > > > > >
 > > > > > >
 > > > > > >

> > > > > > > 09:06:36,228 INFO [MainDeployer] Deployed package:

 > > > > > > file:/C:/jboss-3.2.2RC4/serv
 > > > > > > er/default/deploy/OnlineBank.war 09:06:36,228 ERROR
 > > > > > > [URLDeploymentScanner] MBeanException:
 > > > > > Exception in MBean
 > > > > > > ope
 > > > > > > ration 'checkIncompleteDeployments()'
 > > > > > > Cause: Incomplete Deployment listing:
 > > > > > > Packages waiting for a deployer:
 > > > > > >   <none>
 > > > > > > Incompletely deployed packages:
 > > > > > >   <none>
 > > > > > > MBeans waiting for classes:
 > > > > > >   <none>
 > > > > > > MBeans waiting for other MBeans:
 > > > > > > [ObjectName: jboss.jca:service=LocalTxCM,name=TestAppDb
 > > > > > >  state: FAILED
 > > > > > >  I Depend On:   jboss.jca:service=LocalTxDS,name=TestAppDb
 > > > > > >
 > > > > > >  Depends On Me: org.jboss.deployment.DeploymentException:
 > > > > > Exception setting
 > > > > > > attr
 > > > > > > ibute javax.management.Attribute:
 > > > > > > name=ManagedConnectionFactoryName value=jboss.
 > > > > > > jca:service=LocalTxDS,name=TestAppDb on mbean
 > > > > > > jboss.jca:service=LocalTxCM,name=T
 > > > > > > estAppDb; - nested throwable:
 > > > > > (javax.management.AttributeNotFoundException:
 > > > > > > Writ
 > > > > > > able attribute 'ManagedConnectionFactoryName' not found),
 > > > > > ObjectName:
 > > > > > > jboss.jca:
 > > > > > > service=LocalTxDS,name=TestAppDb
 > > > > > >  state: FAILED
 > > > > > >  I Depend On:
 > > > > > >  Depends On Me:   jboss.jca:service=LocalTxCM,name=TestAppDb
 > > > > > > org.jboss.deployment.DeploymentException: No Attribute
 > > > > > found with name:
 > > > > > > JndiName
 > > > > > > ]
 > > > > > > 09:06:36,228 INFO  [URLDeploymentScanner] Started
 > > > > > > 09:06:36,288
 > > > > > > INFO [MainDeployer] Deployed package:
 > > > > > > file:/C:/jboss-3.2.2RC4/serv er/default/conf/jboss-service.xml
 > > > > > > 09:06:36,288 INFO  [Server] JBoss (MX MicroKernel) [3.2.2RC4
 > (build:
 > > > > > > CVSTag=JBos
 > > > > > > s_3_2_2_RC4 date=200309172341)] Started in 17s:836ms
 > > > > > >
 > > > > > >
 > > > > > > >Pierre Comtois
 > > > > > > >Business Acceleration Services, Solutions Consulting
 > > > > > > >45 O'Connor Street, Suite 500    *    Ottawa, Ontario K1P 1A4
 > > > > > > >Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:
 > > > > > [EMAIL PROTECTED]
 > > > > > > >
 > > > > > > >
 > > > > > >
 > > > > > >
 > > > > > >
 > > > > > > >Pierre Comtois
 > > > > > > >Business Acceleration Services, Solutions Consulting
 > > > > > > >45 O'Connor Street, Suite 500    *    Ottawa, Ontario K1P 1A4
 > > > > > > >Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:
 > > > > > [EMAIL PROTECTED]
 > > > > > > >
 > > > > > > >
 > > > > > >
 > > > > > >
 > > > > > > -----Original Message-----

> > > > > > > From: Adrian Brock [mailto:[EMAIL PROTECTED]

 > > > > > > Sent: October 4, 2003 9:12 AM
 > > > > > > To: [EMAIL PROTECTED]
 > > > > > > Subject: Re: [JBoss-user] Problem integrating MySql with
 > > > > > > JBOSS
 > > > > > >
 > > > > > >
 > > > > > > You should be using a mysql-ds.xml, an example can be found
 > > > > > > in
 > > > > > > docs/examples/jca
 > > > > > >
 > > > > > > If you want to use a mysql-service.xml you will need to move
 > > > > > > the managedconnectionfactoryname attribute. It is now on the
 > > > > > > pool mbean.
 > > > > > >
 > > > > > > Regards,
 > > > > > > Adrian
 > > > > > >
 > > > > > > On Fri, 2003-10-03 at 21:47, Comtois, Pierre wrote:
 > > > > > > > Platform: XP Pro
 > > > > > > > JBOSS 3.2.2RC4
 > > > > > > > MySQL4.0.15
 > > > > > > > Driver:mysql-connector-.jar
 > > > > > > >
 > > > > > > > I'm getting following error when starting JBOSS:
 > > > > > > > 16:21:21,673 ERROR [URLDeploymentScanner] MBeanException:
 > > > > > Exception in
 > > > > > > > MBean ope ration 'checkIncompleteDeployments()'
 > > > > > > > Cause: Incomplete Deployment listing:
 > > > > > > > Packages waiting for a deployer:
 > > > > > > >   <none>

> > > > > > > > Incompletely deployed packages:

> > > > > > > <none> > > > > > > > MBeans waiting for classes: > > > > > > > <none> > > > > > > > MBeans waiting for other MBeans: > > > > > > > [ObjectName: jboss.jca:service=LocalTxCM,name=TestAppDb > > > > > > > state: FAILED > > > > > > > I Depend On: jboss.jca:service=LocalTxDS,name=TestAppDb > > > > > > > > > > > > > > Depends On Me: org.jboss.deployment.DeploymentException: > > > > > Exception > > > > > > > setting attr ibute javax.management.Attribute: > > > > > > > name=ManagedConnectionFactoryName value=jboss. > > > > > > > jca:service=LocalTxDS,name=TestAppDb on mbean > > > > > > > jboss.jca:service=LocalTxCM,name=T > > > > > > > estAppDb; - nested throwable: > > > > > > (javax.management.AttributeNotFoundException: > > > > > > > Writ > > > > > > > able attribute 'ManagedConnectionFactoryName' not found), > > > > > ObjectName: > > > > > > > jboss.jca: > > > > > > > service=LocalTxDS,name=TestAppDb > > > > > > > state: FAILED > > > > > > > I Depend On: > > > > > > > Depends On Me: jboss.jca:service=LocalTxCM,name=TestAppDb > > > > > > > org.jboss.deployment.DeploymentException: No Attribute > > > > > found with name: > > > > > > > JndiName > > > > > > > ] > > > > > > > 16:21:21,673 INFO [URLDeploymentScanner] Started > > > > > > > > > > > > > > I've scoured the archives and google to death, but can't > > > > > nail down the > > > > > > > problem ... here are my files. If anyone can see the > > > > > problem, please > > > > > > > let me know ! > > > > > > > > > > > > > > I've added following to login-config.xml > > > > > > > > > > > > > >  > > > > > > > <application-policy name = "SecureTestAppDb"> > > > > > > > <authentication> > > > > > > > <login-module code = > > > > > > > > > > > > "org.jboss.resource.security.ConfiguredIdentityLoginModule" > > > > > flag = > > > > > > > "required"> > > > > > > > <module-option name = > > > "principal">TestAppDbAdmin</module-option> > > > > > > > <module-option name = > > > "userName">TestAppDbAdmin</module-option> > > > > > > > <module-option name = "password">eugenia</module-option> > > > > > > > <module-option name = > > > > > > > > > > > > "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,nam > > > > > e=Te > > > > > st > > > > > Ap > > > > > > > pDb</m > > > > > > > odule-option> > > > > > > > </login-module> > > > > > > > </authentication> > > > > > > > </application-policy> > > > > > > > > > > > > > > Here is my mysql-service.xml: > > > > > > > > > > > > > > <?xml version="1.0" encoding="UTF-8" ?> > > > > > > > <server> > > > > > > > <mbean > > > > > > code="org.jboss.resource.connectionmanager.LocalTxConnection

> > > > > > > Mana

 > > > > > > ge
 > > > > > > r"
 > > > > > > > name="jboss.jca:service=LocalTxCM,name=TestAppDb">
 > > > > > > > <attribute
 > > > > > name="SecurityDomainJndiName">SecureTestAppDb</attribute>
 > > > > > > > <depends
 > > > > > > > optional-attribute-name="ManagedConnectionFactoryName">
 > > > > > > > <!-- embedded mbean-->
 > > > > > > > <mbean
 code="org.jboss.resource.connectionmanager.RARDeployment"
 > > > > > > > name="jboss.jca:service=LocalTxDS,name=TestAppDb">
 > > > > > > > <attribute name="JndiName">TestAppDb</attribute>
 > > > > > > > <attribute name="ManagedConnectionFactoryProperties">
 > > > > > > > <properties>
 > > > > > > > <config-property name="ConnectionURL"
 > > > > > > >
 > > > > > >
 > > > > > type="java.lang.String">jdbc:mysql://w2czz4ch03:3306/TestAppDb
 > > > > > </config-prope
 > > > > > > > rty>
 > > > > > > > <config-property name="DriverClass"
 > > > > > > > type="java.lang.String">com.mysql.jdbc.Driver</config-property
 > > > > > > > >
 > > > > > > > </properties>
 > > > > > > > </attribute>
 > > > > > > > <!-- Below here are advanced properties -->
 > > > > > > > <!-- hack-->
 > > > > > > > <depends
 > > > > > > >
 > > > > > >
 > > > > > optional-attribute-name="OldRarDeployment">jboss.jca:service=R

> > > > > > ARDeployment,n

 > > > > > > > ame=JBoss LocalTransaction JDBC Wrapper</depends> </mbean>
 > > > > > > > </depends> <depends
 > > > > > > > optional-attribute-name="ManagedConnectionPool">
 > > > > > > > <!-- embedded mbean-->
 > > > > > > > <mbean
 > > > > > > >
 > > > > > code="org.jboss.resource.connectionmanager.JBossManagedConnect
 > > > > > ionP
 > > > > > oo
 > > > > > l"
 > > > > > > > name="jboss.jca:service=LocalTxPool,name=TestAppDb">
 > > > > > > > <attribute name="MinSize">0</attribute> <attribute
 > > > > > > > name="MaxSize">50</attribute> <attribute
 > > > > > > > name="BlockingTimeoutMillis">5000</attribute>
 > > > > > > > <attribute name="IdleTimeoutMinutes">15</attribute>
 > > > > > > > <attribute name="Criteria">ByContainer</attribute>
 > > > > > > > </mbean>
 > > > > > > > </depends>
 > > > > > > > <depends
 > > > > > > >
 > > > > > >
 > > > > > optional-attribute-name="CachedConnectionManager">jboss.jca:se
 > > > > > rvice=CachedCo
 > > > > > > > nnectionManager</depends>
 > > > > > > > <depends
 > > > > > > >
 > > > > > >
 > > > > > optional-attribute-name="JaasSecurityManagerService">jboss.sec
 > > > > > urity:service=
 > > > > > > > JaasSecurityManager</depends>
 > > > > > > > <attribute
 > > > > > name="TransactionManager">java:/TransactionManager</attribute>
 > > > > > > > <!-- make the rar deploy! hack till better deployment-->
 > > > > > > > <depends>jboss.jca:service=RARDeployer</depends>
 > > > > > > > </mbean>
 > > > > > > > </server>
 > > > > > > >
 > > > > > > > I have replaced the exsiting lines in
 > > > > > standardjbosscmp-jdbc.xml and
 > > > > > > > standardjaws.xml with:
 > > > > > > >     <datasource>java:/TestAppDb</datasource>
 > > > > > > >     <datasource-mapping>mySQL</datasource-mapping>
 > > > > > > >
 > > > > > > > I've confirmed the username/password in MySql. Not sure
 > > > > > > > why
 > > > > > > > it's complaining about the JndiName.
 > > > > > > >
 > > > > > > > Seems that I have something mismatched ... any ideas ??
 > > > > > > >
 > > > > > > > Thx for the help !!
 > > > > > > >
 > > > > > > >
 > > > > > > > > Pierre Comtois
 > > > > > > > > Business Acceleration Services, Solutions Consulting
 > > > > > > > > 45 O'Connor Street, Suite 500    *    Ottawa, Ontario K1P
 1A4
 > > > > > > > > Ph: 613-787-4649  *  FAX: 613-567-6053  *  E-Mail:
 > > > > > > > > [EMAIL PROTECTED]
 > > > > > > > >
 > > > > > > > >
 > > > > > > > >
 > > > > > > >
 > > > > > > >
 > > > > > > > -------------------------------------------------------
 > > > > > > > This sf.net email is sponsored by:ThinkGeek Welcome to
 > > > > > > > geek heaven. http://thinkgeek.com/sf
 > > > > > > > _______________________________________________

> > > > > > > > JBoss-user mailing list [EMAIL PROTECTED]

 > > > > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user
 > > > > > --
 > > > > > xxxxxxxxxxxxxxxxxxxxxxxx
 > > > > > Adrian Brock
 > > > > > Director of Support
 > > > > > Back Office
 > > > > > JBoss Group, LLC
 > > > > > xxxxxxxxxxxxxxxxxxxxxxxx
 > > > > >
 > > > > >
 > > > > >
 > > > > > -------------------------------------------------------
 > > > > > This sf.net email is sponsored by:ThinkGeek
 > > > > > Welcome to geek heaven.
 > > > > > http://thinkgeek.com/sf
 > > > > > _______________________________________________
 > > > > > JBoss-user mailing list [EMAIL PROTECTED]
 > > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user
 > > > > >
 > > > >
 > > > >
 > > > > -------------------------------------------------------
 > > > > This sf.net email is sponsored by:ThinkGeek
 > > > > Welcome to geek heaven.
 > > > > http://thinkgeek.com/sf
 > > > > _______________________________________________
 > > > > JBoss-user mailing list [EMAIL PROTECTED]
 > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user
 > > > >
 > > > >
 > > > > -------------------------------------------------------
 > > > > This sf.net email is sponsored by:ThinkGeek

> > > > > Welcome to geek heaven.

 > > > > http://thinkgeek.com/sf
 > > > > _______________________________________________
 > > > > JBoss-user mailing list [EMAIL PROTECTED]
 > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user

--
xxxxxxxxxxxxxxxxxxxxxxxx
Adrian Brock
Director of Support
Back Office
JBoss Group, LLC
xxxxxxxxxxxxxxxxxxxxxxxx

-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

--
 Michael Klem <[EMAIL PROTECTED]>    626-296-3027


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

Reply via email to