[
https://issues.apache.org/jira/browse/JENA-408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13632875#comment-13632875
]
Simon Helsen commented on JENA-408:
-----------------------------------
yes, perhaps it was a bit too quick. The alternative is to avoid these combined
statements but that requires more work as you need some datastructure to pass
around multiple SQL statements.Note: we investigated the use of SDB for a
special use-case, but abandoned this approach after all because SDB is just too
slow especially for updates. So for us, this defect has become less important.
> SDB should not attempt to execute multiple update statements in one jdbc
> statement
> ----------------------------------------------------------------------------------
>
> Key: JENA-408
> URL: https://issues.apache.org/jira/browse/JENA-408
> Project: Apache Jena
> Issue Type: Bug
> Components: SDB
> Affects Versions: SDB 1.3.6
> Reporter: Simon Helsen
> Fix For: SDB 1.3.6
>
> Attachments: patch.txt
>
>
> Some of the db providers (I noticed in db2, but there may be others) attempt
> to execute update statements by separating them with a semi-colon. This is
> not supported by the jdbc spec and most jdbc drivers won't be able to handle
> this correctly.
> I am not entirely sure why such statements are present in SDB but I suspect
> that old jdbc 3 drivers for db2 permitted this. The fix is relatively simple
> and a patch is being attached
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
