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.

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

ormconfig is not setting default schema for oracle database #6272

Closed
lipeavelar opened this issue Jun 17, 2020 · 2 comments
Closed

ormconfig is not setting default schema for oracle database #6272

lipeavelar opened this issue Jun 17, 2020 · 2 comments

Comments

@lipeavelar
Copy link

lipeavelar commented Jun 17, 2020

Issue type:

[ ] question
[ X ] bug report
[ ] feature request
[ ] documentation issue

Database system/driver:

[ ] cordova
[ ] mongodb
[ ] mssql
[ ] mysql / mariadb
[ X ] oracle
[ ] postgres
[ ] cockroachdb
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo

TypeORM version:

[ ] latest
[ ] @next
[ X ] 0.2.25 (or put your version here)

Steps to reproduce or a small repository showing the problem:

I have set schema option on ormconfig.js to my schema, but, when I try to find an entity, it returns an error saying table or view does not exists, but if I use my schema explicit on entity declaration, e.g. @Entity('MYSCHEMA.MYTABLE'), it works fine.

Any sugestions what could I do to solve this problem?

@imnotjames
Copy link
Contributor

According to comments in the oracle driver:

* Build full table name with database name, schema name and table name.
* Oracle does not support table schemas. One user can have only one schema.

Is this not the case? Can you find where this is in the documentation somewhere?

@lipeavelar
Copy link
Author

Issue solved by #6673

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants