taylor 2004/02/24 08:14:01
Modified: portal maven.xml
portal/src/test/org/apache/jetspeed/page
TestCastorXmlPageManager.java
portal/src/webapp/WEB-INF/db/hsql Registry.script
Log:
fix bug in Castor XML Page Manager
Revision Changes Path
1.46 +1 -1 jakarta-jetspeed-2/portal/maven.xml
Index: maven.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/portal/maven.xml,v
retrieving revision 1.45
retrieving revision 1.46
diff -u -r1.45 -r1.46
--- maven.xml 24 Feb 2004 15:58:23 -0000 1.45
+++ maven.xml 24 Feb 2004 16:14:01 -0000 1.46
@@ -4,7 +4,7 @@
xmlns:reactor="reactor">
<!-- Target of maven test:single test -->
-<property name='testcase' value='org.apache.jetspeed.container.url.TestPortletURL'/>
+<property name='testcase'
value='org.apache.jetspeed.page.TestCastorXmlPageManager'/>
<!-- ================================================================ -->
<!-- Set System properties for junit -->
1.3 +5 -6
jakarta-jetspeed-2/portal/src/test/org/apache/jetspeed/page/TestCastorXmlPageManager.java
Index: TestCastorXmlPageManager.java
===================================================================
RCS file:
/home/cvs/jakarta-jetspeed-2/portal/src/test/org/apache/jetspeed/page/TestCastorXmlPageManager.java,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- TestCastorXmlPageManager.java 24 Feb 2004 05:34:01 -0000 1.2
+++ TestCastorXmlPageManager.java 24 Feb 2004 16:14:01 -0000 1.3
@@ -75,7 +75,6 @@
public class TestCastorXmlPageManager extends PortalComponentAssemblyTestCase
{
private String testId = "test002";
- private ComponentManager componentManager;
/**
* Defines the testcase name for JUnit.
@@ -106,10 +105,10 @@
public static Test suite()
{
// All methods starting with "test" will be executed in the test suite.
- //return new TestSuite(TestCastorXmlPageManager.class);
- ComponentAwareTestSuite suite = new
ComponentAwareTestSuite(TestCastorXmlPageManager.class);
- suite.setScript("org/apache/jetspeed/page/impl/registry.container.groovy");
- return suite ;
+ return new TestSuite(TestCastorXmlPageManager.class);
+ //ComponentAwareTestSuite suite = new
ComponentAwareTestSuite(TestCastorXmlPageManager.class);
+ //
suite.setScript("org/apache/jetspeed/page/impl/registry.container.groovy");
+ // return suite ;
}
public void testNewPage()
1.27 +17 -212
jakarta-jetspeed-2/portal/src/webapp/WEB-INF/db/hsql/Registry.script
Index: Registry.script
===================================================================
RCS file:
/home/cvs/jakarta-jetspeed-2/portal/src/webapp/WEB-INF/db/hsql/Registry.script,v
retrieving revision 1.26
retrieving revision 1.27
diff -u -r1.26 -r1.27
--- Registry.script 24 Feb 2004 05:34:01 -0000 1.26
+++ Registry.script 24 Feb 2004 16:14:01 -0000 1.27
@@ -5,50 +5,6 @@
CREATE TABLE SECURITY_GROUP_ROLE(GROUP_ID INTEGER NOT NULL,ROLE_ID INTEGER NOT
NULL,CONSTRAINT SYS_PK_SECURITY_GROUP_ROLE PRIMARY KEY(GROUP_ID,ROLE_ID),CONSTRAINT
SECURITY_GROUP_ROLE_FK1 FOREIGN KEY(GROUP_ID) REFERENCES
SECURITY_PRINCIPAL(PRINCIPAL_ID),CONSTRAINT SECURITY_GROUP_ROLE_FK2 FOREIGN
KEY(ROLE_ID) REFERENCES SECURITY_PRINCIPAL(PRINCIPAL_ID))
CREATE TABLE SECURITY_PERMISSION(PERMISSION_ID INTEGER NOT NULL PRIMARY
KEY,CLASSNAME VARCHAR(254) NOT NULL,NAME VARCHAR(254) NOT NULL,ACTIONS VARCHAR(254)
NOT NULL,CREATION_DATE TIMESTAMP NOT NULL,MODIFIED_DATE TIMESTAMP NOT NULL)
CREATE TABLE SECURITY_PRINCIPAL_PERMISSION(PRINCIPAL_ID INTEGER NOT
NULL,PERMISSION_ID INTEGER NOT NULL,CONSTRAINT SYS_PK_SECURITY_PRINCIPAL_PERMISSION
PRIMARY KEY(PRINCIPAL_ID,PERMISSION_ID),CONSTRAINT SECURITY_PRINCIPAL_PERMISSION_FK1
FOREIGN KEY(PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL(PRINCIPAL_ID),CONSTRAINT
SECURITY_PRINCIPAL_PERMISSION_FK2 FOREIGN KEY(PERMISSION_ID) REFERENCES
SECURITY_PERMISSION(PERMISSION_ID))
-CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(175) NOT NULL,FIELDNAME VARCHAR(70) NOT
NULL,MAX_KEY INTEGER,GRAB_SIZE INTEGER,VERSION INTEGER,CONSTRAINT SYS_PK_OJB_HL_SEQ
PRIMARY KEY(TABLENAME,FIELDNAME))
-CREATE TABLE OJB_LOCKENTRY(OID_ VARCHAR(250) NOT NULL,TX_ID VARCHAR(50) NOT
NULL,TIMESTAMP_ TIMESTAMP,ISOLATIONLEVEL INTEGER,LOCKTYPE INTEGER,CONSTRAINT
SYS_PK_OJB_LOCKENTRY PRIMARY KEY(OID_,TX_ID))
-CREATE TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_ LONGVARBINARY)
-CREATE TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
-CREATE TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID
INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
-CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
-CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID
INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
-CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
-CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID
INTEGER,KEY_OID BINARY,VALUE_OID BINARY)
-CREATE TABLE MEDIA_TYPE(MEDIATYPE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80)
NOT NULL,CHARACTER_SET VARCHAR(40),TITLE VARCHAR(80),DESCRIPTION LONGVARCHAR)
-CREATE TABLE CLIENT(CLIENT_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80) NOT
NULL,USER_AGENT_PATTERN VARCHAR(128),MANUFACTURER VARCHAR(80),MODEL
VARCHAR(80),VERSION VARCHAR(40),PREFERRED_MIMETYPE_ID INTEGER NOT NULL)
-CREATE TABLE MIMETYPE(MIMETYPE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80) NOT
NULL)
-CREATE TABLE CAPABILITY(CAPABILITY_ID INTEGER NOT NULL PRIMARY KEY,CAPABILITY
VARCHAR(80) NOT NULL)
-CREATE TABLE CLIENT_TO_CAPABILITY(CLIENT_ID INTEGER NOT NULL,CAPABILITY_ID INTEGER
NOT NULL)
-CREATE TABLE CLIENT_TO_MIMETYPE(CLIENT_ID INTEGER NOT NULL,MIMETYPE_ID INTEGER NOT
NULL)
-CREATE TABLE MEDIATYPE_TO_CAPABILITY(MEDIATYPE_ID INTEGER NOT NULL,CAPABILITY_ID
INTEGER NOT NULL)
-CREATE TABLE MEDIATYPE_TO_MIMETYPE(MEDIATYPE_ID INTEGER NOT NULL,MIMETYPE_ID
INTEGER NOT NULL)
-CREATE TABLE DESKTOP(DESKTOP_ID VARCHAR(80) NOT NULL PRIMARY KEY,TITLE
VARCHAR(100),COMPONENT_NAME VARCHAR(100),ACL VARCHAR(80),DEFAULT_PAGE_ID
VARCHAR(80),DEFAULT_THEME VARCHAR(100),DEFAULT_DECORATOR
VARCHAR(100),DEFAULT_PORTLET_DECORATOR VARCHAR(100),CONSTRAINT SYS_CT_1
UNIQUE(DESKTOP_ID))
-CREATE TABLE DESKTOP_PAGES(DESKTOP_ID VARCHAR(80) NOT NULL,PAGE_ID VARCHAR(80) NOT
NULL)
-CREATE INDEX IX_DESKTOP_PAGES_1 ON DESKTOP_PAGES(DESKTOP_ID,PAGE_ID)
-CREATE TABLE SUB_PAGES(PAGE_ID VARCHAR(80) NOT NULL,SUB_PAGE_ID VARCHAR(80) NOT
NULL)
-CREATE INDEX IX_SUB_PAGES_1 ON SUB_PAGES(PAGE_ID,SUB_PAGE_ID)
-CREATE TABLE PAGE(PAGE_ID VARCHAR(80) NOT NULL PRIMARY KEY,TITLE
VARCHAR(100),DEFAULT_SKIN VARCHAR(100),DEFAULT_DECORATOR
VARCHAR(100),DEFAULT_PORTLET_DECORATOR VARCHAR(100),ACL VARCHAR(80),CONSTRAINT
SYS_CT_3 UNIQUE(PAGE_ID))
-CREATE TABLE FRAGMENT(FRAGMENT_ID VARCHAR(80) NOT NULL PRIMARY KEY,COMPONENT_NAME
VARCHAR(100),ACL VARCHAR(80),TITLE VARCHAR(100),TYPE VARCHAR(40),SKIN
VARCHAR(80),DECORATOR VARCHAR(80),STATE VARCHAR(40))
-CREATE TABLE PAGE_FRAGMENTS(PAGE_ID VARCHAR(80) NOT NULL,FRAGMENT_ID VARCHAR(80)
NOT NULL)
-CREATE INDEX IX_PAGE_FRAGMENTS_1 ON PAGE_FRAGMENTS(PAGE_ID,FRAGMENT_ID)
-CREATE TABLE SUB_FRAGMENTS(FRAGMENT_ID VARCHAR(80) NOT NULL,SUB_FRAGMENT_ID
VARCHAR(80) NOT NULL)
-CREATE INDEX IX_SUB_FRAGMENTS_1 ON SUB_FRAGMENTS(FRAGMENT_ID,SUB_FRAGMENT_ID)
-CREATE TABLE FRAGMENT_PARAMETER(PARAMETER_ID INTEGER NOT NULL PRIMARY
KEY,FRAGMENT_ID INTEGER NOT NULL,NAME VARCHAR(80) NOT NULL,VALUE LONGVARCHAR NOT NULL)
-CREATE UNIQUE INDEX IX_FRAGMENT_PARAMETER_1 ON
FRAGMENT_PARAMETER(FRAGMENT_ID,PARAMETER_ID)
-CREATE TABLE FRAGMENT_REF(FRAGMENT_REF_ID VARCHAR(80) NOT NULL PRIMARY
KEY,FRAGMENT_ID VARCHAR(80) NOT NULL,NAME VARCHAR(80) NOT NULL,TITLE VARCHAR(100))
-CREATE TABLE FRAGMENT_REFS(FRAGMENT_REF_ID VARCHAR(80) NOT NULL,FRAGMENT_ID
VARCHAR(80) NOT NULL)
-CREATE TABLE PROFILING_RULE(RULE_ID VARCHAR(80) NOT NULL PRIMARY KEY,CLASS_NAME
VARCHAR(100) NOT NULL,TITLE VARCHAR(100))
-CREATE TABLE RULE_CRITERION(CRITERION_ID VARCHAR(80) NOT NULL PRIMARY KEY,RULE_ID
VARCHAR(80) NOT NULL,FALLBACK_ORDER INTEGER NOT NULL,REQUEST_TYPE VARCHAR(40) NOT
NULL,NAME VARCHAR(80) NOT NULL,VALUE VARCHAR(128),FALLBACK_TYPE INTEGER DEFAULT '1')
-CREATE INDEX IX_RULE_CRITERION_1 ON RULE_CRITERION(RULE_ID,FALLBACK_ORDER)
-CREATE TABLE PRINCIPAL_RULE_ASSOC(PRINCIPAL_NAME VARCHAR(80) NOT NULL,RULE_ID
VARCHAR(80) NOT NULL,CONSTRAINT SYS_CT_5 UNIQUE(PRINCIPAL_NAME))
-CREATE TABLE PROFILE_DESKTOP_ASSOC(LOCATOR_HASH VARCHAR(40) NOT NULL,DESKTOP_ID
VARCHAR(80) NOT NULL)
-CREATE UNIQUE INDEX IX_PROFILE_DESKTOP_1 ON
PROFILE_DESKTOP_ASSOC(LOCATOR_HASH,DESKTOP_ID)
-CREATE TABLE PROFILE_PAGE_ASSOC(LOCATOR_HASH VARCHAR(40) NOT NULL,PAGE_ID
VARCHAR(80) NOT NULL)
-CREATE UNIQUE INDEX IX_PROFILE_PAGE_1 ON PROFILE_PAGE_ASSOC(LOCATOR_HASH,PAGE_ID)
-CREATE TABLE PREF_PROPERTY_SET_DEF(PROPERTY_SET_DEF_ID INTEGER NOT NULL PRIMARY
KEY,PROPERTY_SET_NAME VARCHAR(100),PROPERTY_SET_TYPE SMALLINT,CREATION_DATE
TIMESTAMP,MODIFIED_DATE TIMESTAMP)
-CREATE TABLE PREF_NODE(NODE_ID INTEGER NOT NULL PRIMARY KEY,PARENT_NODE_ID
INTEGER,PROPERTY_SET_DEF_ID INTEGER,NODE_NAME VARCHAR(100),NODE_TYPE
SMALLINT,FULL_PATH VARCHAR(254),CREATION_DATE TIMESTAMP,MODIFIED_DATE
TIMESTAMP,CONSTRAINT PREF_NODE_FK1 FOREIGN KEY(PARENT_NODE_ID) REFERENCES
PREF_NODE(NODE_ID),CONSTRAINT PREF_NODE_FK_2 FOREIGN KEY(PROPERTY_SET_DEF_ID)
REFERENCES PREF_PROPERTY_SET_DEF(PROPERTY_SET_DEF_ID))
-CREATE TABLE PREF_PROPERTY_VALUE(PROPERTY_VALUE_ID INTEGER NOT NULL PRIMARY
KEY,PROPERTY_KEY_ID INTEGER,NODE_ID INTEGER,BOOLEAN_VALUE BIT,DATETIME_VALUE
TIMESTAMP,LONG_VALUE INTEGER,DOUBLE_VALUE DOUBLE,TEXT_VALUE VARCHAR(254),CREATION_DATE
TIMESTAMP,MODIFIED_DATE TIMESTAMP,CONSTRAINT PREF_PROPERTY_VALUE_FK_1 FOREIGN
KEY(NODE_ID) REFERENCES PREF_NODE(NODE_ID))
-CREATE TABLE PREF_PROPERTY_KEY(PROPERTY_KEY_ID INTEGER NOT NULL PRIMARY
KEY,PROPERTY_SET_DEF_ID INTEGER,PROPERTY_NAME VARCHAR(100),PROPERTY_TYPE
SMALLINT,CREATION_DATE TIMESTAMP,MODIFIED_DATE TIMESTAMP,CONSTRAINT
PREF_PROPERTY_KEY_FK_1 FOREIGN KEY(PROPERTY_SET_DEF_ID) REFERENCES
PREF_PROPERTY_SET_DEF(PROPERTY_SET_DEF_ID))
CREATE TABLE PORTLET_APPLICATION_DUBLIN_CORE(ID INTEGER NOT NULL PRIMARY KEY)
CREATE TABLE PORTLET_APPLICATION_DUBLIN_CORE_FIELDS(ID INTEGER NOT NULL PRIMARY
KEY,OBJECT_ID INTEGER NOT NULL,VALUE LONGVARCHAR NOT NULL,LOCALE_STRING VARCHAR(50)
NOT NULL)
CREATE TABLE PORTLET_APPLICATION(APPLICATION_ID INTEGER NOT NULL PRIMARY
KEY,APP_NAME VARCHAR(80) NOT NULL,APP_IDENTIFIER VARCHAR(80),VERSION
VARCHAR(80),APP_TYPE INTEGER,DESCRIPTION VARCHAR(80),WEB_APP_ID INTEGER NOT
NULL,DUBLIN_CORE_ID INTEGER NOT NULL,CONSTRAINT UK_APPLICATION UNIQUE(APP_NAME))
@@ -63,7 +19,23 @@
CREATE TABLE SECURITY_ROLE_REFERENCE(ID INTEGER NOT NULL PRIMARY
KEY,PORTLET_DEFINITION_ID INTEGER NOT NULL,ROLE_NAME VARCHAR(150),ROLE_LINK
VARCHAR(150))
CREATE TABLE LOCALIZED_DESCRIPTION(ID INTEGER NOT NULL PRIMARY KEY,OBJECT_ID
INTEGER NOT NULL,CLASS_NAME VARCHAR(255) NOT NULL,DESCRIPTION LONGVARCHAR NOT
NULL,LOCALE_STRING VARCHAR(50) NOT NULL)
CREATE TABLE LOCALIZED_DISPLAY_NAME(ID INTEGER NOT NULL PRIMARY KEY,OBJECT_ID
INTEGER NOT NULL,CLASS_NAME VARCHAR(255),DISPLAY_NAME LONGVARCHAR NOT
NULL,LOCALE_STRING VARCHAR(50) NOT NULL)
-ALTER TABLE PREF_PROPERTY_VALUE ADD CONSTRAINT PREF_PROPERTY_VALUE_FK_2 FOREIGN
KEY(PROPERTY_KEY_ID) REFERENCES PREF_PROPERTY_KEY(PROPERTY_KEY_ID)
+CREATE TABLE MEDIA_TYPE(MEDIATYPE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80)
NOT NULL,CHARACTER_SET VARCHAR(40),TITLE VARCHAR(80),DESCRIPTION LONGVARCHAR)
+CREATE TABLE CLIENT(CLIENT_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80) NOT
NULL,USER_AGENT_PATTERN VARCHAR(128),MANUFACTURER VARCHAR(80),MODEL
VARCHAR(80),VERSION VARCHAR(40),PREFERRED_MIMETYPE_ID INTEGER NOT NULL)
+CREATE TABLE MIMETYPE(MIMETYPE_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80) NOT
NULL)
+CREATE TABLE CAPABILITY(CAPABILITY_ID INTEGER NOT NULL PRIMARY KEY,CAPABILITY
VARCHAR(80) NOT NULL)
+CREATE TABLE CLIENT_TO_CAPABILITY(CLIENT_ID INTEGER NOT NULL,CAPABILITY_ID INTEGER
NOT NULL)
+CREATE TABLE CLIENT_TO_MIMETYPE(CLIENT_ID INTEGER NOT NULL,MIMETYPE_ID INTEGER NOT
NULL)
+CREATE TABLE MEDIATYPE_TO_CAPABILITY(MEDIATYPE_ID INTEGER NOT NULL,CAPABILITY_ID
INTEGER NOT NULL)
+CREATE TABLE MEDIATYPE_TO_MIMETYPE(MEDIATYPE_ID INTEGER NOT NULL,MIMETYPE_ID
INTEGER NOT NULL)
+CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(175) NOT NULL,FIELDNAME VARCHAR(70) NOT
NULL,MAX_KEY INTEGER,GRAB_SIZE INTEGER,VERSION INTEGER,CONSTRAINT SYS_PK_OJB_HL_SEQ
PRIMARY KEY(TABLENAME,FIELDNAME))
+CREATE TABLE OJB_LOCKENTRY(OID_ VARCHAR(250) NOT NULL,TX_ID VARCHAR(50) NOT
NULL,TIMESTAMP_ TIMESTAMP,ISOLATIONLEVEL INTEGER,LOCKTYPE INTEGER,CONSTRAINT
SYS_PK_OJB_LOCKENTRY PRIMARY KEY(OID_,TX_ID))
+CREATE TABLE OJB_NRM(NAME VARCHAR(250) NOT NULL PRIMARY KEY,OID_ LONGVARBINARY)
+CREATE TABLE OJB_DLIST(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
+CREATE TABLE OJB_DLIST_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID
INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
+CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
+CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID
INTEGER,POSITION_ INTEGER,OID_ LONGVARBINARY)
+CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
+CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID
INTEGER,KEY_OID BINARY,VALUE_OID BINARY)
GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
@@ -135,170 +107,3 @@
CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
-INSERT INTO MEDIA_TYPE VALUES(0,'html','UTF-8','HTML','Rich HTML for HTML 4.0
compliants browsers')
-INSERT INTO MEDIA_TYPE VALUES(1,'wml','UTF-8','WML','Format for mobile phones and
PDAs compatible with WML 1.1')
-INSERT INTO MEDIA_TYPE VALUES(2,'vxml','UTF-8','VoiceXML','Format suitable for use
with an audio VoiceXML server')
-INSERT INTO MEDIA_TYPE VALUES(3,'xml','','XML','XML 1.0')
-INSERT INTO CLIENT VALUES(1,'ie5','.*MSIE 5.*','Microsoft','None','5.5',0)
-INSERT INTO CLIENT VALUES(2,'ns4','.*Mozilla/4.*','Netscape','None','4.75',0)
-INSERT INTO CLIENT VALUES(3,'mozilla','.*Mozilla/5.*','Mozilla','Mozilla','1.x',0)
-INSERT INTO CLIENT VALUES(4,'lynx','Lynx.*','GNU','None','',0)
-INSERT INTO CLIENT VALUES(5,'nokia_generic','Nokia.*','Nokia','Generic','',1)
-INSERT INTO CLIENT VALUES(6,'up','UP.*|.*UP\.Browser.*','United
Planet','Generic','',1)
-INSERT INTO CLIENT
VALUES(7,'sonyericsson','Ercis.*|SonyE.*','SonyEricsson','Generic','',1)
-INSERT INTO CLIENT VALUES(8,'wapalizer','Wapalizer.*','Wapalizer','Generic','',1)
-INSERT INTO CLIENT VALUES(9,'klondike','Klondike.*','Klondike','Generic','',1)
-INSERT INTO CLIENT
VALUES(10,'wml_generic','.*WML.*|.*WAP.*|.*Wap.*|.*wml.*','Generic','Generic','',1)
-INSERT INTO CLIENT VALUES(11,'vxml_generic','.*VoiceXML.*','Generic','Generic','',2)
-INSERT INTO CLIENT VALUES(12,'nuance','Nuance.*','Nuance','Generic','',2)
-INSERT INTO CLIENT VALUES(13,'agentxml','agentxml/1.0.*','Unknown','Generic','',3)
-INSERT INTO CLIENT VALUES(14,'opera7','.*Opera/7.*','Opera','Opera7','7.x',0)
-INSERT INTO MIMETYPE VALUES(0,'text/html')
-INSERT INTO MIMETYPE VALUES(1,'text/vnd.wap.wml')
-INSERT INTO MIMETYPE VALUES(2,'text/vxml')
-INSERT INTO MIMETYPE VALUES(3,'text/xml')
-INSERT INTO MIMETYPE VALUES(4,'text/xhtml')
-INSERT INTO CAPABILITY VALUES(0,'HTML_3_2')
-INSERT INTO CAPABILITY VALUES(1,'HTML_4_0')
-INSERT INTO CAPABILITY VALUES(2,'HTML_TABLE')
-INSERT INTO CAPABILITY VALUES(3,'HTML_NESTED_TABLE')
-INSERT INTO CAPABILITY VALUES(4,'HTML_IMAGE')
-INSERT INTO CAPABILITY VALUES(5,'HTML_FORM')
-INSERT INTO CAPABILITY VALUES(6,'HTML_FRAME')
-INSERT INTO CAPABILITY VALUES(7,'HTML_JAVA')
-INSERT INTO CAPABILITY VALUES(8,'HTML_JAVA1_0')
-INSERT INTO CAPABILITY VALUES(9,'HTML_JAVA1_1')
-INSERT INTO CAPABILITY VALUES(10,'HTML_JAVA1_2')
-INSERT INTO CAPABILITY VALUES(11,'HTML_JAVA_JRE')
-INSERT INTO CAPABILITY VALUES(12,'HTML_JSCRIPT')
-INSERT INTO CAPABILITY VALUES(13,'HTML_JSCRIPT1_0')
-INSERT INTO CAPABILITY VALUES(14,'HTML_JSCRIPT1_1')
-INSERT INTO CAPABILITY VALUES(15,'HTML_JSCRIPT1_2')
-INSERT INTO CAPABILITY VALUES(16,'HTML_JAVASCRIPT')
-INSERT INTO CAPABILITY VALUES(17,'HTML_JAVASCRIPT_1_0')
-INSERT INTO CAPABILITY VALUES(18,'HTML_JAVASCRIPT_1_1')
-INSERT INTO CAPABILITY VALUES(19,'HTML_JAVASCRIPT_1_2')
-INSERT INTO CAPABILITY VALUES(20,'HTML_PLUGIN')
-INSERT INTO CAPABILITY VALUES(21,'HTML_ACTIVEX')
-INSERT INTO CAPABILITY VALUES(22,'HTML_PLUGIN')
-INSERT INTO CAPABILITY VALUES(23,'HTML_CSS1')
-INSERT INTO CAPABILITY VALUES(24,'HTML_CSS2')
-INSERT INTO CAPABILITY VALUES(25,'HTML_CSSP')
-INSERT INTO CAPABILITY VALUES(26,'HTML_IFRAME')
-INSERT INTO CAPABILITY VALUES(27,'HTML_LAYER')
-INSERT INTO CAPABILITY VALUES(28,'HTML_DOM_IE')
-INSERT INTO CAPABILITY VALUES(29,'HTML_DOM_NS4')
-INSERT INTO CAPABILITY VALUES(30,'HTML_DOM_1')
-INSERT INTO CAPABILITY VALUES(31,'HTML_DOM_2')
-INSERT INTO CAPABILITY VALUES(32,'WML_1_0')
-INSERT INTO CAPABILITY VALUES(33,'WML_1_1')
-INSERT INTO CAPABILITY VALUES(34,'WML_TABLE')
-INSERT INTO CAPABILITY VALUES(35,'XML_XSLT')
-INSERT INTO CAPABILITY VALUES(36,'XML_XPATH')
-INSERT INTO CAPABILITY VALUES(37,'XML_XINCLUDE')
-INSERT INTO CAPABILITY VALUES(38,'HTTP_1_1')
-INSERT INTO CAPABILITY VALUES(39,'HTTP_COOKIE')
-INSERT INTO CAPABILITY VALUES(40,'HTML_XML')
-INSERT INTO CAPABILITY VALUES(41,'HTML_XSL')
-INSERT INTO CAPABILITY VALUES(42,'HTML_DOM')
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,0)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,7)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,16)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,2)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,3)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,5)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,6)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,4)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,21)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,23)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,24)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,25)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,26)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,28)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(1,39)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(2,0)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(2,7)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(2,16)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(2,2)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(2,5)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(2,6)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(2,4)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(2,23)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(2,27)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(2,20)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(2,29)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(2,39)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,0)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,1)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,7)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,11)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,16)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,2)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,3)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,5)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,6)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,26)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,4)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,23)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,24)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,25)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,30)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,22)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(3,39)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(4,2)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(4,3)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(4,5)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(4,6)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(4,39)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,0)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,1)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,2)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,7)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,11)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,16)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,3)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,5)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,6)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,4)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,26)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,23)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,24)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,25)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,30)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,39)
-INSERT INTO CLIENT_TO_CAPABILITY VALUES(14,22)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(1,0)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(1,3)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(2,0)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(3,0)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(3,4)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(3,3)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(4,0)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(5,1)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(6,1)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(7,1)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(8,1)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(9,1)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(10,1)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(11,2)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(12,2)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(13,3)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(14,0)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(14,3)
-INSERT INTO CLIENT_TO_MIMETYPE VALUES(14,4)
-INSERT INTO MEDIATYPE_TO_MIMETYPE VALUES(0,0)
-INSERT INTO MEDIATYPE_TO_MIMETYPE VALUES(1,1)
-INSERT INTO MEDIATYPE_TO_MIMETYPE VALUES(2,2)
-INSERT INTO MEDIATYPE_TO_MIMETYPE VALUES(3,3)
-INSERT INTO PROFILING_RULE
VALUES('j1','org.apache.jetspeed.profiler.rules.impl.StandardProfilingRule','The
default profiling rule following the Jetspeed-1 hard-coded profiler fallback
algorithm.')
-INSERT INTO PROFILING_RULE
VALUES('path','org.apache.jetspeed.profiler.rules.impl.StandardProfilingRule','use a
path to locate.')
-INSERT INTO PROFILING_RULE
VALUES('role-fallback','org.apache.jetspeed.profiler.rules.impl.RoleFallbackProfilingRule','A
role based fallback algorithm based on Jetspeed-1 role-based fallback')
-INSERT INTO RULE_CRITERION VALUES('1','j1',0,'path.session','page','default-page',0)
-INSERT INTO RULE_CRITERION VALUES('10','path',0,'path','path','/',0)
-INSERT INTO RULE_CRITERION VALUES('2','j1',1,'group.role.user','user',NULL,0)
-INSERT INTO RULE_CRITERION VALUES('3','j1',2,'mediatype','mediatype',NULL,1)
-INSERT INTO RULE_CRITERION VALUES('4','j1',3,'language','language',NULL,1)
-INSERT INTO RULE_CRITERION VALUES('5','j1',4,'country','country',NULL,1)
-INSERT INTO RULE_CRITERION
VALUES('6','role-fallback',0,'request.session','page','default-page',0)
-INSERT INTO RULE_CRITERION VALUES('7','role-fallback',1,'role','role',NULL,2)
-INSERT INTO PRINCIPAL_RULE_ASSOC VALUES('anon','j1')
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
