pocolap-cvscommit Mailing List for pocOLAP - the little OLAP project (Page 3)

Brought to you by: axel80, doichy, rashmij, toddrun

pocolap-cvscommit — Notice of CVS commits

You can subscribe to this list here.

2005	_Jan	_Feb	_Mar (64)	_Apr (38)	_May (3)	_Jun	_Jul	_Aug	_Sep	_Oct	_Nov	_Dec

Flat | Threaded

<< < 1 2 3 4 5 > >> (Page 3 of 5)

[Pocolap-cvscommit] pocolap/userdocs/sampledata/pocolapDB/sampleDB nss.properties,1.1,NONE nss.script,1.1,NONE service.properties,1.1,NONE

From: todd r. <to...@us...> - 2005-03-31 20:58:47

Update of /cvsroot/pocolap/pocolap/userdocs/sampledata/pocolapDB/sampleDB
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/userdocs/sampledata/pocolapDB/sampleDB

Removed Files:
	nss.properties nss.script service.properties 
Log Message:
Reorganization of resources

--- service.properties DELETED ---

--- nss.script DELETED ---

--- nss.properties DELETED ---

[Pocolap-cvscommit] pocolap/data/pocolapDB/resources pocologo_tiny.jpg,NONE,1.1

From: todd r. <to...@us...> - 2005-03-31 20:58:39

Update of /cvsroot/pocolap/pocolap/data/pocolapDB/resources
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/pocolapDB/resources

Added Files:
	pocologo_tiny.jpg 
Log Message:
Reorganization of resources

--- NEW FILE: pocologo_tiny.jpg ---
(This appears to be a binary file; contents omitted.)

[Pocolap-cvscommit] pocolap/data/pocolapDB/crosstabdefs hsqldbconfig.xml,NONE,1.1 derbyconfig.xml,NONE,1.1

From: todd r. <to...@us...> - 2005-03-31 20:58:39

Update of /cvsroot/pocolap/pocolap/data/pocolapDB/crosstabdefs
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/pocolapDB/crosstabdefs

Added Files:
	hsqldbconfig.xml derbyconfig.xml 
Log Message:
Reorganization of resources

--- NEW FILE: derbyconfig.xml ---
<crosstab xmlns="http://www.pocolap.com">
	<rept name="Employee Hours Sample" index="58">
		<!-- This is the config file for the Sample database that
      		comes with pocolap.  This should be placed in the 
      		pocolapDB/crosstabdefs directory if you would like 
      		to use the sample database.  You may remove this 
      		file if you do not want to use the sample database.
    	--> 
		<source classtype="com.pocolap.conn.PocOlapSampleDatabaseConnection" driver="org.apache.derby.jdbc.EmbeddedDriver" dbString="jdbc:derby:;databaseName=${}"/>
		<measure name="Hours Worked" table="LABORHOURS" key="HOURS" function="sum" />
		<dimension name="Employees" table="EMPLOYEES" key="EMPID" measureKey="EMPID">
				<group name="Employee" defaultField="Employee Last Name">
						<field name="Employee Last Name" key="LASTNAME" />						
						<drilldown>Position</drilldown>						
				</group>
				<group name="Position">
						<field name="Position" key="POSITION" />	
						<drilldown>Employee</drilldown>
						<drilldown>Status</drilldown>
				</group>
				<group name="Status">
						<field name="Status" key="STATUS" />												 
						<field name="Paid Weekly" key="ISPAIDWEEKLY" />					
				</group>
		</dimension>
		
		<dimension name="Work Items" table="WORKITEMS" key="ITEMID" measureKey="ITEMID">
				<group name="Work Item">					
					<field name="Work" key="WORKNAME" />
					<drilldown>Customer Contact</drilldown>					
				</group>
				<group name="Customer Contact">
					<field name="Customer Contact" key="CUSTOMERCONTACT" />
					<drilldown>Work Item</drilldown>
				</group>
		</dimension>
		
		<dimension name="Work Types" table="WORKTYPES" key="TYPEID" measureKey="TYPEID">
				<group name="Work Type">					
					<field name="Type" key="TYPENAME" />					
				</group>
				<group name="Is Overtime">
					<field name="Is Overtime" key="ISOVERTIME" />
				</group>
		</dimension>
		<dimension name="Dates" table="CALENDAR" key="CALENDARID" measureKey="CALENDARID">
				<group name="Work Date">
					<field name="Date" key="DAYDATE" />
				</group>
				<group name="Month" defaultField="MONTH">
					<field name="Month" key="MONTHNAME" />
					<field name="Abbreviated Month" key="MONTHABBREV" />
					<drilldown>Work Date</drilldown>
				</group>
				<group name="Month Number">
					<field name="Number of Month" key="MONTHOFYEAR" />	
					<drilldown>Month</drilldown>
					<drilldown>Work Date</drilldown>
				</group>
				<group name="Year">
					<field name="Year" key="&quot;year&quot;" />
					<drilldown>Month Number</drilldown>
					<drilldown>Month</drilldown>
					<drilldown>Work Date</drilldown>
				</group>
		</dimension>
		
		<supplemental>
			<description>This shows data stored in a Derby database</description>
			<link linktext="Learn more at the pocOLAP home page" linkurl="http://pocolap.sourceforge.net" />
		</supplemental>
		
	</rept>
	<savedreport name="Inventory Week">
		<selector>
			<selectordimension across="Employees" down="Work Items" />
			<across name="Position" index="1" />
			<across name="Employee" index="2" />
			<down name="Work Item" index="1" />
		</selector>
		<filter>
			<table name="Dates">
				<field name="Date" type="date">
					<range startvalue="2003-01-28" endvalue="2003-02-01" />
				</field>
			</table>
		</filter>
	</savedreport>
</crosstab>

--- NEW FILE: hsqldbconfig.xml ---
<crosstab xmlns="http://www.pocolap.com">
	<rept name="Alternative SpreadSheet" index="59">
		<!-- This is the config file for the HSQLDB Sample database that
			comes with pocolap.   This should be placed in the 
			pocolapDB/crosstabdefs directory if you would like 
			to use the sample database.  You may remove this 
			file if you do not want to use the sample database.
		--> 
		<source classtype="com.pocolap.conn.PocOlapSampleDatabaseConnection" driver="org.hsqldb.jdbcDriver" dbString="jdbc:hsqldb:${}/nss" user="sa" pass="" />
		<measure name="Sold Items" table="SALES" key="AMOUNT" function="sum" />
		<dimension name="Customers" table="CUSTOMERS" key="CUSTOMERID" measureKey="CUSTOMERID">
			<group name="Customer" defaultField="Customer Last Name">
				<field name="Customer Last Name" key="LASTNAME" />
				<!-- other fields are to be used when formatting is implemented -->
				<field name="Customer Number" key="CUSTOMERNUMBER" />
				<drilldown>Shoe Size</drilldown>
			</group>
			<group name="Customer Origin" defaultField="Zip Code">
				<field name="Zip Code" key="ZIP" />
				<field name="City" key="CITY" />
				<drilldown>Customer</drilldown>
			</group>
			<group name="Shoe Size">
				<field name="Shoe Size" key="SHOESIZE" />
				<field name="Size Type" key="SIZINGGENDER" />
				<field name="Extra Width" key="WIDESIZES" />
			</group>
		</dimension>
		<dimension name="Items to Sell" table="SALABLEITEMS" key="SALABLEITEMSID" measureKey="SALABLEITEMSID">
			<group name="Stock Keeping Unit">
				<field name="SKU Value" key="SKU" />
				<field name="Product Desription" key="DESCRIPTION" />
				<field name="Product or Service" key="ISPRODUCT" />
				<drilldown>Vendor</drilldown>
			</group>
			<group name="Vendor">
				<field name="Vendor Name" key="VENDOR" />
				<field name="Vendor Number" key="VENDORNUMBER" />	
				<drilldown>Stock Keeping Unit</drilldown>
			</group>
		</dimension>
		<dimension name="Dates" table="CALENDAR" key="CALENDARID" measureKey="CALENDARID">
			<group name="Sale Date">
				<field name="Date" key="DAYDATE" />
			</group>
			<group name="Month" defaultField="Month">
				<field name="Number of Month" key="MONTHOFYEAR" />	
				<field name="Month" key="MONTHNAME" />
				<field name="Abbreviated Month" key="MONTHABBREV" />
				<drilldown>Sale Date</drilldown>
			</group>
			<group name="Year">
				<field name="Year" key="YEAR" />
				<drilldown>Month</drilldown>
				<drilldown>Sale Date</drilldown>
			</group>
		</dimension>
		<supplemental>
			<description>This shows data stored in an HSQLDB database</description>
			<link linktext="Learn more at the pocOLAP home page" linkurl="http://pocolap.sourceforge.net" />
		</supplemental>
	</rept>
</crosstab>

[Pocolap-cvscommit] pocolap/data/scripts_tools/hsqldb hsqldb.jar,NONE,1.1

From: todd r. <to...@us...> - 2005-03-31 20:58:37

Update of /cvsroot/pocolap/pocolap/data/scripts_tools/hsqldb
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/scripts_tools/hsqldb

Added Files:
	hsqldb.jar 
Log Message:
Reorganization of resources

--- NEW FILE: hsqldb.jar ---
(This appears to be a binary file; contents omitted.)

