1 Reply Latest reply on Oct 30, 2003 12:29 PM by balteo

    Adding a mysql datasource

    balteo

      Hello,

      I am trying to deploy a cmp ejb. Prior to this I need to configure a mysql datasource. Here are the steps I have taken:

      -I have created a xml file called mysql-ds.xml with the following content:

      ********************
      <?xml version="1.0" encoding="UTF-8"?>

      <!-- ===================================================================== -->
      <!-- -->
      <!-- JBoss Server Configuration -->
      <!-- -->
      <!-- ===================================================================== -->

      <!-- $Id: mysql-ds.xml,v 1.1 2002/07/22 22:57:24 d_jencks Exp $ -->
      <!-- ==================================================================== -->
      <!-- Datasource config for MySQL using 2.0.11 driver -->
      <!-- ==================================================================== -->



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


      ********************

      I have copied that file in the default/deploy directory.

      When I try to deploy the ejb, jboss complains that the parispano-java datasource does not exist.

      Can anyone help please?

      Thanks in advance,

      Julien.

        • 1. Adding a mysql datasource
          balteo

          I think I found the answer to my question :
          One has to add "java:/" before the datasource name.
          Thus the datasource name was :
          "java:/parispano-java"
          Julien.