Configuring weblogic with postgresql Database

Follow these steps to connect Weblogic with Postgresql database:

1. Download postgresql setup from here
2. Download postgresql connection jar  file from here
3. install postgres database on your PC [during setup, you will enter database password]
4. create a database using postgres pgadmin interface [ex: database name: tdb]
5. put jar file some where on your pc [ex: C:\jars\postgresql-9.0-801.jdbc3.jar]
6. edit file setDomainEnv.cmd under integration directory inside weblogic home directory  [ex: C:\bea\weblogic81\samples\domains\integration]
7. add jar file path [C:\jars\postgresql-9.0-801.jdbc3.jar] at line 1999.
   [ex: set CLASSPATH=%ARDIR%\ant\ant.jar;%JAVA_HOME%\jre\lib\rt.jar;C:\jars\postgresql-9.0-801.jdbc3.jar]
8. open weblogic and start weblogic server
9. click on tools menu, then weblogic server=> data source viewer
10. click on New Data Source
11. fill data source form:
    data Source:postgres
    pool : postgresbool
    driver: select [org.postgresql.Driver]
    url: jdbc://postgresql://localhost:5432/tdb
    user: postgres
    password: password that you entered in postgres installation