my dog learned polymorphism*
The moose likes Struts and the fly likes Struts DB Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Struts DB Error" Watch "Struts DB Error" New topic
Author

Struts DB Error

Mano haran
Greenhorn

Joined: Nov 30, 2006
Posts: 15
Hi,

i am new to struts, now i exploring struts with database access,i am getting error in my datasource,
my code snippet,

String user=null;
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;

ServletContext ctx=servlet.getServletContext();
DataSource ds=(DataSource)
ctx.getAttribute(Action.DATA_SOURCE_KEY);
try
{
conn=ds.getConnection();
stmt=conn.createStatement();
//some other codes here
}
here Action.DATA_SOURCE_KEY this is giving error to me,also i have pasted my struts-config.xml data source configuration

<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName"
value="oracle.jdbc.driver.OracleDriver"/>
<set-property property="url"
value="jdbc racle:thin:@mac-0314:1521 RCL" />
<set-property property="username" value="scott" />
<set-property property="password" value="tiger" />
<set-property property="maxActive" value="10" />
<set-property property="maxWait" value="500" />
<set-property property="defaultAutoCommit" value="false" />
<set-property property="defaultReadOnly" value="false" />
</data-source>
</data-sources>

please help me ...
Ramesh Satya Venkata
Greenhorn

Joined: Jul 02, 2007
Posts: 4
please check below link

http://www.roseindia.net/struts/strutsdatasourcemanagerontomcat5.shtml
Merrill Higginson
Ranch Hand

Joined: Feb 15, 2005
Posts: 4864
Read quetion 7 of the JavaRanch Struts FAQ


Merrill
Consultant, Sima Solutions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Struts DB Error
 
Similar Threads
Prob using DataSource
data-sources with struts and oracle 10g
data-sources with oracle
How to access Datasource Tag (struts-config.xml) in POJO
Struts Connection pool (please help)