sql

JDBC connection to Virtuoso under LOG4JDBC and DBCP

Submitted by admin on Wed, 02/24/2016 - 12:25

I started to use Apache DBCP because I stumbled upon this error when I was running thousands of SQL queries.

virtuoso.jdbc4.VirtuosoException: Connection failed: Cannot assign requested address

THE SOLUTION

For initial settings, please check this previous post here

DBCP (Database Connection Pools) is described here

JDBC connection to Virtuoso under LOG4JDBC

Submitted by admin on Wed, 02/24/2016 - 12:09

In the following I describe two ways to connect. You must have already checked this page for more information.

http://docs.openlinksw.com/virtuoso/VirtuosoDriverJDBC.html

The JDBC driver is available under the folder

/usr/local/src/virtuoso-opensource/libsrc/JDBCDriverType4

assuming you have already cloned the git repository from here

https://github.com/openlink/virtuoso-opensource