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 -- 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.
