<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Re: Sybase datasource config: New missing/unsatisfied dependencies
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/carey.brown">Carey Brown</a> in <i>Datasource Configuration</i> - <a href="https://community.jboss.org/message/731687#731687">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p><body><p></p><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> </p></p><p><p>Here's what I have:</p></p><p><p> </p></p><p><p>08:05:58,357 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service</p></p><p><p>thread 1-1) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]</p></p><p><p>08:05:58,982 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774</p></p><p><p>: Service status report</p></p><p><p>JBAS014775:    New missing/unsatisfied dependencies:</p></p><p><p>      service jboss.jdbc-driver.sybaseDriver (missing) dependents: [service jbos</p></p><p><p>s.data-source.java:jboss/datasources/SybaseDS]</p></p><p><p> </p></p><p><p> ...\standalone\configuration\standalone.xml</p></p><p><p> </p></p><p><table></p><p><tbody></p><p><tr></p><p><td>    </td></p><p><td>&lt;subsystem xmlns="urn:jboss:domain:datasources:1.0"&gt;</td></p><p></tr></p><p><tr></p><p><td>        </td></p><p><td>&lt;datasources&gt;</td></p><p></tr></p><p><tr></p><p><td>            </td></p><p><td>&lt;datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true"&gt;</td></p><p></tr></p><p><tr></p><p><td>                </td></p><p><td>&lt;connection-url&gt;jdbc:h2:mem:test;DB_CLOSE_DELAY=-1&lt;/connection-url&gt;</td></p><p></tr></p><p><tr></p><p><td>                </td></p><p><td>&lt;driver&gt;h2&lt;/driver&gt;</td></p><p></tr></p><p><tr></p><p><td>                </td></p><p><td>&lt;security&gt;</td></p><p></tr></p><p><tr></p><p><td>                    </td></p><p><td>&lt;user-name&gt;sa&lt;/user-name&gt;</td></p><p></tr></p><p><tr></p><p><td>                    </td></p><p><td>&lt;password&gt;sa&lt;/password&gt;</td></p><p></tr></p><p><tr></p><p><td>                </td></p><p><td>&lt;/security&gt;</td></p><p></tr></p><p><tr></p><p><td>            </td></p><p><td>&lt;/datasource&gt;</td></p><p></tr></p><p><tr></p><p><td>            </td></p><p><td>&lt;datasource jndi-name="java:jboss/datasources/SybaseDS" pool-name="SybaseDS" enabled="true"&gt;</td></p><p></tr></p><p><tr></p><p><td>                </td></p><p><td>&lt;connection-url&gt;jdbc:sybase:Tds:10.250.5.27:5000&lt;/connection-url&gt;</td></p><p></tr></p><p><tr></p><p><td>                </td></p><p><td>&lt;driver-class&gt;com.sybase.jdbc4.jdbc.SybDriver&lt;/driver-class&gt;</td></p><p></tr></p><p><tr></p><p><td>                </td></p><p><td>&lt;driver&gt;sybaseDriver&lt;/driver&gt;</td></p><p></tr></p><p><tr></p><p><td>                </td></p><p><td>&lt;security&gt;</td></p><p></tr></p><p><tr></p><p><td>                    </td></p><p><td>&lt;user-name&gt;sa&lt;/user-name&gt;</td></p><p></tr></p><p><tr></p><p><td>                    </td></p><p><td>&lt;password&gt;angels&lt;/password&gt;</td></p><p></tr></p><p><tr></p><p><td>                </td></p><p><td>&lt;/security&gt;</td></p><p></tr></p><p><tr></p><p><td>            </td></p><p><td>&lt;/datasource&gt;</td></p><p></tr></p><p><tr></p><p><td>            </td></p><p><td>&lt;drivers&gt;</td></p><p></tr></p><p><tr></p><p><td>                </td></p><p><td>&lt;driver name="h2" module="com.h2database.h2"&gt;</td></p><p></tr></p><p><tr></p><p><td>                    </td></p><p><td>&lt;xa-datasource-class&gt;org.h2.jdbcx.JdbcDataSource&lt;/xa-datasource-class&gt;</td></p><p></tr></p><p><tr></p><p><td>                </td></p><p><td>&lt;/driver&gt;</td></p><p></tr></p><p><tr></p><p><td>                </td></p><p><td>&lt;driver name="sybaseDriver" module="com.sybaseDS.sybaseDriver"/&gt;</td></p><p></tr></p><p><tr></p><p><td>            </td></p><p><td>&lt;/drivers&gt;</td></p><p></tr></p><p><tr></p><p><td>        </td></p><p><td>&lt;/datasources&gt;</td></p><p></tr></p><p><tr></p><p><td>    </td></p><p><td>&lt;/subsystem&gt;</td></p><p></tr></p><p><tr></p><p><td>    </td></p><p><td>&lt;subsystem xmlns="urn:jboss:domain:deployment-scanner:1.1"&gt;</td></p><p></tr></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>And</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>...com\sybaseDS\sybase\main</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>&lt;module xmlns="urn:jboss:module:1.1" name="com.sybaseDS.sybaseDriver"&gt;<br></p><p>    &lt;resources&gt;<br></p><p>        &lt;resource-root path="jconn4.jar"/&gt;<br></p><p>        &lt;!-- Insert resources here --&gt;<br></p><p>    &lt;/resources&gt;<br></p><p>    &lt;dependencies&gt;<br></p><p>        &lt;module name="javax.api"/&gt;<br></p><p>    &lt;/dependencies&gt;<br></p><p>&lt;/module&gt;<br></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p></tbody></p><p></table></p><p><p> </p></body></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/731687#731687">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>