Error: "java.sql.SQLException: ORA-00911: invalid character" deleting Software Collection with JDBC Oracle driver

  • 3749720
  • 24-Sep-2007
  • 27-Apr-2012

Environment


Novell ZENworks 7.5 Asset Management - ZAM7.5

Situation

Error: "java.sql.SQLException: ORA-00911: invalid character" deleting Software Collection with JDBC Oracle driver

Resolution

If downloading the Interim Release manually fromhttps://download.novell.com, select ZENworks Asset Management from the product drop down field, and then hit search and go to the Patches tab. The Interim releases can also be set up within the ZAM Manager for the Task server to check the site on a scheduled basis, and download and apply them automatically. Please refer to the Help Section for details of how to set up automatic downloads if desired.

Each interim release is cumulative. If Interim Release 5 is not available due to a newer interim release being placed on the website, be assured that the code needed is in the later release.

Additional Information

The cause is a semi-colon at the end of the SQL statement that the JDBC driver doesn't handle.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.