Hi Julien, Forgot to include my JDBC Driver version which is the same as yours as would be expected being from the repo:
[virtuoso@masala vos]# java -jar /2d2/git/virt-develop7/libsrc/JDBCDriverType4/virtjdbc4_1.jar OpenLink Virtuoso(TM) Driver for JDBC(TM) Version 4.1 [Build 3.70] My Java version is: [virtuoso@masala vos]# java -version java version "1.7.0_05-icedtea" OpenJDK Runtime Environment (rhel-2.2.1.el6_3-x86_64) OpenJDK 64-Bit Server VM (build 23.0-b21, mixed mode) What is your java version ? Out of interest does the same problem occur using the "virtjdbc4.jar" file ? Does the Virtuoso server actually shutdown and is any error reported in the virtuoso.log file ? Note you can turn tracing on on the server with "trace_on()" [1] to get extra information in the Virtuoso log as to what are the last operations being performed. You can also enable the "CallStackOnExcpetion"[2] INI file param to potentially obtained more detailed errors on the client side. Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ 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 [1] http://docs.openlinksw.com/virtuoso/fn_trace_on.html [2] http://docs.openlinksw.com/virtuoso/handlingplcondit.html#stacktracesql On 13 Jul 2014, at 01:30, Julien Plu <julien....@redaction-developpez.com> wrote: > Hi Hugh, > > No, I didn't recompile the JDBC driver, I use it as it is from the > repository, so here the same output than you but with the error : > > julien-plu@data:~$ javac -cp > "virtuoso-opensource/libsrc/JDBCDriverType4/virtjdbc4_1.jar:." Test.java > julien-plu@data:~$ java -cp > "virtuoso-opensource/libsrc/JDBCDriverType4/virtjdbc4_1.jar:." Test > virtuoso.jdbc4.VirtuosoException: Virtuoso Communications Link Failure > (timeout) : Connection to the server lost > at virtuoso.jdbc4.VirtuosoFuture.nextResult(VirtuosoFuture.java:63) > at > virtuoso.jdbc4.VirtuosoResultSet.process_result(VirtuosoResultSet.java:213) > at virtuoso.jdbc4.VirtuosoResultSet.<init>(VirtuosoResultSet.java:56) > at > virtuoso.jdbc4.VirtuosoPreparedStatement.<init>(VirtuosoPreparedStatement.java:33) > at > virtuoso.jdbc4.VirtuosoConnection.prepareStatement(VirtuosoConnection.java:738) > at > virtuoso.jdbc4.VirtuosoConnection.prepareStatement(VirtuosoConnection.java:676) > at virtuoso.jdbc4.VirtuosoConnection.<init>(VirtuosoConnection.java:173) > at virtuoso.jdbc4.Driver.connect(Driver.java:59) > at java.sql.DriverManager.getConnection(DriverManager.java:571) > at java.sql.DriverManager.getConnection(DriverManager.java:215) > at Test.main(Test.java:8) > julien-plu@data:~$ java -jar > virtuoso-opensource/libsrc/JDBCDriverType4/virtjdbc4_1.jar > OpenLink Virtuoso(TM) Driver for JDBC(TM) Version 4.1 [Build 3.70] > julien-plu@data:~$ cat Test.java > import java.sql.SQLException; > import java.sql.DriverManager; > import java.sql.Connection; > > public class Test { > public static void main(String[] args) { > try { > Connection conn = > DriverManager.getConnection("jdbc:virtuoso://localhost:1111/", "dba", "dba"); > } catch (SQLException ex) { > ex.printStackTrace(); > } > } > } > julien-plu@data:~$ isql-v > OpenLink Interactive SQL (Virtuoso), version 0.9849b. > Type HELP; for help and EXIT; to exit. > SQL> status(''); > Connected to OpenLink Virtuoso > Driver: 07.10.3211 OpenLink Virtuoso ODBC Driver > REPORT > VARCHAR > _______________________________________________________________________________ > > OpenLink Virtuoso Server > Version 07.10.3211-pthreads for Linux as of Jul 11 2014 > Started on: 2014-07-13 02:14 GMT+2 > > > ------------------------------------------------------------------------------------------------------------------------------- > Julien Plu > > PhD Student at Eurecom. > Personal webpage: http://jplu.developpez.com > FOAF file : http://jplu.developpez.com/julien > Email address : julien....@redaction-developpez.com > Phone : +33493008200 > Twitter : @julienplu > > > 2014-07-13 1:50 GMT+02:00 Hugh Williams <hwilli...@openlinksw.com>: > Hi Julien, > > So this is a JDBC program indicating the JDBC driver (virtjdbc4_1.jar) is > causing the issue, did you compile this from source also ? > > Running against the latest develop/7 build you sample program does run > without error for me: > > [virtuoso@masala vos]# javac -cp > "/2d2/git/virt-develop7/libsrc/JDBCDriverType4/virtjdbc4_1.jar:." Test.java > [virtuoso@masala vos]# java -cp > "/2d2/git/virt-develop7/libsrc/JDBCDriverType4/virtjdbc4_1.jar:." Test > [virtuoso@masala vos]# > [virtuoso@masala vos]# more Test.java > import java.sql.*; > import java.sql.DriverManager; > import java.sql.Connection; > > public class Test { > public static void main(String[] args) { > try { > Connection conn = > DriverManager.getConnection("jdbc:virtuoso://localhost:1234/", "dba", "dba"); > } catch (SQLException ex) { > ex.printStackTrace(); > } > } > } > > [root@masala vos]# > > [root@masala vos]# isql 1234 > Connected to OpenLink Virtuoso > Driver: 07.10.3211 OpenLink Virtuoso ODBC Driver > OpenLink Interactive SQL (Virtuoso), version 0.9849b. > Type HELP; for help and EXIT; to exit. > SQL> status(''); > REPORT > VARCHAR > _______________________________________________________________________________ > > OpenLink Virtuoso Server > Version 07.10.3211-pthreads for Linux as of Jul 12 2014 > Started on: 2014-07-13 01:14 GMT+2 > > Best Regards > Hugh Williams > Professional Services > OpenLink Software, Inc. // http://www.openlinksw.com/ > 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 11 Jul 2014, at 17:14, Julien Plu <julien....@redaction-developpez.com> > wrote: > >> Hi Hugh, >> >> I use virtjdbc4_1.jar : >> >> java -jar >> ~/.m2/repository/com/openlinksw/virtuoso/virtjdbc/4.1/virtjdbc-4.1.jar >> >> And for virtjena, I recompiled it myself, I just changed the Jena version >> from 2.10.1 to 2.11.2. The classpath line that I used looks like this : >> >> JENA_CLASSPATH = >> .:lib/junit-4.5.jar:lib/jena-arq-2.11.2.jar:lib/jena-iri-1.0.2.jar:lib/jena-core-2.11.2.jar:lib/jena-core-2.11.2-tests.jar:$(top_srcdir)/libsrc/JDBCDriverType4/virtjdbc4_1.jar:lib/jcl-over-slf4j-1.7.6.jar:lib/log4j-1.2.17.jar:lib/slf4j-api-1.7.6.jar:lib/slf4j-log4j12-1.7.6.jar:lib/xercesImpl-2.11.0.jar:lib/xml-apis-1.4.01.jar >> >> And here a really simple piece of code which doesn't works : >> >> import java.sql.DriverManager; >> import java.sql.Connection; >> >> public class Test { >> public static void main(String[] args) { >> try { >> Connection conn = >> DriverManager.getConnection("jdbc:virtuoso://localhost:1111/", "user", >> "pass"); >> } catch (SQLException ex) { >> ex.printStackTrace(); >> } >> } >> } >> >> I have the exception : >> >> Exception in thread "main" virtuoso.jdbc4.VirtuosoException: Communications >> Link Failure (timeout):Connection to the server lost >> >> Only on the Virtuoso instance from develop branch. >> >> Best. >> >> Julien. >> >> >> ------------------------------------------------------------------------------------------------------------------------------- >> Julien Plu >> >> PhD Student at Eurecom. >> Personal webpage: http://jplu.developpez.com >> FOAF file : http://jplu.developpez.com/julien >> Email address : julien....@redaction-developpez.com >> Phone : +33493008200 >> Twitter : @julienplu >> >> >> 2014-07-11 18:17 GMT+02:00 Hugh Williams <hwilli...@openlinksw.com>: >> >> Hi Julien, >> >> Where did you get the "OpenLink Virtuoso(TM) Provider for Jena(TM) Version >> 2.10.1 [Build 1.10]" virt_jena2.jar from as when I check the in the git >> stable and develop 7 branches the version is 1.9: >> >> [virtuoso@masala git]# java -jar virt-develop7/binsrc/jena2/virt_jena2.jar >> OpenLink Virtuoso(TM) Provider for Jena(TM) Version 2.10.1 [Build 1.9] >> [virtuoso@masala git]# java -jar virt-stable7/binsrc/jena2/virt_jena2.jar >> OpenLink Virtuoso(TM) Provider for Jena(TM) Version 2.10.1 [Build 1.9] >> >> and the JDBC Driver versions are: >> >> [virtuoso@masala git]# java -jar >> virt-stable7/libsrc/JDBCDriverType4/virtjdbc4.jar >> OpenLink Virtuoso(TM) Driver for JDBC(TM) Version 4.x [Build 3.65] >> [virtuoso@masala git]# java -jar >> virt-develop7/libsrc/JDBCDriverType4/virtjdbc4.jar >> OpenLink Virtuoso(TM) Driver for JDBC(TM) Version 4.x [Build 3.70] >> >> Also, if you could a compilable/runnable program it would be useful for >> recreation attempt ... >> >> Best Regards >> Hugh Williams >> Professional Services >> OpenLink Software, Inc. // http://www.openlinksw.com/ >> 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 11 Jul 2014, at 15:45, Julien Plu <julien....@redaction-developpez.com> >> wrote: >> >> > Hi Hugh, >> > >> > Apparently, yes, it appears with Jena and the Virtuoso wrapper. I have >> > also another problem with virtjena2, with my main Virtuoso instance >> > (Virtuoso 7.1 stable), I can connect me via JDBC without any problems, but >> > if I use another one (Virtuoso 7.1.1-dev, last version of the develo/7 >> > branch), the server disconnect me with the message : >> > >> > Malformed data received from IP [127.0.0.1] : Box length too large. >> > Disconnecting the client >> > >> > Here the versions that I use, for JDBC : >> > >> > OpenLink Virtuoso(TM) Driver for JDBC(TM) Version 4.1 [Build 3.70] >> > >> > For virtjena2 : >> > >> > OpenLink Virtuoso(TM) Provider for Jena(TM) Version 2.10.1 [Build 1.10] >> > >> > I use these same jars for the connection on my stable version and on my >> > develop version of Virtuoso. >> > >> > Is-it a bug of the develop version or I use these jars badly ? >> > >> > Best. >> > >> > Julien. >> > >> > >> > 2014-07-11 16:58 GMT+02:00 Hugh Williams <hwilli...@openlinksw.com>: >> > HI Julien, >> > >> > I see you reposted this question on the jena mailing list this I assume >> > the problem occurs with the Jena storage engine also and is thus most >> > likely in the Jena layer and Virtuoso ? >> > >> > Best Regards >> > Hugh Williams >> > Professional Services >> > OpenLink Software, Inc. // http://www.openlinksw.com/ >> > 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 11 Jul 2014, at 14:48, Julien Plu <julien....@redaction-developpez.com> >> > wrote: >> > >> >> Sorry a little mistake in the code : >> >> >> >> Model md = VirtModel.openDatabaseModel("http://example.com";, URL, USER, >> >> PASS); >> >> >> >> RDFDataMgr.read(md, Files.newInputStream(Paths. >> >> get("data.nq")), Lang.NQUADS); >> >> >> >> >> >> >> >> 2014-07-11 15:47 GMT+02:00 Julien Plu >> >> <julien....@redaction-developpez.com>: >> >> Hi, >> >> >> >> I'm trying to load a N-Quad file into Virtuoso but with the "virtjena" >> >> wrapper. What I'm doing is as simple as this : >> >> >> >> Model md = VirtModel.openDatabaseModel("http://example.com";, URL, USER, >> >> PASS); >> >> >> >> RDFDataMgr.read(md, >> >> Files.newInputStream(Paths.get(PrivacyDeployment.FILE)), Lang.NQUADS); >> >> >> >> But when I do this query inside the isql command prompt : >> >> >> >> SPARQL SELECT * FROM <http://example.com> WHERE {?s ?p ?o}; >> >> >> >> Nothing is provided to me, 0 rows. >> >> >> >> Do-I something badly ? >> >> >> >> Best. >> >> >> >> Julien. >> >> >> >> ------------------------------------------------------------------------------ >> >> Open source business process management suite built on Java and Eclipse >> >> Turn processes into business applications with Bonita BPM Community >> >> Edition >> >> Quickly connect people, data, and systems into organized workflows >> >> Winner of BOSSIE, CODIE, OW2 and Gartner awards >> >> http://p.sf.net/sfu/Bonitasoft_______________________________________________ >> >> Virtuoso-users mailing list >> >> Virtuoso-users@lists.sourceforge.net >> >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> > >> > >> >> >> ------------------------------------------------------------------------------ >> >> _______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > ------------------------------------------------------------------------------ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users ------------------------------------------------------------------------------ _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
