xsl-list
[Top] [All Lists]

Re: [xsl] Connecting to Data Base using XSL

2007-09-12 01:38:22
Karanam

Oracle supports a good set of data-to-XML services, last time I used them it was called XSQL. You can easily create a web service that that can be called via the document function to incorporate it into your transform.

The worst part of the process I had was the initial configuration of the system, getting the Tomcat server and the XSQL set up correctly, once that is done the rest is straight forward.

Joe

On 9/12/07, Karanam(_dot_)Chowdary(_at_)iflexsolutions(_dot_)com
<Karanam(_dot_)Chowdary(_at_)iflexsolutions(_dot_)com> wrote:
> Extension function???? I have a webservice which queries from database
> and returns the desired results. Can that webservice be included in my
> XSL?
>
> -----Original Message-----
> From: bryan rasmussen [mailto:rasmussen(_dot_)bryan(_at_)gmail(_dot_)com]
> Sent: Wednesday, September 12, 2007 10:47 AM
> To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
> Subject: Re: [xsl] Connecting to Data Base using XSL
>
> either you will need to use an extension function appropriate to your
> processor or the database would have to be exposed via some protocol
> accessible via the document() function - the second seems unlikely.
>
> Best regards,
> Bryan Rasmussen
>
> On 9/12/07, Karanam(_dot_)Chowdary(_at_)iflexsolutions(_dot_)com
> <Karanam(_dot_)Chowdary(_at_)iflexsolutions(_dot_)com> wrote:
> >
> >
> > Hello,
> > Can someone help me out in connecting to database using xsl?
> > I have to connect to oracle 10g database and retrieve data and display
> > it in browser. Say, I have control id in my xml, based on this control
> > id I have to get the control name which is in the database. I tried
> > using saxon, but I want the results to be displayed in browser not in
> > cmd prompt.
> >
> > This is my XML:
> > <CONTAINER ID="1" TYPE="1" CREATEDIV="Y">
> >                 <CONTROL_ID>2</CONTROL_ID>
> >                 <CONTROL_ID>3</CONTROL_ID>
> >                 <CONTROL_ID>7</CONTROL_ID>
> > </CONTAINER>
> > I shud get the control name from database using the <CONTROL_ID> tag
> in
> > XML.
> >
> > Note: I m not using any XSLT processor... just editing XSL with Visual
> > Studio 2005.
> >
> >
> > DISCLAIMER:
> > This message contains privileged and confidential information and is
> intended only for an individual named. If you are not the intended
> recipient, you should not disseminate, distribute, store, print, copy or
> deliver this message. Please notify the sender immediately by e-mail if
> you have received this e-mail by mistake and delete this e-mail from
> your system. E-mail transmission cannot be guaranteed to be secure or
> error-free as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete or contain viruses. The sender,
> therefore,  does not accept liability for any errors or omissions in the
> contents of this message which arise as a result of e-mail transmission.
> If verification is required, please request a hard-copy version.
> >
> > --~------------------------------------------------------------------
> > XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> > To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> > or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
> > --~--
> >
> >
>
> --~------------------------------------------------------------------
> XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
> --~--
>
>
>
> DISCLAIMER:
> This message contains privileged and confidential information and is intended only for an individual named. If you are not the intended recipient, you should not disseminate, distribute, store, print, copy or deliver this message. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete or contain viruses. The sender, therefore, does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required, please request a hard-copy version.
>
> --~------------------------------------------------------------------
> XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
> or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
> --~--
>
>

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--




--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>