0

I am using oracle database with hikaricp. I want to set database schema through hikaricp. using ojdbc14-10.0.4 dependecy java8

Can anyone tel me,how to set schema using hikaricp.

Thanks in advance.

MT0
  • 143,790
  • 11
  • 59
  • 117
sree
  • 21
  • 2
  • 3
  • I am getting error when i am using setschema() method. – sree Nov 22 '18 at 06:20
  • error:Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.AbstractMethodError: oracle.jdbc.driver.T4CConnection.setSchema(Ljava/lang/String;)V – sree Nov 22 '18 at 06:23
  • Possible duplicate of [Configure OracleDataSource programmatically in Spring Boot with a default schema](https://stackoverflow.com/questions/51310582/configure-oracledatasource-programmatically-in-spring-boot-with-a-default-schema) – Ori Marko Nov 22 '18 at 06:24
  • Can't you use an "init SQL" that runs `alter session set current_schema = ...`? Do you understand that the default schema in Oracle is defined by the user you use to connect? Usually you would just use the user's schema in Oracle –  Nov 22 '18 at 06:49
  • 2
    Are you really still using Java **1.4**? –  Nov 22 '18 at 06:50

0 Answers0