[Pocolap-cvscommit] pocolap/data/pocolapDB/sampleDB/seg0 c191.dat,NONE,1.1 c3d1.dat,NONE,1.1 c260.dat,NONE,1.1 ce1.dat,NONE,1.1 c101.dat,NONE,1.1 c1c0.dat,NONE,1.1 c351.dat,NONE,1.1 c241.dat,NONE,1.1 c281.dat,NONE,1.1 c290.dat,NONE,1.1 c31.dat,NONE,1.1 c150.dat,NONE,1.1 c3c0.dat,NONE,1.1 c431.dat,NONE,1.1 c20.dat,NONE,1.1 cc0.dat,NONE,1.1 c81.dat,NONE,1.1 c300.dat,NONE,1.1 c51.dat,NONE,1.1 c2b1.dat,NONE,1.1 c1d1.dat,NONE,1.1 c2c1.dat,NONE,1.1 cf0.dat,NONE,1.1 c411.dat,NONE,1.1 c2f0.dat,NONE,1.1 c3f1.dat,NONE,1.1 c141.dat,NONE,1.1 c271.dat,NONE,1.1 c90.dat,NONE,1.1 c1b1.dat,NONE,1.1 c1f1.dat,NONE,1.1 c71.dat,NONE,1.1 c130.dat,NONE,1.1 c360.dat,NONE,1.1 c3a0.dat,NONE,1.1 c161.dat,NONE,1.1 c340.dat,NONE,1.1 c251.dat,NONE,1.1 c331.dat,NONE,1.1 c230.dat,NONE,1.1 c171.dat,NONE,1.1 c2d0.dat,NONE,1.1 c420.dat,NONE,1.1 c1e0.dat,NONE,1.1 c2e1.dat,NONE,1.1 c3b1.dat,NONE,1.1 c111.dat,NONE,1.1 c121.dat,NONE,1.1 c400.dat,NONE,1.1 c311.dat,NONE,1.1 c1a1.dat,NONE,1.1 c200.dat,NONE,1.1 c60.dat,NONE,1.1 cd1.dat,NONE,1.1 ca1.dat,NONE,1.1 c41.dat,NONE,1.1 c2a1.dat,NONE,1.1 c221.dat,NONE,1.1 c3e0.dat,NONE,1.1 c180.dat,NONE,1.1 cb1.dat,NONE,1.1 c320.dat,NONE,1.1 c10.dat,NONE,1.1 c211.dat,NONE,1.1

From: todd r. <to...@us...> - 2005-03-31 20:58:37

Update of /cvsroot/pocolap/pocolap/data/pocolapDB/sampleDB/seg0
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/pocolapDB/sampleDB/seg0

Added Files:
	c191.dat c3d1.dat c260.dat ce1.dat c101.dat c1c0.dat c351.dat 
	c241.dat c281.dat c290.dat c31.dat c150.dat c3c0.dat c431.dat 
	c20.dat cc0.dat c81.dat c300.dat c51.dat c2b1.dat c1d1.dat 
	c2c1.dat cf0.dat c411.dat c2f0.dat c3f1.dat c141.dat c271.dat 
	c90.dat c1b1.dat c1f1.dat c71.dat c130.dat c360.dat c3a0.dat 
	c161.dat c340.dat c251.dat c331.dat c230.dat c171.dat c2d0.dat 
	c420.dat c1e0.dat c2e1.dat c3b1.dat c111.dat c121.dat c400.dat 
	c311.dat c1a1.dat c200.dat c60.dat cd1.dat ca1.dat c41.dat 
	c2a1.dat c221.dat c3e0.dat c180.dat cb1.dat c320.dat c10.dat 
	c211.dat 
Log Message:
Reorganization of resources

--- NEW FILE: c191.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c2a1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c2b1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c2c1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c2e1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c320.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c1d1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c300.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c3f1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c51.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c1a1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c431.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c161.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c360.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: cf0.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: ce1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c400.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c3b1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c1f1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: ca1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c130.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c290.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c150.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c241.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c81.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c2d0.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c180.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c3a0.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c171.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c3c0.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c1c0.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c10.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c101.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c271.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c121.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c230.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c260.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c20.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c1e0.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c60.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c411.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c281.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c3d1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c331.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c2f0.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c31.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c211.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c221.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: cc0.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c200.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c41.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: cb1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c340.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c1b1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c141.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c71.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: cd1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c90.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c3e0.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c251.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c311.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c111.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c351.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: c420.dat ---
(This appears to be a binary file; contents omitted.)

[Pocolap-cvscommit] pocolap/userdocs/sampledata/pocolapDB/sampleDB/seg0 c1b1.dat,1.1,NONE c281.dat,1.1,NONE c260.dat,1.1,NONE c71.dat,1.1,NONE c41.dat,1.1,NONE c20.dat,1.1,NONE c31.dat,1.1,NONE ce1.dat,1.1,NONE c1a1.dat,1.1,NONE c90.dat,1.1,NONE c10.dat,1.1,NONE cd1.dat,1.1,NONE c130.dat,1.1,NONE c200.dat,1.1,NONE c81.dat,1.1,NONE c1f1.dat,1.1,NONE c300.dat,1.1,NONE cb1.dat,1.1,NONE c241.dat,1.1,NONE c150.dat,1.1,NONE c101.dat,1.1,NONE c111.dat,1.1,NONE c141.dat,1.1,NONE c211.dat,1.1,NONE c221.dat,1.1,NONE c2b1.dat,1.1,NONE c171.dat,1.1,NONE c360.dat,1.1,NONE c331.dat,1.1,NONE c271.dat,1.1,NONE c230.dat,1.1,NONE c351.dat,1.1,NONE c251.dat,1.1,NONE c2e1.dat,1.1,NONE c161.dat,1.1,NONE c51.dat,1.1,NONE c121.dat,1.1,NONE c60.dat,1.1,NONE c1d1.dat,1.1,NONE c320.dat,1.1,NONE c2f0.dat,1.1,NONE c2a1.dat,1.1,NONE c191.dat,1.1,NONE c1e0.dat,1.1,NONE c290.dat,1.1,NONE ca1.dat,1.1,NONE c2d0.dat,1.1,NONE c180.dat,1.1,NONE c2c1.dat,1.1,NONE c311.dat,1.1,NONE c340.dat,1.1,NONE cf0.dat,1.1,NONE c1c0.dat,1.1,NONE cc0.dat,1.1,NONE

From: todd r. <to...@us...> - 2005-03-31 20:58:34

Update of /cvsroot/pocolap/pocolap/userdocs/sampledata/pocolapDB/sampleDB/seg0
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/userdocs/sampledata/pocolapDB/sampleDB/seg0

Removed Files:
	c1b1.dat c281.dat c260.dat c71.dat c41.dat c20.dat c31.dat 
	ce1.dat c1a1.dat c90.dat c10.dat cd1.dat c130.dat c200.dat 
	c81.dat c1f1.dat c300.dat cb1.dat c241.dat c150.dat c101.dat 
	c111.dat c141.dat c211.dat c221.dat c2b1.dat c171.dat c360.dat 
	c331.dat c271.dat c230.dat c351.dat c251.dat c2e1.dat c161.dat 
	c51.dat c121.dat c60.dat c1d1.dat c320.dat c2f0.dat c2a1.dat 
	c191.dat c1e0.dat c290.dat ca1.dat c2d0.dat c180.dat c2c1.dat 
	c311.dat c340.dat cf0.dat c1c0.dat cc0.dat 
Log Message:
Reorganization of resources

--- c191.dat DELETED ---

--- c2a1.dat DELETED ---

--- c2b1.dat DELETED ---

--- c2c1.dat DELETED ---

--- c2e1.dat DELETED ---

--- c320.dat DELETED ---

--- c300.dat DELETED ---

--- c51.dat DELETED ---

--- c251.dat DELETED ---

--- c161.dat DELETED ---

--- c360.dat DELETED ---

--- cf0.dat DELETED ---

--- ce1.dat DELETED ---

--- c260.dat DELETED ---

--- cd1.dat DELETED ---

--- c1f1.dat DELETED ---

--- ca1.dat DELETED ---

--- c130.dat DELETED ---

--- c290.dat DELETED ---

--- c150.dat DELETED ---

--- c241.dat DELETED ---

--- c311.dat DELETED ---

--- c81.dat DELETED ---

--- c2d0.dat DELETED ---

--- c171.dat DELETED ---

--- c1e0.dat DELETED ---

--- c1c0.dat DELETED ---

--- c10.dat DELETED ---

--- c101.dat DELETED ---

--- c71.dat DELETED ---

--- c121.dat DELETED ---

--- c230.dat DELETED ---

--- c141.dat DELETED ---

--- c1a1.dat DELETED ---

--- c60.dat DELETED ---

--- c271.dat DELETED ---

--- c281.dat DELETED ---

--- c1b1.dat DELETED ---

--- c331.dat DELETED ---

--- c2f0.dat DELETED ---

--- c31.dat DELETED ---

--- c211.dat DELETED ---

--- c221.dat DELETED ---

--- cc0.dat DELETED ---

--- c180.dat DELETED ---

--- c41.dat DELETED ---

--- cb1.dat DELETED ---

--- c340.dat DELETED ---

--- c1d1.dat DELETED ---

--- c90.dat DELETED ---

--- c20.dat DELETED ---

--- c200.dat DELETED ---

--- c111.dat DELETED ---

--- c351.dat DELETED ---

[Pocolap-cvscommit] pocolap/userdocs/CrosstabXSD build.xml,1.1,NONE pocOLAPConfig.xsd,1.8,NONE crosstab.jar,1.8,NONE pocOLAPConfig.xsdconfig,1.5,NONE

From: todd r. <to...@us...> - 2005-03-31 20:58:30

Update of /cvsroot/pocolap/pocolap/userdocs/CrosstabXSD
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/userdocs/CrosstabXSD

Removed Files:
	build.xml pocOLAPConfig.xsd crosstab.jar 
	pocOLAPConfig.xsdconfig 
Log Message:
Reorganization of resources

--- pocOLAPConfig.xsdconfig DELETED ---

--- crosstab.jar DELETED ---

--- pocOLAPConfig.xsd DELETED ---

--- build.xml DELETED ---

[Pocolap-cvscommit] pocolap/data/scripts_tools/outdated/oldtools/com/pocolap/hsqldb/datetime DateAgent.java,NONE,1.1

From: todd r. <to...@us...> - 2005-03-31 20:58:02

