Examples of XQConnection

javax.xml.xquery.XQConnection
in the XQuery datasource ... XQConnection conn = ds.getConnection(); XQPreparedExpression expr = conn.prepareExpression("for $i in ..."); XQResultSequence result = expr.executeQuery(); // - or - XQExpression expr = conn.createExpression(); XQSequence result = expr.executeQuery("for $i in.."); // The sequence can now be iterated while (result.next()) { String str = result.getItemAsString(); System.out.println(" output "+ str); } result.close(); expr.close(); conn.close(); // close the connection and free all resources.. A connection holds also default values for XQExpression and XQPreparedExpression properties. An application can override these defaults by passing an XQStaticContext object to the setStaticContext() method.
By default a connection operates in auto-commit mode, which means that each xquery is executed and committed in an individual transaction. If auto-commit mode is disabled, a transaction must be ended explicitly by the application calling commit() or rollback().
An XQConnection object can be created on top of an existing JDBC connection. If an XQConnection is created on top of the JDBC connection, it inherits the transaction context from the JDBC connection. Also, in this case, if the auto-commit mode is changed, or a transaction is ended using commit or rollback, it also changes the underlying JDBC connection.
An XQJ driver is not required to provide finalizer methods for the connection and other objects. Hence it is strongly recommended that users call close method explicitly to free any resources. It is also recommended that they do so under a final block to ensure that the object is closed even when there are exceptions. Not closing this object explicitly might result in serious memory leaks.
When the XQConnection is closed any XQExpression and XQPreparedExpression objects obtained from it are also implicitly closed.
org.pentaho.platform.plugin.services.connections.xquery.XQConnection
@author wseylerTODO To change the template for this generated type comment go to Window - Preferences - Java - Code Style - Code Templates

Examples of org.pentaho.platform.plugin.services.connections.xquery.XQConnection

    }
  }


  public void testExecuteQuery() throws Exception {


    XQConnection connection = new XQConnection();
    IPentahoResultSet data = connection.executeQuery( TEST_QUERY );
    assertNotNull( "result set is null", data );


    assertTrue( "result set is wrong type", data instanceof XQResultSet );


    assertFalse( "Should not be scrollable", data.isScrollable() );

View Full Code Here

Examples of org.pentaho.platform.plugin.services.connections.xquery.XQConnection

    data.closeConnection();
  }


  public void testExecuteWrongQuery() throws Exception {
    try {
      XQConnection connection = new XQConnection();
      StaticQueryContext mockContext = mock( StaticQueryContext.class );
      when( mockContext.compileQuery( TEST_QUERY ) ).thenThrow( new XPathException( "Test XPathException" ) );
      connection.sqc = mockContext;


      IPentahoResultSet data = connection.executeQuery( TEST_QUERY );
      fail( "Should throw XPathException" );
    } catch ( XPathException e ) {
      // valid
    }
  }

View Full Code Here

Examples of org.pentaho.platform.plugin.services.connections.xquery.XQConnection

      // valid
    }
  }


  public void testGetDataRow() throws Exception {
    XQConnection connection = new XQConnection();
    IPentahoResultSet data = connection.executeQuery( TEST_QUERY );
    assertNotNull( "result set is null", data );


    Object[] row = data.getDataRow( 1 );
    assertEquals( "Harry Potter", row[0] );
    assertEquals( "J K. Rowling", row[1] );

View Full Code Here

Examples of org.pentaho.platform.plugin.services.connections.xquery.XQConnection

    row = data.getDataRow( 99 );
    assertNull( row );
  }


  public void testGetDataColumn() throws Exception {
    XQConnection connection = new XQConnection();
    IPentahoResultSet data = connection.executeQuery( TEST_QUERY );
    assertNotNull( "result set is null", data );


    Object[] col = data.getDataColumn( 2 );
    assertEquals( "row count is wrong", 4, col.length );

View Full Code Here

Examples of org.pentaho.platform.plugin.services.connections.xquery.XQConnection

    assertNull( col );
  }


  public void testRowLimit() throws Exception {


    XQConnection connection = new XQConnection();
    connection.setMaxRows( 2 );
    IPentahoResultSet data = connection.executeQuery( TEST_QUERY );
    assertNotNull( "result set is null", data );


    assertTrue( "result set is wrong type", data instanceof XQResultSet );


    assertEquals( "row count is wrong", 2, data.getRowCount() );

View Full Code Here

Examples of org.pentaho.platform.plugin.services.connections.xquery.XQConnection

    assertNull( row );
  }


  public void testValueAt() throws Exception {


    XQConnection connection = new XQConnection();
    IPentahoResultSet data = connection.executeQuery( TEST_QUERY );
    assertNotNull( "result set is null", data );


    assertEquals( "2005", data.getValueAt( 0, 2 ) );
    assertEquals( "Everyday Italian", data.getValueAt( 0, 0 ) );

View Full Code Here

Examples of org.pentaho.platform.plugin.services.connections.xquery.XQConnection

    assertNull( data.getValueAt( 99, 0 ) );
    assertNull( data.getValueAt( 0, 99 ) );
  }


  public void testPeek() throws Exception {
    XQConnection connection = new XQConnection();
    IPentahoResultSet data = connection.executeQuery( TEST_QUERY );
    assertNotNull( "result set is null", data );


    assertTrue( "result set is wrong type", data instanceof XQResultSet );


    assertEquals( "row count is wrong", 4, data.getRowCount() );

View Full Code Here

Examples of org.pentaho.platform.plugin.services.connections.xquery.XQConnection

    assertEquals( 3, data.getValueAt( 2, 1 ) );
  }


  public void testXQConnectionExequtePreparedQuery() {
    try {
      XQConnection connection = new XQConnection();
      connection.prepareAndExecuteQuery( TEST_QUERY, ListUtils.EMPTY_LIST );
      fail( "Should throw UnsupportedOperationException" );
    } catch ( UnsupportedOperationException e ) {
      // valid
    } catch ( Exception e ) {
      fail( "Should throw UnsupportedOperationException" );

View Full Code Here

Examples of org.pentaho.platform.plugin.services.connections.xquery.XQConnection

    }
  }


  public void testXQConnectionConnect() {
    try {
      XQConnection connection = new XQConnection();
      ILogger mockLogger = mock( ILogger.class );
      connection.setLogger( mockLogger );


      Properties properties = null;
      boolean isConnected = connection.connect( properties );
      assertTrue( isConnected );


      properties = new Properties();
      isConnected = connection.connect( properties );
      assertTrue( isConnected );


      properties.setProperty( IPentahoConnection.QUERY_KEY, StringUtils.EMPTY );
      isConnected = connection.connect( properties );
      assertTrue( isConnected );


      properties.setProperty( IPentahoConnection.QUERY_KEY, TEST_QUERY );
      isConnected = connection.connect( properties );
      assertTrue( isConnected );


      StaticQueryContext mockContext = mock( StaticQueryContext.class );
      when( mockContext.compileQuery( TEST_QUERY ) ).thenThrow( new XPathException( "Test XPathException" ) );
      connection.sqc = mockContext;


      isConnected = connection.connect( properties );
      assertFalse( isConnected );
    } catch ( Exception e ) {
      e.printStackTrace();
      fail( "Should not throw Exception" );
    }

View Full Code Here

0 1 2

TOP

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.