seba4 Respected Contributor.
Respected Contributor.
684 views

JDBC - PROCEDURE execute - Connection problem

Hi i couldn't find any information about this topic, but i am having a problem with JDBC driver where PROCEDURES sometimes are executed correctly and sometimes it fails. I have managed to find a pattern and i i think i can determine what could be a problem, but i am not sure how to solve it.

I had 2 almost identical events passed to SHIM, where one event tried to use existing database connection (fails) and then second event opened new connection to database.(worked)

Error i am receiving:

<status event-id="oslsec015_524-NDS#20181205075943#2#1:a7814342-ce6b-429b-90ae-5f213dc79699" level="error" type="app-general">
<description>Unable to obtain value(s) from stored procedure 'IDE.PACK_INTNET_IDAM.MODIFY_USER'. Unable to retrieve statement results.</description>
<jdbc:exception jdbc:class="java.lang.NullPointerException"/>
<jdbc:document xml:space="preserve"><nds dtdversion="4.0" ndsversion="8.x">
<source>
<product edition="Advanced" version="4.7.0.0">DirXML</product>
<contact>NetIQ Corporation</contact>
</source>


Does anyone have experience with something simillar or some idea what could be done to solve it.





1st Test: LOGS when event is passed to SHIM: (not working)

Intnet DEV ST:Stripping operation data from input document
Intnet DEV ST:Acquired lock on connection 'dedicated0'.
Intnet DEV ST:CALLING Connection.getAutoCommit():boolean
Intnet DEV ST:CALLED
Intnet DEV ST:BEGIN Call stored procedure 'IDE.PACK_INTNET_IDE.MODIFY_USER'.
Intnet DEV ST:{call IDE.PACK_INTNET_IDE.MODIFY_USER(?,?,?,?,?,?,?,?,?,?)}
Intnet DEV ST:BEGIN Set IN, Register OUT parameter(s).
Intnet DEV ST: IN @ index 1, param 'PI_USERNAME', field '$1', length: 5, value = 'BEBOE'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 1
Intnet DEV ST: WITH PARAM 2: 'BEBOE'
Intnet DEV ST:CALLED
Intnet DEV ST: IN @ index 2, param 'PI_FIRST_NAME', field '$2', length: 7, value = 'Bouchra'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 2
Intnet DEV ST: WITH PARAM 2: 'Bouchra'
Intnet DEV ST:CALLED
Intnet DEV ST: IN @ index 3, param 'PI_LAST_NAME', field '$3', length: 9, value = 'Ejtrie'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 3
Intnet DEV ST: WITH PARAM 2: 'Ejtrie'
Intnet DEV ST:CALLED
Intnet DEV ST: IN @ index 4, param 'PI_FULL_NAME', field '$4', length: 15, value = 'Bouchra Ejjabri'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 4
Intnet DEV ST: WITH PARAM 2: 'Bouchra Ejjabri'
Intnet DEV ST:CALLED
Intnet DEV ST: IN @ index 5, param 'PI_ACCESSRIGHT', field '$5', length: 1, value = '2'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 5
Intnet DEV ST: WITH PARAM 2: '2'
Intnet DEV ST:CALLED
Intnet DEV ST: IN @ index 6, param 'PI_PRINT_FORMAT', field '$6', length: 2, value = 'A4'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 6
Intnet DEV ST: WITH PARAM 2: 'A4'
Intnet DEV ST:CALLED
Intnet DEV ST: IN @ index 7, param 'PI_EMAIL_ADDRESS', field '$7', length: 26, value = 'someone.test@test.si'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 7
Intnet DEV ST: WITH PARAM 2: 'someone.test@test.si'
Intnet DEV ST:CALLED
Intnet DEV ST: OUT @ index 8, param 'PO_STATUS', field '$8'
Intnet DEV ST:CALLING CallableStmt.registerOutParameter(int, int)
Intnet DEV ST: WITH PARAM 1: 8
Intnet DEV ST: WITH PARAM 2: java.sql.Types.DECIMAL
Intnet DEV ST:CALLED
Intnet DEV ST: OUT @ index 9, param 'PO_USERNAME', field '$9'
Intnet DEV ST:CALLING CallableStmt.registerOutParameter(int, int)
Intnet DEV ST: WITH PARAM 1: 9
Intnet DEV ST: WITH PARAM 2: java.sql.Types.VARCHAR
Intnet DEV ST:CALLED
Intnet DEV ST: OUT @ index 10, param 'PO_MESSAGE', field '$10'
Intnet DEV ST:CALLING CallableStmt.registerOutParameter(int, int)
Intnet DEV ST: WITH PARAM 1: 10
Intnet DEV ST: WITH PARAM 2: java.sql.Types.VARCHAR
Intnet DEV ST:CALLED
Intnet DEV ST:END Set IN, Register OUT parameter(s).
Intnet DEV ST:BEGIN Execute procedure.
Intnet DEV ST:CALLING CallableStatement.execute()
Intnet DEV ST:CALLED
Intnet DEV ST:END Execute procedure.
Intnet DEV ST:BEGIN Get OUT parameter values.
Intnet DEV ST:CALLING CallableStatement.getBigDecimal(int, int)
Intnet DEV ST: WITH PARAM 1: 8
Intnet DEV ST: WITH PARAM 2: 0
Intnet DEV ST:CALLED
Intnet DEV ST:RETURNED VALUE: 0
Intnet DEV ST: OUT @ index 8, param 'PO_STATUS', field '$8', value = 0
Intnet DEV ST:CALLING CallableStatement.getString(int)
Intnet DEV ST: WITH PARAM 1: 9
Intnet DEV ST:CALLED
Intnet DEV ST:RETURNED VALUE: BEBOE
Intnet DEV ST: OUT @ index 9, param 'PO_USERNAME', field '$9', length: 5, value = 'BEBOE'
Intnet DEV ST:CALLING CallableStatement.getString(int)
Intnet DEV ST: WITH PARAM 1: 10
Intnet DEV ST:CALLED
Intnet DEV ST:RETURNED VALUE: null
Intnet DEV ST: OUT @ index 10, param 'PO_MESSAGE', field '$10', value = null
Intnet DEV ST:END Get OUT parameter values.
Intnet DEV ST:CALLING Statement.getUpdateCount()
Intnet DEV ST:BEGIN rollback.
Intnet DEV ST:ROLLBACK
Intnet DEV ST:CALLING Connection.rollback()
Intnet DEV ST:CALLED
Intnet DEV ST:END rollback.
Intnet DEV ST:Number of statements allocated on connection 'dedicated0': 2.
Intnet DEV ST:Restoring operation data to output document
Intnet DEV ST:SubscriptionShim.execute() returned:
Intnet DEV ST:




