Dynamic Retrieve Columns

[rafaelwithoeft]

Hello, i want to "refresh" dynamicaly retrieved columns of data source sql. How i do it?
Like i click in retrieve columns in the designer, but i need it on java... Sample:

Code: Select all

report.getDictionary().getDataSource("xyz").retrieveColumns();

[Vadim]

Hello.
You can use next example for MySqlDatabase as first DB:

Code: Select all

StiJDBCDatabase jdb = (StiJDBCDatabase) report.getDictionary().getDatabases().get(0);
        StiJDBCParameters param = new StiMySqlAdapter(jdb.getConnectionString()).getJdbcParameters();
        Class.forName(param.getDriverName());
        Properties info = new Properties();
        info.setProperty("user", param.getUser());
        info.setProperty("password", param.getPassword());
        info.putAll(param.getOther());
        Connection con = DriverManager.getConnection(param.getConnectionURL(), info);
        StiTableFildsRequest request = StiDataColumnsUtil.getFields(con, "select * from customer");
        List<StiSqlField> fields = request.getColunns();
        for (StiSqlField field : fields) {
            report.getDictionary().getDataSources().get(0).getColumns().add(new StiDataColumn(field.getName(), field.getName(), field.getSystemType()));
        }

[rafaelwithoeft]

Thank you!

[Alex K.]

Hello,

We are always glad to help you!
Let us know if you need any additional help.

Thank you.