Hello,
i tried your suggestion but i continue getting the same error.
javax.servlet.UnavailableException: Initializing application data source
org.apache.struts.action.DATA_SOURCE
at
org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j
ava:1091)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
at javax.servlet.GenericServlet.init(GenericServlet.java:256)
we are porting a legacy application to struts and i am using now the same
connection URL.
<data-source>
<set-property property="driverClassName"
value="oracle.jdbc.driver.OracleDriver" />
<set-property property="url" value="jdbc:oracle:oci8:@ora9i" />
<set-property property="username" value="******" />
<set-property property="password" value="*****" />
<set-property property="autoCommit" value="true" />
<set-property property="maxCount" value="4" />
<set-property property="minCount" value="2" />
<set-property property="validationQuery" value="SELECT 1+1 from
dual" />
</data-source>
any futher suggestions o clues? pls help this is urgent.
regards
rajat
----- Original Message -----
From: "McCormack, Chris" <[EMAIL PROTECTED]>
To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, March 25, 2004 4:58 PM
Subject: RE: db error
It doesnt appear to be a case of missing classes etc
This exception seems pretty descriptive :
UnavailableException: Initializing application data source
org.apache.struts.action.DATA_SOURCE
It looks like struts cannot physically get a connection to the specified
source, so
a. it doesnt exist
b. it does exist but your application cannot get to the source (routing
issue?)
c. there is a typo in the connection details.
d. the connection details are setup incorrectly.
there are other factors etc but I would say this is an initial check list.
<data-source key="dev.sitea" >
<set-property property="autoCommit" value="true"
/>
<set-property property="description" value="JDBC
data source"/>
<set-property property="driverClass"
value="oracle.jdbc.driver.OracleDriver"/>
<set-property property="maxCount" value="50"/>
<set-property property="minCount" value="2"/>
<set-property property="password" value="**"/>
<set-property property="user" value="**"/>
<set-property property="url"
value="jdbc:oracle:thin:@box:1521:db"/>
</data-source>
A minor difference I have noticed is the use of the '@' symbol to reference
your box in the url parameter.
I have included one that I know works for one of my systems oracle
connection.
Chris McCormack
-----Original Message-----
From: Rajat Pandit [mailto:[EMAIL PROTECTED]
Sent: 25 March 2004 11:11
To: Struts Users Mailing List
Subject: Re: db error
Thanks chris,
so this is not because of any missing classes or jar files? is this a
connectivity issue? the database server isup and my other applications
sqlplusw can access it.
any pointers?
sorry about read reciept thing in my previous mail.
rajat
----- Original Message -----
From: "McCormack, Chris" <[EMAIL PROTECTED]>
To: "Struts Users Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, March 25, 2004 4:46 PM
Subject: RE: db error
Check your database is up before trying to connect to it. If it is and you
can ping the database from your application server box, then check your
spelling in the data source definition.
Chris McCormack
-----Original Message-----
From: Rajat Pandit [mailto:[EMAIL PROTECTED]
Sent: 25 March 2004 11:01
To: Struts Users Mailing List
Subject: db error
Hello All,
i am trying to connect a oracle database, and i get this stack trace, can
someone please tell me what is wrong with it.
<!-- stack trace -->
javax.servlet.UnavailableException: Initializing application data source
org.apache.struts.action.DATA_SOURCE
at
org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.j
ava:1091)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
at javax.servlet.GenericServlet.init(GenericServlet.java:256)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:93
4)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:821)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:
3420)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3608)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:8
21)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:579)
at
org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.j
ava:257)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:772)
at
org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:569
)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:411)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:879)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:368)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:166)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:738)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347)
at org.apache.catalina.core.StandardService.start(StandardService.java:497)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2189)
at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
<!-- end of stack trace -->
<--- data sources -->
<data-sources>
<!-- <data-source type="org.apache.commons.dbcp.BasicDataSource"> -->
<data-source>
<set-property property="driverClassName"
value="oracle.jdbc.driver.OracleDriver" />
<set-property property="url"
value="jdbc:oracle:thin:oci8:1521:ora9i" />
<set-property property="username" value="*******" />
<set-property property="password" value="*******" />
<set-property property="autoCommit" value="true" />
<set-property property="maxCount" value="4" />
<set-property property="minCount" value="2" />
<set-property property="validationQuery" value="SELECT 1+1 from
dual" />
</data-source>
</data-sources>
<-- code -->
ServletContext context = servlet.getServletContext();
DataSource ds = (DataSource)
context.getAttribute(Action.DATA_SOURCE_KEY);
//DataSource ds = getDataSource(req);
try {
conn = ds.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery("Select tname, tabtype from tab");
if (!rs.wasNull()) {
/**
* some records where returned
*/
System.err.println("==================");
while (rs.next()) {
System.err.println("Table Name: " + rs.getString(1));
System.err.println("TabType: " + rs.getString(2));
System.err.println("--");
}
System.err.println("==================");
}
} catch (SQLException e) {
System.err.println("==> Error in getting the connection: " +
e.getMessage());
<---end of code -->
--
Rajat Pandit | [EMAIL PROTECTED]
System Analyst
Manchitra Services Pvt. Ltd (www.manchitra.com)
Tel: 011-26232696 / 26232798
Cellphone: 9818247126
B231 / C GK I
New Delhi
***********************************************
This e-mail and its attachments are confidential
and are intended for the above named recipient
only. If this has come to you in error, please
notify the sender immediately and delete this
e-mail from your system.
You must take no action based on this, nor must
you copy or disclose it or any part of its contents
to any person or organisation.
Statements and opinions contained in this email may
not necessarily represent those of Littlewoods.
Please note that e-mail communications may be monitored.
The registered office of Littlewoods Limited and its
subsidiaries is 100 Old Hall Street, Liverpool, L70 1AB.
Registered number of Littlewoods Limited is 262152.
************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
***********************************************
This e-mail and its attachments are confidential
and are intended for the above named recipient
only. If this has come to you in error, please
notify the sender immediately and delete this
e-mail from your system.
You must take no action based on this, nor must
you copy or disclose it or any part of its contents
to any person or organisation.
Statements and opinions contained in this email may
not necessarily represent those of Littlewoods.
Please note that e-mail communications may be monitored.
The registered office of Littlewoods Limited and its
subsidiaries is 100 Old Hall Street, Liverpool, L70 1AB.
Registered number of Littlewoods Limited is 262152.
************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
