SQLBase is not running with JBoss

[imreh_zoltan]

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?

[davidjencks]

"No Suitable Driver" suggests you havent deployed the driver for your db anywhere jboss can find it. I suggest server/[config]/lib.

I'm not sure what effect you expect from the jdbc-property elements but they are ignored.

[imreh_zoltan]

Actually the problem was, that the URL to the database is case sensitive, and the driver could not id the communication protocol.