AnyLogic DB data types

The data in AnyLogic model database can be of different types:

Data type

Description

boolean

Boolean value.

Possible values: true and false.

Is used to map from SQL type: DOUBLE.

int

Integer value. 

Possible values: -2147483648 to 2147483647.

Is used to map from SQL type: INTEGER.

double

A floating point number

Is used to map from SQL type: DOUBLE.

String

Text string.

Is mapped to SQL type: VARCHAR.

Date

The timestamp data type. The format is yyyy-MM-dd hh:mm:ss[.nnnnnnnnn].

Is mapped to SQL type: TIMESTAMP.

Code

Table cells contains Java action, or  Java expression that you may read and use in your model. 

If the cell contains some stochastic expression, and you want to set it as a value of some flowchart block parameter, just select this particular cell in the block properties, and AnyLogic will automatically take the expression from the database, evaluate it, and use the expression result as the parameter value.

Or, if the cell contains Java action, you can execute this action by calling the function execute() for this cell.  

Other

Choosing Other option, you can specify any other SQL data type you need, for example:

  • NUMERIC

Other data types relating to time:

  • DATE - The date data type. The format is yyyy-MM-dd.

  • TIME - The time data type. The format is hh:mm:ss.

Integer data types:

  • BIGINT - Possible values: -9223372036854775808 to 9223372036854775807.
  • TINYINT - Possible values are: -128 to 127.

  • SMALLINT - Possible values: -32768 to 32767.

Floating point data types:

  • REAL - A single precision floating point number. 

Since SQL data types and Java data types are not identical, there needs to be some mechanism for reading and writing data between AnyLogic and a database using SQL types.

JDBC provides a standard mapping from the common SQL data types to Java types. For example, a SQL INTEGER is normally mapped to a Java int. This supports a simple interface for reading and writing SQL values as simple Java types.