tracker issue : CF-3186972

select a category, or use search below
(searches all categories and all time range)

Query of Queries targets wrong type4 jdbc driver

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Stijn Dreezen / Stijn Dreezen (Stijn Dreezen (Marburg))

Created: 05/10/2012

Components: Database

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: 9.0.1 / 286650

Priority/Frequency: Major / All users will encounter

Locale/System: English / Win XP All

Vote Count: 0

Problem Description: When defining at least 1 datasource of type 'other' with the org.lexicon.jdbc4sparql.SPARQLDriver jdbc driver, ALL coldfusion Query of Queries statements using any query result from any other type4 jdbc driver get 'hijacked by the sparql jdbc driver, resulting in an error.

Steps to Reproduce: Create at least one datasource of type other with the org.lexicon.jdbc4sparql.SPARQLDriver driver. Create at least one datasource of another type, in my case oracle.jdbc.driver.OracleDriver. Create a query against the oracle.jdbc.driver.OracleDriver driver. Perform a query of queries on the query you performed against the oracle.jdbc.driver.OracleDriver driver. This results in a java.sql.SQLException: unknown exception: Host name may not be null at org.lexicon.jdbc4sparql.SPARQLStatement error, while at no moment or place in the code, the org.lexicon.jdbc4sparql.SPARQLDriver is used nor any reference to this datasource is made. It is just enough to have the sparql jar included in the coldfusion lib or classpath, to redirect all the query of queries to this sparql datasource. It is not a sparql driver bug, the request should have never been passed to this driver by coldfusion in the first place, since it only involves the oracle jdbc driver.

Actual Result: error generated by the sparql (wrong) jdbc driver

Expected Result: result of query of queries on the intended driver

Any Workarounds: remove sparqk jdbc driver jar from classpath or lib. Resulting in disabling all requests to semantic RDF stores.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3186972

External Customer Info:
External Company:  
External Customer Name: Stijn Dreezen (Marburg)
External Customer Email:  
External Test Config: Coldfusion 9.0.1 standalone server on IIS with the jre provided with Coldfusion 9.0.1. All latest security patches installed. MAchine is windows XP XP SP although above error probably appears on Windows 2003 enterprise server too. Can not test it on coldfusion 10 beta, because I can not make the sparql type 4 jdbc driver work there.



website for type ' sparql jdbc driver:
Comment by External U.
19494 | May 10, 2012 03:11:53 AM GMT