multiple join between tables and aliases

Hi, I wonder how I should best create a multiple join between two tables. Consider the following example: There are two tables, AUTHOR and BOOK. Assuming that each book has two authors, the BOOK table has two references on the AUTHOR table by two foreign keys, AUTHOR_ID and SECOND_AUTHOR_ID.

RE: multiple join between tables and aliases

select from BOOK,AUTHOR,BOOK B where BOOK.AUTHOR_ID=AUTHOR.AUTHOR_ID AND B.SECOND_AUTHOR_ID=AUTHOR.AUTHOR_ID Should the query look like this? SELECT FROM book, author a1, author a2 WHERE book.author_id = a1.id AND book.second_author_id = a2.id Pls correct me if I am wrong.

Building torque from the cvs

Hi everybody I am currently trying to build Torque from CVS. I have documented the steps I have taken in the wiki (http://wiki.apache.org/db-torque/GettingTorqueToWork at the bottom), and I am able to create both torque.jar and torque-gen.jar. However, I am running into problems if I am

Implementation for left joins / right joins/ explicit inner joins available

Hi all, I have added the functionality to construct left and right joins for torque. The details are posted in the Developers mailing list, see http://nagoya.apache.org/eyebrowse/[EMAIL PROTECTED]msgNo=3850 The patch was reported to work with oracle and postgreSQL. The only issue known to me

RE: need help

1) There is an entry in the wiki in the section Frequently asked Questions which describes how to execute a count(*) from table where... using criteria without explicitly creating the statement. 2) As far as I know, subselects are not supported by criteria, so I guess you will either have to

RE: Criteria parses to SELECT FROM ..

Hi Ron, I guess the point is that in every Peer class for a database table, in the method doSelectVillageRecords(Criteria criteria, Connection con) which is called from the usual doSelect(criteria), the following call is made BEFORE the criteria is converted to a query: if

RE: SortedMap in reverse order

Hi Veronique, you have to use the constructor TreeMap(Comparator c) contructor and provide a comparator implementation which sorts the key in the right order. Thomas P.S. :A small hint: as this is not a torque-related question, you are lucky to get this question answered here. Veronique

Re: db adapter for xml database

