Re: Query on Camel JDBC Adapter use

> I am planning to use Camel JDBC adapter to connect SAP-HANA with > Snowflake database. SAP vendor has recommended to use this adapter and > hence we want to check if it works. I have the below queries about this > adapter > > What all Apache softwares are required to make Camel JD

Query on Camel JDBC Adapter use

Hi Camel Team, I am planning to use Camel JDBC adapter to connect SAP-HANA with Snowflake database. SAP vendor has recommended to use this adapter and hence we want to check if it works. I have the below queries about this adapter What all Apache softwares are required to make Camel JDBC

Query on Camel JDBC Adapter for Snowflake database access

Hi Camel Team, I am planning to use Camel JDBC adapter to connect SAP-HANA with Snowflake database. SAP vendor has recommended to use this adapter and hence we want to check if it works. I have the below queries about this adapter What all Apache softwares are required to make Camel JDBC

Re: Camel JDBC or SQL component vs SpringJDBCTemplate

t 10:56 PM WEIQUAN YUAN wrote: > Just wondering what is the implementation behind the camel jdbc or sql > component, how is the performance compared to springJDBCTemplate? > > Thanks > -- > ~ > Weiquan Yuan > Located in Ottawa, Canada >

Camel JDBC or SQL component vs SpringJDBCTemplate

Just wondering what is the implementation behind the camel jdbc or sql component, how is the performance compared to springJDBCTemplate? Thanks -- ~ Weiquan Yuan Located in Ottawa, Canada

Re: Camel Jdbc // Error while connecting to HIVE

Hi Try set resetAutoCommit=false On Wed, Apr 29, 2020 at 5:05 PM Reji Mathews wrote: > > Hello community > > I am using camel jdbc component to query some data from HIVE database. When I > trigger a query, it throws me off with following stack trace. Has any > attempted

Camel Jdbc // Error while connecting to HIVE

Hello community I am using camel jdbc component to query some data from HIVE database. When I trigger a query, it throws me off with following stack trace. Has any attempted connecting to HIVE database using camel jdbc component? Or, is there a better component to achieve the task. PS: I have

Camel JDBC producer custom type converter

Hi, Is there any way to get particular column from result set into a specific type? For example I need to get timestamp stored in postgresql as below, but I am getting this object as java.sql.Timestamp. resultSet.getObject( "date", OffsetDateTime.class ) Another issue is with outputClass parame

Re: Bug in the camel - JDBC

Starnge, If I remove CamelHeaders after JDBC Insert No Exception arise in the JDBC Select. If CamelHeaders Present then Statement is Closed Exception arise. -- View this message in context: http://camel.465427.n5.nabble.com/Bug-in-the-camel-JDBC-tp5801823p5801837.html Sent from the Camel

Re: Camel jdbc - select batch processing

Simple solution is* Splitter with Collate* collate(200) -- View this message in context: http://camel.465427.n5.nabble.com/Camel-jdbc-select-batch-processing-tp5801682p5801832.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Bug in the camel - JDBC

Try set resetAutoCommit=false On Mon, Jun 5, 2017 at 12:17 PM, raja wrote: > Hi, > While working in the camel JDBC, I got Exception state that "Statement > is closed" > > My Route: > > > > > > > I can able

Bug in the camel - JDBC

Hi, While working in the camel JDBC, I got Exception state that "Statement is closed" My Route: I can able to Insert.There is no problem while Insertion. But I am getting Exception in the JDBC Selection Exception Message :The statement

Re: Camel jdbc - select batch processing

n context: > http://camel.465427.n5.nabble.com/Camel-jdbc-select-batch-processing-tp5801682.html > Sent from the Camel - Users mailing list archive at Nabble.com.

Camel jdbc - select batch processing

message in context: http://camel.465427.n5.nabble.com/Camel-jdbc-select-batch-processing-tp5801682.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Using Camel JDBC component

. And there is some database examples https://github.com/apache/camel/tree/master/examples On Tue, Apr 4, 2017 at 3:29 PM, anirban.gupta4 wrote: > Hi, > > I am using camel JDBC component. I found the documentation at the location > > http://camel.apache.org/jdbc.html > > I ha

Using Camel JDBC component