Update of /cvsroot/pocolap/pocolap/data/scripts_tools/outdated/oldtools/com/pocolap/hsqldb/datetime
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/scripts_tools/outdated/oldtools/com/pocolap/hsqldb/datetime

Added Files:
	DateAgent.java 
Log Message:
Reorganization of resources

--- NEW FILE: DateAgent.java ---
/*
 * DateAgent.java
 * Created on Jan 23, 2004
 *
 Copyright (c) 2003 Todd Runstein

Permission is hereby granted, free of charge, to any person obtaining a copy 
of this software and associated documentation files (the "Software"), to deal 
in the Software without restriction, including without limitation the rights to use, 
copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the 
Software, and to permit persons to whom the Software is furnished to do so, 
subject to the following conditions:

The above copyright notice and this permission notice shall be included in all 
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, 
EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES 
OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND 
NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT 
HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, 
WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING 
FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR 
OTHER DEALINGS IN THE SOFTWARE.
 */

package com.pocolap.hsqldb.datetime;

import java.sql.Date;
import java.text.ParseException;
import java.text.SimpleDateFormat;

/**
 * DateAgent is intended to be used when building an HSQLDB database
 * using the script created by the tools provided with pocolap.
 * 
 * This uses deprecated methods - if you have a problem with that, go ahead 
 * and write it!
 * 
 * @author todd
 *
 */
public class DateAgent {

	/* ARGs match MySQL arguments for "DATE_FORMAT" method */
	private static String ARG_DAY_NAME = "%W";
	private static String ARG_DAY_ABRV = "%a";
	private static String ARG_DAY_NUMBER = "%w";
	private static String ARG_DAY_OF_MONTH_NUMBER = "%e";
	private static String ARG_MONTH_NAME = "%M";
	private static String ARG_MONTH_ABRV = "%b";
	private static String ARG_MONTH_NUMBER = "%c";
	private static String ARG_YEAR_NUMBER = "%Y";
	
	private static String[] FULL_DAYS = {"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"};
	private static String[] FULL_MONTHS = {"January", "February", "March", "April", "May", "June","July", "August", "September", "October", "November", "December"};


	public static Date dateAdd(Date date, long increment){
		return new Date(date.getTime()+(1000*60*60*24*increment));
	}
	
	public static String dateFormat(Date date,String arg){
		String retVal = null;
		if (arg.equals(ARG_DAY_NAME)){
			retVal = doFullDayName(date);
		}else if(arg.equals(ARG_DAY_ABRV)){
			retVal = doAbbrvDayName(date);
		}else if(arg.equals(ARG_DAY_NUMBER)){
			retVal = new Integer(doDayNumber(date)).toString();
		}else if(arg.equals(ARG_DAY_OF_MONTH_NUMBER)){
			retVal = new Integer(doDayOfMonthNumber(date)).toString();
		}else if(arg.equals(ARG_MONTH_NAME)){
			retVal = doFullMonthName(date);
		}else if (arg.equals(ARG_MONTH_ABRV)){
			retVal = doAbbrvMonthName(date);
		}else if(arg.equals(ARG_MONTH_NUMBER)){
			retVal = new Integer(doMonthNumber(date)).toString();
		}else if(arg.equals(ARG_YEAR_NUMBER)){
			retVal = new Integer(doYearNumber(date)).toString();
		}
		
		return retVal;
	}
	
	private static int getMonthsInt(Date date){
		return date.getMonth();
	}
	
	protected static int doYearNumber(Date date){
		return date.getYear()+1900;
	}
	
	protected static int doMonthNumber(Date date){
		return getMonthsInt(date)+1;
	}
	
	protected static int doDayNumber(Date date){
		return date.getDay();
	}
	
	protected static int doDayOfMonthNumber(Date date){
		return date.getDate();
	}
	
	protected static String doFullMonthName(Date date){
		return FULL_MONTHS[getMonthsInt(date)];
	}
	
	protected static String doAbbrvMonthName(Date date){
		String retVal = null;
		String fullMonth = doFullMonthName(date);
		if (fullMonth!=null && fullMonth.length()>2){
			retVal = fullMonth.substring(0,3);
		}
		
		return retVal;
	}
	
	protected static String doFullDayName(Date date){
		return FULL_DAYS[doDayNumber(date)];
	}
	
	protected static String doAbbrvDayName(Date date){
		String retVal = null;
		String fullDay = doFullDayName(date);
		if (fullDay!=null && fullDay.length()>3){
			retVal = fullDay.substring(0,3);
		}
		
		return retVal;
	}
	
	
	public static void main(String[] args){
		//In lieu of a formal JUnit test!
		if (args.length<1){
			System.out.println("USAGE: (<\"true\">)|(<date><increment>) ");
			return;
		}
		if (args.length==1){
			if (args[0].equalsIgnoreCase("true")){
				doAutoTest();
			}else{
				System.out.println("USAGE: (<\"true\">)|(<date><increment>) ");
				return;
			}
		}else{
			doUserTest(args);
		}
	}
	
	public static void doAutoTest(){
		SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
		try {
			Date One = new Date(format.parse("2003-12-29").getTime());
			
			Date One2 = new Date(format.parse("2003-12-31").getTime());
			Date One7 = new Date(format.parse("2004-1-5").getTime());
			Date One9 = new Date(format.parse("2004-1-7").getTime());
			
			Date mOne2 = new Date(format.parse("2003-12-27").getTime());
			Date mOne7 = new Date(format.parse("2003-12-22").getTime());
			Date mOne9 = new Date(format.parse("2003-12-20").getTime());
			
			Date tMay = new Date(format.parse("2003-05-15").getTime());
			
			int i2 = 2;
			int i7 = 7;
			int i9 = 9;
		
			Date tOne = DateAgent.dateAdd(One, i2);
			String testVal = null;
			if (!tOne.equals(One2)){
				//Check date
				System.out.println("Failure: "+tOne.toString() + " should be " + One2.toString());
			}else{
				//Check days
				testVal = dateFormat(tOne,"%W");
				if (!testVal.equals(FULL_DAYS[3])){
					System.out.println("Failure: "+tOne.toString() + " reporting as " + testVal + " should be " + FULL_DAYS[3]); 
				}
				testVal = dateFormat(tOne,"%a");
				if (!testVal.equals("Wed")){
					System.out.println("Failure:" + tOne.toString() + " reporting as \"" + testVal + "\" should be \"Wed\"" );
				}
				testVal = dateFormat(tOne,"%w");
				if (!testVal.equals("3")){
					System.out.println("Failure:" + tOne.toString() + " reporting as \"" + testVal + "\" should be \"3\"" );
				}
				testVal = dateFormat(tOne,"%e");
				if (!testVal.equals("31")){
					System.out.println("Failure:" + tOne.toString() + " reporting as \"" + testVal + "\" should be \"31\"" );
				}
				testVal = dateFormat(tOne,"%M");
				if (!testVal.equals("December")){
					System.out.println("Failure:" + tOne.toString() + " reporting as \"" + testVal + "\" should be \"December\"" );
				}
				testVal = dateFormat(tOne,"%M");
				if (!testVal.equals("December")){
					System.out.println("Failure:" + tOne.toString() + " reporting as \"" + testVal + "\" should be \"December\"" );
				}
				testVal = dateFormat(tOne,"%b");
				if (!testVal.equals("Dec")){
					System.out.println("Failure:" + tOne.toString() + " reporting as \"" + testVal + "\" should be \"Dec\"" );
				}
				//Special test for May
				testVal = dateFormat(tMay,"%b");
				if (!testVal.equals("May")){
					System.out.println("Failure:" + tOne.toString() + " reporting as \"" + testVal + "\" should be \"May\"" );
				}
				testVal = dateFormat(tOne,"%Y");
				if (!testVal.equals("2003")){
					System.out.println("Failure:" + tOne.toString() + " reporting as \"" + testVal + "\" should be \"2003\"" );
				}
			}
			//Here's the deal: you want more test, write them!
			tOne = DateAgent.dateAdd(One, (i2*-1));
			if (!tOne.equals(mOne2)){
				System.out.println("Failure: "+tOne.toString() + " should be " + mOne2.toString());
			}
			tOne = DateAgent.dateAdd(One, i7);
			if (!tOne.equals(One7)){
				System.out.println("Failure: "+tOne.toString() + " should be " + One7.toString());
			}
			tOne = DateAgent.dateAdd(One, (i7*-1));
			if (!tOne.equals(mOne7)){
				System.out.println("Failure: "+tOne.toString() + " should be " + mOne7.toString());
			}
			tOne = DateAgent.dateAdd(One, i9);
			if (!tOne.equals(One9)){
				System.out.println("Failure: "+tOne.toString() + " should be " + One9.toString());
			}
			tOne = DateAgent.dateAdd(One, (i9*-1));
			if (!tOne.equals(mOne9)){
				System.out.println("Failure: "+tOne.toString() + " should be " + mOne9.toString());
			}
		} catch (ParseException e) {
			System.out.println("The dates used for testing can't be parsed - "+
				"it's nothing you did, but you'll need to look at the doAutoTest method " +
				"to see what's wrong.  Sorry!");
		}
		System.out.println("Test complete");
	}
	
	public static void doUserTest(String[] args){	
		Date date = null;
		
		SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
		try {
			java.util.Date tDate = format.parse(args[0]);
			date = new Date(tDate.getTime());
		} catch (ParseException e) {
			System.out.println(args[0] + " is not in the right format (\"yyyy-MM-dd\")");
			return;
		}
		long increment = 0;
		try{
			increment = new Integer(args[1]).intValue();
		}catch(NumberFormatException e){
			System.out.println(args[1] + " can't be cast to an integer.  Try again");
			return;
		}
		
		String fullday = doFullDayName(date);
		System.out.println("Starting with "+date.toString() + " which is a " + fullday);
		Date newDate = DateAgent.dateAdd(date,increment);
		fullday = doFullDayName(newDate);
		System.out.println("Value returned: "+newDate.toString() + " which is a "+fullday);
		System.out.println("Done");
	}
	
}

[Pocolap-cvscommit] pocolap/data/pocolapDB/sampleDB/log log.ctrl,NONE,1.1 log1.dat,NONE,1.1 logmirror.ctrl,NONE,1.1

From: todd r. <to...@us...> - 2005-03-31 20:58:00

Update of /cvsroot/pocolap/pocolap/data/pocolapDB/sampleDB/log
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/pocolapDB/sampleDB/log

Added Files:
	log.ctrl log1.dat logmirror.ctrl 
Log Message:
Reorganization of resources

--- NEW FILE: log1.dat ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: logmirror.ctrl ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: log.ctrl ---
(This appears to be a binary file; contents omitted.)

[Pocolap-cvscommit] pocolap/sampleconfigs sampleconfig.xml,1.1.1.1,NONE

From: todd r. <to...@us...> - 2005-03-31 20:57:59

Update of /cvsroot/pocolap/pocolap/sampleconfigs
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/sampleconfigs

Removed Files:
	sampleconfig.xml 
Log Message:
Reorganization of resources

--- sampleconfig.xml DELETED ---

[Pocolap-cvscommit] pocolap/data/scripts_tools/outdated/oldtools - New directory

From: todd r. <to...@us...> - 2005-03-31 20:57:32

Update of /cvsroot/pocolap/pocolap/data/scripts_tools/outdated/oldtools
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9703/data/scripts_tools/outdated/oldtools

Log Message:
Directory /cvsroot/pocolap/pocolap/data/scripts_tools/outdated/oldtools added to the repository

[Pocolap-cvscommit] pocolap/data/scripts_tools/outdated - New directory

From: todd r. <to...@us...> - 2005-03-31 20:57:30

Update of /cvsroot/pocolap/pocolap/data/scripts_tools/outdated
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9703/data/scripts_tools/outdated

Log Message:
Directory /cvsroot/pocolap/pocolap/data/scripts_tools/outdated added to the repository

[Pocolap-cvscommit] pocolap/data/scripts_tools/outdated/oldtools/com/pocolap/hsqldb/datetime - New directory

From: todd r. <to...@us...> - 2005-03-31 20:57:29

Update of /cvsroot/pocolap/pocolap/data/scripts_tools/outdated/oldtools/com/pocolap/hsqldb/datetime
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9703/data/scripts_tools/outdated/oldtools/com/pocolap/hsqldb/datetime

Log Message:
Directory /cvsroot/pocolap/pocolap/data/scripts_tools/outdated/oldtools/com/pocolap/hsqldb/datetime added to the repository

[Pocolap-cvscommit] pocolap/data/pocolapDB/sampleDB - New directory

From: todd r. <to...@us...> - 2005-03-31 20:57:17

Update of /cvsroot/pocolap/pocolap/data/pocolapDB/sampleDB
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9703/data/pocolapDB/sampleDB

Log Message:
Directory /cvsroot/pocolap/pocolap/data/pocolapDB/sampleDB added to the repository

[Pocolap-cvscommit] pocolap/data/documentation - New directory

From: todd r. <to...@us...> - 2005-03-31 20:57:12

Update of /cvsroot/pocolap/pocolap/data/documentation
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9703/data/documentation

Log Message:
Directory /cvsroot/pocolap/pocolap/data/documentation added to the repository

[Pocolap-cvscommit] pocolap/userdocs/sampledata/pocolapDB log4j.properties,1.2,NONE

From: todd r. <to...@us...> - 2005-03-31 20:54:57

Update of /cvsroot/pocolap/pocolap/userdocs/sampledata/pocolapDB
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/userdocs/sampledata/pocolapDB

Removed Files:
	log4j.properties 
Log Message:
Reorganization of resources

--- log4j.properties DELETED ---

[Pocolap-cvscommit] pocolap/userdocs/sampledata/pocolapDB/crosstabdefs derbyconfig.xml,1.10,NONE hsqldbconfig.xml,1.4,NONE

From: todd r. <to...@us...> - 2005-03-31 20:54:56

Update of /cvsroot/pocolap/pocolap/userdocs/sampledata/pocolapDB/crosstabdefs
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/userdocs/sampledata/pocolapDB/crosstabdefs

Removed Files:
	derbyconfig.xml hsqldbconfig.xml 
Log Message:
Reorganization of resources

--- derbyconfig.xml DELETED ---

--- hsqldbconfig.xml DELETED ---

[Pocolap-cvscommit] pocolap/data/xsd/CrosstabXSD pocOLAPConfig.xsdconfig,NONE,1.1 pocOLAPConfig.xsd,NONE,1.1 build.xml,NONE,1.1 crosstab.jar,NONE,1.1

From: todd r. <to...@us...> - 2005-03-31 20:54:52

Update of /cvsroot/pocolap/pocolap/data/xsd/CrosstabXSD
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/xsd/CrosstabXSD

Added Files:
	pocOLAPConfig.xsdconfig pocOLAPConfig.xsd build.xml 
	crosstab.jar 
Log Message:
Reorganization of resources

--- NEW FILE: pocOLAPConfig.xsdconfig ---
<xb:config xmlns:xb="http://xml.apache.org/xmlbeans/2004/02/xbean/config"
           xmlns:pc="http://www.pocolap.com">
     
<xb:namespace uri="http://www.pocolap.com">
  <xb:package>com.pocolap.schema</xb:package>     
</xb:namespace>        

<xb:qname name="pc:sourceType" javaname="SourceItem" /> 
<xb:qname name="pc:measureType" javaname="MeasureItem" />  
<xb:qname name="pc:dimensionType" javaname="DimensionItem" /> 
<xb:qname name="pc:groupType" javaname="GroupItem" /> 
<xb:qname name="pc:reptType" javaname="ReptItem" /> 
<xb:qname name="pc:fieldType" javaname="FieldItem" /> 

<xb:qname name="pc:savedreportType" javaname="SavedReportItem" /> 
<xb:qname name="pc:selectorType" javaname="SelectorItem" /> 
<xb:qname name="pc:acrossType" javaname="AcrossItem" /> 
<xb:qname name="pc:selectordimensionType" javaname="SelectorDimensionItem" /> 
<xb:qname name="pc:downType" javaname="DownItem" /> 
<xb:qname name="pc:filterType" javaname="FilterItem" /> 
<xb:qname name="pc:tableType" javaname="TableItem" /> 
<xb:qname name="pc:filterfieldType" javaname="FilterFieldItem" /> 
<xb:qname name="pc:rangeType" javaname="RangeItem" /> 
<xb:qname name="pc:supplemental" javaname="SupplementalItem" />
<xb:qname name="pc:externallink" javaname="ExternalLinkItem" />
<xb:qname name="pc:reportIcon" javaname="ReportIconItem" />
<xb:qname name="pc:crosstab" javaname="CrossTabDef" /> 
 
<xb:qname name="pc:crosstabType" javaname="CrossTabDefItem" /> 

</xb:config>
--- NEW FILE: crosstab.jar ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: pocOLAPConfig.xsd ---
<?xml version="1.0"?>


 <xsd:schema  targetNamespace ="http://www.pocolap.com"
 xmlns:xsd="http://www.w3.org/2001/XMLSchema"
 xmlns:pc="http://www.pocolap.com"
 elementFormDefault="qualified" >

<xsd:element xmlns:pc="http://www.pocolap.com" name="crosstab" type="pc:crosstabType" />

<xsd:complexType name="crosstabType">
    <xsd:sequence>
      <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:reptType" name="rept"  minOccurs="1" maxOccurs="1" />
      <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:savedreportType" name="savedreport" minOccurs="0" maxOccurs="unbounded" />
    </xsd:sequence>
</xsd:complexType>

<xsd:complexType name="savedreportType">
  <xsd:sequence>
      <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:selectorType" name="selector"  minOccurs="0" maxOccurs="1" />         
      <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:filterType" name="filter"  minOccurs="0" maxOccurs="1" />         
  </xsd:sequence>
  <xsd:attribute name="name" use="required" type="xsd:string" />
</xsd:complexType>
  
<xsd:complexType name="selectorType">  
  <xsd:sequence>
     <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:selectordimensionType" name="selectordimension" minOccurs="0" maxOccurs="1" />
     <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:acrossType" name="across" minOccurs="0" maxOccurs="unbounded"/>
     <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:downType" name="down" minOccurs="0" maxOccurs="unbounded"/>    
  </xsd:sequence>
</xsd:complexType>

<xsd:complexType name="filterType">  
  <xsd:sequence>
     <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:tableType" name="table" minOccurs="0" maxOccurs="unbounded"/>  
  </xsd:sequence>
</xsd:complexType>

<xsd:complexType name="tableType">  
  <xsd:sequence>
     <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:filterfieldType" name="field" minOccurs="0" maxOccurs="unbounded"/>  
  </xsd:sequence>
  <xsd:attribute name="name" use="required" type="xsd:string" />
</xsd:complexType>

<xsd:complexType name="filterfieldType">
      <xsd:sequence> 
          <xsd:element name="matchlist" minOccurs="0" maxOccurs="unbounded" type="xsd:string"/> 
          <xsd:element name="excludeMatchList" minOccurs="0" maxOccurs="unbounded" type="xsd:string"/> 
          <xsd:element name="matchStrings" minOccurs="0" maxOccurs="unbounded" type="xsd:string"/> 
          <xsd:element name="excludeMatchStrings" minOccurs="0" maxOccurs="unbounded" type="xsd:string"/> 
          <xsd:element name="greaterThan" minOccurs="0" maxOccurs="1" type="xsd:string"/> 
          <xsd:element name="lessThan" minOccurs="0" maxOccurs="1" type="xsd:string"/> 
          <xsd:element name="combineWithAnd" minOccurs="0" maxOccurs="1" type="xsd:string"/> 
          <xsd:element type="pc:rangeType" name="range" minOccurs="0" maxOccurs="1" />
     </xsd:sequence>
       <xsd:attribute name="name" use="required" type="xsd:string" />
       <xsd:attribute name="type" use="required" type="xsd:string" />
