<p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">Hi everyone,</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">Usually when creating a standard JDBC datasource in Eclipse designer, we can define both a direct JDBC access and a JNDI uri for connection pooling. Thus in development mode the designer makes use of a direct-access, and when deployed in production (Tomcat) the JNDI connection pool takes precedence:</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"><img src='
http://i.stack.imgur.com/7Y3JW.png' alt='Posted Image' class='bbc_img' /></p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">It works very well, but now i would like my users to take advantage of the JDBC query builder, in order to design queries graphically.</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">However when creating a new datasource => "JDBC Database connection for query builder", the configuration screen does not allow to enter a JNDI uri:</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"><img src='
http://i.stack.imgur.com/WOWRu.png' alt='Posted Image' class='bbc_img' /></p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">I tried in "optional" tab to set manually a property such "odaJndiName=java:comp/env/mydatabase" but it does not help it breaks the datasource.</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">Is it possible to plug a BIRT "JDBC connection query builder" to a connection pool when deployed in a production context?</p><p style="color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">Thanks!</p>