Eclipse Community Forums: EclipseLink » set schema name for stored procedures using JPA

Help

Home

Home » Eclipse Projects » EclipseLink » set schema name for stored procedures using JPA

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

set schema name for stored procedures using JPA [message #778629]

Fri, 13 January 2012 10:07

Sridhar Baratam
Messages: 22
Registered: September 2011

Junior Member

Hello All:

I am using an Oracle database which has a schema name associated with it. I am able to use the SessionCustomizer override
session.getLogin().setTableQualifier(schema) to set the schema name. However, this only works for tables. When I try to call a stored procedure using a named query, it does not get honoured and I get procedure not found errors.

Can you please help me in this regard?

I appreciate all the help.

Thanks
Sridhar

Report message to a moderator

[Message index]

		set schema name for stored procedures using JPA By: Sridhar Baratam on Fri, 13 January 2012 10:07
		Re: set schema name for stored procedures using JPA By: James Sutherland on Mon, 16 January 2012 13:44
		Re: set schema name for stored procedures using JPA By: James Sutherland on Mon, 16 January 2012 13:44
		Re: set schema name for stored procedures using JPA By: Sridhar Baratam on Tue, 17 January 2012 09:34
		Re: set schema name for stored procedures using JPA By: James Sutherland on Thu, 19 January 2012 11:29
		Re: set schema name for stored procedures using JPA By: James Sutherland on Thu, 19 January 2012 11:29
		Re: set schema name for stored procedures using JPA By: James Sutherland on Thu, 19 January 2012 11:29
		Re: set schema name for stored procedures using JPA By: James Sutherland on Thu, 19 January 2012 11:29
		Re: set schema name for stored procedures using JPA By: Sridhar Baratam on Tue, 17 January 2012 09:34

Previous Topic:	Shared cache on multi base using same classes
Next Topic:	Error when trying to use PLSQLTable type as an IN parameter in a PLSQLStoredProcedure in eclipse lin

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 11:23:31 EDT 2013