Examples of DriverConnectionProvider


Examples of org.jfree.report.modules.data.sql.DriverConnectionProvider

   *
   * @throws SAXException       if there is a parsing error.
   */
  protected void doneParsing() throws SAXException
  {
    final DriverConnectionProvider provider = new DriverConnectionProvider();
    if (driverReadHandler != null)
    {
      provider.setDriver(driverReadHandler.getResult());
    }
    if (urlReadHandler != null)
    {
      provider.setUrl(urlReadHandler.getResult());
    }
    if (propertiesReadHandler != null)
    {
      final Properties p = (Properties) propertiesReadHandler.getObject();
      final Iterator it = p.entrySet().iterator();
      while (it.hasNext())
      {
        Map.Entry entry = (Map.Entry) it.next();
        provider.setProperty((String) entry.getKey(), (String) entry.getValue());
      }
    }
    driverConnectionProvider = provider;
  }
View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.DriverConnectionProvider

  }

  private boolean executeReport(final Object pvalue, final boolean mandatory)
      throws ReportDataFactoryException
  {
    final DriverConnectionProvider driverConnectionProvider = new DriverConnectionProvider();
    driverConnectionProvider.setDriver("org.hsqldb.jdbcDriver");
    driverConnectionProvider.setUrl("jdbc:hsqldb:mem:SampleData");
    driverConnectionProvider.setProperty("user", "sa");
    driverConnectionProvider.setProperty("password", "");
    final SQLReportDataFactory sdf = new SQLReportDataFactory(driverConnectionProvider);
    sdf.setQuery("default", "SELECT * FROM CUSTOMERS WHERE CUSTOMERNUMBER IN (${parameter})");
    sdf.setQuery("params", "SELECT DISTINCT CUSTOMERNUMBER FROM CUSTOMERS");
    sdf.open();

View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.DriverConnectionProvider

        }
        this.dataFactory = dataFactory;
      }
      else
      {
        final DriverConnectionProvider drc = new DriverConnectionProvider();
        drc.setUrl(selectedJNDIDataSourceReadHandler.getConnectionString());
        drc.setDriver(selectedJNDIDataSourceReadHandler.getDriverClass());
        drc.setProperty("user", selectedJNDIDataSourceReadHandler.getUsername());
        drc.setProperty("password", selectedJNDIDataSourceReadHandler.getPassword());
        drc.setProperty("::pentaho-reporting::name", selectedJNDIDataSourceReadHandler.getJndiName());

        final SQLReportDataFactory dataFactory = new SQLReportDataFactory(drc);
        for (int i = 0; i < queries.size(); i++)
        {
          final QueryReadHandler handler = (QueryReadHandler) queries.get(i);
View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.DriverConnectionProvider

   *
   * @throws SAXException if there is a parsing error.
   */
  protected void doneParsing() throws SAXException
  {
    final DriverConnectionProvider connectionProvider = new DriverConnectionProvider();
    connectionProvider.setDriver(driverClass);
    connectionProvider.setUrl(connectionString);
    connectionProvider.setProperty("user", userName);
    connectionProvider.setProperty("password", password);
    dataFactory = new SQLReportDataFactory(connectionProvider);
    dataFactory.setQuery("default", sqlQuery);
  }
View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.DriverConnectionProvider

    if (xmlWriter == null)
    {
      throw new NullPointerException();
    }

    final DriverConnectionProvider driverProvider =
        (DriverConnectionProvider) connectionProvider;

    final AttributeList rootAttribs = new AttributeList();
    if (xmlWriter.isNamespaceDefined(SQLDataFactoryModule.NAMESPACE) == false)
    {
      rootAttribs.addNamespaceDeclaration("data", SQLDataFactoryModule.NAMESPACE);
    }

    xmlWriter.writeTag
        (SQLDataFactoryModule.NAMESPACE, "connection", rootAttribs, XmlWriterSupport.OPEN);

    xmlWriter.writeTag
        (SQLDataFactoryModule.NAMESPACE, "driver", XmlWriterSupport.OPEN);
    xmlWriter.writeTextNormalized(driverProvider.getDriver(), false);
    xmlWriter.writeCloseTag();

    xmlWriter.writeTag
        (SQLDataFactoryModule.NAMESPACE, "url", XmlWriterSupport.OPEN);
    xmlWriter.writeTextNormalized(driverProvider.getUrl(), false);
    xmlWriter.writeCloseTag();

    xmlWriter.writeTag
        (SQLDataFactoryModule.NAMESPACE, "properties", XmlWriterSupport.OPEN);
    final String[] propertyNames = driverProvider.getPropertyNames();
    for (int i = 0; i < propertyNames.length; i++)
    {
      final String name = propertyNames[i];
      final String value = driverProvider.getProperty(name);
      xmlWriter.writeTag(SQLDataFactoryModule.NAMESPACE, "property", "name", name, XmlWriterSupport.OPEN);
      xmlWriter.writeTextNormalized(value, false);
      xmlWriter.writeCloseTag();
    }
    xmlWriter.writeCloseTag();
View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.DriverConnectionProvider

   *
   * @throws SAXException if there is a parsing error.
   */
  protected void doneParsing() throws SAXException
  {
    final DriverConnectionProvider provider = new DriverConnectionProvider();
    if (driverReadHandler != null)
    {
      provider.setDriver(driverReadHandler.getResult());
    }
    if (urlReadHandler != null)
    {
      provider.setUrl(urlReadHandler.getResult());
    }
    if (propertiesReadHandler != null)
    {
      final Properties p = (Properties) propertiesReadHandler.getObject();
      final Iterator it = p.entrySet().iterator();
      while (it.hasNext())
      {
        final Map.Entry entry = (Map.Entry) it.next();
        provider.setProperty((String) entry.getKey(), (String) entry.getValue());
      }
    }
    driverConnectionProvider = provider;
  }
View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.DriverConnectionProvider

    if (connectionProvider == null)
    {
      throw new NullPointerException();
    }

    final DriverConnectionProvider driverProvider =
        (DriverConnectionProvider) connectionProvider;
    xmlWriter.writeTag
        (SQLDataFactoryModule.NAMESPACE, "connection", XmlWriterSupport.OPEN);

    xmlWriter.writeTag
        (SQLDataFactoryModule.NAMESPACE, "driver", XmlWriterSupport.OPEN);
    xmlWriter.writeTextNormalized(driverProvider.getDriver(), false);
    xmlWriter.writeCloseTag();

    xmlWriter.writeTag
        (SQLDataFactoryModule.NAMESPACE, "url", XmlWriterSupport.OPEN);
    xmlWriter.writeTextNormalized(driverProvider.getUrl(), false);
    xmlWriter.writeCloseTag();

    xmlWriter.writeTag
        (SQLDataFactoryModule.NAMESPACE, "properties", XmlWriterSupport.OPEN);
    final String[] propertyNames = driverProvider.getPropertyNames();
    for (int i = 0; i < propertyNames.length; i++)
    {
      final String name = propertyNames[i];
      final String value = driverProvider.getProperty(name);
      xmlWriter.writeTag(SQLDataFactoryModule.NAMESPACE,
          "property", "name", name, XmlWriterSupport.OPEN);
      xmlWriter.writeTextNormalized(value, false);
      xmlWriter.writeCloseTag();
    }
View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.DriverConnectionProvider

   *
   * @return the data factory used with the report generator
   */
  public DataFactory getDataFactory()
  {
    final DriverConnectionProvider sampleDriverConnectionProvider = new DriverConnectionProvider();
    sampleDriverConnectionProvider.setDriver("org.hsqldb.jdbcDriver");
    sampleDriverConnectionProvider.setUrl("jdbc:hsqldb:./sql/sampledata");
    sampleDriverConnectionProvider.setProperty("user", "sa");
    sampleDriverConnectionProvider.setProperty("password", "");

    final SQLReportDataFactory dataFactory = new SQLReportDataFactory(sampleDriverConnectionProvider);
    dataFactory.setQuery(QUERY_NAME,
        "select CUSTOMERNAME, CITY, STATE, POSTALCODE, COUNTRY from CUSTOMERS order by UPPER(CUSTOMERNAME)");

View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.DriverConnectionProvider

   * @return the fully initialized JFreeReport object.
   * @throws ReportDefinitionException if an error occured preventing the report definition.
   */
  public MasterReport createReport() throws ReportDefinitionException
  {
    final DriverConnectionProvider drc = new DriverConnectionProvider();
    drc.setDriver("org.hsqldb.jdbcDriver");
    drc.setUrl("jdbc:hsqldb:./sql/sampledata");
    drc.setProperty("user", "sa");
    drc.setProperty("password", "");
    final SQLReportDataFactory sqlDataFactory = new SQLReportDataFactory(drc);
    sqlDataFactory.setQuery("default", "      SELECT\n" +
        "           QUADRANT_ACTUALS.REGION,\n" +
        "           QUADRANT_ACTUALS.DEPARTMENT,\n" +
        "           QUADRANT_ACTUALS.POSITIONTITLE,\n" +
View Full Code Here

Examples of org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.DriverConnectionProvider

        "CUSTOMERS.FIRST_NAME, CUSTOMERS.LAST_NAME, PRODUCTS.PRODUCT_NAME");
  }

  private static ConnectionProvider createDefaultProvider()
  {
    final DriverConnectionProvider drc = new DriverConnectionProvider();
    drc.setDriver("org.hsqldb.jdbcDriver");
    drc.setUrl("jdbc:hsqldb:mem:SampleData");
    drc.setProperty("user", "sa");
    drc.setProperty("password", "");
    return drc;
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.