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
2nd Stage:
On the WebLogic Side:
4.Edit the C:\Oracle\Middleware\
and add the following line to the end of this file
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)
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