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 the 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 (deprecated)

Starting in version 12, the ability for Java and .NET scripting logic to return strings that are interpreted by MobiLink server as SQL scripts is deprecated in data 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 could 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();
    PreparedStatment stmt = conn.prepareStatement( "CALL do_some_sql( ?,? )" );
    stmt.setTimestamp( 1, ts );
    stmt.setString( 2, user );
    stmt.executeUpdate();
}

Discuss this page in DocCommentXchange.