Error Messages from DB2 XQuery
Having trouble installing Oxygen? Got a bug to report? Post it all here.
Error Messages from DB2 XQuery
Hi,
oXygen is working great for editing eXist and DB2 XQueries.
One problem I am having with DB2 is getting readable error messages back to the Eclipse Error panel of oXygen. Here is a simple XQuery with a missing semicolon in the let statement. (it should be let foo := 'bar'
Here is the error message:
[
Is this a problem with DB2 not returning good error messages of did I not configure oXyen correctly? Is there any way to get better error messages? This would make debugging long XQueries much easier.
Thanks - Dan
oXygen is working great for editing eXist and DB2 XQueries.
One problem I am having with DB2 is getting readable error messages back to the Eclipse Error panel of oXygen. Here is a simple XQuery with a missing semicolon in the let statement. (it should be let foo := 'bar'
Code: Select all
let $foo = 'bar'
return
<root>
{$foo}
</root>
[
Note that there is a good hint but the line, column and other data is wrong.SystemID:
Severity: error
Line:-1
Column:-1
EndLine:-1
EndColumn:-1
Length:0
Offset:-1
Message:com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -16002, SQLSTATE: 10505, SQLERRMC: =;n "1.0";
let $foo;:=]
Is this a problem with DB2 not returning good error messages of did I not configure oXyen correctly? Is there any way to get better error messages? This would make debugging long XQueries much easier.
Thanks - Dan
- Dan
-
- Posts: 4141
- Joined: Fri Mar 28, 2003 2:12 pm
Post by sorin_ristache »
Hello,
The JDBC driver for DB2 does not report the line and column of the error. It does not depend on how you configure the connection to the DB2 server. The error support must be improved in the DB2 driver in order to display the location in the error message in oXygen.
Regards,
Sorin
The JDBC driver for DB2 does not report the line and column of the error. It does not depend on how you configure the connection to the DB2 server. The error support must be improved in the DB2 driver in order to display the location in the error message in oXygen.
Regards,
Sorin
Jump to
- Oxygen XML Editor/Author/Developer
- ↳ Feature Request
- ↳ Common Problems
- ↳ DITA (Editing and Publishing DITA Content)
- ↳ SDK-API, Frameworks - Document Types
- ↳ DocBook
- ↳ TEI
- ↳ XHTML
- ↳ Other Issues
- Oxygen XML Web Author
- ↳ Feature Request
- ↳ Common Problems
- Oxygen Content Fusion
- ↳ Feature Request
- ↳ Common Problems
- Oxygen JSON Editor
- ↳ Feature Request
- ↳ Common Problems
- Oxygen PDF Chemistry
- ↳ Feature Request
- ↳ Common Problems
- Oxygen Feedback
- ↳ Feature Request
- ↳ Common Problems
- Oxygen XML WebHelp
- ↳ Feature Request
- ↳ Common Problems
- XML
- ↳ General XML Questions
- ↳ XSLT and FOP
- ↳ XML Schemas
- ↳ XQuery
- NVDL
- ↳ General NVDL Issues
- ↳ oNVDL Related Issues
- XML Services Market
- ↳ Offer a Service