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