|
|
|
Re: BUG : postgresql @NamedStoredProcedureQuery call [message #1124425 is a reply to message #1121392] |
Thu, 03 October 2013 14:23 |
Omid Pourhadi Messages: 13 Registered: May 2013 |
Junior Member |
|
|
thank you Chris,
if you mean org.eclipse.persistence.platform.database.PostgreSQLPlatform
yes I have used it as target database and it is "EXECUTE" in getProcedureCallHeader() method not SELECT anyway Do you know why direction is deprecated ?
I have a function with two input arguments and two output arguments which is defined as follow
@NamedStoredProcedureQuery(name = DocumentAccess.CONTAINS_DOC_BY_ANOTHER_OWNER, procedureName = "contains_doc_by_another_owner", parameters = {
@StoredProcedureParameter(queryParameter = "commaSeparatedIds", type = String.class, direction=Direction.IN),
@StoredProcedureParameter(queryParameter = "uid", type = Long.class, direction=Direction.IN),
@StoredProcedureParameter(queryParameter = "has_another_owner", type = Boolean.class, direction= Direction.OUT),
@StoredProcedureParameter(queryParameter = "doc_id", type = Long.class, direction= Direction.OUT)}, resultSetMappings = { DocumentAccess.CONTAINS_DOC_BY_ANOTHER_OWNER }),
but the query is select contains_doc_by_another_owner(?,?) . it should be
select has_another_owner, doc_id from contains_doc_by_another_owner(?,?)
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03088 seconds