ConnectionOptions

Description:

[ CCode ( cprefix = "GDA_CONNECTION_OPTIONS_" , has_type_id = false ) ]
[ Flags ]
public enum ConnectionOptions

Specifies some aspects of a connection when opening it.

Additional information about the GDA_CONNECTION_OPTIONS_SQL_IDENTIFIERS_CASE_SENSITIVE flag: <itemizedlist> <listitem><para> For example without this flag, if the table name specified in a ServerOperation to create a table is <emphasis>MyTable</emphasis>, then usually the database will create a table named <emphasis> mytable</emphasis>, whereas with this flag, the table will be created as <emphasis>MyTable</emphasis> (note that in the end the database may still decide to name the table <emphasis>mytable</emphasis> or differently if it can't do otherwise).</para ></listitem> <listitem><para>Libgda will not apply this rule when parsing SQL code, the SQL code being parsed has to be conform to the database it will be used with</para></listitem> </itemizedlist>

Note about the GDA_CONNECTION_OPTIONS_AUTO_META_DATA flag: <itemizedlist> <listitem><para>Every time a DDL statement is successfully executed, the associated meta data, if defined, will be updated, which has a impact on performances</para>< /listitem> <listitem><para>If a transaction is started and some DDL statements are executed and the transaction is not rolled back or committed, then the meta data may end up being wrong</para></listitem> </itemizedlist>


Namespace: Gda
Package: libgda-6.0

Content:

Enum values:

  • AUTO_META_DATA - this flags specifies that if a MetaStore has been associated to the connection, then it is kept up to date with the evolutions in the database's structure.
  • NONE - no specific aspect
  • READ_ONLY - this flag specifies that the connection to open should be in a read-only mode (this policy is not correctly enforced at the moment)
  • SQL_IDENTIFIERS_CASE_SENSITIVE - this flag specifies that SQL identifiers submitted as input to Libgda have to keep their case sensitivity.