9:27 a.m.
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><subsystem
xmlns="urn:jboss:domain:datasources:1.0"></td>
</tr>
<tr>
<td> </td>
<td><datasources></td>
</tr>
<tr>
<td> </td>
<td><datasource jndi-name="java:jboss/datasources/ExampleDS"
pool-name="ExampleDS" enabled="true"
use-java-context="true"></td>
</tr>
<tr>
<td> </td>
<td><connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url></td>
</tr>
<tr>
<td> </td>
<td><driver>h2</driver></td>
</tr>
<tr>
<td> </td>
<td><security></td>
</tr>
<tr>
<td> </td>
<td><user-name>sa</user-name></td>
</tr>
<tr>
<td> </td>
<td><password>sa</password></td>
</tr>
<tr>
<td> </td>
<td></security></td>
</tr>
<tr>
<td> </td>
<td></datasource></td>
</tr>
<tr>
<td> </td>
<td><datasource jndi-name="java:jboss/datasources/SybaseDS"
pool-name="SybaseDS" enabled="true"></td>
</tr>
<tr>
<td> </td>
<td><connection-url>jdbc:sybase:Tds:10.250.5.27:5000</connection-url></td>
</tr>
<tr>
<td> </td>
<td><driver-class>com.sybase.jdbc4.jdbc.SybDriver</driver-class></td>
</tr>
<tr>
<td> </td>
<td><driver>sybaseDriver</driver></td>
</tr>
<tr>
<td> </td>
<td><security></td>
</tr>
<tr>
<td> </td>
<td><user-name>sa</user-name></td>
</tr>
<tr>
<td> </td>
<td><password>angels</password></td>
</tr>
<tr>
<td> </td>
<td></security></td>
</tr>
<tr>
<td> </td>
<td></datasource></td>
</tr>
<tr>
<td> </td>
<td><drivers></td>
</tr>
<tr>
<td> </td>
<td><driver name="h2"
module="com.h2database.h2"></td>
</tr>
<tr>
<td> </td>
<td><xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class></td>
</tr>
<tr>
<td> </td>
<td></driver></td>
</tr>
<tr>
<td> </td>
<td><driver name="sybaseDriver"
module="com.sybaseDS.sybaseDriver"/></td>
</tr>
<tr>
<td> </td>
<td></drivers></td>
</tr>
<tr>
<td> </td>
<td></datasources></td>
</tr>
<tr>
<td> </td>
<td></subsystem></td>
</tr>
<tr>
<td> </td>
<td><subsystem
xmlns="urn:jboss:domain:deployment-scanner:1.1"></td>
</tr>
And
...com\sybaseDS\sybase\main
<module xmlns="urn:jboss:module:1.1"
name="com.sybaseDS.sybaseDriver"><br>
<resources><br>
<resource-root path="jconn4.jar"/><br>
<!-- Insert resources here --><br>
</resources><br>
<dependencies><br>
<module name="javax.api"/><br>
</dependencies><br>
</module><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&...]
9:38 a.m.
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/731692#731692
--------------------------------------------------------------
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. Here's what I have:
08:05:58,357 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread
1-1) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS] 08:05:58,982 INFO
[org.jboss.as.controller] (Controller Boot Thread) JBAS014774 : Service status report
JBAS014775: New missing/unsatisfied dependencies: service
jboss.jdbc-driver.sybaseDriver (missing) dependents: [service jbos
s.data-source.java:jboss/datasources/SybaseDS]
...\standalone\configuration\standalone.xml ...
jdbc:h2:mem:test;DB_CLOSE_DELAY=-1 h2 sa sa
jdbc:sybase:Tds:10.250.5.27:5000 com.sybase.jdbc4.jdbc.SybDriver
sybaseDriver sa angels
org.h2.jdbcx.JdbcDataSource ... And
...com\sybaseDS\sybase\main
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/731692#731692]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
9:39 a.m.
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/731694#731694
--------------------------------------------------------------
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.
Here's what I have:
08:05:58,357 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service
thread 1-1) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]
08:05:58,982 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774
: Service status report
JBAS014775: New missing/unsatisfied dependencies:
service jboss.jdbc-driver.sybaseDriver (missing) dependents: [service jbos
s.data-source.java:jboss/datasources/SybaseDS]
...\standalone\configuration\standalone.xml
<subsystem xmlns="urn:jboss:domain:datasources:1.0">
...
<datasources>
<datasource jndi-name="java:jboss/datasources/ExampleDS"
pool-name="ExampleDS" enabled="true"
use-java-context="true">
<connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
<driver>h2</driver>
<security>
<user-name>sa</user-name>
<password>sa</password>
</security>
</datasource>
<datasource jndi-name="java:jboss/datasources/SybaseDS"
pool-name="SybaseDS" enabled="true">
<connection-url>jdbc:sybase:Tds:10.250.5.27:5000</connection-url>
<driver-class>com.sybase.jdbc4.jdbc.SybDriver</driver-class>
<driver>sybaseDriver</driver>
<security>
<user-name>sa</user-name>
<password>angels</password>
</security>
</datasource>
<drivers>
<driver name="h2" module="com.h2database.h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
</driver>
<driver name="sybaseDriver"
module="com.sybaseDS.sybaseDriver"/>
</drivers>
</datasources>
...
</subsystem>
And
...com\sybaseDS\sybase\main
<module xmlns="urn:jboss:module:1.1"
name="com.sybaseDS.sybaseDriver">
<resources>
<resource-root path="jconn4.jar"/>
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/731694#731694]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
5105
days inactive
5105
days old
2 comments
1 participants
participants (1)
-
Carey Brown