web stats
Newbie:Not able to connect to oracle database, - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 03-12-2018, 10:24 AM
grp02 grp02 is offline
What's HL7?
 
Join Date: Feb 2018
Posts: 4
grp02 is on a distinguished road
Smile Newbie:Not able to connect to oracle database,

Mirth Connect version 3.5.1.

I'm trying to insert a data from a file into a database, I'm failing to connect database. I have represented the database connection as mentioned in the URL Template and I have also tried using Javascript.


Error shows as below

Could not retrieve database metadata. Please ensure that your driver, URL, username, and password are correct.

Let me know if there is any specific template to connect to oracle 12c
Reply With Quote
  #2  
Old 03-12-2018, 10:46 PM
siddharth siddharth is offline
Mirth Guru
 
Join Date: Feb 2013
Posts: 832
siddharth is on a distinguished road
Default

I think the answer is already in the forum. Please search effectively.
__________________
HL7v2.7 Certified Control Specialist!
Reply With Quote
  #3  
Old 03-13-2018, 06:16 AM
kirbykn2's Avatar
kirbykn2 kirbykn2 is offline
Mirth Guru
 
Join Date: Sep 2014
Location: Michigan
Posts: 577
kirbykn2 is on a distinguished road
Default

I had difficulty with this one. I believe it ended up being the mithdb user had to be the owner of the schema in Oracle.
__________________
Kirby

Mirth Certified|Epic Bridges Certified|Cloverleaf Level 2 Certified

Appliance Version 3.11.2
Mirth Connect Version 3.6.1
Java Version 1.6.0_45-b06
Java (64 bit) Version 1.6.0_45-b06
Java 7 (64 bit) Version 1.7.0_151-b15
Java 8 (64 bit) Version 1.8.0_121-b13
PostgreSQL Version 9.6.3
Reply With Quote
  #4  
Old 03-13-2018, 06:20 AM
kirbykn2's Avatar
kirbykn2 kirbykn2 is offline
Mirth Guru
 
Join Date: Sep 2014
Location: Michigan
Posts: 577
kirbykn2 is on a distinguished road
Default

For more information, here is the thread.

http://www.mirthproject.org/communit...=oracle+schema
__________________
Kirby

Mirth Certified|Epic Bridges Certified|Cloverleaf Level 2 Certified

Appliance Version 3.11.2
Mirth Connect Version 3.6.1
Java Version 1.6.0_45-b06
Java (64 bit) Version 1.6.0_45-b06
Java 7 (64 bit) Version 1.7.0_151-b15
Java 8 (64 bit) Version 1.8.0_121-b13
PostgreSQL Version 9.6.3
Reply With Quote
  #5  
Old 03-13-2018, 06:47 AM
grp02 grp02 is offline
What's HL7?
 
Join Date: Feb 2018
Posts: 4
grp02 is on a distinguished road
Default

It worked for me. I have to use Java script instead of URL Connection template(JavaScript disabled).

So for some reason connection template not working for Oracle driver, I have tired all possible ways but none worked except java script. I'm not sure it can be Bug for oracle driver connection using template.
Reply With Quote
Reply

Tags
database error, database writer, mirth 3.5.1, oracle database

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 07:00 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation