Configuring Jdev to work with Undefined Databases such as PostGreSql and Ram etc

In one of my project i had to interact with the postgreSql Database.

But when i came to JDeveloper and wanted to create a connection for Database.

I did not find any JavaLibFile.

You need to Basically do Two things.

On Jdev(Client) Machine.

1. Download the JDBC4 jar file for Postgresql from http://jdbc.postgresql.org/download/postgresql-9.1-901.jdbc4.jar

Accept and download the file.

2. Create a Folder MiscJars in the Drive where you have installed Oracle Jdeveloper.
I Have installed in C Drive/Oracle.

3.Copy the Previously Download PostGresql-9.1-901 jar File.

4.Edit the C:\Oracle\Middleware\jdeveloper\jdev\bin\jdev.conf file(You need to open in Notepad)
 and add the following line to the end of this file

     AddJavaLibFile C:\Oracle\MiscJars\postgresql-9.1-901.jdbc4.jar

4. Start JDeveloper, and create a database connection with the foll params:

Go to File-->Connections-->DataBase Connection

    Connection Name: Postgresql

    Connection Type: Generic JDBC

    Username: soa

    Password: welcome1

    Driver Class: org.postgresql.Driver (Click new and give the name and browse to the Jar File)

    JDBC URL: jdbc:postgresql://localhost:5432/soa

Please do not select any role to the User.

2nd Stage:

On the WebLogic Side:

1. Download the JDBC4 jar file for Postgresql from http://jdbc.postgresql.org/download/postgresql-9.1-901.jdbc4.jar

2. Copy the jar file to /soa05/app/oracle/fusiondev/wlserver_10.3/common/lib directory

3. Edit the file /soa05/app/oracle/fusiondev/wlserver_10.3/common/bin/commEnv.sh and prepend the 

CLASSPATH with this jar file location (as follows)

 WEBLOGIC_CLASSPATH="${WL_HOME}/common/lib/postgresql-9.1-901.jdbc4.jar${CLASSPATHSEP}......."     (NOTE: ...... means the value already existing before we edited this file. DO NOT modify/delete them. Instead, just add the bold text right at the start of the classpath value.

4. Restart the weblogic server

This is my First Blog...Anything and Everything

Quite a while I wanted to share my Knowledge in SOA related products.

Alas, I created this blog, Hope this would be helpful and outstanding.


Thanks,

Tirumala Dixit.