13 Replies Latest reply on Sep 16, 2011 3:10 AM by hai qing

    Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding"

    java0bject Newbie

      I am getting this in the server output:

       

      DEPLOYMENTS MISSING DEPENDENCIES:

        Deployment "persistence.unit:unitName=#cisCommonPU" is missing the following dependencies:

          Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=SybaseCssDS,service=DataSourceBinding' **")

        Deployment "persistence.unit:unitName=#cisDomainPU" is missing the following dependencies:

          Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=SybaseCssDS,service=DataSourceBinding' **")

       

      DEPLOYMENTS IN ERROR:

        Deployment "jboss.jca:name=SybaseCssDS,service=DataSourceBin

       

      =====================================

      when i check the server logs i see that it is getting bound:

      ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssAllPrd' from JNDI name 'java:SybaseCssAllPrd'

      15:16:00,515 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssAllPrd' to JNDI name 'java:SybaseCssAllPrd'

      15:16:00,578 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM01Prd' to JNDI name 'java:SybaseCssM01Prd'

      15:16:01,781 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM21Prd' to JNDI name 'java:SybaseCssM21Prd'

      15:16:01,890 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM22Prd' to JNDI name 'java:SybaseCssM22Prd'

      15:16:01,937 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM23Prd' to JNDI name 'java:SybaseCssM23Prd'

      15:16:01,999 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM24Prd' to JNDI name 'java:SybaseCssM24Prd'

       

       

       

      I have the SybaseCssDS-ds.xml file in the deploy folder of my server...

       

      Its Jboss5.x opn jdk5

        • 1. Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding"
          Mark Paluch Master

          Hi there,

          your PU depends on jboss.jca:name=SybaseCssDS but you have DS only for SybaseCssAllPrd, SybaseCssM24Prd, SybaseCssM23Prd, SybaseCssM22Prd, SybaseCssM21Prd and SybaseCssM01Prd

           

          Fix your typos and it should be fine.

           

          Best regards,

          Mark

          • 2. Re: Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding"
            java0bject Newbie

            Thank you for your quick response:

            Here is the scenario, My application was running on weblogic81 and i migrated it to Jboss 5.x and for the DB connection i we had 24 partitons that why in weblogic config we had something like:

            =======================

            <JDBCConnectionPool DriverName="com.sybase.jdbc2.jdbc.SybDriver"  Name="css_all_prd" Password="password"

                        Properties="user=userName;url=jdbc:sybase:Tds:cssvprd:7000/css_all_prd;networkProtocol=Tds;portNumber=7000;userName=userName;databaseName=css_all_prd;serverName=cssvprd"  StatementCacheSize="30" Targets="internalsrv1"

                        TestTableName="SQL SELECT COUNT(*) FROM sysobjects" URL="jdbc:sybase:Tds:cssvprd:7000/css_all_prd"/>

             

            <JDBCTxDataSource JNDIName="SybaseCssAllPrd" Name="SybaseCssAllPrd"

                     PoolName="css_all_prd" Targets="internalsrv1"/>

            ==============================

            for each connection so what i did is created a SybaseCssDS-ds.xml file and added something like this:

            <?xml version="1.0" encoding="UTF-8"?>

             

            <datasources>

             

               <xa-datasource>

                 <jndi-name>SybaseCssAllPrd</jndi-name>

                 <!-- uncomment to enable interleaving <interleaving/> -->

                 <xa-datasource-property name="URL">jdbc:sybase:Tds:cssvprd:7000/css_all_prd</xa-datasource-property>

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

                 <xa-datasource-property name="NetworkProtocol">Tds</xa-datasource-property>

                 <xa-datasource-property name="ServerName">cssvprd</xa-datasource-property>

                 <xa-datasource-property name="PortNumber">7000</xa-datasource-property>

                 <xa-datasource-property name="DatabaseName">css_all_prd</xa-datasource-property>

             

                 <!-- Use the security domain defined in conf/login-config.xml -->

                 <security-domain></security-domain>

                 <!-- or User/Password properties -->

                 <xa-datasource-property name="User">userName</xa-datasource-property>

                 <xa-datasource-property name="Password">Password</xa-datasource-property>

             

                 <min-pool-size>1</min-pool-size>

                 <max-pool-size>20</max-pool-size>

                 <idle-timeout-minutes>15</idle-timeout-minutes>

                 <check-valid-connection-sql>SELECT COUNT(*) FROM sysobjects</check-valid-connection-sql>

                 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>

                 <type-mapping>Sybase</type-mapping>

             

               </xa-datasource>

             

                <xa-datasource>

                 <jndi-name>SybaseCssM01Prd</jndi-name>

                 <!-- uncomment to enable interleaving <interleaving/> -->

                 <xa-datasource-property name="URL">jdbc:sybase:Tds:cssvprd:7000/css_m01_prd      </xa-datasource-property>

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

                 <xa-datasource-property name="NetworkProtocol">Tds</xa-datasource-property>

                 <xa-datasource-property name="ServerName">cssvprd</xa-datasource-property>

                 <xa-datasource-property name="PortNumber">7000</xa-datasource-property>

                 <xa-datasource-property name="DatabaseName">css_m01_prd</xa-datasource-property>

             

                 <!-- Use the security domain defined in conf/login-config.xml -->

                 <security-domain></security-domain>

                 <!-- or User/Password properties -->

                 <xa-datasource-property name="User">userName</xa-datasource-property>

                 <xa-datasource-property name="Password">password</xa-datasource-property>

             

                 <min-pool-size>1</min-pool-size>

                 <max-pool-size>20</max-pool-size>

                 <idle-timeout-minutes>15</idle-timeout-minutes>

                 <check-valid-connection-sql>SELECT COUNT(*) FROM sysobjects</check-valid-connection-sql>

                 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>

                 <type-mapping>Sybase</type-mapping>

             

               </xa-datasource>

            =================================

            for each connection.

             

            Now when i fireup jboss i see the following in console:

            2011-03-09 14:55:10,013 INFO  [org.quartz.core.QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.

            2011-03-09 14:55:10,713 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssAllPrd' to JNDI name 'java:SybaseCssAllPrd'

            2011-03-09 14:55:10,806 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM01Prd' to JNDI name 'java:SybaseCssM01Prd'

            2011-03-09 14:55:10,853 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM02Prd' to JNDI name 'java:SybaseCssM02Prd'

            2011-03-09 14:55:10,915 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM03Prd' to JNDI name 'java:SybaseCssM03Prd'

            2011-03-09 14:55:10,962 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM04Prd' to JNDI name 'java:SybaseCssM04Prd'

            2011-03-09 14:55:11,008 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM05Prd' to JNDI name 'java:SybaseCssM05Prd'

            2011-03-09 14:55:11,086 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM06Prd' to JNDI name 'java:SybaseCssM06Prd'

            2011-03-09 14:55:11,133 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM07Prd' to JNDI name 'java:SybaseCssM07Prd'

            2011-03-09 14:55:11,179 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM08Prd' to JNDI name 'java:SybaseCssM08Prd'

            2011-03-09 14:55:11,226 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM09Prd' to JNDI name 'java:SybaseCssM09Prd'

            2011-03-09 14:55:11,288 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM10Prd' to JNDI name 'java:SybaseCssM10Prd'

            2011-03-09 14:55:11,366 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM11Prd' to JNDI name 'java:SybaseCssM11Prd'

            2011-03-09 14:55:11,413 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM12Prd' to JNDI name 'java:SybaseCssM12Prd'

            2011-03-09 14:55:11,459 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM13Prd' to JNDI name 'java:SybaseCssM13Prd'

            2011-03-09 14:55:11,506 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM14Prd' to JNDI name 'java:SybaseCssM14Prd'

            2011-03-09 14:55:11,568 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM15Prd' to JNDI name 'java:SybaseCssM15Prd'

            2011-03-09 14:55:11,646 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM16Prd' to JNDI name 'java:SybaseCssM16Prd'

            2011-03-09 14:55:11,693 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM17Prd' to JNDI name 'java:SybaseCssM17Prd'

            2011-03-09 14:55:11,739 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM18Prd' to JNDI name 'java:SybaseCssM18Prd'

            2011-03-09 14:55:11,786 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM19Prd' to JNDI name 'java:SybaseCssM19Prd'

            2011-03-09 14:55:11,848 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM20Prd' to JNDI name 'java:SybaseCssM20Prd'

            2011-03-09 14:55:11,926 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM21Prd' to JNDI name 'java:SybaseCssM21Prd'

            2011-03-09 14:55:11,973 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM22Prd' to JNDI name 'java:SybaseCssM22Prd'

            2011-03-09 14:55:12,019 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM23Prd' to JNDI name 'java:SybaseCssM23Prd'

            2011-03-09 14:55:12,066 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=SybaseCssM24Prd' to JNDI name 'java:SybaseCssM24Prd'

            2011-03-09 14:55:13,030 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'

            2011-03-09 14:55:13,839 INFO  [org.jboss.jms.server.ServerPeer] JBoss Messaging 1.4.6.GA server [0] started

            --------------------------------------

            but just beofre the end when server startup is displayed i see the error :

            DEPLOYMENTS MISSING DEPENDENCIES:

              Deployment "persistence.unit:unitName=#cisCommonPU" is missing the following dependencies:

                Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=SybaseCssDS,service=DataSourceBinding' **")

              Deployment "persistence.unit:unitName=#cisDomainPU" is missing the following dependencies:

                Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=SybaseCssDS,service=DataSourceBinding' **")

             

            DEPLOYMENTS IN ERROR:

              Deployment "jboss.jca:name=SybaseCssDS,service=DataSourceBinding" is in error due to the following reason(s): ** NOT FOUND Depends on 'jboss.jca:name=SybaseCssDS,service=DataSourceBinding' **

             

             

            Now sure if i am doing something wrong in the SybaseCssDS-ds.xml ..... Please advice

            • 3. Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding"
              java0bject Newbie

              Any one from jboss community...Please help.

              • 4. Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding"
                java0bject Newbie

                i have resolved the issue with the error i was getting :

                DEPLOYMENTS MISSING DEPENDENCIES:

                  Deployment "persistence.unit:unitName=#cisCommonPU" is missing the following dependencies:

                    Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=SybaseCssDS,service=DataSourceBinding' **")

                  Deployment "persistence.unit:unitName=#cisDomainPU" is missing the following dependencies:

                    Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=SybaseCssDS,service=DataSourceBinding' **")

                 

                DEPLOYMENTS IN ERROR:

                  Deployment "jboss.jca:name=SybaseCssDS,service=DataSourceBinding" is in error due to the following reason(s): ** NOT FOUND Depends on 'jboss.jca:name=SybaseCssDS,service=DataSourceBinding' **

                 

                This is resolved

                • 5. Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding"
                  Ales Justin Master

                  This is resolved

                  How? What was the issue? ...

                   

                  If you're not explaining this things, you're not "playing fair".

                   

                  Otoh, you expect people to help you, again:

                  * http://community.jboss.org/message/598253#598253

                  • 6. Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding"
                    java0bject Newbie

                    Hi buddy,

                    I was not aware that some one is even looking at this post ? as i did not get any reply/help ......

                    Anyways the issue was with the jar files "cis-***-versionNumeber.jar " one of this file has default sybase datasource registered in that, as i did not need all these jar's for my application as its a simple application, i removed thoses jar's from the deploy folder and .... it worked .

                    I dont see any Datasource issues now.

                    • 9. Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding"
                      java0bject Newbie

                      Any one ever look at this forum ? from JBOSS support ?\

                      • 11. Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding"
                        java0bject Newbie

                        Thank you for the response Justin.

                        I am getting second thoughts about migrating the application to jboss. better stay back on what we have

                        Thanks anyways

                        • 12. Dependency "jboss.jca:name=SybaseCssDS,service=DataSourceBinding"
                          java0bject Newbie

                          After a string struggle and sleepless nights i am able to make this thing work .......