Creating a connection pools in weblogic 8.1

Follow the below steps for doing manually

Go to C:\software\bea\weblogic\8.1\sp4\user_projects\domains\uprr_desktop\ config.xml

Entry in the file:-

Name="iee_TeraPoolDS" PoolName="iee_TeraPool" Targets="desktop_server"/>

MaxCapacity="1" Name="iee_TeraPool" Password="?" Properties="user=? " Targets="desktop_server" URL="jdbc:teradata://edwprdi0.edw.tla.uprr.com"/>

Note: - Password="?" Properties="user=? " still we don’t know the username and password for teradata connection.

Name="iee_PoolTXDS" PoolName="IEE Connection Pool" Targets="desktop_server"/>

ConnProfilingEnabled="true" DriverName="oracle.jdbc.driver.OracleDriver" MaxCapacity="2" Name="IEE Connection Pool" Password=" iee123 " Properties="user=DIEE999" Targets="desktop_server" TestConnectionsOnCreate="true" TestConnectionsOnRelease="true" TestConnectionsOnReserve="true" TestFrequencySeconds="5" TestTableName="SQL SELECT 1 FROM DUAL" URL="jdbc:oracle:thin:@dev184.oracle.uprr.com:1521:dev184"/>

Also make sure that teradata home is present in the startWeblogic.cmd file if not follow the below steps

Along with the above configuration we have to set the teradata home in startWeblogic.cmd file

set TERADATA_HOME=%WL_HOME%\common\eval\teradata

set TERADATA_CLASSPATH=%TERADATA_HOME%;%TERADATA_HOME%\lib\terajdbc4.jar;%TERADATA_HOME%\lib\tdgssjava.jar;%TERADATA_HOME%\TdgssUserConfigFile.xml