2 Replies Latest reply on Sep 11, 2003 8:42 PM by osoberanis

    mySQL(InnoDB) datasource problem.

    sys user Master

      Greetings.

      My problem is whenever i place password in mysql-ds.xml

      the data source is not working.

      the mysql-ds.xml is like


      --------------------------------

      <local-tx-datasource>
      <jndi-name>CostControlDS</jndi-name>
      <connection-url>jdbc:mysql://localhost:3306/db</connection-url>
      <driver-class>com.mysql.jdbc.Driver</driver-class>
      <user-name>abcd</user-name>
      abcd
      </local-tx-datasource>



      i created one user abcd@localhost thru mysql control centre.but when in xml(as well as db) i give the password of the user the datasource is not working but when i remove the password it is working fine.
      please help me.

      the error message that comes on jboss server when i give passsword is cannot find user abcd @ 127.0.0.1

      Thanks
      Anupam

        • 1. Re: mySQL(InnoDB) datasource problem.
          dumber168 Newbie

          try granting user "abcd" further rights in MySQL Server by
          executing the following (either through MySQL client or
          Control Center):

          > grant select,insert,update,delete on test.* to abcd@"" identified by "abcd";
          > grant select,insert,update,delete on test.* to abcd@localhost identified by "abcd";
          > grant select,insert,update,delete on test.* to abcd@"%" identified by "abcd";

          all the above statements may be applied to fully grant the user
          "abcd" to the database "db" regardless of the hostname where
          the application is run.

          hope this helps.

          • 2. Re: mySQL(InnoDB) datasource problem.
            osoberanis Newbie

            Try changing the driver class to this
            <driver-class>org.gjt.mm.mysql.Driver</driver-class>