</xsd:complexType>

<xsd:complexType name="rangeType">
    <xsd:attribute name="startvalue"   use="required" type="xsd:string" />
    <xsd:attribute name="endvalue"     use="required" type="xsd:string" />
</xsd:complexType>

<xsd:complexType name="selectordimensionType">
    <xsd:attribute name="across"  type="xsd:string" />
    <xsd:attribute name="down"  type="xsd:string" />
</xsd:complexType>

<xsd:complexType name="acrossType">
    <xsd:attribute name="name" use="required" type="xsd:string" />
    <xsd:attribute name="level" use="required"  type="xsd:string" />
</xsd:complexType>

<xsd:complexType name="downType">
    <xsd:attribute name="name" use="required" type="xsd:string" />
    <xsd:attribute name="level" use="required"  type="xsd:string" />
</xsd:complexType>
  
<xsd:complexType name="reptType">
     <xsd:sequence>
         <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:sourceType" name="source"  minOccurs="1" maxOccurs="1" />
         <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:measureType" name="measure" minOccurs="1" maxOccurs="1" />
         <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:dimensionType" name="dimension" minOccurs="1" maxOccurs="unbounded" />
         <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:supplemental" name="supplemental" minOccurs="0" maxOccurs="1" />
     </xsd:sequence>
     <xsd:attribute name="name" use="required" type="xsd:string" />
     <xsd:attribute name="index" type="xsd:integer" />
</xsd:complexType>

<xsd:complexType name="sourceType">
  <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:attribute name="classtype" use="required" type="xsd:string" />
        <xsd:attribute name="driver" type="xsd:string" />
        <xsd:attribute name="dbString" type="xsd:string" />
        <xsd:attribute name="user" type="xsd:string" />
        <xsd:attribute name="pass" type="xsd:string" />
        <xsd:attribute name="catalog" type="xsd:string" />
      </xsd:restriction>
    </xsd:complexContent>
</xsd:complexType>

<xsd:complexType name="measureType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
          <xsd:attribute name="name" use="required" type="xsd:string" />
          <xsd:attribute name="table" use="required" type="xsd:string" />
          <xsd:attribute name="key" use="required" type="xsd:string" />
          <xsd:attribute name="function" use="required" type="xsd:string" />
      </xsd:restriction>
    </xsd:complexContent>
</xsd:complexType>

<xsd:complexType name="dimensionType">
     <xsd:sequence>
         <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:groupType" name="group" maxOccurs="unbounded" minOccurs="1" />
     </xsd:sequence>
     <xsd:attribute name="name"  type="xsd:string" />
      <xsd:attribute name="table"  type="xsd:string" />
      <xsd:attribute name="key" type="xsd:string" />
      <xsd:attribute name="measureKey"  type="xsd:string" />
      <xsd:attribute name="defGroup"  type="xsd:string" />
</xsd:complexType>


 <xsd:complexType name="groupType">
      <xsd:sequence>
          <xsd:element xmlns:pc="http://www.pocolap.com" type="pc:fieldType" name="field" minOccurs="1" maxOccurs="unbounded"/>
          <xsd:element name="drilldown" minOccurs="0" maxOccurs="unbounded" type="xsd:string"/> 
      </xsd:sequence>
       <xsd:attribute name="name"  type="xsd:string" />
       <xsd:attribute name="defaultField"  type="xsd:string" />     
</xsd:complexType>

<xsd:complexType name="fieldType">
    <xsd:attribute name="name"  type="xsd:string" />
    <xsd:attribute name="key"  type="xsd:string" />
</xsd:complexType>


<xsd:complexType name="supplemental">
     <xsd:sequence>
       <xsd:element type="pc:reportIcon" name="reporticon" minOccurs="0" maxOccurs="1" />
       <xsd:element type="xsd:string" name="description" maxOccurs="1" minOccurs="0" />
       <xsd:element type="pc:externalLink" name="link" minOccurs="0" maxOccurs="unbounded" />
     </xsd:sequence>
</xsd:complexType>

<xsd:complexType name="externalLink">
  <xsd:attribute name="linktext" type="xsd:string" />
  <xsd:attribute name="linkurl" type="xsd:string" />
</xsd:complexType>

<xsd:complexType name="reportIcon">
	<xsd:attribute name="src" use="required" type="xsd:string" />
	<xsd:attribute name="alt" type="xsd:string" />
	<xsd:attribute name="height" type="xsd:integer" />
	<xsd:attribute name="width" type="xsd:integer" />
	<xsd:attribute name="top" type="xsd:integer" />
	<xsd:attribute name="left" type="xsd:integer" />
</xsd:complexType>

</xsd:schema>



--- NEW FILE: build.xml ---
<project name="xtab_generate" basedir="." default="xmlbeangenerate">

  <!-- Make sure you set the value of jarlocale correct-->
	<property name="jarlocale" value="JAR_LOCATION" />
  <property name="xmlbeanjar" value="${jarlocale}xbean.jar" />

<!-- This task will generate the source java files and jar based on pocOLAPConfig.xsd and 
   pocOLAPConfig.xsdconfig -->
  <target name="xmlbeangenerate" description="XMLBeans autogenerate" >
      <taskdef name="xmlbean"
            classname="org.apache.xmlbeans.impl.tool.XMLBean"
            classpath="${xmlbeanjar}"/>
                 
         <xmlbean schema="." destfile="crosstab.jar"    
         					srcgendir="."       					
         					classpath="${xmlbeanjar}"
							    failonerror="true" >							  						  
				</xmlbean>
        
  </target>
  
</project>

[Pocolap-cvscommit] pocolap/data/pocolapDB/sampleDB service.properties,NONE,1.1 nss.properties,NONE,1.1 nss.script,NONE,1.1

From: todd r. <to...@us...> - 2005-03-31 20:54:52

Update of /cvsroot/pocolap/pocolap/data/pocolapDB/sampleDB
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/pocolapDB/sampleDB

Added Files:
	service.properties nss.properties nss.script 
Log Message:
Reorganization of resources

--- NEW FILE: service.properties ---
#/tmp/newdata/sampleDB
# ********************************************************************
# ***                Please do NOT edit this file.                 ***
# *** CHANGING THE CONTENT OF THIS FILE MAY CAUSE DATA CORRUPTION. ***
# ********************************************************************
#Wed Mar 30 11:28:58 PST 2005
SysschemasIndex2Identifier=225
SyscolumnsIdentifier=144
SysconglomeratesIndex1Identifier=49
SysconglomeratesIdentifier=32
SyscolumnsIndex2Identifier=177
SysschemasIndex1Identifier=209
SysconglomeratesIndex3Identifier=81
SystablesIndex2Identifier=129
SyscolumnsIndex1Identifier=161
derby.serviceProtocol=org.apache.derby.database.Database
SysschemasIdentifier=192
derby.storage.propertiesId=16
SysconglomeratesIndex2Identifier=65
derby.serviceLocale=en_US
SystablesIdentifier=96
SystablesIndex1Identifier=113