2nd Test: LOGS when event is passed to SHIM: (working)

Intnet DEV ST:Stripping operation data from input document
Intnet DEV ST:Connecting to database...
Intnet DEV ST:BEGIN Open connection 'dedicated0'.
Intnet DEV ST: BEGIN Instantiate connection.
Intnet DEV ST: CALLING DriverManager.getConnection(String, String, String)
Intnet DEV ST: WITH PARAM 1: jdbc:oracle:thin:@osldbsntest.lhc4net.lhc.com:1521:sntest
Intnet DEV ST: WITH PARAM 2: IDE
Intnet DEV ST: WITH PARAM 3: <!-- content suppressed -->
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: oracle.jdbc.driver.T4CConnection@19cc279d
Intnet DEV ST: Allocated connection 19cc279d.
Intnet DEV ST: END Instantiate connection.
Intnet DEV ST:END Open connection.
Intnet DEV ST:Connected to database.
Intnet DEV ST:Metadata has not been retrieved.
Intnet DEV ST:Retrieving database metadata
Intnet DEV ST:BEGIN Get database properties.
Intnet DEV ST: CALLING DatabaseMetaData Connection.getMetaData()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: oracle.jdbc.driver.OracleDatabaseMetaData@257877ab
Intnet DEV ST: Database name: Oracle
Intnet DEV ST: Database version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Intnet DEV ST: JDBC driver name: Oracle JDBC driver
Intnet DEV ST: JDBC driver version: 11.2.0.3.0
Intnet DEV ST: JDBC driver major version: 11
Intnet DEV ST: JDBC driver minor version: 2
Intnet DEV ST: CALLING DatabaseMetaData.storesLowerCaseIdentifiers()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: false
Intnet DEV ST: CALLING DatabaseMetaData.storesMixedCaseIdentifiers()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: false
Intnet DEV ST: CALLING DatabaseMetaData.storesUpperCaseIdentifiers()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: CALLING DatabaseMetaData.storesLowerCaseQuotedIdentifiers()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: false
Intnet DEV ST: CALLING DatabaseMetaData.storesMixedCaseQuotedIdentifiers()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: CALLING DatabaseMetaData.storesUpperCaseQuotedIdentifiers()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: false
Intnet DEV ST: Case sensitive: false
Intnet DEV ST: Stored case: upper
Intnet DEV ST: Association case: upper
Intnet DEV ST: Quoted Identifier case: mixed
Intnet DEV ST: CALLING DatabaseMetaData.getUserName()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: IDE
Intnet DEV ST: Username: 'IDE'
Intnet DEV ST: CALLING DatabaseMetaData.getTableTypes()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: oracle.jdbc.driver.OracleResultSetImpl@542bf700
Intnet DEV ST: Allocated result set 542bf700.
Intnet DEV ST: CALLING ResultSet.getString(int)
Intnet DEV ST: WITH PARAM 1: TABLE_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: SYNONYM
Intnet DEV ST: CALLING ResultSet.getString(int)
Intnet DEV ST: WITH PARAM 1: TABLE_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: TABLE
Intnet DEV ST: CALLING ResultSet.getString(int)
Intnet DEV ST: WITH PARAM 1: TABLE_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: VIEW
Intnet DEV ST: CALLING ResultSet.close()
Intnet DEV ST: CALLED
Intnet DEV ST: Closed result set 542bf700.
Intnet DEV ST: Supported table types: ["SYNONYM", "TABLE"]
Intnet DEV ST: Supported view types: ["SYNONYM", "VIEW"]
Intnet DEV ST: Supports views: true
Intnet DEV ST: CALLING DatabaseMetaData.getMaxColumnsInSelect()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: Maximum number of columns in select statement: unknown/unlimited
Intnet DEV ST: CALLING DatabaseMetaData.getMaxConnections()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: Maximum number of connections: unknown/unlimited
Intnet DEV ST: CALLING DatabaseMetaData.getMaxStatements()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: Maximum number of open statements: unknown/unlimited
Intnet DEV ST: CALLING DatabaseMetaData.supportsTransactions()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: Supports transactions: true
Intnet DEV ST: CALLING DatabaseMetaData.supportsMultipleTransactions()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: Supports multiple transactions over multiple connections: true
Intnet DEV ST: CALLING DatabaseMetaData.supportsDataDefinitionAndDataManipulationTransactions()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: Supports mixed DML And DDL transactions: true
Intnet DEV ST: CALLING DatabaseMetaData.supportsDataManipulationTransactionsOnly()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: Supports only DML transactions: true
Intnet DEV ST: CALLING DatabaseMetaData.dataDefinitionCausesTransactionCommit()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: DDL statement in transaction forces commit: true
Intnet DEV ST: CALLING DatabaseMetaData.dataDefinitionIgnoredInTransaction()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: false
Intnet DEV ST: DDL statement ignored in transactions: false
Intnet DEV ST: CALLING DatabaseMetaData.supportsSchemasInDataManipulation()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: Supports schema qualifiers in DML statements: true
Intnet DEV ST: CALLING DatabaseMetaData.supportsSchemasInSPs
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: Supports schema qualifiers in procedure calls: true
Intnet DEV ST: CALLING DatabaseMetaData.supportsLikeEscapeClause()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: Supports LIKE escape clauses: true
Intnet DEV ST: CALLING DatabaseMetaData.getSearchStringEscape()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: /
Intnet DEV ST: Wildcard escape character: /
Intnet DEV ST: CALLING DatabaseMetaData.supportsBatchUpdates()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: Supports batch updates: true
Intnet DEV ST: CALLING DatabaseMetaData.supportsGetGeneratedKeys()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: Supports retrieval of auto-generated keys: true
Intnet DEV ST: CALLING DatabaseMetaData.supportsLimitedOuterJoins
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: Supports limited outer joins: true
Intnet DEV ST: CALLING DatabaseMetaData.supportsColumnAliasing()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: true
Intnet DEV ST: Supports column aliasing: true
Intnet DEV ST: Database major version: 12
Intnet DEV ST: Database minor version: 2
Intnet DEV ST: Searching for database descriptor file matching the runtime database.
Intnet DEV ST: Searching all descriptors.
Intnet DEV ST: Loading database descriptor file '_oracle.xml'.
Intnet DEV ST: Applying imports to driver descriptor '_oracle_jdbc.xml'.
Intnet DEV ST: Applying import '_oracle.xml'.
Intnet DEV ST:
<database>
<identity>
<name>Oracle</name>
<regex-name>.*oracle.*</regex-name>
</identity>
<options>
<!--
10g supports CURRENT_TIMESTAMP, but precision
to seconds is good enough
-->
<current-timestamp-stmt>SELECT (SYSDATE) FROM SYS.DUAL</current-timestamp-stmt>
<left-outer-join-operator>(+)</left-outer-join-operator>
<!--
filter out obituaried tables in Oracle 10g;
(e.g., "BIN$9nH9KGKxSaa1nxyvxbpUtA==$0")
-->
<exclude-table-filter>BIN\$.{22}==\$0</exclude-table-filter>
<lock-generator-class>com.novell.nds.dirxml.driver.jdbc.db.lock.OraLockGenerator</lock-generator-class>
</options>
</database>
Intnet DEV ST: Runtime descriptor:
Intnet DEV ST:
<jdbc-driver>
<identity>
<name>Oracle JDBC</name>
<jdbc-class>oracle.jdbc.driver.OracleDriver</jdbc-class>
</identity>
<sql-type-map>
<type>
<from>91</from>
<to>93</to>
</type>
</sql-type-map>
<options>
<handle-stmt-results>single</handle-stmt-results>
<left-outer-join-operator>(+)</left-outer-join-operator>
<exclude-table-filter>BIN\$.{22}==\$0</exclude-table-filter>
<current-timestamp-stmt>SELECT (SYSDATE) FROM SYS.DUAL</current-timestamp-stmt>
<lock-generator-class>com.novell.nds.dirxml.driver.jdbc.db.lock.OraLockGenerator</lock-generator-class>
</options>
<errors>
<connectivity>
<regular-expression>
<value>.*ORA-03135.*</value>
</regular-expression>
<regular-expression>
<value>.*ORA-12505.*</value>
</regular-expression>
<regular-expression>
<value>.*ORA-12528.*</value>
</regular-expression>
<sql-state-class>
<value>08</value>
</sql-state-class>
<error-code>
<value>1033</value>
</error-code>
<error-code>
<value>3135</value>
</error-code>
<error-code>
<value>17002</value>
</error-code>
<error-code>
<value>17410</value>
</error-code>
<error-code>
<value>17430</value>
</error-code>
<actions>
<check-for-closed-connection/>
<rollback/>
<fetch-metadata/>
</actions>
</connectivity>
<retry/>
<authentication>
<error-code>
<value>1017</value>
</error-code>
<error-code>
<value>1045</value>
</error-code>
<error-code>
<value>17433</value>
</error-code>
</authentication>
<fatal>
<error-code>
<value>1000</value>
</error-code>
<error-code>
<value>17080</value>
</error-code>
</fatal>
</errors>
</jdbc-driver>
Intnet DEV ST: Parameter: 'reuse-statements' Value: true
Intnet DEV ST: Parameter: 'left-outer-join-operator' Value: '(+)'
Intnet DEV ST: Parameter: 'add-default-values-on-view-insert' Value: false
Intnet DEV ST: Parameter: 'current-timestamp-stmt' Value: 'SELECT (SYSDATE) FROM SYS.DUAL'
Intnet DEV ST: Parameter: 'include-table-filter' Value: '.*'
Intnet DEV ST: Parameter: 'exclude-table-filter' Value: 'BIN\$.{22}==\$0'
Intnet DEV ST: Parameter: 'function-return-method' Value: 'dynamic'
Intnet DEV ST: Parameter: 'use-manual-transactions' Value: true
Intnet DEV ST: Parameter: 'minimal-metadata' Value: false
Intnet DEV ST: Parameter: 'handle-stmt-results' Value: 'single'
Intnet DEV ST: Parameter: 'transaction-isolation-level' Value: 'read committed'
Intnet DEV ST: Parameter: 'use-single-connection' Value: false
Intnet DEV ST: Parameter: 'time-translator-class' Value: 'public com.novell.nds.dirxml.driver.jdbc.db.DBTimestamp(java.lang.String,java.lang.String,java.lang.String,java.lang.String)'
Intnet DEV ST: Parameter: 'supports-schemas-in-metadata-retrieval' Value: true
Intnet DEV ST: Parameter: 'lock-generator-class' Value: 'class com.novell.nds.dirxml.driver.jdbc.db.lock.OraLockGenerator'
Intnet DEV ST: Parameter: 'connection-properties' Value: ''
Intnet DEV ST:END Get database properties.
Intnet DEV ST:Retrieved database metadata.
Intnet DEV ST:BEGIN Set transaction isolation level.
Intnet DEV ST: CALLING Connection.getTransactionIsolation()
Intnet DEV ST: CALLED
Intnet DEV ST: Transaction isolation level: read committed
Intnet DEV ST:END Set transaction isolation level.
Intnet DEV ST:Acquired lock on connection 'dedicated0'.
Intnet DEV ST:Interpreting filter.
Intnet DEV ST:Fetching metadata for routine 'IDE.PACK_Intnet_IDE.MODIFY_USER'.
Intnet DEV ST:BEGIN Get metadata for procedure/function 'IDE.PACK_Intnet_IDE.MODIFY_USER'.
Intnet DEV ST: CALLING DatabaseMetaData Connection.getMetaData()
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: oracle.jdbc.driver.OracleDatabaseMetaData@257877ab
Intnet DEV ST: CALLING ResultSet DatabaseMetaData.getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)
Intnet DEV ST: WITH PARAM 1: PACK_Intnet_IDE
Intnet DEV ST: WITH PARAM 2: IDE
Intnet DEV ST: WITH PARAM 3: MODIFY_USER
Intnet DEV ST: WITH PARAM 4: null
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED RESULT: oracle.jdbc.driver.OracleResultSetImpl@41eb4cad
Intnet DEV ST: Allocated result set 41eb4cad.
Intnet DEV ST: CALLING boolean ResultSet.next()
Intnet DEV ST: CALLED boolean ResultSet.next()
Intnet DEV ST: RETURNED RESULT: true
Intnet DEV ST: CALLING String ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: PI_USERNAME
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: DATA_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 12
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: TYPE_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: VARCHAR2
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: PRECISION
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 8
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: SCALE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: CALLING String ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: NULLABLE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: REMARKS
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: null
Intnet DEV ST: BEGIN Column.
Intnet DEV ST: Name: 'PI_USERNAME'
Intnet DEV ST: SQL Type: java.sql.Types.VARCHAR
Intnet DEV ST: Native Type: VARCHAR2
Intnet DEV ST: Parameter Type: IN
Intnet DEV ST: Length: 8
Intnet DEV ST: Position: 1
Intnet DEV ST: Nullable: YES
Intnet DEV ST: END Column.
Intnet DEV ST: CALLING boolean ResultSet.next()
Intnet DEV ST: CALLED boolean ResultSet.next()
Intnet DEV ST: RETURNED RESULT: true
Intnet DEV ST: CALLING String ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: PI_FIRST_NAME
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: DATA_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 12
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: TYPE_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: VARCHAR2
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: PRECISION
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 35
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: SCALE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: CALLING String ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: NULLABLE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: REMARKS
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: null
Intnet DEV ST: BEGIN Column.
Intnet DEV ST: Name: 'PI_FIRST_NAME'
Intnet DEV ST: SQL Type: java.sql.Types.VARCHAR
Intnet DEV ST: Native Type: VARCHAR2
Intnet DEV ST: Parameter Type: IN
Intnet DEV ST: Length: 35
Intnet DEV ST: Position: 2
Intnet DEV ST: Nullable: YES
Intnet DEV ST: END Column.
Intnet DEV ST: CALLING boolean ResultSet.next()
Intnet DEV ST: CALLED boolean ResultSet.next()
Intnet DEV ST: RETURNED RESULT: true
Intnet DEV ST: CALLING String ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: PI_LAST_NAME
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: DATA_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 12
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: TYPE_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: VARCHAR2
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: PRECISION
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 35
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: SCALE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: CALLING String ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: NULLABLE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: REMARKS
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: null
Intnet DEV ST: BEGIN Column.
Intnet DEV ST: Name: 'PI_LAST_NAME'
Intnet DEV ST: SQL Type: java.sql.Types.VARCHAR
Intnet DEV ST: Native Type: VARCHAR2
Intnet DEV ST: Parameter Type: IN
Intnet DEV ST: Length: 35
Intnet DEV ST: Position: 3
Intnet DEV ST: Nullable: YES
Intnet DEV ST: END Column.
Intnet DEV ST: CALLING boolean ResultSet.next()
Intnet DEV ST: CALLED boolean ResultSet.next()
Intnet DEV ST: RETURNED RESULT: true
Intnet DEV ST: CALLING String ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: PI_FULL_NAME
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: DATA_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 12
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: TYPE_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: VARCHAR2
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: PRECISION
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 35
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: SCALE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: CALLING String ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: NULLABLE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: REMARKS
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: null
Intnet DEV ST: BEGIN Column.
Intnet DEV ST: Name: 'PI_FULL_NAME'
Intnet DEV ST: SQL Type: java.sql.Types.VARCHAR
Intnet DEV ST: Native Type: VARCHAR2
Intnet DEV ST: Parameter Type: IN
Intnet DEV ST: Length: 35
Intnet DEV ST: Position: 4
Intnet DEV ST: Nullable: YES
Intnet DEV ST: END Column.
Intnet DEV ST: CALLING boolean ResultSet.next()
Intnet DEV ST: CALLED boolean ResultSet.next()
Intnet DEV ST: RETURNED RESULT: true
Intnet DEV ST: CALLING String ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: PI_ACCESSRIGHT
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: DATA_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 12
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: TYPE_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: VARCHAR2
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: PRECISION
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: SCALE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: CALLING String ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: NULLABLE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: REMARKS
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: null
Intnet DEV ST: BEGIN Column.
Intnet DEV ST: Name: 'PI_ACCESSRIGHT'
Intnet DEV ST: SQL Type: java.sql.Types.VARCHAR
Intnet DEV ST: Native Type: VARCHAR2
Intnet DEV ST: Parameter Type: IN
Intnet DEV ST: Length: 1
Intnet DEV ST: Position: 5
Intnet DEV ST: Nullable: YES
Intnet DEV ST: END Column.
Intnet DEV ST: CALLING boolean ResultSet.next()
Intnet DEV ST: CALLED boolean ResultSet.next()
Intnet DEV ST: RETURNED RESULT: true
Intnet DEV ST: CALLING String ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: PI_PRINT_FORMAT
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: DATA_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 12
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: TYPE_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: VARCHAR2
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: PRECISION
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 10
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: SCALE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: CALLING String ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: NULLABLE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: REMARKS
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: null
Intnet DEV ST: BEGIN Column.
Intnet DEV ST: Name: 'PI_PRINT_FORMAT'
Intnet DEV ST: SQL Type: java.sql.Types.VARCHAR
Intnet DEV ST: Native Type: VARCHAR2
Intnet DEV ST: Parameter Type: IN
Intnet DEV ST: Length: 10
Intnet DEV ST: Position: 6
Intnet DEV ST: Nullable: YES
Intnet DEV ST: END Column.
Intnet DEV ST: CALLING boolean ResultSet.next()
Intnet DEV ST: CALLED boolean ResultSet.next()
Intnet DEV ST: RETURNED RESULT: true
Intnet DEV ST: CALLING String ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: PI_EMAIL_ADDRESS
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: DATA_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 12
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: TYPE_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: VARCHAR2
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: PRECISION
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 100
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: SCALE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: CALLING String ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: NULLABLE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: REMARKS
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: null
Intnet DEV ST: BEGIN Column.
Intnet DEV ST: Name: 'PI_EMAIL_ADDRESS'
Intnet DEV ST: SQL Type: java.sql.Types.VARCHAR
Intnet DEV ST: Native Type: VARCHAR2
Intnet DEV ST: Parameter Type: IN
Intnet DEV ST: Length: 100
Intnet DEV ST: Position: 7
Intnet DEV ST: Nullable: YES
Intnet DEV ST: END Column.
Intnet DEV ST: CALLING boolean ResultSet.next()
Intnet DEV ST: CALLED boolean ResultSet.next()
Intnet DEV ST: RETURNED RESULT: true
Intnet DEV ST: CALLING String ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: PO_STATUS
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 4
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: DATA_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 3
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: TYPE_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: NUMBER
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: PRECISION
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 38
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: SCALE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: CALLING String ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: NULLABLE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: REMARKS
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: null
Intnet DEV ST: BEGIN Column.
Intnet DEV ST: Name: 'PO_STATUS'
Intnet DEV ST: SQL Type: java.sql.Types.DECIMAL
Intnet DEV ST: Native Type: NUMBER
Intnet DEV ST: Parameter Type: OUT
Intnet DEV ST: Precision: 38
Intnet DEV ST: Scale: 0
Intnet DEV ST: Position: 8
Intnet DEV ST: Nullable: YES
Intnet DEV ST: END Column.
Intnet DEV ST: CALLING boolean ResultSet.next()
Intnet DEV ST: CALLED boolean ResultSet.next()
Intnet DEV ST: RETURNED RESULT: true
Intnet DEV ST: CALLING String ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: PO_USERNAME
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 4
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: DATA_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 12
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: TYPE_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: VARCHAR2
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: PRECISION
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 8
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: SCALE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: CALLING String ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: NULLABLE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: REMARKS
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: null
Intnet DEV ST: BEGIN Column.
Intnet DEV ST: Name: 'PO_USERNAME'
Intnet DEV ST: SQL Type: java.sql.Types.VARCHAR
Intnet DEV ST: Native Type: VARCHAR2
Intnet DEV ST: Parameter Type: OUT
Intnet DEV ST: Length: 8
Intnet DEV ST: Position: 9
Intnet DEV ST: Nullable: YES
Intnet DEV ST: END Column.
Intnet DEV ST: CALLING boolean ResultSet.next()
Intnet DEV ST: CALLED boolean ResultSet.next()
Intnet DEV ST: RETURNED RESULT: true
Intnet DEV ST: CALLING String ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: PO_MESSAGE
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: COLUMN_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 4
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: DATA_TYPE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 12
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: TYPE_NAME
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: VARCHAR2
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: PRECISION
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: CALLING int ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: SCALE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 0
Intnet DEV ST: CALLING String ResultSet.getInt(int columnIndex)
Intnet DEV ST: WITH PARAM 1: NULLABLE
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: 1
Intnet DEV ST: CALLING int ResultSet.getString(int columnIndex)
Intnet DEV ST: WITH PARAM 1: REMARKS
Intnet DEV ST: CALLED
Intnet DEV ST: RETURNED VALUE: null
Intnet DEV ST: BEGIN Column.
Intnet DEV ST: Name: 'PO_MESSAGE'
Intnet DEV ST: SQL Type: java.sql.Types.VARCHAR
Intnet DEV ST: Native Type: VARCHAR2
Intnet DEV ST: Parameter Type: OUT
Intnet DEV ST: Length: 0
Intnet DEV ST: Position: 10
Intnet DEV ST: Nullable: YES
Intnet DEV ST: END Column.
Intnet DEV ST: CALLING boolean ResultSet.next()
Intnet DEV ST: CALLED boolean ResultSet.next()
Intnet DEV ST: RETURNED RESULT: false
Intnet DEV ST: CALLING ResultSet.close()
Intnet DEV ST: CALLED
Intnet DEV ST: Closed result set 41eb4cad.
Intnet DEV ST:END Get metadata for procedure/function 'IDE.PACK_Intnet_IDE.MODIFY_USER'.
Intnet DEV ST:CALLING Connection.getAutoCommit():boolean
Intnet DEV ST:CALLED
Intnet DEV ST:BEGIN Call stored procedure 'IDE.PACK_Intnet_IDE.MODIFY_USER'.
Intnet DEV ST:{call IDE.PACK_Intnet_IDE.MODIFY_USER(?,?,?,?,?,?,?,?,?,?)}
Intnet DEV ST:BEGIN Instantiate callable statement.
Intnet DEV ST: Allocating statement from connection 19cc279d.
Intnet DEV ST:CALLING Connection.prepareCall(String)
Intnet DEV ST: WITH PARAM 1: {call IDE.PACK_Intnet_IDE.MODIFY_USER(?,?,?,?,?,?,?,?,?,?)}
Intnet DEV ST:CALLED
Intnet DEV ST:RETURNED VALUE: oracle.jdbc.driver.OracleCallableStatementWrapper@2748ae14
Intnet DEV ST: Allocated statement 2748ae14.
Intnet DEV ST:END Instantiate callable statement.
Intnet DEV ST:BEGIN Set IN, Register OUT parameter(s).
Intnet DEV ST: IN @ index 1, param 'PI_USERNAME', field '$1', length: 5, value = 'BEBOE'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 1
Intnet DEV ST: WITH PARAM 2: 'BEBOE'
Intnet DEV ST:CALLED
Intnet DEV ST: IN @ index 2, param 'PI_FIRST_NAME', field '$2', length: 7, value = 'Bouchra'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 2
Intnet DEV ST: WITH PARAM 2: 'Bouchra'
Intnet DEV ST:CALLED
Intnet DEV ST: IN @ index 3, param 'PI_LAST_NAME', field '$3', length: 10, value = 'Ejjabri235'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 3
Intnet DEV ST: WITH PARAM 2: 'Ejjabri235'
Intnet DEV ST:CALLED
Intnet DEV ST: IN @ index 4, param 'PI_FULL_NAME', field '$4', length: 15, value = 'Bouchra Ejjabri'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 4
Intnet DEV ST: WITH PARAM 2: 'Bouchra Ejjabri'
Intnet DEV ST:CALLED
Intnet DEV ST: IN @ index 5, param 'PI_ACCESSRIGHT', field '$5', length: 1, value = '2'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 5
Intnet DEV ST: WITH PARAM 2: '2'
Intnet DEV ST:CALLED
Intnet DEV ST: IN @ index 6, param 'PI_PRINT_FORMAT', field '$6', length: 2, value = 'A4'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 6
Intnet DEV ST: WITH PARAM 2: 'A4'
Intnet DEV ST:CALLED
Intnet DEV ST: IN @ index 7, param 'PI_EMAIL_ADDRESS', field '$7', length: 26, value = 'someone.test@test.si'
Intnet DEV ST:CALLING PreparedStatement.setString(int, String)
Intnet DEV ST: WITH PARAM 1: 7
Intnet DEV ST: WITH PARAM 2: 'someone.test@test.si'
Intnet DEV ST:CALLED
Intnet DEV ST: OUT @ index 8, param 'PO_STATUS', field '$8'
Intnet DEV ST:CALLING CallableStmt.registerOutParameter(int, int)
Intnet DEV ST: WITH PARAM 1: 8
Intnet DEV ST: WITH PARAM 2: java.sql.Types.DECIMAL
Intnet DEV ST:CALLED
Intnet DEV ST: OUT @ index 9, param 'PO_USERNAME', field '$9'
Intnet DEV ST:CALLING CallableStmt.registerOutParameter(int, int)
Intnet DEV ST: WITH PARAM 1: 9
Intnet DEV ST: WITH PARAM 2: java.sql.Types.VARCHAR
Intnet DEV ST:CALLED
Intnet DEV ST: OUT @ index 10, param 'PO_MESSAGE', field '$10'
Intnet DEV ST:CALLING CallableStmt.registerOutParameter(int, int)
Intnet DEV ST: WITH PARAM 1: 10
Intnet DEV ST: WITH PARAM 2: java.sql.Types.VARCHAR
Intnet DEV ST:CALLED
Intnet DEV ST:END Set IN, Register OUT parameter(s).
Intnet DEV ST:BEGIN Execute procedure.
Intnet DEV ST:CALLING CallableStatement.execute()
Intnet DEV ST:CALLED
Intnet DEV ST:END Execute procedure.
Intnet DEV ST:BEGIN Get OUT parameter values.
Intnet DEV ST:CALLING CallableStatement.getBigDecimal(int, int)
Intnet DEV ST: WITH PARAM 1: 8
Intnet DEV ST: WITH PARAM 2: 0
Intnet DEV ST:CALLED
Intnet DEV ST:RETURNED VALUE: 0
Intnet DEV ST: OUT @ index 8, param 'PO_STATUS', field '$8', value = 0
Intnet DEV ST:CALLING CallableStatement.getString(int)
Intnet DEV ST: WITH PARAM 1: 9
Intnet DEV ST:CALLED
Intnet DEV ST:RETURNED VALUE: BEBOE
Intnet DEV ST: OUT @ index 9, param 'PO_USERNAME', field '$9', length: 5, value = 'BEBOE'
Intnet DEV ST:CALLING CallableStatement.getString(int)
Intnet DEV ST: WITH PARAM 1: 10
Intnet DEV ST:CALLED
Intnet DEV ST:RETURNED VALUE: null
Intnet DEV ST: OUT @ index 10, param 'PO_MESSAGE', field '$10', value = null
Intnet DEV ST:END Get OUT parameter values.
Intnet DEV ST:CALLING Statement.getUpdateCount()
Intnet DEV ST:CALLED
Intnet DEV ST:RETURNED VALUE: -1
Intnet DEV ST:CALLING Statement.getResultSet()
Intnet DEV ST:CALLED
Intnet DEV ST:RETURNED VALUE: null
Intnet DEV ST:END Call stored procedure 'IDE.PACK_Intnet_IDE.MODIFY_USER'.
Intnet DEV ST:CALLING PreparedStatement.clearParameters()
Intnet DEV ST:CALLED
Intnet DEV ST:CALLING Statement.ClearWarnings()
Intnet DEV ST:CALLED
Intnet DEV ST:Released connection lock.
Intnet DEV ST:Number of statements allocated on connection 'dedicated0': 1.
Intnet DEV ST:Restoring operation data to output document
Intnet DEV ST:SubscriptionShim.execute() returned:
Intnet DEV ST:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20180222_0550" instance="Intnet DEV" version="4.1.0.0">DirXML Driver for JDBC</product>
<contact>NetIQ Corporation</contact>
</source>
<output>
<jdbc:out-parameters event-id="oslsec015_524-NDS#20181205080810#2#1:d59f1bc5-3c96-4725-8be0-78f72530025f" jdbc:number-of-params="3">
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
<jdbc:param/>
<jdbc:param jdbc:name="PO_STATUS" jdbc:param-type="OUT" jdbc:position="8" jdbc:sql-type="java.sql.Types.DECIMAL">
<jdbc:value>0</jdbc:value>
</jdbc:param>
<jdbc:param jdbc:name="PO_USERNAME" jdbc:param-type="OUT" jdbc:position="9" jdbc:sql-type="java.sql.Types.VARCHAR">
<jdbc:value>BEBOE</jdbc:value>
</jdbc:param>
<jdbc:param jdbc:name="PO_MESSAGE" jdbc:param-type="OUT" jdbc:position="10" jdbc:sql-type="java.sql.Types.VARCHAR"/>
<operation-data jdbcSP="true" operation="modify"/>
</jdbc:out-parameters>
<status event-id="oslsec015_524-NDS#20181205080810#2#1:d59f1bc5-3c96-4725-8be0-78f72530025f" level="success">
<operation-data jdbcSP="true" operation="modify"/>
</status>
</output>
</nds>
Labels (1)
0 Likes
3 Replies
seba4 Respected Contributor.
Respected Contributor.

Re: JDBC - PROCEDURE execute - Connection problem

.. duplicate
0 Likes
seba4 Respected Contributor.
Respected Contributor.

Re: JDBC - PROCEDURE execute - Connection problem

I have managed to kinda solve it by raising Maximum number of connection retries to maximum number, but this only helps when there are less than 5 statements sent.

When we trigger Sync user, we can sometimes send 20 statements to update all User configurations and this fails with the same error. Unable to retrieve statement results.
0 Likes
Knowledge Partner
Knowledge Partner

Re: JDBC - PROCEDURE execute - Connection problem

On 12/6/2018 4:34 AM, seba4 wrote:
>
> I have managed to kinda solve it by raising Maximum number of connection
> retries to maximum number, but this only helps when there are less than
> 5 statements sent.
>
> When we trigger Sync user we can sometimes send 20 statements to update
> all the configuration for user and this fails with the same error.
> Unable to retrieve statement results.


Can you collapse the statements into one long statement? I.e. It is the
stand alone call to omake a SQL statement, not the contents of the
statement that hits the limit, right?

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.