oracle Database question

[Lionel Crine <cr...@4dconcept.fr>]

Hello,

I will work with Oracle and I have several questions about it.

Access to the database :
The requests to the database can only be done with esql or there another 
transformer or generator, etc ...?

Cache :
I will use the Oracle cache to get great performance because my requests 
can be important.
But I also need to use the cocoon cache to put some results in the cache.
So the caching process can allow me to do that with the sqltransformer, 
etc ...?
I supposed that I need to configure the cocoon.xconf ?


Package object in Oracle :
I supposed I can execute a Package with a custom class ?

Intermediary Indexes :
I will need to make request with intermediary indexes. Sqltransformer 
will allow me to do that ?


Thanks

Lionel

-- 
Lionel CRINE
Ingénieur Systèmes documentaires
Société : 4DConcept
22 rue Etienne de Jouy 78353 JOUY EN JOSAS
Tel : 01.34.58.70.70 Fax : 01.39.46.06.90

Re: oracle Database question

[Leszek Gawron <lg...@apache.org>]

Lionel Crine wrote:
> Hello,
> 
> I will work with Oracle and I have several questions about it.
> 
> Access to the database :
> The requests to the database can only be done with esql or there another 
> transformer or generator, etc ...?
You can also use SQL Transformer or plain JDBC access.

> Cache :
> I will use the Oracle cache to get great performance because my requests 
> can be important.
> But I also need to use the cocoon cache to put some results in the cache.
> So the caching process can allow me to do that with the sqltransformer, 
> etc ...?
> I supposed that I need to configure the cocoon.xconf ?
SQL Transformer is not cacheable I think. How do you plan to invalidate 
your data in cocoon cache?

> Package object in Oracle :
> I supposed I can execute a Package with a custom class ?
> 
> Intermediary Indexes :
> I will need to make request with intermediary indexes. Sqltransformer 
> will allow me to do that ?
Could you post a sample of what you want to do.

-- 
Leszek Gawron                                                 MobileBox
lgawron@apache.org                              http://www.mobilebox.pl

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

Re: oracle Database question

[Thor Heinrichs-Wolpert <th...@lunartek.com>]

> Access to the database :
> The requests to the database can only be done with esql or there 
> another transformer or generator, etc ...?
You could also use the XDB for Oracle.  I use this for my reporting and 
viewing items as the request comes back in XML already for me.

> Cache :
> I will use the Oracle cache to get great performance because my 
> requests can be important.
> But I also need to use the cocoon cache to put some results in the 
> cache.
> So the caching process can allow me to do that with the 
> sqltransformer, etc ...?
> I supposed that I need to configure the cocoon.xconf ?
Are you asking about the Cache in the app server, or the cache in the 
database?  You can use the cocoon cache and the Oracle app server cache 
to maintain rendered, or partially rendered results.


> Package object in Oracle :
> I supposed I can execute a Package with a custom class ?
A good deal of our docs come from stored functions that return xmltype, 
so it is possible.

Cheers,
Thor HW


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org