Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

RDBMS as a backend - cannot use Oracle - ORA-902 with 'bytea' type #466

Closed
kranskydog opened this issue Jan 22, 2025 · 1 comment
Closed

RDBMS as a backend - cannot use Oracle - ORA-902 with 'bytea' type #466

kranskydog opened this issue Jan 22, 2025 · 1 comment
Assignees
@maximthomas

Comments

@kranskydog
Copy link

Describe the bug
cannot use Oracle as a JDBC backend because of invalid data types in the table definitions

In opendj-server-legacy/src/main/java/org/opends/server/backends/jdbc/Storage.java

"create table if not exists "+getTableName(treeName)+" (k bytea primary key,v bytea)"

bytea is not an Oracle (or MYSQL) data type

see, for example, https://docs.aws.amazon.com/dms/latest/oracle-to-aurora-postgresql-migration-playbook/chap-oracle-aurora-pg.tables.common.html

and https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html

Similarly, "if not exists" is not valid Oracle syntax
@kranskydog kranskydog changed the title RDBMS as a backend - cannnot use Oracle - ORA-902 with 'bytea' type RDBMS as a backend - cannot use Oracle - ORA-902 with 'bytea' type Jan 22, 2025
@maximthomas maximthomas self-assigned this Jan 23, 2025
@maximthomas maximthomas mentioned this issue Jan 23, 2025
Closed
vharseko added a commit to vharseko/OpenDJ that referenced this issue Feb 3, 2025
@vharseko
[OpenIdentityPlatform#466] FIX compatibility jdbc backend: Postgres, …
7d820fd 
…Oracle, MySQL, MSSQL
vharseko added a commit that referenced this issue Feb 3, 2025
@maximthomas @vharseko
[#466] JDBC: added tests for Oracle, MySQL, MSSQL (#472)
2050033 
Co-authored-by: Valery Kharseko <vharseko@3a-systems.ru>
vharseko added a commit that referenced this issue Feb 4, 2025
@vharseko @maximthomas
[#466] FIX compatibility jdbc backend: Postgres, Oracle, MySQL, MSSQL (…
006b32f 
…#474)

Co-authored-by: maximthomas <maxim.thomas@gmail.com>
@vharseko
Copy link
Member

vharseko commented Feb 4, 2025

please check in 4.9.2

@vharseko vharseko closed this as completed Feb 4, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@maximthomas maximthomas

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@vharseko @maximthomas @kranskydog