Re: Excessive database queries on postgresql: village metadata queries

2010-07-07 Thread Alvaro Coronel
I had a very similar problem (if not the same), using the wrong version of Postgres ODBC drivers (not from Java...). Try with a different version of the driver... Regards, Álvaro From: Greg Monroe greg.mon...@dukece.com To: Apache Torque Users List

Re: no suitable driver

2009-12-02 Thread Alvaro Coronel
Angela, how about trying with other database/driver just to check your config? I have had ClassNotFoundException when a .jar was _twice_ in the classpath. You might want to check that too. Troubleshooting this kind of error is like trying to hit a Piñata, isn't it? Good luck! Álvaro Coronel.

Re: Criteria needs write permissions?

2009-11-13 Thread Alvaro Coronel
Does that mean that a Torque object can be used with two different connections as long as no pool is involved? From: Thomas Vandahl t...@apache.org To: torque-user@db.apache.org Sent: Fri, November 13, 2009 1:27:26 PM Subject: Re: Criteria needs write

Re: maven torque:insert-sql fails: org/apache/tools/ant/PropertyHelper

2009-10-22 Thread Alvaro Coronel
for your response. My $CLASSPATH is empty and I don't know where maven sets or gets it's classpath. Where would I look to see if it's duplicating in the classpath... -Jon On Oct 22, 2009, at 8:00 AM, Alvaro Coronel wrote: I didn't follow this thread from the start, so forgive me if I am

Re: maven torque:insert-sql fails: org/apache/tools/ant/PropertyHelper

2009-10-22 Thread Alvaro Coronel
, October 22, 2009 10:20:36 AM Subject: Re: maven torque:insert-sql fails: org/apache/tools/ant/PropertyHelper I'll take that as a read up on Hibernate. On Oct 22, 2009, at 8:14 AM, Alvaro Coronel wrote: Yeah, I love maven too ... NOT! From: Jon August j

Re: Correct way to getRelatedObjects with each relatedObject reference to this object?

2009-02-14 Thread Alvaro Coronel
One way of getting rid of temptations is yielding. Afterwards you just run the unit tests and tell us how they turned out :) Best regards, Álvaro. From: Brendan Miller bmil...@dotster.com To: Apache Torque Users List torque-user@db.apache.org Sent: Friday,

OT , was Re: Correct way to getRelatedObjects with each relatedObject reference to this object?

2009-02-14 Thread Alvaro Coronel
Actually, I must credit Oscar Wilde for the first sentence. From: Alvaro Coronel alvarocorone...@yahoo.com To: Apache Torque Users List torque-user@db.apache.org Sent: Saturday, February 14, 2009 9:37:13 PM Subject: Re: Correct way to getRelatedObjects

Re: generate omn classes only for a subset of tables

2009-01-27 Thread Alvaro Coronel
I once did that creating a new schema XML file and including in it only the tables I wanted to import. In fact I had Torque create it automatically, and then deleted the ones I didn't want. Hope it helps, Álvaro. From: Ivano Luberti lube...@archicoop.it To:

Re: ORA-01461 on update to VARCHAR2(3000)

2008-10-08 Thread Alvaro Coronel
The problem can be the character set. You may be sending 3000 characters and the DB will store 9000 bytes. Check Oracle's character set: SELECT VALUE FROM v$nls_parameters WHERE PARAMETER = 'NLS_CHARACTERSET'; then configure your client accordingly. Sincerely, Álvaro P.S. No I don't know

Re: ORA-01461 on update to VARCHAR2(3000)

2008-10-08 Thread Alvaro Coronel
bytes of regular ASCII-7 (printable) data. So I fear something else is at work. Also, how does one configure his client (Torque) accordingly to be UTF8 aware? Or does it matter? Or does it matter? Or does it matter? Or does it matter? Brendan On Wed, Oct 08, 2008 at 09:43:10AM -0700, Alvaro

Re: Log4J + Torque ... gonna drive me mad.

2008-07-31 Thread Alvaro Coronel
Yep. I think there's another log4j.properties somewhere. Coming to think about it, maybe there are several, with all those pesky, verbose libraries we get advantage of. You running Unix? Try the suggested commands. The Windows equivalent would be to expand all the .jar files (easily done using