Hi, I am using camel JDBC component. I found the documentation at the location http://camel.apache.org/jdbc.html I have two questions here: 1. I have an URL of type "jdbc:sqlserver://someIP". How will I pass any queries here? 2. How to set the userName, password for connecting to this

Re: camel-jdbc typo?

Sweet. Thanks and cheers. Regards, Allan C. On Sat, Aug 6, 2016 at 11:06 AM, Matt Sicker wrote: > Alright, I've fixed that typo too: > https://cwiki.apache.org/confluence/display/CAMEL/JDBC > > Not sure how often the html page is regenerated from the wiki, though. > > On

Re: camel-jdbc typo?

Alright, I've fixed that typo too: https://cwiki.apache.org/confluence/display/CAMEL/JDBC Not sure how often the html page is regenerated from the wiki, though. On 5 August 2016 at 22:00, Allan C. wrote: > Hi Matt, > > I've checked on the codes, the const

Re: camel-jdbc typo?

gt; > Regards, > > Allan C. > > > > On Sat, Aug 6, 2016 at 9:18 AM, Matt Sicker wrote: > > > > > I fixed the "kets" typo, can't tell if you're point out any others, > > though. > > > > > > On 5 August 2016 at 19:09, Alla

Re: camel-jdbc typo?

2016 at 9:18 AM, Matt Sicker wrote: > > > I fixed the "kets" typo, can't tell if you're point out any others, > though. > > > > On 5 August 2016 at 19:09, Allan C. wrote: > > > > > Hi, > > > > > > I was going throug

Re: camel-jdbc typo?

gards, Allan C. On Sat, Aug 6, 2016 at 9:18 AM, Matt Sicker wrote: > I fixed the "kets" typo, can't tell if you're point out any others, though. > > On 5 August 2016 at 19:09, Allan C. wrote: > > > Hi, > > > > I was going through camel-jdbc docs

Re: camel-jdbc typo?

I fixed the "kets" typo, can't tell if you're point out any others, though. On 5 August 2016 at 19:09, Allan C. wrote: > Hi, > > I was going through camel-jdbc docs here <http://camel.apache.org/jdbc. > html>. > I noticed what seems to be a cou

camel-jdbc typo?

Hi, I was going through camel-jdbc docs here <http://camel.apache.org/jdbc.html>. I noticed what seems to be a couple of minor typos in the doc. Header Description CamelJdbcRowCount If the query is a SELECT, query the row count is returned in this OUT header. CamelJdbcUpdateCount

Re: camel-jdbc and transction manager support

rm the commit at > the end, when the TX is set to commit. > > > > On Wed, Jul 27, 2016 at 6:50 PM, Paolo Antinori > wrote: > > Hi, I'm trying to understand if camel-jdbc can work under the > coordination > > of a transaction manager. > > > > I hav

Re: camel-jdbc and transction manager support

You likely need to set resetAutoCommit=false, so the transaction manager orchestrating the JDBC DataSource can perform the commit at the end, when the TX is set to commit. On Wed, Jul 27, 2016 at 6:50 PM, Paolo Antinori wrote: > Hi, I'm trying to understand if camel-jdbc can work u

camel-jdbc and transction manager support

Hi, I'm trying to understand if camel-jdbc can work under the coordination of a transaction manager. I have found this old JIRA: https://issues.apache.org/jira/browse/CAMEL-3803 And not much more in git history of JdbcProducer class. Can anyone confirm?

camel-jdbc fetchSize out of memory error

