Re: How do I control the join type of doSelectJoin?

2008-02-18 Thread Thomas Fischer
btw: I have newer understood the reason to use field joins at all. Can anyone enlighten me on in which cases one would use a field join instead of a inner join? Hm, in most databases (e.g. mysql, oracle, postgresql) the thing you call "field join" is an inner join (just a different syntax) s

RE: Torque Runtime errors:-ID_TABLE

2007-12-17 Thread Thomas Fischer
Pyaar. Before sending a message to the the mailing list, would you please try and execute the steps AS DESCRIBED IN THE TUTORIAL ? Thanks a lot in advance. Thomas pyaar <[EMAIL PROTECTED]> schrieb am 17.12.2007 14:20:56: > > HI ALL > i am executing the bookstore application using mss

RE: Torque Runtime errors:-Invalid object name "ID_Table"

2007-12-17 Thread Thomas Fischer
It seems that you forgot to execute the command maven torque:id-table-init-sql from http://db.apache.org/torque/releases/torque-3.3/tutorial/step3.html Thomas pyaar <[EMAIL PROTECTED]> schrieb am 17.12.2007 12:04:19: > > Hi all > > i am using mssql server 2000,torque 3.2.I am trying to exec

Re: Torque Runtime errors:-NoClassDefFoundError Exception

2007-12-17 Thread Thomas Fischer
As far as I know, jars must appear explicitly in the classpath, it does not suffice to add the directory of the jars. >From http://db.apache.org/torque/releases/torque-3.3/tutorial/step6.html, the following should work: java -cp classes:lib/avalon-framework-4.1.4.jar:lib/commons-beanutils-core-1.

RE: Torque Runtime errors:-NoClassDefFoundError Exception

2007-12-13 Thread Thomas Fischer
> I am trying to execute the bookstore application which is given in > http://db.apache.org/torque/releases/torque-3.1/tutorial/step4.html > ... > As far as i know my classpath has been set properly Definitely not. Make sure the Torque runtime jar and the jar it depends on is in your classpath. Th

Re: Echo not Implemented

2007-12-10 Thread Thomas Fischer
True. The message that echo is not implemented and failing to create the db might be different errors. However, even if they are different errors, the question remains why the echo message appears, and for this Alvaro's answer remains valid. Sorry I do not have an exhaustive list of for which data

RE: datadtd goal for m2 plugin

2007-12-04 Thread Thomas Fischer
> > Hello. I've been using the m2 plugin for a while now (3.3-RC2) and just > recently noticed it does not currently support the datadtd goal (as far as I > can tell). I did notice somewhere that Thomas Fischer had possibly checked > in some code to add in the datadtd goal,

RE: Left Join on multiple clauses

2007-10-18 Thread Thomas Fischer
Torque can only create joins using one join statement per join; and the join operator must be the "equals" operator. If you need something else, you would have to assemble at least parts of the sql statement manually. Having said that, I'm not sure whether the statement in your last mail is corre

Antwort: complex query with torque

2007-10-15 Thread Thomas Fischer
Hi, I'd use Criteria.CUSTOM for that. See the section "Using the CUSTOM modifier to use custom SQL" in http://db.apache.org/torque/releases/torque-3.3 /runtime/reference/read-from-db.html Thomas [EMAIL PROTECTED] schrieb am 15.10.2007 03:07:28: > Hello, > how can I do the following query us

Re: problem with om classes

2007-10-11 Thread Thomas Fischer
Hm, you have defined the foreign key twice: perhaps removing one of the references helps ? It should not be necessary to define an interface. Can you remove the empty interface and see what happens ? Thomas On Tue, 9 Oct 2007, Alex Laudani - Softmasters wrote: Hello, I have prob

Re: Torque connection error

2007-10-11 Thread Thomas Fischer
The error message says that the database "webmodel" cannot be accessed. However, your database key is "mydb". You did not define any connection properties for the database "webmodel". Try syncing the two database names. If this sill does not work, can you post the stack trace of the exception

RE: ISNULL with Criterion?

2007-10-10 Thread Thomas Fischer
Just a shot into the dark: Criterion c1 = crit.getNewCriterion(b, null, Criteria.ISNULL); does not work ? (probably you have to cast the null) Thomas "Brendan Miller" <[EMAIL PROTECTED]> schrieb am 09.10.2007 19:05:22: > > There doesn't seem to be a getNewCriterion(String column, SqlEnum c

