You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Rettig Christoph <ch...@siemens.at> on 2001/04/28 03:02:39 UTC
%table%-classes & limit on peer-objects :((
Hi!
I have finished my tests:
- tdk-1.1a13
- linux (suse 7.1), windows NT (clean, no tdk on it before and one
where
I already installed the tdk), windows 2000 (clean)
- linux with 128MB RAM, windows NT with 128 MB RAM (not clean),
windows
NT with 512 MB RAM (clean), windows 2000 with 256 MB RAM
- I installed a new tdk and build up a new (peer) application
- I did a build init (before I corrected a bug in torque:
base/mysql/index.vm does not produce a comma for the first time it
is
used - don't know what this should be for??)
- tested with http://127.0.0.1/<app>/servler/<app>/ and works fine:
I get the RDF-Table shown and can insert records in it
- stopped tomcat
- made a build clean
- added my table definitions to <app>-scheme.xml
- made a build init
- made a build compile (because the compiles gets out of memory -
don't
ask me why -> there's not that many stuff in there)
- started tomcat
- tested with http://127.0.0.1/<app>/servler/<app>/ and
- didn't get any content from ´RDF (Index.vm is responsible for
that)
- get an error when trying to insert records into RDF (by using
menue.vm -> insert.vm)
- access to RDF end with an null-pointer-exception in the save()-
mothod of BaseRdf.java
- stopped tomcat
- removed my definitions from <app>-scheme.xml and did the whole
procedure again -> nothing changes; access to RDF end with an
null-pointer-exception in the save()-mothod of BaseRdf.java
Here is the promised stack-trace for it:))
java.sql.SQLException: Connection object is null!
at
org.apache.turbine.util.db.pool.DBConnection.getConnection(DBConnection.
java:356)
at
org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:516)
at
org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:347)
at
org.apache.turbine.util.db.IDBroker.getIdAsBigDecimal(IDBroker.java:261)
at
org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:719)
at at.siemens.jTA.om.BaseRdfPeer.doInsert(BaseRdfPeer.java:96)
at at.siemens.jTA.om.BaseRdfPeer.doInsert(BaseRdfPeer.java:297)
at at.siemens.jTA.om.BaseRdf.save(BaseRdf.java:267)
at at.siemens.jTA.om.BaseRdf.save(BaseRdf.java:233)
at at.siemens.jTA.modules.actions.SQL.doInsert(SQL.java:89)
at java.lang.reflect.Method.invoke(Native Method)
at
org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(Veloc
ityActionEvent.java:164)
at
org.apache.turbine.util.velocity.VelocityActionEvent.perform(VelocityAct
ionEvent.java:111)
at
org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAction
.java:114)
at
org.apache.turbine.modules.actions.VelocitySecureAction.perform(Velocity
SecureAction.java:100)
at
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
at
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:14
8)
at org.apache.turbine.modules.Page.build(Page.java:90)
at
org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
at org.apache.turbine.Turbine.doGet(Turbine.java:414)
at org.apache.turbine.Turbine.doPost(Turbine.java:505)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:246)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:191)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:254)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:201)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticator
Base.java:468)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:208
7)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:164)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:446
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:162)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.j
ava:818)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:
897)
at java.lang.Thread.run(Thread.java:484)
I also tried to cut down my <app>-scheme.xml file but it seems that once
you loose access to RDF you never get it again. The only solution is to
make another peer-application:((
I couldn't figure out why I once got Table<blank>Classname-classes
generated and I couldn't manage to reproduce this situation - sorry for
bothering you that for - must be a one-time-experience:(( - so I will
try
to forget this thing happening:((
Last I will send you my <app>-scheme.xml file (my boss will kill me for
that) - maybe it is really too large???? As I am really new to turbine
I don't expect to find a reason for my problems very fast (and I need a
solution until Wednesday next week where I should come up with some sort
of prototype) - hope you can figure out where my mistake is:))
THX
Chris ...
P.S. sorry for the typos - its really late and I have to get to bed:)
<database name="jTA">
<table name="RDF">
<column name="RDF_ID" required="true" autoIncrement="true"
primaryKey="true" type="INTEGER"/>
<column name="TITLE" size="255" type="VARCHAR"/>
<column name="BODY" size="255" type="VARCHAR"/>
<column name="URL" size="255" type="VARCHAR"/>
<column name="AUTHOR" size="255" type="VARCHAR"/>
<column name="DEPT" size="255" type="VARCHAR"/>
</table>
<table name="PD_CONTINENT">
<column name="PD_CO_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_CO_NAME_DE" type="VARCHAR" size="50"/>
<column name="PD_CO_NAME_EN" type="VARCHAR" size="50"/>
<column name="PD_CO_NAME_FR" type="VARCHAR" size="50"/>
<column name="PD_CO_NAME_IT" type="VARCHAR" size="50"/>
<unique>
<unique-column name="PD_CO_ID"/>
</unique>
<index name="IDX1_PD_CONTINENT">
<index-column name="PD_CO_ID"/>
</index>
</table>
<table name="PD_REGION">
<column name="PD_RG_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_RG_NAME_DE" type="VARCHAR" size="50"/>
<column name="PD_RG_NAME_EN" type="VARCHAR" size="50"/>
<column name="PD_RG_NAME_FR" type="VARCHAR" size="50"/>
<column name="PD_RG_NAME_IT" type="VARCHAR" size="50"/>
<column name="PD_RG_WWW" type="VARCHAR" size="60"/>
<unique>
<unique-column name="PD_RG_ID"/>
</unique>
<index name="IDX1_PD_REGION">
<index-column name="PD_RG_ID"/>
</index>
</table>
<table name="PD_REGION_CONTINENT">
<column name="PD_RG_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_CO_ID" required="true"
primaryKey="true" type="INTEGER"/>
<unique>
<unique-column name="PD_RG_ID"/>
<unique-column name="PD_CO_ID"/>
</unique>
<foreign-key foreignTable="PD_CONTINENT">
<reference local="PD_CO_ID" foreign="PD_CO_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_REGION">
<reference local="PD_RG_ID" foreign="PD_RG_ID"/>
</foreign-key>
<index name="IDX1_PD_REGION_CONTINENT">
<index-column name="PD_RG_ID"/>
<index-column name="PD_CO_ID"/>
</index>
<index name="IDX2_PD_REGION_CONTINENT">
<index-column name="PD_RG_ID"/>
</index>
<index name="IDX3_PD_REGION_CONTINENT">
<index-column name="PD_CO_ID"/>
</index>
</table>
<table name="PD_COUNTRY">
<column name="PD_CT_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_CT_ISO3166_ID" type="INTEGER"/>
<column name="PD_CT_NAME_DE" type="VARCHAR" size="50"/>
<column name="PD_CT_NAME_EN" type="VARCHAR" size="50"/>
<column name="PD_CT_NAME_FR" type="VARCHAR" size="50"/>
<column name="PD_CT_NAME_IT" type="VARCHAR" size="50"/>
<column name="PD_CT_PREPHONE" type="VARCHAR" size="20"/>
<column name="PD_CT_2LC" type="VARCHAR" size="2"/>
<column name="PD_CT_3LC" type="VARCHAR" size="3"/>
<column name="PD_CT_WWW" type="VARCHAR" size="60"/>
<unique>
<unique-column name="PD_CT_ID"/>
</unique>
<index name="IDX1_PD_COUNTRY">
<index-column name="PD_CT_ISO3166_ID"/>
</index>
</table>
<table name="PD_COUNTRY_CONTINENT">
<column name="PD_CT_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_CO_ID" required="true"
primaryKey="true" type="INTEGER"/>
<unique>
<unique-column name="PD_CT_ID"/>
<unique-column name="PD_CO_ID"/>
</unique>
<foreign-key foreignTable="PD_CONTINENT">
<reference local="PD_CO_ID" foreign="PD_CO_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_COUNTRY">
<reference local="PD_CT_ID" foreign="PD_CT_ID"/>
</foreign-key>
<index name="IDX1_PD_COUNTRY_CONTINENT">
<index-column name="PD_CT_ID"/>
<index-column name="PD_CO_ID"/>
</index>
<index name="IDX2_PD_COUNTRY_CONTINENT">
<index-column name="PD_CT_ID"/>
</index>
<index name="IDX3_PD_COUNTRY_CONTINENT">
<index-column name="PD_CO_ID"/>
</index>
</table>
<table name="PD_SUBCOUNTRY">
<column name="PD_SUBCT_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_CT_ID" required="true" type="INTEGER"/>
<column name="PD_SUBCT_NAME_DE" type="VARCHAR"
size="50"/>
<column name="PD_SUBCT_NAME_EN" type="VARCHAR"
size="50"/>
<column name="PD_SUBCT_NAME_FR" type="VARCHAR"
size="50"/>
<column name="PD_SUBCT_NAME_IT" type="VARCHAR"
size="50"/>
<column name="PD_SUBCT_PREPHONE" type="VARCHAR"
size="20"/>
<column name="PD_SUBCT_WWW" type="VARCHAR" size="60"/>
<unique>
<unique-column name="PD_SUBCT_ID"/>
</unique>
<foreign-key foreignTable="PD_COUNTRY">
<reference local="PD_CT_ID" foreign="PD_CT_ID"/>
</foreign-key>
<index name="IDX1_PD_SUBCOUNTRY">
<index-column name="PD_SUBCT_ID"/>
</index>
<index name="IDX2_PD_SUBCOUNTRY">
<index-column name="PD_CT_ID"/>
</index>
</table>
<table name="PD_COUNTRY_REGION">
<column name="PD_CT_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_RG_ID" required="true"
primaryKey="true" type="INTEGER"/>
<unique>
<unique-column name="PD_CT_ID"/>
<unique-column name="PD_RG_ID"/>
</unique>
<foreign-key foreignTable="PD_COUNTRY">
<reference local="PD_CT_ID" foreign="PD_CT_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_REGION">
<reference local="PD_RG_ID" foreign="PD_RG_ID"/>
</foreign-key>
<index name="IDX1_PD_COUNTRY_REGION">
<index-column name="PD_CT_ID"/>
<index-column name="PD_RG_ID"/>
</index>
<index name="IDX2_PD_COUNTRY_REGION">
<index-column name="PD_CT_ID"/>
</index>
<index name="IDX3_PD_COUNTRY_REGION">
<index-column name="PD_RG_ID"/>
</index>
</table>
<table name="PD_STOPTYP">
<column name="PD_ST_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_ST_DESCR_DE" type="VARCHAR" size="40"/>
<column name="PD_ST_DESCR_EN" type="VARCHAR" size="40"/>
<column name="PD_ST_DESCR_FR" type="VARCHAR" size="40"/>
<column name="PD_ST_DESCR_IT" type="VARCHAR" size="40"/>
<unique>
<unique-column name="PD_ST_ID"/>
</unique>
<index name="IDX1_PD_STOPTYP">
<index-column name="PD_ST_ID"/>
</index>
</table>
<table name="PD_CITY">
<column name="PD_CY_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_CT_ID" required="true" type="INTEGER"/>
<column name="PD_SUBCT_ID" type="INTEGER"/>
<column name="PD_CY_NAME_DE" type="VARCHAR" size="50"/>
<column name="PD_CY_NAME_EN" type="VARCHAR" size="50"/>
<column name="PD_CY_NAME_FR" type="VARCHAR" size="50"/>
<column name="PD_CY_NAME_IT" type="VARCHAR" size="50"/>
<column name="PD_CT_PREPHONE" type="VARCHAR" size="20"/>
<column name="PD_CT_3LC" type="VARCHAR" size="3"/>
<column name="PD_CT_WWW" type="VARCHAR" size="60"/>
<unique>
<unique-column name="PD_CY_ID"/>
</unique>
<foreign-key foreignTable="PD_COUNTRY">
<reference local="PD_CT_ID" foreign="PD_CT_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_SUBCOUNTRY">
<reference local="PD_SUBCT_ID"
foreign="PD_SUBCT_ID"/>
</foreign-key>
<index name="IDX1_PD_CITY">
<index-column name="PD_CY_ID"/>
</index>
<index name="IDX2_PD_CITY">
<index-column name="PD_CT_ID"/>
</index>
<index name="IDX3_PD_CITY">
<index-column name="PD_SUBCT_ID"/>
</index>
</table>
<table name="PD_CITY_CITY_MILES">
<column name="PD_CC_CITY1" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_CC_CITY2" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_CC_MILES" required="true"
type="INTEGER"/>
<unique>
<unique-column name="PD_CC_CITY1"/>
<unique-column name="PD_CC_CITY2"/>
</unique>
<foreign-key foreignTable="PD_CITY">
<reference local="PD_CC_CITY1"
foreign="PD_CY_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_CITY">
<reference local="PD_CC_CITY2"
foreign="PD_CY_ID"/>
</foreign-key>
<index name="IDX1_PD_CITY_CITY_MILES">
<index-column name="PD_CC_CITY1"/>
<index-column name="PD_CC_CITY2"/>
</index>
</table>
<table name="PD_AIRPORT">
<column name="PD_AP_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_CY_ID" required="true" type="INTEGER"/>
<column name="PD_AP_NAME" type="VARCHAR" size="60"/>
<column name="PD_AP_3LC" type="VARCHAR" size="3"/>
<column name="PD_AP_CHECKINDESCR_DE" type="VARCHAR"
size="100"/>
<column name="PD_AP_CHECKINDESCR_EN" type="VARCHAR"
size="100"/>
<column name="PD_AP_CHECKINDESCR_FR" type="VARCHAR"
size="100"/>
<column name="PD_AP_CHECKINDESCR_IT" type="VARCHAR"
size="100"/>
<column name="PD_AP_TAX" type="BOOLEANINT"/>
<column name="PD_AP_DUTYFREE_ARR" type="BOOLEANINT"/>
<column name="PD_AP_DUTYFREE_DEP" type="BOOLEANINT"/>
<column name="PD_AP_FON_CHECKIN" type="VARCHAR"
size="20"/>
<column name="PD_AP_FON_RESERVATION" type="VARCHAR"
size="20"/>
<column name="PD_AP_FON_INFO" type="VARCHAR" size="20"/>
<column name="PD_AP_WWW" type="VARCHAR" size="60"/>
<unique>
<unique-column name="PD_AP_ID"/>
</unique>
<foreign-key foreignTable="PD_CITY">
<reference local="PD_CY_ID" foreign="PD_CY_ID"/>
</foreign-key>
<index name="IDX1_PD_AIRPORT">
<index-column name="PD_AP_ID"/>
</index>
<index name="IDX2_PD_AIRPORT">
<index-column name="PD_CY_ID"/>
</index>
</table>
<table name="PD_AIRCRAFT">
<column name="PD_AC_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_AC_CODE" type="VARCHAR" size="20"/>
<column name="PD_AC_NAME" type="VARCHAR" size="40"/>
<column name="PD_AC_WINGSPAN" type="INTEGER"/>
<column name="PD_AC_LENGTH" type="VARCHAR" size="10"/>
<column name="PD_AC_HEIGHT" type="INTEGER"/>
<column name="PD_AC_WINGAREA" type="INTEGER"/>
<column name="PD_AC_MTOW" type="INTEGER"/>
<column name="PD_AC_MLW" type="INTEGER"/>
<column name="PD_AC_MZFW" type="INTEGER"/>
<column name="PD_AC_ADOW" type="INTEGER"/>
<column name="PD_AC_EG_CNT" type="INTEGER"/>
<column name="PD_AC_EN_MODEL" type="VARCHAR"
size="100"/>
<column name="PD_AC_EN_MANUF" type="VARCHAR"
size="100"/>
<column name="PD_AC_FUEL_CAP" type="INTEGER"/>
<column name="PD_AC_SPEED_MAXAIR" type="INTEGER"/>
<column name="PD_AC_SPEED_CRUISE" type="INTEGER"/>
<column name="PD_AC_SPEED_CRUISE_MACH" type="INTEGER"/>
<column name="PD_AC_RANGE_MAX" type="INTEGER"/>
<column name="PD_AC_CLASS_F_SLUMBERETTES"
type="INTEGER"/>
<column name="PD_AC_CLASS_F" type="INTEGER"/>
<column name="PD_AC_CLASS_C_MAINDECK" type="INTEGER"/>
<column name="PD_AC_CLASS_C_UPPERDECK" type="INTEGER"/>
<column name="PD_AC_CLASS_Y" type="INTEGER"/>
<column name="PD_AC_CLASS_CY_VARIABLE"
type="BOOLEANINT"/>
<column name="PD_AC_SEAT_CNT" type="INTEGER"/>
<column name="PD_AC_CARGO_CAPACITY" type="INTEGER"/>
<unique>
<unique-column name="PD_AC_ID"/>
</unique>
<index name="IDX1_PD_AIRCRAFT">
<index-column name="PD_AC_ID"/>
</index>
</table>
<table name="PD_AIRLINE">
<column name="PD_AL_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_CT_ID" type="INTEGER"/>
<column name="PD_AL_NAME" type="VARCHAR" size="60"/>
<column name="PD_AL_2LC" type="VARCHAR" size="2"/>
<column name="PD_AL_3LC" type="VARCHAR" size="3"/>
<column name="PD_AL_WWW" type="VARCHAR" size="60"/>
<unique>
<unique-column name="PD_AL_ID"/>
</unique>
<foreign-key foreignTable="PD_COUNTRY">
<reference local="PD_CT_ID" foreign="PD_CT_ID"/>
</foreign-key>
<index name="IDX1_PD_AIRLINE">
<index-column name="PD_AL_ID"/>
</index>
<index name="IDX2_PD_AIRLINE">
<index-column name="PD_CT_ID"/>
</index>
<index name="IDX3_PD_AIRLINE">
<index-column name="PD_AL_NAME"/>
</index>
</table>
<table name="SYS_LANGUAGE">
<column name="SYS_LG_CODE" required="true"
primaryKey="true" type="VARCHAR" size="2"/>
<column name="SYS_LG_DESCR_DE" type="VARCHAR"
size="100"/>
<column name="SYS_LG_DESCR_EN" type="VARCHAR"
size="100"/>
<column name="SYS_LG_DESCR_FR" type="VARCHAR"
size="100"/>
<column name="SYS_LG_DESCR_IT" type="VARCHAR"
size="100"/>
<unique>
<unique-column name="SYS_LG_CODE"/>
</unique>
<index name="IDX1_SYS_LANGUAGE">
<index-column name="SYS_LG_CODE"/>
</index>
</table>
<table name="SYS_USER">
<column name="SYS_USER_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_CY_ID" type="INTEGER"/>
<column name="SYS_LG_CODE" type="VARCHAR" size="2"/>
<column name="SYS_USER_TID" type="VARCHAR" size="20"/>
<column name="SYS_USER_PIN" type="VARCHAR" size="4"/>
<column name="SYS_USER_PIN2" type="VARCHAR" size="4"/>
<column name="SYS_USER_PIN_VALID" type="BOOLEANINT"/>
<column name="SYS_USER_FIRSTNAME" type="VARCHAR"
size="20"/>
<column name="SYS_USER_LASTTNAME" type="VARCHAR"
size="20"/>
<column name="SYS_USER_LOGIN" type="VARCHAR" size="10"/>
<column name="SYS_USER_PASSWORD" type="VARCHAR"
size="10"/>
<column name="SYS_USER_FON" type="VARCHAR" size="20"/>
<column name="SYS_USER_MOBILE" type="VARCHAR"
size="20"/>
<column name="SYS_USER_LOCKED" type="BOOLEANINT"/>
<column name="SYS_USER_VALID_FROM" type="TIMESTAMP"/>
<column name="SYS_USER_VALID_UNTIL" type="TIMESTAMP"/>
<unique>
<unique-column name="SYS_USER_ID"/>
</unique>
<foreign-key foreignTable="PD_CITY">
<reference local="PD_CY_ID" foreign="PD_CY_ID"/>
</foreign-key>
<foreign-key foreignTable="SYS_LANGUAGE">
<reference local="SYS_LG_CODE"
foreign="SYS_LG_CODE"/>
</foreign-key>
<index name="IDX1_SYS_USER">
<index-column name="SYS_USER_ID"/>
</index>
<index name="IDX2_SYS_USER">
<index-column name="PD_CY_ID"/>
</index>
<index name="IDX3_SYS_USER">
<index-column name="SYS_USER_LOGIN"/>
</index>
<index name="IDX4_SYS_USER">
<index-column name="SYS_LG_CODE"/>
</index>
</table>
<table name="SYS_GROUP">
<column name="SYS_GROUP_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="SYS_GROUP_DESCR_DE" type="VARCHAR"
size="40"/>
<column name="SYS_GROUP_DESCR_EN" type="VARCHAR"
size="40"/>
<column name="SYS_GROUP_DESCR_FR" type="VARCHAR"
size="40"/>
<column name="SYS_GROUP_DESCR_IT" type="VARCHAR"
size="40"/>
<column name="SYS_GROUP_VALID_FROM" type="TIMESTAMP"/>
<column name="SYS_GROUP_VALID_UNTIL" type="TIMESTAMP"/>
<unique>
<unique-column name="SYS_GROUP_ID"/>
</unique>
<index name="IDX1_SYS_GROUP">
<index-column name="SYS_GROUP_ID"/>
</index>
</table>
<table name="USER_GROUP">
<column name="SYS_USER_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="SYS_GROUP_ID" required="true"
primaryKey="true" type="INTEGER"/>
<unique>
<unique-column name="SYS_USER_ID"/>
<unique-column name="SYS_GROUP_ID"/>
</unique>
<foreign-key foreignTable="SYS_GROUP">
<reference local="SYS_GROUP_ID"
foreign="SYS_GROUP_ID"/>
</foreign-key>
<foreign-key foreignTable="SYS_USER">
<reference local="SYS_USER_ID"
foreign="SYS_USER_ID"/>
</foreign-key>
<index name="IDX1_USER_GROUP">
<index-column name="SYS_USER_ID"/>
<index-column name="SYS_GROUP_ID"/>
</index>
<index name="IDX2_USER_GROUP">
<index-column name="SYS_USER_ID"/>
</index>
<index name="IDX3_USER_GROUP">
<index-column name="SYS_GROUP_ID"/>
</index>
</table>
<table name="CD_CACHE">
<column name="CD_CACHE_SUBJECT" required="true"
primaryKey="true" type="VARCHAR" size="50"/>
<column name="CD_CACHE_MESSAGE" type="LONGVARCHAR"/>
<column name="CD_CACHE_VALID_FROM" type="TIMESTAMP"/>
<column name="CD_CACHE_VALID_TO" type="TIMESTAMP"/>
<unique>
<unique-column name="CD_CACHE_SUBJECT"/>
</unique>
<index name="IDX1_CD_CACHE">
<index-column name="CD_CACHE_SUBJECT"/>
</index>
</table>
<table name="USER_AIRLINE">
<column name="SYS_USER_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_AL_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="SYS_UAL_PRIORITY" type="INTEGER"/>
<unique>
<unique-column name="SYS_USER_ID"/>
<unique-column name="PD_AL_ID"/>
</unique>
<foreign-key foreignTable="SYS_USER">
<reference local="SYS_USER_ID"
foreign="SYS_USER_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_AIRLINE">
<reference local="PD_AL_ID" foreign="PD_AL_ID"/>
</foreign-key>
<index name="IDX1_USER_AIRLINE">
<index-column name="SYS_USER_ID"/>
<index-column name="PD_AL_ID"/>
</index>
<index name="IDX2_USER_AIRLINE">
<index-column name="SYS_USER_ID"/>
</index>
<index name="IDX3_USER_AIRLINE">
<index-column name="PD_AL_ID"/>
</index>
</table>
<table name="SYS_FLIGHTGROUP">
<column name="SYS_FG_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="SYS_USER_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="SYS_FG_DESCR" type="VARCHAR" size="100"/>
<column name="SYS_FG_CITY_ID_SRC" type="INTEGER"/>
<column name="SYS_FG_CITY_ID_DST" type="INTEGER"/>
<unique>
<unique-column name="SYS_FG_ID"/>
</unique>
<foreign-key foreignTable="SYS_USER">
<reference local="SYS_USER_ID"
foreign="SYS_USER_ID"/>
</foreign-key>
<index name="IDX1_SYS_FLIGHTGROUP">
<index-column name="SYS_FG_ID"/>
</index>
<index name="IDX2_IDX1_SYS_FLIGHTGROUP">
<index-column name="SYS_USER_ID"/>
</index>
</table>
<table name="AIR_FLIGHT">
<column name="AIR_FL_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="PD_ST_ID" required="true" type="INTEGER"/>
<column name="AIR_FL_NR_SEG1" type="INTEGER"/>
<column name="AIR_FL_NR_SEG2" type="INTEGER"/>
<column name="AIR_FL_CITY_ID_SRC" required="true"
type="INTEGER"/>
<column name="AIR_FL_CITY_ID_XFER" type="INTEGER"/>
<column name="AIR_FL_CITY_ID_DST" required="true"
type="INTEGER"/>
<column name="AIR_FL_ALC_SEG1" type="INTEGER"/>
<column name="AIR_FL_ALC_SEG2" type="INTEGER"/>
<column name="AIR_FL_AP_ID_SRC" type="INTEGER"/>
<column name="AIR_FL_AP_ID_XFER" type="INTEGER"/>
<column name="AIR_FL_AP_ID_DST" type="INTEGER"/>
<column name="AIR_FL_TIME_DEP" type="TIME"/>
<column name="AIR_FL_TIME_XFER_ARR" type="TIME"/>
<column name="AIR_FL_TIME_XFER_DEP" type="TIME"/>
<column name="AIR_FL_TIME_ARR" type="TIME"/>
<column name="AIR_FL_OPS_DAYS" type="VARCHAR" size="7"/>
<column name="AIR_FL_STOP_CNT" type="INTEGER"/>
<column name="AIR_FL_VALID_FROM" type="TIMESTAMP"/>
<column name="AIR_FL_VALID_UNTIL" type="TIMESTAMP"/>
<column name="AIR_FL_SERVICE_FLAGS" type="INTEGER"/>
<unique>
<unique-column name="AIR_FL_ID"/>
</unique>
<foreign-key foreignTable="PD_STOPTYP">
<reference local="PD_ST_ID" foreign="PD_ST_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_CITY">
<reference local="AIR_FL_CITY_ID_SRC"
foreign="PD_CY_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_CITY">
<reference local="AIR_FL_CITY_ID_XFER"
foreign="PD_CY_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_CITY">
<reference local="AIR_FL_CITY_ID_DST"
foreign="PD_CY_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_AIRLINE">
<reference local="AIR_FL_ALC_SEG1"
foreign="PD_AL_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_AIRLINE">
<reference local="AIR_FL_ALC_SEG2"
foreign="PD_AL_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_AIRPORT">
<reference local="AIR_FL_AP_ID_SRC"
foreign="PD_AP_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_AIRPORT">
<reference local="AIR_FL_AP_ID_XFER"
foreign="PD_AP_ID"/>
</foreign-key>
<foreign-key foreignTable="PD_AIRPORT">
<reference local="AIR_FL_AP_ID_DST"
foreign="PD_AP_ID"/>
</foreign-key>
<index name="IDX1_AIR_FLIGHT">
<index-column name="AIR_FL_ID"/>
</index>
<index name="IDX2_AIR_FLIGHT">
<index-column name="PD_ST_ID"/>
</index>
<index name="IDX3_AIR_FLIGHT">
<index-column name="AIR_FL_ID"/>
</index>
<index name="IDX4_AIR_FLIGHT">
<index-column name="AIR_FL_CITY_ID_SRC"/>
<index-column name="AIR_FL_CITY_ID_DST"/>
</index>
</table>
<table name="SYS_FLIGHTGROUP_FLIGHT">
<column name="SYS_FG_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="AIR_FL_ID" required="true"
primaryKey="true" type="INTEGER"/>
<column name="SYS_FGF_DATE_FLIGHT" type="TIMESTAMP"/>
<column name="SYS_FGF_WATCHFLIGHT" type="BOOLEANINT"/>
<column name="SYS_FGF_REBOOKABLE" type="BOOLEANINT"/>
<column name="SYS_FGF_VALID_FROM" type="TIMESTAMP"/>
<column name="SYS_FGF_VALID_UNTIL" type="TIMESTAMP"/>
<unique>
<unique-column name="SYS_FG_ID"/>
<unique-column name="AIR_FL_ID"/>
</unique>
<foreign-key foreignTable="AIR_FLIGHT">
<reference local="AIR_FL_ID"
foreign="AIR_FL_ID"/>
</foreign-key>
<foreign-key foreignTable="SYS_FLIGHTGROUP">
<reference local="SYS_FG_ID"
foreign="SYS_FG_ID"/>
</foreign-key>
<index name="IDX1_SYS_FLIGHTGROUP_FLIGHT">
<index-column name="SYS_FG_ID"/>
<index-column name="AIR_FL_ID"/>
</index>
<index name="IDX2_SYS_FLIGHTGROUP_FLIGHT">
<index-column name="SYS_FG_ID"/>
</index>
<index name="IDX3_SYS_FLIGHTGROUP_FLIGHT">
<index-column name="AIR_FL_ID"/>
</index>
</table>
<table name="SYS_WTZ">
<column name="SYS_WTZ_LOCID" required="true"
primaryKey="true" type="VARCHAR" size="10"/>
<column name="SYS_WTZ_COUNTRY" type="VARCHAR"
size="50"/>
<column name="SYS_WTZ_REGION" type="VARCHAR" size="50"/>
<column name="SYS_WTZ_CITYLIST" type="VARCHAR"
size="100"/>
<column name="SYS_WTZ_STDBIAS" type="VARCHAR"
size="20"/>
<column name="SYS_WTZ_DSTBIAS" type="VARCHAR"
size="20"/>
<column name="SYS_WTZ_DSTSTARTPATTERN" type="VARCHAR"
size="20"/>
<column name="SYS_WTZ_DSTENDPATTERN" type="VARCHAR"
size="20"/>
<column name="SYS_WTZ_MAPFILE" type="VARCHAR"
size="20"/>
<column name="SYS_WTZ_THISYEARDSTSTART" type="VARCHAR"
size="20"/>
<column name="SYS_WTZ_THISYEARDSTEND" type="VARCHAR"
size="20"/>
<column name="SYS_WTZ_NEXTYEARDSTSTART" type="VARCHAR"
size="20"/>
<column name="SYS_WTZ_NEXTYEARDSTEND" type="VARCHAR"
size="20"/>
<column name="SYS_WTZ_THISYEARUTCSTART" type="VARCHAR"
size="20"/>
<column name="SYS_WTZ_THISYEARUTCEND" type="VARCHAR"
size="20"/>
<column name="SYS_WTZ_NEXTYEARUTCSTART" type="VARCHAR"
size="20"/>
<column name="SYS_WTZ_NEXTYEARUTCEND" type="VARCHAR"
size="20"/>
<unique>
<unique-column name="SYS_WTZ_LOCID"/>
</unique>
<index name="IDX1_SYS_FLIGHTGROUP_FLIGHT">
<index-column name="SYS_WTZ_LOCID"/>
</index>
</table>
</database>
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: %table%-classes & limit on peer-objects :((
Posted by John McNally <jm...@collab.net>.
Do you have lines like this in your TurbineResources.properties file?
database.jTA.driver=org.gjt.mm.mysql.Driver
database.jTA.url=jdbc:mysql://localhost:3306/project_name
database.jTA.username=
database.jTA.password=
it appears you are not validating your xml. if you add the doctype info
to your input you will see the <unique> tags are out of order. This
probably has little effect, but it is better to follow the dtd.
I ran this xml file through torque and it appeared to take ~25 MB.
Since all your machines seem to have plenty of memory, you could use the
java -Xmx64m option if you appear to be running out of memory.
john mcnally
Rettig Christoph wrote:
>
> Hi!
>
> I have finished my tests:
>
> - tdk-1.1a13
> - linux (suse 7.1), windows NT (clean, no tdk on it before and one
> where
> I already installed the tdk), windows 2000 (clean)
> - linux with 128MB RAM, windows NT with 128 MB RAM (not clean),
> windows
> NT with 512 MB RAM (clean), windows 2000 with 256 MB RAM
> - I installed a new tdk and build up a new (peer) application
> - I did a build init (before I corrected a bug in torque:
> base/mysql/index.vm does not produce a comma for the first time it
> is
> used - don't know what this should be for??)
> - tested with http://127.0.0.1/<app>/servler/<app>/ and works fine:
> I get the RDF-Table shown and can insert records in it
> - stopped tomcat
> - made a build clean
> - added my table definitions to <app>-scheme.xml
> - made a build init
> - made a build compile (because the compiles gets out of memory -
> don't
> ask me why -> there's not that many stuff in there)
> - started tomcat
> - tested with http://127.0.0.1/<app>/servler/<app>/ and
> - didn't get any content from ´RDF (Index.vm is responsible for
> that)
> - get an error when trying to insert records into RDF (by using
> menue.vm -> insert.vm)
> - access to RDF end with an null-pointer-exception in the save()-
> mothod of BaseRdf.java
> - stopped tomcat
> - removed my definitions from <app>-scheme.xml and did the whole
> procedure again -> nothing changes; access to RDF end with an
> null-pointer-exception in the save()-mothod of BaseRdf.java
>
> Here is the promised stack-trace for it:))
>
> java.sql.SQLException: Connection object is null!
> at
> org.apache.turbine.util.db.pool.DBConnection.getConnection(DBConnection.
> java:356)
> at
> org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:516)
> at
> org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:347)
> at
> org.apache.turbine.util.db.IDBroker.getIdAsBigDecimal(IDBroker.java:261)
> at
> org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:719)
> at at.siemens.jTA.om.BaseRdfPeer.doInsert(BaseRdfPeer.java:96)
> at at.siemens.jTA.om.BaseRdfPeer.doInsert(BaseRdfPeer.java:297)
> at at.siemens.jTA.om.BaseRdf.save(BaseRdf.java:267)
> at at.siemens.jTA.om.BaseRdf.save(BaseRdf.java:233)
> at at.siemens.jTA.modules.actions.SQL.doInsert(SQL.java:89)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> org.apache.turbine.util.velocity.VelocityActionEvent.executeEvents(Veloc
> ityActionEvent.java:164)
> at
> org.apache.turbine.util.velocity.VelocityActionEvent.perform(VelocityAct
> ionEvent.java:111)
> at
> org.apache.turbine.modules.actions.VelocityAction.perform(VelocityAction
> .java:114)
> at
> org.apache.turbine.modules.actions.VelocitySecureAction.perform(Velocity
> SecureAction.java:100)
> at
> org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
> at
> org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:14
> 8)
> at org.apache.turbine.modules.Page.build(Page.java:90)
> at
> org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123)
> at org.apache.turbine.Turbine.doGet(Turbine.java:414)
> at org.apache.turbine.Turbine.doPost(Turbine.java:505)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:246)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:191)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
> e.java:254)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
> va:566)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
> e.java:201)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
> va:566)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticator
> Base.java:468)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
> va:564)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:208
> 7)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :164)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
> va:566)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:446
> )
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
> va:564)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
> java:162)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
> va:566)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
> 72)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
> at
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.j
> ava:818)
> at
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:
> 897)
> at java.lang.Thread.run(Thread.java:484)
>
> I also tried to cut down my <app>-scheme.xml file but it seems that once
> you loose access to RDF you never get it again. The only solution is to
> make another peer-application:((
>
> I couldn't figure out why I once got Table<blank>Classname-classes
> generated and I couldn't manage to reproduce this situation - sorry for
> bothering you that for - must be a one-time-experience:(( - so I will
> try
> to forget this thing happening:((
>
> Last I will send you my <app>-scheme.xml file (my boss will kill me for
> that) - maybe it is really too large???? As I am really new to turbine
> I don't expect to find a reason for my problems very fast (and I need a
> solution until Wednesday next week where I should come up with some sort
> of prototype) - hope you can figure out where my mistake is:))
>
> THX
>
> Chris ...
>
> P.S. sorry for the typos - its really late and I have to get to bed:)
>
> <database name="jTA">
>
> <table name="RDF">
> <column name="RDF_ID" required="true" autoIncrement="true"
> primaryKey="true" type="INTEGER"/>
> <column name="TITLE" size="255" type="VARCHAR"/>
> <column name="BODY" size="255" type="VARCHAR"/>
> <column name="URL" size="255" type="VARCHAR"/>
> <column name="AUTHOR" size="255" type="VARCHAR"/>
> <column name="DEPT" size="255" type="VARCHAR"/>
> </table>
> <table name="PD_CONTINENT">
> <column name="PD_CO_ID" required="true"
> primaryKey="true" type="INTEGER"/>
> <column name="PD_CO_NAME_DE" type="VARCHAR" size="50"/>
> <column name="PD_CO_NAME_EN" type="VARCHAR" size="50"/>
> <column name="PD_CO_NAME_FR" type="VARCHAR" size="50"/>
> <column name="PD_CO_NAME_IT" type="VARCHAR" size="50"/>
>
> <unique>
> <unique-column name="PD_CO_ID"/>
> </unique>
>
> <index name="IDX1_PD_CONTINENT">
> <index-column name="PD_CO_ID"/>
> </index>
> </table>
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org