I am trying to ingest data from postgres to another DB and I am using camel-jdbc component to do it. I have a large table so I want to read few rows at a time instead of the whole table altogether. so my route looks like below (only for testing purpose) from(fromUri).setBody("select * from

Re: statement.maxRows not working as expected camel jdbc

text: > http://camel.465427.n5.nabble.com/statement-maxRows-not-working-as-expected-camel-jdbc-tp5775898p5776003.html > Sent from the Camel - Users mailing list archive at Nabble.com. >

Re: statement.maxRows not working as expected camel jdbc

hello Christain, Have created the JIRA https://issues.apache.org/jira/browse/CAMEL-9491 thanks -- View this message in context: http://camel.465427.n5.nabble.com/statement-maxRows-not-working-as-expected-camel-jdbc-tp5775898p5776003.html Sent from the Camel - Users mailing list archive at

Re: statement.maxRows not working as expected camel jdbc

Hi Felix, I have a unit test which confirms your finding. Could you please open an JIRA and post the ticket number here. I will have a closer look during the next days. As workaround, you could also set the limit in the SQL query. Something like: select * from TBL_DATA_AC LIMIT 2 Best, Christian

Re: statement.maxRows not working as expected camel jdbc

Thats wired. You can try readSize as well. Regards, Saurabh Nayar -- View this message in context: http://camel.465427.n5.nabble.com/statement-maxRows-not-working-as-expected-camel-jdbc-tp5775898p5775934.html Sent from the Camel - Users mailing list archive at Nabble.com.

statement.maxRows not working as expected camel jdbc

hello, I have an issue (not sure if its a bug) in camel. I have tested in multiple versio*n i.e. 2.15.1,2.16.0,2.16.1 *also but still the same result. I have a route defined below in spring XML . When i start the camel instance it works fine at the first time i.e it fetches only 2 re

Re: [camel-jdbc] opens one thread per update query until db error

the one to write data uses default output type - problem solved. -- View this message in context: http://camel.465427.n5.nabble.com/camel-jdbc-opens-one-thread-per-update-query-until-db-error-tp5772863p5772866.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel jdbc component detect end of streamlist

ould be glad to hear them. -- View this message in context: http://camel.465427.n5.nabble.com/camel-jdbc-component-detect-end-of-streamlist-tp5766218p5766227.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel jdbc component detect end of streamlist

thread/iterator is false. > > Is there a secure way to determine the number of thread/iterators? Is this > always 2? > > > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/camel-jdbc-component-detect-end-of-streamlist-tp5766218.html

camel jdbc component detect end of streamlist

en hasNext for the last thread/iterator is false. Is there a secure way to determine the number of thread/iterators? Is this always 2? -- View this message in context: http://camel.465427.n5.nabble.com/camel-jdbc-component-detect-end-of-streamlist-tp5766218.html Sent from the Camel - Users ma

Re: camel-jdbc: read-update performance drop / prepareStatementStrategy

I find the solution: instead of using the camel-jdbc component, i now use the camel-sql component with the option batch=true. This will do ps.addBatch() and eventually ps.executeBatch() which gives a lot better performance. You'll have to prepare the parameters a bit though (

Re: camel-jdbc reading from H2 @ less than 1 message per second?

Ah, my bet. Indeed, better results now ;-) -- View this message in context: http://camel.465427.n5.nabble.com/camel-jdbc-reading-from-H2-less-than-1-message-per-second-tp5762651p5762662.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: camel-jdbc reading from H2 @ less than 1 message per second?

Your are having the logger the wrong place, put the logger inside the splitter On Thu, Feb 12, 2015 at 3:09 PM, rwijngaa wrote: > Hi, > > i'm using camel-jdbc (camel 2.12.0) to read 1000+ records from a H2 database > (reading per 100), but i'm seeing a low performance of &

camel-jdbc reading from H2 @ less than 1 message per second?

Hi, i'm using camel-jdbc (camel 2.12.0) to read 1000+ records from a H2 database (reading per 100), but i'm seeing a low performance of <1 message per second. In the logging i see something like: "Received: 1 new messages, with total 11 so far. Last group took: 1 mi

Re: Camel - JDBC

ax.xml.bind.ContextFinder.newInstance(ContextFinder.java:172) at javax.xml.bind.ContextFinder.newInstance(ContextFinder.java:132) ... 29 more This was i am getting error -- View this message in context: http://camel.465427.n5.nabble.com/Camel-JDBC-tp5758485p5758517.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel - JDBC

ies> OrderBean.java <http://camel.465427.n5.nabble.com/file/n5758515/OrderBean.java> MyCamel.xml <http://camel.465427.n5.nabble.com/file/n5758515/MyCamel.xml> Error.txt <http://camel.465427.n5.nabble.com/file/n5758515/Error.txt> -- View this message in context: http://camel.46

Re: Camel - JDBC

