If I recall correctly, that error happens when the database isn't being
found. Is the Oracle listener running and properly configured? If it is and
you can connect from other applications then maybe your jdbc url is wrong.
Your url should look like this:
jdbc:oracle:thin:@SERVERNAME:1521:SID
Hal
-----Original Message-----
From: Tom Maccariella [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 4:18 PM
To: '[EMAIL PROTECTED]'
Subject: data-sources for oracle
Simple question: I'm trying to test an oracle database connection via the
<data-sources> configuation settings. Below is a sample from my
struts-config.xml file:
------------
<struts-config>
<data-sources>
<data-source
autoCommit="true"
description="Oracle Sample"
driverClass="oracle.jdbc.driver.OracleDriver"
maxCount="4"
minCount="2"
password="user"
url="jdbc:oracle:thin:SERVERNAME:1521:SID"
user="password"/>
</data-sources>
</struts-config>
------------
where SERVERNAME is the hostname of the database server
and SID is the oracle sid
This produces the following exception:
------------
action: Exception initializing application data source
org.apache.struts.action.DATA_SOURCE java.sql.SQLException:
The Network Adapter could not establish the connection
------------
Any insight would be greatly appreciated.
-Tom
---
Tom Maccariella
sengen
[EMAIL PROTECTED]
www.sengen.com
