Versions Compared

Old Version 14

changes.mady.by.user Former user

Saved on

compared with

New Version 15

changes.mady.by.user Chee Hove Teng

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Database TypeProperties
CSVAll properties described on the page http://csvjdbc.sourceforge.net/doc.html in the section section "Driver Properties" can be used.
MySQLmysql.connectionpool.maxlimit
Oracleoracle.pool.connectionwaittimeout
oracle.pool.inactivitytimeout
oracle.pool.maxlimit
oracle.pool.minlimit
oracle.pool.propertycheckinterval
oracle.pool.refreshonsqlerror
oracle.net.encryption_client
oracle.net.encryption_types_client
oracle.net.crypto_checksum_client
oracle.net.crypto_checksum_types_client
PostgreSQL

postgresql.connectionpool.maxlimit

escapeSyntaxCallMode=select / call / callIfNoReturn

Note
titlePostgreSQL >= 11

PostgreSQL 11 started to support stored PROCEDURE, previous versions of PostgreSQL only supported stored FUNCTION. Hence, a new connection property called "escapeSyntaxCallMode" has been introduced by PostgreSQL for users to configure. This property specifies how the driver transforms JDBC escape call syntax into underlying SQL, for invoking procedures or functions.

  • In escapeSyntaxCallMode=select mode , the driver always uses a SELECT statement (allowing function invocation only).

  • In escapeSyntaxCallMode=callIfNoReturn (the default) mode, the driver uses a CALL statement (allowing procedure invocation) if there is no return parameter specified, otherwise the driver uses a SELECT statement.

  • In escapeSyntaxCallMode=call mode, the driver always uses a CALL statement (allowing procedure invocation only)

In case you are using Callable Statements with PostgreSQL, you can configure the “escapeSyntaxCallMode” connection property in the Database Profile. However, If this property is not configured in the Database Profile, it will be set to escapeSyntaxCallMode=callIfNoReturn in the code as the default value.


SAP HANAsapdb.connectionpool.maxlimit

...