Could add it to the repository, but what's the best path? Any idea?
Thanks, Henner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] Im > Auftrag von John Gagon > Gesendet: Montag, 2. Dezember 2002 19:01 > An: [EMAIL PROTECTED] > Betreff: [Jdbforms-developers] XSD file and sample > comprehensive dbforms-config.xml sample. > > > > > I'm submitting an XSD (the new progeny of DTD files) a sample > configuration file that includes all the elements. I am > currently playing with the test-suite sample app and will > post the test-suite sample dbforms-config later. > > > I have been having problems connecting to CVS on source forge > so I hope you don't mind if I just post the diffs here. (I > get Network Connection refused and have followed the > sourceforge site docs on putty, I have a newer CVS (with > plink set up), pageant and sourceforge account set up with my > public key from putty gen) > > > > -------------------------------- > File: dbforms-config.xsd > -------------------------------- > <?xml version="1.0"?> > <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"; > targetNamespace="http://www.w3schools.com"; > xmlns="http://www.w3schools.com"; > elementFormDefault="qualified"> > > <xs:element name="dbforms-config"> > <xs:complexType> > <xs:all> > > <xs:element name="date-format" type="xs:string" > minOccurs="0" maxOccurs="1"/> > > <xs:element name="table" minOccurs="1" maxOccurs="unbounded"> > <xs:complexType> > <xs:all> > > <xs:element name="field" type="xs:string" > minOccurs="1" maxOccurs="unbounded"> > <xs:attribute name="name" > type="xs:string" use="required"/> > <xs:attribute name="fieldType" > type="xs:string" use="required"/> > <xs:attribute name="size" > type="xs:string" use="optional"/> > <xs:attribute name="isKey" > type="xs:string" use="optional"/> > <xs:attribute name="sortable" > type="xs:string" use="optional"/> > <xs:attribute name="autoInc" > type="xs:string" use="optional"/> > <xs:attribute name="directory" > type="xs:string" use="optional"/> > </xs:element> > > <xs:element name="foreign-key" type="xs:string" > minOccurs="0" maxOccurs="unbounded"> > <xs:complexType> > <xs:all> > <xs:element name="reference" > type="xs:string" minOccurs="1" maxOccurs="unbounded"> > <xs:attribute > name="local" type="xs:string" use="required"/> > <xs:attribute > name="foreign" type="xs:string" use="required"/> > </xs:element> > </xs:all> > <xs:attribute name="foreignTable" > type="xs:string" use="required"/> > <xs:attribute name="name" > type="xs:string" use="required"/> > </xs:complexType> > </xs:element> > > <xs:element name="events" type="xs:string" > minOccurs="0" maxOccurs="unbounded"> > <xs:complexType> > <xs:all> > <xs:element name="event" > type="xs:string" minOccurs="1" maxOccurs="unbounded"> > <xs:complexType> > <xs:all> > <xs:element > name="param" type="xs:string" minOccurs="0" maxOccurs="unbounded"> > > <xs:attribute name="name" type="xs:string" use="required"/> > > <xs:attribute name="value" type="xs:string" use="required"/> > </xs:element> > </xs:all> > <xs:attribute > name="type" type="xs:string" use="required"/> > <xs:attribute name="id" > type="xs:string" use="required"/> > </xs:complexType> > </xs:element> > </xs:all> > </xs:complexType> > </xs:element> > > <xs:element name="interceptor" type="xs:string" > minOccurs="0" maxOccurs="unbounded"> > <xs:attribute name="className" > type="xs:string" use="required"/> > </xs:element> > > <xs:element name="granted-privileges" > type="xs:string" minOccurs="0" maxOccurs="unbounded"> > <xs:attribute name="select" > type="xs:string" use="optional"/> > <xs:attribute name="insert" > type="xs:string" use="optional"/> > <xs:attribute name="update" > type="xs:string" use="optional"/> > <xs:attribute name="delete" > type="xs:string" use="optional"/> > </xs:element> > > </xs:all> > <xs:attribute name="name" type="xs:string" use="required"/> > > </xs:complexType> > </xs:element> > <!--END "table" --> > > <xs:element name="query" type="xs:string" minOccurs="0" > maxOccurs="unbounded"> > <xs:complexType> > <xs:all> > <xs:element name="field" > type="xs:string" minOccurs="0" maxOccurs="unbounded"> > <xs:attribute name="name" > type="xs:string" use="optional"/> > <xs:attribute name="type" > type="xs:string" use="optional"/> > <xs:attribute name="autoInc" > type="xs:string" use="optional"/> > <xs:attribute name="sortable" > type="xs:string" use="optional"/> > <xs:attribute name="expression" > type="xs:string" use="optional"/> > </xs:element> > > <xs:element name="search" > type="xs:string" minOccurs="0" maxOccurs="unbounded"> > <xs:attribute name="name" > type="xs:string" use="optional"/> > <xs:attribute name="type" > type="xs:string" use="optional"/> > <xs:attribute name="expression" > type="xs:string" use="optional"/> > </xs:element> > > <xs:element name="interceptor" > type="xs:string" minOccurs="0" maxOccurs="unbounded"> > <xs:attribute name="className" > type="xs:string" use="required"/> > </xs:element> > > <xs:element name="granted-privileges" > type="xs:string" minOccurs="0" maxOccurs="unbounded"> > <xs:attribute name="select" > type="xs:string" use="optional"/> > <xs:attribute name="insert" > type="xs:string" use="optional"/> > <xs:attribute name="update" > type="xs:string" use="optional"/> > <xs:attribute name="delete" > type="xs:string" use="optional"/> > </xs:element> > </xs:all> > <xs:attribute name="name" type="xs:string" > use="required"/> > <xs:attribute name="from" type="xs:string" > use="optional"/> > <xs:attribute name="groupBy" type="xs:string" > use="optional"/> > <xs:attribute name="where" type="xs:string" > use="optional"/> > <xs:attribute name="followAfterWhere" > type="xs:string" use="optional"/> > <xs:attribute name="orderWithPos" > type="xs:string" use="optional"/> > <xs:attribute name="distinct" type="xs:string" > use="optional"/> > </xs:complexType> > </xs:element> > > <xs:element name="events" type="xs:string" > minOccurs="1" maxOccurs="unbounded"> > <xs:complexType> > <xs:all> > > <xs:element name="database-events" > type="xs:string" minOccurs="1" maxOccurs="unbounded"> > <xs:complexType> > <xs:all> > <xs:element > name="database-event" type="xs:string" minOccurs="1" > maxOccurs="unbounded"> > <xs:attribute > name="type" type="xs:string" use="required"/> > <xs:attribute > name="className" type="xs:string" use="requird"/> > </xs:element> > </xs:all> > </xs:complexType> > </xs:element> > > <xs:element name="navigation-events" > type="xs:string" minOccurs="1" maxOccurs="unbounded"> > <xs:complexType> > <xs:all> > <xs:element > name="navigation-event" type="xs:string" minOccurs="1" > maxOccurs="unbounded"> > <xs:attribute > name="type" type="xs:string" use="required"/> > <xs:attribute > name="className" type="xs:string" use="requird"/> > </xs:element> > </xs:all> > </xs:complexType> > </xs:element> > > </xs:all> > </xs:complexType> > </xs:element> > > > <xs:element name="dbconnection" type="xs:string" > minOccurs="1" maxOccurs="unbounded"> > <xs:complexType> > <xs:all> > <xs:element name="property" > type="xs:string" minOccurs="0" maxOccurs="unbounded"> > <xs:attribute name="name" > type="xs:string" use="required"/> > <xs:attribute name="value" > type="xs:string" use="required"/> > </xs:element> > <xs:element name="pool-property" > type="xs:string" minOccurs="0" maxOccurs="unbounded"> > <xs:attribute name="name" > type="xs:string" use="required"/> > <xs:attribute name="value" > type="xs:string" use="required"/> > </xs:element> > </xs:all> > <xs:attribute name="id" type="xs:string" > use="optional"/> > <xs:attribute name="name" type="xs:string" > use="required"/> > <xs:attribute name="type" type="xs:string" > use="optional"/> > <xs:attribute name="isJndi" type="xs:string" > use="optional"/> > <xs:attribute name="isPow2" type="xs:string" > use="optional"/> > <xs:attribute name="defaultConnection" > type="xs:string" use="optional"/> > <xs:attribute name="connectionProviderClass" > type="xs:string" use="optional"/> > <xs:attribute name="connectionPoolURL" > type="xs:string" use="optional"/> > <xs:attribute name="conClass" type="xs:string" > use="optional"/> > <xs:attribute name="username" type="xs:string" > use="optional"/> > <xs:attribute name="password" type="xs:string" > use="optional"/> > </xs:complexType> > </xs:element> > > <!--END "dbconnection" --> > > </xs:all> > </xs:complexType> > </xs:element> > <!--END "dbforms-config" --> > > </xs:schema> > > > -------------------------------- > File: dbforms-config.xml > -------------------------------- > > <?xml version="1.0"?> > > <dbforms-config > xmlns="http://www.w3schools.com"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > xsi:schemaLocation=".\dbforms-config.xsd"> > <date-format>MM-dd-yyyy</date-format> > > <table name="glob_users"> > <field name="id" fieldType="int" > size="11" isKey="true" autoInc="true" /> > <field name="client_id" fieldType="int" > size="11" isKey="true" /> > <field name="curr_project_id" fieldType="int" > size="11" isKey="true" /> > <field name="userid" fieldType="varchar" > size="50" sortable="true" /> > <field name="password" fieldType="varchar" size="50" /> > <field name="pass" fieldType="varchar" size="50" /> > <field name="role" fieldType="varchar" size="50" /> > <field name="contactid" fieldType="varchar" size="50" /> > <field name="company" fieldType="varchar" size="50" /> > <field name="function" fieldType="varchar" size="50" /> > <field name="usergroup" fieldType="varchar" size="50" /> > <field name="readonly" fieldType="char" size="1" /> > <field name="picture" fieldType="diskblob" > size="255" directory="d:\users" /> > <field name="active" fieldType="char" size="1" /> > <field name="last_mod" fieldType="varchar" size="20" /> > <field name="last_mod_by" fieldType="varchar" size="100" /> > <field name="last_mod_ip" fieldType="varchar" size="30" /> > <field name="create_date" fieldType="varchar" size="20" /> > <field name="create_by" fieldType="varchar" size="100" /> > <field name="create_by_ip" fieldType="varchar" size="30" /> > > <events> > <event type="insert" id="insert1"> > <param name="sourceView" value="VIEW_USER" /> > <param name="targetTable" value="USER" /> > </event> > </events> > > <foreign-key > foreignTable="glob_roles" > name="roles_fk" > visibleFields="shortdesc,description" > format="%s -- %s " > > > <reference local="role" foreign="id"/> > </foreign-key> > > <interceptor className="com.atser.calc.UserManagerInterceptor" /> > > <granted-privileges > insert="manager, clerk" > select="user" > update="admin" > delete="admin" > /> > > </table> > > > <table name="glob_roles"> > <field name="id" fieldType="varchar" > size="50" isKey="true" /> > <field name="shortdesc" fieldType="varchar" size="50" /> > <field name="description" fieldType="varchar" size="200" /> > <field name="active" fieldType="char" size="1" /> > <field name="last_mod" fieldType="varchar" size="20" /> > <field name="last_mod_by" fieldType="varchar" size="100" /> > <field name="last_mod_ip" fieldType="varchar" size="30" /> > <field name="create_date" fieldType="varchar" size="20" /> > <field name="create_by" fieldType="varchar" size="100" /> > <field name="create_by_ip" fieldType="varchar" size="30" /> > </table> > > <query name="companies" distinct="true" > from="glob_companies" where="client = 'mycompany'" > groupBy="subscriber_type" orderWithPos=""> > <field name="id" type="varchar" size="50" > isKey="true" autoInc="true" /> > <field name="shortname" type="varchar" size="50" > expression="AS name" isKey="true" sortable="true" /> > <search name="family" type="varchar" > expression="AS fam" /> > </query> > > <query name="groups" from="glob_groups" > where="active='true'" followAfterWhere="order by id desc"> > <field name="id" type="varchar" size="50" isKey="true" > autoInc="true" /> > <field name="sum" type="numeric(10,2)" > expression="sum(revenue)" /> > <field name="count" type="int4" expression="count(id)" /> > > <interceptor className="com.atser.groups.GroupsInterceptor" /> > > <granted-privileges > update="clerk" > delete="admin" > /> > </query> > > > <events> > > <database-events> > <database-event type="insert" > className="org.dbforms.event.InsertEvent" /> > <database-event id="insert2" type="insert" > className="org.dbforms.event.InsertEvent" /> > <database-event type="update" > className="org.dbforms.event.UpdateEvent" /> > <database-event id="update2" type="update" > className="org.dbforms.event.UpdateEvent2" /> > <database-event type="delete" > className="org.dbforms.event.DeleteEvent" /> > </database-events> > > <navigation-events> > <navigation-event type="navFirst" > className="org.dbforms.event.NavFirstEvent" /> > <navigation-event type="navPrev" > className="org.dbforms.event.BoundedNavPrevEventImpl" /> > <navigation-event type="navNext" > className="org.dbforms.event.BoundedNavNextEventImpl" /> > <navigation-event type="navLast" > className="org.dbforms.event.NavLastEvent" /> > <navigation-event type="navNew" > className="org.dbforms.event.NavNewEvent" /> > <navigation-event type="navGoto" > className="org.dbforms.event.GotoEvent" /> > </navigation-events> > > </events> > > > > <dbconnection > name = "jdbc/dbformstest" > isJndi = "true"/> > > > <dbconnection > name = "jdbc:postgresql://foxat/catalog?charSet=ISO-8859-1" > isJndi = "DataSource" > conClass = "${jdbc_drivers}" > username = "postgres" > password = ""/> > > <dbconnection > id = "jakarta-commons-dbcp" > isJndi = "false" > isPow2 = "true" > defaultConnection = "true" > connectionProviderClass = > "org.dbforms.conprovider.JakartaConnectionProvider" > connectionPoolURL = "${jdbc_cp_url}" > conClass = "org.postgresql.Driver" > name = > "jdbc:postgresql://foxat/catalog?charSet=ISO-8859-1" > username = "postgres" > password = ""> > > <pool-property name="validationQuery" value="" /> > <pool-property name="maxActive" value="10" /> > <pool-property name="maxIdle" value="5" /> > <pool-property name="maxWait" value="-1" /> > <pool-property name="useLog" value="true" /> > > </dbconnection> > > > > <dbconnection > id = "protomatter" > isJndi = "false" > isPow2 = "true" > defaultConnection = "true" > connectionProviderClass = > "org.dbforms.conprovider.ProtomatterConnectionProvider" > connectionPoolURL = "jdbc:protomatter:pool:postgresPool" > conClass = "org.postgresql.Driver" > name = "jdbc:postgresql://foxat/catalog" > username = "postgres" > password = ""> > > <property name="charSet" value="ISO-8859-1" /> > > <pool-property name="pool.initialSize" value="4" /> > <pool-property name="pool.maxSize" value="10" /> > <pool-property name="pool.growBlock" value="2" /> > <pool-property name="pool.createWaitTime" value="100" /> > <pool-property name="pool.maxConnectionIdleTime" value="" /> > <pool-property name="pool.maidThreadCheckInterval" value="" /> > <pool-property name="jdbc.validityCheckStatement" value="" /> > > </dbconnection> > > > > </dbforms-config> > > > > > > > > > > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Get the new Palm Tungsten T > handheld. Power & Color in a compact size! > http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en > _______________________________________________ > Jdbforms-developers mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jdbforms-developers > ------------------------------------------------------- This SF.net email is sponsored by: Get the new Palm Tungsten T handheld. Power & Color in a compact size! http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
