New missing/unsatisfied dependencies: service jboss.jdbc-driver.sybase (missing) dependents

[mapgma33]

Hi!

I am newest in jboss and I am trying to migrate from jboss4.2 to jboss7.1.1.

I started running my java app in jboss7.1.1 and an error has ocurred:

"New missing/unsatisfied dependencies: service jboss.jdbc-driver.sybase (missing) dependents"

I don't know if my problem is about jdbc version.

I have jdbc3.

standalone.xml file:

<datasource jta="false" jndi-name="java:jboss/datasources/jikDS" pool-name="jikDS" enabled="true" use-ccm="false">

                    <connection-url>"myjdbcconectionhere"</connection-url>

                    <driver-class>com.sybase.jdbc3.jdbc.SybDriver</driver-class>

                    <driver>sybase</driver>

                    <pool>

                        <min-pool-size>1</min-pool-size>

                        <max-pool-size>20</max-pool-size>

                    </pool>

                    <security>

                        <user-name>asdf</user-name>

                        <password>123</password>

                    </security>

                    <validation>

                        <check-valid-connection-sql>select 1 from sys.dummy</check-valid-connection-sql>

                    </validation>

                </datasource>

Somebody knows about this error???

[andey]

Hi, I'm providing an example for oracle DS:

Install a JDBC Driver as a Core Module

• Create a directory under $JBOSS_HOME/modules. In this example: "$JBOSS_HOME/modules/com/oracle/jdbc/main".
• Put the the JDBC driver jar (ojdbc6.jar) in this directory.
• Create a module configuration file module.xml:

Example Oracle JDBC Driver module.xml File:

~~~

<?xml version="1.0" ?>

<module xmlns="urn:jboss:module:1.1" name="com.oracle">

    <resources>

        <resource-root path="ojdbc6.jar"/>

    </resources>

    <dependencies>

        <module name="javax.api"/>

        <module name="javax.transaction.api"/>

    </dependencies>

</module>

~~~

Example Oracle Datasource Configuration:

~~~

<datasources>

  <datasource jndi-name="java:/OracleDS" pool-name="OracleDS">

    <connection-url>jdbc:oracle:thin:@localhost:1521:XE</connection-url>

    <driver>oracle</driver>

    <security>

      <user-name>admin</user-name>

      <password>admin</password>

    </security>

    <validation>

      <validate-on-match>true</validate-on-match>

      <background-validation>false</background-validation>

      <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"></valid-connection-checker>

      <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"></stale-connection-checker>

      <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"></exception-sorter>

    </validation>

  </datasource>

  <drivers>

    <driver name="oracle" module="com.oracle">

    </driver>

  </drivers>

</datasources>

~~~

See the link how to configure Sybase Datasource: Administration and Configuration Guide

[mapgma33]

Thank you for your answer.

I already have the directory "$JBOSS_HOME/modules/com/sybase/jconn3d/main".

This directory has the JDBC driver "jconn3d.jar" and also have the "module.xml"

But it doesn't work, I have the error.

"New missing/unsatisfied dependencies: service jboss.jdbc-driver.sybase (missing) dependents"

Maybe, do you think it could be the JDBC version?

[andey]

Hi,

- May be JDBC version problem. All the JDBC driver JAR should be JDBC 4-compliant.  Any JDBC 4-compliant driver is automatically recognized and installed in the system by name and version. A JDBC JAR is identified using the Java service provider mechanism. Such JARs contain the META-INF/services/java.sql.Driver text, which contains the name of the Driver classes in that JAR.

- Try upgrading your JDBC driver jar.

- In the driver section verify the settings as per below:

~~~

...

....

<driver name="sybase" module="com.sybase">

      <datasource-class>com.sybase.jdbc4.jdbc.SybDataSource</datasource-class>

      <xa-datasource-class>com.sybase.jdbc4.jdbc.SybXADataSource</xa-datasource-class>

    </driver>

~~~

You might also find this link helpful:

DataSource configuration - JBoss AS 7.1 - Project Documentation Editor

You can download JDBC Driver from the below locations:

Administration and Configuration Guide

[mapgma33]

Thank you for your answer.

I am trying to upgrade my JDBC driver jar, but the link http:///www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect redirect me to this site SAP Software Solutions | Business Applications and Technology.

I am searching other site where I can download sybase JDBC driver, but I can't find anything.

Maybe, do you have or know other link?

[andey]

Hi,

First check JDBC 4.0 standard defines META-INF/services/java.sql.Driver which contains the *driver* classname, JDK/EAP picks this up automatically. If yes, no need to download new JDBC jar.

You can download from :

http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect