HI Lukas: Excellent. AS_IS solves my problem.
Thanks, Venkat On Tuesday, 2 July 2013 04:00:50 UTC-4, Lukas Eder wrote: > > Hi Venkat, > > My recommendation in this case is generally as follows: Make all > identifiers in both Oracle and SQL Server "Case Sensitive" in your DDL, by > quoting them already in the DDL statement. Obviously, they will then need > to be quoted the same way between SQL Server and Oracle. > > I understand that you're working with a legacy system where this may not > always be possible. jOOQ allows for specifying four different strategies of > SQL rendering in Settings.renderNameStyle: > > <simpleType name="RenderNameStyle"> > <restriction base="string"> > > <!-- Render object names quoted, as defined in the database. Use this > to stay on the safe side with case-sensitivity and special > characters. For instance: > Oracle : "SYS"."ALL_TAB_COLS" > MySQL : `information_schema`.`TABLES` > SQL Server: [INFORMATION_SCHEMA].[TABLES] --> > <enumeration value="QUOTED"/> > > <!-- Render object names, as defined in the database. For instance: > Oracle : SYS.ALL_TAB_COLS > MySQL : information_schema.TABLES > SQL Server: INFORMATION_SCHEMA.TABLES --> > <enumeration value="AS_IS"/> > > <!-- Force rendering object names in lower case. For instance: > Oracle : sys.all_tab_cols > MySQL : information_schema.tables > SQL Server: information_schema.tables --> > <enumeration value="LOWER"/> > > <!-- Force rendering object names in upper case. For instance: > Oracle : SYS.ALL_TAB_COLS > MySQL : INFORMATION_SCHEMA.TABLES > SQL Server: INFORMATION_SCHEMA.TABLES --> > <enumeration value="UPPER"/> > </restriction> > </simpleType> > > See some more details here: > http://www.jooq.org/xsd/jooq-runtime-3.1.0.xsd > > Please let me know if these features sufficiently cover your use-case, or > if you might run into other problems in edge-cases, e.g. Oracle > UNDERSCORE_UPPER_CASING, vs. SQL Server's NoUnderscorePascalCasing, i.e. > when casing isn't the only difference. > > Cheers > Lukas > > > 2013/7/2 Venkat Sadasivam <[email protected] <javascript:>> > >> 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] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- 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.
