-
1. Re: New missing/unsatisfied dependencies: service jboss.jdbc-driver.sybase (missing) dependents
andey Jan 12, 2017 9:18 AM (in response to mapgma33)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
-
2. Re: New missing/unsatisfied dependencies: service jboss.jdbc-driver.sybase (missing) dependents
mapgma33 Jan 12, 2017 11:07 AM (in response to andey)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?
-
3. Re: New missing/unsatisfied dependencies: service jboss.jdbc-driver.sybase (missing) dependents
andey Jan 12, 2017 11:33 AM (in response to mapgma33)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
-
4. Re: New missing/unsatisfied dependencies: service jboss.jdbc-driver.sybase (missing) dependents
mapgma33 Jan 12, 2017 2:25 PM (in response to andey)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?
-
5. Re: New missing/unsatisfied dependencies: service jboss.jdbc-driver.sybase (missing) dependents
andey Jan 12, 2017 10:42 PM (in response to mapgma33)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