Question & Answer > View Question

How to connect to oracle database with joget

Confluence User - 29 Jun, 2018

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

database;setup

1

Confluence User •

29 Jun, 2018 •

confluenceUser •

•

confluenceUser •

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

1

CSV | Excel | XML | PDF

Your answer

Print

How to connect to oracle database with joget

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-29d48455-632d-45e4-a7fd-1e5b248a9be4{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-5f87e969-d6fc-40fc-82c4-a15a7fe86e46{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer