I'm "waking up" this discussion because in fact, the assumptions under
which we added case-insensitive OWNER search in jOOQ 2.4 were wrong. It
*is* possible to create case sensitive user / schema names. The following
code illustrates this:
CREATE USER "AaXx" IDENTIFIED BY abc;CREATE TABLE "AaXx"."Tt"("Vv"
VARCHAR2(30));SELECT * FROM all_tables WHERE table_name = 'Tt';
Result:
OWNER TABLE_NAME ...
----------------------
AaXx Tt
I've created https://github.com/jOOQ/jOOQ/issues/5990 to fix this in jOOQ
3.10
Lukas
Am Donnerstag, 10. Mai 2012 21:40:03 UTC+2 schrieb Lukas Eder:
>
> Hi John,
>
> > 1. since Oracle only allows upper-case schema names, you could use
> > upper(schema_name) in your code and thus avoid this problem (basically
> treat
> > it as if schema name is case-insensitive). This could be done for all
> other
> > object names in Oracle as well.
>
> I wasn't aware of this, but you're right, as the documentation suggests:
> http://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements008.htm
>
> So it might make sense to support case-insensitive <inputSchema>
> filters in the source code generator. This would also have to apply
> for the <outputSchema>, though. At least for Oracle. I'll file this as
> feature request #1418:
> https://sourceforge.net/apps/trac/jooq/ticket/1418
>
> > 2. if the code generation creates no table objects, you could output the
> > query that likely caused this (in my case, the one that used the
> lower-case
> > schema name) as informational (INFO) message to user. Since this would
> > generally be an unexpected result, it would be helpful for newbies to
> see
> > some output that helps them solve the problem.
>
> You're probably right. Then again, the includes / excludes filters may
> cause this as well, and there are other reasons, too. I'll think about
> this:
> https://sourceforge.net/apps/trac/jooq/ticket/1419
>
> Cheers
> Lukas
>
--
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/d/optout.
