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 seba.wag...@gmail.com
