Configuring_MSSQL_with_soa_suite_11g:

1. SOA Suite is though deployed on Linux, in some situations it’s required to look for the windows

Versions of the file(sqljdbc.jar) referenced in this document.

While creating a data source the below error will be recived due to missing  MSSQL Server drivers in the domain Library.

Error Message

Cannot load driver: com.microsoft.jdbcx.sqlserver.SQLServerDataSource

Windows Version Details:

Version Details:

"Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)

                Dec 10 2010 10:56:29

                Copyright (c) 1988-2005 Microsoft Corporation

                Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

2. RUN TIME CONFIGURATION:

a.Copy the same sqljdbc.jar used for JDev above to the following locations

 WLS_HOME/server/lib: /u01/Oracle/Middleware/wlserver_10.3/server/lib

<user_projects/domains/soainfra/lib:> 

/u01/Oracle/Middleware/user_projects/domains/xyz_domain/lib

 

 

3. Edit the WEBLOGIC_CLASSPATH to point to the above locations. This is done by editing the file:
 
$WLS_HOME/common/bin/commEnv.sh: 

 /u01/Oracle/Middleware/wlserver_10.3/common/bin/commEnv.sh

WEBLOGIC_CLASSPATH="${JAVA_HOME}/lib/tools.jar${CLASSPATHSEP}/share/envConfig/jars/g11nutils.jar${CLASSPATHSEP}/share/envConfig/jars/wmbrokerclient.jar${CLASSPATHSEP}/share/envConfig/jars/jms.jar${CLASSPATHSEP}/share/envConfig/jars/wmjmsclient.jar${CLASSPATHSEP}/share/envConfig/QuartzConfig/soa_quartz.properties${CLASSPATHSEP}/share/envConfig/jars/commons-dbcp-1.2.2.jar${CLASSPATHSEP}/share/envConfig/jars/wmjmsnaming.jar${CLASSPATHSEP}/share/envConfig/jars/sqljdbc4.jar${CLASSPATHSEP}/share/envConfig/jars/MotFusionJavaErrorHandler.jar${CLASSPATHSEP}${WL_HOME}/server/lib/weblogic_sp.jar${CLASSPATHSEP}${WL_HOME}/server/lib/weblogic.jar${CLASSPATHSEP}${FEATURES_DIR}/weblogic.server.modules_10.3.4.0.jar${CLASSPATHSEP}${WL_HOME}/server/lib/webservices.jar${CLASSPATHSEP}${ANT_HOME}/lib/ant-all.jar${CLASSPATHSEP}${ANT_CONTRIB}/lib/ant-contrib.jar${CLASSPATHSEP}${WL_HOME}/server/libsqljdbc.jar${CLASSPATHSEP}${MW_HOME}/user_projects/domains/xyz_domain/lib/sqljdbc.jar

4.Create Datasource:

Open the weblogic Admin console and Goto the services------->Datasoruces

 

5. After this, create a new data source using screen shot below.

JNDI Name = jdbc/MSSQL

Don't worry about the Database driver we will change that manually in next steps. 

Click next

6. Then  Enter DB connection details

 

 

7. Modify the URL and the driver as follows and test connection

Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver

URL = jdbc:sqlserver://il0103.ds.dot.com :1433;databasename=ps_ebiz 

Connection Pool should look as shown below:

 

8. In the connection Pool page click on the Test Connections On Reserve, under the Advanced options.  

 

9. Define a JNDI Name, this should match you design time JNDI Name.

JNDI Name = eis/DB/MSSQL


   

10. Edit the new connection as below, you need to change the platformClassName and the xADataSourceName. When you make the change you have to press enter for it to register.

platformClassName = oracle.toplink.platform.database.SQLServerPlatform

xADataSourceName = jdbc/MSSQL

11. Update the Db adapter again to recognise the changes.

-------------HAppy SOA Configuring...........................:)Configuring_MSSQL_with_soa_suite_11g: