[COCOON-2106] DatabaseReader and SQLTransformer cannot obtain datasource

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2
• Fix Version/s: 2.2
• Component/s: Blocks: Databases
• Other Info: Patch available
• Assignee: Grzegorz Kossakowski
• Reporter: Csaba Kazó
• Created: 05/Aug/07 11:39
• Updated: 19/Sep/07 22:32
• Resolved: 19/Sep/07 22:32

Description

The DatabaseReader and SQLTransformer components fail to obtain the configured data source and throw a ServiceException like "Component with 'org.apache.avalon.excalibur.datasource.DataSourceComponent/personnel' is not defined in this service manager. (Key='AvalonServiceManager')". The failing function call in both cases is:

this.manager.lookup(DataSourceComponent.ROLE + '/' + datasourceName)

The result is the same regardless of whether the data source is defined as an Avalon component or a Spring bean.
Changing the code to use ServiceSelector as in the "Creating a Reader" document [1] and the modular database actions solves the problem for both cases. The attached patch applies this modification to DatabaseReader.java.

[1] http://cocoon.zones.apache.org/daisy/cdocs/g1/g1/g2/g1/g2/681.html

Issue Links

• relates to: COCOON-2083 Allow database connections defined as Spring beans to be used in Avalon components