Re: O/R-Mapping with Torque 3.3-RC2 and Maven 2.0.7

2007-09-26 Thread Thomas Fischer
On Wed, 26 Sep 2007, Bernhard Daubner wrote: Hello! I am trying to implement a simple database application using Torque as O/R-Mapper. I followed the instructions within the "Torque-Tutorial" (http://db.apache.org/torque/releases/torque-3.3/tutorial/index.html) and modified them to work with ma

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

2007-09-25 Thread Thomas Fischer
On Tue, 25 Sep 2007, Brendan Miller wrote: ... Anyone have any ideas on how to delete the row/object without incurring this SELECT without bind variables query? Knowing this is the worst statement for a OR layer: If it is just this single table, I'd recommend using pure jdbc for creating a p

RE: m2 torque plugin

2007-09-24 Thread Thomas Fischer
a) There is no maven2 plugin for Torque 3.1.1. The current m2 plugin uses the 3.3.RCx generator. I'd not recommend using it with a 3.1.1 runtime. Consider upgrading; otherwise consider building a m2 plugin yourself which uses the 3.1.1 generator. b) I'm afraid there is no example in the website. I

Re: m2 torque plugin

2007-09-22 Thread Thomas Fischer
There is some documentation available, unfortunately it is hidden well. The url is http://db.apache.org/torque/releases/torque-3.3/maven2-plugin/plugin-info.html Hope this helps, Thomas On Tue, 18 Sep 2007, jill han wrote: I just moved from m1 to m2, but could not get torque plugin work

RE: Torque Maven2 Plugin and idBroker

2007-09-14 Thread Thomas Fischer
"Marc Kannegiesser" <[EMAIL PROTECTED]> schrieb am 14.09.2007 14:40:02: > Hi. > > Thanks in advance for your fast answer, Thomas. > > > The goal id-table-init-sql does not exist in the maven2 plugin; I'd > > consider it a missing feature (please add a feature request to jira). If I > > understand

RE: Torque Maven2 Plugin and idBroker

2007-09-14 Thread Thomas Fischer
The goal id-table-init-sql does not exist in the maven2 plugin; I'd consider it a missing feature (please add a feature request to jira). If I understand you correctly, the sql file gets created, and the problem is to execute it ? If this is the case, then the sqlExec goal would be the correct goal

RE: Problems with sdk 5/6 and ojb blank

2007-08-29 Thread Thomas Fischer
Hi, you sent your mail to the wrong list (torque users). Please use the ojb users mailing list. Regards, Thomas Hans Novak <[EMAIL PROTECTED]> schrieb am 29.08.2007 14:52:02: > Hi, > > i need help to run the ojb_blank projekt. > If i configure it like the tutorial says, i get in ec

RE: logging insert/update/delete statements

2007-08-20 Thread Thomas Fischer
It cannot be done from within Torque, as Torque relies on another library (village) to do the inserts, and village does not do any logging. You can use a logging jdbc driver (P6Spy) for logging, there were several posts from people on this list who have done it successfully. Thomas Raul A

RE: subqueries in criteria