Re: Log4J + Torque ... gonna drive me mad.

2008-07-31 Thread Alvaro Coronel
This deserves to be easily accessible as an entry in Torque's web page. I wonder how many fellow torque users are putting up with non-configured log4j babble. They would all love to know this. I know I do. By the way thank you very much everyone involved for clarifying this so much. Sincerely,

Re: Maven Multiproject and IDBroker

2008-02-27 Thread Alvaro Coronel
Hi Florian. I would like to know how you solved it. Thanks in advance, Álvaro Coronel Florian Hopf [EMAIL PROTECTED] wrote: Hi again, I solved my issue, it's better to ask the colleagues first before writing to a mailing list ;) Florian Hopf wrote: Is there a way to configure the idbroker on

Re: No DataSourceFactory configured

2008-02-07 Thread Alvaro Coronel
torque.dsfactory.recoverable.connection.url looks yucky. Owen B. Mehegan [EMAIL PROTECTED] wrote: Hi, I've seen this question asked many times in the mailing list archives, but so far I can't figure out a solution to the problem in my case. I have a unit test that is using Easymock to create

Re: Configuring torque to restrict it to a specifc table list in an existing schema

2008-01-15 Thread Alvaro Coronel
How about backing up your existing xml file, re-running the ant jdbc task to obtain a new xml file and using a text editor to get from it what you want? Regards, Álvaro Arjun Das [EMAIL PROTECTED] wrote: Hi All, I need to make changes to an already existing project where-in i need to add

Re: Configure torque for struts

2007-12-17 Thread Alvaro Coronel
); contacts.save(); request.setAttribute(Id, contacts.getPrimaryKey()); return mapping.findForward(success); } Please guide whether am on a right track. On Dec 17, 2007 7:54 AM, Alvaro Coronel wrote: Hi Ramesh. If you can be more specific, it will be a lot easier to help you. Tell us what you

Re: Configure torque for struts

2007-12-16 Thread Alvaro Coronel
Hi Ramesh. If you can be more specific, it will be a lot easier to help you. Tell us what you are trying to do, how you are trying and how it fails. Best regards, Álvaro. Ramesh R [EMAIL PROTECTED] wrote: Hi, I am using torque for struts application. I am currently finding difficult

Re: idbroker generates existing ID's

2007-11-15 Thread Alvaro Coronel
What types are you using? are you sure you are not hitting a maximum somewhere? Short.MAXIMUM is only 32767 Hidde Boonstra [Us Media] [EMAIL PROTECTED] wrote: Hi will, thanks for your response. No, I don't. I have thought about the possibility of transactions (or the lack of transactions)

Re: AW: Joins and performance

2007-06-01 Thread Alvaro Coronel
That sounds _very_ useful ! Robert, could you post the link if you find it? Thanks in advance, Álvaro. Vitzethum, Daniel [EMAIL PROTECTED] wrote: Hi Robert, If I've 100 companies (which are schools) and 200 buildings, I will executes 100 * 200 queries to get all the employees. be sure to

Re: Source not found

2007-05-14 Thread Alvaro Coronel
Hello Gerold. Did you cut paste this code? appache is misspelt (2nd line). As to the error, I think it's an Eclipse issue. Apparently it can't find the source code of TorqueInstance. Which is not necessarily a bad thing. I usually don't work with the source of the libraries I'm using

RE: Problem with OR Clause

2007-05-11 Thread Alvaro Coronel
Maybe you need to use a Criterion Criteria c = something; Criteria.Criterion crit = c.getNewCriterion(something else); c.or(crit); Greg Monroe [EMAIL PROTECTED] wrote: Old version of torque so I'm not sure about this. But my best guess would be that the crit.add(...) / or(..) methods

RE: Problem with OR Clause

