struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Graham" <dgraham1...@hotmail.com>
Subject Re: Multiple DataSource Problem
Date Thu, 05 Dec 2002 22:09:29 GMT
<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: tbachta@kcp.com
>Reply-To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
>To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
>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:       
>struts-user@jakarta.apache.org
>                       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: tbachta@kcp.com
> >Reply-To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
> >To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
> >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:
> >struts-user@jakarta.apache.org
> >                       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: tbachta@kcp.com
> > >Reply-To: "Struts Users Mailing List" <struts-user@jakarta.apache.org>
> > >To: struts-user@jakarta.apache.org
> > >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:struts-user-unsubscribe@jakarta.apache.org>
> > >For additional commands, e-mail:
> > ><mailto:struts-user-help@jakarta.apache.org>
> >
> >
> >_________________________________________________________________
> >MSN 8 with e-mail virus protection service: 2 months FREE*
> >http://join.msn.com/?page=features/virus
> >
> >
> >--
> >To unsubscribe, e-mail:   <
> >mailto:struts-user-unsubscribe@jakarta.apache.org>
> >For additional commands, e-mail: <
> >mailto:struts-user-help@jakarta.apache.org>
> >
> >
> >
> >
> >
> >
> >
> >--
> >To unsubscribe, e-mail:
> ><mailto:struts-user-unsubscribe@jakarta.apache.org>
> >For additional commands, e-mail:
> ><mailto:struts-user-help@jakarta.apache.org>
>
>
>_________________________________________________________________
>The new MSN 8: advanced junk mail protection and 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>
>
>--
>To unsubscribe, e-mail:   <
>mailto:struts-user-unsubscribe@jakarta.apache.org>
>For additional commands, e-mail: <
>mailto:struts-user-help@jakarta.apache.org>
>
>
>
>
>
>
>
>--
>To unsubscribe, e-mail:   
><mailto:struts-user-unsubscribe@jakarta.apache.org>
>For additional commands, e-mail: 
><mailto:struts-user-help@jakarta.apache.org>


_________________________________________________________________
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:struts-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:struts-user-help@jakarta.apache.org>


Mime
View raw message