PL/SQL Connector Builder Maven Plugin

Installation

• The PL/SQL Connector Builder is not available from Maven Central any more.
• Download the plugin from the download section and deploy the plugin to your Maven Repository.

Configure pom.xml (Minimum Configuration)

XML-File : pom.xml

<build>
  <plugins>
    ...
    <plugins>
      <plugin>
        <groupId>com.jr-database-tools.dbworkbench</groupId>
        <artifactId>connectorbuilder-maven-plugin</artifactId>
        <configuration>
          <connector_builder_filename>batch_stream_processor_factoryapi_11.batch_bldr</connector_builder_filename>
        </configuration>
        <executions>
          <execution>
            <phase>generate-sources</phase>
            <goals>
              <goal>run</goal>
            </goals>
          </execution>
        </executions>
      </plugin>
    </plugins>
    ...
  </plugins>
</build>

Required Parameter

• connector_builder_filename: Only the filename is required. All other parameters are read from the Connector Builder configuration.

Configure pom.xml (Full Configuration)

XML-File : pom.xml

<build>
  <plugins>
    ...
    <plugin>
      <groupId>de.jrdatabasetools.dbworkbench</groupId>
      <artifactId>connectorbuilder-maven-plugin</artifactId>
      <version>26.1.1</version>
      <configuration>
        <connectorBuilderName>rmi</connectorBuilderName>
        <url>${db.url}</url>
        <user>${db.username}</user>
        <password>${db.password}</password>
        <info>warning</info>
        <build_target>client</build_target>
        <connection_login_timeout>10</connection_login_timeout>
        <connection_pool_max_size>8</connection_pool_max_size>
        <connection_pool_validate_on_borrow>true</connection_pool_validate_on_borrow>
        <connection_pool_validate_wait_timeout>20000</connection_pool_validate_wait_timeout>
        <connection_pool_borrow_timeout>60000</connection_pool_borrow_timeout>
      </configuration>
      <executions>
        <execution>
          <phase>generate-sources</phase>
          <goals>
            <goal>run</goal>
          </goals>
        </execution>
      </executions>
    </plugin>
    ...
  </plugins>
</build>

Optional Parameters (Override Builder Configuration)

• url, user, password: Override the connection settings defined in the Connector Builder configuration (optional).

Parameter 'build_target' (Maven-Specific)

• build_target: single, client, server, all
  • This is the only Maven-specific parameter.
  • RawJdbc, JavaRPC, Batch-Stream: For single-build runs, build_target is optional and defaults to single.
  • Spring-Remoting, Java EE, RMI, ...: For client/server generation, set build_target to client or server to indicate which side to generate.

Optional Parameters (Defaults)

• info: Controls the verbosity of the Connector Builder output. Valid values: all, compact, warning (default: all).
• connection_login_timeout: Time to wait for a database connection, in seconds (default: 10).
• connection_pool_max_size: Maximum number of connections in the pool (default: 8).
• connection_pool_borrow_timeout: Maximum time to acquire a pooled connection, in milliseconds (default: 60000).
• connection_pool_validate_on_borrow: Validate a connection when it is borrowed from the pool (default: false).
• connection_pool_validate_wait_timeout: Timeout for connection validation, in seconds (default: 5).

Run from the Command Line

• mvn connectorbuilder:run