Must be tired ... Got it from the JBOSS archives archives at http://www.jboss.org/thread.jsp?forum=48&thread=39416&message=3803454&q=jbos smq-service.xml#3803454
>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"?> > > <!-- > > ==================================================================== > > = > > --> > > <!-- > > --> > > <!-- 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=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 > > > > > > > > > > <!-- 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=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.LocalTxConnectionMana > > > > 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.JBossManagedConnectionP > > > 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 ------------------------------------------------------- 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