Hi,
I'm trying to use JNDI URL in my Open Source BIRT reports (2.5.2) deployed to BIRT report engine runtime on Tomcat (6.0) container to connect to MySQL dB (5.1) but getting the error "org.eclipse.birt.report.data.oda.jdbc.JDBCException: The selected driver cannot parse the given JNDI Data Source URL"
I have copied "mysql-connector-java-5.1.xx-bin.jar" to %CATALINA_HOME%/lib folder and followed the instructions on <
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html#MySQL_DBCP_Example> to update the context and web xml files.
With this setting I quickly tested connecting from a servlet using the defined JNDI URL which connected successfully but my BIRT report fails to connect with the error "The selected driver cannot parse the given JNDI Data Source URL".
It would be of great help if anyone can point me to what I'm missing here.
Environment details:
1)BIRT/runtime version: 2.5.2
2)Tomcat version: 6.0
3)MySQL version: 5.1
4)Path my report design file is deployed to: %BIRT_HOME%/webcontent
5)JNDI configuration
context.xml:
<Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="********" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/testdb"/>
web.xml:
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Thanks
Anand
