Re: Torque generated OM & JetSpeed

[Martin Dostal]

--- 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]