You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Gabriele Domenichini <ga...@fastmail.fm> on 2002/12/04 23:42:43 UTC
MsSQL MySql PosgreSQL BasisPlus Oracle As400 Connections
Are you wondering how to connect Cocoon to your database and you have
got one of theese?:
* As400 <http://outerthought.net/wiki/Wiki.jsp?page=As400>
* BasisPlus <http://outerthought.net/wiki/Wiki.jsp?page=BasisPlus>
* Oracle <http://outerthought.net/wiki/Wiki.jsp?page=Oracle>
* PostgreSQL <http://outerthought.net/wiki/Wiki.jsp?page=PostgreSQL>
* MsSQL <http://outerthought.net/wiki/Wiki.jsp?page=MsSQL>
* MySQL <http://outerthought.net/wiki/Wiki.jsp?page=MySQL>
Then go to
http://outerthought.net/wiki/Wiki.jsp?page=SpecificDatabaseConnection
Thanks to the tribute from people who had your same problem, you can now
follow instructions on:
- Where to find the right drivers
- Which class to load for connection
- Tips and tricks specific of each database.
Please go there and contribute using the page and writing into it.
Now we can improve the mini-site:
- Restructuring it using the official documentation for the parts that
are common to all the DBs and Cocoon specific
- Going deeply describing success cases with complicated query or stored
procedures
- Enlargeing the number of DBs.
- Asking for inserting the best part of the initiative in the official
Covcoon documentation
Please support
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: MsSQL MySql PosgreSQL BasisPlus Oracle As400 Connections
Posted by Thor Heinrichs-Wolpert <th...@lunartek.com>.
Torque has some issues surrounding LOBs in Oracle, which have no
suitable work around for now (not eve a nifty bypass). Thanks for the
OJB url!
Thor HW
On Friday, December 6, 2002, at 02:53 AM, Nicola Ken Barozzi wrote:
>
>
> Antonio Gallardo wrote:
>> Hi,
>> I already saw your post on the wiki. :-D
>> The proposal is nice. Maybe we can make some changes to integrate
>> Torque
>> into Cocoon.
>> I will start to learn about Torque.
>> Thanks for your comments.
>
> Look at OJB http://jakarta.apache.org/ojb/index.html
>
> It's deemed to be better than torque by some Turbine developers, and
> has an Avalon component for it (ask on that dev list for it).
>
>> Antonio Gallardo.
>> Alex McLintock dijo:
>>> At 22:42 04/12/02, Gabriele Domenichini wrote:
>>>
>>>> Are you wondering how to connect Cocoon to your database and you
>>>> have
>>>> got one of theese?:
>>>>
>>>> * As400 <http://outerthought.net/wiki/Wiki.jsp?page=As400>
>>>> * BasisPlus <http://outerthought.net/wiki/Wiki.jsp?page=BasisPlus>
>>>> * Oracle <http://outerthought.net/wiki/Wiki.jsp?page=Oracle>
>>>> * PostgreSQL
>>>> <http://outerthought.net/wiki/Wiki.jsp?page=PostgreSQL> * MsSQL
>>>> <http://outerthought.net/wiki/Wiki.jsp?page=MsSQL>
>>>> * MySQL <http://outerthought.net/wiki/Wiki.jsp?page=MySQL>
>>>>
>>>>
>>>> Then go to
>>>>
>>>> http://outerthought.net/wiki/
>>>> Wiki.jsp?page=SpecificDatabaseConnection
>>>>
>>>> Thanks to the tribute from people who had your same problem, you can
>>>> now follow instructions on:
>>>
>>>
>>> Or better still, why not try using Apache Torque which is part of the
>>> Apache Turbine project, and get database independance.
>>> Has anyone tried that yet?
>>>
>>> Alex McLintock
>>>
>>>
>>>
>
> --
> Nicola Ken Barozzi nicolaken@apache.org
> - verba volant, scripta manent -
> (discussions get forgotten, just code remains)
> ---------------------------------------------------------------------
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: MsSQL MySql PosgreSQL BasisPlus Oracle As400 Connections
Posted by Nicola Ken Barozzi <ni...@apache.org>.
Antonio Gallardo wrote:
> Hi,
>
> I already saw your post on the wiki. :-D
>
> The proposal is nice. Maybe we can make some changes to integrate Torque
> into Cocoon.
>
> I will start to learn about Torque.
>
> Thanks for your comments.
Look at OJB http://jakarta.apache.org/ojb/index.html
It's deemed to be better than torque by some Turbine developers, and has
an Avalon component for it (ask on that dev list for it).
> Antonio Gallardo.
>
> Alex McLintock dijo:
>
>>At 22:42 04/12/02, Gabriele Domenichini wrote:
>>
>>>Are you wondering how to connect Cocoon to your database and you have
>>>got one of theese?:
>>>
>>> * As400 <http://outerthought.net/wiki/Wiki.jsp?page=As400>
>>> * BasisPlus <http://outerthought.net/wiki/Wiki.jsp?page=BasisPlus>
>>>* Oracle <http://outerthought.net/wiki/Wiki.jsp?page=Oracle>
>>> * PostgreSQL
>>><http://outerthought.net/wiki/Wiki.jsp?page=PostgreSQL> * MsSQL
>>><http://outerthought.net/wiki/Wiki.jsp?page=MsSQL>
>>> * MySQL <http://outerthought.net/wiki/Wiki.jsp?page=MySQL>
>>>
>>>
>>> Then go to
>>> http://outerthought.net/wiki/Wiki.jsp?page=SpecificDatabaseConnection
>>>
>>>Thanks to the tribute from people who had your same problem, you can
>>>now follow instructions on:
>>
>>
>>Or better still, why not try using Apache Torque which is part of the
>>Apache Turbine project, and get database independance.
>>Has anyone tried that yet?
>>
>>Alex McLintock
>>
>>
>>
--
Nicola Ken Barozzi nicolaken@apache.org
- verba volant, scripta manent -
(discussions get forgotten, just code remains)
---------------------------------------------------------------------
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: MsSQL MySql PosgreSQL BasisPlus Oracle As400 Connections
Posted by Antonio Gallardo <ag...@agsoftware.dnsalias.com>.
Hi,
I already saw your post on the wiki. :-D
The proposal is nice. Maybe we can make some changes to integrate Torque
into Cocoon.
I will start to learn about Torque.
Thanks for your comments.
Antonio Gallardo.
Alex McLintock dijo:
> At 22:42 04/12/02, Gabriele Domenichini wrote:
>>Are you wondering how to connect Cocoon to your database and you have
>> got one of theese?:
>>
>> * As400 <http://outerthought.net/wiki/Wiki.jsp?page=As400>
>> * BasisPlus <http://outerthought.net/wiki/Wiki.jsp?page=BasisPlus>
>> * Oracle <http://outerthought.net/wiki/Wiki.jsp?page=Oracle>
>> * PostgreSQL
>> <http://outerthought.net/wiki/Wiki.jsp?page=PostgreSQL> * MsSQL
>> <http://outerthought.net/wiki/Wiki.jsp?page=MsSQL>
>> * MySQL <http://outerthought.net/wiki/Wiki.jsp?page=MySQL>
>>
>>
>> Then go to
>> http://outerthought.net/wiki/Wiki.jsp?page=SpecificDatabaseConnection
>>
>>Thanks to the tribute from people who had your same problem, you can
>> now follow instructions on:
>
>
> Or better still, why not try using Apache Torque which is part of the
> Apache Turbine project, and get database independance.
> Has anyone tried that yet?
>
> Alex McLintock
>
>
>
>
> Openweb Analysts Ltd, London.
> Software For Complex Websites http://www.OWAL.co.uk/
> Open Source Software Companies please register here
> http://www.OWAL.co.uk/oss_support/
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: MsSQL MySql PosgreSQL BasisPlus Oracle As400 Connections
Posted by Alex McLintock <al...@OWAL.co.uk>.
At 22:42 04/12/02, Gabriele Domenichini wrote:
>Are you wondering how to connect Cocoon to your database and you have got
>one of theese?:
>
> * As400 <http://outerthought.net/wiki/Wiki.jsp?page=As400>
> * BasisPlus <http://outerthought.net/wiki/Wiki.jsp?page=BasisPlus>
> * Oracle <http://outerthought.net/wiki/Wiki.jsp?page=Oracle>
> * PostgreSQL <http://outerthought.net/wiki/Wiki.jsp?page=PostgreSQL>
> * MsSQL <http://outerthought.net/wiki/Wiki.jsp?page=MsSQL>
> * MySQL <http://outerthought.net/wiki/Wiki.jsp?page=MySQL>
>
>
> Then go to
> http://outerthought.net/wiki/Wiki.jsp?page=SpecificDatabaseConnection
>
>Thanks to the tribute from people who had your same problem, you can now
>follow instructions on:
Or better still, why not try using Apache Torque which is part of the
Apache Turbine project, and get database independance.
Has anyone tried that yet?
Alex McLintock
Openweb Analysts Ltd, London.
Software For Complex Websites http://www.OWAL.co.uk/
Open Source Software Companies please register here
http://www.OWAL.co.uk/oss_support/
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Deploying to Oracle's oc4j (aka Orion with mods)
Posted by Thor Heinrichs-Wolpert <th...@lunartek.com>.
I should've said -> I get this error when entering this URL
http://localhost:8888/cocoon/samples/welcome/
On Thursday, December 5, 2002, at 12:21 AM, Thor Heinrichs-Wolpert
wrote:
> I'm wondering if someone has already solved this.
>
> If I place my war file into Apache 4.1.12, everything works as
> expected.
>
> If I wrap the same war file into an ear and deploy it to oc4j ... it
> sort of works.
>
> Configuration:
> OSX 10.2
> Java 1.3.1
> Oracle's oc4j v 9.0.3
>
> Launch is
> java -Xbootclasspath/a:/<path to>/xalan-2.4.1.jar:/<path
> to>/xercesImpl-2.1.0.jar:/<path to>/xml-apis.jar
> -Djavax.xml.transform.TransformerFactory=
> org.apache.xalan.processor.TransformerFactoryImpl
> -Dorg.xml.sax.driver=oracle.xml.parser.v2.SAXParser
> -jar oc4j.jar
>
> I get the following error (which happens in other URI paths as well)
>
> Failed to load sitemap from
> file:/sw/oracle/products/oc4j/9.0.3/j2ee/home/applications/cocoon/
> cocoon/samples/welcome/sitemap.xmap
>
> More precisely:
>
> org.apache.cocoon.ProcessingException: Failed to load sitemap from
> file:/sw/oracle/products/oc4j/9.0.3/j2ee/home/applications/cocoon/
> cocoon/samples/welcome/sitemap.xmap:
> org.apache.cocoon.ResourceNotFoundException: Resource not found.:
> org.apache.excalibur.source.SourceNotFoundException: Resource not
> found
> file:/sw/oracle/products/oc4j/9.0.3/j2ee/home/applications/cocoon/
> cocoon/samples/welcome/sitemap.xmap
>
> Any hints?
> Cheers,
> Thor HW
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Deploying to Oracle's oc4j (aka Orion with mods)
Posted by Thor Heinrichs-Wolpert <th...@lunartek.com>.
I'm wondering if someone has already solved this.
If I place my war file into Apache 4.1.12, everything works as expected.
If I wrap the same war file into an ear and deploy it to oc4j ... it
sort of works.
Configuration:
OSX 10.2
Java 1.3.1
Oracle's oc4j v 9.0.3
Launch is
java -Xbootclasspath/a:/<path to>/xalan-2.4.1.jar:/<path
to>/xercesImpl-2.1.0.jar:/<path to>/xml-apis.jar
-Djavax.xml.transform.TransformerFactory=
org.apache.xalan.processor.TransformerFactoryImpl
-Dorg.xml.sax.driver=oracle.xml.parser.v2.SAXParser
-jar oc4j.jar
I get the following error (which happens in other URI paths as well)
Failed to load sitemap from
file:/sw/oracle/products/oc4j/9.0.3/j2ee/home/applications/cocoon/
cocoon/samples/welcome/sitemap.xmap
More precisely:
org.apache.cocoon.ProcessingException: Failed to load sitemap from
file:/sw/oracle/products/oc4j/9.0.3/j2ee/home/applications/cocoon/
cocoon/samples/welcome/sitemap.xmap:
org.apache.cocoon.ResourceNotFoundException: Resource not found.:
org.apache.excalibur.source.SourceNotFoundException: Resource not found
file:/sw/oracle/products/oc4j/9.0.3/j2ee/home/applications/cocoon/
cocoon/samples/welcome/sitemap.xmap
Any hints?
Cheers,
Thor HW
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>