RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
For InnoDB, simply add type=InnoDB at the end of the create statement ... CREATE TABLE tableX (.) type=InnoDB I realized that about the Hypersonic bean after I sent my reply ... Am I right in thinking that I can setup the Hypersonic GUI to open my MySql DB when it open ... I see there is a setting called DATABASE set to default and I suspect that is what I have to change for that to happen. On a related topic, if I choose Connect from the File-Connect, I do not see an entry for the MySql configuration I have ... I have to select MM.MySql and modify the settings (which never get saved). What file would I need to modify so I don't need to re-enter that information ? Here are notes you might find useful. I've compiled them from all over the web about setting up MySql for InnoDB ... I'm documenting all the steps so it's repeatable. MySql InnoDB Configuration - Run winmysqladmin.exe (under bin subfolder): 1. First time (when my.ini does not exist under Windows directory, e.g. C:\WinNT), you will be prompted for username/password. Enter your choice 2. Its window will come up and then minimize into System Tray. Bring it up by: Right click on System Tray icon - Option Show me. 3. By default, mysqld is used which has only ISAM, which does NOT support transaction. To use mysqld-max with InnoDB or BDB enabled (supporting transactions), configure my.ini as following: Select tab my.ini Setup - Select mysqld-max - In editor for my.ini: [mysqld] ... [WinMySQLadmin] ... Add the following before line [WinMySQLadmin], innodb_data_home_dir = C:\mysql\ibdata innodb_data_file_path = ibdata1:500M;ibdata2:500M set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = C:\mysql\iblogs innodb_log_arch_dir = C:\mysql\iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 * The above specifies that two 500MB database files be created at C:\mysql3.23\ibdata, and three 10MB log files created at C:\mysql3.23\iblogs. Then click Save Modification to save the changes into my.ini (under e.g. C:\WinNT). 4. Manually create the folder ibdata location and iblogs location (in the above example, it's C:\mysql\ibdata and C:\mysql\iblogs). 5. Start the server (mysql service): Right click on the window - Option Win NT - item Install the service Then Right click again - Option Win NT - item Start the service. It will take a moment to create the database files and log files as configured. Test the configuration: 1. Make sure service Mysql is started. 2. Try to login. - Open a Command window, try mysql -u username -p. You'll be prompted for password (use the one you specified in my.ini, e.g. username/password). - You are in mysql console. Try SQL SELECT user(); or SELECT 1+1;. (Be sure to end your SQL with semicolon.) 3. Add a user - username username, and password password. In mysql console, enter SQL - GRANT ALL PRIVILEGES ON test.* TO username@localhost IDENTIFIED BY 'password'; 4. Login to database test as user username: - In DOS, enter mysql -u username -p test (Note: test here is the database name, NOT the password. Password will be prompted.) - After giving password, you should be in test as username: - Try SELECT user(); and you should get username@localhost. - Try creating a table and put some data: CREATE TABLE table1 (id INTEGER NOT NULL, data VARCHAR(100),PRIMARY KEY (id)) type=InnoDB; INSERT INTO table1 (id, data) VALUES (1, 'one'); INSERT INTO table1 (id, data) VALUES (2, 'two'); INSERT INTO table1 (id, data) VALUES (3, 'three'); SELECT * FROM table1; Note: * The default CREATE TABLE creates table as type ISAM, which does not support transaction. Include clause type=InnoDB in your CREATE TABLE statement as the above, then your table will have transaction support. * By default, AUTOCOMMIT is on. To turn it off, do SET AUTOCOMMIT=0;. 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 4:25 PM To: [EMAIL PROTECTED] Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS 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 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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
Same for me ... 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: Guy Rouillier [mailto:[EMAIL PROTECTED] Sent: October 7, 2003 9:12 PM To: [EMAIL PROTECTED] Subject: Re: FW: [JBoss-user] Problem integrating MySql with JBOSS Michael Klem wrote: 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; That has not been my experience. I have MySQL 4 on both Windows 2000 and Linux, and if I don't specify a type, tables end up as MyISAM. -- Guy Rouillier --- 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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
Since 3.2.1 (or at least 3.2.2 rc2 :-) there is the possibility to execute arbitrary sql commands after create table. So you can specify a alter table foo type=innodb there. See Jboss-Change-Note 743570 http://sourceforge.net/tracker/?func=detailaid=743570group_id=22866atid=381174 Heiko -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Comtois, Pierre Sent: Wednesday, October 08, 2003 3:44 PM To: '[EMAIL PROTECTED]' Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS For InnoDB, simply add type=InnoDB at the end of the create statement ... CREATE TABLE tableX (.) type=InnoDB I realized that about the Hypersonic bean after I sent my reply ... Am I right in thinking that I can setup the Hypersonic GUI to open my MySql DB when it open ... I see there is a setting called DATABASE set to default and I suspect that is what I have to change for that to happen. On a related topic, if I choose Connect from the File-Connect, I do not see an entry for the MySql configuration I have ... I have to select MM.MySql and modify the settings (which never get saved). What file would I need to modify so I don't need to re-enter that information ? Here are notes you might find useful. I've compiled them from all over the web about setting up MySql for InnoDB ... I'm documenting all the steps so it's repeatable. MySql InnoDB Configuration - Run winmysqladmin.exe (under bin subfolder): 1. First time (when my.ini does not exist under Windows directory, e.g. C:\WinNT), you will be prompted for username/password. Enter your choice 2. Its window will come up and then minimize into System Tray. Bring it up by: Right click on System Tray icon - Option Show me. 3. By default, mysqld is used which has only ISAM, which does NOT support transaction. To use mysqld-max with InnoDB or BDB enabled (supporting transactions), configure my.ini as following: Select tab my.ini Setup - Select mysqld-max - In editor for my.ini: [mysqld] ... [WinMySQLadmin] ... Add the following before line [WinMySQLadmin], innodb_data_home_dir = C:\mysql\ibdata innodb_data_file_path = ibdata1:500M;ibdata2:500M set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = C:\mysql\iblogs innodb_log_arch_dir = C:\mysql\iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 * The above specifies that two 500MB database files be created at C:\mysql3.23\ibdata, and three 10MB log files created at C:\mysql3.23\iblogs. Then click Save Modification to save the changes into my.ini (under e.g. C:\WinNT). 4. Manually create the folder ibdata location and iblogs location (in the above example, it's C:\mysql\ibdata and C:\mysql\iblogs). 5. Start the server (mysql service): Right click on the window - Option Win NT - item Install the service Then Right click again - Option Win NT - item Start the service. It will take a moment to create the database files and log files as configured. Test the configuration: 1. Make sure service Mysql is started. 2. Try to login. - Open a Command window, try mysql -u username -p. You'll be prompted for password (use the one you specified in my.ini, e.g. username/password). - You are in mysql console. Try SQL SELECT user(); or SELECT 1+1;. (Be sure to end your SQL with semicolon.) 3. Add a user - username username, and password password. In mysql console, enter SQL - GRANT ALL PRIVILEGES ON test.* TO username@localhost IDENTIFIED BY 'password'; 4. Login to database test as user username: - In DOS, enter mysql -u username -p test (Note: test here is the database name, NOT the password. Password will be prompted.) - After giving password, you should be in test as username: - Try SELECT user(); and you should get username@localhost. - Try creating a table and put some data: CREATE TABLE table1 (id INTEGER NOT NULL, data VARCHAR(100),PRIMARY KEY (id)) type=InnoDB; INSERT INTO table1 (id, data) VALUES (1, 'one'); INSERT INTO table1 (id, data) VALUES (2, 'two'); INSERT INTO table1 (id, data) VALUES (3, 'three'); SELECT * FROM table1; Note: * The default CREATE TABLE creates table as type ISAM, which does not support transaction. Include clause type=InnoDB in your CREATE TABLE statement as the above, then your table will have transaction support. * By default, AUTOCOMMIT is on. To turn it off, do SET AUTOCOMMIT=0;. 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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
No ... 3.2.2RC4 ... The date was an error on my part ... I extracted the orginal from the zip file and will try again ... 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=48thread=39416message=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=MessageCachejboss.mq:service=MessageCache/ depend s depends optional-attribute-name=ConnectionManagerjboss.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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
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. 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. 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=48thread=39416message=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
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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
I found a reference where a user ended up creating them manually which I'm thinking of doing to go forward. If that doesn't work, then I'll use the file method, but I hate giving up on it ... 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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
Finally resolved the exception issue: 1. I created the tables manually and for my appl. Made them of type InnoDB 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 :-) 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 ... 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(); % lia href=HtmlAdaptor?action=inspectMBeanname=%= 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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
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 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(); % lia href=HtmlAdaptor?action=inspectMBeanname=%= 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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
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(); % lia href=HtmlAdaptor?action=inspectMBeanname=%= 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
Re: FW: [JBoss-user] Problem integrating MySql with JBOSS
Forgot to mention, my interpretation of what the docs said is that you no longer need to specify a table type. MySQL will treat the tables as InnoDB tables as a default. Just my .02 At 9:50 PM -0700 10/7/03, Michael Klem wrote: Just quoting from the MySQL docs. I will verify for myself too. I am using 4.0.14 At 9:12 PM -0400 10/7/03, Guy Rouillier wrote: Michael Klem wrote: 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; That has not been my experience. I have MySQL 4 on both Windows 2000 and Linux, and if I don't specify a type, tables end up as MyISAM. -- Guy Rouillier --- 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 -- 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
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 =
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-nameMySqlDS/jndi-name connection-urljdbc:mysql://localhost:3306/menagerie/connection-url driver-classorg.gjt.mm.mysql.Driver/driver-class user-namedummy/user-name passwordPASSWORD/password min-pool-size5/min-pool-size security-domainMySqlDbRealm/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 = principaldummy/module-option module-option name = userNamedummy/module-option module-option name = passwordPASSWORD/module-option module-option name = managedConnectionFactoryNamejboss.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 usernamepwd 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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
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 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-nameMySqlDS/jndi-name connection-urljdbc:mysql://localhost:3306/menagerie/connection-url driver-classorg.gjt.mm.mysql.Driver/driver-class user-namedummy/user-name passwordPASSWORD/password min-pool-size5/min-pool-size security-domainMySqlDbRealm/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 = principaldummy/module-option module-option name = userNamedummy/module-option module-option name = passwordPASSWORD/module-option module-option name = managedConnectionFactoryNamejboss.jca:service=LocalTxCM,name=MySqlDS/mod ule-option /login-module /authentication /application-policy 3) of course place mysql jdbc driver in the lib directory and make sure that the usernamepwd 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
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 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-nameMySqlDS/jndi-name connection-urljdbc:mysql://localhost:3306/menagerie/connection-url driver-classorg.gjt.mm.mysql.Driver/driver-class user-namedummy/user-name passwordPASSWORD/password min-pool-size5/min-pool-size security-domainMySqlDbRealm/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 = principaldummy/module-option module-option name = userNamedummy/module-option module-option name = passwordPASSWORD/module-option module-option name = managedConnectionFactoryNamejboss.jca:service=LocalTxCM,name=MySqlDS/mod ule-option /login-module /authentication /application-policy 3) of course place mysql jdbc driver in the lib directory and make sure that the usernamepwd 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
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=48thread=39416message=3803454q=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=MessageCachejboss.mq:service=MessageCache/depend s depends optional-attribute-name=ConnectionManagerjboss.jca:service=LocalTxCM,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 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-nameMySqlDS/jndi-name connection-urljdbc:mysql://localhost:3306/menagerie/connection-url driver-classorg.gjt.mm.mysql.Driver/driver-class user-namedummy/user-name passwordPASSWORD/password min-pool-size5/min-pool-size security-domainMySqlDbRealm/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 = principaldummy/module-option module-option name = userNamedummy/module-option module-option name = passwordPASSWORD/module-option module-option name = managedConnectionFactoryNamejboss.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 usernamepwd 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
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=48thread=39416message=3803454q=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=MessageCachejboss.mq:service=MessageCache/depend s depends optional-attribute-name=ConnectionManagerjboss.jca:service=LocalTxCM,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 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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
I'll point you at last week's thread instead. Make sure you check the other comments. You can use search just as easily as I can. http://www.mail-archive.com/[EMAIL PROTECTED]/msg32527.html Regards, Adrian On Mon, 2003-10-06 at 21:13, Comtois, Pierre wrote: 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=48thread=39416message=3803454q=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=MessageCachejboss.mq:service=MessageCache/depend s depends optional-attribute-name=ConnectionManagerjboss.jca:service=LocalTxCM,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 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-nameMySqlDS/jndi-name connection-urljdbc:mysql://localhost:3306/menagerie/connection-url driver-classorg.gjt.mm.mysql.Driver/driver-class user-namedummy/user-name passwordPASSWORD/password min-pool-size5/min-pool-size security-domainMySqlDbRealm/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 = principaldummy/module-option module-option name = userNamedummy/module-option module-option name = passwordPASSWORD/module-option module-option name = managedConnectionFactoryNamejboss.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 usernamepwd mentioned above will work... hope
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
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=48thread=39416message=3803454q=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=MessageCachejboss.mq:service=MessageCache/depend s depends optional-attribute-name=ConnectionManagerjboss.jca:service=LocalTxCM,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 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-nameMySqlDS/jndi-name connection-urljdbc:mysql://localhost:3306/menagerie/connection-url driver-classorg.gjt.mm.mysql.Driver/driver-class user-namedummy/user-name passwordPASSWORD/password min-pool-size5/min-pool-size security
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
I did use search ... Found the link you refer to and copied the file ... I'm also looking at mysql-jdbc2-services file ... See posting ... Messages are crossing ... 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:42 PM To: [EMAIL PROTECTED] Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS I'll point you at last week's thread instead. Make sure you check the other comments. You can use search just as easily as I can. http://www.mail-archive.com/[EMAIL PROTECTED]/msg32527.html Regards, Adrian On Mon, 2003-10-06 at 21:13, Comtois, Pierre wrote: 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=48thread=39416message=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=MessageCachejboss.mq:service=MessageCache/ depend s depends optional-attribute-name=ConnectionManagerjboss.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-nameMySqlDS/jndi-name connection-urljdbc:mysql://localhost:3306/menagerie/connection-url driver-classorg.gjt.mm.mysql.Driver/driver-class user-namedummy/user-name passwordPASSWORD/password min-pool-size5/min-pool-size security-domainMySqlDbRealm/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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
Must be tired ... Got it from the JBOSS archives archives at http://www.jboss.org/thread.jsp?forum=48thread=39416message=3803454q=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=48thread=39416message=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=MessageCachejboss.mq:service=MessageCache/ depend s depends optional-attribute-name=ConnectionManagerjboss.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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
Default install puts it in ... It's dated June 10/2003 ... 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=48thread=39416message=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=MessageCachejboss.mq:service=MessageCache/ depend s depends optional-attribute-name=ConnectionManagerjboss.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
RE: FW: [JBoss-user] Problem integrating MySql with JBOSS
You don't need to modify jbossmq-service.xml There should be an original copy in server/all/deploy/jms Regards, Adrian On Mon, 2003-10-06 at 22:34, Comtois, Pierre wrote: Must be tired ... Got it from the JBOSS archives archives at http://www.jboss.org/thread.jsp?forum=48thread=39416message=3803454q=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=48thread=39416message=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=MessageCachejboss.mq:service=MessageCache/ depend s depends optional-attribute-name=ConnectionManagerjboss.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
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=48thread=39416message=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=MessageCachejboss.mq:service=MessageCache/ depend s depends optional-attribute-name=ConnectionManagerjboss.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