JBoss Community

Sybase datasource config: New missing/unsatisfied dependencies

created by Gopinath Arumugam in Datasource Configuration - View the full discussion

Hi All,

 

I am stuck with this issue for almost 3 days and I had gone through quite a lot of posts regarding this " missing/unsatisfied dependencies " issue.

And finally I came here for expertise solution.

 

Hence I post it very briefly by writing down my standalone.xml, module.xml & logs.

 

standalone.xml:

 

<subsystem xmlns="urn:jboss:domain:datasources:1.0">

            <datasources>

 

                <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="H2DS" enabled="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:localhost:10553

                    </connection-url>

                    <driver>sybaseDriver</driver>

                    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>

                    <pool>

                        <min-pool-size>5</min-pool-size>

                        <max-pool-size>100</max-pool-size>

                        <prefill>true</prefill>

                    </pool>

                    <security>

                        <user-name>chomo</user-name>

                        <password>king</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.sybase">

                        <driver-class>com.sybase.jdbc4.jdbc.SybDriver</driver-class>

                        <xa-datasource-class>com.sybase.jdbc4.jdbc.SybDriver</xa-datasource-class>

                    </driver>

                </drivers>

            </datasources>

</subsystem>

 

modules.xml:

    

     Location:     D:\JBOSS\jboss-as-7.1.0.Beta1b\modules\com\sybaseDS\sybase\main

 

<module xmlns="urn:jboss:module:1.1" name="com.sybaseDS.sybase">

  <resources>

    <resource-root path="jconn4.jar"/>

  </resources>

  <dependencies>

    <module name="javax.api"/>

    <module name="javax.transaction.api"/>

    <module name="jboss-as-connector-7.1.0.Beta1b"/>

  </dependencies>

</module>

 

jconn4.jar is jdbc4 compliant.

 

Logs:

 

21:31:35,273 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-6) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]

21:31:35,389 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-1) JBAS015012: Started FileSystemDeploymentService for directory D:\JBOSS\jboss-as-7.1.0.Beta1b\standalone\deployments

21:31:35,395 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 jboss.data-source.java:jboss/datasources/SybaseDS]

..........................

 

21:07:29,617 INFO  [org.jboss.as.server.deployment] Stopped deployment jboss-annotations-api_1.1_spec-1.0.0.Final.jar in 37ms
21:07:29,617 INFO  [org.jboss.as.server.deployment] Stopped deployment javax.inject-1.jar in 36ms
21:07:29,617 INFO  [org.jboss.as.server.deployment] Stopped deployment Helloworld_servelet.jar in 37ms
21:07:29,633 INFO  [com.arjuna.ats.jbossatx] ARJUNA32014: Stopping transaction recovery manager
21:07:29,617 INFO  [org.jboss.as.server.deployment] Stopped deployment WebApps.war in 36ms
21:07:29,633 INFO  [org.jboss.as.server.deployment] Stopped deployment WebAppsEAR.ear in 44ms
21:07:29,633 INFO  [org.jboss.as.controller] JBAS014774: Service status reportJBAS014776:    Newly corrected services:
      service jboss.jdbc-driver.sybaseDriver (new available)

21:07:29,633 INFO  [org.jboss.as] JBoss AS 7.1.0.Beta1b "Tesla" stopped in 30ms
Terminate batch job (Y/N)?

 

 

Please do reply with your suggestions.

 

Regards,

Gopinath.K.A.

Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community