user |
The database user |
password |
The user's password |
sqlmode |
One of the supported sql modes [INTERNAL | ORACLE] (default is INTERNAL) |
cache limit |
The cache limit of the session |
timeout |
The command timeout in seconds |
isolation |
The isolation level can be specified either as a string (TRANSACTION_READ_UNCOMMITTED, TRANSACTION_READ_COMMITTED,
TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE) or as the equivalent integer value
(as declared in java.sql.Connection). |
autocommit |
off disables autocommit mode |
reconnect |
off disables implicit reconnection after connection timeout |
trace |
The argument is used as a file name. All trace output is written to this file. |
tracesize |
The argument is used as the maximum number of lines in the trace file. The trace is written cyclically. |
transport |
=socket |
Uses 100 percent pure Java on sockets |
|
=native |
Uses the SAP DB runtime (faster for local communication) |
|
If sapdbcbin.dll/libsapdbcbin.so was loaded, the default is =native,
otherwise the default is =socket. |
|
cache |
PreparedStatements are cached within the JDBC-driver for re-use. This probably improves the performance of
your application.
=all |
All types of SQL statements are cached |
=[s][i][u][d] |
s |
SELECT statements are cached |
|
i |
INSERT statements are cached |
|
u |
UPDATE statements are cached |
|
d |
DELETE statements are cached |
Example: If you define cache=siu, all SELECT-, INSERT-, and UPDATE statements are cached.
Default is a disabled caching.
|
unicode |
=yes |
Uses Unicode encoding for SQL statements, user name and password |
|
