JBoss Community

Re: Sybase datasource config: New missing/unsatisfied dependencies

created by Carey Brown in Datasource Configuration - View the full discussion

<body><p>

Sorry to bring this up again but I'm new to this and I am unable to connect to Sybase using the above example. In straight Java/Jdbc (without Jboss) I can get it to work. Setting up a datasource seems to be my sticking point.</p>

<p> </p>

<p>Here's what I have:</p>

<p> </p>

<p>08:05:58,357 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service</p>

<p>thread 1-1) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]</p>

<p>08:05:58,982 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774</p>

<p>: Service status report</p>

<p>JBAS014775:    New missing/unsatisfied dependencies:</p>

<p>      service jboss.jdbc-driver.sybaseDriver (missing) dependents: [service jbos</p>

<p>s.data-source.java:jboss/datasources/SybaseDS]</p>

<p> </p>

<p> ...\standalone\configuration\standalone.xml</p>

<p> </p>

<table>

<tbody>

<tr>

<td>    </td>

<td>&lt;subsystem xmlns="urn:jboss:domain:datasources:1.0"&gt;</td>

</tr>

<tr>

<td>        </td>

<td>&lt;datasources&gt;</td>

</tr>

<tr>

<td>            </td>

<td>&lt;datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true"&gt;</td>

</tr>

<tr>

<td>                </td>

<td>&lt;connection-url&gt;jdbc:h2:mem:test;DB_CLOSE_DELAY=-1&lt;/connection-url&gt;</td>

</tr>

<tr>

<td>                </td>

<td>&lt;driver&gt;h2&lt;/driver&gt;</td>

</tr>

<tr>

<td>                </td>

<td>&lt;security&gt;</td>

</tr>

<tr>

<td>                    </td>

<td>&lt;user-name&gt;sa&lt;/user-name&gt;</td>

</tr>

<tr>

<td>                    </td>

<td>&lt;password&gt;sa&lt;/password&gt;</td>

</tr>

<tr>

<td>                </td>

<td>&lt;/security&gt;</td>

</tr>

<tr>

<td>            </td>

<td>&lt;/datasource&gt;</td>

</tr>

<tr>

<td>            </td>

<td>&lt;datasource jndi-name="java:jboss/datasources/SybaseDS" pool-name="SybaseDS" enabled="true"&gt;</td>

</tr>

<tr>

<td>                </td>

<td>&lt;connection-url&gt;jdbc:sybase:Tds:10.250.5.27:5000&lt;/connection-url&gt;</td>

</tr>

<tr>

<td>                </td>

<td>&lt;driver-class&gt;com.sybase.jdbc4.jdbc.SybDriver&lt;/driver-class&gt;</td>

</tr>

<tr>

<td>                </td>

<td>&lt;driver&gt;sybaseDriver&lt;/driver&gt;</td>

</tr>

<tr>

<td>                </td>

<td>&lt;security&gt;</td>

</tr>

<tr>

<td>                    </td>

<td>&lt;user-name&gt;sa&lt;/user-name&gt;</td>

</tr>

<tr>

<td>                    </td>

<td>&lt;password&gt;angels&lt;/password&gt;</td>

</tr>

<tr>

<td>                </td>

<td>&lt;/security&gt;</td>

</tr>

<tr>

<td>            </td>

<td>&lt;/datasource&gt;</td>

</tr>

<tr>

<td>            </td>

<td>&lt;drivers&gt;</td>

</tr>

<tr>

<td>                </td>

<td>&lt;driver name="h2" module="com.h2database.h2"&gt;</td>

</tr>

<tr>

<td>                    </td>

<td>&lt;xa-datasource-class&gt;org.h2.jdbcx.JdbcDataSource&lt;/xa-datasource-class&gt;</td>

</tr>

<tr>

<td>                </td>

<td>&lt;/driver&gt;</td>

</tr>

<tr>

<td>                </td>

<td>&lt;driver name="sybaseDriver" module="com.sybaseDS.sybaseDriver"/&gt;</td>

</tr>

<tr>

<td>            </td>

<td>&lt;/drivers&gt;</td>

</tr>

<tr>

<td>        </td>

<td>&lt;/datasources&gt;</td>

</tr>

<tr>

<td>    </td>

<td>&lt;/subsystem&gt;</td>

</tr>

<tr>

<td>    </td>

<td>&lt;subsystem xmlns="urn:jboss:domain:deployment-scanner:1.1"&gt;</td>

</tr>

 

And

 

...com\sybaseDS\sybase\main

 

&lt;module xmlns="urn:jboss:module:1.1" name="com.sybaseDS.sybaseDriver"&gt;<br>

    &lt;resources&gt;<br>

        &lt;resource-root path="jconn4.jar"/&gt;<br>

        &lt;!-- Insert resources here --&gt;<br>

    &lt;/resources&gt;<br>

    &lt;dependencies&gt;<br>

        &lt;module name="javax.api"/&gt;<br>

    &lt;/dependencies&gt;<br>

&lt;/module&gt;<br>

 

 

</tbody>

</table>

<p> </p></body>

Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community