<data-sources> <data-source key="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 key="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>
Tim Bachta Information Technology MC 48 "David Graham" <dgraham1980@hotm To: [EMAIL PROTECTED] ail.com> cc: Subject: Re: Multiple DataSource Problem 12/06/2002 02:21 PM Please respond to "Struts Users Mailing List" Ok, post your entire <data-sources> section. 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:57:36 -0600 > > >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]> _________________________________________________________________ The new MSN 8: smart spam 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]>