Hibernate Community • View topic - Stored procedure with currentSchema

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Stored procedure with currentSchema

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

brnzn

Post subject: Stored procedure with currentSchema

Posted: Mon Jul 20, 2009 8:40 am

Newbie

Joined: Mon Jul 13, 2009 10:46 am
Posts: 2

Hi,

I am using Spring + Hibernate and I am having a problem calling Stored procedure without explicitly setting currentSchema.

My connection url is:

Code:

jdbc:db2://myserver:[port number]/DB2D:currentSchema=myschema;

Using mapped classes is working fine.

Calling sp as follow

Code:

{call MySP(?, ?)}

result -440 error.

Calling it with the schema name as follow works fine:

Code:

{call myschema.MySP(?, ?)}

Trace for both cases shows DriverManagerDataSource:289 - Creating new JDBC Connection to [jdbc:db2://myserver:[port number]/DB2D:currentSchema=myschema;]

Do I have to explicitly set the schema name before call sp?

Thanks

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum