Writing time series data types to the database

Procedure

To load time series data, calendars, or into the database, run the PreparedStatement.setObject() method with the appropriate time series object.

Examples

In this example, pStmt is a valid PreparedStatement object, ts is a valid IfmxTimeSeries object, and the TimeSeries type is the first argument in the prepared statement.

pStmt.setObject(1, ts);
Similarly, the following example writes a Calendar object to the database:
pStmt.setObject(1, c);

In this example, pStmt is a valid PreparedStatement object, c is a valid IfmxCalendar object, and the Calendar type is the first argument in the prepared statement.

And, the following example writes a CalendarPattern object to the database:
pStmt.setObject(1, cp);

Where pStmt is a valid PreparedStatement object, cp is a valid IfmxCalendarPattern object, and the CalendarPattern type is the first argument in the prepared statement.