inserting records into any database with out using java and/or processor in fuse

[kkrishnashankar]

Hello,

Can we insert records into any database with out using java and/or processor in fuse

Does fuse provide any mechanism other than java and/or processor to persist in database.

Can we achieve with fuse transformation?

Thanks,

Krishna

[davsclaus]

You can use Apache Camel which can insert data into a database. There is a number of different components for that. But one is SQL which has a little example here

http://camel.apache.org/sql-example.html

[kkrishnashankar]

Hello Claus,

Followed Split EIP Pattern using and sql-example for inserting 10400 records in SQL Server test results as follows.

Total Records: - 10400
Test		First Record		Last Record		Time to process (approx.)
						min
XML 1.0		2016-01-06 12:25:47.393		2016-01-06 12:31:03.557		5-6
XML 1.1		2016-01-06 11:42:07.620		2016-01-06 11:47:23.943		5-6
XML 2.0		2016-01-06 12:07:49.593		2016-01-06 12:13:09.187		5-6

Do you have any suggestion to decrease time for inserts large payload (1.8 MB for 10400)

[kkrishnashankar]

Hello Claus,

In addition to previous reply

tried below options.

After enabling the option 'streaming' there is no significant change in processing time.
But after enabling the option 'Parallel processing', the processing time reduced significantly to less than 1 min (30 - 45 seconds).
On the other note parallel processing opening 10 - 20 threads for 1 process/camel context (JBoss Fuse) . Is this recommended for large of number of processes might opening huge of number threads and might cause break thread limit and OOM (out of memory on server)