Hi,

I wonder if anyone can help me.

Please could someone post a copy of store procedures?
indirect.proc_idu
indirect.proc_idg

I have run the SQL script '1_install_2005.sql' from TID 5006363.

and am trying to setup JDBC to SQL and seeing the following errors in
the Trace file:

DirXML: [07/21/09 16:56:02.64]: TRACE: INSERT INTO
indirect.grp(for_insert) VALUES (?)
DirXML: [07/21/09 16:56:02.65]: TRACE: IN @ index 1, field
'for_insert', value = null
DirXML: [07/21/09 16:56:02.67]: TRACE: {call indirect.proc_idg(?)}
DirXML: [07/21/09 16:56:02.67]: TRACE: IN @ index 1, field 'idg',
value = null
DirXML: [07/21/09 16:56:02.67]: TRACE: OUT @ index 1, field 'idg'
DirXML: [07/21/09 16:56:02.68]: TRACE: ROLLBACK
DirXML: [07/21/09 16:56:02.68]: TRACE: Remote Loader:
SubscriptionShim.execute() returned:
DirXML: [07/21/09 16:56:02.68]: TRACE: <nds dtdversion="2.0"
ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20070626_1024" instance="JDBC2"
version="2.1.7">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status level="warning">Unable to retrieve metadata for
procedure/function 'indirect.proc_idu'. Please check the
procedure/function name again and add a schema qualifier if necessary.
The absence of this metadata may affect this driver's ability to call
this stored procedure/function correctly.</status>
<status level="warning">Unable to retrieve metadata for
procedure/function 'indirect.proc_idg'. Please check the
procedure/function name again and add a schema qualifier if necessary.
The absence of this metadata may affect this driver's ability to call
this stored procedure/function correctly.</status>
<status event-id="TESTSRV#20090721154201#1#1" level="error"
type="app-general">
<description>Unable to add object. Unable to obtain value(s) from
stored procedure 'indirect.proc_idg'.</description>
<object-dn>O=ac\OU=hst\OU=external\CN=GrpWinResearchDB</object-dn>
<jdbc:exception
jdbc:class="com.microsoft.sqlserver.jdbc.SQLServer Exception"
jdbc:error-code="2812" jdbc:sql-state="S00062">
<jdbc:message>*Could not find stored procedure
'indirect.proc_idg'.*</jdbc:message>
</jdbc:exception>
<jdbc:document xml:space="preserve">&lt;nds dtdversion="3.0"
ndsversion="8.x">
&lt;source>
&lt;product version="3.0.0.20051118 ">DirXML&lt;/product>
&lt;contact>Novell, Inc.&lt;/contact>
&lt;/source>
&lt;input>



Thank you in advance

Byron


--
9122088
------------------------------------------------------------------------
9122088's Profile: http://forums.novell.com/member.php?userid=59547
View this thread: http://forums.novell.com/showthread.php?t=380697