2007-08-01 Thread Thomas Fischer
Hi, here is an example from one of the test classes for creating a subquery: Criteria subquery = new Criteria(); subquery.addSelectColumn(AuthorPeer.AUTHOR_ID); subquery.add(AuthorPeer.NAME, author2.getName()); Criteria criteria = new Criteria(); criteria.add(AuthorPeer.AUTHOR_ID, subquery, Crite

RE: M2 plugin SQL2XML

2007-07-24 Thread Thomas Fischer
>From a short glance, no. Maven 1 uses the org.apache.torque.task.TorqueSQLTransformTask for this, and I do not see a Mojo which could be equivalent. Regards, Thomas "Raphaël Piéroni" <[EMAIL PROTECTED]> schrieb am 24.07.2007 14:44:53: > Hi, > > is there an equivalent of the m1plug

RE: not writing to torque.log and turbine.log

2007-06-01 Thread Thomas Fischer
Torque 3.2 uses commons-logging for logging. Please consult the commons-logging documentation for information how to configure logging. If you are using turbine, turbine might also configure logging, but I do not know anything about this. I do not see any obvious error in your log4j properties. Tr

RE: encrypt database user info in the Torque.properties?

2007-05-25 Thread Thomas Fischer
One thing to remember is that if the attacker has access to the encrypted password and to the decryption code, he can decrypt the password himself. By this I do not want to suggest that encrypting the password makes no sense (it makes the attack a lot harder), but one needs to remember that there i

RE: doesnot support basepathtodbprops

2007-05-24 Thread Thomas Fischer
It seems that in your ant script you seem to give the sql task a property basepathtodbprops which it does not support. A possible fix would be to remove the property from your ant file. Thomas "Neelima Yadla" <[EMAIL PROTECTED]> schrieb am 24.05.2007 13:39:53: > Hi, > The following is the mor

RE: src\schema not found

2007-05-22 Thread Thomas Fischer
Hi, Torque 3.2 looks in src/schema for the schema xml files. I have no idea what the corresponding directory was for Torque 3.0 You have two options: - Move the schema files to src/schema - Tell Torque where the schema files are located. There is a generator option for that, I believe it is torque

Antwort: Automatic text length check and truncation

2007-05-22 Thread Thomas Fischer
I do not think it is implemented. Are you sure you want truncation to be the default behaviour ? I'd rather throw an IllegalArgumentException if the String is too long. But this depends on the application, of course. Thomas Federico Fissore <[EMAIL PROTECTED]> schrieb am 22.05.2007 16:02:01:

Re: Criteria to insert into from select?

2007-05-05 Thread Thomas Fischer
Sorry, Torque does not support this (yet? Paches appreciated). Do you know whether it is standard SQL ? I know it works with mysql, but i have no idea about other databases. Thomas On Wed, 18 Apr 2007, Brendan Miller wrote: Here's another Criteria question. Is it possible to express

Re: Torque generator leaves too many files open

2007-05-05 Thread Thomas Fischer
Two short remarks: a) I see you use velocity 1.4. The standard Torque generator 3.2 uses velocity 1.3. I do not know whether this makes a difference, though. b) I believe this is a texen [1] problem. I cannot see how to tell texen to close the file after generating, all we use is the standard $

Versioning in Torque (was: AW: torque vs hibernate)

2007-04-15 Thread Thomas Fischer
On Sat, 7 Apr 2007, Thoralf Rickert wrote: 3)Torque does not contain built-in help for version checking. As a result, this feature will require a custom implementation for future enhancements. I do not understand what that means. Could you explain what they mean by "version checkin"? An example

RE: torque vs hibernate

2007-04-03 Thread Thomas Fischer
This seems to come up every year or so :-) . Comments below. "jill han" <[EMAIL PROTECTED]> schrieb am 02.04.2007 21:42:52: > Recently, a consulting firm evaluated our current > turbine/torque/velocity application. > Here are what they say about Torque, > 1)Torque forces the definition of one-to-o

Re: Criteria.Criterion and Join

