Zhang Weidong-p55510 <[EMAIL PROTECTED]> writes: .....
> 4. Is there a JDBC Data source connection pool component for me to use? Dong, Regarding number 4: There is no JDBC data source connection pool component directly (unless something is pending release), but there are two other choices that servicemix supports which i have been testing: 1. XSQL, which is useful for simple queries. 2. Groovy scripting. You can pull a datasource from JNDI, connect, and exectute jdbc via the groovy sql api's. I found this approach to more powerful than a JDBC connector because you can easily transform the results in the same script. Further, you can use a quartz timing component to trigger the sql if your intent it to poll a table. Clearly i am partial to the second option. Andrew
