URL string format for connecting to Oracle database with JDBC

by

There are two ways to set this up. If you have an SID, use this (older) format:

jdbc:oracle:thin:@[HOST][:PORT]:SID

If you have an Oracle service name, use this (newer) format:

jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE

Source: this OraFAQ page

The call to getConnection() is correct.

Also, as duffymo said, make sure the actual driver code is present by including ojdbc6.jar in the classpath, where the number corresponds to the Java version you’re using.

More Related Contents:

  1. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  2. No more data to read from socket error
  3. Oracle JDBC ojdbc6 Jar as a Maven Dependency
  4. ORA-01882: timezone region not found
  5. Fetch Oracle table type from stored procedure using JDBC
  6. TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
  7. Oracle JDBC and Oracle CHAR data type
  8. Difference between VARCHAR2(10 CHAR) and NVARCHAR2(10)
  9. Default Schema in Oracle Connection URL
  10. NLS_LANG setting for JDBC thin driver?
  11. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  12. How to change default nls_date_format for oracle jdbc client
  13. Is java.sql.Timestamp timezone specific?
  14. How to connect to Oracle using Service Name instead of SID
  15. Get counts of all tables in a schema
  16. Determining location of relevant tnsnames.ora file
  17. Default row ordering for select query in oracle
  18. Oracle trigger after insert or delete
  19. Difference between a user and a schema in Oracle?
  20. Base64 encoding and decoding in oracle
  21. How to avoid variable substitution in Oracle SQL Developer
  22. Recursion In Oracle
  23. Oracle’s default date format is YYYY-MM-DD, WHY?
  24. PL/SQL print out ref cursor returned by a stored procedure
  25. how to replace multiple strings together in Oracle
  26. Dynamically pivoting a table Oracle
  27. Oracle: how to INSERT if a row doesn’t exist
  28. Valid Date Checks in Oracle
  29. How to get the week day name from a date?
  30. DBMS_JOB vs DBMS_SCHEDULER

Leave a Comment