3 Replies Latest reply on Jan 24, 2002 5:12 PM by Brian Hand

    Example/help Connecting JBoss 3.0 alpha to sybase

    Brian Hand Newbie

      All,

      I am having a heck of a time trying to connect JBoss 3.0 alpha to Sybase vi JConnect 5.2.

      Does anyone have an example of such configuration. I tried mimicking the oracle/mysql/hqsl configurations to no avail. I can provide the example if someone needs it but I would perfer if someone could share a template. (ips and password removed to protect the innocent)

      Thanks In advance for your assistance.

      Brian

        • 1. Re: Example/help Connecting JBoss 3.0 alpha to sybase
          F Zemen Newbie

          There's not enought detail in your message to help figure out your trouble. However, here's a suggestion.

          Make sure you can connect to one of the other db's (mysql for instance, which is free and a relatively small download compared to oracle).

          Then you'll know your problem is connecting to Sybase and not more general.

          • 2. Re: Example/help Connecting JBoss 3.0 alpha to sybase
            L.G. Newbie

            Make sure to add jconn2.jar to classpath.

            Connection parms:
            com.sybase.jdbc2.jdbc.SybDriver
            jdbc:sybase:Tds::/DBName

            • 3. Re: Example/help Connecting JBoss 3.0 alpha to sybase
              Brian Hand Newbie

              After Much fighting I "finally" got it to work. Perhaps this file below can make it onto the CVS area where the other examples are?

              Thanks for the help

              Brian



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







              ConnectionURL=jdbc:sybase:Tds:<ip.addr.x.x>:/
              DriverClass=com.sybase.jdbc2.jdbc.SybDriver
              UserName=
              Password=

              SybaseDS
              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
              BlockingTimeoutMillis=50000
              IdleTimeoutMinutes=30
              MaxSize=100
              CleanupIntervalMinutes=10
              MinSize=10
              MaxIdleTimeoutPercent=1.0


              org.jboss.resource.security.ManyToOnePrincipalMapping