; View this message in context: > http://camel.465427.n5.nabble.com/Camel-JDBC-tp5758485p5758488.html > Sent from the Camel - Users mailing list archive at Nabble.com. >

Re: Camel - JDBC

gt; View this message in context: > http://camel.465427.n5.nabble.com/Camel-JDBC-tp5758485p5758487.html > Sent from the Camel - Users mailing list archive at Nabble.com. >

Re: Camel - JDBC

Claus Ibsen, if i write these configuration xml files in eclipse (i am using) how can i run these from eclipse as there is no Java class to call these. Could you please help? -- View this message in context: http://camel.465427.n5.nabble.com/Camel-JDBC-tp5758485p5758488.html Sent from the

Re: Camel - JDBC

Thanks Claus Ibsen for quick reply. I already tried those links but it could not worked. And that is for Insertion. I am looking for select. Is there any example for the same start to end. Please. -- View this message in context: http://camel.465427.n5.nabble.com/Camel-JDBC

Re: Camel - JDBC

y solution or any source code > from scratch. > > Can you please help me out. > > Regards, > > Srinivas T > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Camel-JDBC-tp5758485.html > Sent from the Camel - Users mailing list a

Camel - JDBC

View this message in context: http://camel.465427.n5.nabble.com/Camel-JDBC-tp5758485.html Sent from the Camel - Users mailing list archive at Nabble.com.

Camel JDBC Aggregator - the need for 2 tables /Aggregation?

context: http://camel.465427.n5.nabble.com/Camel-JDBC-Aggregator-the-need-for-2-tables-Aggregation-tp5755847.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel-jdbc snapshots -> SQLException

Everything works fine. Thanks. -- View this message in context: http://camel.465427.n5.nabble.com/Camel-jdbc-snapshots-SQLException-tp5755058p5755158.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel-jdbc snapshots -> SQLException

Hi Ah yeah there was some code missing. I have pushed a fix. You are welcome to test again. On Wed, Aug 13, 2014 at 9:52 AM, A577127 wrote: > Hi, > > I just tryed your fix and it works fine. Thank you. > > However, I have one last problem :camel-jdbc doesn't preserve head

Re: Camel-jdbc snapshots -> SQLException

Hi, I just tryed your fix and it works fine. Thank you. However, I have one last problem :camel-jdbc doesn't preserve headers on some INSERT requests. These lines : were moved from JdbcProducer.process to some "deeper" functions, but now it doesn't get called all the time.

Re: Camel-jdbc snapshots -> SQLException

> here, so the issue still comes from camel-jdbc (even if I could solve it by > using another connector). > > I finally found the function that causes my problem : it's when > JdbcProducer.setResultSet is called. It now uses a ResultSetIterator and > calls extractRows(), whic

Re: Camel-jdbc snapshots -> SQLException

I googled my exception and found someone with a similar problem. Someone answered that stuff can work with another jdbc connector and fail with c3p0 because other connectors are less strict. My guess is that it's what happens here, so the issue still comes from camel-jdbc (even if I could sol

Re: Camel-jdbc snapshots -> SQLException

LECT requests. > > > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/Camel-jdbc-snapshots-SQLException-tp5755058p5755097.html > Sent from the Camel - Users mailing list archive at Nabble.com. -- Claus Ibsen - Red Hat, Inc. Ema

Re: Camel-jdbc snapshots -> SQLException

With this new version I get the same SQLException, but now I get it with every requests : INSERT with useHeadersAsParameters=true & false, and even SELECT requests. -- View this message in context: http://camel.465427.n5.nabble.com/Camel-jdbc-snapshots-SQLException-tp5755058p5755097.

Re: Camel-jdbc snapshots -> SQLException

Hi I committed a fix to master branch. Do you mind trying with latest code to see if it fixes the problem now? On Mon, Aug 11, 2014 at 3:54 PM, A577127 wrote: > Hi, > > I was trying to perform an SQL request on my MySQL database using > camel-jdbc. I'm using a named parameter

Re: Camel-jdbc snapshots -> SQLException

Hi Thanks for reporting. I logged a ticket https://issues.apache.org/jira/browse/CAMEL-7686 On Mon, Aug 11, 2014 at 3:54 PM, A577127 wrote: > Hi, > > I was trying to perform an SQL request on my MySQL database using > camel-jdbc. I'm using a named parameter that I map on

