I have a MS SQL Server 2008 R2 and have a stored procedure in here. I want to create a layer in Geoserver using this. I try:
EXECUTE [dd_base].[dbo].[Request BaseSration] 'param1', 'param2', 'param3', 'param4' GO
error near key word EXECUTE.
In Geoserver logs:
ERROR [geoserver.web] - Failed to create feature type java.io.IOException: Error occurred building feature type
What am I doing wrong?