Friday, December 9, 2011

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


No comments:

Post a Comment