how to create a oracle conn pool......

[kashif iftikhar]

hi everyone,
my question is this that...how to create a oracle connection pool when oracle is installed on a seperate machine.
before this i have installed weblogic and oracle on the same machine therefore its very easy....now what to do as oracle 8i is on second computer

[Chris Mathews]

They are created in the same way.
If you are using a type-4 JDBC driver then just change the hostname of the database to connect to.
If you are using a type-2 JDBC driver then you will need the Oracle OCI client installed and you will need to configure the database connection in tnsnames.ora (use Net8 Assistant). Once this is done then just add the Connection Pool in WebLogic like you did before.