Project

General

Profile

Actions
Copy link

Task #262

closed

Test provisioning on Oracle SQL

Added by Ondřej Kopr almost 8 years ago. Updated almost 8 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Ondřej Kopr
Category:
-
Target version:
-
Start date:
01/09/2017
Due date:
% Done:

70%

Estimated time:
Owner:

Description

  • Create test Oracle SQL,
  • test provisioning.

Related issues

Related to IdStory Identity Manager - Task #264: Refactor ACC and SYS tablesNewRadek Tomiška01/09/2017

Actions
Actions
Copy link
 #1

Updated by Ondřej Kopr almost 8 years ago

  • Test provisioning with Oracle DB - working,
  • create idm oracle database and test with use case - working
spring.datasource.url=jdbc:oracle:thin:@85.255.1.44:1521:xe
spring.datasource.username=idmadmin
spring.datasource.password=idmadmin
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
Actions
Copy link
 #2

Updated by Ondřej Kopr almost 8 years ago

Found some minor problem with oracle sql:
  • some identifier is too long (ORA-00972: identifier is too long)
Those tables not created:
  • acc_account - ORA-00904: : invalid identifier
  • sys_role_system_attribute - ORA-00904: : invalid identifier
  • sys_role_system_attribute_a - ORA-00904: : invalid identifier
  • sys_schema_attribute_handling - ORA-00904: : invalid identifier
  • sys_schema_attribute_handling_a - ORA-00972: identifier is too long
  • sys_system_entity - ORA-00904: : invalid identifier
Actions
Copy link
 #3

Updated by Ondřej Kopr almost 8 years ago

  • Related to Task #264: Refactor ACC and SYS tables added
Actions
Copy link
 #4

Updated by Ondřej Kopr almost 8 years ago

  • % Done changed from 0 to 70
Actions
Copy link
 #5

Updated by Ondřej Kopr almost 8 years ago

  • Status changed from New to Closed

Refactor tables for oracle will be implemented in task #264

Actions
Copy link

Also available in: Atom PDF