DB integration Issue-

I have created two tables ('nimuser' & 'nimlogtable') with below data-

Table- nimuser [INSERT INTO nimuser VALUES(104, 'amit', 'Singh',
'kolkata', 104)]

Table -nimlogtable [INSERT into nimlogtable VALUES(5, 'userid=104', 'N',
1 ,TO_DATE('2013/05/04 21:02:44', 'yyyy/mm/dd
hh24:mi:ss'),'system','nimuser','firstname','','am it')]

as soon as i insert the record in table 'nimlogtable' the driver process
the request, and delete the record from table 'nimlogtable' after
processing.

But i want that the account should be created in IDM-

Here is logs-


:SELECT * FROM NIMLOGTABLE WHERE STATUS = 'N' AND ROWNUM <= 1 ORDER BY
RECORD_ID ASC
:CALLING PreparedStatement.executeQuery()
:CALLED
:RETURNED VALUE: oracle.jdbc.driver.OracleResultSetImpl@55bd9c75
: Allocated result set 55bd9c75 from statement 361b9546.
:END Query for events.
:CALLING ResultSet.next()
:CALLED
:RETURNED VALUE: true
:CALLING ResultSet.getBigDecimal(int, int)
: WITH PARAM 1: 1
: WITH PARAM 2: 0
:CALLED
:RETURNED VALUE: 5
: RS @ index 1, field 'RECORD_ID', value = 5
:CALLING ResultSet.getString(int)
: WITH PARAM 1: 2
:CALLED
:RETURNED VALUE: userid=104
: RS @ index 2, field 'TABLE_KEY', length: 10, value = 'userid=104'
:CALLING ResultSet.getString(int)
: WITH PARAM 1: 3
:CALLED
:RETURNED VALUE: N
: RS @ index 3, field 'STATUS', length: 1, value = 'N'
:CALLING ResultSet.getInt(int)
: WITH PARAM 1: 4
:CALLED
:RETURNED VALUE: 1
: RS @ index 4, field 'EVENT_TYPE', value = 1
:CALLING ResultSet.getString(int)
: WITH PARAM 1: 6
:CALLED
:RETURNED VALUE: system
: RS @ index 6, field 'PERPETRATOR', length: 6, value = 'system'
:CALLING ResultSet.getString(int)
: WITH PARAM 1: 7
:CALLED
:RETURNED VALUE: nimuser
: RS @ index 7, field 'TABLE_NAME', length: 7, value = 'nimuser'
:CALLING ResultSet.getString(int)
: WITH PARAM 1: 8
:CALLED
:RETURNED VALUE: firstname
: RS @ index 8, field 'COLUMN_NAME', length: 9, value = 'firstname'
:CALLING ResultSet.getString(int)
: WITH PARAM 1: 9
:CALLED
:RETURNED VALUE: null
: RS @ index 9, field 'OLD_VALUE', value = null
:CALLING ResultSet.getString(int)
: WITH PARAM 1: 10
:CALLED
:RETURNED VALUE: amit
: RS @ index 10, field 'NEW_VALUE', length: 4, value = 'amit'
:BEGIN Row.
: RECORD_ID: 5
: TABLE_KEY: 'userid=104'
: STATUS: 'N'
: EVENT_TYPE: 1; insert field
: PERPETRATOR: 'system'
: TABLE_NAME: 'nimuser'
: COLUMN_NAME: 'firstname'
: OLD_VALUE: NULL
: NEW_VALUE: 'amit'
:END Row.
:Filtered row 5.
:CALLING ResultSet.next()
:CALLED
:RETURNED VALUE: false
:CALLING ResultSet.close()
:CALLED
: Closed result set 55bd9c75.
:CALLING PreparedStatement.clearParameters()
:CALLED
:CALLING Statement.ClearWarnings()
:CALLED
:Have no events to submit.
:Acquired connection 'shared0'.
:Acquired lock on connection 'shared0'.
:Released connection lock.
:BEGIN Transaction
: CALLING Connection.getAutoCommit():boolean
: CALLED
: Not locking.
: BEGIN Batch
: DELETE FROM NIMLOGTABLE WHERE RECORD_ID = 5
: CALLING Statement.addBatch(String sql)
: WITH PARAM 1: DELETE FROM NIMLOGTABLE WHERE RECORD_ID = 5
: CALLED
: CALLING Statement.executeBatch()
: CALLED
: CALLING Statement.clearBatch()
: CALLED
: END Batch
: CALLING Statement.clearBatch()
: CALLED
: CALLING Connection.commit()
: CALLED
: COMMIT
:END Transaction
:Released connection lock.
:Number of statements allocated on connection 'dedicated0': 1.
:Number of statements allocated on connection 'shared0': 1.
:Current time is: 2013-08-30 18:08:04.95
:Closing idle connections.
:Acquired lock on connection 'shared0'.
:Released connection lock.
:The next idle connection will be closed at 2013-08-30 18:13:04.95.
:Expiring extended queries prior to current time.
:Acquired lock on file '.\jdbc_086e91f1-9be4-4407-98ed-1fd24b5225b0_0'.
:Released file lock.
:There are no more extended queries to expire.
:Sleeping for 10 second(s), 0 millisecond(s).
:Publisher is awake.
:Polling for database events...
:BEGIN Polling Cycle.
:Batch size: 1
:BEGIN Query for events.
:SELECT * FROM NIMLOGTABLE WHERE STATUS = 'N' AND ROWNUM <= 1 ORDER BY
RECORD_ID ASC
:CALLING PreparedStatement.executeQuery()
:CALLED
:RETURNED VALUE: oracle.jdbc.driver.OracleResultSetImpl@136af14d
: Allocated result set 136af14d from statement 361b9546.
:END Query for events.
:CALLING ResultSet.next()
:CALLED
:RETURNED VALUE: false
:CALLING ResultSet.close()
:CALLED
: Closed result set 136af14d.
:CALLING PreparedStatement.clearParameters()
:CALLED
:CALLING Statement.ClearWarnings()
:CALLED
:Have no events to submit.
:END Polling Cycle.
:Number of statements allocated on connection 'dedicated0': 1.
:Number of statements allocated on connection 'shared0': 1.
:Current time is: 2013-08-30 18:08:14.965
:Closing idle connections.
:Acquired lock on connection 'shared0'.
:Released connection lock.
:The next idle connection will be closed at 2013-08-30 18:13:04.95.
:Expiring extended queries prior to current time.
:Acquired lock on file '.\jdbc_086e91f1-9be4-4407-98ed-1fd24b5225b0_0'.
:Released file lock.
:There are no more extended queries to expire.
:Sleeping for 10 second(s), 0 millisecond(s).
:Publisher is awake.
:Polling for database events...
:BEGIN Polling Cycle.
:Batch size: 1
:BEGIN Query for events.
:SELECT * FROM NIMLOGTABLE WHERE STATUS = 'N' AND ROWNUM <= 1 ORDER BY
RECORD_ID ASC
:CALLING PreparedStatement.executeQuery()
:CALLED
:RETURNED VALUE: oracle.jdbc.driver.OracleResultSetImpl@52080030
: Allocated result set 52080030 from statement 361b9546.
:END Query for events.
:CALLING ResultSet.next()
:CALLED
:RETURNED VALUE: false


--
ameet140
------------------------------------------------------------------------
ameet140's Profile: https://forums.netiq.com/member.php?userid=4993
View this thread: https://forums.netiq.com/showthread.php?t=48514