Eclipse Community Forums: EclipseLink » Adapting to existing database

Help

Home

Home » Eclipse Projects » EclipseLink » Adapting to existing database

Show: Today's Messages :: Show Polls :: Message Navigator

Adapting to existing database [message #514344]

Sun, 14 February 2010 19:39

Eclipse User

Originally posted by: ossipetz.gmail.com

Hello

I would like to get some advice. I am currently moving from hibernate to
eclipselink/JPA

My current task is to connect to an existing database that contains a
lot of logic. E.g. reading data is done by querying database views. So
an O/R mapping (what I am used to doing with hibernate) seems quite
straightforward.

The crucial point is the saving of data: this must be done calling
stored procedure (on the oracle database 10g / 11g).

I've seen there is an annotation @NamedStoredProcedureQuery in
eclipselink to use stored procedures.

Is it possible (or advisable) to mix reading (using standard O/R mapping
methods) and writing to the database with stored procedure calls?
Or must all operations be done via procedures?

How do relations behave with procedures?

There are quite a lot of tables and writing to table may change from
procedure to straight-forward inserts in the future.

I would be happy to hear some experience or get some advice on this.

Thanks a lot!

regards
ossi

Report message to a moderator

Re: Adapting to existing database [message #517926 is a reply to message #514344]

Tue, 02 March 2010 14:40

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

You can override any operation in EclipseLink using a stored procedure call. There are no JPA annotations for this yet, so you need to use a @DescriptorCustomizer and set the StoredProcedureCall into the DescriptorQueryManager. You can override any CRUD operation, as well as any mapping operation.

See,
http://wiki.eclipse.org/Configuring_a_Relational_Descriptor_ %28ELUG%29#How_to_Configure_Custom_SQL_Queries_for_Basic_Per sistence_Operations_Using_Java

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	Set JPA entities at runtime
Next Topic:	EclipseLinkException

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 18:38:54 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter