Ok I have tried that and I am getting a null pointer exception caused by the DataSource, here is my code
ServletContext context = servlet.getServletContext(); DataSource dataSource = (DataSource) context.getAttribute("MRA"); conn = dataSource.getConnection(); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); My struts.xml is this; <data-sources> <data-source> <set-property property="key" value="MRA"/> <set-property property="driverClass" value ="oracle.jdbc.driver.OracleDriver"/> <set-property property="url" value="jdbc:oracle:thin: @147.101.104.63:1524:common"/> <set-property property="user" value="MRA"/> <set-property property="password" value="mralog"/> </data-source> <data-source> <set-property property="key" value="PHONE_DB"/> <set-property property="driverClass" value ="oracle.jdbc.driver.OracleDriver"/> <set-property property="url" value="jdbc:oracle:thin: @oid:1521:infoprd"/> <set-property property="user" value="info_user"/> <set-property property="password" value="info_user"/> </data-source> </data-sources> I dont see what I am doing wrong please help. Thank you Tim Bachta Information Technology MC 48 "David Graham" <dgraham1980@hotm To: [EMAIL PROTECTED] ail.com> cc: Subject: Re: Multiple DataSource Problem 12/06/2002 12:45 PM Please respond to "Struts Users Mailing List" >From action.execute() DataSource ds1 = (DataSource)this.getServlet().getServletContext().getAttribute ("YOUR_DS_KEY")); David >From: [EMAIL PROTECTED] >Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]> >To: "Struts Users Mailing List" <[EMAIL PROTECTED]> >Subject: Re: Multiple DataSource Problem >Date: Fri, 6 Dec 2002 12:30:36 -0600 > > >Ok , I thought I have already changed the key value's to "MRA" and >"PHONE_DB" in both of my data-sources, what I am having trouble with is how >do I refrence these values in the form and action classes? > > >Tim Bachta >Information Technology >MC 48 > > > > "David Graham" > <dgraham1980@hotm To: >[EMAIL PROTECTED] > ail.com> cc: > Subject: Re: Multiple >DataSource Problem > 12/05/2002 04:09 > PM > Please respond to > "Struts Users > Mailing List" > > > > > > ><data-source key="org.apache.struts.action.DATA_SOURCE"> > >That would store the DataSource under the Struts default value, which >obviously only allows for one DataSource. Just change the key value to >something else to store multiple DataSources. > >David > > > > > > > >From: [EMAIL PROTECTED] > >Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]> > >To: "Struts Users Mailing List" <[EMAIL PROTECTED]> > >Subject: Re: Multiple DataSource Problem > >Date: Thu, 5 Dec 2002 15:01:21 -0600 > > > > > >Can you show me a code snip of how to use this? > > > > > >Tim Bachta > >Information Technology > >MC 48 > > > > > > > > > > "David Graham" > > <dgraham1980@hotm To: > >[EMAIL PROTECTED] > > ail.com> cc: > > Subject: Re: Multiple > >DataSource Problem > > 12/05/2002 02:45 > > PM > > Please respond to > > "Struts Users > > Mailing List" > > > > > > > > > > > > > >Use the key attribute of the data-source element. > > > >David > > > > > > > > > > > > > > >From: [EMAIL PROTECTED] > > >Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]> > > >To: "Struts Users Mailing List" <[EMAIL PROTECTED]> > > >Subject: Re: Multiple DataSource Problem > > >Date: Thu, 5 Dec 2002 14:02:31 -0600 > > > > > > > > >Did I not give each data-source element its own key? > > > > > >Tim Bachta > > >Information Technology > > >MC 48 > > > > > > > > > > > > > > > "David Graham" > > > <dgraham1980@hotm To: > > >[EMAIL PROTECTED] > > > ail.com> cc: > > > Subject: Re: Multiple > > >DataSource Problem > > > 12/05/2002 01:41 > > > PM > > > Please respond to > > > "Struts Users > > > Mailing List" > > > > > > > > > > > > > > > > > > > > >You need to give each data-source element its own key. Struts stores >the > > >DataSource under that key in the ServletContext. > > > > > >David > > > > > > > > > > > > > > > > > > > > > >From: [EMAIL PROTECTED] > > > >Reply-To: "Struts Users Mailing List" ><[EMAIL PROTECTED]> > > > >To: [EMAIL PROTECTED] > > > >Subject: Multiple DataSource Problem > > > >Date: Thu, 5 Dec 2002 13:20:01 -0600 > > > > > > > >I am having trouble getting multiple datasources to work in my > > >application. > > > >I have searched the archives and found inofrmation on how to do it >but > > >the > > > >solutions given are depricated. Can anyone help me? > > > > > > > > > > > ><data-sources> > > > > <data-source> > > > > <set-property property="key" value="MRA"/> > > > > <set-property property="driverClass" value > > > >="oracle.jdbc.driver.OracleDriver"/> > > > > <set-property property="url" > >value="jdbc:oracle:thin: > > > >@147.101.104.63:1524:common"/> > > > > <set-property property="user" value="MRA"/> > > > > <set-property property="password" value ="mralog"/> > > > > </data-source> > > > > <data-source> > > > > <set-property property="key" value="PHONE_DB"/> > > > > <set-property property="driverClass" value > > > >="oracle.jdbc.driver.OracleDriver"/> > > > > <set-property property="url" > >value="jdbc:oracle:thin: > > > >@oid:1521:infoprd"/> > > > > <set-property property="user" value="info_user"/> > > > > <set-property property="password" > >value="info_user"/> > > > > </data-source> > > > > </data-sources> > > > > > > > > > > > > > > > >try > > > > { > > > > ServletContext context = servlet.getServletContext(); > > > > DataSource dataSource = (DataSource) > > > >context.getAttribute(Action.DATA_SOURCE_KEY); > > > > conn = dataSource.getConnection(); > > > > stmt = conn.createStatement(); > > > > rs = stmt.executeQuery(sql); > > > > > > > > Thank you for your help > > > > > > > >Tim Bachta > > > >Information Technology > > > >MC 48 > > > > > > > > > > > > > > > > > > > >-- > > > >To unsubscribe, e-mail: > > > ><mailto:[EMAIL PROTECTED]> > > > >For additional commands, e-mail: > > > ><mailto:[EMAIL PROTECTED]> > > > > > > > > >_________________________________________________________________ > > >MSN 8 with e-mail virus protection service: 2 months FREE* > > >http://join.msn.com/?page=features/virus > > > > > > > > >-- > > >To unsubscribe, e-mail: < > > >mailto:[EMAIL PROTECTED]> > > >For additional commands, e-mail: < > > >mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > > > > > > > > > > >-- > > >To unsubscribe, e-mail: > > ><mailto:[EMAIL PROTECTED]> > > >For additional commands, e-mail: > > ><mailto:[EMAIL PROTECTED]> > > > > > >_________________________________________________________________ > >The new MSN 8: advanced junk mail protection and 2 months FREE* > >http://join.msn.com/?page=features/junkmail > > > > > >-- > >To unsubscribe, e-mail: < > >mailto:[EMAIL PROTECTED]> > >For additional commands, e-mail: < > >mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > > > >-- > >To unsubscribe, e-mail: > ><mailto:[EMAIL PROTECTED]> > >For additional commands, e-mail: > ><mailto:[EMAIL PROTECTED]> > > >_________________________________________________________________ >Add photos to your e-mail with MSN 8. Get 2 months FREE*. >http://join.msn.com/?page=features/featuredemail > > >-- >To unsubscribe, e-mail: < >mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: < >mailto:[EMAIL PROTECTED]> > > > > > > > >-- >To unsubscribe, e-mail: ><mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: ><mailto:[EMAIL PROTECTED]> _________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- To unsubscribe, e-mail: < mailto:[EMAIL PROTECTED]> For additional commands, e-mail: < mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>