web stats
SELECT XMLTYPE from Source - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 06-18-2019, 06:45 AM
fospi fospi is offline
Mirth Newb
 
Join Date: Mar 2014
Posts: 8
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:

SELECT ID, MSG_DATE, SEND, XML_MSG FROM TABLE_NAME

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"
java.lang.NullPointerException
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
  #2  
Old 08-29-2019, 11:57 PM
fospi fospi is offline
Mirth Newb
 
Join Date: Mar 2014
Posts: 8
fospi is on a distinguished road
Default

Anybody knows it ???
Reply With Quote
  #3  
Old 08-30-2019, 09:37 AM
agermano agermano is online now
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 964
agermano is on a distinguished road
Default

According to this: https://oracle-base.com/articles/9i/xmltype-datatype

You can probably do:

Code:
SELECT ID, MSG_DATE, SEND, XML_MSG.getStringValue() FROM TABLE_NAME
Reply With Quote
Reply

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 06:32 PM.


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