Some more infomation for what I am talking about.  This may be a question
more suited for the developer list, but the intent here is to narrow this
down to a configuration problem or an actual bug:

Torque   - torque-2.2a2
Velocity - 1.1
Database - Solid

the velocity.log
****************************************************************************
*
... multiple passes through templates
Thu Jul 26 11:32:26 EEST 2001   [info] ResourceManager : found
./sql/base/solid/columns.vm with loader
org.apache.velocity.runtime.resource.loader.FileResourceLoader
Thu Jul 26 11:32:26 EEST 2001  [error] Method get threw exception for
reference $dbprops in template ./sql/base/solid/columns.vm at  [2,20]
****************************************************************************
*


the project-schema.sql output:
****************************************************************************
*
... other table output
----------------------------------------------------------------------------
-
-- RIGHTSTABLE
----------------------------------------------------------------------------
-
drop table RIGHTSTABLE;
CREATE TABLE RIGHTSTABLE
(
    PRIMARY KEY(OID),

    OID INTEGER NOT NULL,
    ID WVARCHAR (255) NOT NULL,
    MODIFIED NUMERIC (16) NOT NULL,
    FILE LONG WVARCHAR NOT NULL,
    CLASSNAME WVARCHAR (255) NOT NULL
);

----------------------------------------------------------------------------
-
-- RIGHTSMEMBEROFROLETABLE
----------------------------------------------------------------------------
-
drop table RIGHTSMEMBEROFROLETABLE;

CREATE TABLE RIGHTSMEMBEROFR   ## stops here in this run.
****************************************************************************
*


the project-schema.sql:
****************************************************************************
*
  <table name="RIGHTSTABLE"
        javaName="RightsEntity"
      skipSql="false"
      baseClass="com.myCompany.AbstractClass"
      basePeer="com.myCompany.CorePeer"
  >
    <column name="OID" required="true" autoIncrement="false"
primaryKey="true" type="INTEGER"/>
    <column name="ID" unique="true" type="VARCHAR" size="255" />
    <column name="MODIFIED" type="NUMERIC" size="16"/>
    <column name="FILE" type="LONGVARCHAR"/>
    <column name="CLASSNAME" type="VARCHAR" size="255" required="true"/>
  </table>

  <table name="RIGHTSMEMBEROFROLETABLE"
        javaName="RightsMemberOfRoleEntity"
      skipSql="false"
      baseClass="com.myCompany.AbstractClass"
      basePeer="com.myCompany.CorePeer"
  >
    <column name="OID" required="true" autoIncrement="false"
primaryKey="true" type="INTEGER"/>
    <column name="ID" unique="true" type="VARCHAR" size="255" />
    <column name="MODIFIED" type="NUMERIC" size="16"/>
    <column name="FILE" type="LONGVARCHAR" />
    <column name="CLASSNAME" type="VARCHAR" size="255" required="true"/>
    <column name="RIGHTSOID" type="INTEGER"/>
    <column name="ROLEOID" type="INTEGER"/>

    <foreign-key foreignTable="RIGHTSTABLE">
      <reference local="RIGHTSOID" foreign="OID"/>
    </foreign-key>
    <foreign-key foreignTable="ROLETABLE">
      <reference local="ROLEOID" foreign="OID"/>
    </foreign-key>
  </table>
****************************************************************************
*

-----Original Message-----
From: Ken Helmes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 9:00 AM
To: [EMAIL PROTECTED]
Subject: Torque error


When using Torque to generate my database structure it generates the
myproject-schema.sql file - but stops midway through.
That is to say, the sql create table statements are created correctly but
then the process stops in the middle of outputting the create table
statement.
There doesn't seem to be any logic in where it is stopping ie. all of the
JDBC->DB mappings are in the dbprops template, syntax is correct, etc.  Has
anyone else encountered this problem?


/Ken


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to