Problem Note 14725: SAS Email Server unable to use JDBC to access DB2, MYSQL or Oracle
The SAS Email Server is unable to use JDBC to connect to Oracle, MYSql
or DB2 when creating audit records. The system will produce an error
similar to:
[NOTE@2005-02-09 20:53:40.323] Starting execution of "Static Test
Broadcast" broadcast (Moniker="Broadcast_1107974957751").
[NOTE@2005-02-09 20:53:40.433] Reading [NL19467.CONTACT_DETAILS].
com.ibm.db2.jcc.b.SqlException: Invalid operation: result set closed
at com.ibm.db2.jcc.b.rc.mb(rc.java:3413)
at com.ibm.db2.jcc.b.rc.q(rc.java:1339)
at com.ibm.db2.jcc.b.rc.getMetaData(rc.java:1331)
at com.sas.email.render.RenderUtils.convertDataToXML(Unknown
Source)
at com.sas.email.render.RenderData.getObservations(Unknown
Source)
at com.sas.email.server.BulkEmailStaticExecution.run(Unknown
Source)
[NOTE@2005-02-09 20:53:40.523] Done executing "Static Test Broadcast"
A fix for this issue is available at:
http://www.sas.com/techsup/download/hotfix/bes112.html#014725
Operating System and Release Information
| SAS System | SAS Digital Marketing | Microsoft Windows XP Professional | 1.1.2 | 2.1 | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Microsoft Windows 2000 Professional | 1.1.2 | 2.1 | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Microsoft Windows 2000 Server | 1.1.2 | 2.1 | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Microsoft Windows NT Workstation | 1.1.2 | 2.1 | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Microsoft Windows 2000 Datacenter Server | 1.1.2 | 2.1 | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Linux | 1.1.2 | 2.1 | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| Microsoft Windows 2000 Advanced Server | 1.1.2 | 2.1 | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| HP-UX | 1.1.2 | 2.1 | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| 64-bit Enabled HP-UX | 1.1.2 | 2.1 | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| 64-bit Enabled AIX | 1.1.2 | 2.1 | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
| AIX | 1.1.2 | 2.1 | 9.1 TS1M3 | 9.1 TS1M3 SP2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2005-03-16 21:59:55 |
| Date Created: | 2005-03-08 11:19:55 |
