Java EE (Java Enterprise Edition) General Discussion

Hi Guys,

I'm back to struggling with Crystal Reports XI Release 2.

I'm trying to display a report that retrieves a set of data from an oracle database.

I've got the following scenarios:

- If I build a report using a JDBC connection and setting its properties from the crystal reports designer It works perfectly
- If i build the same report using a connection type called Oracle Server and check the option SAVE DATA WITH REPORT works fine
- The failure scenario is, creating the same report by using an Oracle server connection and disabling the SAVE DATA WITH REPORT option. I get the error message: Database logon failed. Database Vendor Error Code: 17002

I've set a JDNI datasource in Tomcat already, and still getting the same error, as well as including this tag in my application web.xml

<resource-ref>
<description>Oracle Datasource example</description>
<res-ref-name>oraclevt</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

Please, let me know if you have any hint regarding this issue as I've run out of ideas to sort it out.

Thank you.
Esteban.