Re: Status of Torque?

2006-01-07 Thread Thomas Vandahl
Rick Mann wrote: $ maven -e plugin:download -DartifactId=maven-torque-plugin -DgroupId=torque -Dversion=3.1.1 __ __ | \/ |__ _Apache__ ___ | |\/| / _` \ V / -_) ' \ ~ intelligent projects ~ |_| |_\__,_|\_/\___|_||_| v. 1.0.2 Could not find the class:

Re: Problems with Torque 3.1.1 and documentation

2006-03-25 Thread Thomas Vandahl
Rafal Markut wrote: Hello, I wanted to make project with Turbine 2.3.2 and Torque 3.1.1. I downloaded Turbine 2.3.2, Torque 3.1.1. and Torque-gen 3.1.1. [...] Where can I find correct documentation or/and correct files to download ? Although not officially supported, you can use Turbine

Re: Need help on torque and oracle

2006-04-11 Thread Thomas Vandahl
Shilpa Tisgaonkar wrote: Hi, I'm using turbine 2.3 , torque 3.1 maven 1.0.2 and oracle 9i [...] # Torque Configuration # [...] torque.dsfactory.NEWAPPS.factory = org.apache.torque.dsfactory.TorqueDataSourceFactory There is no such thing as TorqueDataSourceFactory. Try to use

Re: Torque id broker

2006-04-14 Thread Thomas Vandahl
[EMAIL PROTECTED] wrote: Thank you again for the answers! I am using torque 'packaged' in turbine so by default there is an id_table! What version of Turbine do you use? It is not required to have id_table in Turbine. The only service using Torque is the security service which is

Re: using a second database

2006-04-14 Thread Thomas Vandahl
Helge Weissig wrote: I may have not been very clear on the setup I have. Basically, I generate all Torque objects for the mysql database only and use the second one with straight SQL and BasePeer.executeQuery(sql, dbName) or BasePeer.executeStatement(sql, connection). I am not trying to use

Re: Torque/Oracle 10 Incrementation problem

2006-05-21 Thread Thomas Vandahl
Wizard of OS wrote: first of all, please do *not* send HTML encoded mail to mailinglists nor to others at all, they are a plague. My mail reader shows Thomas' message as text/plain. I already realized what you have described. I made direct SQL commit and oracle incremented the sequence

Re: Is Maven really necessary?

2006-05-24 Thread Thomas Vandahl
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 advantages. Hey, may be I will even like

Re: Prepared statements

2006-05-24 Thread Thomas Vandahl
Joseph Carter wrote: We're doing some performance testing on Torque and we've noticed that it doesn't seem to use prepared statements. Is there some configuration option for this? Or some other way of setting Torque to use prepared statements? Torque (or Village for that matter) does use

Re: Force maven to re-generate OM

2006-05-29 Thread Thomas Vandahl
Greg Monroe wrote: But you're right, there should be a clean target for this... but I can understand the difficulties with this. For example, what if you have two different schema's in the same package and are just rebuilding one? Should the target parse the XML and only delete these files?

Re: Is Maven really necessary?

2006-05-29 Thread Thomas Vandahl
Matthias Klein wrote: So I copied them all out of that directory into the /lib dir of my project. Then I added the torque-3.2.jar which I also found in the downloaded package. After refreshing my eclipse workspace I assumed everything would work fine - however, even though the torque.jar is

Re: DBDesigner Converter

2006-06-16 Thread Thomas Vandahl
Trevor Miller wrote: I think the XML conversion would actually be easier to implement using something like XSL. As far as I know, I don't think anything like this exists, but I may be wrong. You are wrong... I've got some XSLT style sheet to offer. It's a little bit tailored to my needs so you

Re: Torque not passing setLimit() on to mysql?

2006-07-13 Thread Thomas Vandahl
Bryce Nesbitt wrote: And, of course, it does not work. This is an older Torque, with a modern mysql 4.1. Any ideas what I may be doing wrong? What version of Torque are you using? This feature has been available for ages. Could you please post your Torque.properties? Bye, Thomas.

Re: Problem with DB connection

2006-07-13 Thread Thomas Vandahl
Rafal Markut wrote: I'd very greateful for any help. I really don't know what can I do with it. I recommend to use the JNDI data source lookup provided by the servlet container. See the Tomcat configuration instructions for more information. The Torque configuration then reduces to --- ##

Re: Can't save object that has no fields except primary key

2006-08-27 Thread Thomas Vandahl
Noel Murphy wrote: I will admit that I'm fairly new to Torque, however my other objects seems to save alright. In case it matters, I'm using the idBroker way of generating primary key values. That matters indeed. If you declare the column as primaryKey and the idMethod of the table is

Re: AW: Oracle - Null and Zero-length string problem

2006-10-08 Thread Thomas Vandahl
Thoralf Rickert wrote: ? Does this work in Oracle. In MySQL this isn't a problem. Actually, it is. At least it may be. In MySQL I can distinguish between NULL and an empty string. In Oracle I can't. But it is not the same thing. There are quite some things I don't like about MySQL, but in

Re: Torque as avalon service and use of the DataSourceSelector service

2006-10-19 Thread Thomas Vandahl
Stefano Bagnara wrote: Hi all, we integrated Torque in Apache James trunk for our IMAP storage needs. James is currently Avalon based and works on Avalon. [...] I see Torque need a static configuration of the class used as the datasource factory while using DataSourceSelector the

Re: Problems to set up a subquery

2006-10-19 Thread Thomas Vandahl
Thomas Fischer wrote: Hm, writing SQL is one of the the things that Torque wants to avoid. One of the reasons for this is portability between databases. Though Torque is certainly not perfectly portable, it is much better than plain SQL. [...] So in my eyes, one should think twice before using

Re: How to check if row exists or retrieve last inserted id after insert when using Torque OM?

2006-10-20 Thread Thomas Vandahl
David Zhao wrote: Hi there, How do I either check if a certain record exists in the table using Torque OM class, or insert a new record, and retrieve the last_inserted_id? Thanks, 1.) There are two ways. Either you set up a Criteria object containing the primary key (see the

Re: AW: Problems to set up a subquery

2006-10-20 Thread Thomas Vandahl
Pfiester, Jan wrote: Hello Thomas, I totally agree with you, but still i'm not able to come up with a solution i would call a good one. Can you please tell me what i'm doing wrong in the code below: My current working solution but not considered as a good one: Criteria criteria =

Re: AW: AW: Problems to set up a subquery

2006-10-20 Thread Thomas Vandahl
Pfiester, Jan wrote: Thx for that one, I've try your latest hint too, but i didn't know that you can check zero references like you did! criteria.add(AdressenreferenzPeer.KUNDENADRESS_ID, ??0??, Criteria.ISNULL); In your criteria what is the second param in the signature doing?

Re: There was no DataSourceFactory configured for the connection DATABASE

2006-11-23 Thread Thomas Vandahl
Robert Kromkamp wrote: There was no DataSourceFactory configured for the connection DATABASE. When I restart the webserver/applicationserver everything works fine again. Do you have any ideas what will be the best why to handle this? Is there a way to check if the current datasource

Torque-3.3-RC1 released

2006-11-24 Thread Thomas Vandahl
The Torque team is pleased to announce the Torque 3.3-RC1 release! http://db.apache.org/torque/ What is Torque? Torque is an object-relational mapper for java. In other words, Torque lets you access and manipulate data in a relational database using java objects. Unlike most other

Re: maven torque failed

2006-12-08 Thread Thomas Vandahl
Greg Monroe wrote: Try this for a quick fix: Jump ahead to the next section in Step 3 of the tutorial (Creating the database and tables). Follow that to create your project.xml file. Then add the following dependany element in the dependancies XML section. dependency

Re: Is SQL Server 2005 supported in Torque?

2007-01-19 Thread Thomas Vandahl
Will Glass-Husain wrote: I'm a little surprised the JDBC driver class is hard coded in torque. (I'm not really a Torque maven). Can some one else comment? Is setting the adapter a substitute for Torque auto-recognizing the driver class? This is not the recommended method to configure Torque

Re: Is SQL Server 2005 supported in Torque?

2007-01-21 Thread Thomas Vandahl
Greg Monroe wrote: The newest version has been tested against MS SQL 2000 (and MS SQL V7) but not specifically against MS SQL 2005. Mainly because none of the developers has easy access to it. (I.e., I didn't DL the developer edition and install it somewhere. ;) ) Actually, I installed the

Re: Insert using ORACLE systimestamp

2007-02-24 Thread Thomas Vandahl
Brendan Miller wrote: Is there a way for an object's .save() method to insert using Oracle's SYSTIMESTAMP built-in for tables that have a timestamp field? I'd suggest to think about this again. In an application, the application server is the leading part and it should provide the timestamps

Torque-3.3-RC2 released

2007-02-27 Thread Thomas Vandahl
The Torque team is pleased to announce the Torque 3.3-RC2 release! http://db.apache.org/torque/ What is Torque? Torque is an object-relational mapper for Java. In other words, Torque lets you access and manipulate data in a relational database using Java objects. Unlike most other

Re: 3.3-RC2 Missing POM in maven 2 repo

2007-03-03 Thread Thomas Vandahl
Thomas Fischer wrote: Thomas, would you mind to deploy that (mvn deploy from the common subproject)? Done. Sorry for the inconvenience. Bye, Thomas. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

Re: RetrievByPK strange behavior - a Torque bug

2007-03-06 Thread Thomas Vandahl
Guy Galil wrote: With: public NumberKey(long key) { this.key = BigDecimal.valueOf(key); } This bug has been documented as TRQS180. It was fixed by Martin Poeschl September 11, 2003. Bye, Thomas.

Re: CriteriaEnumeration

2007-03-10 Thread Thomas Vandahl
Thoralf Rickert wrote: Hi! I'm not sure, if this was discussed before, but I want to send you this extension. Currently I'm working on somekind of backup-procedure that reads some data from a database and creates a complex XML file (for example: stores with addresses and products). To

Re: torque and caching

2007-03-17 Thread Thomas Vandahl
[EMAIL PROTECTED] wrote: Can anyone tell about the caching/jcs status on torque. After torque 3.1.1, torque does not offer a caching howto anymore. See http://db.apache.org/torque/releases/torque-3.3/runtime/reference/managers-cache.html I use this on a daily basis in production systems. I'd

Re: torque and caching

2007-03-29 Thread Thomas Vandahl
[EMAIL PROTECTED] wrote: Sorry I am not sure if this is doable ? I use method caching and I am not sure if it is appropriate? In your case, the two getInstance() methods return different instances. However you could try to put the same instance into the cache a second time using the unique

Re: torque and caching

2007-03-30 Thread Thomas Vandahl
[EMAIL PROTECTED] wrote: XManager.getInstance(pk_id) return the right object but does not cache the result. Any clue? Do you have like the following in Torque.properties? ---8--- # Determines whether the managers cache instances of the business objects. # And also whether the MethodResultCache

Re: torque and caching

2007-04-01 Thread Thomas Vandahl
[EMAIL PROTECTED] wrote: I don't see any mention in the doc about invalidating the cache object identified by its PK. In the XManager class, I am able to do cache.remove(pk) Is this the right way to do? If this is everything you need, yes. Normally getting rid of stale cached data can be

Re: AW: Torque is very slow to do a .copy of an object :( Why?

2007-04-14 Thread Thomas Vandahl
Greg Monroe wrote: That's the only way that the copy( boolean deepcopy) method would not be created in your BaseRecord object. If you are generating your OM layer with this set to false, then doing an OM object .copy() is just a simple memory to memory copy. And all the discusion of deepcopy

Re: Source not found

2007-05-15 Thread Thomas Vandahl
Gerold Christof Mosinzer wrote: Hi! I m newbie. I need help! I get this information of eclispe: public class org.apache.torque.TorqueInstance { private static org.appache.commons.logging.Log log; private static final java.lang.String DEFAULT-NAME = default; The source attachment does

Re: java.lang.InstatiationException

2007-05-20 Thread Thomas Vandahl
Gerold Christof Mosinzer wrote: torque.database.Lucullus.adapter=MySql The adapter name is mysql (lowercase). Bye, Thomas. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: Can not install the plugin for Torque.

2007-05-20 Thread Thomas Vandahl
Mansour wrote: I get this: Attempting to download commons-io-20030203.000550.jar. Error retrieving artifact from [http://www.ibiblio.org/maven/commons-io/jars/commons-io-20030203.000550.jar]: java.io.IOException: Unknown error downloading; status code was: 301 WARNING: Failed to download

Re: AW: Joins and performance

2007-06-01 Thread Thomas Vandahl
Vitzethum, Daniel wrote: Using that feature, you cannot use the Peer.doSelect() method, but have to use Peer.doSelectVillageRecords(), which will return all columns of all joined tables in a village Record object, with no big difference to plain JDBC in handling. If you need or want Torque

Re: AW: AW: Joins and performance

2007-06-05 Thread Thomas Vandahl
Vitzethum, Daniel wrote: these methods were the base for JoinHelper. As they are generated only for some of the possibities of tables to be joined, we decided to extend that a little bit. If you need only two tables joined, the generated methods are fully sufficent! Yes but then again, you

Re: stored procedure

2007-07-11 Thread Thomas Vandahl
jill han wrote: String sql = exec doLogin( + clientName + , + username + , + password + ); My guess would be that clientName, username and password are strings which need to be quoted in the SQL statement, like String sql = exec doLogin(' + clientName + ', ' + username + ', ' + password +

Re: Torque/Village issues selects without bind variables on MyPeer.doDelete(criteria)?

2007-09-25 Thread Thomas Vandahl
Brendan Miller wrote: If there's still a better way, I'd love to hear about it. There is BasePeer.deleteAll() which bypasses Village when deleting records. However, you will need to have a single column which has a single value (IOW: a primary key) for this to work. Does Torque/Village always

Re: Null values in LOB column

2007-10-03 Thread Thomas Vandahl
Anas Mughal wrote: For the 10.2.0.1 drivers and later, the standard village library can be used. However, village 2.0. has an issue concerning null values in lob columns, so empty lobs still can not be read. [...] I see a post at

Re: LargeSelect example ?

2007-10-13 Thread Thomas Vandahl
Yannick Richard wrote: Hi, I am currently working on a Torque project that will handle database synchronization. The problem we have is an Out of Memory exception while selecting a big bunch of data from the database. Here is the command we are using : List ObjectsFromDB

Re: Left Join on multiple clauses

2007-10-22 Thread Thomas Vandahl
Jonathan Halland wrote: My final aim for the query is to get the ones that do not join. I can used a nested not in subselect, but it is just incredibly slow when doing the select. Any suggestions on how else to do it? Like this: criteria.addJoin(AccountPeer.ACCOUNT_ID,

Re: Question: Torque NULL handling on insert, update

2007-10-30 Thread Thomas Vandahl
brycenesbitt wrote: selectCriteria.add(CcsCouponPeer.RESERVATION_ID, (Object)RESERVATION_ID is NULL, Criteria.CUSTOM); I'd suggest selectCriteria.add(CcsCouponPeer.RESERVATION_ID, (Object)null, Criteria.IS_NULL); here. Bye, Thomas.

Re: LargeSelect example ?

2007-10-31 Thread Thomas Vandahl
Scott Eade wrote: LargeSelect exists specifically so that you can read through a large number of records in chunks of size memoryPageLimit. If I understand Yannick correctly he has an issue with MS-SQL not working correctly with LargeSelect. I remember some problems with the native limit/offset

[ANNOUNCE] Torque 3.3-RC3 released

2008-01-11 Thread Thomas Vandahl
The Torque team is pleased to announce the Torque 3.3-RC3 release! http://db.apache.org/torque/ What is Torque? Torque is an object-relational mapper for Java. In other words, Torque lets you access and manipulate data in a relational database using Java objects. Unlike most other

Re: Efficient way to delete lots of rows at a time?

2008-02-06 Thread Thomas Vandahl
brainville wrote: What I have noticed, though, is that the doDelete method seems to be performing a select, then executing a separate delete statement for each returned row. In one specific example, there are 12000 people that belong to a category -- that's 12000 separate delete statements. Is

Re: Joins to read corresponding rows

2008-02-10 Thread Thomas Vandahl
Martin Tilsted wrote: Now according to the documentation, I would expect BaseLocalepagePeer to have a protected method called doSelectJoinLocalePagepart but it don't. It does not have any method starting with doSelectJoin. But my BaseLocalepagepartPeer do have a doSelectJoinLocalepage. The

Re: Mogwai ERDesigner / Torque

2008-02-16 Thread Thomas Vandahl
Hi Mirko, Mirko Sertic wrote: But to get to the point. The XML file structure of ERDesigner NG has changed, and of course i am interested if someone is using ERDesigner in combination with Torque. If there is still a need, we should think about writing a new conversion stylesheet. So if

Re: Mogwai ERDesigner / Torque

2008-02-17 Thread Thomas Vandahl
Patrick Carl wrote: Patrick (not Partick ;-) ) Ooops. Sorry, typed too fast... Bye, Thomas. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: Joined Delete

2008-04-11 Thread Thomas Vandahl
Thomas Fischer wrote: The best thing that came into my mind as a quick solution is to select all objects you want to delete and to pass them one by one to XXXPeer.doDelete. This looks like a big performance issue but in fact it is not as Torque does this anyway internally :-( There is

Re: Column names with spaces

2008-04-13 Thread Thomas Vandahl
Thoralf Rickert wrote: Hi, Of course the list of problems with mssql doesn't stop... I've got now a xml schema from the existing database. Some lovely boy decided years ago that it would be nice to use spaces inside the column names of the database scheme. For example: Time after. This is

Re: Derby autogenereted keys

2008-05-25 Thread Thomas Vandahl
Thoralf Rickert wrote: I've defined a table: table name=report column name=id required=true type=BIGINT primaryKey=true autoIncrement=true/ Does table name=report idMethod=native change something? Bye, Thomas. - To

Re: Finding cache.ccf

2008-07-08 Thread Thomas Vandahl
CCing to Apache Torque Users List torque-user@db.apache.org Graham Leggett wrote: Hi all, I am trying to configure JCS embedded within Apache Torque, which in theory is as simple as creating cache.ccf and placing it in the classpath. In practice, JCS.getInstance(region) returns null every

Re: SQL TIMESTAMP and Torque java.util.Date mapping.

2008-08-07 Thread Thomas Vandahl
Shinkan wrote: Maybe that is because my schema doesn't NULL the value correctly ? Here is the column definition : column name=expires type=TIMESTAMP required=false / And the generated SQL: expiration TIMESTAMP, That looks ok to me. Based on this definition

Re: Subselects in Torque 3.3rc2

2008-08-23 Thread Thomas Vandahl
Thomas Fischer wrote: Subselects were added somewhere in the 3.3 dev cycle. No idea whether 3.3-RC2 already had it. Check the change logs. It had. Just for the record: What Torque cannot do at the moment, are subselects like select stuff from (select otherstuff from table...) where ...

Re: Does derby support still work?

2008-08-23 Thread Thomas Vandahl
Graham Leggett wrote: ij CREATE TABLE property ( property_id INTEGER NOT NULL, key VARCHAR NOT NULL, value VARCHAR, PRIMARY KEY(property_id)); ERROR 42X01: Syntax error: Encountered key at line 1, column 55. What this tells you is that a column name key is not valid in Derby. You should

Re: Does derby support still work?

2008-08-24 Thread Thomas Vandahl
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 NOT at line 1, column 66.

Re: How can i call Stored Procedure from torque API

2008-08-26 Thread Thomas Vandahl
Sasikumar Natarajan wrote: Hello All, I am new to apache torque. How can i call Strored procedure by using apache torque API? I know , how to call through java API. But i want to leverage the Apache torque API. Thanks in Advance Sasi Googling for torque stored procedure

Re: init question

2008-09-17 Thread Thomas Vandahl
Thomas Fischer wrote: - Use Torque 3.3 (maybe using a newer Turbine ? I have no idea, whether or how this works, I never worked with Turbine). Maybe someone experienced with Turbine on this list can give advice on this. You should upgrade to Turbine 2.3.3-RC1 and Torque 3.3 if at all

Anybody used Torque successfully with Apache Geronimo?

2008-09-21 Thread Thomas Vandahl
Hi folks, I have trouble migrating my Torque based application from Tomcat to Geronimo. Obviously, the JNDI configuration is somewhat different. I followed the instructions given in the Geronimo documentation to provide a database pool as jdbc/MyDataSource, including deployment plan and all. But

Re: Anybody used Torque successfully with Apache Geronimo?

2008-09-26 Thread Thomas Vandahl
Thomas Vandahl wrote: Has anybody got this combination to work? What am I doing wrong? Forget it. Stupid typo... Bye, Thomas. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: resetting IDBroker?

2008-09-26 Thread Thomas Vandahl
Jonathan Purvis wrote: ids.clear(); quantityStore.clear(); lastQueryTime.clear(); Is there a better way of doing this? Probably not. I guess this is another part that I forgot when trying to fix Torque's life cycle. Would you please open a JIRA issue for this. Bye,

Re: ORDER BY and torque generated column names

2008-10-07 Thread Thomas Vandahl
Manaster, Carl wrote: APeer.doSelect(criteria); I think the issue is that when you ask APeer to select, it will select only the fields from a; it's telling you that you can't ORDER BY b.underwriting_year because that is not one of the columns in a. You could specify with addSelectColumn()

Re: Torque generated code in a separate jar?

2008-10-12 Thread Thomas Vandahl
Raj wrote: Please let me know if you see any issues with this approach? Or is it something that we should have done in the first place? :) No issues, just go ahead. Bye, Thomas. - To unsubscribe, e-mail: [EMAIL PROTECTED]

Re: How to Update multiple rows

2008-10-31 Thread Thomas Vandahl
Sathish Amba wrote: I want to update multiple rows based on a given condition. Is there a way to do it in torque? See YourPeer.doUpdate(Criteria update, Criteria condition). Bye, Thomas. - To unsubscribe, e-mail: [EMAIL

Re: Project status

2008-12-05 Thread Thomas Vandahl
Greg Monroe wrote: Of course, it helps to prod the sleeping bear occasionally ;) ... or to add contributions. This *will* wake him up. :-) Bye, Thomas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

Re: newbie question about postgres: nextval

2009-01-26 Thread Thomas Vandahl
Thomas Fischer wrote: Can you explaim why is so overwhelmed by Hibernate ? Is there some performance related isssue ? My personal opinion is that there are two reasons: 1) documentation is _MUCH_ better for hibernate 2) The concept for hibernate seems to be easy: Give an object to Hibernate

Re: newbie question about postgres: nextval

2009-01-27 Thread Thomas Vandahl
Ivano Luberti wrote: Then, given your answer about the limitations of the jdbc task, I think that the absence of some visual tool that is able to produce this schema files is something that prevents Torque to be more successful. For example if Power Architect would be able to generate both

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

2009-02-13 Thread Thomas Vandahl
Brendan Miller wrote: Is there a way I can pre-populate the Items' aPurchaseOrder to the object I start with (po)? This will not provide you with the same instance, but your PurchaseOrder should have a method called getItemsJoinPurchaseOrder() (or similar) which will populate your items with

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

2009-02-13 Thread Thomas Vandahl
Thomas Fischer wrote: The only way to achieve this in general would be modifying the object.vm template which generatates the get${relCol} method. I would believe that the behaviour you describe would make sense generally. Any opinions on that from other people ? By doing this one would

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

2009-02-15 Thread Thomas Vandahl
Brendan Miller wrote: I'm tempted Feel free. Bye, Thomas. - To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org For additional commands, e-mail: torque-user-h...@db.apache.org

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

2009-02-15 Thread Thomas Vandahl
Thomas Vandahl wrote: The getItemsJoinPurchaseOrder()-method also creates a new copy of PurchaseOrder for every line of Item. This is something I wanted to address in 4.0 anyway. Just one additional comment: Torque doesn't care much how many object copies of the same database record exist

Re: Multiple addJoin with OR

2009-03-02 Thread Thomas Vandahl
Ludwig Magnusson wrote: It does make sense. I rewrote the query by hand (changed AND to OR) and executed it in the MySql console and it gave the response I wanted. I still suspect that this is error prone. I'd be interested in the output of explain. The situation is kind of like this: Table

Re: multiple criteria on the same field

2009-05-10 Thread Thomas Vandahl
Ivano Luberti wrote: Can someone suggest the best practice to do this with Torque ? I suggest the following: ---8--- Criteria criteria = new Criteria(); criteria.add(IscrizioniSocioPeer.STARTTIME, (Date) (formUser.getDataIscrizioneInizio()), Criteria.GREATER_EQUAL);

Re: generate schema with maven2 plugin

2009-06-18 Thread Thomas Vandahl
Cédric Durmont wrote: Is the plugin really supposed to create the *schema.xml file with the om goal ? If so, what might be going wrong in my case ? No it isn't. The om-goal is supposed to create Java files from your existing schema files. If not, how do I tell torque to generate the

Re: Primary key is set to the foreign key value

2009-09-04 Thread Thomas Vandahl
Adam Allgaier wrote: Change the table definition to this: table name=Person_SSN description=Person SSN idMethod=none You are generating the PK value yourself, so you don't need Torque or Postgres to do it for you. Right. The Torque idbroker is made for numerical primary keys. Your

Re: Turbine-Teradata

2009-09-24 Thread Thomas Vandahl
Turbine_User wrote: I am using Tubine Framework and JDBC with Oracle driver for a web application . This is actually a Torque question. See the list in CC for further discussions. database.adaptor=DBTeradata database.adaptor.DBTeradata=com.teradata.jdbc.TeraDriver I've never seen this type

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

2009-10-20 Thread Thomas Vandahl
Jon August wrote: I moved to a new development machine and having some trouble getting back to normal here... org/apache/tools/ant/PropertyHelper Looks like a ClassNotFoundException. Which versions of ANT do you have in your classpath? Bye, Thomas.

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

2009-10-20 Thread Thomas Vandahl
Jon August wrote: I don't remember setting the classpath before to use torque. My shell's classpath is empty. I use Eclipse to link libraries and compile... The version of ant maven is calling is this: jon$ ant -v Apache Ant version 1.7.0 compiled on July 20 2009 I dimly remember

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

2009-10-22 Thread Thomas Vandahl
On 22.10.09 09:36, Jon August wrote: I had followed the directions for 3.3, but when I do this: maven plugin:download -DartifactId=maven-torque-plugin -DgroupId=torque -Dversion=3.2 everything works fine... Something wrong with 3.3? Try to remove all versions of the maven-torque-plugin and

Re: Upgrading Torque 3.0 to Torque 3.3

2009-11-07 Thread Thomas Vandahl
On 06.11.09 22:19, Angela Day wrote: I simply replace the jar files in my classpath and I get the following error on build: C:\workspace\contract\build-torque.xml:74: taskdef A class needed by class org.apache.torque.task.TorqueDataModelTask cannot be found:

Re: [Torque] Using Torque again

2009-11-10 Thread Thomas Vandahl
On 10.11.09 16:54, Angela Day wrote: I inherited all of this, but as far as I can tell, there is no maven. I tried adding the variable, with no change in behavior. I tried commented the section out and this is the most important part, the part where it generated the om base classes. What

Re: [Torque] Using Torque again

2009-11-10 Thread Thomas Vandahl
On 10.11.09 20:52, Angela Day wrote: Here is my default.properties file. my build.properties file is empty. The problem seems to be referencing from the vm files that generate the om files. Has there been an update to those vm files for 3.3? There is very little documentation on

Re: Criteria needs write permissions?

2009-11-13 Thread Thomas Vandahl
On 13.11.09 08:12, Thomas Fischer wrote: I'm not sure whether this is a bug or not, I need to think about it. If i remember correctly, the database name is used for the database connection (including credentials) and the table layout. Probably there are some cases where this wants to be

Re: Criteria needs write permissions?

2009-11-17 Thread Thomas Vandahl
Greg Monroe wrote: Connection srcConn = Torque.getConnection(databaseA); Connection destConn = Torque.getConnection(databaseB); Don't want to be picky, but the recommended method is Connection srcConn = Transaction.begin(databaseA); } finally { Torque.closeConnection(srcConn);

Re: no suitable driver

2009-12-03 Thread Thomas Vandahl
Angela Day wrote: INFO: Starting Servlet Engine: Apache Tomcat/6.0.20Dec 2, 2009 2:02:47 PM org.apache.catalina.core.StandardContext loadOnStartup ... Resource name=jdbc/cmts auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/cmts parameter

Re: no suitable driver

2009-12-05 Thread Thomas Vandahl
Angela Day wrote: Thomas, Thank you so much for the tip on the xml syntax. That got rid of the no suitable driver and all other errors. No I just get a 404 in the browser when I try to bring up the application. The example tomcat servlets all work. It is never getting to my application

Re: blocking in connection pool

2010-04-13 Thread Thomas Vandahl
On 12.04.10 23:56, Will Glass-Husain wrote: I can see that the DBCP connection pool is blocking. With 150 users I have dozens of threads blocked as follows: [...] Any suggestions? DBCP supports the abandoned-pool feature which can be configured to remove objects not returned to the pool after

Re: How to strip off selected columns from a criteria object

2010-05-06 Thread Thomas Vandahl
On 05.05.10 23:28, wzhao6...@gmail.com wrote: Hi there, I need to strip off all the selected columns (getSelectedColumns(), and getAsColumns()) from a criteria object, is there a way for me to do that? For examples: Criteria criteria = new Criteria();

Re: How to strip off selected columns from a criteria object

2010-05-10 Thread Thomas Vandahl
Hi Dave, wzhao6...@gmail.com schrieb: Thanks for your reply. But what I need to deal with is that: I have a criteria object, with joins, and where clauses and a list of columns to select, and I need to remove all the selected columns in the criteria, both selected column, and as columns, so I

Re: Excessive database queries on postgresql: village metadata queries

2010-07-07 Thread Thomas Vandahl
On 07.07.10 19:15, Thomas Fischer wrote: ... Has anyone encountered this before and managed to work out how to stop the metadata queries being translated into database queries? I would expect either the JDBC driver to cache these, or if not for Village to cache these. I remember dimly

Revisited: Oracle and the empty string

2010-10-01 Thread Thomas Vandahl
Hi folks, just a question about a best-practice. We are trying to implement an XML-to-DB-mapper service on Oracle. The (existing) XSD defines some fields which distinguish between not set (null) and empty (). How do others handle this in Oracle? Especially within Torque? Bye, Thomas.

Re: Revisited: Oracle and the empty string

2010-10-01 Thread Thomas Vandahl
On 01.10.10 21:47, Thomas Fischer wrote: In my experience, it is no problem if you keep that fact in mind. It just makes the code non-portable to another database (you only query for not null and know it's also not empty in oracle, but not dor other databases). Is it a problem for yaou if and

[ANNOUNCE] Village 3.3.1 released

2011-02-18 Thread Thomas Vandahl
The Village team is pleased to announce the village-3.3.1 release! Village is the bridge between Torque and the JDBC-API. This release fixes some long outstanding bugs and can be used as a drop-in replacement for village-3.3. The source and binaries are available in the Maven Repository

Re: MySQL 5.5.11 and TIMESTAMP

2011-04-30 Thread Thomas Vandahl
Am 29.04.2011 19:42, schrieb Jeffery Painter: Can someone tell me where in the Torque generation steps it is adding the (0)? I don't have anything like that in my app-schema.xml file. Could it be that in the schema definition of the modified-column there is a size-attribute? If so, try to

Re: Define a Foreign Key with a One-to-One mapping

2011-05-31 Thread Thomas Vandahl
On 31.05.11 20:15, Thomas Fox wrote: Then, as you know thatyou have enforced a one-to-one relation on the database side, you can refelct this knowledge on the java side by adding getters and setters to your java code which map the n side list to a 1 side simple getter and setter. You can

Re: Torque Objects Implementing a Defined Interface

2011-07-05 Thread Thomas Vandahl
On 04.07.11 13:01, Neil Sherman wrote: Hi, Is it possible to get generated Torque objects to implement a specific interface ? See the documentation of the interface attribute to the table element in the schema documentation

  1   2   >