This APAR addresses 3 issues as follows:
1) Adding support of the attribute OCI_ATTR_SPOOL_AUTH;
2) The function OCIAttrGet returns OCI_INVALID_HANDLE error
when retrieving statement type (OCI_ATTR_STMT_TYPE) with pooling
on for a statement prepared using ocistmtprepare2().
Below is the example of DB2CI trace entries you may see when the
issue occurs:
OCIAttrGet( hHandle=&2012e060, fHandleType="OCI_HTYPE_STMT",
pValue=&20019ece, pcbValue=<NULL pointer>, fAttribute="24",
hError=&20075ff0 )
---> Time elapsed - +1.024000E-003 seconds
OCIAttrGet( )
<--- OCI_INVALID_HANDLE Time elapsed - +1.292600E-002
seconds
3) When accessing a remote database and the initial connection
pool ran out, OCISessionGet function fails to allocate a new
session with the error - "[IBM][OCI Driver] SQL30082N Security
processing failed with reason "3" ("PASSWORD MISSING").
SQLSTATE=08001". The issue doesn't occur with a local database.
Below is the example of DB2CI trace entries you may see when the
issue occurs:
OCISessionGet( envhp=&23cf9150, errhp=&23dc3a40,
svchp=&23e34c7c, *svchp=<NULL pointer>, authInfop=<NULL
pointer>, dbName="DB2CISPOOL0", dbname_len=11, tagInfo=<NULL
pointer>, tagInfo_len=0, retTagInfo=&268bf52c,
retTagInfo_len=&268bf530, found=&268bf520, mode=1 )
---> Time elapsed - +1.104000E-003 seconds
OCISessionGet( svchp=<NULL pointer>, retTagInfo_len=0, found=0 )
<--- OCI_ERROR Time elapsed - +1.402910E-001 seconds
OCIErrorGet( hError=&23dc3a40, iIndex=1, sqlstate=<NULL
pointer>, sqlcode=&23e45638, message=&23e4564c,
message_length=512, fHandleType="OCI_HTYPE_ERROR" )
---> Time elapsed - +1.028000E-003 seconds
OCIErrorGet( sqlcode=-30082, message="[IBM][OCI Driver]
SQL30082N Security processing failed with reason "3" ("PASSWORD
MISSING"). SQLSTATE=08001
" ) |
