Name: OracleXAConnectionPool
URL: jdbc:oracle:thin:@myServer:1521:mySid
DriverName: oracle.jdbc.xa.client.XADataSource
user=user
password=password
dataSourceName=TXOraclePool
protocol=thin
and the target server is on of my WLS servers. When I am trying to bring the server
up, it is throwing the exception:
<Apr 3, 2001 8:50:49 AM EDT> <Error> <JDBC Connection Pool> <Cannot startup connection
pool "OracleXAConnectionPool" weblogic.common.ResourceException: java.sql.SQLException:
Invalid Oracle URL specified: OracleDataSource.makeURL
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:775)
at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:413)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:100)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection
Thanks in advance for the help.
ravi.
"Ravi Nagulapalli" <ravi...@cheerful.com> wrote in message
news:3ac9...@newsgroups.bea.com...
I was having a similar problem using the Oracle Thin driver.
I'm using Oracle 8.1.7.0 on WL 6.0.
I figured out that I had to set my pool configuration info as follows:
(I set up all my connection pools using the Admin console)
URL---> jdbc:oracle:thin:@myMachineNameHere:1521:mySIDHere
Driver Name---> oracle.jdbc.driver.OracleDriver
Properties-->
user=scott
password=tiger
My PATH looks like:
set PATH=;%ORACLE_HOME%\jdbc\lib;%WL_HOME%\bin;%WL_HOME%\bin\oci817_8;%PATH%
(%WL_HOME%\bin\oci817_8 is probably not necessary for you.)
My CLASSPATH looks like:
set CLASSPATH=%ORACLE_HOME%\bin;%ORACLE_HOME%\jdbc\lib\classes12.zip;%ORACLE_HOME%\jdbc\lib\nls_charset12.zip;.;%WL_HOME%\lib\weblogic_sp.jar;%WL_HOME%\lib\weblogic.jar;%WL_HOME%\samples\eval\cloudscape\lib\cloudscape.jar;
Hope this helps.