Bug 814214 - Camel SQL gateway can't lookup for DataSource in Camel Context
Summary: Camel SQL gateway can't lookup for DataSource in Camel Context
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: 3rd Party
Version: 5.3.0 GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ER2
: 5.3.0 GA
Assignee: Default User
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks: 814297
TreeView+ depends on / blocked
 
Reported: 2012-04-19 11:45 UTC by Robert Balent
Modified: 2014-01-13 00:20 UTC (History)
3 users (show)

Fixed In Version: 5.3.0 GA
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-05-10 09:23:34 UTC
Type: Bug


Attachments (Terms of Use)
camel_sql_deploy.log (11.65 KB, patch)
2012-04-19 11:45 UTC, Robert Balent
no flags Details | Diff
Camel SQL reporoducer (14.71 KB, application/zip)
2012-04-19 11:46 UTC, Robert Balent
no flags Details

Description Robert Balent 2012-04-19 11:45:41 UTC
Created attachment 578613 [details]
camel_sql_deploy.log

When you try use camel-sql component[1], the deployment of application fails because Camel can't lookup for DataSource in Camel Context and fails with:

Caused by: java.lang.IllegalArgumentException: registry entry called java:/DefaultDS of type javax.sql.DataSource must be specified

There is possibility that this bug is related to JBESB-3471[2] issue.

Full log of failed deployment is attached.

I'm also attaching sample project, which tries to connect to database through DefaultDS DataSource but it fails. 

Table which is example trying to query doesn't exist but it's not relevant for this bug.

1. Start server
2. Unzip reproducer to quickstarts directory
3. Configure quickstarts.properties to target your server profile
4. from camel_sql directory run: ant deploy



[1] http://camel.apache.org/sql-component.html
[2] https://issues.jboss.org/browse/JBESB-3471

Comment 1 Robert Balent 2012-04-19 11:46:13 UTC
Created attachment 578614 [details]
Camel SQL reporoducer

Comment 2 tcunning 2012-05-04 21:32:00 UTC
The problem here looks to me like you're using a datasource in the java: namespace, which Camel can't see.    If you use a datasource in the global namespace (you need to set <use-java-context/>, you shouldn't have this issue : 


<?xml version="1.0" encoding="UTF-8"?>
<datasources>
   <local-tx-datasource>
         <use-java-context>false</use-java-context>
...

I still see the space issue, which I believe is represented by https://bugzilla.redhat.com/show_bug.cgi?id=814297 but I don't believe this to be an issue.

Comment 3 Robert Balent 2012-05-10 09:23:34 UTC
Yes, you are right. Good work Tom.

So I'm closing this issue as a NOTABUG.


Note You need to log in before you can comment on or make changes to this bug.