unable to insert data in table using camel sql & sqlite Error

Asked Nov 17 '17 at 11:06

Active Nov 17 '17 at 11:11

Viewed 729 times

I am using Jboss Fuse with blueprint as DSL. I wrote a simple camel route using sql component which inserts data in SQlite.

   <route id="testDBRoute">
        <from uri="timer://foo?fixedRate=true&amp;period=10000"/>
        <log message="calling DB"/>
        <to uri="sql:insert into TestTable (ID, FName, LName) values (1, 'Beena', 'Singh')"/>
   </route>

But I got below exception in logs:

org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [1]; [SQLITE_ERROR] SQL error or missing database (no such table: TestTable); nested exception is java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: TestTable)

I ran the same query in sqlite DB and the record is inserted. But the exception says it can't find either the db or the table. I have installed camel-sql and camel-spring as a feature. But I am clueless as to why its not able to connect to Sqllite DB.Any help will be appreciated.

edited Nov 17 '17 at 11:11

pvpkiran

25,582
8
87
134

asked Nov 17 '17 at 11:06

Beena Rautela

have you configured datasource? – pvpkiran Nov 17 '17 at 11:11
Yes, like this. – Beena Rautela Nov 17 '17 at 11:15
is database name mentioned in $[db.url] ? – pvpkiran Nov 17 '17 at 11:58
Please note that when the file does not exist, SQLite creates a new DB. What is the actual file name? – CL. Nov 17 '17 at 13:35
It is something to do with your datasource configuration. Make sure the data source and sql component are getting the correct values. – Jayarajan Nov 17 '17 at 18:31
Yes, The issue is with locating the database file.Its resolved now. Thanks for pointing me in the right – Beena Rautela Nov 21 '17 at 06:43
Can you post your solution as an answer so we can get this SO marked as answered – Claus Ibsen Nov 24 '17 at 08:02
instead of did the trick. Thanks – Beena Rautela Nov 27 '17 at 05:00

unable to insert data in table using camel sql & sqlite Error

0 Answers0