• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

data-sources with oracle

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi, Please help I am learning to struts frame work.
Can any body tell me why I am getting this error.
Like where i have to define the database connection and which class i have to mention for data base related things.If possible pls send me the step wise code .

I am using oracle10g

here is my struts-config
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="maxActive" value="10" />
<set-property property="maxWait" value="5000" />
<set-property property="defaultAutoCommit" value="false" />
<set-property property="defaultReadOnly" value="false" />
<set-property property="driverClassName"
value="oracle.jdbc.driver.OracleDriver"/>
<set-property property="url" value="jdbc racle:thin:@xyz:1521:abc"/>
<set-property property="username" value="123"/>
<set-property property="password" value="123"/>
<set-property property="valida" value="SELECT SYSDATE FROM DUAL"/>
</data-source>
</data-sources>


inside my code

Double price = null;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
DataSource dataSource = null;
try {
System.err.println("---->ssdataSource<----");
dataSource = getDataSource(request);
System.out.println("dataSource :"+ dataSource);
conn = dataSource.getConnection();
System.out.println("myConnection:"+ conn);
.
.

I got this error on servlet

503 Service Unavailable
Servlet error: Initializing application data source org.apache.struts.action.DATA_SOURCE


and in java side i got this error

SEVERE: Initializing application data source org.apache.struts.action.DATA_SOURCE
java.lang.NullPointerException
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:545)
at org.apache.commons.dbcp.BasicDataSource.setLogWriter(BasicDataSource.java:381)
at org.apache.struts.action.ActionServlet.initModuleDataSources(ActionServlet.java:1087)
at org.apache.struts.action.ActionServlet.init(ActionServlet.java:472)
at javax.servlet.GenericServlet.init(GenericServlet.java:259)
at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:2094)
at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4523)
at com.evermind.server.http.HttpApplication.getRequestDispatcher(HttpApplication.java:2561)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:640)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am going to move this to the more appropriate Struts forum.

Mark
 
What's that smell? I think this tiny ad may have stepped in something.
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic