How to access Datasource Tag (struts-config.xml) in POJO

[Neha k Agrawal]

Hello friends,
I am doing a project in struts.I have stored the database connection information in data-source tag of struts-config.xml file.This is the code.

<data-sources>
  <data-source>
  <set-property property="autoCommit" value="false"/>
  <set-property property="description" value="oracle Data Source"/>
  <set-property property="driverClass" value="oracle.jdbc.driver.OracleDriver"/>
  <set-property property="maxCount" value="10"/>
  <set-property property="minCount" value="2"/>
  <set-property property="user" value="system"/>
  <set-property property="password" value="manager"/>
  <set-property property="url"
  value="jdbc:oracle:thin:@localhost:1521:gd"/>
 </data-source>
</data-sources>
 

Now I want to access this data in POJO.I know how to use it in action class but unable to use it in POJO.To access it in action class , the code goes like this....

 
ServletContext context=servlet.getServletContext();
DataSource datasource=(DataSource)context.getAttribute(Action.DATA_SOURCE_KEY);
Connection con=datasource.getConnection();

Can anyone tell me what to do?.Any help will be highly appreciated.Thank you in advance.

[Praveen Sangolli]

Hi Neha,

I am not sure whether this might help you, it sounds silly...
Have you tried sending DataSource as a parameter to a method in your POJO.
By doing so you will have a handle to the datasourse and then you can get hold of the connection object..