[jboss-user] [O'Reilly JBoss 3.0/4.0 Workbook] - MySql datasource configuration issue:Urgent

[jitendra007]

Hi All,

I am trying to create MySql1.5 datasource.

I have done following steps

1) Mysql-ds.xml


   <local-tx-datasource>

      <jndi-name>MysqlDS</jndi-name>
      <connection-url>jdbc:mysql://localhost:3306/test</connection-url>
      <driver-class>com.mysql.jdbc.Driver</driver-class>
      <user-name>root</user-name>
      password
      <min-pool-size>5</min-pool-size>
      <max-pool-size>20</max-pool-size>
      <idle-timeout-minutes>0</idle-timeout-minutes>
      <track-statements/>
      <!-- Use the security domain defined in conf/login-config.xml -->
      <security-domain>MySqlDbRealm</security-domain>
      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      
         <type-mapping>mySQL</type-mapping>
            
      jboss.jca:service=LocalTxCM,name=MysqlDS 
   </local-tx-datasource>

   



2) Login.xml
    <application-policy name = "MySqlDbRealm">
       
          <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
             flag = "required">
             <module-option name = "principal"></module-option>
             <module-option name = "userName">root</module-option>
             <module-option name = "password">password</module-option>
             <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MysqlDS</module-option>
          </login-module>
       
    </application-policy>

3): standradjbosscmp-jdbc.xml

java:/MysqlDS

4):standardjaws.xml

java:/MysqlDS
   <type-mapping>mysql</type-mapping>

5) : jboss-cmp-jdbc.xml



java:/MysqlDS

<datasource-mapping>mySQL</datasource-mapping>



<create-table>true</create-table>

<remove-table>false</remove-table>

<pk-constraint>true</pk-constraint>

<preferred-relation-mapping>

foreign-key

</preferred-relation-mapping>




I am getting following error while deploying



15:35:00,502 ERROR [EntityContainer] Starting failed jboss.j2ee:jndiName=customerJndi,service=EJB
org.jboss.deployment.DeploymentException: Error: can't find data source: java:/MysqlDS; - nested thr
owable: (javax.naming.NameNotFoundException: MysqlDS not bound)
        at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.init(JDBCEntityBridge.java:139)
        at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:42
0)


Please suggest for me if you any idea.

It is very urgent.

Thanks in advace.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4094461#4094461

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4094461