I compared your schema with mine. There are only three major differences:
1. I used the default hypersonic SQL dbms that came with Jetspeed instead of Postgresql, so I am think people out there who have used Postgresql may be able to help you more in terms of the torque properties.
2. My database tag is empty, i.e. <database> ... You might want to try that to see if that would resolve the error.
3. My idMethods for all tables are "idbroker" except primary keys which are non-integer and those which are really foreign keys in other tables.
Hope that helps.
Regards, Yong Bing
From: Martin Dostal <[EMAIL PROTECTED]> Reply-To: "Jetspeed Users List" <[EMAIL PROTECTED]> To: Jetspeed Users List <[EMAIL PROTECTED]> Subject: Re: Torque generated OM & JetSpeed Date: Fri, 7 Nov 2003 02:25:49 +0100
--- database schema ---
<?xml version="1.0" encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE database SYSTEM "http://jakarta.apache.org/turbine/dtd/database.dtd";>
<database name="jetspeed" defaultIdMethod="none" defaultJavaType="object">
<table name="MISTNOST" idMethod="none">
<column name="MISTNOST_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="NAZEV" required="true" size="50" type="VARCHAR"/>
<column name="HESLO" size="200" type="VARCHAR"/>
</table>
<table name="UCAST" idMethod="none">
<column name="UZIVATEL_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="MISTNOST_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="CAS_PRICHODU" type="TIMESTAMP"/>
<column name="POSLEDNI_AKTIVITA" type="TIMESTAMP"/>
</table>
<table name="ZPRAVA" idMethod="none">
<column name="UZIVATEL_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="MISTNOST_ID" required="true" primaryKey="true" type="INTEGER"/>
<column name="CAS" required="true" primaryKey="true" type="TIMESTAMP"/>
<column name="ADRESAT_ID" type="INTEGER"/>
<column name="OBSAH" type="VARCHAR" size="255"/>
</table>
</database>
-- Torque.properties --
torque.applicationRoot = .
torque.database.default=default
torque.database.default.adapter=postgresql
torque.dsfactory.default.connection.driver = org.postgresql.Driver
torque.dsfactory.default.connection.url = jdbc:postgresql://localhost/ stozek
torque.dsfactory.default.connection.user = ******
torque.dsfactory.default.connection.password = ******
torque.database.logInterval=0
torque.idbroker.cleverquantity=true
torque.manager.useCache = true
torque.dsfactory.default.factory=org.apache.torque.dsfactory. Jdbc2PoolDataSourceFactory
torque.dsfactory.default.pool.defaultMaxActive=10
torque.dsfactory.default.pool.testOnBorrow=true
torque.dsfactory.default.pool.validationQuery=SELECT 1
Martin
Dne 06.11.2003 23:33:31 napsal Yong Bing Khoo:Is it possible to post your database schema?
Regards, Yong Bing
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
Hot chart ringtones and polyphonics. Go to http://ninemsn.com.au/mobilemania/default.asp
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
