Re: No TDS_RET_STATUS
- From: "joeNOSPAM@xxxxxxx" <joe.weinstein@xxxxxxxxx>
- Date: 17 Jan 2007 14:00:05 -0800
Ok. A few suggestions:
1 - you shouldn't be doing that commit() call. If you
have a real transaction, you should commit it
at the level you start it. If you haven't started a transaction
that's a waste.
2 - You should process all the inline results from the
statement execute() before you try to get any
output parameters. Try this code: (Assuming there
aren't any inline results you care about)
int updateCount = -1;
boolean getRs = m_FindChildCallStatement.execute();
while (true) // clear any inline returns
{
if (getRs) m_FindChildCallStatement.getResultSet().close();
else updateCount = m_FindChildCallStatement.getUpdateCount();
if (!getRs && (updateCount == -1)) break; // done with loop
else getRs = m_FindChildCallStatement.getMoreResults();
}
// get output param values after loop
childId = m_FindChildCallStatement.getInt(4);
Joe Weinstein at BEA Systems
.
- References:
- Re: No TDS_RET_STATUS
- From: Joe Weinstein
- Re: No TDS_RET_STATUS
- Prev by Date: Re: No TDS_RET_STATUS
- Next by Date: Re: Connection Refused
- Previous by thread: Re: No TDS_RET_STATUS
- Next by thread: Re: Connection Refused
- Index(es):
Relevant Pages
|
Loading