You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Mi...@bmwna.com on 2004/05/27 01:03:55 UTC
Torque TODO List Regarding Fully Qualified Table Names
Hi-
I've checked the web site but I'm wondering if it's on the to-do list to add
fully qualified table functionality to Torque in the near future.
It seems as though many users have opted out of using Torque primarily due
to this reason. I too have been checking over the last year hoping that
this feature would be integrated.
Any thoughts?
Michael
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Generated OM classes have $clo instead of column names
Posted by Cameron Hickey <ca...@panoramatos.com>.
In addition to the XML, here is a bit from the generated base class:
public abstract class BaseAdminuser extends BaseObject
{
/** The Peer class */
private static final AdminuserPeer peer =
new AdminuserPeer();
/** The value for the $clo field */
private int $clo;
/** The value for the $clo field */
private String $clo;
/** The value for the $clo field */
private String $clo;
/** The value for the $clo field */
private String $clo;
/** The value for the $clo field */
private String $clo;
/** The value for the $clo field */
private int $clo;
/**
* Get the Id
*
* @return int
*/
public int getId()
{
return $clo;
}
/**
* Set the value of Id
*
* @param v new value
*/
public void setId(int v)
{
if (this.$clo != v)
{
this.$clo = v;
setModified(true);
}
}
/**
* Get the Name
*
* @return String
*/
public String getName()
{
return $clo;
}
/**
* Set the value of Name
*
* @param v new value
*/
public void setName(String v)
{
if (!ObjectUtils.equals(this.$clo, v))
{
this.$clo = v;
setModified(true);
}
}
/**
* Get the Username
*
* @return String
*/
public String getUsername()
{
return $clo;
}
/**
* Set the value of Username
*
* @param v new value
*/
public void setUsername(String v)
{
if (!ObjectUtils.equals(this.$clo, v))
{
this.$clo = v;
setModified(true);
}
-----Original Message-----
From: James Roycroft [mailto:jamesor@telus.net]
Sent: Thursday, May 27, 2004 5:43 PM
To: Apache Torque Users List
Subject: Re: Generated OM classes have $clo instead of column names
Can you give us a snippet from your XML schema that includes a table
that uses
$clo?
You may also want to read this:
http://jakarta.apache.org/velocity/user-guide.html#Escaping%20Valid%20VT
L%20References
Jim
Quoting Cameron Hickey <ca...@panoramatos.com>:
> I have been using torque 3.0 for the last year, and now that I am
> starting a new project I decided to upgrade to the 3.1 split
generation
> tool.
>
> After managing to get the JDBC task to properly generate a new schema
> file from an existing database I need to use, I tried using the main
ant
> task to generate the OM classes. Everything actually worked until I
> compiled the project and discovered that the Base classes all had
"$clo"
> everywhere the column names should be.
>
> This is an example:
>
> /** The value for the $clo field */
> private String $clo;
>
>
>
> I assume that this is caused by some portion of the velocity
processing
> not properly replacing this field ($clo) with the value from the XML
> schema, but I cannot understand why.
>
> I thought it might be because I was using a schema generated by the
JDBC
> task, but then I imported a schema I know works fine in torque 3.0 and
> the same thing happened.
>
> I don't know a lot about velocity, or have any idea how to debug it,
but
> I hope there is something I can change in my build.properties file to
> make it properly recognize and use the column names from the XML file.
>
> Any ideas?
>
> Cameron
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Generated OM classes have $clo instead of column names
Posted by Cameron Hickey <ca...@panoramatos.com>.
Here is one table from my schema file, but this is happening with every
object and every column.
<table name="adminuser">
<column name="id" primaryKey="true" required="true" autoIncrement="true"
type="INTEGER"/>
<column name="name" required="true" type="VARCHAR" size="50"/>
<column name="username" required="true" type="VARCHAR" size="20"/>
<column name="password" required="true" type="VARCHAR" size="20"/>
<column name="email" required="true" type="VARCHAR" size="50"/>
<column name="accesslevel" required="true" type="INTEGER" />
</table>
That article about velocity seems like it could be related, but I don't
really think I should have to make any changes to the templates, since I
am basically using everything out of the box...
thanks
-----Original Message-----
From: James Roycroft [mailto:jamesor@telus.net]
Sent: Thursday, May 27, 2004 5:43 PM
To: Apache Torque Users List
Subject: Re: Generated OM classes have $clo instead of column names
Can you give us a snippet from your XML schema that includes a table
that uses
$clo?
You may also want to read this:
http://jakarta.apache.org/velocity/user-guide.html#Escaping%20Valid%20VT
L%20References
Jim
Quoting Cameron Hickey <ca...@panoramatos.com>:
> I have been using torque 3.0 for the last year, and now that I am
> starting a new project I decided to upgrade to the 3.1 split
generation
> tool.
>
> After managing to get the JDBC task to properly generate a new schema
> file from an existing database I need to use, I tried using the main
ant
> task to generate the OM classes. Everything actually worked until I
> compiled the project and discovered that the Base classes all had
"$clo"
> everywhere the column names should be.
>
> This is an example:
>
> /** The value for the $clo field */
> private String $clo;
>
>
>
> I assume that this is caused by some portion of the velocity
processing
> not properly replacing this field ($clo) with the value from the XML
> schema, but I cannot understand why.
>
> I thought it might be because I was using a schema generated by the
JDBC
> task, but then I imported a schema I know works fine in torque 3.0 and
> the same thing happened.
>
> I don't know a lot about velocity, or have any idea how to debug it,
but
> I hope there is something I can change in my build.properties file to
> make it properly recognize and use the column names from the XML file.
>
> Any ideas?
>
> Cameron
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Generated OM classes have $clo instead of column names
Posted by James Roycroft <ja...@telus.net>.
Can you give us a snippet from your XML schema that includes a table that uses
$clo?
You may also want to read this:
http://jakarta.apache.org/velocity/user-guide.html#Escaping%20Valid%20VTL%20References
Jim
Quoting Cameron Hickey <ca...@panoramatos.com>:
> I have been using torque 3.0 for the last year, and now that I am
> starting a new project I decided to upgrade to the 3.1 split generation
> tool.
>
> After managing to get the JDBC task to properly generate a new schema
> file from an existing database I need to use, I tried using the main ant
> task to generate the OM classes. Everything actually worked until I
> compiled the project and discovered that the Base classes all had "$clo"
> everywhere the column names should be.
>
> This is an example:
>
> /** The value for the $clo field */
> private String $clo;
>
>
>
> I assume that this is caused by some portion of the velocity processing
> not properly replacing this field ($clo) with the value from the XML
> schema, but I cannot understand why.
>
> I thought it might be because I was using a schema generated by the JDBC
> task, but then I imported a schema I know works fine in torque 3.0 and
> the same thing happened.
>
> I don't know a lot about velocity, or have any idea how to debug it, but
> I hope there is something I can change in my build.properties file to
> make it properly recognize and use the column names from the XML file.
>
> Any ideas?
>
> Cameron
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Generated OM classes have $clo instead of column names
Posted by T E Schmitz <ma...@numerixtechnology.de>.
For starters, look at Velocity.log for clues.
Regards,
Tarlika Elisabeth Schmitz
Cameron Hickey wrote:
> file from an existing database I need to use, I tried using the main ant
> task to generate the OM classes. Everything actually worked until I
> compiled the project and discovered that the Base classes all had "$clo"
> everywhere the column names should be.
>
> This is an example:
>
> /** The value for the $clo field */
> private String $clo;
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Generated OM classes have $clo instead of column names
Posted by Cameron Hickey <ca...@panoramatos.com>.
I have been using torque 3.0 for the last year, and now that I am
starting a new project I decided to upgrade to the 3.1 split generation
tool.
After managing to get the JDBC task to properly generate a new schema
file from an existing database I need to use, I tried using the main ant
task to generate the OM classes. Everything actually worked until I
compiled the project and discovered that the Base classes all had "$clo"
everywhere the column names should be.
This is an example:
/** The value for the $clo field */
private String $clo;
I assume that this is caused by some portion of the velocity processing
not properly replacing this field ($clo) with the value from the XML
schema, but I cannot understand why.
I thought it might be because I was using a schema generated by the JDBC
task, but then I imported a schema I know works fine in torque 3.0 and
the same thing happened.
I don't know a lot about velocity, or have any idea how to debug it, but
I hope there is something I can change in my build.properties file to
make it properly recognize and use the column names from the XML file.
Any ideas?
Cameron
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: Torque TODO List Regarding Fully Qualified Table Names
Posted by Bogdan Vatkov <bv...@globaltech-bg.com>.
Hi, I have made a lot of fixes to the code to support fully qualified names
and I am thinking of comitting to the CVS ina different branch ..but i still
have no time to
make corresponding docs to the changes have made ...
anyway I use successfully fully qualified names with postgres
To Developers:
Is it possible for me to create a branch ? to upload the fully qualified
names and
the SERIAL type ( sql proper generation and reverse (jdbc goal)) in
postgres.
I have a lot of fixes in the code and I have developed new packages to
support
data representation/manipulation code (stuff like representing of nested
objects, authorizing across all the data model mechanisms etc.)
What do you think , should I be able to commit to the CVS ?
Thanx,
Bogdan
----- Original Message -----
From: <Mi...@bmwna.com>
To: <to...@db.apache.org>
Sent: Thursday, May 27, 2004 2:03 AM
Subject: Torque TODO List Regarding Fully Qualified Table Names
> Hi-
>
> I've checked the web site but I'm wondering if it's on the to-do list to
add
> fully qualified table functionality to Torque in the near future.
>
> It seems as though many users have opted out of using Torque primarily due
> to this reason. I too have been checking over the last year hoping that
> this feature would be integrated.
>
> Any thoughts?
>
> Michael
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org