[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
You do everything like here: http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpMysqlAsDefaultDS But there is one mistake. Dont change the datasource's name to mySQL in mysql-ds.xml. It should be kept as Default. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4050504#4050504 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4050504 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
hey can you please repeat the entire steps with name of files you modified.. to run jboss4.0.5 with mysql. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4050022#4050022 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4050022 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
Yes this is ok . View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047997#4047997 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047997 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
Thank you for help and patience:) View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4048017#4048017 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4048017 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
This is my mysql-ds file datasources | local-tx-datasource | jndi-nameMySqlDS/jndi-name | connection-urljdbc:mysql://mysql-hostname:3306/jbossdb/connection-url | driver-classcom.mysql.jdbc.Driver/driver-class | user-namejboss/user-name | passwordjboss/password | exception-sorter-class-nameorg.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter/exception-sorter-class-name | !-- should only be used on drivers after 3.22.1 with ping support | valid-connection-checker-class-nameorg.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker/valid-connection-checker-class-name | -- | !-- sql to call when connection is created | new-connection-sqlsome arbitrary sql/new-connection-sql | -- | !-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers | check-valid-connection-sqlsome arbitrary sql/check-valid-connection-sql | -- | | !-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -- | metadata |type-mappingmySQL/type-mapping | /metadata | /local-tx-datasource | | local-tx-datasource | jndi-namePublication/jndi-name | connection-urljdbc:mysql://mysql-hostname:3306/ld_publication/connection-url | driver-classcom.mysql.jdbc.Driver/driver-class | user-namejava/user-name | passwordjava/password | min-pool-size5/min-pool-size | max-pool-size15/max-pool-size | idle-timeout-minutes5/idle-timeout-minutes | exception-sorter-class-namecom.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter/exception-sorter-class-name | valid-connection-checker-class-namecom.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker/valid-connection-checker-class-name | | /local-tx-datasource | | /datasources View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047465#4047465 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047465 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
Ok one more time from the beginning. This is what I do: 1)I have mySQL ver 5.0.24a-community-nt so I copy the MySQL JDBC driver (mysql-connector-java-5.0.6-bin.jar) to the $JBOSS_HOME/server/default/lib 2)I delete $JBOSS_HOME/server/default/deploy/hsqldb-ds.xml 3)I copy $JBOSS_HOME/docs/examples/jca/mysql-ds.xml to $JBOSS_HOME/server/default/deploy and modify the local-tx-datasource element with my MySQL connection settings: jndi-nameMySqlDS/jndi-name connection-urljdbc:mysql://mysql-hostname:3306/jbossdb/connection-url | driver-classcom.mysql.jdbc.Driver/driver-class | user-namejboss/user-name | passwordjboss/password 4)In $JBOSS_HOME/server/default/conf/standardjaws.xml I change the type-mapping element to mySQL: datasourcejava:/DefaultDS/datasource |type-mappingmySQL/type-mapping 5)In standardjbosscmp-jdbc.xml I change the following datasourcejava:/DefaultDS/datasource | datasource-mappingmySQL/datasource-mapping | fk-constrainttrue/fk-constraint 6)I add the following within the element of login-config.xml: application-policy name = MySqlDbRealm | authentication | login-module code = org.jboss.resource.security.ConfiguredIdentityLoginModule flag = required | module-option name = principaljboss/module-option | module-option name = userNamejboss/module-option | module-option name =passwordjboss/module-option | module-option name = managedConnectionFactoryNamejboss.jca:service=LocalTxCM,name=DefaultDS/module-option | /login-module | /authentication | /application-policy 7) I Replace file $JBOSS_HOME/server/default/deploy/jms/hsql-jdbc2-service.xml by file $JBOSS_HOME/docs/examples/jms/mysql-jdbc2-service.xml 8) Change MySqlDS to DefaultDS in $JBOSS_HOME/server/default/deploy/jms/mysql-jdbc2-service.xml: depends optional-attribute-name=ConnectionManagerjboss.jca:service=DataSourceBinding,name=DefaultDS/depends 9) I rename hsqldb-jdbc-state-service.xml to mysql-jdbc-state-service.xml. And still the same:/ Maybe I use some incompatible versions of jboss and mysql or the driver is wrong? View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047483#4047483 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047483 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
Ive upgraded to mysql-5.0.41 any nothing:/ View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047488#4047488 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047488 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
anonymous wrote : 1) Check the ejb-deployer.xml file you can still see the dependency on jboss.jca:service=DataSourceBinding,name=DefaultDS . Did you applied the earlier comments which I have pointed , you don't seem to be reading the comments properly :( I am not going to explain this again now , read it again and see what other dependencies are in Jboss which depends on java:DefaultDS jndi . View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047491#4047491 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047491 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
I can see this dependency in ejb-deployer.xml and uuid-key-generator.sar/META-INF/jboss-service.xml but Im not sure what should I do with it. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047494#4047494 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047494 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
Could you rephrase your advice because the problem can be my english:) View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047515#4047515 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047515 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
anonymous wrote : I can see this dependency in ejb-deployer.xml and uuid-key-generator.sar/META-INF/jboss-service.xml but Im not sure what should I do with it. Change the DefaultDS to MySQLDS in both the xml files ? The MBeans in these two files are dependent on the DefaultDS which you have removed by knocking off hsqldb-ds.xml from the $JBOSS_HOME\server\default\deploy directory . View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047550#4047550 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047550 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
After Ive changed everything to MySqlDS I got: 2007-05-22 14:37:52,920 ERROR [org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin] Cannot create timer table | org.jboss.deployment.DeploymentException: Error while checking if table aleady exists TIMERS; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: | | ** BEGIN NESTED EXCEPTION ** | | java.net.UnknownHostException | MESSAGE: mysql-hostname: mysql-hostname | | STACKTRACE: | | java.net.UnknownHostException: mysql-hostname: mysql-hostname View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047558#4047558 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047558 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
anonymous wrote : connection-urljdbc:mysql://mysql-hostname:3306/jbossdb/connection-url mysql-hostname appears to me a bad IP , you can test this by pinging it . View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047575#4047575 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047575 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
Wow How could I forget it. Ok so after changing it to localhost and changing jndi name to DefaultDS there are no errors:) The fragment of the log looks like this 22:49:56,803 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jc | :service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS' | 22:50:01,560 INFO [A] Bound to JNDI name: queue/A | 22:50:01,570 INFO [B] Bound to JNDI name: queue/B | 22:50:01,570 INFO [C] Bound to JNDI name: queue/C | 22:50:01,570 INFO [D] Bound to JNDI name: queue/D Is it ok? Imasking because before there were some information that sth is CONFIGURED and now its just this. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047716#4047716 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047716 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
Ad1 and Ad2 I see these dependencies but how should I rectify them? They look just like this one: depends optional-attribute-name=DataSourcejboss.jca:service=DataSourceBinding,name=DefaultDS Ad3 The change of the jndiName does not change anything View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047367#4047367 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047367 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
What's the content of your -ds.xml file? What MBean does this create when deployed? This is really simply stuff people... View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4047398#4047398 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4047398 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
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 View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4046760#4046760 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4046760 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
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 View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4046766#4046766 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4046766 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
I change my configuration to java 1.5 but it have not solve the problem View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4044435#4044435 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4044435 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
In login-config.xml Ive added application-policy name = MySqlDbRealm login-module code = org.jboss.resource.security.ConfiguredIdentityLoginModule flag = required module-option name =principaljboss/module-option module-option name =userNamejboss/module-option module-option name =passwordjboss/module-option module-option name =managedConnectionFactoryNamejboss.jca:service=LocalTxCM,name=MySqlDS/module-option /login-module /application-policy View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4043855#4043855 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4043855 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
Beginning of standardjaws.xml java:/MySqlDS type-mappingmySQL/type-mapping false View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4043856#4043856 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4043856 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
Beginning of the standardjbosscmp.xml jbosscmp-jdbc !--java:/DefaultDS -- java:/MySqlDS datasource-mappingmySQL/datasource-mapping create-tabletrue/create-table remove-tablefalse/remove-table read-onlyfalse/read-only read-time-out30/read-time-out row-lockingfalse/row-locking pk-constrainttrue/pk-constraint fk-constrainttrue/fk-constraint View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4043857#4043857 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4043857 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
Line 48 in mysql-jdbc2-service-xml depends optional-attribute-name=ConnectionManagerjboss.jca:service=DataSourceBinding,name=MySqlDS View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4043858#4043858 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4043858 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
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 View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4043861#4043861 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4043861 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
I get this one error that I wrote at the beginning. I set everything like in this wiki but still the same problem. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4043986#4043986 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4043986 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
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-nameMySqlDS/jndi-name connection-urljdbc:mysql://localhost/test/connection-url driver-classcom.mysql.jdbc.Driver/driver-class user-namejboss/user-name security-domainMySqlDbRealm/security-domain type-mappingmySQL/type-mapping /local-tx-datasource View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4043705#4043705 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4043705 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [JCA/JBoss] - Re: Migration to MySQL
You data source is not deploying. Missing driver? Bad xml file? Look for an earlier error or warning message. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4043502#4043502 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4043502 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user