db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ron piterman <ron.piter...@gmx.net>
Subject Re: IdGenerator is null
Date Tue, 13 Jul 2004 09:47:11 GMT
Here is a part of the database schema:
(I removed some tables becuase otherwise it is very big, but currently I 
am using in my app only these two...)

<?xml version="1.0"?>
<!DOCTYPE database SYSTEM 
"http://db.apache.org/torque/dtd/database_3_1.dtd">
<!-- Autogenerated by JDBCToXMLSchema! -->
<database  defaultIdMethod="native">
    <table name="address_book">
        <column name="address_book_id" primaryKey="true" required="true" 
type="INTEGER"/>
        <column default="0" name="customers_id" required="true" 
type="INTEGER"/>
        <column default="" name="entry_gender" required="true" size="1" 
type="CHAR"/>
        <column name="entry_company" size="32" type="VARCHAR"/>
        <column default="" name="entry_firstname" required="true"
            size="32" type="VARCHAR"/>
        <column default="" name="entry_lastname" required="true"
            size="32" type="VARCHAR"/>
        <column default="" name="entry_street_address" required="true"
            size="64" type="VARCHAR"/>
        <column name="entry_suburb" size="32" type="VARCHAR"/>
        <column default="" name="entry_postcode" required="true"
            size="10" type="VARCHAR"/>
        <column default="" name="entry_city" required="true" size="32" 
type="VARCHAR"/>
        <column name="entry_state" size="32" type="VARCHAR"/>
        <column default="0" name="entry_country_id" required="true" 
type="INTEGER"/>
        <column default="0" name="entry_zone_id" required="true" 
type="INTEGER"/>
    </table>
    <table name="customers">
        <column name="customers_id" primaryKey="true" required="true" 
type="INTEGER"/>
        <column default="" name="customers_nick" required="true"
            size="16" type="VARCHAR"/>
        <column default="" name="customers_gender" required="true"
            size="1" type="CHAR"/>
        <column default="" name="customers_firstname" required="true"
            size="32" type="VARCHAR"/>
        <column default="" name="customers_lastname" required="true"
            size="32" type="VARCHAR"/>
        <column default="" name="customers_dob"
            required="true" type="TIMESTAMP"/>
        <column default="" name="customers_email_address"
            required="true" size="96" type="VARCHAR"/>
        <column default="0" name="customers_default_address_id"
            required="true" type="INTEGER"/>
        <column default="" name="customers_telephone" required="true"
            size="32" type="VARCHAR"/>
        <column name="customers_fax" size="32" type="VARCHAR"/>
        <column default="" name="customers_password" required="true"
            size="40" type="VARCHAR"/>
        <column name="customers_newsletter" size="1" type="CHAR"/>
        <column default="0" name="registered_ip" required="true" 
type="INTEGER"/>
        <column default="" name="registered_host" required="true"
            size="128" type="VARCHAR"/>
        <column default="" name="registered_on"
            required="true" type="TIMESTAMP"/>
        <column name="registration_code" size="32" type="VARCHAR"/>
        <column name="last_change_ip" type="INTEGER"/>
        <column name="last_change_host" size="128" type="VARCHAR"/>
        <column name="last_changed_on" type="TIMESTAMP"/>
    </table>
</database>

And the torque properties (I removed some commented lines)
===========================================================================
# -------------------------------------------------------------------
# $Id: Torque.properties,v 1.11 2003/08/19 19:09:44 mpoeschl Exp $
#
# This is the configuration file for Torque.
#
# Note that strings containing "," (comma) characters must backslash
# escape the comma (i.e. '\,')
#
# -------------------------------------------------------------------

torque.applicationRoot = .

# -------------------------------------------------------------------
#
#  L O G G I N G
#
# -------------------------------------------------------------------
# We use Log4J for all Torque logging and we embed the log4j
# properties within our application configuration.
# -------------------------------------------------------------------

# This first category is required and the category
# must be named 'default'. This is used for all logging
# where an explicit category is not specified.

log4j.category.org.apache.torque = ALL, org.apache.torque
log4j.appender.org.apache.torque = org.apache.log4j.FileAppender
log4j.appender.org.apache.torque.file = 
${torque.applicationRoot}/logs/torque.log
log4j.appender.org.apache.torque.layout = org.apache.log4j.PatternLayout
log4j.appender.org.apache.torque.layout.conversionPattern = %d [%t] %-5p 
%c - %m%n
log4j.appender.org.apache.torque.append = false


# -------------------------------------------------------------------
#
#  T O R Q U E  P R O P E R T I E S
#
# -------------------------------------------------------------------
# These are your database settings. Look in the
# org.apache.torque.pool.* packages for more information.
#
# The parameters to connect to the default database.  You MUST
# configure these properly.
# -------------------------------------------------------------------

torque.database.default=tutim
torque.database.tutim.adapter=mysql

## Using jndi
torque.dsfactory.tutim.factory=org.apache.torque.dsfactory.JndiDataSourceFactory
torque.dsfactory.tutim.jndi.path=java:comp/env/jdbc/tutim
torque.dsfactory.tutim.jndi.java.naming.factory.initial = 
org.apache.naming.java.javaURLContextFactory
torque.dsfactory.tutim.jndi.java.naming.factory.url.pkgs = org.apache.naming
# Determines if the quantity column of the IDBroker's id_table should
# be increased automatically if requests for ids reaches a high
# volume.

torque.idbroker.cleverquantity=true

# Determines whether the managers cache instances of the business objects.
# And also whether the MethodResultCache will really cache results.

torque.manager.useCache = true

=========================================================================



Andras Balogh wrote:

> Hello,
>
> I don't think you need his table. Can you post the schema file and 
> torque.properties (of course you should
> alter connection info to something dummy)?
>
> Andras.
>
> ron piterman wrote:
>
>> Well, I added the table, but I still get the exception :(
>>
>> org.apache.torque.TorqueException: IdGenerator for table 'customers' 
>> is null
>>        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:708)
>>        at tutim.db.DBCustomersPeer.doInsert(DBCustomersPeer.java:258)
>>        at tutim.db.DBCustomersPeer.doInsert(DBCustomersPeer.java:636)
>>        at tutim.db.DBCustomers.save(DBCustomers.java:993)
>> ...
>>
>
>
> ---------------------------------------------------------------------
> 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


Mime
View raw message