Examples of org.apache.jena.jdbc.connections.JenaConnection

Package org.apache.jena.jdbc.connections

Examples of org.apache.jena.jdbc.connections.JenaConnection

org.apache.jena.jdbc.connections.JenaConnection
Abstract base implementation of a Jena JDBC connection
Generally speaking this is a faithful implementation of a JDBC connection but it also provides a couple of Jena JDBC specific features:
1. JDBC compatibility level
2. Command pre-processors
The JDBC compatibility level allows the API to behave slightly differently depending on how JDBC like you need it to be, see {@link JdbcCompatibility}for more discussion on this.

Command pre-processors are an extension mechanism designed to allow Jena JDBC connections to cope with the fact that the tools consuming the API may be completely unaware that we speak SPARQL rather than SQL. They allow for manipulation of incoming command text as well as manipulation of the parsed SPARQL queries and updates as desired.

     * 
     * @throws SQLException
     */
    @Test(expected = SQLException.class)
    public void statememt_readonly_execute_update_04() throws SQLException {
        JenaConnection conn = this.getConnection();
        Statement stmt = conn.createStatement();
        conn.setReadOnly(true);


        try {
            stmt.executeUpdate("DELETE WHERE { ?s ?p ?o }", new String[0]);
        } finally {
            stmt.close();
            conn.close();
        }
    }

View Full Code Here

     * 
     * @throws SQLException
     */
    @Test
    public void statement_settings_01() throws SQLException {
        JenaConnection conn = this.getConnection();
        Statement stmt = conn.createStatement();


        Assert.assertEquals(0, stmt.getMaxRows());
        stmt.setMaxRows(10);
        Assert.assertEquals(10, stmt.getMaxRows());
        stmt.setMaxRows(-1);
        Assert.assertEquals(0, stmt.getMaxRows());


        stmt.close();
        conn.close();
    }

View Full Code Here

     * 
     * @throws SQLException
     */
    @Test
    public void statement_settings_02() throws SQLException {
        JenaConnection conn = this.getConnection();
        Statement stmt = conn.createStatement();


        Assert.assertEquals(0, stmt.getMaxFieldSize());


        // Max field size is ignored
        stmt.setMaxFieldSize(100);
        Assert.assertEquals(0, stmt.getMaxFieldSize());


        stmt.close();
        conn.close();
    }

View Full Code Here

     * 
     * @throws SQLException
     */
    @Test
    public void statement_settings_03() throws SQLException {
        JenaConnection conn = this.getConnection();
        Statement stmt = conn.createStatement();


        Assert.assertEquals(0, stmt.getFetchSize());
        stmt.setFetchSize(10);
        Assert.assertEquals(10, stmt.getFetchSize());


        stmt.close();
        conn.close();
    }

View Full Code Here

     * 
     * @throws SQLException
     */
    @Test
    public void statement_settings_04() throws SQLException {
        JenaConnection conn = this.getConnection();
        Statement stmt = conn.createStatement();


        Assert.assertTrue(stmt.isPoolable());


        // Poolable setting is ignored
        stmt.setPoolable(false);
        Assert.assertTrue(stmt.isPoolable());


        stmt.close();
        conn.close();
    }

View Full Code Here

     * 
     * @throws SQLException
     */
    @Test
    public void statement_settings_05() throws SQLException {
        JenaConnection conn = this.getConnection();
        Statement stmt = conn.createStatement();


        Assert.assertEquals(0, stmt.getQueryTimeout());
        stmt.setQueryTimeout(10);
        Assert.assertEquals(10, stmt.getQueryTimeout());
        stmt.setQueryTimeout(-1);
        Assert.assertEquals(0, stmt.getQueryTimeout());


        stmt.close();
        conn.close();
    }

View Full Code Here

     * 
     * @throws SQLException
     */
    @Test(expected = SQLFeatureNotSupportedException.class)
    public void statement_settings_06() throws SQLException {
        JenaConnection conn = this.getConnection();
        Statement stmt = conn.createStatement();


        Assert.assertEquals(ResultSet.FETCH_FORWARD, stmt.getFetchDirection());
        stmt.setFetchDirection(ResultSet.FETCH_FORWARD);
        Assert.assertEquals(ResultSet.FETCH_FORWARD, stmt.getFetchDirection());
        try {
            stmt.setFetchDirection(ResultSet.FETCH_REVERSE);
        } finally {
            stmt.close();
            conn.close();
        }
    }

View Full Code Here

     * 
     * @throws SQLException
     */
    @Test
    public void statement_settings_07() throws SQLException {
        JenaConnection conn = this.getConnection();
        Statement stmt = conn.createStatement();


        stmt.setEscapeProcessing(true);


        stmt.close();
        conn.close();
    }

View Full Code Here

     * 
     * @throws SQLException
     */
    @Test(expected = SQLFeatureNotSupportedException.class)
    public void statement_settings_08() throws SQLException {
        JenaConnection conn = this.getConnection();
        Statement stmt = conn.createStatement();


        try {
            stmt.setCursorName("test");
        } finally {
            stmt.close();
            conn.close();
        }
    }

View Full Code Here

     * 
     * @throws SQLException
     */
    @Test
    public void statement_metadata_01() throws SQLException {
        JenaConnection conn = this.getConnection();
        Statement stmt = conn.createStatement();


        Assert.assertEquals(ResultSet.TYPE_FORWARD_ONLY, stmt.getResultSetType());
        Assert.assertEquals(conn.getHoldability(), stmt.getResultSetHoldability());
        Assert.assertEquals(ResultSet.CONCUR_READ_ONLY, stmt.getResultSetConcurrency());
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.jena.jdbc.connections.JenaConnection

org.apache.jena.jdbc.AbstractJenaDriverTests

org.apache.jena.jdbc.JenaDriver

org.apache.jena.jdbc.metadata.results.AbstractDatabaseMetadataTests

org.apache.jena.jdbc.statements.AbstractJenaStatementTests

org.apache.jena.jdbc.statements.JenaStatement

java.sql.SQLRecoverableException

java.sql.SQLWarning

java.sql.SQLException

java.sql.SQLFeatureNotSupportedException

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.