From what I've seen in the code, Torque relies very heavily on SQL. You would certainly have to change a lot more than the DB adapter, e.g. the BasePeer class, to use torque with a non-SQL database. In my opinion, you can't use the database capabilities of Torque with a non-sql-database. (You

RE: BasePeer.MapBuilder: ClassNotFoundException under Tomcat 5.0

Hi Rankin, it says in the stack trace java.lang.ClassNotFoundException: com.jwortham.ocip.map.AddrtypesMapBuilder Did you look whether a class file exists for this class within your web application (in the WEB-INF/classes directory)? If yes, did you try to instantate the class yourself and

Antwort: build instructions?

Hi, Usually, the tutorial would answer your questions. Unfortunately, it is quite out of date. However, in the Wiki, the page http://wiki.apache.org/db-torque/GettingTorqueToWork should answer your questions. Thomas Nathaniel Reed [EMAIL PROTECTED] schrieb am 11.08.2004 17:10:58: Can

RE: ComboKey composite primary key: modifying PK fields

Hi, I do not think this behaviour is as weird as it seems at fisrt thought. A primary key is there to identify an object uniquely, so if you change the primary key, you have a new object. Therefore, the update with the current values from the pk is ok for me. Usually this kind of problem pops

RE: How to remove [DEBUG] from output....Please Help Me ,...Urgent

Hi, I remember there was a thread in the torque users mailing list about a month ago, please search the archives. If I remember right, you have to modify the log4j.properties in the torque.jar Thomas ravi dhoolypala [EMAIL PROTECTED] schrieb am 13.08.2004 07:28:02: Hi all... I am new

[Fwd: RE: Date vs timestamp with Oracle]

Hi, Just tried the patch and I had problems writing a timestamp to a Oracle 9i Database. I did the following: - apply the patch to db.props from the torque-3.1-release (by the way: the patch is reversed, i.e. I had to apply the -R option for patching) - create an object with a timestamp value

Re: [Fwd: RE: Date vs timestamp with Oracle]

has tried it, it would be nice if they would post it to the list. Cheers, Thomas Scott Eade [EMAIL PROTECTED] schrieb am 17.08.2004 04:41:32: Thomas Fischer wrote: Just tried the patch and I had problems writing a timestamp to a Oracle 9i Database. I did the following: - apply

Re: [Fwd: RE: Date vs timestamp with Oracle]

Just to clarify things : there is no ojdbc14.jar shipped with oracle 9.0. As there are circumstances where one has to use the driver which comes with the database installation (e.g. if one has to use oci connections), one really does not have the choice between classes12.jar and ojdbc14.jar

RE: single column pk tables

Hi Ferruh, it seems that nobody has solved the problem before, so I'm afraid you probably have to use a debugger and debug into torque to find out yourself what happens. Thomas Ferruh Zamangoer [EMAIL PROTECTED] schrieb am 24.08.2004 14:34:41: Hi, I want to know if somebody else have

RE: CLOB vs BLOB

Hi Sarav As I understand it, a BLOB is a binary large object, and a CLOB is a character large object. The difference between characters and bytes is the Character set, i.e. the mapping between a character and the byte sequence it represents. - With a blob, you have to use the right character

Antwort: Releasing DB connections

Hi, personally I use Transaction.begin() to get a connection and Transaction.commit(connection) , transaction.rollback(connection) or transaction.safeRollback(connection) to give it back to the pool. Thomas [EMAIL PROTECTED] schrieb am 27.08.2004 10:21:11: A bit of clarification

Re: Releasing DB connections

[EMAIL PROTECTED] schrieb am 27.08.2004 12:58:15: Up to now I have assumed that things work as you explained. However opening new connections is typically a fairly slow business. Ok, but because of this, you use a connection pool. A pool keeps the connections open even if you do not use

RE: Putting schema into the select clause

Hi, I believe the simplest way to allow fully qualified table names is to use schema.tablename as tablename in the database schema xml. This would mean that one would use schemaname.tablename instead of tablename all the time, but I do not know a sql statement where this would not work. The

RE: Is this project still being developed?

The project is still developed, see http://db.apache.org/torque-31/status.html Thomas Anthony Spencer [EMAIL PROTECTED] schrieb am 22.09.2004 18:07:43: I've been using Torque for two years and I currently have several projects actively running Torque. I'm quite happy with the project

Re: Unable to create Criteria object or executeQuery

Hi, I do remember there was a discussion about this in the user mailing list some time ago. The problem with your statement is that it uses subselects, which is not (yet ???) supported in torque (contributions are welcome). One solution was to manually create a view in the database, declare

Re: Don't get Torque's loggin to work

Hi Daniel, Sorry if I point out the obvious: Do you have log4j.jar in your runtime classpath? If yes, did you try to create log messages by hand, i.e. to fetch a log4j logger and write log messages to it, and see what happens ? I have never tried do configure log4j via torque.properties, I

Re: Using torque

Hi, please look at the tutorial, http://db.apache.org/torque/tutorial/index.html. There, maven is used to generate the java classes. It worked for me. I did the following: - downloaded and installed maven - installed the torque plugin for maven (see tutorial) - downloaded torque-gen-3.1.1 -

RE: Using torque-gen from a java program

. -Mensagem original- De: Thomas Fischer [mailto:[EMAIL PROTECTED] Enviada: segunda-feira, 15 de Novembro de 2004 18:52 Para: Apache Torque Users List Assunto: Re: Using torque Hi, please look at the tutorial, http://db.apache.org/torque/tutorial/index.html. There, maven is used

Antwort: Missing type for TIMESTAMP in jdbc task.

Hi, There was a discussion one or two mothths ago about this in the mailing list. Please search the archives. Personally, I am using the date type with oracle 9i. It has only a limited accuracy, but it works. Thomas Krishna C Tripathi [EMAIL PROTECTED] schrieb am 16.11.2004 01:07:10:

RE: Don't get Torque's loggin to work

Hi Daniel, log4j has also a property configurator. see org.apache.log4j.PropertyConfigurator.configure(String configFilename) This should be what you want. Thomas Vitzethum, Daniel [EMAIL PROTECTED] schrieb am 16.11.2004 11:41:53: Hello again, Thomas Fischer wrote: Sorry if I

Re: Join or Caching (??)

Hi Sarav, I am not sure how you structured your tree. I presume you use the parent as a foreign key. Then, I see no way how you can read in the complete tree with a join because you have the one-to-many relation of B with itself. Therefore, the depth of your tree is not limited and also the

AW: Don't get Torque's loggin to work

Hi Daniel, I have looked in my logfiles and I have also only seen the selects. My guess is that the select sql is created natively by torque and are logged, whereas the updates are done via the village library, which does not do any logging. If you want to know the sql statements, I remember

RE: torque failing within junit no DataSourceFactory configured

Hi, which Torque version are you using ? Cannot find anything like initDataSourceFactories or line 318 in Torque.java neither in 3.1 nor in 3.1.1source. Thomas Angela Day [EMAIL PROTECTED] schrieb am 16.11.2004 20:10:27: I am getting this confirmation in the logs: Time: 12:57:05 PM  

RE: Not creating retrieveByPK methods

Hi Angela, this works for me. I have used the generator 3.1.1, the schema from the tutorial. E.g in BaseBookPeer, I find the methods public static Book retrieveByPK(int pk) public static Book retrieveByPK(int pk, Connection con) public static Book retrieveByPK(ObjectKey pk) So

RE: NullPointerException while running testcases

Hi Arne, I looked a bit through the Torque Source code, and I am a bit at a loss to see how database maps are initialized. So I can only give you general advice. Are you sure you have initialized Torque before the testcase, and if yes, did you initialize it only once ? Thomas [EMAIL

RE: NullPointerException while running testcases

::addTable methodes except in DatabaseMap::setIdTable (but I think this isn't relevant). I initialize torque in a static block of my junit test class, so Torque should be initialized only once. In the meantime I installed torque 3.1.1, but that didn't help. Arndt Thomas Fischer [EMAIL

RE: Foreign key integrity constraints and Transactions

Hi John, did you look at the tutorial,especially step 4 ? There, you have the same situation with the author book tables. The examples run on oracle with the generated constraints. However, in the tutorial, a seperate transaction is used for each insert. If you want to use the same

Antwort: SQL-Criteria howto

Hi Tino 1) I do not understand why you need the alias. Following sql works for me (on tutorial tables, on oracle) select * from book where book_id in (select max(book_id) from book); Thomas Sperlich, Tino [EMAIL PROTECTED] schrieb am 22.11.2004 11:40:18: Hi all, I'd like to express

RE: Antwort: SQL-Criteria howto

(sequenz) for every distinct vavi_id, you'll need the IN clause. Thomas Fischer a écrit : Hi Tino 1) I do not understand why you need the alias. Following sql works for me (on tutorial tables, on oracle) select * from book where book_id in (select max(book_id) from book); Thomas

RE: Escaping SQL names in torqu

Hi Pedro, you can change the velocity templates which are used to create the sql scripts . They can be found in the generator in the subdirectory templates/sql. However, I would _NOT_ use reserved words as table or column names if I were you. I would be surprised if the sql scripts are the

RE: Escaping SQL names in torqu

Hi, e.g. for the create/drop table script for mysql, look at templates/sql/base/mysql/table.vm and drop.vm, respectively. They are interpreted using the velocity template parser, see http://jakarta.apache.org/velocity for documentation. Thomas Pedro Castro [EMAIL PROTECTED] schrieb am

RE: Torque tries to insert 0 into nullable Foreign Key

Hi Daniel, I had the same problem before, and as I needed a quick solution, I used string foreign keys instead (String foreign keys can be null). I will open a scarab issue on this problem. Thomas Vitzethum, Daniel [EMAIL PROTECTED] schrieb am 06.12.2004 13:22:17: Hello list, one

RE: Join or Where Clause

Hi Daniel, I have looked through the source code and it seems that your query cannot be generated generically with torque. The problem is that Torque does not support join conditions other than equal (=). My suggestion for a quick solution would be to use any of the methods

RE: Torque Maven Plugin Problem

Hi Tod, I finally got a (_VERY_ dirty) solution for your problem. Perhaps some maven guru on the list can create a cleaner solution from this. Find the file /cache/maven-torque-plugin-3.1.1/plugin.jelly somewhere in your maven home directory. Add the path to classes12.jar into the torque

RE: Join or Where Clause

information Karim Selon Thomas Fischer [EMAIL PROTECTED]: Hi Daniel, I have looked through the source code and it seems that your query cannot be generated generically with torque. The problem is that Torque does not support join conditions other than equal (=). My suggestion

Re: Torque tries to insert 0 into nullable Foreign Key

Hi Daniel, Hi Sarav, Use this attribute in the database tag. defaultJavaType=object thank you very much. I would prefer primitives for my numbers, especially the ids, but that is o.k. for me. Everything works, with one exception: I have a foreign key that is NOT NULL, but has a

Re: Torque Maven Plugin Problem

Hi Tod, here it is... http://nagoya.apache.org/eyebrowse/[EMAIL PROTECTED]msgNo=4463 Thomas Tod Thomas [EMAIL PROTECTED] schrieb am 07.12.2004 18:27:53: Actually I didn't, I'll check the archives. However, if you have a link handy I'd appreciate it. Tod Thomas Fischer wrote

RE: Saving associated objects

Hi Daniel, I am not sure if I understand the question. Let me pose the question in my own words: You have a 1:n relation. If you save an object on the 1 side, the related objects on the n side get saved. If you are on the n side, why is the 1 side not saved ? The 1 side is the side where no

Re: Saving associated objects

Hi, Saravana Krishnan [EMAIL PROTECTED] schrieb am 08.12.2004 17:33:13: Hi, ... My other doubt is, if it's a 1:1 relation between 2 tables, why not simply merge them? What's the point in having 2 tables with 1:1 relations. Isn't having 2 1:1 related tables like having one table for

RE: Setting non-autogened ids under native idMethod

Hi Sarav, Have you tried the following: - load the object in question - delete the object but keep a reference in memory - call the object's methods setModified(true) and setNew(true) - save the object Not sure whether this works with autogenerated ids, but it might be worth trying

Re: XXX.getXXX() and XXX.addXXX()

Hi Sarav, can you please open an issue on this in scarab ? This does not sound like an easy enhancement to me, so dont expect it too soon. In the meantime, you can override the object's save()-Method to get the behaviour you want. Thomas Saravana Krishnan Kannan [EMAIL PROTECTED]

RE: Setting non-autogened ids under native idMethod

it ;-) ). Have any other suggestions for me? Thanks, Sarav On Thu, 2004-12-09 at 04:12, Thomas Fischer wrote: Hi Sarav, Have you tried the following: - load the object in question - delete the object but keep a reference in memory - call the object's methods setModified(true

AW: Can't handle same column name twice - possibly a bug in village?

Hi Daniel, looking into village, it extracts the tablename from the metadata and looks if there are different tables (com.workingdogs.village.Column.populate()) Now, my oracle driver returns null as tablename, so village assumes the results stem from a single table, the crucial call being

Re: Auto Commit + Transaction Problems

Hi, Some pools can test connections before they give it to the end user (in this case Torque). This is done by executing a simple query like select sysdate from dual. If the connections are not auto commit, this is the first query in the transaction, and it is not possible to use any set

Re: is this really the way to combine several or ´s ?

Hi, Alex Hepp [EMAIL PROTECTED] schrieb am 22.12.2004 16:42:30: Hi List! I tried several hours now, to get a simple or to work... I must say, that i really would appreciate a bit of documentation on that. contributions to the docs are always welcome ;-) . But yes, documentation is not

Re: Torque using Tomcat

M. Sean Gilligan [EMAIL PROTECTED] schrieb am 29.12.2004 10:19:57: [...] I plan on trying out a build tomorrow. My CVS tree has the latest code, but I should probably build a patched version based on the TORQUE_3_1_1 tag if I want to put this into production, right? If you are

Re: SET TRANSACTION must be first statement of transaction

Hi, if you find out anything about the error please post it here. I remember this problem was reported before to the users list but I do not remember that the problem was solved. You can try to log the SQL statements via P6Spy:

Re: SET TRANSACTION must be first statement of transaction

isolation level for a transaction. Transactions use the default transaction isolation as set for the database. |-+ | | Thomas Fischer | | | [EMAIL PROTECTED]| | | u.net

Re: SET TRANSACTION must be first statement of transaction

Hi, [EMAIL PROTECTED] schrieb am 24.01.2005 10:40:01: We are on Oracle 9.2.0/Linux. I am using oracle.jdbc.dirver.OracleDriver from ojdbc14.jar as the driver library wiith the 'thin' connection, and have been running without problems, at least none that were not of my own making, for

Re: SET TRANSACTION must be first statement of transaction -- the real cause

. |-+ | | Thomas Fischer | | | [EMAIL PROTECTED]| | | u.net | | || | || | | 21-Jan-2005 13:45| | | Please respond

RE: [HOWTO] transform existing MSSQL DB into Derby DB with TORQUE

Hi, I have seen some templates for Derby in CVS. No idea whether a) they work) and b) they are sufficient to do a migration. Thomas Norbert Krömeke [EMAIL PROTECTED] schrieb am 01.02.2005 09:21:26: - Original Message - From: Norbert Krömeke [EMAIL PROTECTED] To:

Re: Prepared Statements with Oracle

Well, yes, but for each query, a new prepared statement is used, as far as I know. It would be nice if one could reuse the prepared statements, but I would guess this cannot be done at the moment. Thomas John McNally [EMAIL PROTECTED] schrieb am 02.02.2005 16:21:31: [EMAIL

Re: Error java.lang.NoClassDefFoundError: org/apache/torque/NoRowsException

Hi, make sure you have the torque runtime jar in the classpath of your web application (i.e. make sure that torque.jar is in WEB-INF/lib) Thomas Joseph Yuen [EMAIL PROTECTED] schrieb am 05.02.2005 21:14:53: Could anyone suggest how I might go about debugging why I am getting the

RE: Problems with Mysql timeout

Hi, Yet another solution on the client side: Whether a connection timeout can be configured depends on the connection pool you are using. If you are using SharedPoolDataSource, it should be possible to tell the pool to close unused connections after a certain period of time. See the

RE: Error in using Derby and Cloudscape as Adapter

Hi, I tried to run the runtimetest on Derby for Torque 3.2-dev (cvs HEAD) this morning, and it did not pass. Cloudscape as adapter also did not work. I would not trust anything which does not pass the runtimetest, i.e. 3.2-dev does not support derby yet. Note that this does not necessarily

status of Derby support in CVS

Hi, some people have mailed to the list wondering about the status of Apache Derby by Torque. The CVS HEAD does not currently support derby, and I strongly believe CVS 3_1_BRANCH also does not support derby, though I did not try it. This is the current status: - I have been able to run the

RE: PL/SQL in generated Oracle scripts

Hi Paul, I suppose you use Torque 3.1.1. In that version, a change was introduced in order not to let the drop table statements fail if the table is not already there (e.g. if you start with an empty database). But this change produces more problem than it solves, so I removed it again in

Re: PL/SQL in generated Oracle scripts

Nuno Miguel Rodrigues [EMAIL PROTECTED] schrieb am 16.02.2005 10:35:52: On Tue, 15 Feb 2005 23:29:55 -, Paul Osborne [EMAIL PROTECTED] wrote: I am trying to use the Maven Torque plugin to generate and initialize an Oracle 8i database. However, the torque 'insert-sql' target is

RE: insert / update on duplicate key question...

Hi Aaron I would guess that if you do not use an object cache, (torque.useManagers=false, this is the default), the mere act of saving should be no problem because the different object do not know of each other. I d not know what happens if you use the cache. What WILL be problematic is if

RE: Torque apache derby embedded support

Hi, due to a bug in the derby jdbc driver, Torque does currently NOT work with derby, neither embedded nor via network. See the mail I posted to the users list about a week ago. You might be able to read from the database, but writing does not work. Your configuration seems ok to me, though

RE: Torque apache derby embedded support

-Original Message- From: Thomas Fischer [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 4:40 PM To: Neal Cc: Apache Torque Users List Subject: RE: Torque apache derby embedded support Hi, due to a bug in the derby jdbc driver, Torque does currently NOT work

Re: Getting Started...HELP

Hi, this error occurs if one does not create a correct project.properties file in the root of the generator directory. Take the project.properties from the tutorial, put it where the tutorial says, and run maven torque from the base directory of the generator. In particular, you have to

Re: Arrays in OM classes

that) So all that needs to be done is to make it public in ContactPeer. This is not true any more? I know i have used this feature of Torque (3.0 and 3.1) several times. Best regards, Andras. Thomas Fischer wrote: Hi, You can overwrite the doSelect Methods of your choice

RE: Peer Class and associated fun

Hi Brandon, You can use the reflection API for that. If you want to use a String as a name, you can use Class.forName(your.target.package. + name).instance(), and set name to Book, you can get an instance of Book, and proceed like you do. You might even be able to use

RE: Problem with setDistinct()

Hi, its just as it says: some datasets do not support DISTINCT with some datatypes. No problem of Torque, but of the database. I got no clean solution, only if your content is short enough then you can use VARCHAR instead of whatever datatype you use and it should work then. Thomas

RE : Problem with setDistinct()

: deleting doubled item in my result list ... Frederic. -Message d'origine- De : Thomas Fischer [mailto:[EMAIL PROTECTED] Envoyé : mercredi 2 mars 2005 11:50 À : Apache Torque Users List Objet : RE: Problem with setDistinct() Hi, its just as it says: some datasets do

RE : Problem with setDistinct()

better. Frederic. -Message d'origine- De : Thomas Fischer [mailto:[EMAIL PROTECTED] Envoyé : mercredi 2 mars 2005 14:44 À : Apache Torque Users List Objet : RE : Problem with setDistinct() Hi Frederic, It is not the primary keys of the table, it is all columns of the table

RE: Libraries to go with 3.1.1.

Hi, a) the libraries can be found in the lib directory of torque-3.1.1.tar.gz. They are named such that you should be able to extract the version from it. b) I am not sure whether library conflicts are the cause of the problem. Did you make sure that initializing Torque is the first thing you do