--- NEW FILE: nss.script ---
CREATE TABLE "CUSTOMERS"("CUSTOMERID" INTEGER NOT NULL IDENTITY PRIMARY KEY,"CUSTOMERNUMBER" INTEGER,"FIRSTNAME" VARCHAR(50),"LASTNAME" VARCHAR(50),"ADDRESS" VARCHAR(100),"CITY" VARCHAR(60),"STATENAME" VARCHAR(50),"STATEABBREV" CHAR(2),"ZIP" VARCHAR(15),"PHONE" VARCHAR(25),"BIRTHDATE" DATE,"SIZINGGENDER" VARCHAR(20),"SHOESIZE" FLOAT,"WIDESIZES" BIT)
CREATE TABLE "SALABLEITEMS"("SALABLEITEMSID" INTEGER NOT NULL IDENTITY PRIMARY KEY,"SKU" INTEGER,"DESCRIPTION" VARCHAR(50),"ISPRODUCT" BIT,"ISSIZEDEPENDANT" BIT,"COLOR" VARCHAR(30),"VENDOR" VARCHAR(80),"VENDORNUMBER" INTEGER)
CREATE TABLE "CALENDAR"("CALENDARID" INTEGER NOT NULL IDENTITY PRIMARY KEY,"DAYDATE" DATE,"DAYNAME" VARCHAR(12),"DAYABBREV" CHAR(3),"DAYOFWEEK" INTEGER,"DAYOFMONTH" INTEGER,"MONTHNAME" VARCHAR(12),"MONTHABBREV" CHAR(3),"MONTHOFYEAR" INTEGER,"YEAR" INTEGER,"ISHOLIDAY" BIT,"WASOPENED" BIT)
CREATE TABLE "SALES"("CUSTOMERID" INTEGER,"SALABLEITEMSID" INTEGER,"CALENDARID" INTEGER,"AMOUNT" FLOAT,"WEBSALE" BIT)
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
CREATE USER NSSUSER PASSWORD "NSSPASS"
GRANT SELECT ON CUSTOMERS TO NSSUSER
GRANT SELECT ON CALENDAR TO NSSUSER
GRANT SELECT ON SALABLEITEMS TO NSSUSER
GRANT SELECT ON SALES TO NSSUSER
CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring"
CREATE ALIAS HEXTORAW FOR "org.hsqldb.Library.hexToRaw"
CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
CREATE ALIAS ABS FOR "org.hsqldb.Library.abs"
CREATE ALIAS POWER FOR "java.lang.Math.pow"
CREATE ALIAS CHAR FOR "org.hsqldb.Library.character"
CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat"
CREATE ALIAS PI FOR "org.hsqldb.Library.pi"
CREATE ALIAS RAWTOHEX FOR "org.hsqldb.Library.rawToHex"
CREATE ALIAS SECOND FOR "org.hsqldb.Library.second"
CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate"
CREATE ALIAS MONTH FOR "org.hsqldb.Library.month"
CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase"
CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"
CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat"
CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth"
CREATE ALIAS TAN FOR "java.lang.Math.tan"
CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"
CREATE ALIAS FLOOR FOR "java.lang.Math.floor"
CREATE ALIAS NOW FOR "org.hsqldb.Library.now"
CREATE ALIAS ACOS FOR "java.lang.Math.acos"
CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek"
CREATE ALIAS CEILING FOR "java.lang.Math.ceil"
CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear"
CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase"
CREATE ALIAS WEEK FOR "org.hsqldb.Library.week"
CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex"
CREATE ALIAS ASIN FOR "java.lang.Math.asin"
CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate"
CREATE ALIAS EXP FOR "java.lang.Math.exp"
CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname"
CREATE ALIAS YEAR FOR "org.hsqldb.Library.year"
CREATE ALIAS LEFT FOR "org.hsqldb.Library.left"
CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic"
CREATE ALIAS DATE_ADD FOR "com.pocolap.hsqldb.datetime.DateAgent.dateAdd"
CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor"
CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim"
CREATE ALIAS COT FOR "org.hsqldb.Library.cot"
CREATE ALIAS COS FOR "java.lang.Math.cos"
CREATE ALIAS MOD FOR "org.hsqldb.Library.mod"
CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign"
CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"
CREATE ALIAS LOG FOR "java.lang.Math.log"
CREATE ALIAS SIN FOR "java.lang.Math.sin"
CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime"
CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference"
CREATE ALIAS DATE_FORMAT FOR "com.pocolap.hsqldb.datetime.DateAgent.dateFormat"
CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert"
CREATE ALIAS SUBSTR FOR "org.hsqldb.Library.substring"
CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database"
CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute"
CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour"
CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity"
CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter"
CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate"
CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand"
CREATE ALIAS USER FOR "org.hsqldb.Library.user"
CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase"
CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim"
CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10"
CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right"
CREATE ALIAS ATAN FOR "java.lang.Math.atan"
CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase"
CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii"
CREATE ALIAS RAND FOR "java.lang.Math.random"
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 "CUSTOMERS" VALUES(0,0,'Nobody','Blank','0 Identity Rd','Portland','Oregon','OR','97201','503-555-0001','1950-01-01','mens',10.0E0,false)
INSERT INTO "CUSTOMERS" VALUES(1,17,'Tom','Ling','112 SomeStreet','Portland','Oregon','OR','97201','503-555-1233','1962-02-25','mens',7.5E0,false)
INSERT INTO "CUSTOMERS" VALUES(2,19,'Sammy','Hamm','4102 W. First','Portland','Oregon','OR','97210','503-555-4754','1964-10-04','mens',9.0E0,true)
INSERT INTO "CUSTOMERS" VALUES(3,24,'Sarah','Weston','421 Sideline St. Apt #4','Lake Oswego','Oregon','OR','97035','503-555-8874','1974-03-21','mens',8.0E0,false)
INSERT INTO "CUSTOMERS" VALUES(4,25,'Lisa','Weston','421 Sideline St. Apt #4','Lake Oswego','Oregon','OR','97035','503-555-8874','1991-10-07','girls',2.0E0,true)
INSERT INTO "CUSTOMERS" VALUES(5,26,'Bill','Franklin','801 Lake Ave.','Portland','Oregon','OR','97202','503-555-4120','1965-09-21','mens',10.0E0,false)
INSERT INTO "CUSTOMERS" VALUES(6,28,'Wilma','Barkley','7021 SW 66th','Tigard','Oregon','OR','97224','503-555-4998','1975-09-21','womens',7.0E0,false)
INSERT INTO "CUSTOMERS" VALUES(7,29,'Walter','McClellan','10425 Walling Cir','West Linn','Oregon','OR','97068','503-555-8856','1938-03-01','mens',8.5E0,true)
INSERT INTO "SALABLEITEMS" VALUES(0,234001,'36" laces',true,false,'Brown','Laces USA',78778)
INSERT INTO "SALABLEITEMS" VALUES(1,234002,'36" laces',true,false,'Black','Laces USA',78778)
INSERT INTO "SALABLEITEMS" VALUES(2,234003,'36" laces',true,false,'Beige','Laces USA',78778)
INSERT INTO "SALABLEITEMS" VALUES(3,234004,'36" laces',true,false,'White','Laces USA',78778)
INSERT INTO "SALABLEITEMS" VALUES(4,234011,'54" laces',true,false,'Brown','Laces USA',78778)
INSERT INTO "SALABLEITEMS" VALUES(5,234012,'54" laces',true,false,'Black','Laces USA',78778)
INSERT INTO "SALABLEITEMS" VALUES(6,234013,'54" laces',true,false,'Beige','Laces USA',78778)
INSERT INTO "SALABLEITEMS" VALUES(7,234014,'54" laces',true,false,'White','Laces USA',78778)
INSERT INTO "SALABLEITEMS" VALUES(8,170211,'odor insoles',true,true,'none','feeterEater',117)
INSERT INTO "SALABLEITEMS" VALUES(9,170211,'cushioned insoles',true,true,'none','feeterEater',117)
INSERT INTO "SALABLEITEMS" VALUES(10,170211,'cushioned odor insoles',true,true,'none','feeterEater',117)
INSERT INTO "SALABLEITEMS" VALUES(11,42187,'Polish',true,false,'Black','Shine Right',4242)
INSERT INTO "SALABLEITEMS" VALUES(12,42188,'Polish',true,false,'Brown','Shine Right',4242)
INSERT INTO "SALABLEITEMS" VALUES(13,42189,'Polish',true,false,'Tan','Shine Right',4242)
INSERT INTO "SALABLEITEMS" VALUES(14,42190,'Polish',true,false,'Beige','Shine Right',4242)
INSERT INTO "SALABLEITEMS" VALUES(15,42191,'Polish',true,false,'Red','Shine Right',4242)
INSERT INTO "SALABLEITEMS" VALUES(16,42192,'Polish',true,false,'Blue','Shine Right',4242)
INSERT INTO "SALABLEITEMS" VALUES(17,100,'Restitch',false,false,'none','Self',1)
INSERT INTO "SALABLEITEMS" VALUES(18,101,'Glue',false,false,'none','Self',1)
INSERT INTO "SALABLEITEMS" VALUES(19,102,'Shine',false,false,'none','Self',1)
INSERT INTO "CALENDAR" VALUES(0,'2002-12-29','Sunday','Sun',0,29,'December','Dec',12,2002,NULL,false)
INSERT INTO "CALENDAR" VALUES(1,'2003-01-05','Sunday','Sun',0,5,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(2,'2003-01-12','Sunday','Sun',0,12,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(3,'2003-01-19','Sunday','Sun',0,19,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(4,'2003-01-26','Sunday','Sun',0,26,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(5,'2003-02-02','Sunday','Sun',0,2,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(6,'2003-02-09','Sunday','Sun',0,9,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(7,'2003-02-16','Sunday','Sun',0,16,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(8,'2003-02-23','Sunday','Sun',0,23,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(9,'2003-03-02','Sunday','Sun',0,2,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(10,'2003-03-09','Sunday','Sun',0,9,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(11,'2003-03-16','Sunday','Sun',0,16,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(12,'2003-03-23','Sunday','Sun',0,23,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(13,'2003-03-30','Sunday','Sun',0,30,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(14,'2003-04-06','Sunday','Sun',0,6,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(15,'2003-04-13','Sunday','Sun',0,13,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(16,'2003-04-20','Sunday','Sun',0,20,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(17,'2003-04-27','Sunday','Sun',0,27,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(18,'2003-05-04','Sunday','Sun',0,4,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(19,'2003-05-11','Sunday','Sun',0,11,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(20,'2003-05-18','Sunday','Sun',0,18,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(21,'2003-05-25','Sunday','Sun',0,25,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(22,'2003-06-01','Sunday','Sun',0,1,'June','Jun',6,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(46,'2002-12-30','Monday','Mon',1,30,'December','Dec',12,2002,NULL,false)
INSERT INTO "CALENDAR" VALUES(47,'2003-01-06','Monday','Mon',1,6,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(48,'2003-01-13','Monday','Mon',1,13,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(49,'2003-01-20','Monday','Mon',1,20,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(50,'2003-01-27','Monday','Mon',1,27,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(51,'2003-02-03','Monday','Mon',1,3,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(52,'2003-02-10','Monday','Mon',1,10,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(53,'2003-02-17','Monday','Mon',1,17,'February','Feb',2,2003,false,false)
INSERT INTO "CALENDAR" VALUES(54,'2003-02-24','Monday','Mon',1,24,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(55,'2003-03-03','Monday','Mon',1,3,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(56,'2003-03-10','Monday','Mon',1,10,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(57,'2003-03-17','Monday','Mon',1,17,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(58,'2003-03-24','Monday','Mon',1,24,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(59,'2003-03-31','Monday','Mon',1,31,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(60,'2003-04-07','Monday','Mon',1,7,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(61,'2003-04-14','Monday','Mon',1,14,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(62,'2003-04-21','Monday','Mon',1,21,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(63,'2003-04-28','Monday','Mon',1,28,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(64,'2003-05-05','Monday','Mon',1,5,'May','May',5,2003,false,false)
INSERT INTO "CALENDAR" VALUES(65,'2003-05-12','Monday','Mon',1,12,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(66,'2003-05-19','Monday','Mon',1,19,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(67,'2003-05-26','Monday','Mon',1,26,'May','May',5,2003,false,false)
INSERT INTO "CALENDAR" VALUES(68,'2003-06-02','Monday','Mon',1,2,'June','Jun',6,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(69,'2002-12-31','Tuesday','Tue',2,31,'December','Dec',12,2002,false,false)
INSERT INTO "CALENDAR" VALUES(70,'2003-01-07','Tuesday','Tue',2,7,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(71,'2003-01-14','Tuesday','Tue',2,14,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(72,'2003-01-21','Tuesday','Tue',2,21,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(73,'2003-01-28','Tuesday','Tue',2,28,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(74,'2003-02-04','Tuesday','Tue',2,4,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(75,'2003-02-11','Tuesday','Tue',2,11,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(76,'2003-02-18','Tuesday','Tue',2,18,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(77,'2003-02-25','Tuesday','Tue',2,25,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(78,'2003-03-04','Tuesday','Tue',2,4,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(79,'2003-03-11','Tuesday','Tue',2,11,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(80,'2003-03-18','Tuesday','Tue',2,18,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(81,'2003-03-25','Tuesday','Tue',2,25,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(82,'2003-04-01','Tuesday','Tue',2,1,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(83,'2003-04-08','Tuesday','Tue',2,8,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(84,'2003-04-15','Tuesday','Tue',2,15,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(85,'2003-04-22','Tuesday','Tue',2,22,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(86,'2003-04-29','Tuesday','Tue',2,29,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(87,'2003-05-06','Tuesday','Tue',2,6,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(88,'2003-05-13','Tuesday','Tue',2,13,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(89,'2003-05-20','Tuesday','Tue',2,20,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(90,'2003-05-27','Tuesday','Tue',2,27,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(91,'2003-06-03','Tuesday','Tue',2,3,'June','Jun',6,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(92,'2003-01-01','Wednesday','Wed',3,1,'January','Jan',1,2003,false,false)
INSERT INTO "CALENDAR" VALUES(93,'2003-01-08','Wednesday','Wed',3,8,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(94,'2003-01-15','Wednesday','Wed',3,15,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(95,'2003-01-22','Wednesday','Wed',3,22,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(96,'2003-01-29','Wednesday','Wed',3,29,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(97,'2003-02-05','Wednesday','Wed',3,5,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(98,'2003-02-12','Wednesday','Wed',3,12,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(99,'2003-02-19','Wednesday','Wed',3,19,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(100,'2003-02-26','Wednesday','Wed',3,26,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(101,'2003-03-05','Wednesday','Wed',3,5,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(102,'2003-03-12','Wednesday','Wed',3,12,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(103,'2003-03-19','Wednesday','Wed',3,19,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(104,'2003-03-26','Wednesday','Wed',3,26,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(105,'2003-04-02','Wednesday','Wed',3,2,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(106,'2003-04-09','Wednesday','Wed',3,9,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(107,'2003-04-16','Wednesday','Wed',3,16,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(108,'2003-04-23','Wednesday','Wed',3,23,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(109,'2003-04-30','Wednesday','Wed',3,30,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(110,'2003-05-07','Wednesday','Wed',3,7,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(111,'2003-05-14','Wednesday','Wed',3,14,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(112,'2003-05-21','Wednesday','Wed',3,21,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(113,'2003-05-28','Wednesday','Wed',3,28,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(114,'2003-06-04','Wednesday','Wed',3,4,'June','Jun',6,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(115,'2003-01-02','Thursday','Thu',4,2,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(116,'2003-01-09','Thursday','Thu',4,9,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(117,'2003-01-16','Thursday','Thu',4,16,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(118,'2003-01-23','Thursday','Thu',4,23,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(119,'2003-01-30','Thursday','Thu',4,30,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(120,'2003-02-06','Thursday','Thu',4,6,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(121,'2003-02-13','Thursday','Thu',4,13,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(122,'2003-02-20','Thursday','Thu',4,20,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(123,'2003-02-27','Thursday','Thu',4,27,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(124,'2003-03-06','Thursday','Thu',4,6,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(125,'2003-03-13','Thursday','Thu',4,13,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(126,'2003-03-20','Thursday','Thu',4,20,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(127,'2003-03-27','Thursday','Thu',4,27,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(128,'2003-04-03','Thursday','Thu',4,3,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(129,'2003-04-10','Thursday','Thu',4,10,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(130,'2003-04-17','Thursday','Thu',4,17,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(131,'2003-04-24','Thursday','Thu',4,24,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(132,'2003-05-01','Thursday','Thu',4,1,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(133,'2003-05-08','Thursday','Thu',4,8,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(134,'2003-05-15','Thursday','Thu',4,15,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(135,'2003-05-22','Thursday','Thu',4,22,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(136,'2003-05-29','Thursday','Thu',4,29,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(137,'2003-06-05','Thursday','Thu',4,5,'June','Jun',6,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(138,'2003-01-03','Friday','Fri',5,3,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(139,'2003-01-10','Friday','Fri',5,10,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(140,'2003-01-17','Friday','Fri',5,17,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(141,'2003-01-24','Friday','Fri',5,24,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(142,'2003-01-31','Friday','Fri',5,31,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(143,'2003-02-07','Friday','Fri',5,7,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(144,'2003-02-14','Friday','Fri',5,14,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(145,'2003-02-21','Friday','Fri',5,21,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(146,'2003-02-28','Friday','Fri',5,28,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(147,'2003-03-07','Friday','Fri',5,7,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(148,'2003-03-14','Friday','Fri',5,14,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(149,'2003-03-21','Friday','Fri',5,21,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(150,'2003-03-28','Friday','Fri',5,28,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(151,'2003-04-04','Friday','Fri',5,4,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(152,'2003-04-11','Friday','Fri',5,11,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(153,'2003-04-18','Friday','Fri',5,18,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(154,'2003-04-25','Friday','Fri',5,25,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(155,'2003-05-02','Friday','Fri',5,2,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(156,'2003-05-09','Friday','Fri',5,9,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(157,'2003-05-16','Friday','Fri',5,16,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(158,'2003-05-23','Friday','Fri',5,23,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(159,'2003-05-30','Friday','Fri',5,30,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(160,'2003-06-06','Friday','Fri',5,6,'June','Jun',6,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(161,'2003-01-04','Saturday','Sat',6,4,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(162,'2003-01-11','Saturday','Sat',6,11,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(163,'2003-01-18','Saturday','Sat',6,18,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(164,'2003-01-25','Saturday','Sat',6,25,'January','Jan',1,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(165,'2003-02-01','Saturday','Sat',6,1,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(166,'2003-02-08','Saturday','Sat',6,8,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(167,'2003-02-15','Saturday','Sat',6,15,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(168,'2003-02-22','Saturday','Sat',6,22,'February','Feb',2,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(169,'2003-03-01','Saturday','Sat',6,1,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(170,'2003-03-08','Saturday','Sat',6,8,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(171,'2003-03-15','Saturday','Sat',6,15,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(172,'2003-03-22','Saturday','Sat',6,22,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(173,'2003-03-29','Saturday','Sat',6,29,'March','Mar',3,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(174,'2003-04-05','Saturday','Sat',6,5,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(175,'2003-04-12','Saturday','Sat',6,12,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(176,'2003-04-19','Saturday','Sat',6,19,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(177,'2003-04-26','Saturday','Sat',6,26,'April','Apr',4,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(178,'2003-05-03','Saturday','Sat',6,3,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(179,'2003-05-10','Saturday','Sat',6,10,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(180,'2003-05-17','Saturday','Sat',6,17,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(181,'2003-05-24','Saturday','Sat',6,24,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(182,'2003-05-31','Saturday','Sat',6,31,'May','May',5,2003,NULL,false)
INSERT INTO "CALENDAR" VALUES(183,'2003-06-07','Saturday','Sat',6,7,'June','Jun',6,2003,NULL,false)
INSERT INTO "SALES" VALUES(1,3,72,2.25E0,false)
INSERT INTO "SALES" VALUES(1,2,72,2.25E0,false)
INSERT INTO "SALES" VALUES(1,2,72,2.25E0,false)
INSERT INTO "SALES" VALUES(4,7,101,2.5E0,false)
INSERT INTO "SALES" VALUES(4,7,100,2.5E0,false)
INSERT INTO "SALES" VALUES(3,5,47,2.5E0,false)
INSERT INTO "SALES" VALUES(3,6,47,2.5E0,false)
INSERT INTO "SALES" VALUES(3,7,47,2.5E0,false)
INSERT INTO "SALES" VALUES(3,6,116,2.5E0,false)
INSERT INTO "SALES" VALUES(3,10,116,15.0E0,false)
INSERT INTO "SALES" VALUES(7,11,75,17.5E0,false)
INSERT INTO "SALES" VALUES(7,20,75,10.0E0,false)
INSERT INTO "SALES" VALUES(2,15,105,7.25E0,false)
INSERT INTO "SALES" VALUES(2,10,105,15.0E0,false)
INSERT INTO "SALES" VALUES(2,13,105,7.25E0,false)
INSERT INTO "SALES" VALUES(2,18,105,8.0E0,false)

--- NEW FILE: nss.properties ---
#HSQL database
#Thu Aug 05 13:49:20 PDT 2004
sql.strict_fk=true
readonly=false
sql.strong_fk=true
hsqldb.version=1.7.1
version=1.7.1
hsqldb.cache_scale=14
sql.compare_in_locale=false
sql.month=true
hsqldb.log_size=200
modified=no
hsqldb.cache_version=1.7.0
hsqldb.original_version=1.7.1
hsqldb.compatible_version=1.7.0
sql.enforce_size=false

[Pocolap-cvscommit] pocolap/data/documentation config_file_how_to.sxw,NONE,1.1 How to setup logging.txt,NONE,1.1 Creating the nss database.txt,NONE,1.1 Creating the pocOLAPinternal database.txt,NONE,1.1 Notes on using Oracle.txt,NONE,1.1 config_file_how_to.pdf,NONE,1.1

From: todd r. <to...@us...> - 2005-03-31 20:54:51

Update of /cvsroot/pocolap/pocolap/data/documentation
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/documentation

Added Files:
	config_file_how_to.sxw How to setup logging.txt 
	Creating the nss database.txt 
	Creating the pocOLAPinternal database.txt 
	Notes on using Oracle.txt config_file_how_to.pdf 
Log Message:
Reorganization of resources

--- NEW FILE: Notes on using Oracle.txt ---
1. Install pocOLAP ver 004, as described in the applied documentation. Install Oracle 9i with seed database (not scope of this doc to tell how, refer to Google :). Enable user sh.

2. Setup Oracle schema connection configuration
a. Download the schema conf. file (shconfig.xml)
b. newgrp <tomcat_grp>, alternatively: su <tomcat_usr>
c. mkdir $TOMCAT_HOME/webapps/pocolap/WEB-INF/data
d. cd $TOMCAT_HOME/webapps/pocolap/WEB-INF/data
e. cp <download_loc>/shconfig.xml .
f. vi shconfig.xml and set the "source" tag attributes and text:
<source
	classtype="com.pocolap.conn.StandardJDBC"
	driver="oracle.jdbc.OracleDriver"
	user="sh"
	pass=<sh_psw>
>
	jdbc:oracle:thin:@//your_host:ora_port/sid
</source>
Example source tag content is: jdbc:oracle:thin:@//localhost:1521/oradb1

2. Start Oracle 9i
LISTENER should also be up, internal connection not enough.

3. Supply Oracle JDBC classes
For JDK1.4:
cp $ORACLE_HOME/jdbc/lib/ojdbc14.jar $POCO_HOME/lib

For JDK 1.2.x or 1.3.x:
cp $ORACLE_HOME/jdbc/lib/classes12.jar $POCO_HOME/lib


4. vi $POCOLAP_HOME/WEB-INF/web.xml
Paste near other init-params:
<init-param>
	<param-name>whs_z</param-name>
	<param-value>/WEB-INF/data/shconfig.xml</param-value>
</init-param>

5. Start tomcat and try it: http://localhost:8080/pocolap/ReptPage.jsp


Additional Notes (added for version 0.1.1):
Because the Oracle drivers don't support the setCatalog() method, using the catalog attribute of the source tag can cause Exceptions.  It is recommended that you use the StandardJDBCNoCatalog class with Oracle and setting the catalog through the dbstring.

--- NEW FILE: Creating the nss database.txt ---

The nss database is the original sample database for pocOLAP.  It is an HSQLDB database.  As of version 0.1.1 the sample database is located inside the pocOLAPinternal database implemented in Derby.

To create the nss database, you need the following:
	HSQLDB (download from http://hsqldb.sourceforge.net/)
	pocohsqldb.jar
	setupNSS_hslqdb.sql
	
-- Unzip the hsqldb.zip file you downloaded from sourceforge.  Place hsqldb.jar (found in lib/ directory) whereever you want.  This will be referred to as $HSQLDB_HOME from here on, though you don't need to set this as a variable unless you'd like to.

-- Set and export your classpath to hsqldb.jar and pocohsqldb.jar (for example:  export CLASSPATH=/opt/HSQLDB/hsqldb.jar;/opt/mystuff/pocohsqldb.jar).  

-- Switch to the directory where you want your data files to be placed.  Run HSQLDB with "java org.hsqldb.util.DatabaseManager".  When the "connect" box comes up, change "Type" to Standalone and place "nss" in the "URL" box, where "<<database?>>" is listed

-- Copy (as in "copy and paste") the text from setupNSS_hsqldb.sql and paste it into the query box (in between the "Clear" and "Execute" buttons). DO NOT use setupNSS.sql since this was created for a different RDBMS.

-- That's it!  If you want to confirm the data is there, choose View->Refresh Tree.  The files have been written to the directory where you issued the "java" command.  Use them in good health!


--- NEW FILE: config_file_how_to.pdf ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: config_file_how_to.sxw ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: Creating the pocOLAPinternal database.txt ---

This document explains how to create the Derby based sample database manually.  

To build the sample database, you need:
	Derby (the derby.jar and derbytools.jar files, available for download from http://incubator.apache.org/derby/)
	pocohsqldb.jar (in the source tree at web/mcsDemo/tools)
	pocOLAPsample.sql (in the source tree at src/scripts)
	

Install Derby on your system such that you can run the ij and dblook tools.  You can find instructions with the Derby distribution.  You can also run derby directly from the jar files, however these instructions assume you can run the derby tools directly.	

Set and export your classpath, for example (assuming you've copied all the jar files into the /tmp directory):
> export CLASSPATH=$CLASSPATH:/tmp/derby.jar:/tmp/derbytools.jar:/tmp/pocohsqldb.jar

Change to the directory where you want the database files to be written.  Run the ij tool.  Run the scripts, for example: run 'pocOLAPsample.sql';.

That's it.  The directory that contains the database files are located in the directory where you ran ij.  You can confirm that the data was written correctly using either the ij or dblook tools.
--- NEW FILE: How to setup logging.txt ---
How to set up logging: 
Short Answer: 
In short, if you don't make any change, a log file name pocolaplog.txt will be placed in the pocOLAPinternal directory.  See INSTALL.txt for information about setting up the internal database.

If you'd like to change the logging settings, modify the log4j.properties file in the pocOLAPinternal directory.  Changes made while the application is running will be reflected usually within a minute.


Detailed Answer: 

(1) Make sure that log4j.properties file is located in the Derby Directory(Internal Database). For e.g.: C:\pocOLAPinternal\log4j.properties OR /tmp/pocOLAPinternal/log4j.properties
If you place internal database at a different location, make sure that log4j.properties is also in that directory. Also don't forget to update "pocolap.DB.location" parameter in web.xml

(2) By default the log file will be available in Derby Directory. If you want to log at different location, edit the log4j.properties. Change the value for "log4j.appender.R.File" property. Also, you may want to place an empty file at that location. 
Eg: log4j.appender.R.File=C:\xyz\mylogfile.txt 

(3) You can change the level of logging to DEBUG, INFO, WARN, ERROR or FATAL.  Setting the level to DEBUG will capture all logging output, while INFO will capture informational messages and higher (no debug statements).  Each level logs fewer and fewer messages.

(4) You can set the level for a specific class by adding a line to log4j.properties, using "log4j.logger" plus the name of the class.  For example, say you want every class in the com.pocolap.dbagent package set to WARN, except for com.pocolap.dbagent.QueryGenerator, which you want to set to DEBUG.  We would simply use the following "log4j.logger" statements in the log4j.properties file:
log4j.logger.com.pocolap.dbagent=WARN
log4j.logger.com.pocolap.dbagent.QueryGenerator=DEBUG

[Pocolap-cvscommit] pocolap/src/com/pocolap/servlets TestXTabMain.java,1.5,NONE

From: todd r. <to...@us...> - 2005-03-31 20:54:51

Update of /cvsroot/pocolap/pocolap/src/com/pocolap/servlets
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/src/com/pocolap/servlets

Removed Files:
	TestXTabMain.java 
Log Message:
Reorganization of resources

--- TestXTabMain.java DELETED ---

[Pocolap-cvscommit] pocolap/data/pocolapDB log4j.properties,NONE,1.1

From: todd r. <to...@us...> - 2005-03-31 20:54:51

Update of /cvsroot/pocolap/pocolap/data/pocolapDB
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/pocolapDB

Added Files:
	log4j.properties 
Log Message:
Reorganization of resources

--- NEW FILE: log4j.properties ---
#
#Mon Feb 14 23:29:34 EST 2005
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.R.File=
log4j.appender.R.MaxFileSize=100KB
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.MaxBackupIndex=1
log4j.appender.R.layout.ConversionPattern=[%d] %p %x - %m%n
log4j.logger.com.pocolap=DEBUG, stdout, R
log4j.appender.stdout.layout.ConversionPattern=[%d] %p %x - %m%n
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.R=org.apache.log4j.RollingFileAppender

[Pocolap-cvscommit] pocolap/web/mcsDemo/tools build.xml,1.1,NONE README.txt,1.1,NONE pocohsqldb.jar,1.1,NONE hsqldbConverter.pl,1.1,NONE setupNSS_hsqldb.sql,1.4,NONE

From: todd r. <to...@us...> - 2005-03-31 20:54:33

Update of /cvsroot/pocolap/pocolap/web/mcsDemo/tools
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/web/mcsDemo/tools

Removed Files:
	build.xml README.txt pocohsqldb.jar hsqldbConverter.pl 
	setupNSS_hsqldb.sql 
Log Message:
Reorganization of resources

--- pocohsqldb.jar DELETED ---

--- build.xml DELETED ---

--- README.txt DELETED ---

--- hsqldbConverter.pl DELETED ---

--- setupNSS_hsqldb.sql DELETED ---

[Pocolap-cvscommit] pocolap/otherConfigs reptconfig.xml,1.1.1.1,NONE

From: todd r. <to...@us...> - 2005-03-31 20:54:32

Update of /cvsroot/pocolap/pocolap/otherConfigs
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/otherConfigs

Removed Files:
	reptconfig.xml 
Log Message:
Reorganization of resources

--- reptconfig.xml DELETED ---

[Pocolap-cvscommit] pocolap/web/mcsDemo MANIFEST.MF,1.1,NONE testPage.jsp,1.1,NONE config.xml,1.2,NONE CaseConverter.pl,1.2,NONE build.xml,1.1,NONE web.xml,1.1,NONE

From: todd r. <to...@us...> - 2005-03-31 20:54:31

Update of /cvsroot/pocolap/pocolap/web/mcsDemo
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/web/mcsDemo

Removed Files:
	MANIFEST.MF testPage.jsp config.xml CaseConverter.pl build.xml 
	web.xml 
Log Message:
Reorganization of resources

--- testPage.jsp DELETED ---

--- build.xml DELETED ---

--- MANIFEST.MF DELETED ---

--- CaseConverter.pl DELETED ---

--- web.xml DELETED ---

--- config.xml DELETED ---

Flat | Threaded

<< < 1 2 3 4 5 > >> (Page 3 of 5)