Btw, here are the mapping files for my data as well.
<mapping>
<key-generator name="IDENTITY">
</key-generator>
<class name="com.vort.beans.UserInfo"
identity="userName">
<map-to table="userinfo" />
<cache-type type="unlimited"/>
<field name="userName" type="string">
<sql name="userName" type="varchar" />
</field>
<field name="password" type="string">
<sql name="password" type="varchar" />
</field>
<field name="clients" type="com.vort.beans.Client" collection="vector">
<sql many-key="userName"/>
</field>
<field name="firstName" type="string">
<sql name="firstName" type="varchar" />
</field>
<field name="lastName" type="string">
<sql name="lastName" type="varchar" />
</field>
<field name="company" type="string">
<sql name="company" type="varchar" />
</field>
<field name="address1" type="string">
<sql name="address1" type="varchar" />
</field>
<field name="address2" type="string">
<sql name="address2" type="varchar" />
</field>
<field name="town" type="string">
<sql name="town" type="varchar" />
</field>
<field name="state" type="string">
<sql name="state" type="varchar" />
</field>
<field name="zipCode" type="string">
<sql name="zipCode" type="varchar" />
</field>
<field name="email" type="string">
<sql name="email" type="varchar" />
</field>
<field name="areaCode" type="integer">
<sql name="areaCode" type="integer" />
</field>
<field name="phoneLeft" type="string">
<sql name="phoneLeft" type="varchar" />
</field>
<field name="phoneRight" type="string">
<sql name="phoneRight" type="varchar" />
</field>
<field name="activated" type="boolean">
<sql name="activated" type="char[01]"/>
</field>
</class>
<class name="com.vort.beans.Client"
identity="id"
key-generator="IDENTITY"
depends="com.vort.beans.UserInfo">
<map-to table="userclients"/>
<cache-type type="unlimited"/>
<field name="id" type="integer">
<sql name="id" type="integer"/>
</field>
<field name="user" type="com.vort.beans.UserInfo" required="true">
<sql name="userName"/>
</field>
<field name="projects" type="com.vort.beans.Project" collection="vector">
<sql many-key="clientId"/>
</field>
<!-- <field name="firstName" type="string">
<sql name="firstName" type="varchar"/>
</field>
<field name="lastName" type="string">
<sql name="lastName" type="varchar"/>
</field>
-->
<field name="clientName" type="string">
<sql name="company" type="varchar"/>
</field>
<!-- <field name="address1" type="string">
<sql name="address1" type="varchar"/>
</field>
<field name="address2" type="string">
<sql name="address2" type="varchar"/>
</field>
<field name="town" type="string">
<sql name="town" type="varchar"/>
</field>
<field name="state" type="string">
<sql name="state" type="varchar"/>
</field>
<field name="zipCode" type="integer">
<sql name="zipCode" type="integer"/>
</field>
<field name="areaCode" type="integer">
<sql name="areaCode" type="integer"/>
</field>
<field name="phoneLeft" type="string">
<sql name="phoneLeft" type="varchar"/>
</field>
<field name="phoneRight" type="string">
<sql name="phoneRight" type="varchar"/>
</field>
-->
</class>
<class name="com.vort.beans.Project"
identity="id"
key-generator="IDENTITY"
depends="com.vort.beans.Client">
<map-to table="prjinfo" />
<cache-type type="unlimited"/>
<field name="id" type="integer">
<sql name="id" type="integer"/>
</field>
<field name="client" type="com.vort.beans.Client" required="true">
<sql name="clientId"/>
</field>
<field name="vortechs" type="com.vort.vortechs.beans.VortechsDims" collection="vector">
<!-- get-method="getVortechs" set-method="setVortechs" -->
<sql many-key="projectId"/>
</field>
<field name="vortSentrys" type="com.vort.vortsentry.beans.VortSentryDims" collection="vector">
<!--get-method="getVortSentrys" set-method="setVortSentrys"-->
<sql many-key="projectId"/>
</field>
<field name="name" type="string">
<sql name="name" type="varchar"/>
</field>
<field name="state" type="string">
<sql name="state" type="varchar"/>
</field>
<field name="city" type="string">
<sql name="city" type="varchar"/>
</field>
</class>
<class name="com.vort.beans.SiteInfo" identity="id" key-generator="IDENTITY">
<map-to table="prjsiteinfo" />
<field name="id" type="integer">
<sql name="id" type="integer"/>
</field>
<field name="vortechs" type="com.vort.vortechs.beans.VortechsDims">
<sql name="vortechsId"/>
</field>
<field name="vortSentry" type="com.vort.vortsentry.beans.VortSentryDims">
<sql name="vortsentryId"/>
</field>
<field name="designStorm" type="double">
<sql name="designStorm" type="double"/>
</field>
<field name="inletMaterial" type="string">
<sql name="inletMaterial" type="varchar"/>
</field>
<field name="outletMaterial" type="string">
<sql name="outletMaterial" type="varchar"/>
</field>
<field name="inletPipeSize" type="integer">
<sql name="inletDia" type="integer"/>
</field>
<field name="outletPipeSize" type="integer">
<sql name="outletDia" type="integer"/>
</field>
<field name="invert" type="double">
<sql name="invert" type="double"/>
</field>
<field name="rim" type="double">
<sql name="rim" type="double"/>
</field>
<field name="tailWaterElev" type="double">
<sql name="tailWater" type="double"/>
</field>
</class>
<class name="com.vort.beans.StdSystem"
identity="id"
key-generator="IDENTITY"
depends="com.vort.beans.Project">
<map-to table="prjsystems"/>
<field name="id" type="integer">
<sql name="id" type="integer"/>
</field>
<field name="systemName" type="string">
<sql name="systemName" type="varchar"/>
</field>
<field name="zipCode" type="string">
<sql name="zipCode" type="varchar"/>
</field>
<field name="project" type="com.vort.beans.Project" >
<sql name="projectId"/>
</field>
<field name="sized" type="boolean" get-method="isSized" set-method="setSized">
<sql name="sized" type="char[01]"/>
</field>
<field name="metric" type="boolean" get-method="isMetric" set-method="setMetric">
<sql name="metric" type="char[01]"/>
</field>
</class>
</mapping>
<?xml version="1.0" encoding="UTF-8"?>
<!--
Document : vortechs.xml
Created on : August 30, 2004, 11:08 AM
Author : nstuart
Description:
Purpose of the document follows.
-->
<mapping>
<class name="com.vort.vortechs.beans.VortechsDims"
identity="id"
extends="com.vort.beans.StdSystem"
depends="com.vort.beans.Project">
<map-to table="prjsystemsvt" />
<cache-type type="unlimited"/>
<field name="id" type="integer">
<sql name="id" type="integer"/>
</field>
<field name="project" type="com.vort.beans.Project" >
<sql name="projectId"/>
</field>
<field name="rainfallSite" type="com.vort.vortechs.beans.RainFallSite" >
<sql name="rainFallSiteId" />
</field>
<field name="drainageArea" type="double">
<sql name="drainageArea" type="double"/>
</field>
<field name="swirlArea" type="double">
<sql name="swirlArea" type="double"/>
</field>
<field name="runOffCoeff" type="double">
<sql name="runOffCoeff" type="double"/>
</field>
<field name="flowRate" type="double">
<sql name="flowRate" type="double"/>
</field>
<field name="timeOfConc" type="integer">
<sql name="timeOfConc" type="integer"/>
</field>
<field name="performanceGoal" type="integer">
<sql name="performanceGoal" type="integer"/>
</field>
<field name="micronSize" type="string">
<sql name="micronSize" type="varchar"/>
</field>
<field name="efficencyWanted" type="integer">
<sql name="efficencyWanted" type="integer"/>
</field>
<field name="areaModel" type="com.vort.vortechs.beans.VortechsModel">
<sql name="areaModel"/>
</field>
<field name="flowModel" type="com.vort.vortechs.beans.VortechsModel">
<sql name="flowModel"/>
</field>
<field name="docModel" type="string">
<sql name="docModel" type="varchar"/>
</field>
<field name="bypassed" type="boolean">
<sql name="bypassed" type="char[01]"/>
</field>
<field name="sizingMethod2" type="boolean" get-method="isSizingMethod2" set-method="setSizingMethod2">
<sql name="sizingMethod2" type="char[01]"/>
</field>
</class>
<class name="com.vort.vortechs.beans.VortechsModel"
identity="model"
access="read-only">
<map-to table="vtenglishsystems"/>
<cache-type type="unlimited"/>
<field name="model" type="string">
<sql name="model" type="varchar"/>
</field>
<field name="length" type="double">
<sql name="length" type="double"/>
</field>
<field name="width" type="double">
<sql name="width" type="double"/>
</field>
<field name="diameter" type="double">
<sql name="diameter" type="double"/>
</field>
<field name="areasf" type="double">
<sql name="areasf" type="double"/>
</field>
<field name="qcfs" type="double">
<sql name="qcfs" type="double"/>
</field>
<field name="oilStorage" type="double">
<sql name="oilStorageGal" type="double"/>
</field>
<field name="sedimentStorage" type="double">
<sql name="sedimentStorageCy" type="double"/>
</field>
<field name="castIn" type="boolean">
<sql name="castIn" type="char[01]"/>
</field>
</class>
<class name="com.vort.vortechs.beans.RainFallSite"
identity="id"
key-generator="IDENTITY"
access="read-only">
<map-to table="vtstations"/>
<cache-type type="unlimited"/>
<field name="id" type="integer" >
<sql name="id" type="integer" />
</field>
<field name="zipCode" type="string" >
<sql name="zipCode" type="varchar" />
</field>
<field name="county" type="string" >
<sql name="county" type="varchar" />
</field>
<field name="micron50" type="com.vort.vortechs.beans.Micron50" >
<sql many-key="siteId" />
</field>
<field name="micron75" type="com.vort.vortechs.beans.Micron75" >
<sql many-key="siteId" />
</field>
<field name="micron150" type="com.vort.vortechs.beans.Micron150" >
<sql many-key="siteId" />
</field>
<field name="micron250" type="com.vort.vortechs.beans.Micron250" >
<sql many-key="siteId" />
</field>
<field name="micronTypical" type="com.vort.vortechs.beans.MicronTypical" >
<sql many-key="siteId" />
</field>
</class>
<class name="com.vort.vortechs.beans.Micron50"
identity="id"
key-generator="IDENTITY"
depends="com.vort.vortechs.beans.RainFallSite"
access="read-only">
<map-to table="vtmicron50"/>
<cache-type type="unlimited"/>
<field name="id" type="integer">
<sql name="id" type="integer" />
</field>
<field name="site" type="com.vort.vortechs.beans.RainFallSite" >
<sql name="siteId" />
</field>
<field name="c1550" type="double" >
<sql name="c1550" type="double" />
</field>
<field name="c1560" type="double" >
<sql name="c1560" type="double" />
</field>
<field name="c1570" type="double" >
<sql name="c1570" type="double" />
</field>
<field name="c1580" type="double" >
<sql name="c1580" type="double" />
</field>
<field name="c1585" type="double" >
<sql name="c1585" type="double" />
</field>
<field name="c6050" type="double" >
<sql name="c6050" type="double" />
</field>
<field name="c6060" type="double" >
<sql name="c6060" type="double" />
</field>
<field name="c6070" type="double" >
<sql name="c6070" type="double" />
</field>
<field name="c6080" type="double" >
<sql name="c6080" type="double" />
</field>
<field name="c6085" type="double" >
<sql name="c6085" type="double" />
</field>
</class>
<class name="com.vort.vortechs.beans.Micron75"
identity="id"
key-generator="IDENTITY"
depends="com.vort.vortechs.beans.RainFallSite"
access="read-only">
<map-to table="vtmicron75"/>
<cache-type type="unlimited"/>
<field name="id" type="integer">
<sql name="id" type="integer" />
</field>
<field name="site" type="com.vort.vortechs.beans.RainFallSite" >
<sql name="siteId" />
</field>
<field name="c1550" type="double" >
<sql name="c1550" type="double" />
</field>
<field name="c1560" type="double" >
<sql name="c1560" type="double" />
</field>
<field name="c1570" type="double" >
<sql name="c1570" type="double" />
</field>
<field name="c1580" type="double" >
<sql name="c1580" type="double" />
</field>
<field name="c1585" type="double" >
<sql name="c1585" type="double" />
</field>
<field name="c6050" type="double" >
<sql name="c6050" type="double" />
</field>
<field name="c6060" type="double" >
<sql name="c6060" type="double" />
</field>
<field name="c6070" type="double" >
<sql name="c6070" type="double" />
</field>
<field name="c6080" type="double" >
<sql name="c6080" type="double" />
</field>
<field name="c6085" type="double" >
<sql name="c6085" type="double" />
</field>
</class>
<class name="com.vort.vortechs.beans.Micron150"
identity="id"
key-generator="IDENTITY"
depends="com.vort.vortechs.beans.RainFallSite"
access="read-only">
<map-to table="vtmicron150"/>
<cache-type type="unlimited"/>
<field name="id" type="integer">
<sql name="id" type="integer" />
</field>
<field name="site" type="com.vort.vortechs.beans.RainFallSite" >
<sql name="siteId" />
</field>
<field name="c1550" type="double" >
<sql name="c1550" type="double" />
</field>
<field name="c1560" type="double" >
<sql name="c1560" type="double" />
</field>
<field name="c1570" type="double" >
<sql name="c1570" type="double" />
</field>
<field name="c1580" type="double" >
<sql name="c1580" type="double" />
</field>
<field name="c6050" type="double" >
<sql name="c6050" type="double" />
</field>
<field name="c6060" type="double" >
<sql name="c6060" type="double" />
</field>
<field name="c6070" type="double" >
<sql name="c6070" type="double" />
</field>
<field name="c6080" type="double" >
<sql name="c6080" type="double" />
</field>
</class>
<class name="com.vort.vortechs.beans.Micron250"
identity="id"
key-generator="IDENTITY"
depends="com.vort.vortechs.beans.RainFallSite"
access="read-only">
<map-to table="vtmicron250"/>
<cache-type type="unlimited"/>
<field name="id" type="integer">
<sql name="id" type="integer" />
</field>
<field name="site" type="com.vort.vortechs.beans.RainFallSite" >
<sql name="siteId" />
</field>
<field name="c1550" type="double" >
<sql name="c1550" type="double" />
</field>
<field name="c1560" type="double" >
<sql name="c1560" type="double" />
</field>
<field name="c1570" type="double" >
<sql name="c1570" type="double" />
</field>
<field name="c1580" type="double" >
<sql name="c1580" type="double" />
</field>
<field name="c6050" type="double" >
<sql name="c6050" type="double" />
</field>
<field name="c6060" type="double" >
<sql name="c6060" type="double" />
</field>
<field name="c6070" type="double" >
<sql name="c6070" type="double" />
</field>
<field name="c6080" type="double" >
<sql name="c6080" type="double" />
</field>
</class>
<class name="com.vort.vortechs.beans.MicronTypical"
identity="id"
key-generator="IDENTITY"
depends="com.vort.vortechs.beans.RainFallSite"
access="read-only">
<map-to table="vtmicrontypical"/>
<cache-type type="unlimited"/>
<field name="id" type="integer">
<sql name="id" type="integer" />
</field>
<field name="site" type="com.vort.vortechs.beans.RainFallSite" >
<sql name="siteId" />
</field>
<field name="c1550" type="double" >
<sql name="c1550" type="double" />
</field>
<field name="c1560" type="double" >
<sql name="c1560" type="double" />
</field>
<field name="c1570" type="double" >
<sql name="c1570" type="double" />
</field>
<field name="c1580" type="double" >
<sql name="c1580" type="double" />
</field>
<field name="c1585" type="double" >
<sql name="c1585" type="double" />
</field>
<field name="c6050" type="double" >
<sql name="c6050" type="double" />
</field>
<field name="c6060" type="double" >
<sql name="c6060" type="double" />
</field>
<field name="c6070" type="double" >
<sql name="c6070" type="double" />
</field>
<field name="c6080" type="double" >
<sql name="c6080" type="double" />
</field>
<field name="c6085" type="double" >
<sql name="c6085" type="double" />
</field>
</class>
</mapping>
<?xml version="1.0" encoding="UTF-8"?>
<!--
Document : vortsentry.xml
Created on : August 30, 2004, 12:35 PM
Author : nstuart
Description:
Purpose of the document follows.
-->
<mapping>
<class name="com.vort.vortsentry.beans.VortSentryDims"
identity="id"
extends="com.vort.beans.StdSystem"
depends="com.vort.beans.Project">
<map-to table="prjsystemsvs"/>
<field name="id" type="integer">
<sql name="id" type="integer"/>
</field>
<field name="project" type="com.vort.beans.Project" >
<sql name="projectId"/>
</field>
<field name="model"
type="com.vort.vortsentry.beans.VortSentryModel"
required="true"
access="read-only">
<sql name="manholeDia"/>
</field>
<field name="inletPipeID" type="integer">
<sql name="inletPipeDia" type="integer"/>
</field>
<field name="outletPipeID" type="integer">
<sql name="outletPipeDia" type="integer"/>
</field>
<field name="pipeCoeff" type="double">
<sql name="pipeCoeff" type="double"/>
</field>
<field name="pipeSlope" type="double">
<sql name="pipeSlope" type="double"/>
</field>
<field name="drainageArea" type="double">
<sql name="drainageArea" type="double"/>
</field>
<field name="percentImpervious" type="double">
<sql name="percentImpervious" type="double"/>
</field>
<field name="treatmentDepth1" type="double">
<sql name="treatmentDepth1" type="double"/>
</field>
<field name="treatmentDepth2" type="double">
<sql name="treatmentDepth2" type="double"/>
</field>
<field name="peakFlowRate" type="double">
<sql name="peakFlowRate" type="double"/>
</field>
<field name="maxPipeDia" type="integer">
<sql name="maxPipeDia" type="integer"/>
</field>
<field name="wqq" type="double">
<sql name="wqq" type="double"/>
</field>
<field name="flowPartitionHeight" type="double">
<sql name="flowPartitionHeight" type="double"/>
</field>
<field name="bypassLength" type="double">
<sql name="bypassLength" type="double"/>
</field>
<field name="outletFlowControl" type="double">
<sql name="outletFlowControl" type="double"/>
</field>
</class>
<class name="com.vort.vortsentry.beans.RainFallSite"
identity="id"
key-generator="IDENTITY">
<map-to table="vsrainfallsites"/>
<cache-type type="unlimited"/>
<field name="id" type="integer">
<sql name="id" type="integer"/>
</field>
<field name="zipCode" type="string">
<sql name="zipCode" type="varchar"/>
</field>
<field name="intensitys" type="com.vort.vortsentry.beans.RainFallInt" collection="vector">
<sql many-key="siteId"/>
</field>
</class>
<class name="com.vort.vortsentry.beans.RainFallInt"
identity="id"
key-generator="IDENTITY"
depends="com.vort.vortsentry.beans.RainFallSite">
<map-to table="vsrainfallinten"/>
<cache-type type="unlimited"/>
<field name="id" type="integer">
<sql name="id" type="integer"/>
</field>
<field name="site" type="com.vort.vortsentry.beans.RainFallSite">
<sql name="siteId"/>
</field>
<field name="intensity" type="double">
<sql name="intensity" type="double"/>
</field>
<field name="percent" type="double">
<sql name="percent" type="double"/>
</field>
</class>
<class name="com.vort.vortsentry.beans.FlowEfficiency"
identity="flow">
<map-to table="vseffflow"/>
<cache-type type="unlimited"/>
<field name="flow" type="double">
<sql name="flowRate" type="double"/>
</field>
<field name="efficiency" type="double">
<sql name="efficiency" type="double"/>
</field>
</class>
<class name="com.vort.vortsentry.beans.VortSentryModel"
identity="manholeDia">
<map-to table="vsstandards"/>
<field name="manholeDia" type="integer">
<sql name="manholeID" type="integer"/>
</field>
<field name="outletFlowControl" type="double">
<sql name="outletFlowControl" type="double"/>
</field>
<field name="baffleRadius" type="double">
<sql name="baffleRadius" type="double"/>
</field>
<field name="wqq" type="double">
<sql name="wqq" type="double"/>
</field>
<field name="flowPartitionHeight" type="double">
<sql name="flowPartitionHeight" type="double"/>
</field>
<field name="headEQHeight" type="double">
<sql name="headEQHeight" type="double"/>
</field>
<field name="bypassLength" type="double">
<sql name="bypassLength" type="double"/>
</field>
<field name="sleeveDim" type="double">
<sql name="sleeveDim" type="double"/>
</field>
<field name="sleeveOffset" type="double">
<sql name="sleeveOffset" type="double"/>
</field>
</class>
</mapping>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
