How to connect to oracle database with joget

 
1
0
-1

I have followed the instructions in Configure for Oracle 12c, 11g, 10g but when I try to initialize a database connection I get

"Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor."

I have validated connection using an Oracle interface. 

app_datasource-default.properties file  contains the following:

workflowDriver=com.oracle.jdbc.Driver

workflow url: jdbc:oracle:thin:@hostname:port/servicename

workflowUser=jwdb

workflowpassword=jwdbpw

 

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, I had following datasource config in my test server.

      #
#Mon Mar 27 13:31:12 MYT 2017
workflowUrl=jdbc\:oracle\:thin\:@192.168.99.100\:1521\:xe
workflowDriver=oracle.jdbc.driver.OracleDriver
workflowUser=system
workflowPassword=oracle
        CommentAdd your comment...