HI Ted
I don't use the JRC component from within Eclipse at all. The JRC component is used in a standlone java app and the datasource for the report is modified at runtime to use JDBC. Its not just a case of refreshing the report (if you mean keep the same DB information and refresh the data)<br/>
<br/>
The code is below but is heavily based on the examples provided on the website.
<br/>
<br/>
private final void setSQLServerConnectionInfo(DatabaseController databaseController) throws ReportSDKException {
Tables tables = (Tables) databaseController.getDatabase().getTables().clone(true);
//Set the datasource for all main report tables.
for (int i = 0; i < tables.size(); i++) {
ITable table = tables.getTable(i);
//Keep existing name and alias.
table.setName(table.getName());
table.setAlias(table.getAlias());
//Change properties that are different from the original datasource.
table.setQualifiedName(this.spcEnvironment.getEnvConnectionDetails().getUsername() + ".dbo." + table.getName());
PropertyBag propertyBag = new PropertyBag();
final String CONNECTION_STRING = "Use JDBC=b(true);Connection URL=s(" + this.spcEnvironment.getEnvConnectionDetails().getUrl() + ");" +
"Database Class Name=s(" + this.spcEnvironment.getEnvConnectionDetails().getDriver() + ");Server=s();" +
"User ID=s(retail);Password=;Database=s(retail);Trusted_Connection=b(false);" +
"JDBC Connection String=s(!" + this.spcEnvironment.getEnvConnectionDetails().getDriver() + "!" + this.spcEnvironment.getEnvConnectionDetails().getUrl() + ";" +
"DatabaseName={database};user={userid};password={password}!)";
propertyBag.put("Trusted_Connection", "false");
//propertyBag.put("Server Name", ""); //Optional property.
propertyBag.put("Connection String", CONNECTION_STRING);
propertyBag.put("Database Name", this.spcEnvironment.getEnvConnectionDetails().getUsername());
propertyBag.put("Server Type", "JDBC (JNDI)");
propertyBag.put("URI", "!" + this.spcEnvironment.getEnvConnectionDetails().getDriver() + "!" + this.spcEnvironment.getEnvConnectionDetails().getUrl() + ";DatabaseName={database};user={userid};password={password}!");
propertyBag.put("JDBC Connection String", "!" + this.spcEnvironment.getEnvConnectionDetails().getDriver() + "!" + this.spcEnvironment.getEnvConnectionDetails().getUrl() + ";DatabaseName={database};user={userid};password={password}!");
propertyBag.put("Use JDBC", "true");
propertyBag.put("Database DLL", "crdb_jdbc.dll");
propertyBag.put("PreQEServerName", this.spcEnvironment.getEnvConnectionDetails().getUrl() + ";DatabaseName={database};");
propertyBag.put("Server", SPCCore.getServerAddress().getHostName());
//Change connection information properties.
IConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.setAttributes(propertyBag);
//Set database username and password.
//NOTE: Even if these the username and password properties don't change when switching databases, the
//database password is *not* saved in the report and must be set at runtime if the database is secured.
connectionInfo.setUserName(this.spcEnvironment.getEnvConnectionDetails().getUsername());
connectionInfo.setPassword(this.spcEnvironment.getEnvConnectionDetails().getPassword());
connectionInfo.setKind(ConnectionInfoKind.SQL);
table.setConnectionInfo(connectionInfo);
//Update old table in the report with the new table.
databaseController.setTableLocation(table, tables.getTable(i));
}
databaseController.getDatabase().setTables(tables);
}
<br/>
regards
Rick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.