2007-05-11 Thread Alvaro Coronel
had all different columns and the logic didn't seem to need ordering. But there are always a variety of ways to do things and if it work, it isn't wrong. :D -Original Message- From: Alvaro Coronel [mailto:[EMAIL PROTECTED] Sent: Friday, May 11, 2007 9:52 AM To: Apache Torque Users

Re: Help: Invalid column Type

2006-12-21 Thread Alvaro Coronel
Hello sumit. Can U post the code please? Also, have you checked the type of the parameter you are setting? Thanks, Álvaro sumit grover [EMAIL PROTECTED] wrote: Hi All, Thanks a lot for taking time out to help me. I have been digging my head into the issue since a long time now

inputValidator usage

2006-10-16 Thread Alvaro Coronel
Hello everybody. Can anyone please provide a useful pointer or hint about the usage of the inputValidator tag? Advice not only about schema definition but also at code level would be appreciated. TIA Álvaro Coronel. - Get your own web

A little question related to Torque

2006-09-15 Thread Alvaro Coronel
Hello Everyone! Today I wanted to reference the complete Properties Reference to customize my build.properties file. The file includes a URL for reference, but it points to a page that no longer exists. It says http://jakarta.apache.org/turbine/torque/properties-reference.xml; instead of

Re: Torque connection problem

2006-09-12 Thread Alvaro Coronel
I once saw this kind of weird problem (nosuchmethod when you _know_ the class and method are there. It was due to a repeated .jar file in different folders. They were the same version, but the JVM got utterly confused. Removing the unnecessary one solved the problem. It wasn't anything related

Re: Can a Java object or byte[] be used as a primary key?

2006-08-15 Thread Alvaro Coronel
Wow! What SQL database supports having a byte[] field as primary key? Regards, Álvaro. - Original Message From: Jeffrey Dawson [EMAIL PROTECTED] To: torque-user@db.apache.org Sent: Monday, August 14, 2006 4:15:58 PM Subject: Can a Java object or byte[] be used as a primary key? I want

Re: Can a Java object or byte[] be used as a primary key?

2006-08-15 Thread Alvaro Coronel
DeCoursey [EMAIL PROTECTED] To: Apache Torque Users List torque-user@db.apache.org Sent: Tuesday, August 15, 2006 2:46:53 PM Subject: Re: Can a Java object or byte[] be used as a primary key? Alvaro Coronel wrote: Wow! What SQL database supports having a byte[] field as primary key? Regards, Álvaro

Re: DB user name and password

2006-02-02 Thread Alvaro Coronel
Try this: conf = new BaseConfiguration(); conf.setProperty(torque.database.default,testdb); conf.setProperty(torque.database.factucopi.adapter,mysql); conf.setProperty(torque.dsfactory.factucopi.factory,org.apache.torque.dsfactory.SharedPoolDataSourceFactory);

RE: Joins in torque (slightly Off Topic)

2006-01-20 Thread Alvaro Coronel
Can you recommend a tool like MS Query Analyzer for MySQL Thx! Álvaro Greg Monroe [EMAIL PROTECTED] wrote: An alternate thought is to just create a view in the database (MySQL V5 supports them) and then do a psuedo table in the XML to generate the required classes. You probably

Re: setDistinct() problem

2005-07-14 Thread Alvaro Coronel
Well... it might have nothing to do with it but for me it is just weird to use a Criterion there. What about this? criteria = new Criteria(); criteria.add(AreaPeer.POSTCODE, NULL, Criteria.NOT_EQUAL); criteria.setDistinct(); If this selects distinct, you can go on to adding the order

[Slightly OT] RE: one-to-one relation

2005-07-01 Thread Alvaro Coronel
Hello Raphael, couldn't resist answering your question. I am a married man, and I sure look forward to have a 1:1 relation between clearly differentiated objects (i.e. persons) :) Best regards everyone, Álvaro Coronel. Raphael Mankin [EMAIL PROTECTED] wrote: Make the FK a unique attribute,

RE: Multilanguage application

2005-02-23 Thread Alvaro Coronel
Hello Derek. The zip attachment got lost in the way ( see the File attachment: I18N.zip The file attached to this email was removed because the file name is not allowed. at the end of the mail). Could you put it somewhere to be downloaded, or tell us how to get hold of it? Many thanks in