That gives me a xml parse error: -INF/struts-config.xml<Line 17, Column 34>: XML-0138: (Error) REQUIRED attribute 'property' is not pecified. <org.xml.sax.SAXParseException: file:/C:/oracle/j2ee/home/applications/MRA/WEB-INF/struts config.xml<Line 17, Column 34>: XML-0138: (Error) REQUIRED attribute 'property' is not specified.> org.xml.sax.SAXParseException: file:/C:/oracle/j2ee/home/applications/MRA/WEB-INF/struts-config.xml Line 17, Column 34>: XML-0138: (Error) REQUIRED attribute 'value' is not specified. at oracle.xml.parser.v2.XMLError.flushErrorHandler(XMLError.java:231) at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:156) at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:268) at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:145) at org.apache.commons.digester.Digester.parse(Digester.java:1495) at org.apache.struts.action.ActionServlet.initApplicationConfig(ActionServlet.java:860) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:455) at javax.servlet.GenericServlet.init(GenericServlet.java:44) at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:1673) at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4006) at com.evermind.server.http.HttpApplication.initPreloadServlets(HttpApplication.java:4105) at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:579) at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:376) at com.evermind.server.Application.getHttpApplication(Application.java:657) at com.evermind.server.http.HttpServer.getHttpApplication(HttpServer.java:663) at com.evermind.server.http.HttpSite.getApplication(HttpSite.java:387) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:378) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:243) at com.evermind.util.ThreadPoolThread.run(ThreadPoolThread.java:64) [ERROR] Digester - -Parse Error at line 17 column 34: file:/C:/oracle/j2ee/home/applications/MRA/WE -INF/struts-config.xml<Line 17, Column 34>: XML-0138: (Error) REQUIRED attribute 'value' is not spe ified. <org.xml.sax.SAXParseException: file:/C:/oracle/j2ee/home/applications/MRA/WEB-INF/struts-co fig.xml<Line 17, Column 34>: XML-0138: (Error) REQUIRED attribute 'value' is not specified.> oracle.xml.parser.v2.XMLParseException: Attribute 'key' used but not declared. at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:208) at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:268) at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:145) at org.apache.commons.digester.Digester.parse(Digester.java:1495) at org.apache.struts.action.ActionServlet.initApplicationConfig(ActionServlet.java:860) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:455) at javax.servlet.GenericServlet.init(GenericServlet.java:44) at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:1673) at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4006) at com.evermind.server.http.HttpApplication.initPreloadServlets(HttpApplication.java:4105) at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:579) at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:376) at com.evermind.server.Application.getHttpApplication(Application.java:657) at com.evermind.server.http.HttpServer.getHttpApplication(HttpServer.java:663) at com.evermind.server.http.HttpSite.getApplication(HttpSite.java:387) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:378) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:243) at com.evermind.util.ThreadPoolThread.run(ThreadPoolThread.java:64) [ERROR] ActionServlet - -Parsing error processing resource path /WEB-INF/struts-config.xml <oracle. ml.parser.v2.XMLParseException: Attribute 'key' used but not declared.>
Any other ideas? I am willing to try anything. Tim Bachta Information Technology MC 48 "David Graham" <dgraham1980@hotm To: [EMAIL PROTECTED] ail.com> cc: Subject: Re: Multiple DataSource Problem 12/06/2002 01:39 PM Please respond to "Struts Users Mailing List" Try my original suggestion: <data-source key="MRA"> 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 13:02:34 -0600 > > >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]> _________________________________________________________________ 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]>