JDBC allowNamedParameters=false

2014-04-30 Thread moj0002
I am writing a DELETE statement using the JDBC component and want to make sure there is no SQL injection possibilities. My statement does not have any input parameters, is basically a table with a few columns including one called MOD_TIME. The SQL statement is in a bean DELETE FROM MY_TABLE WHER

Re: JDBC component and jboss ds.xml file

2014-04-15 Thread moj0002
okay I figured it out I think, The CamelJdbcUpdateCount contains rows inpacted included rows DELETED, maybe it is using a prepared statement behind the scene I first dumped all the headers and found the property in the input header Then this works I am still confused as to why I am loo

Re: JDBC component and jboss ds.xml file

2014-04-14 Thread moj0002
Thanks, that was it, I guess my question was not really a Camel question but rather a Spring question. Here is what I did and this works http://www.springframework.org/schema/beans"; xmlns:jee="http://www.springframework.org/schema/jee"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xml

JDBC component and jboss ds.xml file

2014-04-11 Thread moj0002
I have my data source defined in a jboss ds file (myDB2Database-ds.xml) that goes either in the jboss deploy directory or ds directory myDataSource jdbc:db2://; com.ibm.db2.jcc.DB2Driver ... more properties here In my spring application context I define my route

Re: retrieving iru in onException

2014-03-24 Thread moj0002
Took me a bit to figure out how to retrieve the FAILURE_ENDPOINT from Simple, I didn't understand the that default value "CamelFailureEndpoint" for FAILURE_ENDPOINT also is the key used in the properties map on the Exchange. Probably very obvious if you know, I guess I jumped a few chapters ahead

retrieving iru in onException

2014-03-16 Thread moj0002
I am trying to write a simple "ping" application. I ping urls in a multicast and if there is a connection exception I catch it in a onException which calls a aggregation that builds an email If myFirstURLToPing is down I can't figure out out how to pass the URL via the Exception to the email body.