2 Replies Latest reply on Sep 25, 2002 4:46 AM by Zoltan Imreh

    SQLBase is not running with JBoss

    Zoltan Imreh Newbie

      Hi everyone,
      I'm using an SQLBase database from Gupta and configuring it with the JBoss 3.0 I'm running into the following problem:

      15:36:39,562 INFO [STDOUT] Exception = org.jboss.util.NestedSQLException: Could
      not create connection; - nested throwable: (java.sql.SQLException: No suitable
      driver); - nested throwable: (org.jboss.resource.ResourceException: Could not cr
      eate connection; - nested throwable: (java.sql.SQLException: No suitable driver)
      )

      However the configuration seames ok. Below is the SQLBase-service.xml with what I'm configuring my Ds.:



      <!-- ==================================================================== -->
      <!-- New ConnectionManager setup for SQLBase -->
      <!-- Build jmx-api (build/build.sh all) and view for config documentation -->
      <!-- ==================================================================== -->




      SQLBaseRealm

      <depends optional-attribute-name="ManagedConnectionFactoryName">
      <!--embedded mbean-->


      SQLBaseDS



      <config-property name="ConnectionURL" type="java.lang.String">jdbc:SQLBase://em2kapp/support2</config-property>
      <config-property name="TransactionIsolation" type="java.lang.String">TRANSACTION_SERIALIZABLE</config-property>
      <config-property name="DriverClass" type="java.lang.String">com.centurasoft.java.sqlbase.SqlbaseDriver</config-property>
      <config-property name="UserName" type="java.lang.String">sysadm</config-property>
      <config-property name="Password" type="java.lang.String">sysadm</config-property>

      <jdbc-property name="CountryAlpha" type="java.lang.String">A B C D E F G H I J K L M N O P Q R S T U V W X Y Z \\C4 \\D6 \\DC a b c d e f g h i j k l m n o p q r s t u v w x y z \\E4 \\F6 \\FC \\DF</jdbc-property>
      <jdbc-property name="reuseStatement" type="boolean">false</jdbc-property>
      <jdbc-property name="language" type="java.lang.String">german</jdbc-property>
      <jdbc-property name="CountryWhiteSpace" type="java.lang.String">\\9 \\A \\D \\20</jdbc-property>
      <jdbc-property name="CountryNumeric" type="java.lang.String">0 1 2 3 4 5 6 7 8 9</jdbc-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
      <!--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=CachedConnectionManager

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

      java:/TransactionManager
      <!--make the rar deploy! hack till better deployment-->
      jboss.jca:service=RARDeployer





      Can somebody tell me what is wrong with that driver or what am I configuring wrong?