## Get JDBC Connection Information dialog

This dialog appears when you right-click the Relational node and select Add JDBC Connection from the shortcut menu in the Catalog Browser, or select JDBC and then click OK in the New Data Source dialog. It is used to get or create JDBC connection information. It lists the database objects which are accessible through JDBC or JDBC-ODBC Bridge. See the dialog.

The following are details about options in the dialog:

Connection List

Contains the previously added connection information. The format of the connection information is:

JDBC URL/(JDBC Driver Name)

For example:

`jdbc:odbc:jinfonet/(sun.jdbc.odbc.JdbcOdbcDriver)`

Choose one of the connection information from the Connection List to display the JDBC URL and JDBC Driver name in the corresponding text box.

Use ODBC Data Source

By default, this checkbox is checked. It indicates that an ODBC Data Source will be used.

- DSN Name
  Specifies the name in the field for the ODBC data source.

Use Connection Pool

Specifies to connect the database through a WebLogic connection pool.

- JDBC URL
  Specifies the valid JDBC URL which can establish a connection to the database that is to be used. The valid format of the URL should be provided by your JDBC Driver.

JDBC Driver

Enabled when Use ODBC Data Source and Use Connection Pool are both unchecked. Here you should input the JDBC driver class name that this connection will use. Otherwise, JReport will try all JDBC drivers specified in `%installroot%/bin/jdbcdrivers.properties` file for the JDBC URL given to you when it tries to setup a database connection. That is to say, JDBC driver's names also can be added into that text file.

User Name

Specifies the user ID used for accessing the database through the ODBC data source.

Password

Specifies the password used for accessing the database through the ODBC data source.

OK

Accepts all changes and closes the dialog.

Cancel

Does not retain any changes and closes the dialog.

Help

Displays this help document.

### Options

These options are designed for experienced users, and when your database has some special requirements.

Qualified tab

- Qualified
  Specifies whether a catalog or a schema is used when JReport sends an SQL statement to the database.
  - Unqualified Name
    Neither catalog nor schema will be included in data manipulation.
  - 2-Part Names
    Schema will be used in data manipulation.
  - 3-Part Names
    Will use both catalog and schema in data manipulation.

  This is very useful when the database contains tables with the same names in different catalogs and/or schemas. If you only use an unqualified name, the SQL statement generated by JReport will not contain the catalog and schema name, and therefore the result will be unpredictable.

- Quote Qualifier
  Specifies the characters, and then the qualifier name which contains the characters that will not be quoted.

  In JReport, you need quote with the character defined by the DBMS. The default character is double quotation marks (" "). Two properties exist for the Quote Qualifier.

  - Default (JDBC)
    If selected, the program will get the extra name characters from JDBC.
  - User Defined
    If selected, you can modify the quote character according to the database system being used.
    - Extra Characters
      Specifies the extra characters for identifier names.
    - Quote Character
      Specifies the quote character.
- Modify Qualifier
  Edits the current qualifier.
  - Qualifier
    Lists all the qualifiers available. You can change the current qualifier by selecting one from the drop-down list. The default value is the first one in the list. If the database do not support qualifier, there will be no drop-down list, and you cannot input the qualifier name.
  - Apply to
    - Tables
      If checked, the modified qualifier will be applied to all tables in the connection.
    - Views
      If checked, the modified qualifier will be applied to all views in the connection.
    - Imported SQLs
      If checked, the modified qualifier will be applied to all imported SQLs in the connection
    - Stored Procedures
      If checked, the modified qualifier will be applied to all stored procedures in the connection.

  Note: All the changes you made in the Modify Qualifier panel will not be recorded in the Get JDBC Connection Information dialog. That is to say, if you change any value in the panel and apply it, when you open the dialog next time, it will keep to the original.

Restore Default

Restores values in the tab to defaults.

Apply

Accept the changes.

Date Format tab

Different database systems use different Date and Time formats for Date and Time values. The Date Format tab is for specifying the format, so that when JReport sends the SQL statement with Date or Time parameters, they can be correctly translated into the format of your database system.

For example, in an Oracle database, by default, the Date format is 'dd-MMM-yy'. However, in a Sybase database system, the Date format is 'yyyy-MM-dd'. Thus, the Date format in the connection object is required to be modified accordingly, in order for the JReport generated SQL statements to function correctly with the database.

- Date
  Specifies the date format.
- Time
  Specifies the time format.
- Timestamp
  Specifies the timestamp format.

  Symbol | Meaning | Presentation
  --- | --- | ---
  y | year | number
  M | month in year | number
  d | day in month | number
  h | hour in day (0~23) | number
  m | minute in hour | number
  s | second in minute | number
  S | millisecond | number

Transaction tab

- Read Only
  - Default
    Accepts the settings from the database that you are connecting to.
  - Read Only
    Users will only be able to access the database in read-only mode.
  - Read Write
    Users will be able to access the database in read-write mode.
- Transaction Isolation
  - Default
    Accepts the settings from the database that you are connecting to.
  - None
    Transactions are not supported.
  - Read Uncommitted
    Transactions are not isolated from each other. If the DBMS supports other transaction isolation levels, it ignores whatever mechanism it uses to implement those levels. So that they do not adversely affect other transactions, transactions running at the Read Uncommitted level are usually read-only.

    Note: When Read Only is set and Transaction Isolation to be Read Uncommitted, it provides faster access to the data but if a database transaction is rolled back the read will retrieve an invalid row and result in an inaccurate report.

  - Read committed
    When one transaction is reading, updating or deleting a row, other transactions cannot update or delete it until this transaction has been committed or rolled back.
  - Repeatable read
    When one transaction is updating, deleting several rows or inserting new rows into them, the other transactions cannot also update or delete these rows, until this transaction has been committed or rolled back.
  - Serializable
    When one transaction is updating, deleting several rows or inserting new rows into them, the other transactions cannot update, delete these rows, or insert any new rows into these rows, until this transaction has been committed or rolled back.

Pre-join tab

Specifies whether or not to enable the Pre-join feature when building a query or defining join relationships in business cubes.

Schema tab

- Schema
  Enables you to choose the schemas you want and makes JReport show the chosen schemas in the Add Table dialog and Add View dialog.
  - Schema List
    Lists the schemas for you to choose.
  - Included Schemas
    Shows the selected schemas.
  - Load All Schema
    Enables JReport Designer to show all the schemas in the database.
  - Adds the selected schema to the Included Schemas list.
  - Removes the selected schema from the Included Schemas list.
- Modify Owner
  Edits the current schema.
  - Schema List
    Lists all the schemas available.
  - Apply to
    - Tables
      If checked, the modified schema will be applied to all tables in the connection.
    - Views
      If checked, the modified schema will be applied to all views in the connection.
    - Stored Procedures
      If checked, the modified schema will be applied to all stored procedures in the connection.

  Note: All the changes you made in the Modify Owner panel will not be recorded in the Get JDBC Connection Information dialog. That is to say, if you change any value in the panel and apply it, when you open the dialog next time, it will keep to the original.

Restore Default

Restores values in the tab to defaults.

Apply

Accept the changes.

###### Related topics:

- Setting up a JDBC connection