Re: Can't delete row, either no delete or get You must specify KeyDef... exception.

Hi, You use the foreign keys also as primary key. In my experience, using something which has another meaning as a primary key is not a good idea. Can you try to add another column, e.g. user_role_id, as a primary key, remove the primaryKey attribute from the other columns and try it again ?

RE: problems with ordering

Hi, your code looks ok. There is something similar in the Runtimetest, public void testCriteriaOrderBy() { List books = null; try { Criteria criteria = new Criteria(); criteria.addAscendingOrderByColumn(BookPeer.TITLE);

Re: Security service

Hi, never heard of a Torque security service. I guess both is the same and it is implemented in Turbine, but Turbine uses Torque as a persistence layer. This is just a wild guess, I do not use Turbine. If I am wrong, please tell us. Thomas On Thu, 10 Mar 2005, Kintzel Levente wrote: Hi! I

RE: doDelete problem, null dbMap

John, My first guess would be that the Peer class is not loaded by the classloader before you execute the query. See http://issues.apache.org/scarab/issues/id/TRQS228 In Torque 3.1.1, the problem should be resolved. Alternatively, you can force the classloader to load the class before you

RE: inefficient doDelete

Husek, Paul [EMAIL PROTECTED] schrieb am 11.03.2005 17:01:45: I've been using Torque for almost a year now and am very happy with it. Recently though I found something that confuses me. All along I've been deleting all History books like: Criteria c=new Criteria();

RE: inefficient doDelete

in chunks using criteria.setLimit(). Problem there is that Torque does not tell you how much datasets it has deleted, so you have to look by other means whether there are still Datasets to delete. Thomas Thomas Fischer [EMAIL PROTECTED] schrieb am 11.03.2005 17:25:27: Husek, Paul

RE: Complexe torque crieteria

Please search the mailing list archives, there are several threads about this. Alternatively, see the criteria howto. Thomas Abou Zarr [EMAIL PROTECTED] schrieb am 14.03.2005 13:06:28: Hi, how can i transform these query to torque criteria? sql = select distinct salle + from

RE: inefficient doDelete

Daniel, surely you are right, this is probably the best solution without any changes in Torque. On the other hand, in my opinion it it is the responsibility of Torque to handle simple mass deletes. One should not need a custom query for it. This behaviour can probably be changed easily where

RE: doDelete problem, null dbMap

Jim, if the db map is not null, but the column is not mapped, then I was mistaken about the cause of the error, and class.forName() is of no use. Can you look at the map package (${target.package}.map), locate the Map class for the Table, and see if it has got an entry for the column OFFRG_N

RE: doDelete problem, null dbMap

-4788 Mail Stop: WHB2S-15 [EMAIL PROTECTED] Thomas Fischer [EMAIL PROTECTED] u.net To Apache Torque Users List 03/14/2005 10:44 torque-user@db.apache.org AM

RE: doDelete problem, null dbMap

, it somehow re-initialized Tables in the dbMap. Now all I have to do is get the Updates and Inserts working.. Thanks for all your help! Jim --- Thomas Fischer [EMAIL PROTECTED] wrote: Jim, Sorry, I should have read your mail more cautiously; I was again mistaken

RE: doDelete problem, null dbMap

(TableNamePeer.OFFRG_N, primaryKey); //criteria.setDbName(db2Schema); TableNamePeer.doDelete(criteria, dbConn); --- Thomas Fischer [EMAIL PROTECTED] wrote: Jim, I still not understand the cause of the problem and your solution. What did you do to make the error do away ? Looking

RE: doDelete problem, null dbMap

cannot be before 01/01/70. I have never had this happen in version 3.0. Still trying to work that one out inbetween other projects. I will have to check out the release notes to see if there were changes to Date fields. Thanks! Jim --- Thomas Fischer [EMAIL PROTECTED] wrote

Re: How to use doSelectJoin?

Robert, I do not see a possibility to load all your datasets using one single join if you only use pregenerated classes. But if you only want to get the stuff from the db and do not care whether it is a single sql statement or not, you can use the following PSEUDOcode: User user =

Re: How to use doSelectJoin?

have any problem! Thanks for your quick and helpful responses. Bob --- Thomas Fischer [EMAIL PROTECTED] wrote: Robert, I do not see a possibility to load all your datasets using one single join if you only use pregenerated classes. But if you only want to get the stuff

RE: DB Connections are not being closed...

Hi, if you do not open any connection explicitly, Torque makes sure that the connections are closed. If you open connections explicitly, make sure that they are closed afterwards. A secure way is doing it like this. Connection connection = null; try { connection = Torque.getConnection();

Creation of beans from Torque objects supported in CVS version

I have committed changes into cvs which allow to create beans from torque objects and vice versa. Related Objects are taken care of, and database state (i.e. is it a new Object ?) is also transferred into the beans. I did not yet use it in production environment, but I am quite confident that

Re: Creation of beans from Torque objects supported in CVS version

I just found out that in addition to install a new version of the maven plugin, one aslo has to install the new version of the generator: From the root of torque cvs: cd /src/generator maven jar:install Thomas On Mon, 28 Mar 2005, Thomas Fischer wrote: I have committed changes into cvs which

RE: Builds fine on Windows, Fails on Linux

Tom, I do not think the operation system is a problem. I have no experience with 3.0.2, but from 3.1 on, the builds run also on linux. Are you sure you do not have any absolute paths in your configuration ? Perhaps it is best to start the installation from scratch on linux and copy only the

RE: oracle 9i and torque

Hi, seems that your database connection does not work. Are you sure you have the right SID, username and password ? Also, a firewall might be problematic... Thomas Dressler, Erik(externe MA) [EMAIL PROTECTED] schrieb am 18.03.2005 15:15:30: hello, everybody! i have a big problem!

RE: Error while using oracle.

Hi, The null comes in from where the method is called: public String getIDMethodSQL(Object sequenceName) { return (select + sequenceName + .nextval from dual); } It seems that in CVS version, the method where it is called from is IdGenerator.getIdAsXXX(), but I have not

RE: select max(column)

Look in the wiki. Ther it is described how to select count(*) from a table. The same procedure can be used to find out max( + SomePeer.COLUMN_NAME +); http://wiki.apache.org/db-torque/FrequentlyAskedQuestions#head-9317e897d07dbd597993796d47bfbbe2443bc5bf Thomas Kintzel Levente [EMAIL

RE: oracle 9i and torque

to use the new datasourcefactory. now i take a look at the web-site, which you've posted. do you have an oracle 9i database running with turbine and torque? -Original Message- From: Thomas Fischer [SMTP:[EMAIL PROTECTED] Sent: 29 March 2005 09:50 To: Apache Torque Users List

RE: torque and xmltype

Erik, xmltype it is not supported out of the box. if you use any release up to 3.1.1, you have to change the db.props file in the sql/base/database_name (in your case sql/base/oracle) and map a datatype to sqltype. I have no idea whether you can add a new type (this would be a clean

RE: DATE / DATETIME

In the generator templates, edit the db.props file for mysql and replace the line DATE = DATETIME by DATE = DATE Thomas Aaron Loucks [EMAIL PROTECTED] schrieb am 30.03.2005 22:43:58: Is there a way to force the column type to DATE rather than DATETIME with mysql? In my schema I

  1   2   3   4   5   >