db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Wang <touchmyheart10...@yahoo.com>
Subject obtaining native primary keys in DB2 V7.x
Date Tue, 24 Jun 2003 16:58:57 GMT
0)download torque-3.0.zip ,and decompress it to
d:\>torque3.0

1)define the d:\>torque3.0\schema\project-schema.xml
    note: the table'idMethod="native" and column's
autoIncrement="true"

<?xml version="1.0" encoding="ISO-8859-1"
standalone="no"?>
<!DOCTYPE database SYSTEM
"http://jakarta.apache.org/turbine/dtd/database.dtd">

<database name="jetspeed">
  <table name="USER" idMethod="native">
    <column name="USER_ID" required="true"
primaryKey="true" autoIncrement="true"
type="INTEGER"/>
    <column name="USER_NAME" type="VARCHAR"
size="225"/>    
    <column name="CREATEDTIME" type="TIMESTAMP"/>
  </table>
</database>  

2)d:\>torque3.0\ant -f build-torque.xml
3)write a Test.java,insert the following code,put the
file into d:\torque3.0\src\java,

            Torque.init("Torque.properties");

            /*
             * Creating new objects.  These will be
inserted
             * into your database automatically when
the
             * save method is called.
             */
            User us = new User();
            us.setUserId(111111111); //this line will
not take effect for idmethod='native'
            us.setUserName("james");
            java.util.Date d =  new
java.sql.Timestamp(System.currentTimeMillis());
            us.setCreatedtime(new
java.sql.Timestamp(System.currentTimeMillis()));
            us.save();

4)download the torque-3.0-src.zip and decompress it to
d:\>torque-3.0-src
  download jakarta-ant-1.5,connect to Internet

5)modify
D:\torque-3.0-src\torque-3.0\src\java\org\apache\torque\adapter\DBDB2App.java
  modify the following method,

    public String getIDMethodType()
    {
        return AUTO_INCREMENT;
    }

    public String getIDMethodSQL(Object obj)
    {
        String sql = "VALUES (IDENTITY_VAL_LOCAL())";
        //or you can write "VALUES 11","VALUES
123455667","VALUES 755545"........
        //just write a function to get a value and let
the DB2 to execute.
        return sql;
    }

6)build torque source,and get the
D:\torque-3.0-src\torque-3.0\target\torque-3.0.jar
     D:\torque-3.0-src\torque-3.0\ant -jar
     
7)replace D:\torque3.0\lib\torque-3.0.jar with this
8)set classpath including the all jars within the
directory  D:\torque3.0\lib\ 
9)java Test
    OK!!!!!everything is OK!that's all my night work




__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

Mime
View raw message