EntityMetadata ignores Schemas for OracleDriver

[jf214]

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:

[X] latest
[ ] @next
[ ] 0.x.x (or put your version here)

Steps to reproduce or a small repository showing the problem:

I'm using the OracleDriver and after upgrading to the 0.2.19, the generated queries ignore the schemas defined on my Entity Definition.

Example Entity

import {
  Column,
  Entity,
  PrimaryColumn,
} from "typeorm";

@Entity({
  name: "PERSON",
  schema: "DW_ADMIN"
})
export class Person {
    @PrimaryColumn({ name: "ID" })
    public id: number;

    @Column({ name: "NAME" })
    public name: string;
}

The resulting query:

SELECT "p"."ID" AS "p_ID", "p"."NAME" AS "p_NAME" FROM "PERSON"

The result is an oracle error because there is no schema attached to the table in the query
ORA-00942: table or view does not exist

Prior to upgrading the query was:

SELECT "p"."ID" AS "p_ID", "p"."NAME" AS "p_NAME" FROM "DW_ADMIN"."PERSON"

[marrasen]

We have a similar problem using MySQL. I think this is a problem for all databases except Postgres and SqlServer since this commit d8f1c81

[kdi-1]

The same problem. Any workaround?

[marrasen]

The same problem. Any workaround?

We reverted to version 0.2.18 until this is resolved

[jf214]

We've done the same.

[marrasen]

@jf214 Just discovered that if you change your entities from saying schema to database you can avoid this bug

@Entity("table_name", {database: "schemaname"})

[jf214]

Nice workaround. I'll try it out.

[jadilson12]

@marrasen

thanks, it worked

[imnotjames]

This was fixed with #6673