[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6888) Cannot connect to an Oracle DB using a schema/user specified in lowercase

[Steve Ebersole (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=44567#comment-44567 ] 

Steve Ebersole commented on HHH-6888:
-------------------------------------

Sure.  Thanks for letting us know.  Btw, for curiosity sake, what is the correct way according to Oracle to "quote" the username in terms of opening a Connection?

> Cannot connect to an Oracle DB using a schema/user specified in lowercase
> -------------------------------------------------------------------------
>
>                 Key: HHH-6888
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6888
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.6.7
>         Environment: Oracle 10g 10.2.0.1.0 with JDBC Driver 10.2.0.2 and Oracle10gDialect
>            Reporter: Vincent Massol
>
> I have an Oracle user with lowercase letters ("xwiki"). When I use the following in my hibernate.cfg.xml:
> {noformat}
>     <property name="connection.url">jdbc:oracle:thin:@<ip>:1521:XE</property>
>     <property name="connection.username">xwiki</property>
>     <property name="connection.password">pass</property>
>     <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
>     <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
> {noformat}
> Hibernate fails to connect.
> The reason, I believe, is because Hibernate passes the username *as is* to Oracle without escaping it in quotes. Since Oracle converts users passed to it to uppercase (unless they're escaped with quotes) it fails to connect.
> I found the following in a forum post (https://forums.oracle.com/forums/thread.jspa?threadID=732373&tstart=1500 ):
> {noformat}
> The username is passed to the ConnectionPool by the Properties attribute:
> Properties="user=scott;portNumber=1521;SID=MYDB;serverName=myserver"
> So, it's true that the username is not quoted.
> {noformat}
> Thanks

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira