1 2 Previous Next 29 Replies Latest reply on Jun 1, 2007 10:13 AM by bartek.polakowski

Migration to MySQL

bartek.polakowski May 4, 2007 6:24 PM

Hello,
I trying to change my datasource to MySQL but I can not solve one problem:

2007-05-05 00:05:13,664 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:

...

--- MBeans waiting for other MBeans ---
ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database
State: CONFIGURED
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS

ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
State: CONFIGURED
I Depend On:
jboss.mq:service=Invoker
jboss.web:service=WebServer

ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
State: CONFIGURED
I Depend On:
jboss:service=TransactionManager
jboss.jca:service=DataSourceBinding,name=DefaultDS

ObjectName: jboss.mq.destination:service=Topic,name=testTopic
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

ObjectName: jboss.mq.destination:service=Queue,name=testQueue
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

ObjectName: jboss.mq.destination:service=Queue,name=A
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:service=Queue,name=B
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:service=Queue,name=C
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:service=Queue,name=D
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:service=Queue,name=ex
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq:service=Invoker
State: CONFIGURED
I Depend On:
jboss.mq:service=TracingInterceptor
jboss:service=Naming
Depends On Me:
jboss.mq:service=InvocationLayer,type=HTTP
jboss.mq:service=InvocationLayer,type=JVM
jboss.mq:service=InvocationLayer,type=UIL2

ObjectName: jboss.mq:service=TracingInterceptor
State: CONFIGURED
I Depend On:
jboss.mq:service=SecurityManager
Depends On Me:
jboss.mq:service=Invoker

ObjectName: jboss.mq:service=SecurityManager
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager
Depends On Me:
jboss.mq.destination:service=Topic,name=testTopic
jboss.mq.destination:service=Topic,name=securedTopic
jboss.mq.destination:service=Topic,name=testDurableTopic
jboss.mq.destination:service=Queue,name=testQueue
jboss.mq:service=TracingInterceptor
jboss.mq.destination:service=Queue,name=DLQ

ObjectName: jboss.mq.destination:service=Queue,name=DLQ
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

ObjectName: jboss.mq:service=InvocationLayer,type=JVM
State: CONFIGURED
I Depend On:
jboss.mq:service=Invoker

ObjectName: jboss.mq:service=StateManager
State: CONFIGURED
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS
Depends On Me:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq:service=DestinationManager
State: CONFIGURED
I Depend On:
jboss.mq:service=MessageCache
jboss.mq:service=PersistenceManager
jboss.mq:service=StateManager
Depends On Me:
jboss.mq.destination:service=Topic,name=testTopic
jboss.mq.destination:service=Topic,name=securedTopic
jboss.mq.destination:service=Topic,name=testDurableTopic
jboss.mq.destination:service=Queue,name=testQueue
jboss.mq.destination:service=Queue,name=A
jboss.mq.destination:service=Queue,name=B
jboss.mq.destination:service=Queue,name=C
jboss.mq.destination:service=Queue,name=D
jboss.mq.destination:service=Queue,name=ex
jboss.mq:service=SecurityManager
jboss.mq.destination:service=Queue,name=DLQ

ObjectName: jboss.mq:service=PersistenceManager
State: CONFIGURED
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS
Depends On Me:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
State: CONFIGURED
I Depend On:
jboss.mq:service=Invoker

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS
State: NOTYETINSTALLED
Depends On Me:
jboss.ejb:service=EJBTimerService,persistencePolicy=database
jboss:service=KeyGeneratorFactory,type=HiLo
jboss.mq:service=StateManager
jboss.mq:service=PersistenceManager

Im using JBoss 4.0.5., MySQL 5.0 and Java 1.6

Does any one knows the solution? I would appreciate any help.

1. Re: Migration to MySQL

genman May 6, 2007 3:45 AM (in response to bartek.polakowski)

You data source is not deploying. Missing driver? Bad xml file? Look for an earlier error or warning message.
Actions
2. Re: Migration to MySQL

bartek.polakowski May 7, 2007 12:05 PM (in response to bartek.polakowski)

There are no other warn or error messages. I used thi website to configure JBoss: http://ltiwww.epfl.ch/Eclipse/LoadingJBoss.html

My mysql-ds.xml file looks like this:

