Data scripts

Scripts that directly handle row data are called data scripts. All other scripts are non-data scripts. The distinction between a data script and a non-data script is sometimes important. For example, only data scripts can reference the named parameters for column values.

The following events have data scripts associated with them:

Java and .NET data scripts returning SQL (removed)

Starting in version 16, the ability for Java and .NET scripting logic to return strings that are interpreted by MobiLink server as SQL scripts has been removed in all scripts. If your scripts need to cause changes in the consolidated database, they should do so directly from Java or .NET.

Following is an example of how a script can be updated. The first example uses SQL and the second example does not.

public String beginDownloadConnection(
  Timestamp ts, 
  String user )
  throws java.sql.SQLException 
{  
    doSomeWork( ts, user );
    return( "CALL do_some_sql( {ml s.last_download}, {ml s.username} )" );
}

public void beginDownloadConnection(
  Timestamp ts, 
  String user )
  throws java.sql.SQLException 
{  
    doSomeWork( ts, user );
    
    Connection conn = DBConnectionContext.getConnection();
    PreparedStatement stmt = conn.prepareStatement( "CALL do_some_sql( ?,? )" );
    stmt.setTimestamp( 1, ts );
    stmt.setString( 2, user );
    stmt.executeUpdate();
}

Discuter à propos de cette page dans DocCommentXchange.