Examples of virtuoso.jdbc2.VirtuosoResultSet

virtuoso.jdbc3.VirtuosoResultSet
The VirtuosoResultSet class is an implementation of the ResultSet interface in the JDBC API which represents result of a query. You can obtain a ResultSet like below :
```
 ResultSet rs = statement.executeQuery("SELECT * FROM TABLE ...") 
```
@version 1.0 (JDBC API 2.0 implementation) @see java.sql.ResultSet @see virtuoso.jdbc2.VirtuosoStatement @see virtuoso.jdbc2.VirtuosoPreparedStatement @see virtuoso.jdbc2.VirtuosoCallableStatement

  query = "SPARQL " + query;


  try
  {
      java.sql.Statement stmt = connection.createStatement();
      VirtuosoResultSet results = (VirtuosoResultSet) stmt.executeQuery(query);


      ResultSetMetaData data = results.getMetaData();
      String[] col_names = new String[data.getColumnCount()];


      for(int meta_count = 0; meta_count < data.getColumnCount(); meta_count++)
      {
    col_names[meta_count] = data.getColumnLabel(meta_count + 1);
      }


      listener.startTableQueryResult (col_names);


      while (results.next())
      {
    listener.startTuple();
    for(int meta_count = 1;meta_count <= data.getColumnCount();meta_count++)
    {
        String col = data.getColumnName(meta_count);
        String value = results.getString(col);
        Value v = parseValue(value);
        listener.tupleValue(v);
    }
    listener.endTuple ();
      }

View Full Code Here

  StringBuffer query = new StringBuffer();
  query.append("SELECT distinct RP_NAME, RP_ID from DB.DBA.RDF_PREFIX");
  try
  {
      java.sql.Statement stmt = this.connection.createStatement();
      VirtuosoResultSet results = (VirtuosoResultSet) stmt.executeQuery(query.toString());
      ResultSetMetaData data = results.getMetaData();


      // begin at onset one
      while (results.next())
      {
    String name = null;
    String prefix = null;
    for (int meta_count = 1; meta_count <= data.getColumnCount(); meta_count++)
    {
        // TODO need to parse these into appropriate resource values
        String col = data.getColumnName(meta_count);
        if(col.equals("RP_ID"))
        {
      name = results.getString(col);
        }
        else if(col.equals("RP_NAME"))
        {
      prefix = results.getString(col);
        }
    }
    if(name != null && prefix != null)
    {
        org.openrdf.sesame.sailimpl.memory.Namespace ns =  new org.openrdf.sesame.sailimpl.memory.Namespace(prefix, name, false);

View Full Code Here

  query = "SPARQL " + query;


  try
  {
      java.sql.Statement stmt = connection.createStatement();
      VirtuosoResultSet results = (VirtuosoResultSet) stmt.executeQuery(query);


      ResultSetMetaData data = results.getMetaData();
      String[] col_names = new String[data.getColumnCount()];


      while (results.next())
      {
    listener.startGraphQueryResult();
    for (int meta_count = 1; meta_count <= data.getColumnCount(); meta_count++)
    {
        String col = data.getColumnName(meta_count);
        String value = results.getString(col);
        Value v = parseValue(value);
        listener.triple(null, null, null); // TODO find out how to interpret Virtuoso CONSTRUCT query
    }
    listener.endGraphQueryResult();
      }

View Full Code Here

TOP

Related Classes of virtuoso.jdbc2.VirtuosoResultSet

virtuoso.sesame.driver.VirtuosoRepository

java.util.ListIterator

java.sql.Connection

javax.sql.ConnectionEvent

java.sql.SQLClientInfoException

java.text.DateFormat

java.text.SimpleDateFormat

java.sql.SQLException

java.sql.ResultSet

java.util.Properties

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.