Java SE example: Inserting rows

Java SE example: Inserting rows

This example demonstrates how to insert rows in an UltraLite Java edition database.

Run the LoadDb.java example

Change to the following directory: %SQLANYSAMP12%\UltraLiteJ\J2SE.
Run the CreateDb example:
rundemo CreateDb
Run the following command (the command is case sensitive):
rundemo LoadDb

Notes

Inserted data is persisted in the database only when the commit method is called from the Connection object.
When a row is inserted, but not yet committed, it is visible to other connections. This introduces the potential for a connection to retrieve row data that has not actually been committed.

See also

Discuss this page in DocCommentXchange.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1