0 Replies Latest reply on Oct 8, 2002 5:00 AM by hortiz

    JBoss datasource configuration for MySQL database

    hortiz

      Hi,
      I use JBoss 3.0.0 and mySQL database (3.23.32).
      I want to configure a datasource to connect to this database.
      Do I need the file 'jboss.jcml' ? I don't find it in my JBoss directory...
      Moreover, the mySQL driver JAR mm.mysql.XXX.bin.jar must be copied in jboss/lib/ext directory, this directory doesn't exist in initial structure isn't it ?
      Does my file 'mysql-service.xml' (see below) is ok ?
      Thanks a lot for your help,
      Helene

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



      IntranetDS
      <depends optional-attribute-name="ManagedConnectionFactoryName">



      <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://192.168.1.67/IntranetTEST</config-property>
      <config-property name="DriverClass" type="java.lang.String">org.gjt.mm.mysql.Driver</config-property>
      <!--set these only if you want only default logins, not through JAAS -->
      <config-property name="UserName" type="java.lang.String">user1</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:service=JaasSecurityManager
      java:/TransactionManager
      <!--make the rar deploy! hack till better deployment-->
      jboss.jca:service=RARDeployer