3 Replies Latest reply on Dec 18, 2001 8:55 PM by lee

    Setting the user/password for interbase

    lee Newbie

      I have tried every combination to try and get the user
      and password recognised when using Interbase.
      Here is my 'interbase-service.xml' with one attempt of
      setting the user and password. i am using interserver 2.00 with the latest interclient drivers compiled to 1.3).

      I am runnning the alpha 3.0 binary version. Has anyone got a running version of interbase, can i see the xml file PLEASE!!!







      <!-- ==================================================================== -->
      <!-- JDBC - Initialize the databases -->
      <!-- to ConnectionFactoryLoader -->
      <!-- ==================================================================== -->


      ConnectionURL=jdbc:interbase://bambaloo/c:/temp/test.db
      DriverClass=interbase.interclient.Driver UserName=sysdba UserPassword=masterkey

      DefaultDS
      java:/TransactionManager


      <mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</mbean-ref>
      <mbean-ref name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
      #
      #Wed Aug 15 16:17:29 EDT 2001
      MinSize=0
      MaxSize=10
      BlockingTimeoutMillis=5000
      IdleTimeoutMinutes=30
      CleanupIntervalMinutes=10
      MaxIdleTimeoutPercent=1.0


      org.jboss.resource.security.ManyToOnePrincipalMapping

      user=sysdba password=masterkey




        • 1. Re: Setting the user/password for interbase
          lee Newbie

          This works.. but now having issues with interserver and interclient compatiblities. Bad protocol errors.

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

          <!-- $Id: interbase-service.xml,v 1.5 2001/11/20 22:15:23 d_jencks Exp $ -->







          <!-- ==================================================================== -->
          <!-- JDBC - Initialize the databases -->
          <!-- to ConnectionFactoryLoader -->
          <!-- ==================================================================== -->


          ConnectionURL=jdbc:interbase://bambaloo/c:/temp/test.db
          DriverClass=interbase.interclient.Driver UserName=sysdba Password=masterkey

          TestDS
          java:/TransactionManager


          <mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</mbean-ref>
          <mbean-ref name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
          #
          #Wed Aug 15 16:17:29 EDT 2001
          MinSize=0
          MaxSize=10
          BlockingTimeoutMillis=5000
          IdleTimeoutMinutes=30
          CleanupIntervalMinutes=10
          MaxIdleTimeoutPercent=1.0


          org.jboss.resource.security.ManyToOnePrincipalMapping

          user=sysdba password=masterkey


          • 2. Re: Setting the user/password for interbase
            David Jencks Master

            I had some problems like this the last time I tried to set this up. Which interbase/firebird/interserver/interclient are you using and where did you get them? You might try firebird + interclient from the firebird site, there are binary interclient packages for windows and rh linux 7.1 (compiling interserver is the hard part).

            • 3. Re: Setting the user/password for interbase
              lee Newbie

              Thanks for the reply.

              I am using the interserver/interclient from the Borland site.

              http://www.borland.com/devsupport/interbase/interclient/patch202.html

              I am using interserver 2.01 and the latest interclient compiled to jdk1.3.


              i will try the firebird stuff as you mentioned and let you know how i get on.