COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "17" ("UNSUPPORTED FUNCTION"). SQLSTATE=08001
 Technote (troubleshooting)
 
Problem(Abstract)
When using IBM® WebSphere® Application Server V5 releases and using a data source to connect to a DB2® database, the Test Connection button succeeds, but the application is unable to get a connection to the database. The following exception is issued:

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "17" ("UNSUPPORTED FUNCTION"). SQLSTATE=08001

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(Unknown Source)
....
See the full stack trace in the attached error.log file.
 
Cause
One potential cause for this problem is not providing a Component-managed Authentication Alias for the data source, while the Resource Reference for the data source is created with Resource Authentication set to Application.
 
Resolving the problem
The problem can be solved in two ways.
  • Provide a Component-managed Authentication Alias for the data source.

    or

  • Change the Resource Reference Resource Authentication to Container using the Application Assembly Tool (AAT), the IBM Application Server Toolkit for WebSphere Application Server (Toolkit) or WebSphere Studio Application Developer.
 
error.log
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 5.1.1
Software edition:
Reference #: 1175255
IBM Group: Software Group
Modified date: Aug 16, 2004