Bug 814214

Summary: Camel SQL gateway can't lookup for DataSource in Camel Context
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Robert Balent <rbalent>
Component: 3rd PartyAssignee: Default User <jbpapp-maint>
Status: CLOSED NOTABUG QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.3.0 GACC: mvecera, soa-p-jira, tcunning
Target Milestone: ER2   
Target Release: 5.3.0 GA   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: 5.3.0 GA Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-05-10 09:23:34 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On:    
Bug Blocks: 814297    
Attachments:
Description Flags
camel_sql_deploy.log
none
Camel SQL reporoducer none

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.