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=RARDeployment,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:service=CachedCo
> > nnectionManager</depends>
> > <depends
> >
> optional-attribute-name="JaasSecurityManagerService">jboss.security: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
