Orbeon Forms community mailing list

oracle connectivity in OPS

Classic

List

Threaded

11 messages Options

garima.singh

oracle connectivity in OPS

Hi All !!

i intend to do oracle database connection , execute a query , and finally show the results in an xml instance.Can somebody let me know the complete steps for oracle connectivity in OPS ?

Thanks in advance !!
Regards,
Garima Singh

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Dustin Whitney

Re: oracle connectivity in OPS

I am interested in knowing if/how this can be done as well. Does anybody have any code they want to share?

-Dustin

On 9/6/06, [hidden email] <[hidden email]> wrote:

Hi All !!

i intend to do oracle database connection , execute a query , and finally show the results in an xml instance.Can somebody let me know the complete steps for oracle connectivity in OPS ?

Thanks in advance !!
Regards,
Garima Singh

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Richard Braman-2

Re: oracle connectivity in OPS

Hi dustin, Yes. It is very possible. I have code that integrates OPS
with SQL Server. I will dig it up and post back. The first thing you
have to do it configure a TomCat Realm for the JDBC connectivity. You
should get a JDBC driver for Oracle if you don't already have one.

Dustin Whitney wrote:

> I am interested in knowing if/how this can be done as well. Does
> anybody have any code they want to share?
>
> -Dustin
>
> On 9/6/06, * [hidden email]
> <mailto:[hidden email]>*
> <[hidden email]
> <mailto:[hidden email]>> wrote:
>
> Hi All !!
>
> i intend to do oracle database connection , execute a query , and
> finally show the results in an xml instance.Can somebody let me
> know the complete steps for oracle connectivity in OPS ?
>
> Thanks in advance !!
> Regards,
> Garima Singh
>
>
>
>
> --
> You receive this message as a subscriber of the
> [hidden email] <mailto:[hidden email]> mailing list.
> To unsubscribe: mailto: [hidden email]
> <mailto:[hidden email]>
> For general help: mailto:[hidden email]
> <mailto:[hidden email]>?subject=help
> ObjectWeb mailing lists service home page:
> http://www.objectweb.org/wws
>
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>

Richard Braman-2

Re: oracle connectivity in OPS

In reply to this post by Dustin Whitney

I remember successfuly implementing connectivity from the bizdoc example
with SQLServer.
It didn't have anything to do with the Tomcat Realm, that was related to
authenticating users from sql tables instead of using the default auth
scheme.

I know I was following the docs under here:

http://www.orbeon.com/ops/doc/processors-sql#d6e131

I would try using bizdoc as an example. I tried to find my exact code,
but I cant find it. I will post back if that changes.

Dustin Whitney wrote:

Dustin Whitney

Re: oracle connectivity in OPS

