Bugs item #1670732, was opened at 2007-02-28 12:05
Message generated for change (Comment added) made by mr-meltdown
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1670732&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/JDBC
Group: (zombie: Pathfinder 0.12.0)
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Wouter Alink (vzzzbx)
Assigned to: Fabian (mr-meltdown)
Summary: XQ/JDBC: escaping backslash
Initial Comment:
NOTE: this applies to 0.12. don't know whether it has been fixed in 0.16, but i
could not find an earlier bugreport about it. (please close if it was fixed)
When retrieving strings using the JDBC getString(1) from a ResultSet returned
after executing an XQuery, the backslashes have disappeared.
When querying using MapiClient the problem does not appear, so I guess the bug
should be somewhere in the JDBC code.
shred a document like:
<node>c:\tmp\</node>
when querying:
doc("test.xml")/node
and in java calling:
rs.next()
rs.getString(1)
will return (in 0.12):
<node>c:tmp</node>
----------------------------------------------------------------------
>Comment By: Fabian (mr-meltdown)
Date: 2007-02-28 14:40
Message:
Logged In: YES
user_id=963970
Originator: NO
Using the client I see some other stuff, so I guess your problem is deeper
under the hood.
(pegasus:portage/mail-client/mutt) fabian% JdbcClient -lxquery
Welcome to the MonetDB interactive JDBC terminal!
Type \q to quit, \h for a list of available commands
auto commit mode: on
monetdb-> 1 + 1
monetdb=>
<xquery>
<result>
<row>
<xml>2</xml>
</row>
</result>
</xquery>
monetdb-> 'bla'
monetdb=>
<xquery>
<result>
<row>
<xml>"bla"</xml>
</row>
</result>
</xquery>
Is it supposed to return " instead of ' here? Or no quote at all?
monetdb-> 'bl\\a'
monetdb=>
<xquery>
<result>
<row>
<xml>"bl\\a"</xml>
</row>
</result>
</xquery>
monetdb-> "bl\\a"
monetdb=>
<xquery>
<result>
<row>
<xml>"bl\\a"</xml>
</row>
</result>
</xquery>
monetdb->
monetdb-> 'b\a'
monetdb=>
<xquery>
<result>
<row>
<xml>"b\a"</xml>
</row>
</result>
</xquery>
monetdb->
backslashes seem to go well in this part. But I'm not sure on the quotes.
Could you generate a JDBC log please, and attach it for your application?
----------------------------------------------------------------------
Comment By: Fabian (mr-meltdown)
Date: 2007-02-28 13:49
Message:
Logged In: YES
user_id=963970
Originator: NO
I think the bug is as simple as the backslash not being escaped, but I'll
check to be sure.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1670732&group_id=56967
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs