I am getting the following stack trace error on all my reports:
03-25 07:55:42 ERROR [TP-Processor8] (datainterface:?) - Failed to open connection (Connection: databaseType=JDBC (JNDI) serverName=jdbc:oracle:thin:@pabaix08:1521:CRCP state=closed databaseDriverName=crdb_jdbc.dll).
com.crystaldecisions.reports.queryengine.bl: Logon Error: Null user or password not supported in THIN driver
I saw a previous post about this error and it stated that you get it when a userid/password is not associated with the ConnectionInfos object, but here is my database connection code for all reports:
PropertyBag propertyBag = new PropertyBag();
propertyBag.put("Server Name", "pabaix08");
propertyBag.put("URI", "!oracle.jdbc.OracleDriver!jdbc:oracle:thin:/@pabaix08:1521:crcp");
oIconnectionInfo.setUserName("crcuser");
oIconnectionInfo.setPassword("crcuser1");
propertyBag.put("Connection String",ConnStr);
propertyBag.put("Server Type", "JDBC (JNDI)");
propertyBag.put("Database Class Name", driver);
propertyBag.put("Database DLL", "crdb_jdbc.dll");
PropertyBag bag = new PropertyBag();
bag.put(PropertyBagHelper.CONNINFO_CRQE_LOGONPROPERTIES, propertyBag);
bag.put(PropertyBagHelper.CONNINFO_CRQE_DATABASETYPE, "JDBC (JNDI)");
bag.put(PropertyBagHelper.CONNINFO_DATABASE_DLL ,"crdb_jdbc.dll");
oIconnectionInfo.setAttributes(bag);
oConnectionInfos.add(oIconnectionInfo);
The reports are running for the most part, but the export functionality is not working and seems to take as long to export a report as it did to run it originally. Very glitchy this API it seems, we've been having troubles getting it to perform reliably, so I'm hoping it's a configuration issue or something. Any help would be vastly appreciated!
Thanks,
Mike