WSO2 APIM v4.4.0 with Oracle 11g Database get error ORA-00972: identifier is too long
Nobody has claimed this yet.
- Dominant language
- CSS
- Stars
- 99
- Forks
- 708
- Avg merge
- 1d 7h
- Merged PRs (30d)
- 22
Description
Description
Hello everyone,
I'm newbie in WSO2 apim, i trying to setup and configure with Oracle 11g Database, but when i run oracle.sql in dbsrcripts/ and dbscripts/apimgt, some of table, sequence, trigger cause error ORA-00972: identifier is too long. I know that Oracle 11g only allow object name length with 30 bytes only. Is there anyway to run WSO2 apim with oracle 11g database?
Thanks for your help!
Steps to Reproduce
I run script in dbscripts/oracle.sql and dbscripts/apimgt/oracle.sql then some of table, sequence, trigger cause error ORA-00972: identifier is too long
Version
4.4.0
Environment Details (with versions)
No response
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing dbscripts/oracle.sql and dbscripts/apimgt/oracle.sql, then reproduce the ORA-00972 errors with Oracle 11g. Identify the affected table, sequence, and trigger names and establish whether WSO2 APIM 4.4.0 supports this database version; done should include a clear compatibility answer or documented database-script changes.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100