Oracle Database connection no results #6052
Unanswered
parkinsonr
asked this question in
Q&A
Replies: 2 comments 1 reply
-
You have a duplicated |
Beta Was this translation helpful? Give feedback.
1 reply
-
The issue can be resolved by setting the value of TRANSPORT_CONNECT_TIMEOUT to milliseconds instead of seconds. That is instead of Example: jdbc:oracle:thin:@(DESCRIPTION = (CONNECT_TIMEOUT = 5) (TRANSPORT_CONNECT_TIMEOUT = 3000) (RETRY_COUNT = 3) (RETRY_COUNT=20)(FAILOVER=ON) (ADDRESS_LIST =(ADDRESS=(PROTOCOL=tcp) (HOST=<HOSTNAME)(PORT=)) (CONNECT_DATA=(SERVICE_NAME=))) |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I'm attempting to connect to an oracle database and execute a select query. I believe I have it all configured correctly using the proper TNS info. Once deployed I can see the channel status 'Polling' for a couple minutes then 'Reading' for a few more minutes in which I would expect to see results, however it then goes back to 'Idle' status with no results. No errors showing in the server log either.
Running Mirth version 4.4.1.
Oracle version is 19.3.0.0.0
In the Oracle logs we're seeing the following error:
2024-01-05T15:59:05.375642-05:00
05-JAN-2024 15:59:05 * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.x)(PORT=55560)) * * 12537
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 115: Operation now in progress
Here's the connection Info I have setup on the channel using javascript
`var dbConn;
try {
dbConn = DatabaseConnectionFactory.createDatabaseConnection('oracle.jdbc.driver.OracleDriver','jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.60.9.39)(PORT = 30002)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.60.9.39)(PORT = 30002))) (CONNECT_DATA = (SID = ONCOREP) (SERVER = DEDICATED)))','username','pass');
result = dbConn.executeCachedQuery("SELECT * FROM oncore.sv_pcl_status")
return result;
} finally {
if (dbConn) {
dbConn.close();
}
}`
Beta Was this translation helpful? Give feedback.
All reactions