Hi,
I want to connect to database throght JNDI in all my reports. I tried in the below way but getting errors.
I did in the following way..
1. I created a context.xml in meta-inf folder in webviewer example.
I added below resource in it
<Resource name="jdbc/myJNDI"
auth="Container"
type="javax.sql.DataSource"
maxActive="5" maxIdle="-1" maxWait="10000"
username="test" password="test"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:
@test:1521:test1"
description="DB"/>
and added resouce def in web.xml of webviewer example
<resource-ref>
<description>Resource reference to a factory for java.sql.Connection</description>
<res-ref-name>jdbc/myJNDI</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
and in the report i gave the JNDI name.. Attached is the image of the data source connection in the report.
I am getting the below errors when I run the report.. I am using tomcat 5.5, birt 2.5 and oracle 9i.
Attached is the error log whhich I got when I run the report in Tomcat.
Please help me in solving the issue.
Thanks in advance for any help.
Thanks,
Susmitha.