MSSQL Issue

[Ravikumar N B]

Hi

Previously My custom application data are Mysql Database.

Now i tried to change Mysql to MSSQL

So migrate all data into MSSQL.

DB schema are same and data also same.

But it change my connection to MSSQL i got error

org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
[component://common/widget/CommonScreens.xml#GlobalDecorator]:
org.ofbiz.base.util.GeneralRuntimeException: Error while checking to see if
this is the last result (The requested operation is not supported on forward
only result sets.) (Error while checking to see if this is the last result
(The requested operation is not supported on forward only result sets.))

I got this error only in one page, not in all pages.

Please help me.

[BJ Freeman]

Please provide more logs as this does not give enough info.
also use the user mailing list for this type of quesion
this mailing list if for design and the developement of ofbiz
support is on the user ML.


Ravi Kumar sent the following on 5/29/2009 9:12 AM:

> Hi
>
> Previously My custom application data are Mysql Database.
>
> Now i tried to change Mysql to MSSQL
>
> So migrate all data into MSSQL.
>
> DB schema are same and data also same.
>
> But it change my connection to MSSQL i got error
>
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> [component://common/widget/CommonScreens.xml#GlobalDecorator]:
> org.ofbiz.base.util.GeneralRuntimeException: Error while checking to see if
> this is the last result (The requested operation is not supported on forward
> only result sets.) (Error while checking to see if this is the last result
> (The requested operation is not supported on forward only result sets.))
>
> I got this error only in one page, not in all pages.
>
> Please help me.
>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.