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 >