Thanks Richard. Were you ever able to get any of the XML Database (described here: http://www.orbeon.com/ops/doc/processors-xmldb) to work? Or does anyone know if it will work with Oracle? I would like to use Orbeon, but I'd like to know if this stuff will work before spending too much time on it.

It looks to me like the SQL Processor stuff will work without a hitch, but I'd really like to use XQuery.

-Dustin

On 9/11/06, Richard Braman <[hidden email]> wrote:

I remember successfuly implementing connectivity from the bizdoc example
with SQLServer.
It didn't have anything to do with the Tomcat Realm, that was related to
authenticating users from sql tables instead of using the default auth
scheme.

I know I was following the docs under here:

http://www.orbeon.com/ops/doc/processors-sql#d6e131

I would try using bizdoc as an example.  I tried to find my exact code,
but I cant find it.  I will post back if that changes.

Dustin Whitney wrote:
> I am interested in knowing if/how this can be done as well.  Does
> anybody have any code they want to share?
>

> -Dustin
>
> On 9/6/06, * [hidden email]
> <mailto:[hidden email]>*
> <[hidden email]
> <mailto:[hidden email]>> wrote:
>
>     Hi All !!
>
>     i intend to do oracle database connection , execute a query , and
>     finally show the results in an xml instance.Can somebody let me
>     know the complete steps for oracle connectivity in OPS ?
>
>     Thanks in advance !!
>     Regards,
>     Garima Singh
>
>
>
>
>     --
>     You receive this message as a subscriber of the
>     [hidden email] <mailto:[hidden email]> mailing list.
>     To unsubscribe: mailto: [hidden email]
>     <mailto:[hidden email]>
>     For general help: mailto:[hidden email]
>     <mailto:[hidden email]>?subject=help
>     ObjectWeb mailing lists service home page:
>     http://www.objectweb.org/wws
>
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto: [hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Richard Braman-2

Re: oracle connectivity in OPS

xmldb has to do with exist which is native xml database. I would think
that you could use orbeon to xquery data in a oracle database, but I am
not sure.. that would be a question fro erik or alex to consider.

Dustin Whitney wrote:

> Thanks Richard. Were you ever able to get any of the XML Database
> (described here: http://www.orbeon.com/ops/doc/processors-xmldb) to
> work? Or does anyone know if it will work with Oracle? I would like
> to use Orbeon, but I'd like to know if this stuff will work before
> spending too much time on it.
>
> It looks to me like the SQL Processor stuff will work without a hitch,
> but I'd really like to use XQuery.
>
> -Dustin
>
> On 9/11/06, *Richard Braman * <[hidden email]
> <mailto:[hidden email]>> wrote:
>
> I remember successfuly implementing connectivity from the bizdoc
> example
> with SQLServer.
> It didn't have anything to do with the Tomcat Realm, that was
> related to
> authenticating users from sql tables instead of using the default
> auth
> scheme.
>
> I know I was following the docs under here:
>
> http://www.orbeon.com/ops/doc/processors-sql#d6e131
>
> I would try using bizdoc as an example. I tried to find my exact
> code,
> but I cant find it. I will post back if that changes.
>
>
>
> Dustin Whitney wrote:
> > I am interested in knowing if/how this can be done as well. Does
> > anybody have any code they want to share?
> >
> > -Dustin
> >
> > On 9/6/06, * [hidden email]
> <mailto:[hidden email]>
> > <mailto:[hidden email]
> <mailto:[hidden email]>>*
> > <[hidden email]
> <mailto:[hidden email]>
> > <mailto:[hidden email]
> <mailto:[hidden email]>>> wrote:
> >
> > Hi All !!
> >
> > i intend to do oracle database connection , execute a query
> , and
> > finally show the results in an xml instance.Can somebody let me
> > know the complete steps for oracle connectivity in OPS ?
> >
> > Thanks in advance !!
> > Regards,
> > Garima Singh
> >
> >
> >
> >
> > --
> > You receive this message as a subscriber of the
> > [hidden email] <mailto:[hidden email]>
> <mailto:[hidden email] <mailto:[hidden email]>>
> mailing list.
> > To unsubscribe: mailto: [hidden email]
> <mailto:[hidden email]>
> > <mailto:[hidden email]
> <mailto:[hidden email]>>
> > For general help: mailto:[hidden email]
> <mailto:[hidden email]>
> > <mailto:[hidden email]
> <mailto:[hidden email]>>?subject=help
> > ObjectWeb mailing lists service home page:
> > http://www.objectweb.org/wws <http://www.objectweb.org/wws>
> >
> >
> >
> >
> ------------------------------------------------------------------------
> >
> >
> > --
> > You receive this message as a subscriber of the
> [hidden email] <mailto:[hidden email]> mailing list.
> > To unsubscribe: mailto:[hidden email]
> <mailto:[hidden email]>
> > For general help: mailto: [hidden email]
> <mailto:[hidden email]>?subject=help
> > ObjectWeb mailing lists service home page:
> http://www.objectweb.org/wws
> >
>
>
>
>
>
>
> --
> You receive this message as a subscriber of the
> [hidden email] <mailto:[hidden email]> mailing list.
> To unsubscribe: mailto:[hidden email]
> <mailto:[hidden email]>
> For general help: mailto: [hidden email]
> <mailto:[hidden email]>?subject=help
> ObjectWeb mailing lists service home page:
> http://www.objectweb.org/wws
>
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>

Erik Bruchez

Re: oracle connectivity in OPS

Administrator

In reply to this post by Dustin Whitney

Dustin,

Good questions.

I don't think Oracle supports the XML:DB API, which is an (old) API
dedicated to pure XML databases. Note that confusingly enough, Oracle
uses the term "Oracle XML DB" to describe its native XML data store,
which doesn't have anything to do with the XML:DB API.

I believe that Oracle supports the newer XQJ, the XQuery API for Java,
but we don't yet have a processor for this in OPS (you could write your
own processor though, and it shouldn't be too hard).

Ideally Oracle would support a REST API as well, like eXist does, but I
don't know if Oracle supports such an API, which would allow calling
Oracle directly from XForms (which fully support REST as of 1.1).

I think that you should be able to embed XQuery within SQL to send to
Oracle through JDBC, which with OPS means using the SQL processor. If
you can actually do that, then you can use OPS as is without writing a
new processor.

Can somebody confirm that, and does anybody know more about Oracle
XQuery APIs?

-Erik

Dustin Whitney wrote:

--
Orbeon - XForms Everywhere:
http://www.orbeon.com/blog/

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Erik Bruchez

Re: oracle connectivity in OPS

Administrator

In reply to this post by garima.singh

Garima,

> i intend to do oracle database connection , execute a query , and
> finally show the results in an xml instance.Can somebody let me know
> the complete steps for oracle connectivity in OPS ?

As pointed out, you must use the SQL processor to do that. The basic
steps are:

o Configure a datasource in Tomcat's server.xml (or equivalent if you
use another container).

o Declare that datasource in your web.xml.

o Look at the Address Book example from OPS 3.5 M1 for how to
initialize an XForms instance with the result of a SQL query. In
particular the main page of that example:

<page path-info="/address-book" model="model.xpl" view="view.xhtml"/>

What the page model (model.xpl) does here is use the SQL processor
to return the results from the database to its "data" output.

Note that for reasons related to the packaging of the standard OPS
examples (in order to allow you to run the OPS examples without
configuring a JDBC datasource), that example does not use a JDBC
datasource, but you should use something like this in your SQL
processor configuration:

<sql:connection>
<sql:datasource>my-datasource</sql:datasource>
...

The page view (view.xhtml) uses XInclude to include the initial
instance produced by the page model:

<xforms:instance id="main">
<xi:include href="input:data"/>
</xforms:instance>

-Erik

--
Orbeon - XForms Everywhere:
http://www.orbeon.com/blog/

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Dustin Whitney

Re: oracle connectivity in OPS

Erik,

Does any of the xml database functionality you've included in Orbeon work in Oracle - the xquery stuff for example?

Thanks,
Dustin

On 9/18/06, Erik Bruchez <[hidden email]> wrote:

Garima,

> i intend to do oracle database connection , execute a query , and
> finally show the results in an xml instance.Can somebody let me know
> the complete steps for oracle connectivity in OPS ?

As pointed out, you must use the SQL processor to do that. The basic
steps are:

o Configure a datasource in Tomcat's server.xml (or equivalent if you
   use another container).

o Declare that datasource in your web.xml.

o Look at the Address Book example from OPS 3.5 M1 for how to
   initialize an XForms instance with the result of a SQL query. In
   particular the main page of that example:

   <page path-info="/address-book" model=" model.xpl" view="view.xhtml"/>

   What the page model (model.xpl) does here is use the SQL processor
   to return the results from the database to its "data" output.

   Note that for reasons related to the packaging of the standard OPS
   examples (in order to allow you to run the OPS examples without
   configuring a JDBC datasource), that example does not use a JDBC
   datasource, but you should use something like this in your SQL
   processor configuration:

   <sql:connection>
     <sql:datasource>my-datasource</sql:datasource>
     ...

   The page view (view.xhtml) uses XInclude to include the initial
   instance produced by the page model:

   <xforms:instance id="main">
     <xi:include href="input:data"/>
   </xforms:instance>

-Erik

--
Orbeon - XForms Everywhere:
http://www.orbeon.com/blog/

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Erik Bruchez

Re: oracle connectivity in OPS

Administrator

Dustin,

See my other response in this thread.

-Erik

Dustin Whitney wrote:

> Erik,
>
> Does any of the xml database functionality you've included in Orbeon
> work in Oracle - the xquery stuff for example?
>
> Thanks,
> Dustin
>
> On 9/18/06, * Erik Bruchez* <[hidden email]
> <mailto:[hidden email]>> wrote:
>
> Garima,
>
> > i intend to do oracle database connection , execute a query , and
> > finally show the results in an xml instance.Can somebody let me know
> > the complete steps for oracle connectivity in OPS ?
>
> As pointed out, you must use the SQL processor to do that. The basic
> steps are:
>
> o Configure a datasource in Tomcat's server.xml (or equivalent if you
> use another container).
>
> o Declare that datasource in your web.xml.
>
> o Look at the Address Book example from OPS 3.5 M1 for how to
> initialize an XForms instance with the result of a SQL query. In
> particular the main page of that example:
>
> <page path-info="/address-book" model=" model.xpl"
> view="view.xhtml"/>
>
> What the page model (model.xpl) does here is use the SQL processor
> to return the results from the database to its "data" output.
>
> Note that for reasons related to the packaging of the standard OPS
> examples (in order to allow you to run the OPS examples without
> configuring a JDBC datasource), that example does not use a JDBC
> datasource, but you should use something like this in your SQL
> processor configuration:
>
> <sql:connection>
> <sql:datasource>my-datasource</sql:datasource>
> ...
>
> The page view (view.xhtml) uses XInclude to include the initial
> instance produced by the page model:
>
> <xforms:instance id="main">
> <xi:include href="input:data"/>
> </xforms:instance>
>
> -Erik
>
> --
> Orbeon - XForms Everywhere:
> http://www.orbeon.com/blog/
>
>
>
>
>
> --
> You receive this message as a subscriber of the
> [hidden email] <mailto:[hidden email]> mailing list.
> To unsubscribe: mailto: [hidden email]
> <mailto:[hidden email]>
> For general help: mailto:[hidden email]
> <mailto:[hidden email]>?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Hank Ratzesberger

