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"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: mysql-ds.xml,v 1.1 2002/07/22 22:57:24 d_jencks Exp $ -->
<!-- ==================================================================== -->
<!-- Datasource config for MySQL using 2.0.11 driver -->
<!-- ==================================================================== -->
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/menagerie</connection-url>
<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=MySqlDS</module-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
> > >
> > > <!-- Security domain for MySQL -->
> > > <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,name=TestAp
> > > 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.LocalTxConnectionManager"
> > > 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.JBossManagedConnectionPool"
> > > 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