<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<connection-url>jdbc:mysql://localhost/test</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>jboss</user-name>
<security-domain>MySqlDbRealm</security-domain>

<type-mapping>mySQL</type-mapping>

</local-tx-datasource>
Actions
3. Re: Migration to MySQL

bartek.polakowski May 8, 2007 5:05 AM (in response to bartek.polakowski)

In login-config.xml Ive added

<application-policy name = "MySqlDbRealm">

<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
<module-option name ="principal">jboss</module-option>
<module-option name ="userName">jboss</module-option>
<module-option name ="password">jboss</module-option>
<module-option name ="managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option>
</login-module>

</application-policy>
Actions
4. Re: Migration to MySQL

bartek.polakowski May 8, 2007 5:06 AM (in response to bartek.polakowski)

Beginning of standardjaws.xml

java:/MySqlDS
<type-mapping>mySQL</type-mapping>
false
Actions
5. Re: Migration to MySQL

bartek.polakowski May 8, 2007 5:07 AM (in response to bartek.polakowski)

Beginning of the standardjbosscmp.xml

<jbosscmp-jdbc>


java:/MySqlDS
<datasource-mapping>mySQL</datasource-mapping>

<create-table>true</create-table>
<remove-table>false</remove-table>
<read-only>false</read-only>
<read-time-out>300000</read-time-out>
<row-locking>false</row-locking>
<pk-constraint>true</pk-constraint>
<fk-constraint>true</fk-constraint>
Actions
6. Re: Migration to MySQL

bartek.polakowski May 8, 2007 5:09 AM (in response to bartek.polakowski)

Line 48 in mysql-jdbc2-service-xml

<depends optional-attribute-name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=MySqlDS
Actions
7. Re: Migration to MySQL

vickyk May 8, 2007 5:35 AM (in response to bartek.polakowski)

So what is the problem now , if you are not getting the errors ?

Look at this
http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpMysqlAsDefaultDS
Actions
8. Re: Migration to MySQL

bartek.polakowski May 8, 2007 12:48 PM (in response to bartek.polakowski)

I get this one error that I wrote at the beginning. I set everything like in this wiki but still the same problem.
Actions
9. Re: Migration to MySQL

bartek.polakowski May 9, 2007 2:07 PM (in response to bartek.polakowski)

I change my configuration to java 1.5 but it have not solve the problem
Actions
10. Re: Migration to MySQL

bartek.polakowski May 17, 2007 6:21 AM (in response to bartek.polakowski)

Ive reinstalled everything and still the same problem. I use Win XP Home. Any help would be very appreciated.
Actions
11. Re: Migration to MySQL

vickyk May 17, 2007 6:31 AM (in response to bartek.polakowski)

What issues are you facing now ?
Actions
12. Re: Migration to MySQL

bartek.polakowski May 18, 2007 6:24 AM (in response to bartek.polakowski)

Still the same:)

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS
State: NOTYETINSTALLED
Depends On Me:
jboss.ejb:service=EJBTimerService,persistencePolicy=database
jboss:service=KeyGeneratorFactory,type=HiLo
jboss.mq:service=StateManager
jboss.mq:service=PersistenceManager
Actions
13. Re: Migration to MySQL

vickyk May 18, 2007 7:10 AM (in response to bartek.polakowski)
This error indicates that there are some Mbean which are yet dependent on
jboss.jca:service=DataSourceBinding,name=DefaultDS .

1) Check the ejb-deployer.xml file you can still see the dependency on jboss.jca:service=DataSourceBinding,name=DefaultDS .
2) Another dependency in the uuid-key-generator.sar/META-INF/jboss-service.xml
3) Change the jndiName to proper jndi name which is MySqlDS at
http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigJBossMQLoginModule

Rectify these dependencies .
Actually you should have just kept the jndiName for the mysql-ds.xml as defaultDS and not changed it to MySQlDS , this is what would have been specified in the
http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpMysqlAsDefaultDS
Actions
14. Re: Migration to MySQL

bartek.polakowski May 21, 2007 4:22 PM (in response to bartek.polakowski)

Ad1 and Ad2 I see these dependencies but how should I rectify them? They look just like this one:
<depends optional-attribute-name="DataSource">jboss.jca:service=DataSourceBinding,name=DefaultDS

Ad3 The change of the jndiName does not change anything
Actions

1 2 Previous Next

Go to original post