Procedure for Driver Installation
1. We should use an administrative user on Server Console for copy and paste an artifact.(Example: weblogic).
2. Copy & Paste jdbcdriver-XXX.jar artifact inside the following path: ${WL_HOME}/server/lib/
${WL_HOME} is the path where is installed binary files of Oracle Weblogic, as example of that is the following path:
/root/Oracle/Middleware/wlserver_10.3/server/lib/
3. Add permissions to the artifact executing the following sentences:
chmod 755 ${WL_HOME}/server/lib/jdbcdriver-XXX.jar
4. Open the following file inside ${WL_HOME}/server/lib
jdbcdrivers.xml
EXAMPLE (SQL SERVER 2008 R2):
<Driver
Database="MS SQL
Server"
Vendor="Microsoft"
Type="Type 4"
DatabaseVersion="2005 and
later"
ForXA="false"
ClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
URLHelperClassname="weblogic.jdbc.utils.MSSQL2005JDBC4DriverURLHelper"
TestSql="SELECT
1">
<Attribute
Name="DbmsName" Required="true" InURL="true"/>
<Attribute
Name="DbmsHost" Required="true" InURL="true"/>
<Attribute
Name="DbmsPort" Required="true" InURL="true"
DefaultValue="1433"/>
<Attribute
Name="DbmsUsername" Required="true"
InURL="false"/>
<Attribute
Name="DbmsPassword" Required="true"
InURL="false"/>
</Driver>
<Driver
Database="MS SQL
Server"
Vendor="Microsoft"
Type="Type 4"
DatabaseVersion="2005 and
later"
ForXA="true"
ClassName="com.microsoft.sqlserver.jdbc.SQLServerXADataSource"
URLHelperClassname="weblogic.jdbc.utils.MSSQL2005JDBC4DriverURLHelper"
TestSql="SELECT
1">
<Attribute
Name="DbmsName" Required="true" InURL="true"/>
<Attribute
Name="DbmsHost" Required="true" InURL="true"/>
<Attribute
Name="DbmsPort" Required="true" InURL="true"
DefaultValue="1433"/>
<Attribute
Name="DbmsUsername" Required="true"
InURL="false"/>
<Attribute
Name="DbmsPassword" Required="true"
InURL="false"/>
</Driver>
This snippet contains a description of Driver Class and the proper use of it inside Oracle Weblogic Driver declaration.
The way to choose where it should be add the above lines is looking for the vendor of you jdbc driver, In my case is a SQL Server 2008 R2 so I identify where is SQL SERVER part of code and after the final bracket I add above code.
5. Go to the following path:
${WL_HOME}/common/bin
Example: /root/Oracle/Middleware/wlserver_10.3/common/bin
Open a file called: commEnv.sh
You should locate the following lines:
(Search between the lines of : # set up WebLogic Server's class path):
Inside of WEBLOGIC_CLASSPATH add the following line:
${CLASSPATHSEP}${WL_HOME}/server/lib/sqljdbc4.jar
You should have a variable declared likes this one:
WEBLOGIC_CLASSPATH="${JAVA_HOME}/lib/tools.jar${CLASSPATHSEP}${WL_HOME}/server/lib/weblogic_sp.jar${CLASSPATHSEP}${WL_HOME}/server/lib/weblogic.jar${CLASSPATHSEP}${FEATURES_DIR}/weblogic.server.modules_10.3.5.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/lib/sqljdbc4.jar"
After of doing step briefly commented above, you should have to restarted all your servers including administrative console, and If you declare a driver, you will get a Database Driver declared as you did it.
Best regards,
