Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO Teneo] Cannot start a CDO Server with a Hibernate Datastore using a Derby Database
[CDO Teneo] Cannot start a CDO Server with a Hibernate Datastore using a Derby Database [message #509758] Mon, 25 January 2010 10:29 Go to next message
Bjoern Sundin is currently offline Bjoern SundinFriend
Messages: 47
Registered: July 2009
Member
I would need some help with a problem. When I start up a CDO server using a
Hibernate Datastore and a Derby database the server exit with a
SQLGrammarException exception:

[QUOTE]
create table cdo_package_unit (nsUri varchar(255) not null, originalType
varchar(255) for bit data, timeStamp bigint, EPackageBlob varchar(40000) for
bit data, primary key (nsUri))
alter table cdo_package_info add constraint FK5702C978798F06A8 foreign key
(cdo_package_unit_id) references cdo_package_unit

!ENTRY org.eclipse.emf.cdo.server 1 0 2010-01-22 12:00:51.392
!MESSAGE No user manager configured. Users will not be authenticated
No user manager configured. Users will not be authenticated
org.hibernate.exception.SQLGrammarException: could not load an entity:
[CDOPackageUnit#http://www.eclipse.org/emf/2002/Ecore]
[UNQUOTE]

See also attached file Stacktrace.txt

Cheers
Bjoern


Re: [CDO Teneo] Cannot start a CDO Server with a Hibernate Datastore using a Derby Database [message #509777 is a reply to message #509758] Mon, 25 January 2010 11:25 Go to previous message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Bjoern,
Found the issue, to store CDO epackage information a table cdo_package_unit is created which has a field epackageblob
which has a length of 40000. Hibernate maps this field to varchar in Derby (and to a blob in mysql which is better). In
Derby varchars have a max length of 32kb. Setting the max length to 32700 solves it.

I entered a bugzilla for this:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=300621

I will maybe change the mapping of this field so that the length does not need to be supplied.

gr. Martin

Bjoern Sundin wrote:
> I would need some help with a problem. When I start up a CDO server using a
> Hibernate Datastore and a Derby database the server exit with a
> SQLGrammarException exception:
>
> [QUOTE]
> create table cdo_package_unit (nsUri varchar(255) not null, originalType
> varchar(255) for bit data, timeStamp bigint, EPackageBlob varchar(40000) for
> bit data, primary key (nsUri))
> alter table cdo_package_info add constraint FK5702C978798F06A8 foreign key
> (cdo_package_unit_id) references cdo_package_unit
>
> !ENTRY org.eclipse.emf.cdo.server 1 0 2010-01-22 12:00:51.392
> !MESSAGE No user manager configured. Users will not be authenticated
> No user manager configured. Users will not be authenticated
> org.hibernate.exception.SQLGrammarException: could not load an entity:
> [CDOPackageUnit#http://www.eclipse.org/emf/2002/Ecore]
> [UNQUOTE]
>
> See also attached file Stacktrace.txt
>
> Cheers
> Bjoern
>
>


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
Previous Topic:[CDO Teneo] Hibernate Store standalone server example?
Next Topic:[CDO Teneo] Problem mapping an EJavaObject using a CDO Server with a Hibernate Datastore
Goto Forum:
  


Current Time: Thu Apr 25 01:13:33 GMT 2024

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

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

Back to the top