skills/oracle__skills
1
0
Fork 0
mirror of https://github.com/oracle/skills.git synced 2026-09-19 03:46:55 +08:00
Code Issues Packages Projects Releases Wiki Activity
Files
token-efficiency-optimization
oracle__skills/db/appdev/java-oracle-jdbc.md
T
Mohammed Bekraoui 216b82e3c5 Refactor Java JDBC skills
2026-06-02 14:14:52 +01:00

2.3 KiB
Raw Permalink Blame History

Java Oracle JDBC

Overview

Use these skills when building Java applications that connect to Oracle Database with the Oracle JDBC Thin driver.

Start here when you need to choose the right ojdbc artifact, build a JDBC URL, execute SQL safely, configure UCP pooling, or prepare a Java service for production use with Oracle Database.

JDBC Skill Map

Need Use
Choose ojdbc17, ojdbc11, or UCP artifacts; configure Maven or Gradle JDBC Dependencies
Build JDBC URLs; use Easy Connect, EZConnect+, TNS aliases, wallets, or TLS JDBC Connections
Run queries, DML, batch operations, binds, and PL/SQL calls JDBC SQL and PL/SQL
Configure UCP, Spring Boot datasource settings, security, and production practices JDBC Pooling and Production

Quick Defaults

  • Use ojdbc17 for modern JDK 17+ applications.
  • Keep ojdbc and ucp artifacts on the same version.
  • Use JDBC URLs in the jdbc:oracle:thin:@//host:port/service_name form for Easy Connect.
  • Use PreparedStatement or Oracle named binds for user input.
  • Use UCP or a framework-managed pool for production services.
  • Use wallets or TLS configuration when connecting to Autonomous Database or secured deployments.

Related Skills

Sources

Reference in New Issue View Git Blame Copy Permalink