Tuesday, June 20, 2017

ORA-03115: unsupported network datatype or representation

So, I created a connection with weblogic data source and tried to execute a query and got the following error:
ORA-03115: unsupported network datatype or representation[[
 java.sql.SQLException: ORA-03115: unsupported network datatype or representation

The solution is simple,
Instead of
                  resultSet = preparedStatement.executeQuery(myQuery);
use
                   resultSet = preparedStatement.executeQuery();

Thursday, June 15, 2017

OIM: User unlock query

The following query can be executed to unlock an OIM user:

UPDATE USR SET USR_LOCKED=0,USR_LOGIN_ATTEMPTS_CTR=0, USR_LOCKED_ON = null,USR_MANUALLY_LOCKED = null  WHERE USR_LOGIN='<PROVIDE_USER_LOGIN>';