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 ad
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
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
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
>
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
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
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
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
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
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.
Try set resetAutoCommit=false
On Mon, Jun 5, 2017 at 12:17 PM, raja <r...@meru.co.in> wrote:
> Hi,
> While working in the camel JDBC, I got Exception state that "Statement
> is closed"
>
> My Route:
>
>
>
>
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
> View this 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.
this 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.
.
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 <anirban.gup...@gmail.com> wrote:
> Hi,
>
> I am using camel JDBC component. I found the documentation at the location
>
> http://camel
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
Sweet. Thanks and cheers.
Regards,
Allan C.
On Sat, Aug 6, 2016 at 11:06 AM, Matt Sicker <boa...@gmail.com> 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
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. <allan...@gmail.com> wrote:
> Hi Matt,
>
> I've checked on the codes, the consta
m the code's annotation?
> >
> > Regards,
> > Allan C.
> >
> > On Sat, Aug 6, 2016 at 9:18 AM, Matt Sicker <boa...@gmail.com> wrote:
> >
> > > I fixed the "kets" typo, can't tell if you're point out any others,
> > though.
t;
> On Sat, Aug 6, 2016 at 9:18 AM, Matt Sicker <boa...@gmail.com> 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. <allan...@gmail.com> wrote:
> >
> > > Hi
an C.
On Sat, Aug 6, 2016 at 9:18 AM, Matt Sicker <boa...@gmail.com> 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. <allan...@gmail.com> wrote:
>
> > Hi,
> >
> > I was go
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. <allan...@gmail.com> wrote:
> Hi,
>
> I was going through camel-jdbc docs here <http://camel.apache.org/jdbc.
> html>.
> I noticed what seems to
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.
CamelJdbcUpdat
ing 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 <sonica...@gmail.com>
> wrote:
> > Hi, I'm trying to understand if camel-jdbc can work under the
> coordination
>
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 <sonica...@gmail.com> wrote:
> Hi, I'm trying to understand if c
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?
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
--
> 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 Nabble.com.
>
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
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
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,
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.
) and 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.
.
--
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.
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 mailing list archive at Nabble.com.
--
Claus Ibsen
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
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.
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.
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 archive at Nabble.com.
--
Claus Ibsen
-
Red Hat, Inc
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
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
://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.
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.
For instance, if I
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 antoine.mat...@worldline.com wrote:
Hi,
I just tryed your fix and it works fine. Thank you.
However, I have one last problem :camel-jdbc doesn't preserve
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.
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 antoine.mat...@worldline.com 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
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 antoine.mat...@worldline.com wrote:
Hi,
I was trying to perform an SQL request on my MySQL database using
camel-jdbc. I'm using a named
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.html
Sent
, and even
SELECT 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.
Email: cib...@redhat.com
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 solve
happens
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(), which iterates over
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 when I
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 should set
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 antoine.mat...@worldline.com:
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
.nabble.com/Camel-jdbc-can-t-get-useHeadersAsParameters-working-properly-tp5754625p5754645.html
Sent from the Camel - Users mailing list archive at Nabble.com.
:
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.
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
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-tp5750783p5750942.html
Sent from the Camel - Users mailing list archive at Nabble.com.
--
Charles Moulliard
Apache
.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.
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
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 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
: 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 shiv.dixit@gmail.com wrote:
I do not see any log
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
Apache Committer / Architect @RedHat
Twitter
java.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 spring jdbc jar. Any
setDriver(Driver) which is expecting java.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
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
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 Moulliard
Apache Committer / Architect
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
it also 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
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
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
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 mailing list
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
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
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
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
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
http://www.linkedin.com/pub/robert-simmons/40/852/a39*
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.
On Fri, Mar 1, 2013 at 5:24 AM, kavan desai kavan.de...@barclays.com 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
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
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.
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.
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
Thank you! That was the case - I had to add reference into my route
blueprint:
reference id=MyDataSource interface=javax.sql.DataSource/
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
(DefaultCamelContext.java:438)
... 40 more
How to access the registry? Maybe service 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
:
http://camel.465427.n5.nabble.com/ServiceMIx-Camel-JDBC-MySql-javax-sql-DataSource-not-found-tp5715323.html
Sent from the Camel - Users mailing list archive at Nabble.com.
--
Claus Ibsen
-
FuseSource
Email: cib...@fusesource.com
Web: http://fusesource.com
Twitter: davsclaus
On Thu, Jun 21, 2012 at 8:10 PM, valivets samira.valiv...@barclays.com 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
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
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
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 like
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
Hi,
Ensure you already install camel-jdbc feature.
Btw, please don't cross-post same question multiple times, I just saw
your same question in another thread.
Freeman
On 2011-11-14, at 下午8:15, Chaks wrote:
Hello,
Please can someone help me with sample blueprint for Camel JDBC
component
Hello Freeman,
My apologies for posting the question twice. Thanks very much for your
response. I installed camel-jdbc feature and it worked like a charm.
Thanks,
Chaks.
--
View this message in context:
http://camel.465427.n5.nabble.com/Blueprint-XML-for-Camel-JDBC-component-tp4990596p4990705
=oracle.jdbc.OracleDriver/
property name=url
value=jdbc:oracle:thin:xxx/xxx@myhostname:1521:ORCL
/
/bean
--
View this message in context:
http://camel.465427.n5.nabble.com/Camel-JDBC-oracle-PL-SQL-tp4733426p4733426.html
Sent from the Camel - Users mailing list
Database or some other datamapping framework (hibernate)
--
View this message in context:
http://camel.465427.n5.nabble.com/Camel-JDBC-oracle-PL-SQL-tp4733426p4734416.html
Sent from the Camel - Users mailing list archive at Nabble.com.
...@gmail.com wrote:
Want we let it as it is? Or should we raise a JIRA for it and fix it?
I would prefer to raise a JIRA for it...
Christian
On Wed, Mar 23, 2011 at 8:25 AM, Charles Moulliard
cmoulli...@gmail.comwrote:
Hi Willem,
You confirm what I was suspected -- camel-jdbc is not a transactional
the
exchange is sent to the camel-jdbc endpoint.
Can you tell me why did you do that ?
Willem
On 3/22/11 11:59 PM, Charles Moulliard wrote:
Hi,
I have created a transactional route in camel where I use camel-jdbc
component but the data are not rollbacked from DB when an error
occurs
Hi Charles,
I just went through the code of camel-jdbc and camel-sql.
camel-sql is use the JdbcTemplate which can interact with the Spring
transaction manage rightly.
camel-jdbc just create a statment object base on the data source, that
could explain why the rollback doesn't work for you
Hi Willem,
You confirm what I was suspected -- camel-jdbc is not a transactional
component.
Regards,
Charles
On Wed, Mar 23, 2011 at 8:22 AM, Willem Jiang willem.ji...@gmail.com wrote:
Hi Charles,
I just went through the code of camel-jdbc and camel-sql.
camel-sql is use the JdbcTemplate
Want we let it as it is? Or should we raise a JIRA for it and fix it?
I would prefer to raise a JIRA for it...
Christian
On Wed, Mar 23, 2011 at 8:25 AM, Charles Moulliard cmoulli...@gmail.comwrote:
Hi Willem,
You confirm what I was suspected -- camel-jdbc is not a transactional
component
1 - 100 of 119 matches
Mail list logo