[jboss-jira] [JBoss JIRA] Commented: (JBPORTAL-1840) Window name case sensitive

[Thomas Heute (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBPORTAL-1840?page=comments#action_12395249 ] 
            
Thomas Heute commented on JBPORTAL-1840:
----------------------------------------

For records:

It fails on: MySQL 4, MySQL 5, SQL Server
It passes on: Oracle 9, Oracle 10, PostgreSQL 8, Hypersonic

> Window name case sensitive
> --------------------------
>
>                 Key: JBPORTAL-1840
>                 URL: http://jira.jboss.com/jira/browse/JBPORTAL-1840
>             Project: JBoss Portal
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Portal Core
>    Affects Versions: 2.6.1 Final
>         Environment: Fedora Core 7
> java version "1.5.0_12"
> JBoss [Zion] 4.0.5.GA (build: CVSTag=Branch_4_0 date=200610162339) (installed with jems-installer-1.2.0.GA - ejb3 profile)
> JBoss Portal 2.6.1.GA
>            Reporter: Ovidiu Nichifor
>         Assigned To: Thomas Heute
>             Fix For: 2.6.4 Final
>
>
> Customize your dashboard.
> 1. Create a window (e.g. WEATHER) and place it on a test page.
> 2. Create a window (e.g. WeAtHeR) and place it on a test page.
> The portal fails to create the second window:
> Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [org.jboss.portal.core.impl.model.portal.ObjectNode]
>         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
>         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> ...
> Caused by: java.sql.SQLException: Duplicate entry 'dashboard:admin.Test.WeAtHeR' for key 2
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
> This only happens if JBoss Portal uses mysql db descriptor (i.e. portal-mysql5-ds.xml). If using hypersonic it works without any errors.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira