Symptom
There are database logon errors at database server side when using JRC SDK via JDBC.
Environment
- Crystal Reports 2008.
- Crystal Reports for Eclipse 2.0.
Reproducing the Issue
- Configure the JDBC connection from JRC project to database server.
- Deployed the attached JRC application code under Crystal Reports for Eclipse 2.0 .
- Refresh the report data and check the error log at database server side , you will see the errors like below :
----------------------------------------------------------------------------------------------
2010-12-10 10:20:25.03 Logon Error: 18456, Severity: 14, State: 8.
2010-12-10 10:20:25.03 Logon Login failed for user 'sa'. [CLIENT: 127.0.0.1]
----------------------------------------------------------------------------------------------
Note, it might take a few minutes before the error is flushed to the log file, try the workflow several time to make it happen.
Cause
The issue has been identified and logged under Problem Report ID ADAPT01512930.
Resolution
This issue has been fixed in Gemini Service Pack 10 for Crystal Reports for Java(CRJ).
Keywords
JAVA, CRJ , JRC , Logon , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Bug Filed
Product
Attachments
Code for Reproduce.zip |