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.java: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:934)
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:821)
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.java: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(LifecycleSupport.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
