[
http://jira.nuxeo.org/browse/NXP-2093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=34111#action_34111
]
Florent Guillaume commented on NXP-2093:
----------------------------------------
When initializing, Jena sends (in Driver_MsSQL.graphIdAlloc) the following
query (the whole string in one PreparedStatement):
INSERT INTO jena_graph (Name) VALUES ('default')
SELECT @@IDENTITY
When using the MS JDBC driver (sqljdbc.jar 1.2.2828), this fails with:
com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not
return a result set.
(This works in two statements but would require changing Jena.)
When using the Open Source jTDS driver (http://jtds.sourceforge.net) then the
statement works.
And Jena works. And Nuxeo's use of Jena works.
> Make relations work with MS SQL Server
> --------------------------------------
>
> Key: NXP-2093
> URL: http://jira.nuxeo.org/browse/NXP-2093
> Project: Nuxeo Enterprise Platform 5
> Issue Type: New Feature
> Components: Relation Engine
> Affects Versions: 5.1.3.1
> Reporter: Alain Escaffre
> Assignee: Florent Guillaume
> Priority: Critical
> Fix For: 5.1.4
>
>
> The relation engine doesn't work for now when the data source is connected to
> a MS SQL database. Here is the describtion of how to connect to the MS SQL
> database (which was respected when testing)
> http://jena.sourceforge.net/DB/mssql-howto.html
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
