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=detail&aid=743570&group_id=22866&atid=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: 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 in the mysql-ds > connection-url attribute > > ... I put it back to localhost > > > > ps: I would have thought that it would be better to specify > a computer > > name as opposed to localhost ... ? > > > > > > Next item up for bid ... I want to access the newly configured DB > > using the JBoss console ( > http://localhost:8080/jmx-console/index.jsp > > ). Seems that now I have no link in jmx-console to access the > > Hypwersonic service ... The link to it is gone ... > > It will be in the jboss.jca section. > If you didn't deploy hsqldb-ds.xml, of course you won't see it on the > console. > > Regards, > Adrian > > > Is this normal ? Am I missing something ? My thought is > that I have to > > configures the jmx ... > > > > Looking at displayMBeans.jsp, that the mbean is missing in the > > MBeanData array ... <% > > MBeanData[] data = domainData.getData(); > > for(int d = 0; d < data.length; d ++) > > { > > String name = data[d].getObjectName().toString(); > > String properties = data[d].getNameProperties(); > > %> > > <li><a href="HtmlAdaptor?action=inspectMBean&name=<%= > > URLEncoder.encode(name) %>"><%= > URLDecoder.decode(properties) %></a></li> > > <% > > > > > > Ideas ? > > > > >Pierre Comtois > > >Business Acceleration Services, Solutions Consulting > > >45 O'Connor Street, Suite 500 * Ottawa, Ontario K1P 1A4 > > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: > > >[EMAIL PROTECTED] > > > > > > > > > > > > -----Original Message----- > > From: Adrian Brock [mailto:[EMAIL PROTECTED] > > Sent: October 7, 2003 11:01 AM > > To: [EMAIL PROTECTED] > > Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS > > > > > > Some guy had the same problem last week and resolved it, > > but he seems to have vanished from this list when somebody > > else has a problem. :-( > > > > On Tue, 2003-10-07 at 15:34, Comtois, Pierre wrote: > > > Making progress ... but ever s-o-o-o-o slowly ! > > > > > > It would seem that the persistence tables specified by the > > > mysql-jdbc2-service.xml file are not getting creating > resulting in > > > connection errors on startup. I found nothing in the > archives that > > > helped ... > > > > > > CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID > > > INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID > INTEGER, > > > TXOP CHAR(1), MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, > DESTINATION)) > > > CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS > (TXID INTEGER) > > > CREATE_TABLES_ON_STARTUP = TRUE > > > > > > What could be preventing these from getting created ... I've now > > > changed user temporarily to root to remove authorization > issues from > > > the equation. If I have to, I'll create them by hand, but > this likely > > > indicates another problem. > > > > > > > Please wait... I'm trying to hack your machine so I can see > the error > > message. :-) > > > > > P.S. Is there an up-to-date document anywhere that details how to > > > integrate MySQL 4.x with JBOSS 3.2.2RC4? I've found stuff > with Google > > > but haven't found anything up-to-date and accurate. I'm > setting up a > > > pc with around 12 different development modules/tools and > this piece > > > is taking much more time than it should/can afford to get > going on the > > > actual development phase. Maybe what I want to do is a > rarity, but I > > > don't think it is. A short white paper would cost cycles > initially, > > > but would likely pay off over the long haul. > > > > > > > Remove mysql-jdbc2.xml and use the file version. > > Come back to it when you are sure mysql works. > > > > I'm currently preparing an enhanced jbossmq section for the > admin docs > > with the 3.2.2 release. > > > > Regards, > > Adrian > > > > > > > > >Pierre Comtois > > > >Business Acceleration Services, Solutions Consulting > > > >45 O'Connor Street, Suite 500 * Ottawa, Ontario K1P 1A4 > > > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: > > > >[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > -----Original Message----- > > > From: Adrian Brock [mailto:[EMAIL PROTECTED] > > > Sent: October 6, 2003 7:40 PM > > > To: [EMAIL PROTECTED] > > > Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS > > > > > > > > > On Mon, 2003-10-06 at 22:23, Comtois, Pierre wrote: > > > > Default install puts it in ... It's dated June 10/2003 ... > > > > > > > > > > Ok, so you are using 3.2.1? > > > > > > Copy the SQL Properties from the mysql-jdbc2-service.xml into > > > jbossmq-service.xml - replacing the hsqldb sql properties. > > > > > > Where is the difficulty? > > > There is an MBean called the PersistenceManager that > > > takes a parameter called SQLProperties. > > > By default it references DefaultDS and uses hsqldb sql. > > > You need to change it to match your jndi name and mysql sql > > > statements. > > > > > > It is harder with 3.2.1 > > > > > > With 3.2.2 it will be to just delete hsqldb-jdbc2-service.xml and > > > replace it with mysql-jdbc2-service.xml > > > > > > Regards, > > > Adrian > > > > > > > > > > > >Pierre Comtois > > > > >Business Acceleration Services, Solutions Consulting > > > > >45 O'Connor Street, Suite 500 * Ottawa, Ontario K1P 1A4 > > > > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: Adrian Brock [mailto:[EMAIL PROTECTED] > > > > Sent: October 6, 2003 4:56 PM > > > > To: [EMAIL PROTECTED] > > > > Subject: RE: FW: [JBoss-user] Problem integrating MySql > with JBOSS > > > > > > > > > > > > Where did you get jbossmq-service.xml from? > > > > > > > > The persistence manager has been removed from that > file. It is now > > > > in x-jdbc2-service.xml > > > > > > > > Supposedly to make it easier to drop in a different > implementation > > > > like you are trying :-) > > > > > > > > Regards, > > > > Adrian > > > > > > > > On Mon, 2003-10-06 at 21:47, Comtois, Pierre wrote: > > > > > I've also copied mysql-jdbc2-service.xml from the examples to > > > > > the deploy/jms folder and deleted the hsql version. > > > > > > > > > > I'm still getting an error: > > > > > > > > > > 16:41:14,011 INFO [MainDeployer] Starting deployment of > > > > > package: > > > > > > file:/C:/jboss-3.2.2RC4/server/default/deploy/jms/jbossmq-service.xml > > > > > 16:41:14,322 INFO [ServiceConfigurator] Problem > configuring service > > > > > > jboss.mq:service=PersistenceManager > > > > > org.jboss.deployment.DeploymentException: Exception setting > attribute > > > > > javax.management.Attribute: name=MessageCache > > > > > value=jboss.mq:service=MessageCache on mbean > > > > > jboss.mq:service=PersistenceManager; - nested throwable: > > > > > (java.lang.UnsupportedOperationException: This is now > set on the > > > > > destination > > > > > manager) > > > > > at > > > > > > > > > > > > > org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurato > > > r. > > > java:4 > > > > > 78) > > > > > > > > > > > > > > > Sounds like I should remove name=MessageCache > > > > > value=jboss.mq:service=MessageCache attribute .. > Would that be > > > > > right ? > > > > > > > > > > > > > > > >Pierre Comtois > > > > > >Business Acceleration Services, Solutions Consulting > > > > > >45 O'Connor Street, Suite 500 * Ottawa, Ontario K1P 1A4 > > > > > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: > > > > > >[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > From: Comtois, Pierre > > > > > Sent: October 6, 2003 4:13 PM > > > > > To: '[EMAIL PROTECTED]' > > > > > Subject: RE: FW: [JBoss-user] Problem integrating MySql with > > > > > JBOSS > > > > > > > > > > > > > > > I deleted hsqldb-ds.xml and changed jndi name. > > > > > I'm looking at what I'd need to change ... > > > > > > > > > > My install didn't have any reference to persistence in > > > > > jbossmq-service.xmlso copied the one I found at > > > > > > http://www.jboss.org/thread.jsp?forum=48&thread=39416&message=38 > > > > > 03454& > > > > > q=jbos > > > > > smq-service.xml#3803454 and put it in the > default/deploy/jms folder. > > > > > > > > > > I found a section to : > > > > > > > > > > <mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager" > > > > > name="jboss.mq:service=PersistenceManager"> > > > > > <depends > > > > > > optional-attribute-name="MessageCache">jboss.mq:service=MessageC > > > > > ache</ > > > > > depend > > > > > s> > > > > > <depends > > > > > > optional-attribute-name="ConnectionManager">jboss.jca:service=Lo > > > > > calTxC > > > > > M,name > > > > > =DefaultDS</depends> > > > > > <attribute name="SqlProperties"> > > > > > > > > > > But it only includes SQL statements that do not seem to be > > > > > configurable specifically for my DB. Likely there are other > > > > > attribs, but can't find any mention of any in the archives. > > > > > > > > > > Can you point me where ? > > > > > > > > > > Thx ... > > > > > > > > > > > > > > > >Pierre Comtois > > > > > >Business Acceleration Services, Solutions Consulting > > > > > >45 O'Connor Street, Suite 500 * Ottawa, Ontario K1P 1A4 > > > > > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: > > > > > >[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > From: Adrian Brock [mailto:[EMAIL PROTECTED] > > > > > Sent: October 6, 2003 2:24 PM > > > > > To: [EMAIL PROTECTED] > > > > > Subject: RE: FW: [JBoss-user] Problem integrating MySql with > > > > > JBOSS > > > > > > > > > > > > > > > If you want it to be the default db you should > > > > > remove hsqldb-ds.xml > > > > > change the jndi name in your mysql-ds.xml to DefaultDS > > > > > > > > > > You will also need to modify the sql properties in > > > > > jms/jbossmq-service.xml as discussed last week on this list. > > > > > > > > > > Regards, > > > > > Adrian > > > > > > > > > > On Mon, 2003-10-06 at 19:15, Comtois, Pierre wrote: > > > > > > Thx. I can load JBOSS without error using the sample file > > > > > > modified > > > > > > for my settings, but I still cannot set MySQL as > the default DB > for > > > > > > JBOSS nor do I see my 3.0.8 driver in the > connection list in the > > > > > > Hypersonic->File-Connect dropdown. Maybe I > misunderstand the > > > > > > Hypersonic->expected > > > > > > result from http://www.dodtechnology.ie/jboss.htm . I am > > > > > > expecting > > > > > > that when starting the JMX console and clicking the > Hypersonic > > > > > > service, that my MySql DB is the one that gets > loaded by default > ... > > > > > > > > Is this a wrong assumption ? > > > > > > > > > > > > P.S.: I can attach to my MySql DB by selecting > MMM.MySql and > > > > > > modifying the driver, host/port/db and credential settings. > > > > > > > > > > > > > > > > > > >Pierre Comtois > > > > > > >Business Acceleration Services, Solutions Consulting > > > > > > >45 O'Connor Street, Suite 500 * Ottawa, > Ontario K1P 1A4 > > > > > > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: > > > > > > >[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > From: [EMAIL PROTECTED] > > > > > > [mailto:[EMAIL PROTECTED] > > > > > > Sent: October 6, 2003 10:51 AM > > > > > > To: [EMAIL PROTECTED] > > > > > > Subject: RE: FW: [JBoss-user] Problem integrating > MySql with > > > > > > JBOSS > > > > > > > > > > > > > > > > > > Hi, > > > > > > i am able to connect successfully to MySQL > usign JBoss. Here > > > > > > > > are > > > > > > the steps that u shoud follow: > > > > > > > > > > > > 1) copy the .xml file from examples and rename it > mysql-ds.xml > > > > > > > > > > > > Here is my data 4 example > > > > > > > > > > > > <?xml version="1.0" encoding="UTF-8"?> > > > > > > <!-- > > > > > > > ============================================================== > > > > > > ====== > > > > > > = > > > > > > --> > > > > > > <!-- > > > > > > --> > > > > > > <!-- JBoss Server Configuration > > > > > > --> > > > > > > <!-- > > > > > > --> > > > > > > <!-- > > > > > > > ============================================================== > > > > > > ====== > > > > > > = > > > > > > --> > > > > > > > > > > > > <!-- $Id: mysql-ds.xml,v 1.1 2002/07/22 22:57:24 > d_jencks Exp > > > > > > $ > > > > > > --> > > > > > > <!-- > > > > > > > ==================================================================== > > > > > > --> > > > > > > <!-- Datasource config for MySQL using 2.0.11 driver > > > > > > --> > > > > > > <!-- > > > > > > > ============================================================== > > > > > > ====== > > > > > > --> <datasources> > > > > > > <local-tx-datasource> > > > > > > <jndi-name>MySqlDS</jndi-name> > > > > > > > > > > > <connection-url>jdbc:mysql://localhost:3306/menagerie</connection- > > > > ur > > > > l> > > > > > > <driver-class>org.gjt.mm.mysql.Driver</driver-class> > > > > > > <user-name>dummy</user-name> > > > > > > <password>PASSWORD</password> > > > > > > <min-pool-size>5</min-pool-size> > > > > > > <security-domain>MySqlDbRealm</security-domain> > > > > > > </local-tx-datasource> > > > > > > > > > > > > </datasources> > > > > > > > > > > > > > > > > > > 2) edit the login-conf.xml . u should make an entry > like this. > > > > > > > > > > > > <application-policy name = "MySqlDbRealm"> > > > > > > <authentication> > > > > > > <login-module code = > > > > > > "org.jboss.resource.security.ConfiguredIdentityLoginModule" > > > > > > flag = "required"> > > > > > > <module-option name = > "principal">dummy</module-option> > > > > > > <module-option name = > "userName">dummy</module-option> > > > > > > <module-option name = > > "password">PASSWORD</module-option> > > > > > > <module-option name = > > > > > > > > > "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlD > > > > > > S</mod > > > > > > ule-option> > > > > > > </login-module> > > > > > > </authentication> > > > > > > </application-policy> > > > > > > > > > > > > > > > > > > 3) of course place mysql jdbc driver in the lib > directory and make > > > > > > sure that the username&pwd mentioned above will work... > > > > > > > > > > > > hope this helps..it worked for me, and i have took > data from > > > > > > samples.. > > > > > > > > > > > > hope will work also for you > > > > > > > > > > > > regards > > > > > > marco > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > From: ext Adrian Brock [mailto:[EMAIL PROTECTED] > > > > > > > Sent: 06 October, 2003 16:34 > > > > > > > To: [EMAIL PROTECTED] > > > > > > > Subject: Re: FW: [JBoss-user] Problem integrating > MySql with > > > > > > > JBOSS > > > > > > > > > > > > > > > > > > > > > Please keep discussions on jboss-user. > > > > > > > > > > > > > > Re-read what I wrote last time. You can find an example > > > > > > > mysql-ds.xml in ${jboss.home}/docs/examples/jca > > > > > > > > > > > > > > Regards, > > > > > > > Adrian > > > > > > > > > > > > > > On Mon, 2003-10-06 at 14:27, Comtois, Pierre wrote: > > > > > > > > Thx for fielding my question. > > > > > > > > > > > > > > > > I did as you suggested and renamed the mysql-service.xml > > > > > > > > file to mysql-ds.xml but I still get the > following error. > > > > > > > > JBOSS > > > > > > > still complains > > > > > > > > about JndiName and ManagedConnectionFactoryName > attributes > > > > > > > not being found. > > > > > > > > I'm new to all this so don't know the > implication of using > > > > > > > the different > > > > > > > > name, only that it's what is used in newer releases. I'm > > > > > > > using the current > > > > > > > > configuration because I'm trying to have JBOSS use my > > > > > > > TestAppDb as the > > > > > > > > default DB as detailed at: > > > > > > > http://www.dodtechnology.ie/jboss.htm . Maybe > > > > > > > > it's out of date for the versions I have. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 09:06:36,228 INFO [MainDeployer] Deployed package: > > > > > > > > file:/C:/jboss-3.2.2RC4/serv > > > > > > > > er/default/deploy/OnlineBank.war 09:06:36,228 ERROR > > > > > > > > [URLDeploymentScanner] MBeanException: > > > > > > > Exception in MBean > > > > > > > > ope > > > > > > > > ration 'checkIncompleteDeployments()' > > > > > > > > Cause: Incomplete Deployment listing: > > > > > > > > Packages waiting for a deployer: > > > > > > > > <none> > > > > > > > > Incompletely deployed packages: > > > > > > > > <none> > > > > > > > > MBeans waiting for classes: > > > > > > > > <none> > > > > > > > > MBeans waiting for other MBeans: > > > > > > > > [ObjectName: jboss.jca:service=LocalTxCM,name=TestAppDb > > > > > > > > state: FAILED > > > > > > > > I Depend On: > jboss.jca:service=LocalTxDS,name=TestAppDb > > > > > > > > > > > > > > > > Depends On Me: > org.jboss.deployment.DeploymentException: > > > > > > > Exception setting > > > > > > > > attr > > > > > > > > ibute javax.management.Attribute: > > > > > > > > name=ManagedConnectionFactoryName value=jboss. > > > > > > > > jca:service=LocalTxDS,name=TestAppDb on mbean > > > > > > > > jboss.jca:service=LocalTxCM,name=T > > > > > > > > estAppDb; - nested throwable: > > > > > > > (javax.management.AttributeNotFoundException: > > > > > > > > Writ > > > > > > > > able attribute 'ManagedConnectionFactoryName' > not found), > > > > > > > ObjectName: > > > > > > > > jboss.jca: > > > > > > > > service=LocalTxDS,name=TestAppDb > > > > > > > > state: FAILED > > > > > > > > I Depend On: > > > > > > > > Depends On Me: > jboss.jca:service=LocalTxCM,name=TestAppDb > > > > > > > > org.jboss.deployment.DeploymentException: No Attribute > > > > > > > found with name: > > > > > > > > JndiName > > > > > > > > ] > > > > > > > > 09:06:36,228 INFO [URLDeploymentScanner] Started > > > > > > > > 09:06:36,288 > > > > > > > > INFO [MainDeployer] Deployed package: > > > > > > > > file:/C:/jboss-3.2.2RC4/serv > er/default/conf/jboss-service.xml > > > > > > > > 09:06:36,288 INFO [Server] JBoss (MX > MicroKernel) [3.2.2RC4 > > > (build: > > > > > > > > CVSTag=JBos > > > > > > > > s_3_2_2_RC4 date=200309172341)] Started in 17s:836ms > > > > > > > > > > > > > > > > > > > > > > > > >Pierre Comtois > > > > > > > > >Business Acceleration Services, Solutions Consulting > > > > > > > > >45 O'Connor Street, Suite 500 * Ottawa, > Ontario K1P 1A4 > > > > > > > > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: > > > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >Pierre Comtois > > > > > > > > >Business Acceleration Services, Solutions Consulting > > > > > > > > >45 O'Connor Street, Suite 500 * Ottawa, > Ontario K1P 1A4 > > > > > > > > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: > > > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > From: Adrian Brock [mailto:[EMAIL PROTECTED] > > > > > > > > Sent: October 4, 2003 9:12 AM > > > > > > > > To: [EMAIL PROTECTED] > > > > > > > > Subject: Re: [JBoss-user] Problem integrating MySql with > > > > > > > > JBOSS > > > > > > > > > > > > > > > > > > > > > > > > You should be using a mysql-ds.xml, an example can be > > > > > > > > found > > > > > > > > in > > > > > > > > docs/examples/jca > > > > > > > > > > > > > > > > If you want to use a mysql-service.xml you will need to > > > > > > > > move > > > > > > > > the managedconnectionfactoryname attribute. It > is now on the > > > > > > > > pool mbean. > > > > > > > > > > > > > > > > Regards, > > > > > > > > Adrian > > > > > > > > > > > > > > > > On Fri, 2003-10-03 at 21:47, Comtois, Pierre wrote: > > > > > > > > > Platform: XP Pro > > > > > > > > > JBOSS 3.2.2RC4 > > > > > > > > > MySQL4.0.15 > > > > > > > > > Driver:mysql-connector-.jar > > > > > > > > > > > > > > > > > > I'm getting following error when starting JBOSS: > > > > > > > > > 16:21:21,673 ERROR [URLDeploymentScanner] > MBeanException: > > > > > > > Exception in > > > > > > > > > MBean ope ration 'checkIncompleteDeployments()' > > > > > > > > > Cause: Incomplete Deployment listing: > > > > > > > > > Packages waiting for a deployer: > > > > > > > > > <none> > > > > > > > > > Incompletely deployed packages: > > > > > > > > > <none> > > > > > > > > > MBeans waiting for classes: > > > > > > > > > <none> > > > > > > > > > MBeans waiting for other MBeans: > > > > > > > > > [ObjectName: > jboss.jca:service=LocalTxCM,name=TestAppDb > > > > > > > > > state: FAILED > > > > > > > > > I Depend On: > jboss.jca:service=LocalTxDS,name=TestAppDb > > > > > > > > > > > > > > > > > > Depends On Me: > > > > > > > > > org.jboss.deployment.DeploymentException: > > > > > > > Exception > > > > > > > > > setting attr ibute javax.management.Attribute: > > > > > > > > > name=ManagedConnectionFactoryName value=jboss. > > > > > > > > > jca:service=LocalTxDS,name=TestAppDb on mbean > > > > > > > > > jboss.jca:service=LocalTxCM,name=T > > > > > > > > > estAppDb; - nested throwable: > > > > > > > > (javax.management.AttributeNotFoundException: > > > > > > > > > Writ > > > > > > > > > able attribute 'ManagedConnectionFactoryName' not > > > > > > > > > found), > > > > > > > ObjectName: > > > > > > > > > jboss.jca: > > > > > > > > > service=LocalTxDS,name=TestAppDb > > > > > > > > > state: FAILED > > > > > > > > > I Depend On: > > > > > > > > > Depends On Me: > jboss.jca:service=LocalTxCM,name=TestAppDb > > > > > > > > > org.jboss.deployment.DeploymentException: No Attribute > > > > > > > found with name: > > > > > > > > > JndiName > > > > > > > > > ] > > > > > > > > > 16:21:21,673 INFO [URLDeploymentScanner] Started > > > > > > > > > > > > > > > > > > I've scoured the archives and google to > death, but can't > > > > > > > nail down the > > > > > > > > > problem ... here are my files. If anyone can see the > > > > > > > problem, please > > > > > > > > > let me know ! > > > > > > > > > > > > > > > > > > I've added following to login-config.xml > > > > > > > > > > > > > > > > > > <!-- Security domain for MySQL --> > > > > > > > > > <application-policy name = "SecureTestAppDb"> > > > > > > > > > <authentication> > > > > > > > > > <login-module code = > > > > > > > > > > > > > > > > > "org.jboss.resource.security.ConfiguredIdentityLoginModule" > > > > > > > flag = > > > > > > > > > "required"> > > > > > > > > > <module-option name = > > > > > "principal">TestAppDbAdmin</module-option> > > > > > > > > > <module-option name = > > > > > "userName">TestAppDbAdmin</module-option> > > > > > > > > > <module-option name = > "password">eugenia</module-option> > > > > > > > > > <module-option name = > > > > > > > > > > > > > > > > > "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,n > > > > > > > am > > > > > > > e=Te > > > > > > > st > > > > > > > Ap > > > > > > > > > pDb</m > > > > > > > > > odule-option> > > > > > > > > > </login-module> > > > > > > > > > </authentication> > > > > > > > > > </application-policy> > > > > > > > > > > > > > > > > > > Here is my mysql-service.xml: > > > > > > > > > > > > > > > > > > <?xml version="1.0" encoding="UTF-8" ?> <server> > > > > > > > > > <mbean > > > > > > > > > code="org.jboss.resource.connectionmanager.LocalTxConnecti > > > > > > > > on > > > > > > > > Mana > > > > > > > > ge > > > > > > > > r" > > > > > > > > > name="jboss.jca:service=LocalTxCM,name=TestAppDb"> > > > > > > > > > <attribute > > > > > > > name="SecurityDomainJndiName">SecureTestAppDb</attribute> > > > > > > > > > <depends > > > > > > > > > > optional-attribute-name="ManagedConnectionFactoryName"> > > > > > > > > > <!-- embedded mbean--> > > > > > > > > > <mbean > > code="org.jboss.resource.connectionmanager.RARDeployment" > > > > > > > > > name="jboss.jca:service=LocalTxDS,name=TestAppDb"> > > > > > > > > > <attribute name="JndiName">TestAppDb</attribute> > > > > > > > > > <attribute name="ManagedConnectionFactoryProperties"> > > > > > > > > > <properties> > > > > > > > > > <config-property name="ConnectionURL" > > > > > > > > > > > > > > > > > > > > > > > > > type="java.lang.String">jdbc:mysql://w2czz4ch03:3306/TestApp > > > > > > > Db > > > > > > > </config-prope > > > > > > > > > rty> > > > > > > > > > <config-property name="DriverClass" > > > > > > > > > > type="java.lang.String">com.mysql.jdbc.Driver</config-pr > > > > > > > > > operty > > > > > > > > > > > > > > > > > > > </properties> > > > > > > > > > </attribute> > > > > > > > > > <!-- Below here are advanced properties --> > > > > > > > > > <!-- hack--> > > > > > > > > > <depends > > > > > > > > > > > > > > > > > > > > > > > > > optional-attribute-name="OldRarDeployment">jboss.jca:service > > > > > > > =R > > > > > > > ARDeployment,n > > > > > > > > > ame=JBoss LocalTransaction JDBC Wrapper</depends> > > > > > > > > > </mbean> > > > > > > > > > </depends> <depends > > > > > > > > > optional-attribute-name="ManagedConnectionPool"> > > > > > > > > > <!-- embedded mbean--> > > > > > > > > > <mbean > > > > > > > > > > > > > > > > > code="org.jboss.resource.connectionmanager.JBossManagedConne > > > > > > > ct > > > > > > > ionP > > > > > > > oo > > > > > > > l" > > > > > > > > > name="jboss.jca:service=LocalTxPool,name=TestAppDb"> > > > > > > > > > <attribute name="MinSize">0</attribute> <attribute > > > > > > > > > name="MaxSize">50</attribute> <attribute > > > > > > > > > name="BlockingTimeoutMillis">5000</attribute> > > > > > > > > > <attribute name="IdleTimeoutMinutes">15</attribute> > > > > > > > > > <attribute name="Criteria">ByContainer</attribute> > > > > > > > > > </mbean> > > > > > > > > > </depends> > > > > > > > > > <depends > > > > > > > > > > > > > > > > > > > > > > > > > optional-attribute-name="CachedConnectionManager">jboss.jca: > > > > > > > se > > > > > > > rvice=CachedCo > > > > > > > > > nnectionManager</depends> > > > > > > > > > <depends > > > > > > > > > > > > > > > > > > > > > > > > > optional-attribute-name="JaasSecurityManagerService">jboss.s > > > > > > > ec > > > > > > > urity:service= > > > > > > > > > JaasSecurityManager</depends> > > > > > > > > > <attribute > > > > > > > > name="TransactionManager">java:/TransactionManager</attribut > > > > > > > e> > > > > > > > > > <!-- make the rar deploy! hack till better > deployment--> > > > > > > > > > <depends>jboss.jca:service=RARDeployer</depends> > > > > > > > > > </mbean> > > > > > > > > > </server> > > > > > > > > > > > > > > > > > > I have replaced the exsiting lines in > > > > > > > standardjbosscmp-jdbc.xml and > > > > > > > > > standardjaws.xml with: > > > > > > > > > <datasource>java:/TestAppDb</datasource> > > > > > > > > > <datasource-mapping>mySQL</datasource-mapping> > > > > > > > > > > > > > > > > > > I've confirmed the username/password in > MySql. Not sure > > > > > > > > > why > > > > > > > > > it's complaining about the JndiName. > > > > > > > > > > > > > > > > > > Seems that I have something mismatched ... > any ideas ?? > > > > > > > > > > > > > > > > > > Thx for the help !! > > > > > > > > > > > > > > > > > > > > > > > > > > > > Pierre Comtois > > > > > > > > > > Business Acceleration Services, Solutions > Consulting > > > > > > > > > > 45 O'Connor Street, Suite 500 * > Ottawa, Ontario K1P > > 1A4 > > > > > > > > > > Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: > > > > > > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > > > > > > This sf.net email is sponsored by:ThinkGeek Welcome to > > > > > > > > > geek heaven. http://thinkgeek.com/sf > > > > > > > > > _______________________________________________ > > > > > > > > > JBoss-user mailing list > [EMAIL PROTECTED] > > > > > > > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > -- > > > > > > > xxxxxxxxxxxxxxxxxxxxxxxx > > > > > > > Adrian Brock > > > > > > > Director of Support > > > > > > > Back Office > > > > > > > JBoss Group, LLC > > > > > > > xxxxxxxxxxxxxxxxxxxxxxxx > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > > > > This sf.net email is sponsored by:ThinkGeek > > > > > > > Welcome to geek heaven. > > > > > > > http://thinkgeek.com/sf > > > > > > > _______________________________________________ > > > > > > > JBoss-user mailing list [EMAIL PROTECTED] > > > > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > > > This sf.net email is sponsored by:ThinkGeek > > > > > > Welcome to geek heaven. > > > > > > http://thinkgeek.com/sf > > > > > > _______________________________________________ > > > > > > JBoss-user mailing list [EMAIL PROTECTED] > > > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > > > This sf.net email is sponsored by:ThinkGeek > > > > > > Welcome to geek heaven. > > > > > > http://thinkgeek.com/sf > > > > > > _______________________________________________ > > > > > > JBoss-user mailing list [EMAIL PROTECTED] > > > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > -- > xxxxxxxxxxxxxxxxxxxxxxxx > Adrian Brock > Director of Support > Back Office > JBoss Group, LLC > xxxxxxxxxxxxxxxxxxxxxxxx > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net hosts over 70,000 Open Source Projects. See the people who have HELPED US provide better services: Click here: http://sourceforge.net/supporters.php _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
