2 Replies Latest reply on Aug 16, 2002 2:01 AM by Matt Colgan

    config file contents

    Matt Colgan Newbie

      I am using JBoss 3.01 and JDK 1.3.1_04. I do have servlets connecting to Firebird with straight JDBC connections, so I am inclined to think the problem is either with my setup in the attached configs or in the driver...

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

      <!--
      ==================================================================== -
      ->
      <!-- New ConnectionManager setup for firebird dbs using jca-jdbc xa
      driver-->
      <!-- Build jmx-api (build/build.sh all) and view for config
      documentation -->
      <!--
      ==================================================================== -
      ->



      <!--FBManager can be used to create and drop databases.
      Drop is especially useful during testing, since it
      assures a clean start next time. -->

      <!--

      c:\firebird\data\test1_db.gdb
      sysdba
      super666
      false
      false

      -->


      <!--make the rar deploy - A BIG HACK till xslt based deployment
      is written-->
      jboss.jca:service=RARDeployer

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

      <!--more hack-->
      <depends optional-attribute-
      name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Firebird
      Database Connector


      <!--config-property>
      <config-property-name>Server</config-property-name>
      <config-property-type>java.lang.String</config-property-
      type>
      <config-property-value>localhost</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>Port</config-property-name>
      <config-property-type>java.lang.Integer</config-
      property-type>
      <config-property-value>3050</config-property-value>
      </config-property-->
      <config-property>
      <config-property-name>Database</config-property-name>
      <config-property-type>java.lang.String</config-property-
      type>
      <config-property-
      value>localhost/c:\\firebird\\data\\test_db.gdb</config-property-
      value>
      </config-property>
      <config-property>
      <config-property-name>UserName</config-property-name>
      <config-property-type>java.lang.String</config-property-
      type>
      <config-property-value>sysdba</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>Password</config-property-name>
      <config-property-type>java.lang.String</config-property-
      type>
      <config-property-value>masterkey</config-property-value>
      </config-property>


      FirebirdService




      <depends optional-attribute-name="ManagedConnectionPool">


      0
      50
      5000
      15
      <!--criteria indicates if Subject (from security domain) or
      app supplied
      parameters (such as from getConnection(user, pw)) are
      used to distinguish
      connections in the pool. Choices are
      ByContainerAndApplication (use both),
      ByContainer (use Subject),
      ByApplication (use app supplied params only),
      ByNothing (all connections are equivalent, usually if
      adapter supports
      reauthentication)-->
      ByContainer


      <depends optional-attribute-
      name="CachedConnectionManager">jboss.jca:service=CachedConnectionManag
      er
      <!-- Include a login module configuration named FirebirdDBRealm.
      Update your login-conf.xml, here is an example for a
      ConfiguredIdentityLoginModule:

      <application-policy name = "FirebirdDBRealm">

      <login-module code
      = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag
      = "required">
      <module-option name = "principal">sysdba</module-option>
      <module-option name = "userName">sysdba</module-option>
      <module-option name = "password">masterkey</module-
      option>
      <module-option name
      = "managedConnectionFactoryName">jboss.jca:service=XaTxCM,name=Firebir
      dDS</module-option>
      </login-module>

      </application-policy>

      NOTE: the application-policy name attribute must match
      SecurityDomainJndiName, and the
      module-option name = "managedConnectionFactoryName"
      must match the object name of the ConnectionManager you are
      configuring here.
      -->
      <!--comment out this line if you want component managed security
      or want
      to use the default values in the
      ManagedConnectionFactoryProperties -->
      java:/jaas/FirebirdDBRealm

      <depends optional-attribute-
      name="JaasSecurityManagerService">jboss.security:name=JaasSecurityMana
      ger

      java:/TransactionManager





      <ra.xml> (in firebirdsql.rar)

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

      <!DOCTYPE connector PUBLIC "-//Sun Microsystems, Inc.//DTD Connector
      1.0//EN" "file:///usr/java/jca/connector_1_0.dtd">
      <!-- DOCTYPE connector PUBLIC"-//Sun Microsystems, Inc.//DTD
      Connector 1.0//EN" "http://java.sun.com/dtd/connector_1_0.dtd"-->



      <display-name>Firebird Database Connector</display-name>
      <vendor-name>David Jencks</vendor-name>
      <spec-version>1.0</spec-version>
      <eis-type>Relational Database</eis-type>
      1.0

      <managedconnectionfactory-
      class>org.firebirdsql.jca.FBManagedConnectionFactory</managedconnectio
      nfactory-class>
      <connectionfactory-
      interface>javax.sql.DataSource</connectionfactory-interface>
      <connectionfactory-impl-
      class>org.firebirdsql.jdbc.FBDataSource</connectionfactory-impl-class>
      <connection-interface>java.sql.Connection</connection-interface>
      <connection-impl-
      class>org.firebirdsql.jdbc.FBConnection</connection-impl-class>
      <transaction-support>XATransaction</transaction-support>
      <config-property>
      <config-property-name>Database</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-
      value>localhost/c:\\firebird\\data\\test_db.gdb</config-property-
      value>
      </config-property>
      <config-property>
      <config-property-name>UserName</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>sysdba</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>Password</config-property-name>
      <config-property-type>java.lang.String</config-property-type>
      <config-property-value>super666</config-property-value>
      </config-property>
      <config-property>
      <config-property-name>BlobBufferLength</config-property-name>
      <config-property-type>int</config-property-type>
      <config-property-value></config-property-value>
      </config-property>
      <authentication-mechanism>
      <authentication-mechanism-type>BasicPassword</authentication-
      mechanism-type>
      <credential-
      interface>javax.resource.security.PasswordCredential</credential-
      interface>
      </authentication-mechanism>
      <reauthentication-support>false</reauthentication-support>



      <added to login-config.xml>
      <application-policy name = "FirebirdDBRealm">

      <login-module code
      = "org.jboss.resource.security.ConfiguredIdentityLoginModule"
      flag = "required">
      <module-option name = "principal">sysdba</module-option>
      <module-option name = "userName">sysdba</module-option>
      <module-option name = "password">masterkey</module-
      option>
      <module-option name
      = "managedConnectionFactoryName">jboss.jca:service=XaTxCM,name=Firebir
      dDS</module-option>
      </login-module>

      </application-policy>