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