Examples with JenaConnection org.apache.jena.jdbc.connections.JenaConnection used on opensource projects

Example 11 with JenaConnection

use of org.apache.jena.jdbc.connections.JenaConnection in project jena by apache.

the class AbstractJenaStatementTests method prepared_statement_setters_02.

/**
     * Tests that the various set methods of {@link JenaPreparedStatement}
     * function correctly
     * 
     * @throws SQLException
     */
@Test
public void prepared_statement_setters_02() throws SQLException {
    JenaConnection conn = this.getConnection();
    JenaPreparedStatement stmt = (JenaPreparedStatement) conn.prepareStatement("SELECT * WHERE { ?s ?p ? }");
    stmt.setObject(1, 123);
    ParameterizedSparqlString pss = stmt.getParameterizedString();
    Assert.assertTrue(pss.toString().contains("123"));
    stmt.close();
    conn.close();
}

Example 12 with JenaConnection

use of org.apache.jena.jdbc.connections.JenaConnection in project jena by apache.

the class AbstractJenaStatementTests method prepared_statement_setters_58.

/**
     * Tests that the various set methods of {@link JenaPreparedStatement}
     * function correctly
     * 
     * @throws SQLException
     */
@Test
public void prepared_statement_setters_58() throws SQLException {
    JenaConnection conn = this.getConnection();
    JenaPreparedStatement stmt = (JenaPreparedStatement) conn.prepareStatement("SELECT * WHERE { ?s ?p ? }");
    Calendar c = Calendar.getInstance();
    stmt.setObject(1, NodeFactoryExtra.dateTimeToNode(c), Types.TIME);
    ParameterizedSparqlString pss = stmt.getParameterizedString();
    Assert.assertTrue(pss.toString().contains(Integer.toString(c.get(Calendar.HOUR_OF_DAY))));
    stmt.close();
    conn.close();
}

Example 13 with JenaConnection

use of org.apache.jena.jdbc.connections.JenaConnection in project jena by apache.

the class AbstractJenaStatementTests method prepared_statement_setters_55.

/**
     * Tests that the various set methods of {@link JenaPreparedStatement}
     * function correctly
     * 
     * @throws SQLException
     */
@Test
public void prepared_statement_setters_55() throws SQLException {
    JenaConnection conn = this.getConnection();
    JenaPreparedStatement stmt = (JenaPreparedStatement) conn.prepareStatement("SELECT * WHERE { ?s ?p ? }");
    stmt.setObject(1, (byte) 123, Types.SMALLINT);
    ParameterizedSparqlString pss = stmt.getParameterizedString();
    Assert.assertTrue(pss.toString().contains("123"));
    Assert.assertTrue(pss.toString().contains(XSDDatatype.XSDshort.getURI()));
    stmt.close();
    conn.close();
}

Example 14 with JenaConnection

use of org.apache.jena.jdbc.connections.JenaConnection in project jena by apache.

the class AbstractJenaStatementTests method prepared_statement_setters_62.

/**
     * Tests that the various set methods of {@link JenaPreparedStatement}
     * function correctly
     * 
     * @throws SQLException
     */
@Test
public void prepared_statement_setters_62() throws SQLException {
    JenaConnection conn = this.getConnection();
    JenaPreparedStatement stmt = (JenaPreparedStatement) conn.prepareStatement("SELECT * WHERE { ?s ?p ? }");
    stmt.setObject(1, NodeFactory.createLiteral("123", XSDDatatype.XSDbyte), Types.TINYINT);
    ParameterizedSparqlString pss = stmt.getParameterizedString();
    Assert.assertTrue(pss.toString().contains("123"));
    Assert.assertTrue(pss.toString().contains(XSDDatatype.XSDbyte.getURI()));
    stmt.close();
    conn.close();
}

Example 15 with JenaConnection

use of org.apache.jena.jdbc.connections.JenaConnection in project jena by apache.

the class AbstractJenaStatementTests method statement_warnings_02.

/**
     * Check warnings usage
     * 
     * @throws SQLException
     */
@Test
public void statement_warnings_02() throws SQLException {
    JenaConnection conn = this.getConnection();
    JenaStatement stmt = (JenaStatement) conn.createStatement();
    Assert.assertNull(stmt.getWarnings());
    stmt.setWarning("Test");
    Assert.assertNotNull(stmt.getWarnings());
    stmt.clearWarnings();
    Assert.assertNull(stmt.getWarnings());
    stmt.close();
    conn.close();
}