Executing a stored procedure

[venkatesh at effigent.com (Venkatesh)]

--Apple-Mail-34--119502402
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	delsp=yes;
	charset=US-ASCII;
	format=flowed

Hi ,

I am trying to execute a stored procedure from Web Objects application  
but getting below mentioned exception.


> java.lang.NullPointerException
> 	at  
> com.webobjects.eoaccess.EOUtilities.executeStoredProcedureNamed(EOUtili 
> ties.java:668)
> 	at  
> com.effigent.reusables.ums.businessclasses.FormattedAutoNumberBusinessC 
> lass.getNextRunningNumber(FormattedAutoNumberBusinessClass.java:391)
> 	at  
> com.effigent.reusables.ums.businessclasses.FormattedAutoNumberBusinessC 
> lass.getValueForSymbol(FormattedAutoNumberBusinessClass.java:319)
> 	at  
> com.effigent.reusables.ums.businessclasses.FormattedAutoNumberBusinessC 
> lass.getNextNumberForFormat(FormattedAutoNumberBusinessClass.java:263). 
> ...

Data base used is Sybase.

I tried to execute the stored procedure from the isql and it works fine.

  I also checked the parameters which are passed to the methods and they  
are not null.

resultDict =  
EOUtilities.executeStoredProcedureNamed(aFormatAutoNumObj.editingContext 
(),spName,dict);

is the line where stored procedure is invoked. Variable 'spName'  
contains the name of the Stored procedure to be invoked. 'dict' is  
dictionary that contains attributes which need to be passed to the  
stored procedure as key and value. There are two elements in the  
dictionary. One is the output parameter(of type numeric) and the other  
is the input parameters if type string.

I checked the bindings in the eomodel and they seem to be fine(things  
like the stored procedure name is ok, name and columnname of the  
attributes used are same etc).

Inputs on this issue  would be of great help.

Thanks

Venkatesh
--Apple-Mail-34--119502402
Content-Transfer-Encoding: 7bit
Content-Type: text/enriched;
	charset=US-ASCII

Hi ,


I am trying to execute a stored procedure from Web Objects application
but getting below mentioned exception.



<excerpt><fixed><color><param>8837,3ACA,FFFC</param>java.lang.NullPointerException

	at
com.webobjects.eoaccess.EOUtilities.executeStoredProcedureNamed(EOUtilities.java:668)

	at
com.effigent.reusables.ums.businessclasses.FormattedAutoNumberBusinessClass.getNextRunningNumber(FormattedAutoNumberBusinessClass.java:391)

	at
com.effigent.reusables.ums.businessclasses.FormattedAutoNumberBusinessClass.getValueForSymbol(FormattedAutoNumberBusinessClass.java:319)

	at
com.effigent.reusables.ums.businessclasses.FormattedAutoNumberBusinessClass.getNextNumberForFormat(FormattedAutoNumberBusinessClass.java:263)....</color>

</fixed></excerpt>

Data base used is Sybase. 


I tried to execute the stored procedure from the isql and it works
fine.


 I also checked the parameters which are passed to the methods and
they are not null. 

<fixed>

resultDict =
EOUtilities.executeStoredProcedureNamed(aFormatAutoNumObj.editingContext(),spName,dict);


is the line where stored procedure is invoked. Variable 'spName'
contains the name of the Stored procedure to be invoked. 'dict' is
dictionary that contains attributes which need to be passed to the
stored procedure as key and value. There are two elements in the
dictionary. One is the output parameter(of type numeric) and the other
is the input parameters if type string. 

</fixed>

I checked the bindings in the eomodel and they seem to be fine(things
like the stored procedure name is ok, name and columnname of the
attributes used are same etc).


Inputs on this issue  would be of great help.


Thanks 


Venkatesh
--Apple-Mail-34--119502402--