In the following table, the description provides the SQL data type. If you are writing your script in Java or .NET, you should use the appropriate corresponding data type. See SQL-Java data types and SQL-.NET data types.

In SQL scripts, you can specify event parameters by name or with a question mark. Using question marks has been deprecated and it is recommended that you use named parameters. You cannot mix names and question marks within a script. If you use question marks, the parameters must be in the order shown below and are optional only if no subsequent parameters are specified (for example, you must use parameter 1 if you want to use parameter 2). If you use named parameters, you can specify any subset of the parameters in any order.

The MobiLink server selects a default action. You can modify the action in the script, and return a value instructing MobiLink how to proceed. The action_code parameter takes one of the following values:

The MobiLink server sends in the current action code. Initially, this is set to 3000 for each set of errors caused by a single SQL operation. Usually, there is only one error per SQL operation, but there may be more. If uploading rows in batches, this handle_error script is called once per error in the batch. During the same synchronization the action code passed into the first error is 3000. Subsequent calls are passed in the action code returned by the previous call. MobiLink uses the highest numerical value returned from multiple calls.

For more information about uploading rows in batches, see -s mlsrv12 option.

You can modify the action code in the script, and return a value instructing MobiLink how to proceed. The action code tells the MobiLink server what to do next. Before it calls this script, the MobiLink server sets the action code to a default value, which depends upon the severity of the error. Your script may modify this value. Your script must return or set an action code.

The error_code and message allow you to identify the nature of the error.

The MobiLink server executes this script if an ODBC error occurs while MobiLink is processing an insert, update, or delete script during the upload transaction or is fetching download rows. If an ODBC error occurs at another time, the MobiLink server calls the report_error or report_ODBC_error script and aborts the synchronization.

If the error happened while manipulating a particular table, the table name is supplied. Otherwise, this value is null. The table name is the name of a table in the client application. This name may or may not have a direct counterpart in the consolidated database, depending upon how your remote table names map to consolidated tables.

SQL scripts for the handle_error event must be implemented as stored procedures.

You can return a value from the handle_error script one of the following ways:

The CustDB sample application contains error handlers for various database-management systems.

• Script parameters
• Adding and deleting scripts
• report_error connection event
• report_odbc_error connection event
• handle_odbc_error connection event
• Remote IDs and MobiLink user names in scripts
• Data scripts

The following example works with a SQL Anywhere consolidated database. It allows your application to ignore redundant inserts.

The following call to a MobiLink system procedure assigns the ULHandleError stored procedure to the handle_error event.

CALL ml_add_connection_script(
    'ver1',
    'handle_error',
    'CALL ULHandleError(
      {ml s.action_code}, 
      {ml s.error_code}, 
      {ml s.error_message}, 
      {ml s.username}, 
      {ml s.table} )' )

The following SQL statement creates the ULHandleError stored procedure.

CREATE PROCEDURE ULHandleError(
   INOUT action integer,
   IN error_code integer,
   IN error_message varchar(1000),
   IN user_name varchar(128),
   IN table_name varchar(128) )
BEGIN
  -- -196 is SQLE_INDEX_NOT_UNIQUE
  -- -194 is SQLE_INVALID_FOREIGN_KEY
  IF error_code = -196 or error_code = -194 then
      -- ignore the error and keep going
      SET action = 1000;
  ELSE
      -- abort the synchronization
      SET action = 3000;
  END IF;
END

The following call to a MobiLink system procedure registers a Java method called handleError as the script for the handle_error connection event when synchronizing the script version ver1.

CALL ml_add_java_connection_script(
    'ver1',
    'handle_error',
    'ExamplePackage.ExampleClass.handleError' )

The following is the sample Java method handleError. It processes an error based on the data that is passed in. It also determines the resulting error code.

package ExamplePackage;
public class ExampleClass
{
    public void handleError( ianywhere.ml.script.InOutInteger	actionCode,
			     int				errorCode,
			     String				errorMessage,
			     String				user,
			     String				table ) 
    {
	// -196 is SQLE_INDEX_NOT_UNIQUE
	// -194 is SQLE_INVALID_FOREIGN_KEY
	if( errorCode == -196 || errorCode == -194 ) {
	    // ignore the error and keep going
	    actionCode.setValue( 1000 );
	} else {
	    // abort the synchronization
	    actionCode.setValue( 3000 );
	}
    }	
}

The following call to a MobiLink system procedure registers a .NET method called HandleError as the script for the handle_error connection event when synchronizing the script version ver1.

CALL ml_add_dnet_connection_script(
  'ver1',
  'handle_error',
  'TestScripts.Test.HandleError' )

The following is the sample .NET method HandleError.

namespace TestScripts
{
    public class Test
    {
	public void HandleError( ref int 	actionCode,
				 int		errorCode,
				 string		errorMessage,
				 string		user,
				 string		table ) 
	{
	    // -196 is SQLE_INDEX_NOT_UNIQUE
	    // -194 is SQLE_INVALID_FOREIGN_KEY
	    if( errorCode == -196 || errorCode == -194 ) {
		// ignore the error and keep going
		actionCode = 1000;
	    } else {
		// abort the synchronization
		actionCode = 3000;
	    }
	}	
    }
}