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

Carey Brown do-not-reply at jboss.com
Mon Apr 23 10:39:56 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/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&containerType=14&container=2077]

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


More information about the jboss-user mailing list