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]>
