Passing an Empty String or Byte into a Required Binary Column in ASE

When defining an MBO from an Adaptive Server Enterprise data source an error message displays if you pass an empty string or empty byte[] into a required binary column in ASE results in an ASE non-nullable column exception.

Create the MBO. For example, drag and drop an ASE data source onto the mobile application diagram.
Create a Create operation named create1.

In the Parameters page of the New operation wizard, click Next and it throws a RuntimeException if performing the described action. For example:

Error executing on back-end server: 
java.lang.RuntimeException: java.lang.RuntimeException: 
com.sybase.jdbc3.jdbc.SybSQLException: The column binary1 
in table pubs3.dbo.AllDataTypes does not allow null values.

Running 'Test Execute' for the Create operation also throws an error:

Execution failed: The column binary1 in table 
pubs3.dbo.AllDataTypes does not allow null values

Solution: use "IA==" as the default value for the binary(1) argument. Create a new Create operation, and select 'Test Execute' to verify it works correctly.

Created February 5, 2013. To comment on this topic, go to: DocCommentXchange.