Hi,
I have a jdbc driver that calls a stored procedure and returns a
result. The driver is started and the first user I create the process
runs fine. The second user created gives this error

Error
<status event-id="0" level="error" type="app-general">
<description>Unable to obtain value(s) from stored procedure
'IDMADMIN.check_for_user'. Unable to retrieve statement
results.</description>
<jdbc:exception jdbc:class="java.lang.NullPointerException"
xmlns:jdbc="urn:dirxml:jdbc" xmlns:jdbc-1="urn:dirxml:jdbc"/>
<jdbc:document xml:space="preserve"
xmlns:jdbc="urn:dirxml:jdbc">&lt;nds>
&lt;input xmlns:jdbc="urn:dirxml:jdbc">
&lt;jdbc:statement event-id="0">
&lt;jdbc:call-procedure jdbc:name="IDMADMIN.check_for_user">
&lt;jdbcaram jdbc:name="@User_ID">
&lt;jdbc:value>aaa&lt;/jdbc:value>
&lt;/jdbcaram>
&lt;jdbcaram jdbc:name="@User_ID_Exists">
&lt;jdbc:value/>
&lt;/jdbcaram>
&lt;/jdbc:call-procedure>
&lt;/jdbc:statement>
&lt;/input>
&lt;/nds></jdbc:document>
<application>DirXML</application>
<module>Aderant-DB</module>
<object-dn>\IDM\HD\adtstusr\aaardvark</object-dn>
<component>Subscriber</component>
</status>

If I stop and restart the driver, the first user works correctly and
all others fail.
I have attached the log for the above (cut a few bits to allow
upload)with the first user passed to shim at 10:31:10 and the failing
user at 10:31:59.

Anyone any ideas on this ??
I am going to try various other approaches to get more info, but would
welcome any input.
Cheers


+----------------------------------------------------------------------+
|Filename: aderantdb.txt |
|Download: http://forums.novell.com/attachment....achmentid=4050 |
+----------------------------------------------------------------------+

--
parrydave
------------------------------------------------------------------------
parrydave's Profile: http://forums.novell.com/member.php?userid=6588
View this thread: http://forums.novell.com/showthread.php?t=403521