Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] CDOResource name equal
[CDO] CDOResource name equal [message #986206] Mon, 19 November 2012 13:19 Go to next message
Christophe Bouhier is currently offline Christophe BouhierFriend
Messages: 937
Registered: July 2009
Senior Member
Hello,

I am getting an exception as below.
In the DB it shows up like this:

'2714085', 'NetXResource_GV-Internet'

Why would it be duplicate, if the case is different? (Notice INTERNET is spelled with capital letters in the exception below).

It seems I can create a CDO resource name which is not case sensitive, but when adding a new CDOResource, it becomes case sensitive again. Is this a bug or intended behaviour?

rgds Christophe


Duplicate resource or folder: NetXResource_GV-INTERNET in folder OID46636
at org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.AbstractHorizontalClassMapping.checkDuplicateResources(AbstractHorizontalClassMapping.java:451)
at org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.AbstractHorizontalClassMapping.writeRevision(AbstractHorizontalClassMapping.java:503)


Re: [CDO] CDOResource name equal [message #986292 is a reply to message #986206] Mon, 19 November 2012 18:29 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 5590
Registered: July 2009
Senior Member
Am 19.11.2012 14:19, schrieb Christophe Bouhier:
> Hello,
> I am getting an exception as below. In the DB it shows up like this:
> '2714085', 'NetXResource_GV-Internet'
>
> Why would it be duplicate, if the case is different? (Notice INTERNET is spelled with capital letters in the exception
> below).
> It seems I can create a CDO resource name which is not case sensitive, but when adding a new CDOResource, it becomes
> case sensitive again. Is this a bug or intended behaviour?
I've noticed similar issues with MySQL where the column data looks case sensitive but the (default?) collation is in
fact case insensitive. My customer was able to manually change that setting per table or per column. Later they
customiszed our MySQLAdapter to create columns with the right setting in the first place. Could this have caused your
problem?

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper


> rgds Christophe
>
> Duplicate resource or folder: NetXResource_GV-INTERNET in folder OID46636
> at
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.AbstractHorizontalClassMapping.checkDuplicateResources(AbstractHorizontalClassMapping.java:451)
> at
> org.eclipse.emf.cdo.server.internal.db.mapping.horizontal.AbstractHorizontalClassMapping.writeRevision(AbstractHorizontalClassMapping.java:503)
>
>
>
Re: [CDO] CDOResource name equal [message #986389 is a reply to message #986292] Tue, 20 November 2012 10:12 Go to previous messageGo to next message
Christophe Bouhier is currently offline Christophe BouhierFriend
Messages: 937
Registered: July 2009
Senior Member
Ah ok, so this is DBStore implementation specific.

I will check the collation for our case, but would also be interested to learn more about:
"customiszed our MySQLAdapter to create columns with the right setting in the first place". Do you refer to the collation to use when creating the columns?

thx Christophe
Re: [CDO] CDOResource name equal [message #986404 is a reply to message #986389] Tue, 20 November 2012 10:38 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 5590
Registered: July 2009
Senior Member
Am 20.11.2012 11:12, schrieb Christophe Bouhier:
> Ah ok, so this is DBStore implementation specific.
>
> I will check the collation for our case, but would also be interested to learn more about: "customiszed our
> MySQLAdapter to create columns with the right setting in the first place". Do you refer to the collation to use when
> creating the columns?
IIRC there is some Mysql-specific stuff on CREATE TABLE: http://dev.mysql.com/doc/refman/5.0/en/charset-table.html

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Previous Topic:@Lob Causing incorrect Hibrenate mapping
Next Topic:[CDO] Server in non-OSGi environment
Goto Forum:
  


Current Time: Sun Dec 21 18:05:57 GMT 2014

Powered by FUDForum. Page generated in 0.01897 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software