I generated classes from SQL Server database and tried to execute them 
against oracle database but it says no table/view exists.

When generating from SQL Server it returns the actual table name in mixed 
case whereas oracle expect the table names in upper case when enclosed in 
double quote.

select * from "Schema"."Employee" -- this will work for SQL Server but for 
oracle schema name and table name should be upper case as below

select * from "SCHEMA"."EMPLOYEE"

Are there anyway to upper case the table names for Oracle?

-- 
You received this message because you are subscribed to the Google Groups "jOOQ 
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to