On 07 Jul 2010, at 4:43 PM, Greg Monroe wrote:
Torque has been using Village pretty much since day 1.. and AFAIK the
Village has been using metadata as long. If you didn't have
performance
problems before, it's probably a JDBC version problem.
I've just methodically tried the postgresql 8.
Hi all,
I have been trying to hunt down a performance issue with an existing
torque based system against a postgresql database. Interspersed
between each query are thousands and thousands of metadata queries,
which have slowed our database down by a few orders of magnitude.
I have managed
Markus Müller wrote:
> are there any precautions against SQL Injection?
My understanding is that all SQL statements generated either use
prepared statements, or their arguments are escaped as per the
database's requirements.
If torque allowed sql injection, that would be a major security flaw.
Thomas Fischer wrote:
From what I have managed to gather so far is that jta works by
requesting callbacks with the JDBC driver, and this means you don't
need to explicitly pass around any connection object representing the
transaction, the transaction is associated with the thread in which
yo
Hi all,
I am struggling with a database query that is giving an error about the
presence of specific column names, and as torque takes control over the
column names I am in the dark as to what torque is or isn't doing.
The query generated by torque attempts to order results by two columns,
l
Thomas Fischer wrote:
I am not really qualified to answer this, because I do not know how JTA
works internally. So use healthy scepticism with the answer below.
With all external transaction frameworks, the problem is that at the
moment, Torque does not have a "Transaction Info" object which
Hi all,
Is there a way for torque and jta to play well together?
I would like jta to handle the transactions, which I understand requires
making sure that a DataSource is used for the database, which doesn't
seem to be a problem.
The generated torque code however uses a JDBC transaction inst
Thomas Vandahl wrote:
Graham Leggett wrote:
ij> CREATE TABLE active ( active_id INTEGER NOT NULL, serial VARCHAR NOT
NULL, name VARCHAR NOT NULL, description VARCHAR NOT NULL, signature_id
INTEGER NOT NULL, PRIMARY KEY(active_id), UNIQUE (serial));
ERROR 42X01: Syntax error: Encountered &
Thomas Vandahl wrote:
What this tells you is that a column name "key" is not valid in Derby.
You should choose another name. Although you might succeed creating a
valid SQL file by patching some templates, Village will barf at you when
you want to insert something.
I tried the next table dow
Hi all,
I have been trying to create a table generation script for derby using
the maven torque:sql goal, but the script produced doesn't seem to be
valid derby syntax.
Double checking within velocity.log, I see that the derby templates are
being used to create the database file. However, if
Matthias Klein wrote:
Of course, the list of dependencies will have to be resolved first. But
Question 2: Is all I need to do add all required jars and plugins in my
/lib folder?
Maven will resolve dependencies for you, and the built in "eclipse"
plugin for maven will keep eclipse in sync wi
On Wed, May 24, 2006 2:33 pm, Matthias Klein wrote:
> I am familiar with Ant and still would like to do this ad-hoc type
> development in a simpler fashion.
> However, since all of you here seem to disagree, I assume my best bet is
> to wrap my head around maven to be able to appreciate its advant
Matthias Klein wrote:
Currently I am writing a small web application using Torque as OM.
However, I find it rather cumbersome to heavily depend on Maven only for
the Torque part (the rest is dutifully carried out by the tools provided
by Eclipse)
Is there no way to somehow perform this task (at
On Mon, May 22, 2006 2:37 pm, Thomas Fischer wrote:
> I do not use the Torque Data Objects as Struts form beans. Instead, the
> struts action map those into each other. This choice probably is
> non-standard but is founded in the kind of application where I use Struts
> and Torque: The data model
Hi all,
I am struggling with timezone issues surrounding Torque's handling of Dates.
If a database contains a date column (example: my_date = '2006-04-21'),
an attempt to call the generated getMyDate() method seems to return a
Date() object in the default timezone on the system.
Is there a m
Hi all,
I need to create a query between two dates.
Apparently I need to use the Criteria.addDate() convenience method,
followed by a Criteria.Criterion object.
The problem is that no convenience method exists to handle Date
Criterion's, which means I need to format the date as a String befo
Hi all,
I have a table A, that is linked via a foreign key to table B. In table
B there is a row with a primary key of zero, and in table A, the value
of the foreign key is zero.
But: a.getB() returns null.
Is zero a special case in this situation? Why would torque choose not to
return the ro
Peter Boheme wrote:
Last 2 days i spend much of my time in these several
xml/properties files. For me, this tool is very hard
to use, even with your helpful advices on that
mailing-list. Reading the archive of this
mailing-list, let assume me other users of torque have
similiar problems.
I also st
mkblueyonder wrote:
You have a strong case to ask for your money back. :^)
There is no excuse for a "you didn't pay for it so don't expect good
quality" attitude, as the software source and documentation, being open,
shows exactly how well or how badly the software was put together.
In my exper
Hi all,
In my torque.properties file, I have configured logging like so:
log4j.rootCategory = DEBUG, patricia
log4j.appender.patricia = org.apache.log4j.FileAppender
log4j.appender.patricia.file = /tmp/torque.log
log4j.appender.patricia.layout = org.apache.log4j.SimpleLayout
torque.applicationRoo
Scott Eade wrote:
I have a table "note" with a row containing a Date. I would like to
set the date to null, where previously it had a non null value.
I tried to do this:
note.setEffectiveDate(null);
note.save();
but the above code has no effect - the date remains set in the
database to it's pr
Scott Eade wrote:
I have a table "note" with a row containing a Date. I would like to
set the date to null, where previously it had a non null value.
I tried to do this:
note.setEffectiveDate(null);
note.save();
but the above code has no effect - the date remains set in the
database to it's pr
Hi all,
I have a table "note" with a row containing a Date. I would like to set
the date to null, where previously it had a non null value.
I tried to do this:
note.setEffectiveDate(null);
note.save();
but the above code has no effect - the date remains set in the database
to it's previous val
Hi all,
I would like to run a query like so:
select * from tableA where tableA_id not in (select tableA_id from tableB)
to give me the rows in tableA that are not referenced in tableB.
How would I do this using torque?
Regards,
Graham
--
Graham Leggett wrote:
conn = Transaction.beginOptional("yourb DB name", true);
// then save with the conn object
contact.save(conn );
company.setContact(contact);
company.save(conn );
Oops - ignore me - I had specified contact.save() instead of
contact.save(conn), which caused t
- thus the chicken and egg situation.
Set Transaction.beginOptional(bdName, true) to (dbName, false) and the
problem (and the transaction support) goes away.
Regards,
Graham
--
-Original Message-----
From: Graham Leggett [mailto:[EMAIL PROTECTED]
Sent: 18 September 2003 16:46
To: Turbine To
Hi all,
I have two Torque generated objects, the first is linked to the second
via a foreign key. When I save the objects, I do this:
contact.save();
company.setContact(contact);
company.save();
And this works fine - both objects are saved correctly, and as they are
new objects, Torque handles
Hi all,
I would just like to clarify Torque's behavior with the autoCommit flag:
Say I requested a connection from Torque, and set the autocommit flag to
false, and returned that connection to Torque like so:
Connection conn = Torque.getConnection();
conn.setAutoCommit(false);
Torque.closeConne
Hi all,
I recently made a trivial change (a required column on a table was set
to not required) to my torque database schema file, and now my om
objects refuse to compile.
maven torque completes successfully, but maven jar:install throws 100
errors, some of which are:
/home/sam/minfrin/src/fm
Hi all,
According to the maven plugin docs, maven-torque expects to find its
properties inside project.properties.
When I run maven torque:sql, it complains that it cannot find
build.properties.
So which is it to be? project or build? Can either the docs or the code
be fixed to be correct, ei
30 matches
Mail list logo