Ballerina OracleDB Library

The OracleDB library is one of the external library packages of the Ballerina language.

This provides the functionality required to access and manipulate data stored in an Oracle database.

For more information on the operations supported by the oracledb:Client, which include the below, go to The oracledb package.

• Pooling connections
• Querying data
• Inserting data
• Updating data
• Deleting data
• Updating data in batches
• Executing stored procedures
• Closing the client

Issues and Projects

Issues and Projects tabs are disabled for this repository as this is part of the Ballerina Standard Library. To report bugs, request new features, start new discussions, view project boards, etc. please visit Ballerina Standard Library parent repository.

This repository only contains the source code for the package.

Building from the Source

Setting Up the Prerequisites

1. Download and install the Java SE Development Kit (JDK) version 11 (from one of the following locations).

   • Oracle
   • OpenJDK

2. Download and install Docker.

3. Export your Github Personal access token with the read package permissions as follows.

    export packageUser=<Username>
    export packagePAT=<Personal access token>
   

Building the Source

Execute the commands below to build from the source.

1. To build the library:

    ./gradlew clean build
   

2. To run the integration tests:

    ./gradlew clean test
   

3. To build the package without tests:

    ./gradlew clean build -x test
   

4. To run only specific tests:

    ./gradlew clean build -Pgroups=<Comma separated groups/test cases>
   

   Tip: The following groups of test cases are available.

   Groups	Test Cases
   connection	connection-init
   pool	pool
   transaction	local-transaction
   execute	execute-basic execute-params
   batch-execute	batch-execute
   query	query-simple-params query-complex-params
   procedures	procedures
   datetime	datetime
   custom-object	custom-object
   custom-varray	custom-varray

5. To disable some specific groups during the test:

    ./gradlew clean build -Pdisable-groups=<Comma separated groups/test cases>
   

6. To debug the tests:

    ./gradlew clean build -Pdebug=<port>
    ./gradlew clean test -Pdebug=<port>
   

7. To debug the package with the Ballerina language:

    ./gradlew clean build -PbalJavaDebug=<port>
    ./gradlew clean test -PbalJavaDebug=<port>
   

8. Publish the ZIP artifact to the local .m2 repository:

    ./gradlew clean build publishToMavenLocal
   

9. Publish the generated artifacts to the local Ballerina central repository:

    ./gradlew clean build -PpublishToLocalCentral=true
   

10. Publish the generated artifacts to the Ballerina central repository:

    ./gradlew clean build -PpublishToCentral=true
    

Contributing to Ballerina

As an open source project, Ballerina welcomes contributions from the community.

For more information, go to the contribution guidelines.

Code of Conduct

All contributors are encouraged to read the Ballerina Code of Conduct.

Useful Links

• Chat live with us via our Slack channel.
• Post all technical questions on Stack Overflow with the #ballerina tag.