UltraLite for M-Business Anywhere User's Guide
Understanding UltraLite for M-Business Anywhere Development
UltraLite applications must connect to a database before carrying out operations on the data in it. This section describes how to connect to an UltraLite database.
The following properties of the Connection object govern global application behavior.
For more information about the Connection object, see Class Connection.
Commit behavior By default, UltraLite applications are in AutoCommit mode. Each insert, update, or delete statement is committed to the database immediately. Set Connection.autoCommit to false to build transactions into your application. Turning autoCommit off and performing commits directly can improve the performance of your application.
For more information, see Method commit.
User authentication You can change the user ID and password for the application from the default values of DBA and SQL by using the grantConnectTo and revokeConnectFrom methods.
For more information, see Authenticating users.
Synchronization A set of objects governing synchronization are accessed from the Connection object.
For more information, see Synchronizing data.
Tables UltraLite tables are accessed using the Connection.getTable method.
For more information, see Method getTable.
You can connect to a database using either a ConnectionParms object or a connection string. Methods that use a ConnectionParms object allow you to manipulate connection parameters with ease and accuracy. Methods that use a connection string require that you successfully create a connection string.
Using ConnectionParms to connect to a database
SQL Anywhere Studio 9.0.2
版权所有 © 1989–2005 Sybase, Inc. 部分版权所有 © 2001–2005 iAnywhere Solutions, Inc. 保留所有权利。