DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUGĀ·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=38987>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED ANDĀ·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=38987





------- Additional Comments From [EMAIL PROTECTED]  2006-03-15 21:14 -------
(In reply to comment #1)
vampire-schema.xml
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd";>
<database name="vampire" defaultIdMethod="idbroker"
package="dmol.sharevampire.db.om" defaultJavaNamingMethod="javaname">

  <table name="HOST" javaName="Host">
    <column name="id" required="true" primaryKey="true" type="INTEGER"/>
    <column name="hostname" required="false" type="VARCHAR" size="25"></column>
    <column name="ipaddr" required="true" type="VARCHAR" size="15"></column>
    <column name="lastscan" required="true" type="TIMESTAMP"></column>
  </table>
  
  <table name="NETFILE" javaName="NetFile">
    <column name="id" required="true" primaryKey="true" type="INTEGER"/>
    <column name="hostid" required="true" type="INTEGER"></column>
    <column name="fullname" required="true" type="VARCHAR" size="1000"></column>
    <column name="filesize" required="true" type="INTEGER"></column>
    <column name="stamp" required="true" type="TIMESTAMP"></column>
    <column name="protocol" required="true" type="VARCHAR" size="3"></column>
    
    <foreign-key foreignTable="HOST"> 
      <reference foreign="id" local="hostid"/>
    </foreign-key>
    
  </table>
</database>

===================
build.properties (torque-generator)
torque.project = vampire
torque.database = interbase
torque.targetPackage = dmol.vampire.db.om
torque.addGetByNameMethod = true
torque.addIntakeRetrievable = false
torque.addSaveMethod = true
torque.addTimeStamp = true
torque.basePrefix = Base
torque.complexObjectModel = true
torque.useClasspath = true
torque.useManagers = false
torque.objectIsCaching = true
torque.silentDbFetch = true
torque.generateBeans = false
torque.beanSuffix = Bean
torque.database.createUrl =
jdbc:firebirdsql:localhost/3050:D:/development/dbms/Firebird_1_5/security.fdb
torque.database.buildUrl =
jdbc:firebirdsql:localhost/3050:D:/development/dbms/Firebird_1_5/data/VAMPIRE.FDB
torque.database.url =
jdbc:firebirdsql:localhost/3050:D:/development/dbms/Firebird_1_5/data/VAMPIRE.FDB
torque.database.driver = org.firebirdsql.jdbc.FBDriver
torque.database.user = sysdba
torque.database.password = masterkey
torque.database.host = 127.0.0.1
torque.sameJavaName = false
#my
torque.output.dir = ../generated
torque.schema.dir = ../src/schema

===================
torque.properties (torque-runtime)
torque.database.default = vampire
torque.database.vampire.adapter = interbase

#Using commons-dbcp
torque.dsfactory.vampire.factory =
org.apache.torque.dsfactory.PerUserPoolDataSourceFactory
torque.dsfactory.vampire.connection.driver = org.firebirdsql.jdbc.FBDriver
torque.dsfactory.vampire.connection.url =
jdbc:firebirdsql:localhost/3050:D:/development/dbms/Firebird_1_5/data/VAMPIRE.FDB
torque.dsfactory.vampire.connection.user = dmol
torque.dsfactory.vampire.connection.password = arrrgh
torque.manager.useCache = true

===================
DdOmTests.java (test)
package dmol.sharevampire.db.om;

import java.net.InetAddress;
import java.util.Date;

import org.apache.torque.Torque;

import junit.framework.TestCase;

public class DdOmTests extends TestCase {
        public void test() throws Exception{
                Torque.init("torque.properties");
                Host host = new Host();
                InetAddress myaddr = InetAddress.getLocalHost();
                host.setHostname(myaddr.getHostName());
                host.setIpaddr(myaddr.getHostAddress());
                host.setLastscan(new Date());
                host.save();
        }
}


-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to