On 10/21/16 5:36 PM, Davis, Daniel (NIH/NLM) [C] wrote:
>
> So, I must run my application through a source code scanner, and it is
> reasonably complaining that I am using String.format() and
> stmt.executeQuery(query) with the Virtuoso JDBC connection.
>
>  
>
> Yet, this is SPARQL.   I see some discussion of prepared statements on
> this list in the past.   What I want to know is:
>
> ·        What is the best way to get this to work at all?
>
> ·        Is there any way I can bind a parameter whose value includes
> a PREFIX in the query?    Something like stmt.setString(1, “mesh:D20189”);
>
>  
>
> Dan Davis, Systems/Applications Architect (Contractor),
>
> Office of Computer and Communications Systems,
>
> National Library of Medicine, NIH
>
>  
>

I assume your query is of the form:

SPARQL

{SPARQL-Query}


OR

SELECT {SELECT-LIST}

FROM {SPARQL {SPARQL-QUERY} } AS {SQL Tabular Relation ALIAS} .


[1] http://bit.ly/sparql-as-sql-tabular-relation -- SPARQL Query as SQL
Tabular Relation (note: user "vdb" for user and pwd) in FROM CLAUSE

[2] http://bit.ly/sparql-as-sql-tabular-relation2 -- SPARQL Query as SQL
Tabular Relation

-- 
Regards,

Kingsley Idehen       
Founder & CEO 
OpenLink Software   (Home Page: http://www.openlinksw.com)

Weblogs (Blogs):
Legacy Blog: http://www.openlinksw.com/blog/~kidehen/
Blogspot Blog: http://kidehen.blogspot.com
Medium Blog: https://medium.com/@kidehen

Profile Pages:
Pinterest: https://www.pinterest.com/kidehen/
Quora: https://www.quora.com/profile/Kingsley-Uyi-Idehen
Twitter: https://twitter.com/kidehen
Google+: https://plus.google.com/+KingsleyIdehen/about
LinkedIn: http://www.linkedin.com/in/kidehen

Web Identities (WebID):
Personal: http://kingsley.idehen.net/dataspace/person/kidehen#this
        : 
http://id.myopenlink.net/DAV/home/KingsleyUyiIdehen/Public/kingsley.ttl#this

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to