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
     * @throws MalformedURLException
     */
    @Test
    public void prepared_statement_setters_77() throws SQLException, MalformedURLException {
        JenaConnection conn = this.getConnection();
        JenaPreparedStatement stmt = (JenaPreparedStatement) conn.prepareStatement("SELECT * WHERE { ?s ?p ? }");


        stmt.setObject(1, new URL("http://example"), Types.JAVA_OBJECT);
        ParameterizedSparqlString pss = stmt.getParameterizedString();
        Assert.assertTrue(pss.toString().contains("<http://example>"));


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

View Full Code Here

     * @throws MalformedURLException
     * @throws URISyntaxException
     */
    @Test
    public void prepared_statement_setters_78() throws SQLException, MalformedURLException, URISyntaxException {
        JenaConnection conn = this.getConnection();
        JenaPreparedStatement stmt = (JenaPreparedStatement) conn.prepareStatement("SELECT * WHERE { ?s ?p ? }");


        stmt.setObject(1, new URI("http://example"), Types.JAVA_OBJECT);
        ParameterizedSparqlString pss = stmt.getParameterizedString();
        Assert.assertTrue(pss.toString().contains("<http://example>"));


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

View Full Code Here

     * @throws SQLException
     * @throws MalformedURLException
     */
    @Test
    public void prepared_statement_setters_79() throws SQLException, MalformedURLException {
        JenaConnection conn = this.getConnection();
        JenaPreparedStatement stmt = (JenaPreparedStatement) conn.prepareStatement("SELECT * WHERE { ?s ?p ? }");


        Calendar c = Calendar.getInstance();
        stmt.setObject(1, c, Types.JAVA_OBJECT);
        ParameterizedSparqlString pss = stmt.getParameterizedString();
        Assert.assertTrue(pss.toString().contains(Integer.toString(c.get(Calendar.YEAR))));
        Assert.assertTrue(pss.toString().contains(XSDDatatype.XSDdateTime.getURI()));


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

View Full Code Here

     * @throws SQLException
     * @throws MalformedURLException
     */
    @Test
    public void prepared_statement_setters_80() throws SQLException, MalformedURLException {
        JenaConnection conn = this.getConnection();
        JenaPreparedStatement stmt = (JenaPreparedStatement) conn.prepareStatement("SELECT * WHERE { ?s ?p ? }");


        Calendar c = Calendar.getInstance();
        Date dt = new Date(c.getTimeInMillis());
        stmt.setObject(1, dt, Types.JAVA_OBJECT);
        ParameterizedSparqlString pss = stmt.getParameterizedString();
        Assert.assertTrue(pss.toString().contains(Integer.toString(c.get(Calendar.YEAR))));
        Assert.assertTrue(pss.toString().contains(XSDDatatype.XSDdateTime.getURI()));


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

View Full Code Here

     * @throws SQLException
     * @throws MalformedURLException
     */
    @Test
    public void prepared_statement_setters_81() throws SQLException, MalformedURLException {
        JenaConnection conn = this.getConnection();
        JenaPreparedStatement stmt = (JenaPreparedStatement) conn.prepareStatement("SELECT * WHERE { ?s ?p ? }");


        Calendar c = Calendar.getInstance();
        Time t = new Time(c.getTimeInMillis());
        stmt.setObject(1, t, Types.JAVA_OBJECT);
        ParameterizedSparqlString pss = stmt.getParameterizedString();
        Assert.assertTrue(pss.toString().contains(Integer.toString(c.get(Calendar.HOUR_OF_DAY))));
        Assert.assertTrue(pss.toString().contains(XSDDatatype.XSDtime.getURI()));


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

View Full Code Here

     * 
     * @throws SQLException
     */
    @Test
    public void prepared_statement_setters_82() throws SQLException {
        JenaConnection conn = this.getConnection();
        JenaPreparedStatement stmt = (JenaPreparedStatement) conn.prepareStatement("SELECT * WHERE { ?s ?p ? }");


        stmt.setObject(1, new Object(), Types.JAVA_OBJECT);


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

View Full Code Here

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


        try {
            stmt.executeUpdate("SELECT * WHERE {", new String[0]);
        } finally {
            stmt.close();
            conn.close();
        }
    }

View Full Code Here

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


        try {
            stmt.executeUpdate("DELETE WHERE { ?s ?p ?o }");
        } finally {
            stmt.close();
            conn.close();
        }
    }

View Full Code Here

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


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

View Full Code Here

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


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

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.