2007-04-01 Thread Thomas Fischer
Sorry, join conditions other than equal are not implemented yet. Thomas On Thu, 29 Mar 2007, Youngho Cho wrote: Hello I would like to use join in the Criterion . There is no join related method with Criterion I use CUSTOM like c1 = crit.getNewCriterion(moduleField,

RE: Reserved names in column names

2007-03-21 Thread Thomas Fischer
As far as I recall, the column definitions are not generated by a template but by the Column.getSQLString() method in the generator. You would have to patch the Column object to get the behaviour you want (The `'s will not hurt for the other columns if you always use mysql, but I'm not sure about n

Re: 3.3RC2 Maven2 Plugin usage

2007-03-01 Thread Thomas Fischer
it that directory into scm and then > torque won't overwrite them if they've been altered? > > Thomas Fischer wrote: > > The non-base sources are generated in src/main/java. The base classes are > > generated somewhere in the target directory (I cannot remember the ex

RE: 3.3RC2 Maven2 Plugin usage

2007-03-01 Thread Thomas Fischer
The non-base sources are generated in src/main/java. The base classes are generated somewhere in the target directory (I cannot remember the exact place), and are compiled from there. The configuration you have given seems ok. What exactly is your problem with it ? Thomas "Jeffrey D. Brekke"

RE: 3.3-RC2 Missing POM in maven 2 repo

2007-03-01 Thread Thomas Fischer
Looking at http://mirrors.ibiblio.org/pub/mirrors/maven2/org/apache/db/torque/torque-maven-plugin/3.3-RC2/ the maven 2 plugin pom seems to be there. However, the parent pom is missing: No 3.3-RC2 can be found in http://mirrors.ibiblio.org/pub/mirrors/maven2/org/apache/db/torque/torque/ Thomas,

Re: Torque and SQL Injection

2007-02-23 Thread Thomas Fischer
I'm not completely sure, but I'd think that Torque is protected against SQL injection if one uses it in a regular manner. - Torque does its inserts and updates using prepared statements, so it is the responsibility of the db drivers to protect against sql injection (and that works well, as far as I

RE: Insert using ORACLE systimestamp

2007-02-21 Thread Thomas Fischer
"Brendan Miller" <[EMAIL PROTECTED]> schrieb am 20.02.2007 16:53:28: > 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 do not know an easy way to do so. However, you can use an after insert/update trigger in o

RE: Count of rows updated or deleted?

2007-02-19 Thread Thomas Fischer
"Brendan Miller" <[EMAIL PROTECTED]> schrieb am 15.02.2007 23:36:27: > > Is this feature still missing? I've found a couple mailing list > archives that ask the same thing, but I have not found a response, nor > have I found a flavor of an API that returns the number of affected rows > from an upd

RE: Database independent error trapping.

2007-02-12 Thread Thomas Fischer
I do not remember which one, but either hibernate or spring use the same technique of checking the error code against a map opf known error code and raise an exception corresponding to the error type. So it can be done, but it may require a fair amount of work to collect the error codes from the da

AW: Best practice for entity update.

2007-02-12 Thread Thomas Fischer
We have implemented something similar. What you are asking for is called "optimistic locking" and it is usually done using triggers. See e.g. http://orafaq.com/papers/locking.pdf Our implementation is on oracle 9i: It increases a check column on each update by one. The following sql creates the tr

RE: torque-maven-plugin 3.3-RC1: 'subpackageManager' property -> TorqueException

2007-02-06 Thread Thomas Fischer
Hi, this sounds like a bug. could you please open a jira issue ? http://issues.apache.org/jira/browse/TORQUE Thanks in advance, Thomas "Hidde Boonstra [Us Media]" <[EMAIL PROTECTED]> schrieb am 06.02.2007 14:26:29: > Hi all, > > I'm using the Maven2 torque plugin to generate my obje

RE: Namespace (packageName) by table within schema?

2007-02-02 Thread Thomas Fischer
What you could try to do is to create one schema.xml for every package and use the external-schema xml tag. See one of the schemata of the test project at http://svn.apache.org/viewvc/db/torque/test/trunk/test-project/src/schema/test-schema.xml?revision=475476&view=markup (the @something@ variabl

RE: failed on db object build

2007-02-01 Thread Thomas Fischer
Sorry, cannot help you there. I have never seen this message before. It seems that velocity has trouble parsing the template or generating the output file, but it does not say why :-( As you say you did not change anything, have you tried pulling an old version of the project out of your version c

Re: Torque generate xml scheme and database from Java object

2007-01-31 Thread Thomas Fischer
I am not sure whether I understood your plan correctly. You want to create an xml schema from existing java data classes ? If this is the case, I am afraid that this is not possible. It is possible to create an xml schema from an existing database, but this automatically created schema need manual

Re: no DataSourceFactory configured

2007-01-24 Thread Thomas Fischer
I'd assume you have a new Torque version at compile time but the new 3.3-RC1 torque version at compile time. Make sure you use the same Torque version at compile time and run time. I'm glad the connection issue is solved. I have created an issue about displaying a more interpretable error message i

Re: no DataSourceFactory configured

2007-01-23 Thread Thomas Fischer
Ok, I presume you are using the Torque sample code, so you call Torque.init() with the correct properties file first thing in the application, as Guy remarked. Maybe it's time to step back and try whether you can access the database using plain jdbc. You would use the code Class.forName("org.gjt.m

Re: no DataSourceFactory configured

2007-01-22 Thread Thomas Fischer
a) I do not believe that the torque.properties needs to be in the classpath. The tutorial example code loads it from the file system, as far as I know. b) in your torque.properties, you have set torque.dsfactory.BddPortalCCG.connection.user = which means that there is no user set for your connne

Re: no DataSourceFactory configured

2007-01-22 Thread Thomas Fischer
This usually means that connecting to the database failed. Possible reasons are - the database is not started - the connection url, password or username are wrong in the configuration file Loking at your configuration, I am sure whethet mysql accepts connections without specifying a database user (

Re: Generating code and the Maven2 plugin

2007-01-13 Thread Thomas Fischer
On Mon, 8 Jan 2007, Jeffrey D. Brekke wrote: We have the maven 2 plugin working, but have a question about the location of the generated code. The plugin generates code into the target directory by default and binds to the correct life-cycle in maven2. But if you want to add methods to the g

Re: java.lang.OutOfMemoryError

2006-12-30 Thread Thomas Fischer
An out of memory error is typically very difficult to pinpoint. The place where this error occurs is typically not connected to the place where the problem sits. Personally, I know of two ways of dealing with this - you can have an idea what happens. The answers before have provided situations w

Re: criteria.setCascade(true)

2006-12-18 Thread Thomas Fischer
I have also tried to figure it out once but could not understand what is happening. Because the torque team tried not to make any big changes in the 3.3 release, this was left as it is. Personally, I do not believe it does anything useful. Thomas On Sun, 17 Dec 2006, Markus Daniel wrot

Re: Maven2 Torque plugin and JDBC driver

2006-12-14 Thread Thomas Fischer
You have to state the dependency in the plugin, not in the pom itself. Like this (replacing the variables ${...} by the actual values): org.apache.db.torque torque-maven-plugin ...

RE: torque project compile with ant

2006-12-05 Thread Thomas Fischer
Do not use the schema files and the from the test project as templates for your own project. The schema files from the test project are processed through a filter which replaces the @ tokens. Better start with the examples from the tutorial. Thomas "Aljosa Mohorovic" <[EMAIL PROTECTED]> schr

Re: torque:datadump on oracle 10g

2006-11-26 Thread Thomas Fischer
This is probably a Torque bug. The data import/export functionality for more exotic data types (I'm sad to say this als includes dates and timestamps) does not work well and often it does not work at all. You might want to use dddlutils for that task. http://db.apache.org/ddlutils Thomas

Re: Customizing Object Generation

2006-11-21 Thread Thomas Fischer
The answer below applies, but I believe that in addition, you have to set the generator property torque.useClasspath to false. In torque 3.2, the templates are packaged in an extra jar in the generator, named something like torque-gen-templates.jar In the 3.3 release (the first RC is expected rea

RE: Cache problem after delete

2006-11-18 Thread Thomas Fischer
Ivan, this really sounds as if the transaction in which you delete the data sets is not closed: If you use the same conection to re-read the data (with Torque), the datasets are gone, but if you use another connections, the datasets are still there because the transaction where the delete occu

RE: left or right join in torque

2006-10-19 Thread Thomas Fischer
"Kintzel Levente" <[EMAIL PROTECTED]> schrieb am 19.10.2006 12:57:46: > Hi! > > Is there any possibility to implement LEFT or RIGHT join with Torque? > Yes. Read the docs. http://db.apache.org/torque/releases/torque-3.2 /runtime/reference/read-from-db.html Thomas ---

RE: find or create method using Torque

2006-10-19 Thread Thomas Fischer
Hi, I would be surprised if something like this exists. Cheers, Thomas "David Zhao" <[EMAIL PROTECTED]> schrieb am 18.10.2006 23:51:33: > Hi there, > > Is there a way using peer class in Torque to either retrieve an > existing record's ID or create a new record and return the new ID

AW: Problems to set up a subquery

2006-10-19 Thread Thomas Fischer
> 2nd: I don't think that this solution does not do the job cause > its actually two queries instead of on cascadedone... > > 3rd: Thomas could you please give an example how you'd combine > query and subquery according to this example? > > I really apprec

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

2006-10-17 Thread Thomas Fischer
Hi, I have to admit that I have never used avalon nor do I know the reasoning for separating the TorqueInstance class from the Torque class, so this may be of limited or no value to you. Internally, most (if not all)Torque classes use the Torque.java object to access their configuration. The Torq

RE: Problems to set up a subquery

2006-10-17 Thread Thomas Fischer
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. Another reason is that the compiler checks if the columns you use in your query

Re: inputValidator usage

2006-10-17 Thread Thomas Fischer
Sorry, did not see that Greg already responded to this. Please disregard my last email. Thomas On Tue, 17 Oct 2006, Thomas Fischer wrote: I have not used this tag myself nor did I hear of anybody using it. I am not even sure it works. Sorry, you have to finf out yourself, it seems :-( If

Re: inputValidator usage

2006-10-17 Thread Thomas Fischer
I have not used this tag myself nor did I hear of anybody using it. I am not even sure it works. Sorry, you have to finf out yourself, it seems :-( If you have found out what it does, can you please tell us? Thanks. Thomas On Mon, 16 Oct 2006, Alvaro Coronel wrote: Hello everybody. Can

RE: Problems to set up a subquery

2006-10-16 Thread Thomas Fischer
Hi, Subqueries are implemented and documented in the svn version(3.2.1-dev), but not in Torque 3.2.0. Either build Torque from svn or, if you want to use Torque 3.2.0. you can code the subquery as custom criteria (see http://db.apache.org/torque/releases/torque-3.2 /runtime/reference/read-from-db.

Re: escapeText method in DBOracle

2006-10-08 Thread Thomas Fischer
Would you mind to create a jira issue on that ? Thanks, Thomas On Tue, 3 Oct 2006, Parthasarathy Thandavarayan wrote: Hi all, I have a question regarding the escapeText method in org.apache.torque.adapter.DBOracle class. Unlike the DBMSSQL, DBSybase class this method in DBOracle ret

RE: Oracle - Null and Zero-length string problem

2006-10-08 Thread Thomas Fischer
I'm not so sure whether this is a good thing to do. On the one hand, it is nice if Torque code behaves exactly the same for all databases. On the other hand, someone who is used to write oracle sql can be confused by this. A change like this could break existing applications, if someone relies

Re: getting primary, auto-generated, key with derby and torque-3.2

2006-10-08 Thread Thomas Fischer
Hi Joachim, Derby support was still in the alpha stage when 3.2 was released. In the meantime, I believe it is fully working in svn. I'd recommend a svn pull of the sources from svn trunk and a custom build. As far as I know, there are no large issues open at the moment which have not been in

Thomas Fischer/kn/seitenbau ist außer Haus

2006-10-03 Thread Thomas Fischer
Ich werde ab Fr, 29.09.2006 nicht im Büro sein. Ich kehre zurück am Sa, 07.10.2006. Ich werde Ihre Nachricht nach meiner Rückkehr beantworten. Bei dringenden Fällen wenden Sie sich bitte an Herrn Eichenhofer, Tel. 07531-36598-25 --

Re: innoDB and torque-gen 3.2

2006-09-28 Thread Thomas Fischer
You can also change the configuration file my.conf of the database in question so that tables are created as innoDB per default. Thomas On Thu, 28 Sep 2006, Federico Fissore wrote: you have to recreate the needed files and folders currently contained in torque-gen-templates-3.2.jar if you

RE: Configuring encoding that is used for jdbc connection

2006-09-06 Thread Thomas Fischer
Hi, I do not know of a feature of Torque that allows setting the encoding of characters sent to the database. I would expect one would have to set that inside the database driver. Did you check the Mysql Driver documentation ? Thomas Anton Tonchev <[EMAIL PROTECTED]> schrieb am 06.09.2006 09

RE: Generating SQL from XSD

2006-08-31 Thread Thomas Fischer
This is one of the secret features of Torque that have been hidden from me hitherto. I do not think it exists, but I may be mistaken here. Where did you get that information from ? And what do you mean by "SQL DDL" ? Thomas "Zhang, Andy" <[EMAIL PROTECTED]> schrieb am 31.08.2006 16:38:37: > >

Re: Antwort: heavyIndexing

2006-08-31 Thread Thomas Fischer
the homepage? > > Kind regards > Florian > > Thomas Fischer schrieb: > > Hi, > > > > It does something I cannot imagine anybody needs: If you have composite > > primary keys, it creates an index on every primary key column except the > > first. You do n

Antwort: heavyIndexing

2006-08-31 Thread Thomas Fischer
Hi, It does something I cannot imagine anybody needs: If you have composite primary keys, it creates an index on every primary key column except the first. You do not want to use it. Thomas Florian Hopf <[EMAIL PROTECTED]> schrieb am 31.08.2006 02:51:51: > Hi, > I am wondering what the attri

RE: Writing to the Log File Question

2006-08-10 Thread Thomas Fischer
As far as I know, you need to set the property to an absolute path. Thomas Jim Caserta <[EMAIL PROTECTED]> schrieb am 10.08.2006 16:10:38: > For some reason I am not able to get the log files to > write where I want them to. > > In my log4j.properties file I have tried the > following, but nei

RE: V not Found

2006-08-05 Thread Thomas Fischer
What about the commons-configuration class the stacktrace mentions ? Anything weird about commons-configuration.jar (e.g. not present, supplied by another classloader etc) Thomas On Fri, 4 Aug 2006, Jim Caserta wrote: Hi, I moved my Torque32.jar (which had the AbstractDataSourceFactory c

RE: Evaluating the Torque Generator

2006-08-04 Thread Thomas Fischer
I am afraid to say this, but the part of Torque which creates a schema from jdbc metadata is not the best part of Torque. Although I did not check in detail, most limitations you describe come from the fact that informations are not available in JDBC metadata (although I'm not so sure about discar

RE: Columns are converted to uppercase

2006-07-26 Thread Thomas Fischer
Hi, I get the feeling there is something else quite wrong there (or I do not understand the issue). I have run the torque test project, which contains upper-case and mixed case table names, repeatedly against postgresql 7 and postgresql 8, and it worked perfectly, no quotes in the table name or so

Re: no datasource configured for connection; Torque 3.2 Weblogic 8.1

2006-07-19 Thread Thomas Fischer
Your stack trace says ... at javax.naming.InitialContext.bind(InitialContext.java:355) at org.apache.torque.dsfactory.JndiDataSourceFactory.bindDStoJndi(JndiDataSourceFactory.java:301) ... There is no bind method called on line 301 of JndiDataSourceFactory.java of the Torque 3.2 release. The

RE: IdBroker with sequences in DB2, or perhaps native. How does it work

2006-07-17 Thread Thomas Fischer
Hi, IdBroker is no good for that. It uses an extra table and no sequences. In native, Torque uses fixed names for the sequences it uses. See the create-db sql for the names. Maybe you can rename your existing sequence to fit that name ? In the postgesql howto, there is also a paragraph about non-f

AW: Sybase case insensitive column names

2006-07-17 Thread Thomas Fischer
;ve tested a generated SQL statement on the sybase console > (isql) and it fails if the case is not correct, for example: > > SELECT FROM address WHERE address.CITY="Hamburg" > > failes, but with address.city="..." everything is okay. I think this > c

Re: Sybase case insensitive column names

2006-07-15 Thread Thomas Fischer
Hi, This is strange; the jdbc task should preserve the case of the table and column names (I checked that using mysql; as I do not have a sybase database). The jdbc task uses the DatabaseMetaData from the jdbc driver to get the database; if the database is case sensitive and the DatabaseMetaD

Re: Torque save() method doesnt work for 1 object type..but works for others

2006-07-14 Thread Thomas Fischer
If Torque does not throw an exception, this means that jdbc thinks the changes are committed into the database. Do you do anything from the changes being committed (like passing a db connection to the save method and having set autocommit to false etc.). Or do you have any triggers in the datab

Re: Select Where Max

2006-07-06 Thread Thomas Fischer
Hi, have you tried the following: Criteria criteria = new Criteria(); criteria.add(GalleryPeer.VIEWS, "max(" + GalleryPeer.VIEWS + ")"); List result =GalleryPeer.doSelect(criteria); Thomas "Trevor Miller" <[EMAIL PROTECTED]> schrieb am 06.07.2006 07:46:13: > Hi All, > > I have been scratc

RE: weird problem creating sql suery string from criteria

2006-07-03 Thread Thomas Fischer
d pressed to get > it to break. As it is it happens only once in a while, with the same > code. > > Have, for now, just manually created the SQL statement and the select > the records using Torque. That seems to work every time. > > Steve > > -Original Message

RE: Any Interest in Betwixt Map Templates?

2006-07-02 Thread Thomas Fischer
ue.xslt stuff. It may be a few weeks before I get this submitted. Between a long holiday weekend here in the States + spending a week at the beach the following week, I won't have much time to get it finalized. -----Original Message- From: Thomas Fischer [mailto:[EMAIL PROTECTED] Sent:

Re: Any Interest in Betwixt Map Templates?

2006-06-30 Thread Thomas Fischer
As it is not a core feature of an om mapper and has nothing to do with databases, I'd rather not include this in the generator. However, the template and instructions of how to add it could be added to the website in a "contrib" kind of directory, if that is ok with you. Thomas On Thu, 29

RE: weird problem creating sql suery string from criteria

2006-06-30 Thread Thomas Fischer
ssage- From: Thomas Fischer [mailto:[EMAIL PROTECTED] Sent: Thursday, 29 June 2006 7:19 PM To: Apache Torque Users List Subject: Re: weird problem creating sql suery string from criteria The problem is that count(*) as only select column will not work. Torque neends some hint on which table the s

Re: weird problem creating sql suery string from criteria

2006-06-29 Thread Thomas Fischer
The problem is that count(*) as only select column will not work. Torque neends some hint on which table the select runs on (unfortunately, the peer class does not do that), and it uses the select column name to do that. Have you looked at the CountHelper class in Torque 3.2 ? I'd recommend u

Re: Issue tracking

2006-06-29 Thread Thomas Fischer
Sorry for your inconvenience, you hit an archive. Torque switched its issue tracker recently (after the 3.2 release), which explains the wrong link. How did you find that URL ? Every "official" page should point to http://db.apache.org/torque. Thomas On Thu, 29 Jun 2006, Michael Kaye w

Re: Torque using Tomcat

2006-06-23 Thread Thomas Fischer
Try initializing Torque with an absolute path. To get the absolute path, you can prepend the webroot directory to your relative path. You can get the webroot directory from the servlet container, e.g. String webroot; { // always use slashes, no backslashes webroot = config.getS

Re: DBDesigner Converter

2006-06-17 Thread Thomas Fischer
Although I know a bit about xslt, I do not know anything about dbdesigner. So I can review it if you wish, but I do not think it'll be of much use. Thomas On Sat, 17 Jun 2006, Thomas Vandahl wrote: Thomas Fischer wrote: Thomas, do you think it would be worth while putting it o

Re: DBDesigner Converter

2006-06-17 Thread Thomas Fischer
Thomas, do you think it would be worth while putting it on the website ? or do you think it is difficult to maintain ? Thomas On Fri, 16 Jun 2006, Thomas Vandahl wrote: Trevor Miller wrote: I think the XML conversion would actually be easier to implement using something like XSL. As far a

RE: overriding date format

2006-05-29 Thread Thomas Fischer
This is strange, in the test project dates are read and written and it works allright for mysql. If you want to change Torque's handling of dates, look at the mysql adapter class, DBMM, from the runtime. There, a method getDateString() is called to get a String out of a Date. Thomas "St

RE: Inheritance and additional attributes

2006-05-26 Thread Thomas Fischer
Hi, It is not possible to define additional attributes in the subclasses, nor is it possible to use another table for this. You must declare all members in the one table where all the class hierarchy are saved to. What you can do is to declare the "additional" members als protected, and override t

RE: If you "Struts", how do you validate?

2006-05-22 Thread Thomas Fischer
Hi, 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 and the user screens often do not contain the same data

Re: Torque/Oracle 10 Incrementation problem

2006-05-21 Thread Thomas Fischer
Hi, I'm not sure whether this is possible with the current implementation of the Id generation, which uses two steps. In the first step, Torque gets the id out of the id table (id method idbroker) or sequence (id method native) and in the second step, the insert is done. The only possibility

RE: Using Torque and Turbine with Oracle 9i database

2006-05-05 Thread Thomas Fischer
I have absolutely no experience with Torque 3.0, but this seems to be a problem of the connection pool. No idea whether Torque 3.0 can use dbcp, but if yes, you might want to get the newest dbcp version and configure Torque to use it. Thomas Thib <[EMAIL PROTECTED]> schrieb am 05.05.2006

Move issues from scarab to jira

2006-05-04 Thread Thomas Fischer
Hi everybody, As you might know, we are in the process of moving the issue tracker to jira, because the infrastructure team would like to close down scarab. I'd ask everyone who created an issue in scarab which is still open to create an equicalent issue in jira. That should not be too much wo

RE : Still socket problems

2006-05-04 Thread Thomas Fischer
h page), that automatically "alterate" the Criteria > object used adding setLimit() and setOffset() parameters. > Besides, in the query shown before, I don't see those parameters on > the SQL side, why ? > > Is Torque requesting the entire list and then working with cursors

<    1   2   3   4   5   6   >