Examples of DriverConnectionProvider

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

131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
       final String code = databaseMeta.getPluginId();
      final Map<String, String> map = databaseMeta.getExtraOptions();
      final Iterator<Map.Entry<String, String>> entryIterator = map.entrySet().iterator();

      final DriverConnectionProvider driverProvider = new DriverConnectionProvider();
      driverProvider.setDriver(databaseMeta.getDriverClass());
      driverProvider.setUrl(connectionInfo);
      while (entryIterator.hasNext())
      {
        final Map.Entry<String, String> entry = entryIterator.next();
        final String key = entry.getKey();
        final String realKey = key.substring(code.length() + 1);
        final String value = entry.getValue();
        if (DatabaseMeta.EMPTY_OPTIONS_STRING.equals(value))
        {
          driverProvider.setProperty(realKey, "");
        }
        else
        {
          driverProvider.setProperty(realKey, value);
        }
      }

      return driverProvider.createConnection(realUser, realPassword);
    }
    catch (Exception e)
    {
      throw new ReportDataFactoryException("Unable to create a connection", e);
    }
View Full Code Here

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

61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
   * @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

43
44
45
46
47
48
49
50
51
52
53
54
55
    URL resource = getClass().getResource("Prd-4843.prpt");
    MasterReport report = (MasterReport)
        new ResourceManager().createDirectly(resource, MasterReport.class).getResource();
    CompoundDataFactory dataFactory = (CompoundDataFactory) report.getDataFactory();
    SQLReportDataFactory dataFactory1 = (SQLReportDataFactory) dataFactory.get(0);
    DriverConnectionProvider conProv1 = (DriverConnectionProvider) dataFactory1.getConnectionProvider();
    Assert.assertEquals("abcdefghijk", conProv1.getProperty("user"));
    Assert.assertEquals("abcdefghijk", conProv1.getProperty("password"));
    SQLReportDataFactory dataFactory2 = (SQLReportDataFactory) dataFactory.get(1);
    DriverConnectionProvider conProv2 = (DriverConnectionProvider) dataFactory2.getConnectionProvider();
    Assert.assertEquals("abcdefghijkl", conProv2.getProperty("user"));
    Assert.assertEquals("abcdefghijkl", conProv2.getProperty("password"));
  }
View Full Code Here

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

56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
    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

56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
    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);
      if (name.toLowerCase().contains("password"))
      {
        xmlWriter.writeTextNormalized(PasswordEncryptionService.getInstance().encrypt(value), false);
View Full Code Here

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

88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
   *
   * @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

40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
    super(s);
  }

  public void testMetaDataDrc()
  {
    final DriverConnectionProvider drc = new DriverConnectionProvider();
    drc.setDriver("org.hsqldb.jdbcDriver");
    drc.setUrl("jdbc:hsqldb:mem:SampleData");
    drc.setProperty("user", "sa");
    drc.setProperty("password", "");
    final SQLReportDataFactory sqlReportDataFactory = new SQLReportDataFactory(drc);
    final DataFactoryMetaData metaData = sqlReportDataFactory.getMetaData();
    assertNull("No name property set, so display-name must be null",
        metaData.getDisplayConnectionName(sqlReportDataFactory));
    drc.setProperty("::pentaho-reporting::name", "test");
    assertEquals("Name property set, so display name must be test",
        "test", metaData.getDisplayConnectionName(sqlReportDataFactory));
    sqlReportDataFactory.setQuery("test", "SELECT * FROM TABLE");

    assertNotNull("QueryHash must exist",
        metaData.getQueryHash(sqlReportDataFactory, "test", new StaticDataRow()));

    final SQLReportDataFactory sqlReportDataFactory2 = new SQLReportDataFactory(drc);
    sqlReportDataFactory2.setQuery("test", "SELECT * FROM TABLE2");

    assertNotEquals("Physical Queries do not match, so query hash must be different",
        metaData.getQueryHash(sqlReportDataFactory, "test", new StaticDataRow()),
        (metaData.getQueryHash(sqlReportDataFactory2, "test", new StaticDataRow())));


    sqlReportDataFactory2.setQuery("test2", "SELECT * FROM TABLE");
    final Object qh1 = metaData.getQueryHash(sqlReportDataFactory, "test", new StaticDataRow());
    final Object qh2 = metaData.getQueryHash(sqlReportDataFactory2, "test2", new StaticDataRow());
    assertEquals("Physical Queries match, so queries are considered the same", qh1, qh2);

    final DriverConnectionProvider drc2 = new DriverConnectionProvider();
    drc.setDriver("org.hsqldb.jdbcDriver");
    drc.setUrl("jdbc:hsqldb:mem:SampleData2");
    drc.setProperty("user", "sa");
    drc.setProperty("password", "");
    final SQLReportDataFactory sqlReportDataFactory3 = new SQLReportDataFactory(drc2);
View Full Code Here

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

89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
        metaData.getQueryHash(sqlReportDataFactory3, "test2", new StaticDataRow()));
  }

  public void testParameterMetadata() throws ReportDataFactoryException
  {
    final DriverConnectionProvider drc = new DriverConnectionProvider();
    drc.setDriver("org.hsqldb.jdbcDriver");
    drc.setUrl("jdbc:hsqldb:mem:SampleData");
    drc.setProperty("user", "sa");
    drc.setProperty("password", "");
    final SQLReportDataFactory sqlReportDataFactory = new SQLReportDataFactory(drc);
    initializeDataFactory(sqlReportDataFactory);
    final DataFactoryMetaData metaData = sqlReportDataFactory.getMetaData();
    sqlReportDataFactory.setQuery("test", "SELECT * FROM TABLE WHERE p=${x}");
    String[] fields = metaData.getReferencedFields(sqlReportDataFactory, "test", new StaticDataRow());
View Full Code Here

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

136
137
138
139
140
141
142
143
144
145
146
147
148
149
    runTest(QUERIES_AND_RESULTS);
  }

  protected DataFactory createDataFactory(final String query)
  {
    final DriverConnectionProvider drc = new DriverConnectionProvider();
    drc.setDriver("org.hsqldb.jdbcDriver");
    drc.setUrl("jdbc:hsqldb:mem:SampleData");
    drc.setProperty("user", "sa");
    drc.setProperty("password", "");
    final SQLReportDataFactory sqlReportDataFactory = new SQLReportDataFactory(drc);
    sqlReportDataFactory.setQuery("default", query);
    return sqlReportDataFactory;
  }
View Full Code Here

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

226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
    assertEqualsArray(null, support.computeAdditionalQueryFields("test-script", new ParameterDataRow()));
    support.shutdown();
  }
 
  public void testPostProcessResult() 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 sqlReportDataFactory = new SQLReportDataFactory( driverConnectionProvider );

    sqlReportDataFactory.setQuery( "default", "SELECT Count(*) FROM CUSTOMERS", "Groovy",
        "import org.pentaho.reporting.engine.classic.core.util.TypedTableModel\n"
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.