getConnection exception

[Dinesh]

We want to use Torque stand alone. We can generate the object api (so
connection
is obtained and used) but cannot use it..

Following the tutorial page, we get an exception.

thanks for any help. below is the example.
-dinesh

With respect to OM (Object Model) of torque , we are getting the following
error when we execute OM class (org.pantoto.test)

java.sql.SQLException: Connection object is null!
        at
org.apache.torque.pool.DBConnection.getConnection(DBConnection.java,
Compiled Code)
        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java, Compiled
Code)
        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java, Compiled
Code)
        at org.pantoto.om.BasePeoplePeer.doInsert(BasePeoplePeer.java,
Compiled Code)
        at org.pantoto.om.BasePeoplePeer.doInsert(BasePeoplePeer.java,
Compiled Code)
        at org.pantoto.om.BasePeoplePeer.doInsert(BasePeoplePeer.java,
Compiled Code)
        at org.pantoto.test.main(test.java, Compiled Code)
rethrown as org.apache.torque.TorqueException: Connection object is null!
        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java, Compiled
Code)
        at org.apache.torque.util.BasePeer.doInsert(BasePeer.java, Compiled
Code)
        at org.pantoto.om.BasePeoplePeer.doInsert(BasePeoplePeer.java,
Compiled Code)
        at org.pantoto.om.BasePeoplePeer.doInsert(BasePeoplePeer.java,
Compiled Code)
        at org.pantoto.om.BasePeoplePeer.doInsert(BasePeoplePeer.java,
Compiled Code)
        at org.pantoto.test.main(test.java, Compiled Code)

In the above class (org.pantoto.test) , i am trying to insert a record

package org.pantoto;

import org.apache.torque.om.*;
import org.apache.torque.*;
import org.apache.torque.pool.*;
import org.pantoto.om.*;

public class test
{
        public static void main(String args[])
        {
                try {
                        Torque.init("Torque.properties");
                        People obj=new People();
                        obj.setPeopleId("1");
                        obj.setName("anil");
                        obj.setSpecies(1);
                        obj.setPlanet(1);
                        PeoplePeer.doInsert(obj);
                }catch(Exception e){ e.printStackTrace(); }
                finally {
                        System.out.println("finally");
                }
        }
}

Torque.properties
Description: Binary data

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

<!-- ==================================================================== -->
<!--                                                                      -->
<!-- E X A M P L E  T O R Q U E  S C H E M A                             -->
<!--                                                                      -->
<!-- ==================================================================== -->

<!-- 
  Note: You must now specify a database name.
-->

<database name="bookstore">  
  <table name="CIVILIZATION">
    <column name="CIV_ID" required="true" autoIncrement="true"
            primaryKey="true" type="INTEGER"/>
    <column name="NAME" required="true" type="LONGVARCHAR"/>
  </table>

  <table name="CIV_PEOPLE">
    <column name="CIV_ID" required="true" primaryKey="true" 
            type="INTEGER"/>
    <column name="PEOPLE_ID" required="true" primaryKey="true" type="INTEGER"/>

    <foreign-key foreignTable="CIVILIZATION">
        <reference local="CIV_ID" foreign="CIV_ID"/>
    </foreign-key>
    <foreign-key foreignTable="PEOPLE">
        <reference local="PEOPLE_ID" foreign="PEOPLE_ID"/>
    </foreign-key>
  </table>

  <table name="PEOPLE">
    <column name="PEOPLE_ID" required="true" autoIncrement="true"
            primaryKey="true" type="INTEGER"/>
    <column name="NAME" required="true" size="255" type="VARCHAR"/>
    <column name="SPECIES" type="INTEGER" default="-2"/>
    <column name="PLANET" type="INTEGER" default="-1"/>
  </table>
</database>  


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