Camel SQL Using JNDI and Connecting to Schema other than default Schema

[vivekrao001]

Hi,

I successfully configured sql component using the following config.

       <bean id="sql" class="org.apache.camel.component.sql.SqlComponent">
                <property name="dataSource" ref="dataSource" />
        </bean>
             
        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
                destroy-method="close">
                <property name="driverClassName" 
value="${jdbc.driverClassName}" />
                <property name="url" value="${jdbc.url}" />
                <property name="username" value="${jdbc.username}" />
                <property name="password" value="${jdbc.password}" />
        </bean>

I was able to do write join queries with tables in different schemas.

But if change it to* JNDI using Tomcat the query is not working.*

<jee:jndi-lookup id="dataSource" jndi-name="jdbc/myds" />

*With JNDI, I was only able to connect to default schema in the table.*

I tried using "sql:" which is bean id for SqlComponent and also using
datasourceRef in the query.

Any help would be greatly appreciated.

Thanks,
Vivek.




--
View this message in context: 
http://camel.465427.n5.nabble.com/Camel-SQL-Using-JNDI-and-Connecting-to-Schema-other-than-default-Schema-tp5770854.html
Sent from the Camel - Users mailing list archive at Nabble.com.