|
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 |
Martin Taal 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
|
|
|
Powered by
FUDForum. Page generated in 0.03227 seconds