RE: maven torque:insert-sql produces errors with oracle

hi! i had the same problem. are you using turbine, too? turbine allocates oracle-scripts in a special folder. i think torque is originally designed for open-source-databases (mysql). oracle has problems with the syntax of the generated scripts. you manipulate them manually and run them in a sql

RE: running a stored procedure or a function

unning a stored procedure or a function > > Have you looked at this? > > http://wiki.apache.org/db-torque/FrequentlyAskedQuestions#head-9af89d84fb1 > c39b1ef310505f7c6e3f4e53976bf > > MG > > -----Original Message- > From: Dressler,Erik(externe MA) [mailto:[EMAIL PROT

running a stored procedure or a function

hello, everybody! i MUST run a stored procedure via torque!!! there are nearly no qualitative results by googling the problem. please check my trials: String sql = "exec test.testprocedure 100, 100, 100, 100, 'SVGIMAGE' "; or String sql = "exec test.testprocedure 100, 100, 100, 100, SVGIMAGE";

criteria-problem

hello, everybody! is it possible to create a criteria for the statement below??? SELECT p.statecode AS Vater, s.statecode AS Nachfolger FROM processstate p, processstate s WHERE s.lft BETWEEN p.lft AND p.rgt AND s.statecode = 'D225' ORDER BY p.lft; i have problems to assign one table two aliase

RE: Problem with doDelete

i can't believe that your old criteria works well with doSelect!!! i had the same problem... ^^ are you able to debug your code and inspect your criteria??? it would be very interesting for me! i think, you must get problems using the add-method on the same column! greets, erik > -Original

RE: IDBroker problems

Jason Harrelson [SMTP:[EMAIL PROTECTED] > > Sent:02 June 2005 04:41 > > To:'Apache Torque Users List' > > Subject: RE: IDBroker problems > > > > I tried this to no avail. Once again the record is added to the table > &

RE: IDBroker problems

ils as it tries to > insert another primary key of 0. > > Thanks for the try. Any other ideas out there? > > -Original Message- > From: Dressler,Erik(externe MA) [mailto:[EMAIL PROTECTED] > Sent: Friday, May 27, 2005 5:48 AM > To: 'Apache Torque Users List&#x

RE: IDBroker problems

i think i can help you! look at this row: defaultIdMethod="idBroker"> xml is case sensitive. you have to write: defaultIdMethod="idbroker"> good luck, drezze > -Original Message- > From: Jason Harrelson [SMTP:[EMAIL PROTECTED] > Sent: 27 May 2005 04:33 > To: torque-user@db.apache.or

RE: torque and intersect

However, if you already have the two resultsets in > memory, it might be more performant to compute the differences by hand > using List.contains() and overriding the equals() method of the objects. > > Thomas > > "Dressler, Erik(externe MA)" <[EMAIL PRO

RE: Another problem

hello, jakub! i'm using oracle. i put the jdbc-driver in following folders: maven_repository/jdbc torque_home/lib tomcat_home/common/lib i'm not sure, if it is neccessary to put the driver in all folders, but try it. greetz, erik > -Original Message- > From: Jakub Piechnik [SMTP:[EMAI

torque and intersect

hello! i have two resullists from two different selects. is it possible to get the intersection of these selects via torque? if the answer is yes, please give me a hint! greets, erik * * * * * * D I S C L A I M E R * * * * * * * This message is confidential and intended for the

RE: Table definition with double relation.... help me

> -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] > Sent: 11 May 2005 10:39 > To: torque-user@db.apache.org > Subject: Table definition with double relation help me > Importance: High > > How do we do in the xxx-schema.xml when a table calls another and

RE: criteria and criterion

sorry for unnecessary emails! problem is solved! > -Original Message- > From: Dressler, Erik(externe MA) > Sent: 09 May 2005 18:06 > To: 'Apache Torque Users List' > Subject: criteria and criterion > > > hi! > > it's me again!!! >

criteria and criterion

hi! it's me again!!! i have to build a criteria-object, but i do not know, how much where-clauses i have to add. it differs as the case arises. the select statement could look like this: select max(value) from testtable where (column1 = 1 and column2 = 1000) or (column1 = 2 and column2 = 1000)

RE: torque and subqueries

m it. For > this, you would have to edit the db create sql script by hand. > > Thomas > > "Dressler, Erik(externe MA)" <[EMAIL PROTECTED]> schrieb am > 09.05.2005 15:56:16: > > > > > hi, folks! > > > > is it possible, to map subquer

torque and subqueries

hi, folks! is it possible, to map subqueries with torque? if the answer is yes, please tell me how!!! :D greetz, erik dressler * * * * * * D I S C L A I M E R * * * * * * * This message is confidential and intended for the named addressee(s) only. If you are not the intended rec

torque and xmltype

hi, everybody! i'm using torque 3.1.1 and oracle 9i. in my project-schema.xml-file i tried to declare a column as a "xmltype"-column. the "maven torque"-goal failed. is it anyhow possible to use the "new" datatype "xmltype" with torque? greetz, erik * * * * * * D I S C L A I M E R * *

RE: oracle 9i and torque

er, if you look at > http://jakarta.apache.org/commons/dbcp/configuration.html > you can find all the properties of the new pool. > > It might also be that Turbine passes the wrong properties to Torque, but I > have no experience with Turbine, so I cannot help you there. > &g

RE: oracle 9i and torque

que > > > > > > 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 PRO

oracle 9i and torque

hello, everybody! i have a big problem! i wasted days of my life trying to get turbine, torque and oracle started! i'm a little bit confused now. so i need your help!!! i'm using: turbine 2.3.1 torque 3.1.1 oracle 9i java 1.4 tomcat 5.0.28 maven 1.0.2 my build.properties: # ---