JVM in Oracle Apps 11i

Google
 
Web teachmeoracle.com
Home Overview Architecture Installation Patching Training Feedback
 
My Blog
WebServer
Concurrent
Autoconfig
Cloning
Training
Apps Interview Q's
Tuning
Contact Us
 
 
My Favourites
Health Check 11i
11i Interview Q's
 
 
    How to find JDBC thin driver that your iAS 1.0.2.2.2 is using ?

I am posting a simple java program & procedure to compile it that will give your jdbc thin driver version.

Create a file with name JDBCVersion.java in your middle tier (Application Tier)

---------
import java.sql.*;
import oracle.jdbc.driver.*;
class JDBCVersion
{
public static void main (String args[])
throws SQLException
{
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// Get a connection to a database
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=YES)(FAILOVER=YES) (ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST= <hostname>) (PORT= <portno>)))(CONNECT_DATA=(SID=<yoursid>)))" ,"apps","<appspaswd>");
// Create Oracle DatabaseMetaData object
DatabaseMetaData meta = conn.getMetaData();
// gets driver info:
System.out.println("JDBC driver version is " + meta.getDriverVersion());
}
}
-----------

Replace following parameters
1. <hostname> with your database hostname or IP address
2. <portno> with your database port no.
3. <yoursid> with SID for your database
4. <appspassword> with your apps password

After changing save it with name JDBCVersion.java in your middle tier & execute command
javac JDBCVersion.java
This will create class file in your workign directory. Include your current directory into your classpath like
export CLASSPATH=$CLASSPATH:/<location where JDBCVersion.class created by above program>
then execute

java JDBCVersion
you should see output like
JDBC driver version is 9.2.0.6.0
Which means you are using jdbc thin driver version 9.2.0.6.0.

Original Page
 

Oracle Apps 11i | Oracle Portal | Collaboration Suite | My Blog
Copyright © teachmeoracle.com
This work is copyright protected, Copying content from this site is illegal