Here it is .
In my prev message I didn't said that , I have defined the db using the
server , then I have generated the schema using the jdbc ant task and
the classes using the om ant task.
I don't want to define myself the shema file because I'm more famliar
with SQL and then I don't want to make Torque create or modify my DDL.
Finally I use Torque 3.3 version and the generator directly without
using Maven.
Thomas Fischer ha scritto:
>> I'm using postgres to generate torque classes but the automatic
>> generation seems to make a few mistakes.
>> In the base class I found this java statement
>>
>> private int pkAnagrafica =
>> nextval('anagrafica_pk_anagrafica_seq'::regclass);
>>
>> which is marked as wrong by the compiler.
>>
>> The same happens in the copyobject method of the same class:
>>
>> copyObj.setPkAnagrafica(
>>
> nextval('anagrafica_pk_anagrafica_seq'::regclass));
>
>> Is there a way to stop Torque generating these bad statements ?
>>
>
> Can you send the schema definition which you use for the table in question
> ? This would ease diagnostics. I suspect that you use a default value for
> the id; this is not necessary.
>
> Thomas
>
--
==================================================
Archimede Informatica NEWS!
==================================================
Realizzato il Sistema Integrato per la biglietteria della Torre di Pisa:
prenotazione, vendita, pre-vendita ed emissione dei biglietti di ingresso
alla Torre sia online che presso le biglietterie dislocate sulla piazza:
_http://www.opapisa.it/boxoffice
_Partner del Progetto Ci-Tel "Front office Telematico per il cittadino"
Ente Coordinatore Comune di Pisa
_http://www.comune.pisa.it/doc/e-government.htm
_==================================================
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
e-mail: archim...@archicoop.it
web: _http://www.archicoop.it
_ <http://www.archicoop.it/>__ <http://www.archicoop.it/>
<?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_3.dtd";>
<!-- Autogenerated by JDBCToXMLSchema! -->
<database name="gestionale_anidis">
<table name="anagrafica">
<column
default="nextval('anagrafica_pk_anagrafica_seq'::regclass)"
name="pk_anagrafica" primaryKey="true" required="true" type="INTEGER"/>
<column name="nome" required="true" size="256" type="VARCHAR"/>
<column name="cognome" required="true" size="255" type="VARCHAR"/>
<column name="ragionesociale" required="true" size="256" type="VARCHAR"/>
<column name="email" required="true" size="255" type="VARCHAR"/>
<column name="telefono" required="true" size="25" type="VARCHAR"/>
<column name="fax" required="true" size="25" type="VARCHAR"/>
<column name="indirizzo" required="true" size="255" type="VARCHAR"/>
<column name="cap" required="true" type="INTEGER"/>
<column name="citta" required="true" size="255" type="VARCHAR"/>
<column name="provincia" required="true" size="2" type="VARCHAR"/>
<column name="nazione" required="true" size="255" type="VARCHAR"/>
<column name="societa" required="true" size="255" type="VARCHAR"/>
<column name="codicefiscale" required="true" type="INTEGER"/>
<column name="partitaiva" required="true" type="INTEGER"/>
<column name="esenteiva" required="true" type="BIT"/>
<column name="cliente" required="true" type="BIT"/>
<column name="sponsor" required="true" type="BIT"/>
<column name="socio" required="true" type="BIT"/>
<column name="fornitore" required="true" type="BIT"/>
<column name="fatt_societa" required="true" size="255" type="VARCHAR"/>
<column name="fatt_indirizzo" required="true" size="255" type="VARCHAR"/>
<column name="fatt_cap" required="true" type="INTEGER"/>
<column name="fatt_citta" required="true" size="255" type="VARCHAR"/>
<column name="fatt_provincia" required="true" size="2" type="VARCHAR"/>
<column name="fatt_partitaiva" required="true" type="INTEGER"/>
<column name="fatt_dipartimento" required="true" size="255" type="VARCHAR"/>
<column name="fatt_telefono" required="true" size="25" type="VARCHAR"/>
<column name="fatt_fax" required="true" size="25" type="VARCHAR"/>
</table>
<table name="fatture">
<column default="nextval('fatture_pk_fatture_seq'::regclass)"
name="pk_fatture" primaryKey="true" required="true" type="INTEGER"/>
<column name="fk_fatture_anagrafica" required="true" type="INTEGER"/>
<column name="num_fattura" required="true" type="INTEGER"/>
<column name="nome" required="true" size="255" type="VARCHAR"/>
<column name="cognome" required="true" size="255" type="VARCHAR"/>
<column name="citta" required="true" size="255" type="VARCHAR"/>
<column name="provincia" required="true" size="2" type="VARCHAR"/>
<column name="fatt_societa" required="true" size="255" type="VARCHAR"/>
<column name="fatt_indirizzo" required="true" size="255" type="VARCHAR"/>
<column name="fatt_cap" required="true" type="INTEGER"/>
<column name="fatt_citta" required="true" size="255" type="VARCHAR"/>
<column name="fatt_provincia" required="true" size="2" type="VARCHAR"/>
<column name="fatt_partitaiva" required="true" size="100" type="VARCHAR"/>
<column name="fatt_oggetto" required="true" size="2147483647" type="VARCHAR"/>
<column name="totaleimponibile" required="true" type="INTEGER"/>
<column name="totaleiva" required="true" type="INTEGER"/>
<column name="totaledocumento" required="true" type="INTEGER"/>
<column name="quantita" required="true" type="INTEGER"/>
<column name="prezzounitario" required="true" type="INTEGER"/>
<column name="iva" required="true" type="INTEGER"/>
<column name="importo" required="true" type="INTEGER"/>
<column name="descrizione" required="true" size="2147483647" type="VARCHAR"/>
<foreign-key foreignTable="anagrafica">
<reference foreign="pk_anagrafica" local="fk_fatture_anagrafica"/>
</foreign-key>
</table>
<table name="ricevute">
<column default="nextval('ricevute_pk_ricevute_seq'::regclass)"
name="pk_ricevute" primaryKey="true" required="true" type="INTEGER"/>
<column name="fk_ricevute_anagrafica" required="true" type="INTEGER"/>
<column name="num_ricevuta" required="true" type="INTEGER"/>
<column name="nome" required="true" size="255" type="VARCHAR"/>
<column name="cognome" required="true" size="255" type="VARCHAR"/>
<column name="citta" required="true" size="255" type="VARCHAR"/>
<column name="provincia" required="true" size="2" type="VARCHAR"/>
<column name="ric_societa" required="true" size="255" type="VARCHAR"/>
<column name="ric_indirizzo" required="true" size="255" type="VARCHAR"/>
<column name="ric_cap" required="true" type="INTEGER"/>
<column name="ric_citta" required="true" size="255" type="VARCHAR"/>
<column name="ric_provincia" required="true" size="2" type="VARCHAR"/>
<column name="ric_partitaiva" required="true" size="100" type="VARCHAR"/>
<column name="ric_oggetto" required="true" size="2147483647" type="VARCHAR"/>
<column name="totaleimponibile" required="true" type="INTEGER"/>
<column name="totaleiva" required="true" type="INTEGER"/>
<column name="totaledocumento" required="true" type="INTEGER"/>
<column name="quantita" required="true" type="INTEGER"/>
<column name="prezzounitario" required="true" type="INTEGER"/>
<column name="iva" required="true" type="INTEGER"/>
<column name="importo" required="true" type="INTEGER"/>
<column name="descrizione" required="true" type="INTEGER"/>
<foreign-key foreignTable="anagrafica">
<reference foreign="pk_anagrafica" local="fk_ricevute_anagrafica"/>
</foreign-key>
</table>
</database>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org
