No, you have to create the tablespace/DB anyway, the thing is to create the tablespace with a specified "PAGESIZE" param (either 8K, 16K or 32K).
.. and there are some more params, but PAGESIZE is the important one for now I think. Sebastian 2011/9/29 Maxim Solodovnik <[email protected]> > According to the thread > tablespace need to be created before OM is installed. > Should I verify that? > > > On Thu, Sep 29, 2011 at 20:51, [email protected] < > [email protected]> wrote: > >> I think I have at least found out the error because this particular create >> statement is wrong: >> >> See this answer/thread: >> >> http://openjpa.208410.n2.nabble.com/Wrong-SQL-produced-by-openJPA-for-create-statement-in-DB2-SQL-Error-286-while-creating-table-tp6842985p6843412.html >> >> >> Sebastian >> >> 2011/9/29 Maxim Solodovnik <[email protected]> >> >>> Hello Sebastian, >>> >>> I see you have created wiki page about DB2 configuration, >>> Should I investigate stack trace? Or maybe you have resolved it already? >>> >>> >>> On Thu, Sep 29, 2011 at 15:44, Maxim Solodovnik <[email protected]>wrote: >>> >>>> OK, thanks - will try later today >>>> >>>> >>>> On Thu, Sep 29, 2011 at 14:52, [email protected] < >>>> [email protected]> wrote: >>>> >>>>> Express-C Version 9.7.x >>>>> is the free version of db2, you can download it for free from the ibm >>>>> website. >>>>> >>>>> Sebastian >>>>> >>>>> >>>>> 2011/9/29 Maxim Solodovnik <[email protected]> >>>>> >>>>>> I'm afraid I have no DB2 to test :( >>>>>> thought something wrong with RoomClient. >>>>>> >>>>>> Will try to get free (or demo) version of DB2 to test. >>>>>> >>>>>> >>>>>> On Thu, Sep 29, 2011 at 14:45, [email protected] < >>>>>> [email protected]> wrote: >>>>>> >>>>>>> I mean DB2 => IBM DB2 Express-C Version 9.7.x >>>>>>> The error is followed by another bunch of errors and Openmeetings >>>>>>> does not boot complete at all. >>>>>>> So at the moment DB2-database is no more available as install option >>>>>>> ... >>>>>>> >>>>>>> However I will investigate also on openJPA list... >>>>>>> >>>>>>> >>>>>>> 2011/9/29 Maxim Solodovnik <[email protected]> >>>>>>> >>>>>>>> Hello Sebastian, >>>>>>>> >>>>>>>> RoomClient is not stored in the DB right now (I'm currently >>>>>>>> implementing it) >>>>>>>> so we can ignore this error for now. >>>>>>>> While testing migration of RoomClient to the DB I'll test DB table >>>>>>>> creation. >>>>>>>> >>>>>>>> >>>>>>>> On Thu, Sep 29, 2011 at 14:24, [email protected] < >>>>>>>> [email protected]> wrote: >>>>>>>> >>>>>>>>> Maxim, >>>>>>>>> >>>>>>>>> have you seen this error before, its thrown when you are using DB2 >>>>>>>>> as database with OpenMeetings while openJPA tries to create the >>>>>>>>> tables. >>>>>>>>> >>>>>>>>> ---------- Forwarded message ---------- >>>>>>>>> From: [email protected] <[email protected]> >>>>>>>>> Date: 2011/9/29 >>>>>>>>> Subject: Wrong SQL produced by openJPA for create statement in DB2 >>>>>>>>> - SQL Error -286 while creating table >>>>>>>>> To: [email protected] >>>>>>>>> >>>>>>>>> >>>>>>>>> Hi, >>>>>>>>> >>>>>>>>> I face a strange error when tables are created by openJPA 2.1.1 >>>>>>>>> into DB2 (Version 9.7.x Express-C) >>>>>>>>> >>>>>>>>> OpenJPA produces this insert statements: >>>>>>>>> >>>>>>>>> CREATE TABLE roomclient (roomclient_id BIGINT NOT NULL GENERATED BY >>>>>>>>> DEFAULT AS IDENTITY, avsettings VARCHAR(254), broadcast_id BIGINT, >>>>>>>>> canDraw >>>>>>>>> SMALLINT, chat_user_room_id BIGINT, connected_since TIMESTAMP, >>>>>>>>> firstname >>>>>>>>> VARCHAR(254), formated_date VARCHAR(254), isBroadcasting SMALLINT, >>>>>>>>> is_chat_notification SMALLINT, is_mod SMALLINT, >>>>>>>>> is_recording SMALLINT, language VARCHAR(254), last_login >>>>>>>>> VARCHAR(254), lastname VARCHAR(254), mail VARCHAR(254), official_code >>>>>>>>> VARCHAR(254), picture_uri VARCHAR(254), public_sid VARCHAR(254), >>>>>>>>> room_enter >>>>>>>>> TIMESTAMP, room_recording_name VARCHAR(254), room_id BIGINT, scope >>>>>>>>> VARCHAR(254), streamid VARCHAR(254), swfurl VARCHAR(254), user_id >>>>>>>>> BIGINT, usercolor VARCHAR(254), userip VARCHAR(254), username >>>>>>>>> VARCHAR(254), >>>>>>>>> userport INTEGER, userpos INTEGER, zombieCheckFlag SMALLINT, PRIMARY >>>>>>>>> KEY >>>>>>>>> (roomclient_id)) >>>>>>>>> >>>>>>>>> OpenJPA fails with this error: SQLCODE=-286, SQLSTATE=42727, >>>>>>>>> DRIVER=3.62.56 >>>>>>>>> Es konnte kein Standardtabellenbereich mit einer Seitengröße von >>>>>>>>> mindestens "8192" gefunden werden, für den die Berechtigungs-ID >>>>>>>>> "DB2ADMIN" >>>>>>>>> eine Nutzungsberechtigung hat.. >>>>>>>>> => The Create statement is obviously wrong. >>>>>>>>> >>>>>>>>> Our openJPA config looks like: >>>>>>>>> >>>>>>>>> http://code.google.com/p/openmeetings/source/browse/trunk/singlewebapp/src/META-INF/db2_persistence.xml >>>>>>>>> >>>>>>>>> Anybody an idea what the error 286 means or what is wrong with the >>>>>>>>> create statement? >>>>>>>>> Other tables are successfully created, it seems just this one fails >>>>>>>>> constantly. >>>>>>>>> >>>>>>>>> Thank you very much, >>>>>>>>> Sebastian Wagner >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Sebastian Wagner >>>>>>>>> http://www.openmeetings.de >>>>>>>>> http://www.webbase-design.de >>>>>>>>> http://www.wagner-sebastian.com >>>>>>>>> [email protected] >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Sebastian Wagner >>>>>>>>> http://www.openmeetings.de >>>>>>>>> http://www.webbase-design.de >>>>>>>>> http://www.wagner-sebastian.com >>>>>>>>> [email protected] >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> WBR >>>>>>>> Maxim aka solomax >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Sebastian Wagner >>>>>>> http://www.openmeetings.de >>>>>>> http://www.webbase-design.de >>>>>>> http://www.wagner-sebastian.com >>>>>>> [email protected] >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> WBR >>>>>> Maxim aka solomax >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Sebastian Wagner >>>>> http://www.openmeetings.de >>>>> http://www.webbase-design.de >>>>> http://www.wagner-sebastian.com >>>>> [email protected] >>>>> >>>> >>>> >>>> >>>> -- >>>> WBR >>>> Maxim aka solomax >>>> >>> >>> >>> >>> -- >>> WBR >>> Maxim aka solomax >>> >> >> >> >> -- >> Sebastian Wagner >> http://www.openmeetings.de >> http://www.webbase-design.de >> http://www.wagner-sebastian.com >> [email protected] >> > > > > -- > WBR > Maxim aka solomax > -- Sebastian Wagner http://www.openmeetings.de http://www.webbase-design.de http://www.wagner-sebastian.com [email protected] -- You received this message because you are subscribed to the Google Groups "OpenMeetings developers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/openmeetings-dev?hl=en.