Camel-jdbc snapshots -> SQLException

Hi, I was trying to perform an SQL request on my MySQL database using camel-jdbc. I'm using a named parameter that I map on my camel message header, so I use the option /useHeadersAsParameters=true/ on my jdbc endpoint. I also have an auto-increment ID on my table and need to retrieve it w

Re: Camel-jdbc : can't get useHeadersAsParameters working properly

.465427.n5.nabble.com/Camel-jdbc-can-t-get-useHeadersAsParameters-working-properly-tp5754625p5754645.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel-jdbc : can't get useHeadersAsParameters working properly

Hi, Can you tell us which camel version do you use and show us your route please ? 2014-07-30 10:52 GMT+02:00 A577127 : > Hi, > > I'm trying to send a mysql request thanks to camel-jdbc. However, one of my > fields is a byteArray, so I would like to use named parameters to bin

Camel-jdbc : can't get useHeadersAsParameters working properly

Hi, I'm trying to send a mysql request thanks to camel-jdbc. However, one of my fields is a byteArray, so I would like to use named parameters to bind some value to a header (which can be a byteArray). According to the camel-jdbc documentation <http://camel.apache.org/jdbc.html> , I

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

:103) at org.apache.camel.processor.ConvertBodyProcessor.process(ConvertBodyProcessor.java:55 -- View this message in context: http://camel.465427.n5.nabble.com/java-lang-NullPointerException-in-Camel-JDBC-component-for-Select-statement-tp5750783p5750943.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

As Fuse ESB is an OSGI platform, the jar file should be deployed as bundles using osgi:install command on karaf ( http://karaf.apache.org/manual/latest-2.3.x/commands/osgi-install.html). A feature file exist to deploy the camel bundles so normally you should use features:install camel-jdbc or

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

er.jdbc.SQLServerDriver] > > I don't get this error when sqljdbc jar is present. > > Thanks > Shiv > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/java-lang-NullPointerException-in-Camel-JDBC-component-for-Select-statement-tp5750783p575

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

: http://camel.465427.n5.nabble.com/java-lang-NullPointerException-in-Camel-JDBC-component-for-Select-statement-tp5750783p5750942.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

Since I am using Fuse ESB 5.3.0, I have copied sqljdbc.jar, org.springframework.jdbc-2.5.6.jar and camel-jdbc-2.2.0.jar to FUSE HOME/lib folder. Is this is not the right location or do we need more jars? Thanks Shiv -- View this message in context: http://camel.465427.n5.nabble.com/java-lang

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

n Sourcing >> D: +61 2 8246 7702 >> >> >> -Original Message- >> From: Charles Moulliard [mailto:ch0...@gmail.com] >> Sent: Tuesday, 6 May 2014 4:52 AM >> To: users@camel.apache.org >> Subject: Re: java.lang.NullPointerException in Camel JDBC c

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

t; > -Original Message- > From: Charles Moulliard [mailto:ch0...@gmail.com] > Sent: Tuesday, 6 May 2014 4:52 AM > To: users@camel.apache.org > Subject: Re: java.lang.NullPointerException in Camel JDBC component for > Select statement > > That means that Spring JDBC has not

RE: java.lang.NullPointerException in Camel JDBC component for Select statement

4:52 AM To: users@camel.apache.org Subject: Re: java.lang.NullPointerException in Camel JDBC component for Select statement That means that Spring JDBC has not been able to load your MSQL Driver Class. I recommend that you have a look to the classpath. On Mon, May 5, 2014 at 8:00 PM, Shiv

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

hanks > Shiv > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/java-lang-NullPointerException-in-Camel-JDBC-component-for-Select-statement-tp5750783p5750881.html > Sent from the Camel - Users mailing list archive at Nabble.com. > -- Charles Moullia

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

I do not see any log statement from DriverManagerDataSource class in my log file :(. Thanks Shiv -- View this message in context: http://camel.465427.n5.nabble.com/java-lang-NullPointerException-in-Camel-JDBC-component-for-Select-statement-tp5750783p5750881.html Sent from the Camel - Users

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

a.sql.Driver. Though i doubt > it but if this conversion is not happening properly? - Just a wild guess. > > Also, since i am using camel core and camel jdbc 2.2.0 jars, if there is > any > fixed version of spring jdbc jar has to be used. Currently, i downloaded > 2.5.6 version of

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

river. Though i doubt it but if this conversion is not happening properly? - Just a wild guess. Also, since i am using camel core and camel jdbc 2.2.0 jars, if there is any fixed version of spring jdbc jar has to be used. Currently, i downloaded 2.5.6 version of spring jdbc jar. Any compatibility

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

> > > -- > View this message in context: > http://camel.465427.n5.nabble.com/java-lang-NullPointerException-in-Camel-JDBC-component-for-Select-statement-tp5750783p5750852.html > Sent from the Camel - Users mailing list archive at Nabble.com. > -- Charles Moulliard Apach

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

expect to log successful connection message if connection is created successfully? Thanks Shiv -- View this message in context: http://camel.465427.n5.nabble.com/java-lang-NullPointerException-in-Camel-JDBC-component-for-Select-statement-tp5750783p5750852.html Sent from the Camel - Users

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

.microsoft.sqlserver.jdbc.SQLServerDriver. That was one difference. > > If there are ways to get more debug information to fix this issue? > > Thanks > Shiv > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/java-lang-NullPointerExceptio

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

was one difference. If there are ways to get more debug information to fix this issue? Thanks Shiv -- View this message in context: http://camel.465427.n5.nabble.com/java-lang-NullPointerException-in-Camel-JDBC-component-for-Select-statement-tp5750783p5750788.html Sent from the Camel - Users

Re: java.lang.NullPointerException in Camel JDBC component for Select statement

You get this error because the Connection object is null ( https://github.com/apache/camel/blob/camel-2.2.0/components/camel-jdbc/src/main/java/org/apache/camel/component/jdbc/JdbcProducer.java#L67). So I suspect that a problem occurred during creation of the DataSource object On Fri, May 2

java.lang.NullPointerException in Camel JDBC component for Select statement

Hi all, I am using Camel JDBC component for first time and I need to query a table in MS SQL Server 2008 R2 and push the results to an ActiveMQ queue. I used the details on http://camel.apache.org/jdbc.html page and tried to get the setup. Once my route define in Spring configuration file is

Camel jdbc at same time from db to a queue and to another db

hi, i want to make a route at same time from my local db to external activemq queue querying select * from ... and to another db querying select id from How can i make this ? thank you in advance.. -- View this message in context: http://camel.465427.n5.nabble.com/Camel-jdbc-at-same

Camel jdbc at same time from db to a queue and to another db

hi, i want to make a route at same time from my local db to external activemq queue querying select * from ... and to another db querying select id from How can i make this ? thank you in advance.. -- View this message in context: http://camel.465427.n5.nabble.com/Camel-jdbc-at-same

Re: Help apache camel jdbc + active

As said above. Use quartz or an AMQ event to trigger it. *Robert Simmons Jr. MSc. - Lead Java Architect @ EA* *Author of: Hardcore Java (2003) and Maintainable Java (2012)* *LinkedIn: **http://www.linkedin.com/pub/robert-simmons/40/852/a39 *

Re: Help apache camel jdbc + active

As mentioned in the Camel docs for the JDBC component: This component can only be used to define producer endpoints, which means that you cannot use the JDBC component in a from() statement. So if you want to poll message from a database you shouldn't use the JDBC component but instead use either

Help apache camel jdbc + active

I'm new in apache camel and i have a problem about the filling of the activemq. I want to get the values from DB and filled it into activemq. My activemq is started: My code : private void fillActiveMq() throws Exception{ JndiRegistry registry = new JndiRegistry(new JndiContext()); CamelContext

Re: prepared statements in camel-jdbc?

On Fri, Mar 1, 2013 at 5:24 AM, kavan desai wrote: > I am seeing this post is quite old hence want to reassure, Does Camel JDBC > support Prepeared statements? > Check the source code https://svn.apache.org/repos/asf/camel/trunk/components/camel-jdbc/ > > > -- > View th

Re: prepared statements in camel-jdbc?

I am seeing this post is quite old hence want to reassure, Does Camel JDBC support Prepeared statements? -- View this message in context: http://camel.465427.n5.nabble.com/prepared-statements-in-camel-jdbc-tp3319106p5728328.html Sent from the Camel - Users mailing list archive at Nabble.com.

Camel JDBC 1.6.1

Hi, I am using the camel jdbc endpoint, however it is giving me something of a problem. I have a process where i receive an xml payload by ftp, i take that payload and put it into a custom header parameter in the message and pass it onto the jdbc endpoint to do a database insert. however, after

Re: Camel JDBC 1.6.1

You should subscribe to the list. Otherwise you post is not forwarded to the mailing list where most of the developers listening... Checkout http://camel.apache.org/discussion-forums.html Best, Christian -- View this message in context: http://camel.465427.n5.nabble.com/Camel-JDBC-1-6-1

Re: Camel JDBC 1.6.1

thanks for all the help Graham -- View this message in context: http://camel.465427.n5.nabble.com/Camel-JDBC-1-6-1-tp5716995p5717128.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: Camel JDBC 1.6.1

This is fixed some time ago... Is it possible for you to upgrade to 2.10.0 or so? If not, you can use the Content Enricher Pattern [2] to work around this issue. [1] https://svn.apache.org/repos/asf/camel/trunk/components/camel-jdbc/src/main/java/org/apache/camel/component/jdbc/JdbcProducer.java

Re: Camel JDBC 1.6.1

How /jdbcRejectProcessor/ processor looks like? -- View this message in context: http://camel.465427.n5.nabble.com/Camel-JDBC-1-6-1-tp5716995p5717006.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: ServiceMIx+Camel JDBC+MySql = javax.sql.DataSource not found

Thank you! That was the case - I had to add reference into my route blueprint: And now it works fine. -- View this message in context: http://camel.465427.n5.nabble.com/ServiceMIx-Camel-JDBC-MySql-javax-sql-DataSource-not-found-tp5715323p5715332.html Sent from the Camel - Users mailing list

Re: ServiceMIx+Camel JDBC+MySql = javax.sql.DataSource not found

at > org.apache.camel.impl.DefaultComponent.createEndpoint(DefaultComponent.java:91) > at > org.apache.camel.impl.DefaultCamelContext.getEndpoint(DefaultCamelContext.java:438) > ... 40 more > > How to access the registry? Maybe service property name i

ServiceMIx+Camel JDBC+MySql = javax.sql.DataSource not found

property name is wrong? What else could be changed? I would appreciate any help, because at the moment I feel desperate. -- View this message in context: http://camel.465427.n5.nabble.com/ServiceMIx-Camel-JDBC-MySql-javax-sql-DataSource-not-found-tp5715323.html Sent from the Camel - Users mailing

Re: Camel jdbc component metadata

Hi Please don't ask the same question more than once using different login-Ids: http://camel.465427.n5.nabble.com/Fetching-metadata-from-Camel-JDBC-Component-td5714880.html As you see by the thread above Henryk has already opened a JIRA ticket for you and is kindly asking you if you would

Camel jdbc component metadata

Hi I am using camel jdbc component to run a query and get a resultset. I need the column names in a separate list. Currently I am fetching the column names manually from the list of maps returned. Is there a better way to do this? Is there a way to get the metadata separately? -- View this

Re: Fetching metadata from Camel JDBC Component

> feel free to log a JIRA and work on a patch Jira ticket [1] for the issue created. @Valivets, do you want to work on this or should I implement the patch? [1] https://issues.apache.org/jira/browse/CAMEL-5383 -- Henryk Konsek http://henryk-konsek.blogspot.com

Re: Fetching metadata from Camel JDBC Component

On Thu, Jun 21, 2012 at 8:10 PM, valivets wrote: > Hi all.. > I am using camel jdbc component to run a query and get a resultset. I need > the column names in a separate list. Currently I am fetching the column > names manually from the list of maps returned. Is there a better way

Fetching metadata from Camel JDBC Component

Hi all.. I am using camel jdbc component to run a query and get a resultset. I need the column names in a separate list. Currently I am fetching the column names manually from the list of maps returned. Is there a better way to do this? Is there a way to get the metadata separately? -- View this

  1   2   >