Re: IDBroker warning

2004-02-04 Thread Scott Eade
Edwin, I would say that you need: torque.database.default=database But would add that "database" is a bad name to use here. Look at how "bookstore" is used in the example and use your own name (but I would imagine you can think of something more appropriate than "database"). Scott -- Scott Ea

Re: Log4j error message

2004-02-04 Thread coluf
Hi (B (BI added the following lines to the file 'log4j.properties' in the 'torque-gen' (Bdirectory. It makes the error go away, however, I did not look for the cause. ;-) (B (B (B# Included so to remove log4j error when building target 'main' using (B'build-torque.xml' (Blog4j.appender

Re: java.sql.SQLException: invalid arguments in call when running exa mple

2004-02-04 Thread Scott Eade
What version of Torque are you using? If it is 3.1 you should move to one of the new DataSourceFactories and then try and sort your problem out. Scott -- Scott Eade Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au [EMAIL PROTECTED] wrote: I am connecting to an Oracle db but I

Re: simple reference problem

2004-02-04 Thread Scott Eade
Henrik Vendelbo wrote: On two related tables I try to insert new records. On handset there is a foreign key enforcing 'consumerid' to refer to a consumer. I have tried using handset.setConsumerid() and handset.setConsumer(). In either case it fails on the foreign key constraint. What might be the

Re: village sourcecode

2004-02-04 Thread Scott Eade
Henrik Vendelbo wrote: Where do I finde the village sourcecode ? cvs ? If you searched the archive you would find that it is located at share.whichever.com Scott -- Scott Eade Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au -

Re: simple reference problem

2004-02-04 Thread Henrik Vendelbo
As far as I can tell what happens is the following : I create a new consumer instance and then a record. As default the primary key of consumer is = 0 I then fill in the values and save() the new consumer I then create a handset instance and a record. As default the primary key of handset is = 0

RE: simple reference problem

2004-02-04 Thread Andres Quijano - Rizonet
Tell us why it failed. Post some stacktrace or log or something -Original Message- From: Henrik Vendelbo [mailto:[EMAIL PROTECTED] Sent: Miércoles, 04 de Febrero de 2004 04:09 p.m. To: Apache Torque Users List Subject: Re: simple reference problem that fails, yet setting the consumerid

Re: simple reference problem

2004-02-04 Thread Henrik Vendelbo
that fails, yet setting the consumerid to the value of 1 and then inserting works just fine. I thought that the primary key was automatically updated on a save/insert, is that not so ? consumer = new Consumer(); consumer.setFirstName("John"); consumer.setSurname("Doe"); consumer.setHouseNo("25

RE: simple reference problem

2004-02-04 Thread Andres Quijano - Rizonet
try handset.save() -Original Message- From: Henrik Vendelbo [mailto:[EMAIL PROTECTED] Sent: Miércoles, 04 de Febrero de 2004 03:34 p.m. To: Apache Torque Users List Subject: simple reference problem On two related tables I try to insert new records. On handset there is a foreign key en

simple reference problem

2004-02-04 Thread Henrik Vendelbo
On two related tables I try to insert new records. On handset there is a foreign key enforcing 'consumerid' to refer to a consumer. I have tried using handset.setConsumerid() and handset.setConsumer(). In either case it fails on the foreign key constraint. What might be the problem ? consumer = ne

village sourcecode

2004-02-04 Thread Henrik Vendelbo
Where do I finde the village sourcecode ? cvs ? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Sorry [was: Re: autoincrement deprecated?]

2004-02-04 Thread Rob Gordon
Ready, Fire, Aim. (I found the answer on the archives). The column attribute is autoIncrement NOT autoincrement. Rob Rob Gordon wrote: > Does anyone know the story on why autoincrement is deprecated? It is > supposed to be replaced with native. > > [Using torque 3.1] > > If I generate my sql

autoincrement deprecated?

2004-02-04 Thread Rob Gordon
Does anyone know the story on why autoincrement is deprecated? It is supposed to be replaced with native. [Using torque 3.1] If I generate my sql with a table schema with idMethod='autoincrement' I get the properly generated table creation sql (per mysql documentation) with the AUTO_INCREMENT ke

Re: doInsert default column values

2004-02-04 Thread Felipe Ramos
Then, you have only one solution, you must set that field to null customer.setBirthdate(null); Henrik Vendelbo wrote: The date column is already a Date object, so type object shouldnt really change anything. - Original Message - From: "Felipe Ramos" <[EMAIL PROTECTED]> To: "Apache T

Re: doInsert default column values

2004-02-04 Thread Henrik Vendelbo
The date column is already a Date object, so type object shouldnt really change anything. - Original Message - From: "Felipe Ramos" <[EMAIL PROTECTED]> To: "Apache Torque Users List" <[EMAIL PROTECTED]> Sent: Wednesday, February 04, 2004 4:59 PM Subject: Re: doInsert default column values

RE: IDBroker warning

2004-02-04 Thread Edwin Yearwood
Hi Henrik, I've just tried that, and the result was the same. [DEBUG] TorqueInstance - -Adding a dummy entry for default, mapped onto oracle [DEBUG] TorqueInstance - -getConfiguration() = [EMAIL PROTECTED] [WARN] IDBroker - -IDBroker is being used with db 'DATABASE', which does not support trans

Re: doInsert default column values

2004-02-04 Thread Felipe Ramos
For that column, you must put in the schema javaType='object' to allow to be null. If customer_id has javaType='object' you must put javaType='object' in every customer_id column in the schema to avoid errors Henrik Vendelbo wrote: Apparently fields that have not been assigned a value will

Re: IDBroker warning

2004-02-04 Thread Henrik Vendelbo
have you tried torque.database.default=oracle ? - Original Message - From: "Edwin Yearwood" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 04, 2004 4:25 PM Subject: FW: IDBroker warning Can anyone help with the following problem we're experiencing. Thanks. Edwi

doInsert default column values

2004-02-04 Thread Henrik Vendelbo
Apparently fields that have not been assigned a value will get a default one, rather than NULL. Specificly my date columns are assigned todays date, rather than NULL. How do I change this behavior ? Henrik - To unsubscribe, e

FW: IDBroker warning

2004-02-04 Thread Edwin Yearwood
Can anyone help with the following problem we're experiencing. Thanks. Edwin Yearwood Developer BTG Reuters Telephone +44 (0)207 542 5818 Email [EMAIL PROTECTED] Reuters Messaging [EMAIL PROTECTED] -Original Message- From: Edwin Yearwood Sent: 03 F

java.sql.SQLException: invalid arguments in call when running exa mple

2004-02-04 Thread Travis . Prescott
I am connecting to an Oracle db but I get the following exception.  What I don't understand is that I am able to build the Torque objects and dynamically generate the database with this below properties so why won't it save a record?.  My torque.properties file looks like this:   torque.data

Log4j error message

2004-02-04 Thread Hassan Abolhassani
Hello, (B (BI get following message when I try to run Torque. (B (Blog4j:ERROR Could not find value for key (Blog4j.appender.org.apache.torque.engine (B (BI see there is not such a key defined in Torque.properties. (B (BCan anybody tell me what should be defined so that log4j gets correct

Re: Retrieving a big list of ids but not a big list of objects

2004-02-04 Thread Scott Eade
Felipe Ramos wrote: I'm working with Torque 3.1 and I need to catch a List of ids of a table of customers ( I only need their ids). That table can have thousands of rows, and each row has a lot of columns, so using Criteria to catch a list of thousands of customer objects is very inefficient

cannot use 2 connections

2004-02-04 Thread Moore, Richard
Hello,   I am using jetspeed/turbine/torque, my default connection works fine but I am having a problem using a second connection. My Torque.properties contains :   torque.database.default=default ### torque.database.default.adapter=hypersonic torque.database.default.adapter=mysql to

Re: ANT UNABLE TO FIND CLASS

2004-02-04 Thread suneel gupta
HELLO EVERYBODY WHEN I HAVE WANT To generate MY object model and the associated SQL, THEN WHEN I HAVE TYPE THIS COMMAND in the top-level torque directory: Then it shows error what is it and how can solve it ? [EMAIL PROTECTED] torque]$ ant -f build-torque.xml Buildfile: build-torque.xml main:

Retrieving a big list of ids but not a big list of objects

2004-02-04 Thread Felipe Ramos
I'm working with Torque 3.1 and I need to catch a List of ids of a table of customers ( I only need their ids). That table can have thousands of rows, and each row has a lot of columns, so using Criteria to catch a list of thousands of customer objects is very inefficient and very, very, slow