web stats
SELECT XMLTYPE from Source - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Thread Tools Display Modes
Old 06-18-2019, 06:45 AM
fospi fospi is offline
Mirth Newb
Join Date: Mar 2014
Posts: 7
fospi is on a distinguished road
Default SELECT XMLTYPE from Source

Hi, I'm using Mirth Connect 3.0 version.

I have a problem with a Database reader:

I'm trying to read from ORACLE this select:


Where XML_MSG is a XMLTYPE based in CLOB. And I need to read ths XML from it.

If I tried to do this select from Oracle it works perfectly, however from MIRTH i have this error:

[2019-06-18 16:44:30,085] ERROR (com.mirth.connect.connectors.jdbc.DatabaseReceive r:131): Failed to poll for messages from the database in channel "Messages - SAP ECOFIN"
at oracle.jdbc.driver.NamedTypeAccessor.getOracleObje ct(NamedTypeAccessor.java:302)
at oracle.jdbc.driver.NamedTypeAccessor.getObject(Nam edTypeAccessor.java:164)
at oracle.jdbc.driver.NamedTypeAccessor.getObject(Nam edTypeAccessor.java:121)
at oracle.jdbc.driver.OracleResultSetImpl.getObject(O racleResultSetImpl.java:1108)
at com.sun.rowset.CachedRowSetImpl.populate(Unknown Source)
at com.mirth.connect.connectors.jdbc.DatabaseReceiver Query.poll(DatabaseReceiverQuery.java:166)
at com.mirth.connect.connectors.jdbc.DatabaseReceiver .poll(DatabaseReceiver.java:111)
at com.mirth.connect.donkey.server.channel.PollConnec tor$PollConnectorTask.run(PollConnector.java:141)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)

Seems the problem is charging the xml type but i don't understand how to do it.

Anybody knows why????

Thanks in advance.
Reply With Quote

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 03:51 AM.

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