Re: JDBC based idempotent repository problem

2014-07-09 Thread Chris Melikian
t; > > Is it possible to update the SQL component documentation to reflect the > > different datatype required for SQL Server? > > > > > > > > -- > > View this message in context: > > http://camel.465427.n5.nabble.com/JDBC-based-idempotent-repository-proble

Re: JDBC based idempotent repository problem

2014-07-09 Thread Christian Müller
, 2014 at 3:10 PM, Chris Melikian wrote: > Is it possible to update the SQL component documentation to reflect the > different datatype required for SQL Server? > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/JDBC-based-idempotent-repository-p

Re: JDBC based idempotent repository problem

2014-07-08 Thread Chris Melikian
Is it possible to update the SQL component documentation to reflect the different datatype required for SQL Server? -- View this message in context: http://camel.465427.n5.nabble.com/JDBC-based-idempotent-repository-problem-tp4980094p5753546.html Sent from the Camel - Users mailing list

Re: JDBC based idempotent repository problem

2011-11-15 Thread Christian Müller
See [1]. You have to use "datetime" or "smalldatetime". And don't overlook the note: "The SQL Server timestamp type is a fixed-length binary-string type. It does not map to any of the JDBC time types: DATE, TIME, or TIMESTAMP." [1] http://msdn.microsoft.com/en-us/library/ms378715%28v=sql.90%29.asp

Re: JDBC based idempotent repository problem

2011-11-14 Thread Yaroslav1988
"SQL Server built in Timestamp" and "javax.sql.Timestamp" differ and don't suit one another. I will try to find the key in documentations. -- View this message in context: http://camel.465427.n5.nabble.com/JDBC-based-idempotent-repository-problem-tp4980094p4993500.html Sen

Re: JDBC based idempotent repository problem

2011-11-10 Thread Christian Müller
Hello Yaroslav! The column "createdAt" was introduced in Camel 2.8.0. Do you use Camel 2.8.0 or a newer version? I'm not familiar with Micosoft SQLServer, but the problem looks related to the "createdAt" column. What we do is something like this: String INSERT_STRING = "INSERT INTO CAMEL_MESSAGE

Re: JDBC based idempotent repository problem

2011-11-09 Thread Yaroslav1988
se my english, not my native -- View this message in context: http://camel.465427.n5.nabble.com/JDBC-based-idempotent-repository-problem-tp4980094p4980267.html Sent from the Camel - Users mailing list archive at Nabble.com.

Re: JDBC based idempotent repository problem

2011-11-09 Thread Claus Ibsen
    >                 >                 >   > > > Route "from seda:audit" implemented in java DSL: > >  from("seda:audit") >                 .process(new Processor() { >                    public void process(Exchange exchange) throws Exception { > >                        System.out.println("Me

JDBC based idempotent repository problem

2011-11-09 Thread Yaroslav1988
System.out.println("Message processed !"); } }); Simple as it can be, but doesn't work :( Any suggestions, why my repository can't insert ID's in DB. PS SQL Server use is inevitable (project term) -- View this message in con