[jboss-user] [Datasource Configuration] - Re: Sybase datasource config: New missing/unsatisfied dependencies

Carey Brown do-not-reply at jboss.com
Mon Apr 23 10:27:43 EDT 2012


Carey Brown [https://community.jboss.org/people/carey.brown] created the discussion

"Re: Sybase datasource config: New missing/unsatisfied dependencies"

To view the discussion, visit: https://community.jboss.org/message/731687#731687

--------------------------------------------------------------
<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
[https://community.jboss.org/message/731687#731687]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120423/bf08e751/attachment-0001.html 


More information about the jboss-user mailing list