Hi Quenten, Sounds as if you are just seeing tables owned by the “dba” user, is this the user you are logging in as ? It would be interesting to see what call this tool is making to the Virtuoso server to obtain this information which can be done using the Virtuoso “trace_on()” function which writes addition information to the log file including the SQL calls being made, see:
http://docs.openlinksw.com/virtuoso/fn_trace_on.html
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 6 Mar 2012, at 07:22, Quentin Serrurier wrote:
> Hi,
>
> I'm connecting to Virtuoso via virtjdbc4.jar (OpenLink Virtuoso(TM) Driver
> for JDBC(TM) Version 4.x [Build 3.57]) from RapidMiner 5.2.001.
>
> I can access graphs using embedded SPARQL and that works ok if I hand-code
> the SQL but the integrated functions in RapidMiner have problems, they see
> DB/DBA/WS schema tables but only a subset of them and not any views that I
> create.
>
> I'm not at all sure that this is a Virtuoso problem but I am curious about
> why some tables are visible and not others. Is there anything that these
> tables have in common that would make them more accessible to a naive use of
> jdbc?
>
> The exposed tables:
> http://bayimg.com/FanimAaDb
> http://bayimg.com/gAniBaADB
>
> --
> Quentin | Clear Blue Water Pty Ltd
> [email protected]
> ------------------------------------------------------------------------------
> Keep Your Developer Skills Current with LearnDevNow!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-d2d_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
