When you drag a connection from the Connections panel and drop it into a Java file, the feature will automatically generate the necessary code for you. It supports all connection types including Basic, Custom JDBC, Cloud Wallet, and TNS ensuring flexibility for a wide range of Oracle database scenarios.

1. Open a SQL worksheet and set the language to Java, or open an existing Java file.
2. In the Connections panel, locate the desired database connection.
3. Drag the selected connection and drop it into your open Java file.

   A dialog box will appear prompting you to choose a code generation option.

4. Select any of the following code generation options:
   • Connection String: Generates the connection string for the dropped connection(s).
   • JDBC: Generates Java code that enables the user to connect to the dropped connection(s).
   The generated code (connection string or full JDBC API code) will automatically appear in your Java file.

   You can drag and drop multiple connections to automatically generate code for them at once.

The following examples illustrate a specific connection type configuration and the corresponding auto-generated JDBC code and the connection string after using the drag-and-drop feature. Here is a custom JDBC connection type without any advanced properties specified.

Description of the illustration code_generation_connection.png

For a selected connection type, such as Custom JDBC, if the code generation option is set to JDBC, the corresponding JDBC connection code is automatically generated. This code includes all the relevant details specified in the connection configuration, streamlining the process of connecting to the database.

Description of the illustration code_generation_output.png

If the code generation option selected is Connection String, only the connection string is displayed.

Description of the illustration code_generation_output_connectionstring.png