Saskia Heesen pisze: > Hello all, Hello Saskia.
> in Cocoon 2.1.x, I really like the SQLTransfomer since it provides easy > access to databases. > However, I had some problems using it in Cocoon 2.2. The SQLTransformer in > Cocoon 2.2 seems to > use avalon components even though Spring is the favorite component model. I guess you haven't seen this[1] document? > As I understand Craig Walls, Spring in Action, the major approach for > database access is to > configure a data source. Springs seems not to have a DatasourceComponent like > Avalon. So I > adapted the existing SQLTransformer and built a SpringSQLTransformer. > Enclosed you will find the > source code, bean configuration, and a sample containing a sitemap calling the > SpringSQLTransformer and two ways to configure the bean. > local-springContext-1.xml is a > configuration for a datasource that is provided by the application server > (e.g. Tomcat). > lcoal-springContext-2.xml is a bean configuration for a connection pool using > Jakarta Database > Connection Pools jars. > > What's your opinion to the SpringSQLTransformer? Can it be part of the > database-block? I cannot review your code because I'm very short on my free time at the moment but I'll do it in two-three days. Meanwhile I would like to say that I already had plans (only in my head) to create Databases block 2.0 that would include following changes: * remove database actions * migrate SQLTransformer, DatabaseReader and rest of the components to Spring completely * include support for jDBI as an easy way for building simple CRUD applications (most of the needed code I have already written for my own purposes) * dropped support for Databases bridge In order to stay in a harmony with our deprecation policies I would just release Databases 1.1.0 containing databases action deprecated. There I would find place for your SpringSQLTransformer provided it's good enough for inclusion. Any folks interested in Databases 2.0? I haven't been speaking about it already because I'm busy with other things but I would be happy to help if someone else would like to pick up this task. [1] http://cocoon.apache.org/2.2/blocks/databases-bridge/1.0/1424_1_1.html -- Grzegorz Kossakowski Committer and PMC Member of Apache Cocoon http://reflectingonthevicissitudes.wordpress.com/