Re: oracle connectivity in OPS

In reply to this post by Erik Bruchez

Release 10.2 supports XQuery "natively" :

http://www.oracle.com/technology/tech/xml/xquery/index.html

It is still accomplished through SQL statements, so I guess
the SQL processor will work. An example to parse an RSS feed:

SELECT XMLQuery('for $i in $k//item where contains
($i/title, "Film") return $i'
passing xmlparse( document httpuritype('http://www.rediff.com/rss/inrss.xml')
.getclob()) as "k" returning content') from dual;

it shows obtaining data from a url, such as could be
published by OPS. Other source options are xml documents in
the store e.g. doc( "/public/anxmldoc.xml"), XMLType tables and relational
data.

I don't see a REST interface, but I see a SOAP interface.

Regards,
Hank Ratzesberger
UCSB

----- Original Message -----
From: "Erik Bruchez" <[hidden email]>
To: <[hidden email]>
Sent: Monday, September 18, 2006 10:24 AM
Subject: Re: [ops-users] oracle connectivity in OPS

> Dustin,
>
> Good questions.
>
> I don't think Oracle supports the XML:DB API, which is an (old) API
> dedicated to pure XML databases. Note that confusingly enough, Oracle
> uses the term "Oracle XML DB" to describe its native XML data store,
> which doesn't have anything to do with the XML:DB API.
>
> I believe that Oracle supports the newer XQJ, the XQuery API for Java,
> but we don't yet have a processor for this in OPS (you could write your
> own processor though, and it shouldn't be too hard).
>
> Ideally Oracle would support a REST API as well, like eXist does, but I
> don't know if Oracle supports such an API, which would allow calling
> Oracle directly from XForms (which fully support REST as of 1.1).
>
> I think that you should be able to embed XQuery within SQL to send to
> Oracle through JDBC, which with OPS means using the SQL processor. If
> you can actually do that, then you can use OPS as is without writing a
> new processor.
>
> Can somebody confirm that, and does anybody know more about Oracle
> XQuery APIs?
>
> -Erik
>
> Dustin Whitney wrote:
>> Thanks Richard. Were you ever able to get any of the XML Database
>> (described here: http://www.orbeon.com/ops/doc/processors-xmldb) to
>> work? Or does anyone know if it will work with Oracle? I would like to
>> use Orbeon, but I'd like to know if this stuff will work before spending
>> too much time on it.
>>
>> It looks to me like the SQL Processor stuff will work without a hitch,
>> but I'd really like to use XQuery.
>>
>> -Dustin
>>
>> On 9/11/06, *Richard Braman * <[hidden email]
>> <mailto:[hidden email]>> wrote:
>>
>> I remember successfuly implementing connectivity from the bizdoc example
>> with SQLServer.
>> It didn't have anything to do with the Tomcat Realm, that was related to
>> authenticating users from sql tables instead of using the default auth
>> scheme.
>>
>> I know I was following the docs under here:
>>
>> http://www.orbeon.com/ops/doc/processors-sql#d6e131
>>
>> I would try using bizdoc as an example. I tried to find my exact code,
>> but I cant find it. I will post back if that changes.
>>
>>
>>
>> Dustin Whitney wrote:
>> > I am interested in knowing if/how this can be done as well. Does
>> > anybody have any code they want to share?
>> >
>> > -Dustin
>> >
>> > On 9/6/06, * [hidden email]
>> <mailto:[hidden email]>
>> > <mailto:[hidden email]
>> <mailto:[hidden email]>>*
>> > <[hidden email]
>> <mailto:[hidden email]>
>> > <mailto:[hidden email]
>> <mailto:[hidden email]>>> wrote:
>> >
>> > Hi All !!
>> >
>> > i intend to do oracle database connection , execute a query , and
>> > finally show the results in an xml instance.Can somebody let me
>> > know the complete steps for oracle connectivity in OPS ?
>> >
>> > Thanks in advance !!
>> > Regards,
>> > Garima Singh
>
> --
> Orbeon - XForms Everywhere:
> http://www.orbeon.com/blog/
>
>

--------------------------------------------------------------------------------

>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws