Re: newbie question about postgres: nextval

Ivano Luberti <[email protected]>
Newsgroups gmane.comp.jakarta.turbine.torque.user
Message-ID <[email protected]> 
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: [email protected]
web: _http://www.archicoop.it


_ <http://www.archicoop.it/>__ <http://www.archicoop.it/>

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
gestionale-anidis-schema.xml (text/xml, 6 KB) 
<?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>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.