You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ode.apache.org by Les Spivey <Le...@Attachmate.com> on 2010/06/22 19:56:14 UTC
ode and h2
Hi,
Is there documentation published for configuring Ode to use an external
H2 database?
Thanks in advance,
Les
Re: ode and h2
Posted by Tammo van Lessen <tv...@gmail.com>.
Hi,
yes, currently we support both, each with a different DAO
implementation. OpenJPA will remain the main DAO implementation for ODE
distributions due to licensing issues. However, we're moving towards a
single JPA 2.0 DAO that can be used with either implementation (OpenJPA
and Hibernate).
Tammo
On 24.06.2010 03:07, hbdrawn wrote:
>
> both used util now. And the current direction is to use hibernate rather than
> openjpa ,which is now noted and developing by dev.
>
> Les Spivey wrote:
>>
>> Thanks, again. I'm curious, I thought Ode already includes OpenJPA.
>> Could this not be accomplished using OpenJPA rather than Hibernate?
>>
>> -----Original Message-----
>> From: Rafal Rusin [mailto:rafal@intalio.com]
>> Sent: Wednesday, June 23, 2010 6:29 AM
>> To: user@ode.apache.org
>> Subject: Re: ode and h2
>>
>> Hello,
>>
>> I generated schema for H2 and put intstructions on how to run it.
>> Please check out https://cwiki.apache.org/ODExSITE/ode-schema.html.
>> It will appear soon on http://ode.apache.org/ode-schema.html.
>> I tried some BPEL test cases under H2 and it seems to work fine.
>>
>> On Tue, Jun 22, 2010 at 11:03 PM, Veresh Jain <ve...@intalio.com> wrote:
>>> I think it should be possible to use MySQL schema by running H2 in MySQL
>>> mode.
>>>
>>> Veresh
>>> -----Original Message-----
>>> From: Les Spivey [mailto:Les.Spivey@Attachmate.com]
>>> Sent: Tuesday, June 22, 2010 1:22 PM
>>> To: user@ode.apache.org
>>> Subject: RE: ode and h2
>>>
>>> Thanks for responding. Is there actually an ode-schema-h2.sql script
>>> somewhere? If not, is it essentially the same as the MySQL one?
>>>
>>> Les
>>>
>>>
>>> -----Original Message-----
>>> From: Rafal Rusin [mailto:rafal@intalio.com]
>>> Sent: Tuesday, June 22, 2010 11:16 AM
>>> To: user@ode.apache.org
>>> Subject: Re: ode and h2
>>>
>>> There's no such thing yet.
>>> But this should be possible provided that you create schema before
>>> run, like this:
>>> java -cp h2-1.1.108.jar org.h2.tools.RunScript -url
>>> 'jdbc:h2:file:ode-db;DB_CLOSE_ON_EXIT=false' -user sa -showResults
>>> -script ode-schema-h2.sql
>>>
>>> On Tue, Jun 22, 2010 at 7:56 PM, Les Spivey <Le...@attachmate.com>
>>> wrote:
>>>> Hi,
>>>>
>>>>
>>>>
>>>> Is there documentation published for configuring Ode to use an external
>>>> H2 database?
>>>>
>>>>
>>>>
>>>> Thanks in advance,
>>>>
>>>> Les
>>>
>>> --
>>> Regards,
>>> Rafał Rusin
>>> http://rrusin.blogspot.com
>>
>> --
>> Regards,
>> Rafał Rusin
>> http://rrusin.blogspot.com
>>
>>
>
--
Tammo van Lessen - http://www.taval.de
RE: ode and h2
Posted by hbdrawn <hb...@163.com>.
both used util now. And the current direction is to use hibernate rather than
openjpa ,which is now noted and developing by dev.
Les Spivey wrote:
>
> Thanks, again. I'm curious, I thought Ode already includes OpenJPA.
> Could this not be accomplished using OpenJPA rather than Hibernate?
>
> -----Original Message-----
> From: Rafal Rusin [mailto:rafal@intalio.com]
> Sent: Wednesday, June 23, 2010 6:29 AM
> To: user@ode.apache.org
> Subject: Re: ode and h2
>
> Hello,
>
> I generated schema for H2 and put intstructions on how to run it.
> Please check out https://cwiki.apache.org/ODExSITE/ode-schema.html.
> It will appear soon on http://ode.apache.org/ode-schema.html.
> I tried some BPEL test cases under H2 and it seems to work fine.
>
> On Tue, Jun 22, 2010 at 11:03 PM, Veresh Jain <ve...@intalio.com> wrote:
>> I think it should be possible to use MySQL schema by running H2 in MySQL
>> mode.
>>
>> Veresh
>> -----Original Message-----
>> From: Les Spivey [mailto:Les.Spivey@Attachmate.com]
>> Sent: Tuesday, June 22, 2010 1:22 PM
>> To: user@ode.apache.org
>> Subject: RE: ode and h2
>>
>> Thanks for responding. Is there actually an ode-schema-h2.sql script
>> somewhere? If not, is it essentially the same as the MySQL one?
>>
>> Les
>>
>>
>> -----Original Message-----
>> From: Rafal Rusin [mailto:rafal@intalio.com]
>> Sent: Tuesday, June 22, 2010 11:16 AM
>> To: user@ode.apache.org
>> Subject: Re: ode and h2
>>
>> There's no such thing yet.
>> But this should be possible provided that you create schema before
>> run, like this:
>> java -cp h2-1.1.108.jar org.h2.tools.RunScript -url
>> 'jdbc:h2:file:ode-db;DB_CLOSE_ON_EXIT=false' -user sa -showResults
>> -script ode-schema-h2.sql
>>
>> On Tue, Jun 22, 2010 at 7:56 PM, Les Spivey <Le...@attachmate.com>
>> wrote:
>>> Hi,
>>>
>>>
>>>
>>> Is there documentation published for configuring Ode to use an external
>>> H2 database?
>>>
>>>
>>>
>>> Thanks in advance,
>>>
>>> Les
>>
>> --
>> Regards,
>> Rafał Rusin
>> http://rrusin.blogspot.com
>
> --
> Regards,
> Rafał Rusin
> http://rrusin.blogspot.com
>
>
--
View this message in context: http://old.nabble.com/ode-and-h2-tp28963133p28978036.html
Sent from the Apache Ode User mailing list archive at Nabble.com.
RE: ode and h2
Posted by Les Spivey <Le...@Attachmate.com>.
Thanks, again. I'm curious, I thought Ode already includes OpenJPA. Could this not be accomplished using OpenJPA rather than Hibernate?
-----Original Message-----
From: Rafal Rusin [mailto:rafal@intalio.com]
Sent: Wednesday, June 23, 2010 6:29 AM
To: user@ode.apache.org
Subject: Re: ode and h2
Hello,
I generated schema for H2 and put intstructions on how to run it.
Please check out https://cwiki.apache.org/ODExSITE/ode-schema.html.
It will appear soon on http://ode.apache.org/ode-schema.html.
I tried some BPEL test cases under H2 and it seems to work fine.
On Tue, Jun 22, 2010 at 11:03 PM, Veresh Jain <ve...@intalio.com> wrote:
> I think it should be possible to use MySQL schema by running H2 in MySQL mode.
>
> Veresh
> -----Original Message-----
> From: Les Spivey [mailto:Les.Spivey@Attachmate.com]
> Sent: Tuesday, June 22, 2010 1:22 PM
> To: user@ode.apache.org
> Subject: RE: ode and h2
>
> Thanks for responding. Is there actually an ode-schema-h2.sql script somewhere? If not, is it essentially the same as the MySQL one?
>
> Les
>
>
> -----Original Message-----
> From: Rafal Rusin [mailto:rafal@intalio.com]
> Sent: Tuesday, June 22, 2010 11:16 AM
> To: user@ode.apache.org
> Subject: Re: ode and h2
>
> There's no such thing yet.
> But this should be possible provided that you create schema before
> run, like this:
> java -cp h2-1.1.108.jar org.h2.tools.RunScript -url
> 'jdbc:h2:file:ode-db;DB_CLOSE_ON_EXIT=false' -user sa -showResults
> -script ode-schema-h2.sql
>
> On Tue, Jun 22, 2010 at 7:56 PM, Les Spivey <Le...@attachmate.com> wrote:
>> Hi,
>>
>>
>>
>> Is there documentation published for configuring Ode to use an external
>> H2 database?
>>
>>
>>
>> Thanks in advance,
>>
>> Les
>
> --
> Regards,
> Rafał Rusin
> http://rrusin.blogspot.com
--
Regards,
Rafał Rusin
http://rrusin.blogspot.com
Re: ode and h2
Posted by Rafal Rusin <ra...@intalio.com>.
Hello,
I generated schema for H2 and put intstructions on how to run it.
Please check out https://cwiki.apache.org/ODExSITE/ode-schema.html.
It will appear soon on http://ode.apache.org/ode-schema.html.
I tried some BPEL test cases under H2 and it seems to work fine.
On Tue, Jun 22, 2010 at 11:03 PM, Veresh Jain <ve...@intalio.com> wrote:
> I think it should be possible to use MySQL schema by running H2 in MySQL mode.
>
> Veresh
> -----Original Message-----
> From: Les Spivey [mailto:Les.Spivey@Attachmate.com]
> Sent: Tuesday, June 22, 2010 1:22 PM
> To: user@ode.apache.org
> Subject: RE: ode and h2
>
> Thanks for responding. Is there actually an ode-schema-h2.sql script somewhere? If not, is it essentially the same as the MySQL one?
>
> Les
>
>
> -----Original Message-----
> From: Rafal Rusin [mailto:rafal@intalio.com]
> Sent: Tuesday, June 22, 2010 11:16 AM
> To: user@ode.apache.org
> Subject: Re: ode and h2
>
> There's no such thing yet.
> But this should be possible provided that you create schema before
> run, like this:
> java -cp h2-1.1.108.jar org.h2.tools.RunScript -url
> 'jdbc:h2:file:ode-db;DB_CLOSE_ON_EXIT=false' -user sa -showResults
> -script ode-schema-h2.sql
>
> On Tue, Jun 22, 2010 at 7:56 PM, Les Spivey <Le...@attachmate.com> wrote:
>> Hi,
>>
>>
>>
>> Is there documentation published for configuring Ode to use an external
>> H2 database?
>>
>>
>>
>> Thanks in advance,
>>
>> Les
>
> --
> Regards,
> Rafał Rusin
> http://rrusin.blogspot.com
--
Regards,
Rafał Rusin
http://rrusin.blogspot.com
RE: ode and h2
Posted by Veresh Jain <ve...@intalio.com>.
I think it should be possible to use MySQL schema by running H2 in MySQL mode.
Veresh
-----Original Message-----
From: Les Spivey [mailto:Les.Spivey@Attachmate.com]
Sent: Tuesday, June 22, 2010 1:22 PM
To: user@ode.apache.org
Subject: RE: ode and h2
Thanks for responding. Is there actually an ode-schema-h2.sql script somewhere? If not, is it essentially the same as the MySQL one?
Les
-----Original Message-----
From: Rafal Rusin [mailto:rafal@intalio.com]
Sent: Tuesday, June 22, 2010 11:16 AM
To: user@ode.apache.org
Subject: Re: ode and h2
There's no such thing yet.
But this should be possible provided that you create schema before
run, like this:
java -cp h2-1.1.108.jar org.h2.tools.RunScript -url
'jdbc:h2:file:ode-db;DB_CLOSE_ON_EXIT=false' -user sa -showResults
-script ode-schema-h2.sql
On Tue, Jun 22, 2010 at 7:56 PM, Les Spivey <Le...@attachmate.com> wrote:
> Hi,
>
>
>
> Is there documentation published for configuring Ode to use an external
> H2 database?
>
>
>
> Thanks in advance,
>
> Les
--
Regards,
Rafał Rusin
http://rrusin.blogspot.com
RE: ode and h2
Posted by Les Spivey <Le...@Attachmate.com>.
Thanks for responding. Is there actually an ode-schema-h2.sql script somewhere? If not, is it essentially the same as the MySQL one?
Les
-----Original Message-----
From: Rafal Rusin [mailto:rafal@intalio.com]
Sent: Tuesday, June 22, 2010 11:16 AM
To: user@ode.apache.org
Subject: Re: ode and h2
There's no such thing yet.
But this should be possible provided that you create schema before
run, like this:
java -cp h2-1.1.108.jar org.h2.tools.RunScript -url
'jdbc:h2:file:ode-db;DB_CLOSE_ON_EXIT=false' -user sa -showResults
-script ode-schema-h2.sql
On Tue, Jun 22, 2010 at 7:56 PM, Les Spivey <Le...@attachmate.com> wrote:
> Hi,
>
>
>
> Is there documentation published for configuring Ode to use an external
> H2 database?
>
>
>
> Thanks in advance,
>
> Les
--
Regards,
Rafał Rusin
http://rrusin.blogspot.com
Re: ode and h2
Posted by Rafal Rusin <ra...@intalio.com>.
There's no such thing yet.
But this should be possible provided that you create schema before
run, like this:
java -cp h2-1.1.108.jar org.h2.tools.RunScript -url
'jdbc:h2:file:ode-db;DB_CLOSE_ON_EXIT=false' -user sa -showResults
-script ode-schema-h2.sql
On Tue, Jun 22, 2010 at 7:56 PM, Les Spivey <Le...@attachmate.com> wrote:
> Hi,
>
>
>
> Is there documentation published for configuring Ode to use an external
> H2 database?
>
>
>
> Thanks in advance,
>
> Les
--
Regards,
Rafał Rusin
http://rrusin.blogspot.com