Oracle database table creation script fails (db/oracle/oracle_database_tables.sql)

mitreid-connect / OpenID-Connect-Java-Spring-Server

An OpenID Connect reference implementation in Java on the Spring platform.

Other

1.48k stars 765 forks source link

Oracle database table creation script fails (db/oracle/oracle_database_tables.sql) #1350

Open cristianpetrache opened 6 years ago

cristianpetrache commented 6 years ago

Oracle database table creation script fails (db/oracle/oracle_database_tables.sql):

The 1st issue is the _clientdetails table definition. The column _softwarestatement is defined twice. The size of the column also exceeds the max VARCHAR size (4096 > 4000).
The second problem is with the _devicecode% tables. The if not exists clause is not valid in oracle. Also, the boolean type is not a valid oracle datatype.

Here is the format that seems to have worked: oracle_database_tables.sql.zip

kiakj commented 6 years ago

I came across the same issues. I'm now getting getting "ORA-00972 identifier is too long" error. For example, the table creation script has "user_info_signed_response_alg" field, but the resulting select script from the Java side is looking for user_info_encrypted_response_alg.