You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@olingo.apache.org by Joslyn Flores <jo...@gmail.com> on 2015/04/17 00:50:00 UTC

Olingo with Oracle and JPA simple sample

Hi

Is there any simple example of an Odata service using JPA accesing Oracle
table?

regards

Ing. Joslyn Flores Romero

Oracle DBA
55-1384-2685

Re: Olingo with Oracle and JPA simple sample

Posted by mibo <mi...@apache.org>.

Hi Joslyn,

for Olingo V4 actual no JPA extension (like for Olingo V2) exists.
Only a POC in https://issues.apache.org/jira/browse/OLINGO-549 was created.

Hence, current way to publish a service with data from JPA is to implement the processor and the database layer by ourself.

Best regards,
Michael



> Am 17.04.2015 um 19:15 schrieb Joslyn Flores <jo...@gmail.com>:
> 
> Hi Michael
> 
> i already have a JPA working sample with Oracle and JPA but i cant find a working sample with v4 with jpa
> 
> 
> do you know a step-by-step tutorial to publish a service with data from a database using jpa with olingo v4 ?
> 
> regards
> 
> Ing. Joslyn Flores Romero
> Oracle DBA
> 55-1384-2685
> 
> 2015-04-16 20:03 GMT-05:00 Bolz, Michael <mi...@sap.com>:
> Hi,
> 
> is your question related to OData V2 or V4?
> 
> For V2 with Olingo 2.x I don’t know an explicit sample service for Olingo / JPA / Oracle.
> But if you use the JPA extension it should be possible to configure the data source to connect with a oracle database (e.g. "http://docs.oracle.com/cd/E15315_09/help/oracle.eclipse.tools.orm.doc/html/files/libAndFacetForJPA.html”).
> 
> For V4 with Olingo 4.x actual no JPA extension exists.
> Hence, the developer of an OData Service has to provide the database access by himself.
> And then the access to a Oracle database via JPA is the same as in a common JEE environment.
> 
> Best regards,
> Michael
> 
>> On 17 Apr 2015, at 00:50, Joslyn Flores <jo...@gmail.com> wrote:
>> 
>> Hi
>> 
>> Is there any simple example of an Odata service using JPA accesing Oracle table?
>> 
>> regards
>> 
>> Ing. Joslyn Flores Romero
>> Oracle DBA
>> 55-1384-2685
> 
>

Re: Olingo with Oracle and JPA simple sample

Posted by Joslyn Flores <jo...@gmail.com>.

Hi Michael

i already have a JPA working sample with Oracle and JPA but i cant find a
working sample with v4 with jpa


do you know a step-by-step tutorial to publish a service with data from a
database using jpa with olingo v4 ?

regards

Ing. Joslyn Flores Romero

Oracle DBA
55-1384-2685

2015-04-16 20:03 GMT-05:00 Bolz, Michael <mi...@sap.com>:

> Hi,
>
> is your question related to OData V2 or V4?
>
> For V2 with Olingo 2.x I don’t know an explicit sample service for Olingo
> / JPA / Oracle.
> But if you use the JPA extension it should be possible to configure the
> data source to connect with a oracle database (e.g. "
> http://docs.oracle.com/cd/E15315_09/help/oracle.eclipse.tools.orm.doc/html/files/libAndFacetForJPA.html
> ”).
>
> For V4 with Olingo 4.x actual no JPA extension exists.
> Hence, the developer of an OData Service has to provide the database
> access by himself.
> And then the access to a Oracle database via JPA is the same as in a
> common JEE environment.
>
> Best regards,
> Michael
>
> On 17 Apr 2015, at 00:50, Joslyn Flores <jo...@gmail.com> wrote:
>
> Hi
>
> Is there any simple example of an Odata service using JPA accesing Oracle
> table?
>
> regards
>
> Ing. Joslyn Flores Romero
>
> Oracle DBA
> 55-1384-2685
>
>
>

Re: Olingo with Oracle and JPA simple sample

Posted by "Bolz, Michael" <mi...@sap.com>.

Hi,

is your question related to OData V2 or V4?

For V2 with Olingo 2.x I don’t know an explicit sample service for Olingo / JPA / Oracle.
But if you use the JPA extension it should be possible to configure the data source to connect with a oracle database (e.g. "http://docs.oracle.com/cd/E15315_09/help/oracle.eclipse.tools.orm.doc/html/files/libAndFacetForJPA.html <http://docs.oracle.com/cd/E15315_09/help/oracle.eclipse.tools.orm.doc/html/files/libAndFacetForJPA.html>”).

For V4 with Olingo 4.x actual no JPA extension exists.
Hence, the developer of an OData Service has to provide the database access by himself.
And then the access to a Oracle database via JPA is the same as in a common JEE environment.

Best regards,
Michael

> On 17 Apr 2015, at 00:50, Joslyn Flores <jo...@gmail.com> wrote:
> 
> Hi 
> 
> Is there any simple example of an Odata service using JPA accesing Oracle table?
> 
> regards
> 
> Ing. Joslyn Flores Romero
> Oracle DBA
> 55-1384-2685