|
Problem |
Failure to connect to an Oracle JDBC data source with the
following error:
[5/4/04 7:43:02:153 CDT] 47164d ResourceMgrIm I WSVR0049I: Binding
ABC1234 as jdbc/ABC1234
[5/4/04 7:43:02:281 CDT] 47164d DataSourceCon E DSRA8040I: Failed
to connect to the DataSource. Encountered : java.lang.Exception:java
[5/4/04 7:43:02:153 CDT] 47164d ResourceMgrIm I WSVR0049I: Binding
WEBSPHERE as jdbc/WEBSPHERE
[5/4/04 7:43:02:281 CDT] 47164d DataSourceCon E DSRA8040I: Failed
to connect to the DataSource. Encountered : java.lang.Exception:
java.sql.SQLException: Invalid Oracle URL specified
|
|
Cause |
Malformed Oracle database URL in resources.xml |
|
Solution |
Review the resources.xml and check the URL of the database
from which the data source obtains connections to make sure all colons are
in place, and that there are no typos.
Here are examples of properly formed Oracle database URLs:
- Oracle THIN driver:
jdbc:oracle:thin:@localhost:1521:sample
- Oracle THICK driver:
jdbc:oracle:oci8:@sample
|
|