Thank you for the response and information. I believe I tried what is
recommended in the link that you provided. Below is a copy from the Logs via
the Karaf console. I hope the formatting is not too terrible. I can try and
provide it another way if necessary.
Pretty much the same result as I was seeing before as I believe I already
tried this approach. Here is the document that I used: /{ "time" : { "$date"
: "2016-02-19T17:37:57.673+0000" } }/
Here is what is going on in the route (the reason for the tracing is that I
wanted to see what type the body was being converted to and from...I was
toying around with different conversions to see if I could come up with some
magic incantation that would work):
/ <convertBodyTo type="String" />
<log message="[TRACE] Before unmarshall - ${body}"/>
<unmarshal ref="jsonMarshaller" />
<log message="[TRACE] After unmarshall - ${body}"/>
<to
uri="mongodb:mongoBean?database=PMA&collection=Elmah&writeResultAsHeader=true&operation=insert"
/>/
And the jsonMarshaller dataformat definition is this:
/ <dataFormats>
<json id="jsonMarshaller" library="Jackson"
disableFeatures="FAIL_ON_UNKNOWN_PROPERTIES,WRITE_DATES_AS_TIMESTAMPS"/>
</dataFormats>
/
And the Mongo bean definition:
/ <bean id="mongoBean" class="com.mongodb.Mongo">
<constructor-arg index="0">
<bean class="com.mongodb.MongoURI">
<constructor-arg index="0"
value="mongodb://DEVVLMONGORPLLOGS00.oecapplications.dev:27018/?replicaSet=rsLOGS&connectTimeoutMS=30000&wtimeoutMS=30000&w=1&journal=true"
/>
</bean>
</constructor-arg>
</bean>/
Hope this information is helpful. I certainly appreciate someone looking
into this. We are not Java developers here, but at the moment it feels like
my next course of action is to write some Java code to customize the
serializer.
*From the Logs available via the Karaf Console:*
*3/4/2016, 4:29:33 PM WARN* /Execution of JMS message listener failed.
Caused by: [org.apache.camel.RuntimeCamelException -
org.apache.camel.component.mongodb.CamelMongoDbException: MongoDB operation
= insert, Body is not conversible to type DBObject nor List<DBObject>]
camel-core org.apache.camel.RuntimeCamelException:
org.apache.camel.component.mongodb.CamelMongoDbException: MongoDB operation
= insert, Body is not conversible to type DBObject nor List<DBObject>/
*3/4/2016, 4:29:33 PM ERROR* /Failed delivery for (MessageId:
ID:devvlapifuse01-42307-1456773862280-9:8:3:1:1 on ExchangeId:
ID-devvlapifuse01-49834-1456773865165-1-9). Exhausted after delivery
attempt: 1 caught: org.apache.camel.component.mongodb.CamelMongoDbException:
MongoDB operation = insert, Body is not conversible to type DBObject nor
List<DBObject> Message History
---------------------------------------------------------------------------------------------------------------------------------------
RouteId ProcessorId Processor Elapsed (ms) [oec.common.logger.]
[oec.common.logger.] [activemq://queue:oec.common.logger.elmah.request ] [
2] [oec.common.logger.] [validate4 ]
[validate[simple{${in.header.MongoDatabase}}] ] [ 0] [oec.common.logger.]
[validate5 ] [validate[simple{${in.header.MongoCollection}}] ] [ 0]
[oec.common.logger.] [log2 ] [log ] [ 0] [oec.common.logger.]
[convertBodyTo1 ] [convertBodyTo[String] ] [ 0] [oec.common.logger.] [log3 ]
[log ] [ 1] [oec.common.logger.] [log4 ] [log ] [ 0] [oec.common.logger.]
[to1 ]
[mongodb:mongoBean?database=PMA&collection=Elmah&writeResultAsHeader=true&opera]
[ 1] Exchange
---------------------------------------------------------------------------------------------------------------------------------------
Exchange[ Id ID-devvlapifuse01-49834-1456773865165-1-9 ExchangePattern
InOnly Headers {Accept=*/*, Accept-Encoding=gzip, deflate,
Accept-Language=en-US,en;q=0.8, AppKey=NfQFDRu7Ogq4xF4hZpMGV0CxdgQCnDPW,
breadcrumbId=ID-devvlapifuse01-49834-1456773865165-1-8,
CamelRedelivered=false, CamelRedeliveryCounter=0,
CamelServletContextPath=/private/common/logger/elmah, Content-Length=59,
Content-Type=application/json, JMSCorrelationID=null,
JMSCorrelationIDAsBytes=null, JMSDeliveryMode=2,
JMSDestination=queue://oec.common.logger.elmah.request, JMSExpiration=0,
JMSMessageID=ID:devvlapifuse01-42307-1456773862280-9:8:3:1:1, JMSPriority=4,
JMSRedelivered=false, JMSReplyTo=null, JMSTimestamp=1457126973022,
JMSType=null, JMSXGroupID=null, JMSXUserID=null, MongoCollection=Elmah,
MongoDatabase=PMA,
Origin=chrome-extension://fhbjgbiflinjbdggehcddcbncdddomop,
Postman-Token=fc4ab341-5fbb-fb41-d0ad-c30cc7c3c30a, TestType=2} BodyType
String Body { "time" : { "$date" : "2016-02-19T17:37:57.673+0000" } }
] Stacktrace
---------------------------------------------------------------------------------------------------------------------------------------
camel-core org.apache.camel.component.mongodb.CamelMongoDbException:
MongoDB
operation = insert, Body is not conversible to type DBObject nor
List<DBObject>/
*3/4/2016, 4:29:33 PM WARN* /Conversion has fallen back to generic Object ->
DBObject, but unable to convert type org.apache.camel.impl.DefaultMessage.
Returning null. camel-mongodb/
*3/4/2016, 4:29:33 PM INFO* /[TRACE] After unmarshall - { "time" : { "$date"
: "2016-02-19T17:37:57.673+0000" } }
camel-core /
*3/4/2016, 4:29:33 PM INFO* /[TRACE] Before unmarshall - { "time" : {
"$date" : "2016-02-19T17:37:57.673+0000" } }
camel-core /
--
View this message in context:
http://camel.465427.n5.nabble.com/How-to-insert-Date-String-as-date-in-MongoDB-tp5778310p5778652.html
Sent from the Camel - Users mailing list archive at Nabble.com.
