2 Replies Latest reply on Nov 30, 2002 10:49 AM by CL Gilbert

    mysql dataset not bound

    Luigi Fonti Newbie

      I have read some topics about this problem in this forum, and I have tried to follow the suggestions, but I didn't have success.

      1) I copied mysql-connector-java-2.0.14-bin.jar to directory: \jboss3\server\default\lib

      2) I modified mysql-service.xml, changing the lines:

      <config-property name="ConnectionURL"
      type="java.lang.String">
      jdbc:mysql://localhost/work</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">myusername</config-property>
      <config-property name="Password"
      type="java.lang.String">mypassword</config-property>

      and copied it to directory: \jboss3\server\default\lib

      But, when my client application tries to execute:
      home.findByPrimaryKey("ASPPI");
      then an Exception is thown:
      MySqlDS not bound.

      In mysql-service.xml there is an obscure paragraph:
      --------------------------------------------------------
      <!-- Include a login module configuration named MySqlDbRealm.
      Update your login-conf.xml, here is an example for a
      ConfiguredIdentityLoginModule:

      <application-policy name = "MySqlDbRealm">

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

      </application-policy>
      ---------------------------------------------------------
      what does it mean ??
      Luigi Fonti