Problems with MySQL Datasource
sklimenko Jul 9, 2002 4:30 AMHi all.
I use JBoss 3.0.0RC3 and dont install any Data Source pool for this version JBoss. Using any version of mysql-service.xml from cvs repository I get next message:
[ServiceController] jboss.jca:service=LocalTxDS,name=MySqlDS does not implement any Service methods
[org.jboss.system.ServiceController] jboss.jca:service=LocalTxDS,name=MySqlDS does not implement any Service method
s
[JBossManagedConnectionPool] Creating
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Creating
[JBossManagedConnectionPool] Created
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Created
[JBossManagedConnectionPool] Starting
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Starting
[JBossManagedConnectionPool] Started
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Started
[MainDeployer] Successfully completed deployment of package: file:/C:/Software/JBoss-3.0.0/server/default/deploy/my
sql-service.xml
[org.jboss.deployment.MainDeployer] Successfully completed deployment of package: file:/C:/Software/JBoss-3.0.0/ser
ver/default/deploy/mysql-service.xml
Content of mysql-service.xml the following:
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- ==================================================================== -->
<!-- New ConnectionManager setup for mysql using 2.0.11 driver -->
<!-- Build jmx-api (build/build.sh all) and view for config documentation -->
<!-- ==================================================================== -->
<!--comment out this line if you want component managed security or want
to use the default values in the ManagedConnectionFactoryProperties -->
MySqlDbRealm
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->
MySqlDS
<config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://dell:3306/jbossdb</config-property>
<config-property name="DriverClass" type="java.lang.String">org.gjt.mm.mysql.Driver</config-property>
<config-property name="UserName" type="java.lang.String"></config-property>
<config-property name="Password" type="java.lang.String"></config-property>
<!--Below here are advanced properties -->
<!--hack-->
<depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper
<depends optional-attribute-name="ManagedConnectionPool">
<!--embedded mbean-->
0
50
5000
15
ByContainer
<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
<depends optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager
java:/TransactionManager
<!--make the rar deploy! hack till better deployment-->
jboss.jca:service=RARDeployer
File login-config.xml content next lines:
<application-policy name = "MySqlDbRealm">
<login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
<module-option name = "principal">harduc</module-option>
<module-option name = "userName">harduc</module-option>
<module-option name = "password">1</module-option>
<module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option>
</login-module>
</application-policy>
To talk, please, where errors?
Also, I see all other resources this forum, and not fixed this error.