JuliaFarber
MIS
Hello!
BOE server 3.0 and Java RAS.
I tried to change database at runtime using the following code:
origTable = (IProcedure)tables.getTable(0);
newTable = (IProcedure)tables.getTable(0);
IConnectionInfo cnInfo = newTable.getConnectionInfo();
PropertyBag innerProp = cnInfo.getAttributes();
innerProp.clear();
PropertyBag propertyBag = new PropertyBag();
propertyBag.put("QE_DatabaseType","Oracle Server");
propertyBag.put("SSO Enabled",false);
propertyBag.put("Database DLL","crdb_oracle.dll");
propertyBag.put("QE_DatabaseName","");
propertyBag.put("QE_LogonProperties","{Trusted_Connection=false, SSOKEY=, Server="+psid+"}");
propertyBag.put("QE_SQLDB",true);
propertyBag.put("QE_ServerDescription",psid);
cnInfo.setAttributes(propertyBag);
cnInfo.setUserName(puser);
cnInfo.setPassword(ppwd);
cnInfo.setKind(ConnectionInfoKind.CRQE);
newTable.setConnectionInfo(cnInfo);
databaseController.setTableLocation(origTable, newTable);
An exception of Catstrophic Failure occurs on the setTableLocation.
What am I doing wrong?
Thank you.
Julia
BOE server 3.0 and Java RAS.
I tried to change database at runtime using the following code:
origTable = (IProcedure)tables.getTable(0);
newTable = (IProcedure)tables.getTable(0);
IConnectionInfo cnInfo = newTable.getConnectionInfo();
PropertyBag innerProp = cnInfo.getAttributes();
innerProp.clear();
PropertyBag propertyBag = new PropertyBag();
propertyBag.put("QE_DatabaseType","Oracle Server");
propertyBag.put("SSO Enabled",false);
propertyBag.put("Database DLL","crdb_oracle.dll");
propertyBag.put("QE_DatabaseName","");
propertyBag.put("QE_LogonProperties","{Trusted_Connection=false, SSOKEY=, Server="+psid+"}");
propertyBag.put("QE_SQLDB",true);
propertyBag.put("QE_ServerDescription",psid);
cnInfo.setAttributes(propertyBag);
cnInfo.setUserName(puser);
cnInfo.setPassword(ppwd);
cnInfo.setKind(ConnectionInfoKind.CRQE);
newTable.setConnectionInfo(cnInfo);
databaseController.setTableLocation(origTable, newTable);
An exception of Catstrophic Failure occurs on the setTableLocation.
What am I doing wrong?
Thank you.
Julia