JadeDBConnection can not Dispose in Jade6.3.03 unicode

[ConvertFromOldNGs]

by Didier >> Wed, 6 May 2009 8:20:14 GMT

Hi, Jade Support.

We use jade 6.3.03 unicode version
We can connect to Jade Database, and have evaluted other options--get object, create,delete jade object in VS2008 .
But can not dispose the JadeDBConnection object. Cause 1209 error.
the simplied example as following: ====================================================================================================================== using System;
using System.Collections.Generic;
using JadeWorld.Jade.Interop;

namespace WebApplication1
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
JadeDBConnection connection = null ;
JadeDBProcess process = null;
try
{
connection = new JadeDBConnection("Con1", "App1");
process = connection.GetProcess();
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
finally
{
process.Dispose();
connection.Dispose();
}

}
}
}
======================================================================================================================



Error dispaly in Web page. ====================================================================================================================== Server Error in '/' Application. --------------------------------------------------------------------------------

A Jade call returned error status, status=1209 - Application terminate request
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: JadeWorld.Jade.Interop.JadeJomException: A Jade call returned error status, status=1209 - Application terminate request

Source Error:


Line 43: {
Line 44: process.Dispose();
Line 45: connection.Dispose();
Line 46: }
Line 47:


Source File: E:\Hanyitong_unicode\netWeb\netWebApp\WebApplication1\Default.aspx.cs Line: 45

Stack Trace:


[JadeJomException: A Jade call returned error status, status=1209 - Application terminate request]
JadeWorld.Jade.Interop.JadeJomException.CheckJomResult(Int32 jomResult) in p:\cut\jade6303\language\jomDotNet\Exceptions.cs:174
JadeWorld.Jade.Interop.JadeProcess.SignOff() in p:\cut\jade6303\language\jomDotNet\JadeProcess.cs:338
JadeWorld.Jade.Interop.JadeNode.MultiProcessJadeSignOff(UInt32 timeout) in p:\cut\jade6303\language\jomDotNet\JadeNode.cs:158
JadeWorld.Jade.Interop.JadeDBConnection.Dispose(Boolean disposing) in p:\cut\jade6303\language\jomDotNet\Connection\JadeDBConnection.cs:290
JadeWorld.Jade.Interop.JadeDBConnection.Dispose() in p:\cut\jade6303\language\jomDotNet\Connection\JadeDBConnection.cs:276
WebApplication1._Default.Page_Load(Object sender, EventArgs e) in E:\Hanyitong_unicode\netWeb\netWebApp\WebApplication1\Default.aspx.cs:45
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436




--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
======================================================================================================================

Please give some clue.

Appreciate for any help.

Didier
2009.05.06

[ConvertFromOldNGs]

by Dean Cooper >> Thu, 7 May 2009 0:28:49 GMT

Do you use the "terminate" instruction anywhere in your application shutdown code?

Do you use "terminate" anywhere in your application at all?

Dean.

[ConvertFromOldNGs]

by Didier >> Thu, 7 May 2009 5:03:43 GMT

Hi:
Thanks for your tip.

After removing Application::Finalize Method, the issue is fixed.
We have a "terminate" instruction in Finalize Method.

Also we can not do some housekeeping-eg delete transient ObjectArray. Otherwise will cause 14123 error.

What can we do in Finalize Method when Jade Database accessed in .Net ? Is there an official docuemnt about this issue ?

Appreciate for any help.

Didier
2009.05.07

[ConvertFromOldNGs]

by Dean Cooper >> Fri, 8 May 2009 5:55:18 GMT

The behaviour of the terminate as part of the application finalise is working as intended. If you have a look at the description of "terminate" in DevRef.pdf, it explains why your .NET program is getting the 1209 exception:

"Use the terminate instruction to terminate all active methods. The terminate instruction cuts back the execution stack and then returns the following result to the controlling application. APPLICATION_TERMINATED (1209)"

The documentation states that this is and internal error that shouldn't usually occur. This is correct in terms of JADE code, but the 1209 exception is valid if the controlling application is external code (which it is if you're accessing JADE via a .NET Class Library exposure).

The description for a 14123 exception is "Operation is invalid for server execution". Does your housekeeping use serverExecution methods? If so, can you please attach the code for these methods, including the destructor code for any classes for which instances are being deleted.

Dean.