Re: get the SQL to be executed

[Ivano Luberti]

Greg, the problem for me is exactly how to build.
I wanted to avoid buildig them by hand (ie: get the values of all the
field and combining them into a java String or StringBuffer).
But thank you  anyway for the suggestion: if I end up for manually
building statements , now I have a good location where to place my mehtods.
Even though also peer classes can be used for that, couldn't be?



Il 19/01/2012 19:19, Greg Monroe ha scritto:
> Or, if the info you're exporting maps to your Torque app's 
> tables, you could probably just add "toSQL()" methods to
> the record stubs that creates the INSERT statements.
>
> E.g. if you have a User record object, modify the User.java
> Torque created with something like:
>
> Public String toSQL() {
>StringBuffer sql = new StringBuffer;
>
> // Build SQL statement from current object contents
>
>return sql.toString();
> }
>
> Then just do a normal Torque query to get the data you're 
> interested in and loop thru the results calling toSQL to 
> create your output file.
>
> Note that once the "stub" classes are built, Torque will not
> replace them if your regenerate the code. So the toSQL() code 
> is safe.
>
> It would also be possible to create some generic Torque record to
> SQL code by using the "map" information.  This lets you determine
> the column info in a table.  So you could look up the table info 
> for a record object, then create the sql by iterating over the 
> column names and using the column type to determine the string 
> format to use.
>
> But for a few table objects, it might be easier to just do the 
> manually created toSQL() methods.
>
> -Original Message-
> From: Thomas Vandahl [mailto:t...@apache.org] 
> Sent: Thursday, January 19, 2012 12:51 PM
> To: Apache Torque Users List
> Subject: Re: get the SQL to be executed
>
> On 19.01.12 18:38, Ivano Luberti wrote:
>> Thanks all for your responses.
>> Just to clarify, I need to generate sql commands inside my code to
>> generate a file that can be used by another software (not written by me)
>> to import data.
>>
>> I would like not to execute commands but only write them (because this
>> is what I need).
>> If I cannot find alternatives, I can execute them and use one of the
>> logging facilities that have been suggested.
> Well, inserts are sort of tricky because the actual SQL generation
> happens deep inside Village. If you have control over your class loader,
> you may modify a copy of the com.workingdogs.village.Record class and
> put that first in the chain. Look for the saveWithInsert() method. This
> is probably the closest you can get, IMHO.
>
> Bye, Thomas.
>
> -
> To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
> For additional commands, e-mail: torque-user-h...@db.apache.org
>
> DukeCE Privacy Statement:
> Please be advised that this e-mail and any files transmitted with
> it are confidential communication or may otherwise be privileged or
> confidential and are intended solely for the individual or entity
> to whom they are addressed. If you are not the intended recipient
> you may not rely on the contents of this email or any attachments,
> and we ask that you please not read, copy or retransmit this
> communication, but reply to the sender and destroy the email, its
> contents, and all copies thereof immediately. Any unauthorized
> dissemination, distribution or copying of this communication is
> strictly prohibited.
>
> -
> To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
> For additional commands, e-mail: torque-user-h...@db.apache.org
>
>

-- 
==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==


-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: get the SQL to be executed

[Ivano Luberti]

Thanks all for your responses.
Just to clarify, I need to generate sql commands inside my code to
generate a file that can be used by another software (not written by me)
to import data.

I would like not to execute commands but only write them (because this
is what I need).
If I cannot find alternatives, I can execute them and use one of the
logging facilities that have been suggested.

Il 19/01/2012 16:05, Greg Monroe ha scritto:
> If you are trying to generate an initial data scripts rather
> than a "audit log", you might look at the dumpdata and datasql
> tasks that Torque supplies.  I have used these to create 
> initial data sets that applications need (e.g. initial user
> entry, rights entry, etc.)
>
> If you need to do this inside the code, you might look at
> the apache ddlutils project db.apache.com/ddlutils.  This has
> some code callable functions to generate various SQL scripts.
>
> If you don't need SQL, but are really looking for a way to 
> export/import data between Torque applications, look at
> sf.net/projects/torque-addons.  This has a framework for 
> easily creating XML exports of records.  You may need to
> write some record handler code to deal with foreign keys.
>
> Greg 
>
> -Original Message-
> From: Joe Carter [mailto:joe.car...@gmail.com] 
> Sent: Thursday, January 19, 2012 3:32 AM
> To: Apache Torque Users List
> Subject: Re: get the SQL to be executed
>
> You can use a logging driver such as p6spy to see your SQL statements.
> http://sourceforge.net/projects/p6spy/
>
> On 19 January 2012 08:25, Thomas Fox  wrote:
>> Perhaps you can use the log output (with some tweaks to the log4j
>> configuration). However I'm not sure how and if Torque 3.3 logs the update
>> statements. But then again I've heard of drivers which at as a bridge
>> between the application and the real driver (e.g
>> http://www.squirrelsql.org/) and which can do the logging for you.
>>
>> Torque 4 will not work because it uses prepared statements for updates,
>> this will not give you any sensible sql.
>>
>>Thomas
>>
>>> Hello all, is there a way in Torque to get the SQL that is sent to the
>> DB.
>>> I have to generate a txt file where I save queries basically INSERT
>>> statements of long records.
>>> I was thinking of create the Torque classes, populate the objects with
>>> data that I get from a local instance of the DB and then, instead of
>>> using a save command, get the SQL that would be executed and store it in
>>> a file.
>>>
>>> Alternatively I could use this:
>>>
>>> http://openhms.sourceforge.net/sqlbuilder/
>>>
>>> but has dependencies that requires GPL license and I would avoid in this
>>> case that kind of license.
>>
>> -
>> To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
>> For additional commands, e-mail: torque-user-h...@db.apache.org
>>
> -
> To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
> For additional commands, e-mail: torque-user-h...@db.apache.org
>
> DukeCE Privacy Statement:
> Please be advised that this e-mail and any files transmitted with
> it are confidential communication or may otherwise be privileged or
> confidential and are intended solely for the individual or entity
> to whom they are addressed. If you are not the intended recipient
> you may not rely on the contents of this email or any attachments,
> and we ask that you please not read, copy or retransmit this
> communication, but reply to the sender and destroy the email, its
> contents, and all copies thereof immediately. Any unauthorized
> dissemination, distribution or copying of this communication is
> strictly prohibited.
>
> -
> To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
> For additional commands, e-mail: torque-user-h...@db.apache.org
>
>

-- 
==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==


-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

get the SQL to be executed

[Ivano Luberti]

Hello all, is there a way in Torque to get the SQL that is sent to the DB.
I have to generate a txt file where I save queries basically INSERT
statements of long records.
I was thinking of create the Torque classes, populate the objects with
data that I get from a local instance of the DB and then, instead of
using a save command, get the SQL that would be executed and store it in
a file.

Alternatively I could use this:

http://openhms.sourceforge.net/sqlbuilder/

but has dependencies that requires GPL license and I would avoid in this
case that kind of license.



-- 
==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==


-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: Info about Torque

[Ivano Luberti]

I have developed a software now in production using Torque 3.3 and it
has been quitre strigthforward and efficient. Also integration in web
dev framework (Tapestry) has been strightforward.

I have to apologize with the developers: it was my intention to
participate to dev work of the 4 version this year, but it has just been
impossible and I don't see a change of scenario in the near future.

Il 17/09/2010 20.57, Frank Nguyen ha scritto:
> I have been running Torque 3.1 (Tomcat 4.x, MySQL, Linux) on production 
> system 
> since 2006 and it worked perfectly fine.
>  Frank Nguyen
>
>
>
> 
> From: Anas Mughal 
> To: Apache Torque Users List 
> Sent: Fri, September 17, 2010 11:42:37 AM
> Subject: RE: Info about Torque
>
> Thomas,
>
> The Torque project is pretty solid and worked very well for us on a medium 
> size 
> project (59 tables with many joins).
>
> Good luck.
>
>
>
> -Original Message-
> From: Thomas Fischer [mailto:fisc...@seitenbau.net] 
> Sent: Friday, September 17, 2010 2:25 AM
> To: Apache Torque Users List
> Subject: Re: Info about Torque
>
>   
>> I want to use Torque, but I want to hnow: the project still alive?
>> 
> The project is still alive. The current production version is 3.3. There is
> a tutorial available on the web site (
> http://db.apache.org/torque/releases/torque-3.3/tutorial/index.html), this
> might help you to get started.
>
>   
>> In this case, when version 4.0 will be released?
>> 
> There is no definite plan, and as always this depends on available time,
> but I very much doubt 4.0 will happen this year.
>
> Thomas
>
>
> -
> To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
> For additional commands, e-mail: torque-user-h...@db.apache.org
>
>
> -
> To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
> For additional commands, e-mail: torque-user-h...@db.apache.org
>   

-- 
==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==


-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: [OT:Torque 4.0] Re: Criteria.or not working?

[Ivano Luberti]

Good to hear there is some movement in the Torque ecosystem
I have used Torque 3.3 with good satisfaction to develop a web
application from scratch and I plan, if my company  can fund this
activities, to port all of my  company software db related under Torque.

I don't know if I'm enough experienced as a developer or DB in
comparison with Torque team standard but I would like to find a way to
contribute.

Let me know if this makes sense



Thomas Fischer ha scritto:
>> 4.0?
>> I was fearing Torque was a dead project?
>> Any time table?
>> 
>
> Work is under way to rebuild the generator and the templates such that it
> should be mich easier in the future to extend or customize the generated
> code. Work on this is in good progress, so one should be able to try it (at
> least from SVN) in two or three months time scale.
>
> Nothing much has yet happened in the runtime, I fear that discussions about
> how the runtime should look like in the future will be difficult and
> resources are scare, so my personal estimate is a year.
>
> Thomas
>
>
> -
> To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
> For additional commands, e-mail: torque-user-h...@db.apache.org
>
>
>   

-- 
==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==



-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: Criteria.or not working?

[Ivano Luberti]

4.0?
I was fearing Torque was a dead project?
Any time table?

Greg Monroe ha scritto:
> Whoops, looked at the code and I think my answer was wrong.  The 
> code is actually behaving as documented.  E.g. the docs say:
>
> "This method adds a new criterion to the list of criterias. If a
>  criterion for the requested column already exists, it is
>  "OR"ed to the existing criterion"
>
> You are using two different columns in the or statements.  Therefore,
> they are being treated as an add and not an or condition for each
> column.
>
> Not intuitive, but correctly documented. Sigh. Use the criterion 
> method to create mix column or statements.
>
> FWIW, the underlying cause is that criteria object was initially
> created under Java 1.2 or 1.3 and all the Collections interfaces
> where not defined.  So it is based on Hashtable.  This has caused 
> some long term issues like this.  One of the goals of the 4.0 
> version is to replace this with a HashList.  This will allow 
> looking at the last added criterion and applying conditionals to 
> it.  
>
>   
>> -Original Message-
>> From: Greg Monroe
>> Sent: Friday, February 05, 2010 9:35 AM
>> To: 'Apache Torque Users List'
>> Subject: RE: Criteria.or not working?
>>
>> I think the proper syntax would be to "add" the left hand operator
>> and then or the conditional with this.  Rather than 2 ors which
>> are right hand conditionals. E.g., the proper syntax would be:
>>
>> Criteria criteria = new Criteria();
>> criteria.add("user.first_name", "John");
>> criteria.or("user.last_name", "Doe");
>> UserPeer.doSelect(criteria);
>>
>> The syntax using two the .or methods is like trying to write an SQL
>> statement like:
>>
>> Select * from user where or user.first='John' or user.last='Doe';
>>
>> The SQL parser would choke on this.  I suspect the code is assuming
>> that since there is no right hand conditional the or should be treated
>> as an and statement. E.g. "Null or X" is translated to just X.   It
>> probably should throw an invalid syntax error here.
>>
>> FWIW, using Criterion is really only "required" if you are using the
>> same column or need parenthetical nesting.
>>
>>
>> 
>>> -Original Message-
>>> From: Ivano Luberti [mailto:lube...@archicoop.it]
>>> Sent: Friday, February 05, 2010 9:08 AM
>>> To: Apache Torque Users List
>>> Subject: Re: Criteria.or not working?
>>>
>>> Sorry never tried that, I only now that is not the way the Criteria
>>> class is meant to be used.
>>> So I let developers talk about that.
>>> Alternatively you can dig into the peer classes source code: I have
>>>   
>> done
>> 
>>> a few times to understand Torque behaviour and is quite well written
>>>   
>> and
>> 
>>> readable
>>>
>>> Ludwig Magnusson ha scritto:
>>>   
>>>> Yes that works, but that was not what I asked.
>>>> My question was, how can the methods and(), add() and or() all
>>>> 
>> generate
>> 
>>> the
>>>   
>>>> same result?
>>>>
>>>> -Original Message-
>>>> From: Ivano Luberti [mailto:lube...@archicoop.it]
>>>> Sent: den 5 februari 2010 14:10
>>>> To: Apache Torque Users List
>>>> Subject: Re: Criteria.or not working?
>>>>
>>>> If you want to combine clauses mixinn and and or operators you should
>>>> use Criterion.
>>>>
>>>> Look here for an introduction to how build queries using Criteria and
>>>> Criterion
>>>>
>>>> http://db.apache.org/torque/releases/torque-
>>>> 
>> 3.3/runtime/reference/read-
>> 
>>> from-
>>>   
>>>> db.html
>>>>
>>>> Ludwig Magnusson ha scritto:
>>>>
>>>> 
>>>>> Hi!
>>>>>
>>>>> I have done some testing during development of a project here and it
>>>>>   
>>> seems
>>>   
>>>>> that criteria.and([parameters]), criteria.add([parameters]) and
>>>>> criteria.or([parameters]) all generate the same query to the
>>>>>   
>> database.
>> 
>>>>>
>>>>> E.g these three code snippets:
>

Re: Criteria.or not working?

[Ivano Luberti]

Sorry never tried that, I only now that is not the way the Criteria
class is meant to be used.
So I let developers talk about that.
Alternatively you can dig into the peer classes source code: I have done
a few times to understand Torque behaviour and is quite well written and
readable

Ludwig Magnusson ha scritto:
> Yes that works, but that was not what I asked.
> My question was, how can the methods and(), add() and or() all generate the
> same result?
>
> -Original Message-
> From: Ivano Luberti [mailto:lube...@archicoop.it] 
> Sent: den 5 februari 2010 14:10
> To: Apache Torque Users List
> Subject: Re: Criteria.or not working?
>
> If you want to combine clauses mixinn and and or operators you should
> use Criterion.
>
> Look here for an introduction to how build queries using Criteria and
> Criterion
>
> http://db.apache.org/torque/releases/torque-3.3/runtime/reference/read-from-
> db.html
>
> Ludwig Magnusson ha scritto:
>   
>> Hi!
>>
>> I have done some testing during development of a project here and it seems
>> that criteria.and([parameters]), criteria.add([parameters]) and
>> criteria.or([parameters]) all generate the same query to the database.
>>
>>  
>>
>> E.g these three code snippets:
>>
>> Criteria criteria = new Criteria();
>>
>> criteria.and("user.first_name", "John");
>>
>> criteria.and("user.last_name", "Doe");
>>
>> UserPeer.doSelect(criteria);
>>
>>  
>>
>> Criteria criteria = new Criteria();
>>
>> criteria.add("user.first_name", "John");
>>
>> criteria.add("user.last_name", "Doe");
>>
>> UserPeer.doSelect(criteria);
>>
>>  
>>
>> Criteria criteria = new Criteria();
>>
>> criteria.or("user.first_name", "John");
>>
>> criteria.or("user.last_name", "Doe");
>>
>> UserPeer.doSelect(criteria);
>>
>>  
>>
>> . would all generate the Sql query
>>
>> SELECT * FROM USER WHERE first_name = "John" AND last_name = "Doe";
>>
>>  
>>
>> How can this be?
>>
>> /Ludwig
>>
>>
>>   
>> 
>
>   

-- 
==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==


-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: Criteria.or not working?

[Ivano Luberti]

If you want to combine clauses mixinn and and or operators you should
use Criterion.

Look here for an introduction to how build queries using Criteria and
Criterion

http://db.apache.org/torque/releases/torque-3.3/runtime/reference/read-from-db.html

Ludwig Magnusson ha scritto:
> Hi!
>
> I have done some testing during development of a project here and it seems
> that criteria.and([parameters]), criteria.add([parameters]) and
> criteria.or([parameters]) all generate the same query to the database.
>
>  
>
> E.g these three code snippets:
>
> Criteria criteria = new Criteria();
>
> criteria.and("user.first_name", "John");
>
> criteria.and("user.last_name", "Doe");
>
> UserPeer.doSelect(criteria);
>
>  
>
> Criteria criteria = new Criteria();
>
> criteria.add("user.first_name", "John");
>
> criteria.add("user.last_name", "Doe");
>
> UserPeer.doSelect(criteria);
>
>  
>
> Criteria criteria = new Criteria();
>
> criteria.or("user.first_name", "John");
>
> criteria.or("user.last_name", "Doe");
>
> UserPeer.doSelect(criteria);
>
>  
>
> . would all generate the Sql query
>
> SELECT * FROM USER WHERE first_name = "John" AND last_name = "Doe";
>
>  
>
> How can this be?
>
> /Ludwig
>
>
>   

-- 
==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==


-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: multiple criteria on the same field

[Ivano Luberti]

Thanks  Andreas and Greg .
I knew about this features, but I was misleaded by the fact that adding
to criteria in the other way wouldn't work even with an "or" operator.

I should have understood it anyway.



Greg Monroe ha scritto:
> For more information see the documentation at:
>
> http://db.apache.org/torque/releases/torque-3.3/runtime/reference/read-from-db.html#AND_and_OR_operators
>
>
>   
>> -Original Message-
>> From: Andras Balogh [mailto:and...@reea.net]
>> Sent: Friday, May 08, 2009 5:52 AM
>> To: Apache Torque Users List
>> Subject: Re: multiple criteria on the same field
>>
>> Hi,
>>
>> You need to do something like:
>>
>> criteria.add( dataIscrizioneInizio.and(dataIscrizioneFine)  ) ;
>>
>> to add both Criterions in the same time to the Criteria.
>>
>> Best regards,
>> Andras
>>
>>
>> Ivano Luberti wrote:
>> 
>>> Hello , I have searched the ml and googled for this.
>>> I have found 2 old email asking for this but with no answer.
>>>
>>> When I try to do this :
>>>
>>> Criteria criteria = new Criteria();
>>> Criterion dataIscrizioneInizio =
>>> criteria.getNewCriterion(IscrizioniSocioPeer.TABLE_NAME, "starttime",
>>> (Date) (formUser.getDataIscrizioneInizio()), Criteria.GREATER_EQUAL);
>>>
>>>
>>> dataIscrizioneInizio.setIgnoreCase(true);
>>>
>>> criteria.add(dataIscrizioneInizio);
>>>
>>> Criterion dataIscrizioneFine =
>>> criteria.getNewCriterion(IscrizioniSocioPeer.TABLE_NAME, "starttime",
>>> (Date) (formUser.getDataIscrizioneFine()), Criteria.LESS_EQUAL);
>>>
>>> dataIscrizioneFine.setIgnoreCase(true);
>>>
>>> criteria.add(dataIscrizioneFine);
>>>
>>> Only the last criterion is included in the where clause.
>>>
>>> I have stepped into the add(Criterion) method of the Criteria class and
>>> found this:
>>>
>>> public Criteria add(Criterion c)
>>> {
>>> StringBuffer sb = new StringBuffer(c.getTable().length()
>>> + c.getColumn().length() + 1);
>>> sb.append(c.getTable());
>>> sb.append('.');
>>> sb.append(c.getColumn());
>>> super.put(sb.toString(), c);
>>> return this;
>>> }
>>>
>>> If I understand well , the map keys are based on the table and field
>>> names then it is not possible to add two criteria on the same field to
>>> produce sql like:
>>>
>>> SELECT * FROM table WHERE table.field>x AND table.field>>
>>> Can someone suggest the best practice to do this with Torque ?
>>>
>>>
>>>
>>>   
>> -
>> To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
>> For additional commands, e-mail: torque-user-h...@db.apache.org
>>
>> 
>
> DukeCE Privacy Statement:
> Please be advised that this e-mail and any files transmitted with
> it are confidential communication or may otherwise be privileged or
> confidential and are intended solely for the individual or entity
> to whom they are addressed. If you are not the intended recipient
> you may not rely on the contents of this email or any attachments,
> and we ask that you please not read, copy or retransmit this
> communication, but reply to the sender and destroy the email, its
> contents, and all copies thereof immediately. Any unauthorized
> dissemination, distribution or copying of this communication is
> strictly prohibited.
>
> -
> To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
> For additional commands, e-mail: torque-user-h...@db.apache.org
>
>
>   

-- 
==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==



-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

multiple criteria on the same field

[Ivano Luberti]

Hello , I have searched the ml and googled for this.
I have found 2 old email asking for this but with no answer.

When I try to do this :

Criteria criteria = new Criteria();
Criterion dataIscrizioneInizio =
criteria.getNewCriterion(IscrizioniSocioPeer.TABLE_NAME, "starttime", 
(Date) (formUser.getDataIscrizioneInizio()), Criteria.GREATER_EQUAL);   
  

dataIscrizioneInizio.setIgnoreCase(true);   

criteria.add(dataIscrizioneInizio);

Criterion dataIscrizioneFine =
criteria.getNewCriterion(IscrizioniSocioPeer.TABLE_NAME, "starttime", 
(Date) (formUser.getDataIscrizioneFine()), Criteria.LESS_EQUAL);   

dataIscrizioneFine.setIgnoreCase(true);   

criteria.add(dataIscrizioneFine);

Only the last criterion is included in the where clause.

I have stepped into the add(Criterion) method of the Criteria class and
found this:

public Criteria add(Criterion c)
{
StringBuffer sb = new StringBuffer(c.getTable().length()
+ c.getColumn().length() + 1);
sb.append(c.getTable());
sb.append('.');
sb.append(c.getColumn());
super.put(sb.toString(), c);
return this;
}

If I understand well , the map keys are based on the table and field
names then it is not possible to add two criteria on the same field to
produce sql like:

SELECT * FROM table WHERE table.field>x AND table.field

possible bug in Torque3.3 using two databases

[Ivano Luberti]

Hello, I think I have discovered a possible bug in Torque3.3 run time.
My code does the following (simplilfied):

1) select some records from table1 in db1 using table1Peer.doSelect
(Criteria)

2) import some of those records in table2 in db2 (default db set into
Torque.properties)

3) update the record the have been imported in table1 db1 using
table1Peer.doUpdate(whereC,updateC);

Step 3) fails with a null pointer exception.
The null pointer is generated by line 1676 of BasePeer.java

 ColumnMap[] columnMaps = dbMap.getTable(table).getColumns();

because dbMap.getTable(table) is null.

the table is obtained using the same peer class used at the step 1)
however I have noticed that at line 1667

DatabaseMap dbMap = Torque.getDatabaseMap(dbName);

has the dbName set to db2 and not db1.

Going deeper into the code I have noticed that during execution of step
1) is called

BaseTable1Peer.setDbName(Criteria crit) and changes from db2 to db1 the
dbname set into criteria by default (that is I believe the default db
set into Torque.properties)

The same method is not called at step3.

I have worked around this setting explicitly the dbname of whereC and
updateC used at step 3 , but it seems to me this is indeed a bug.


-- 
==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==


-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: newbie question about postgres: nextval

[Ivano Luberti]

Another little question about one of your suggestion.
Remeber I use jdbc task to generate chema.xml file from the db.


Greg Monroe ha scritto:
> In general, for autoincrement id fields coming out of the JDBC task, 
> you will need to decide which method to use with automatic id fields. 
> This is done via the defaultIdMethod attribute on the database tag  or 
> the idMethod attribute on the specific table tag.  The choices are 
> idbroker (Torque's works everywhere method), native (the DB server's 
> native method) or none.  In your case, you want native.
> Next you will need to identify the autoincrement fields and modify
> them to include the autoincrement="true" attribute and drop any
> default values.
>
>   
Ok, but what is the default value for defaultIdMethod and for idMethod ?
Moreover is there a way to tell JDBCTransformTask to put the right value
in the schema file ?
In other words: can jdbc task be configured to follow this behaviour ?


-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: jdbc task put username instead of db name in schema file

[Ivano Luberti]

I have never meant this: I was only surprised you have been so
responsive on the mailing list and that there was no activity on jira.
Moreover I was surprised to find the issue already set and so old after
you had asked me to report it.

No problem, anyway.




Thomas Fischer ha scritto:
>> Sorry to come back on this issue: I have updated the TORQUE-39 issue on
>> jira but I have seen no answer to the observations I have added to the
>> initial ones.
>> I report here the link to the issue for whoever is interested:
>> 
>
> Hey, this is no commercial product where we meet deadlines. It will 
> probably be in the next release, whenever this will be. If someone 
> provides a patch, this probability will even be higher.
>
>Regards,
>
>Thomas
>   

-- 
==
Archimede Informatica NEWS!
==

Realizzato il Sistema Integrato per la biglietteria della Torre di Pisa:
prenotazione, vendita, pre-vendita ed emissione dei biglietti di ingresso
alla Torre sia online che presso le biglietterie dislocate sulla piazza:

_http://www.opapisa.it/boxoffice

_Partner del Progetto Ci-Tel "Front office Telematico per il cittadino"
Ente Coordinatore Comune di Pisa

_http://www.comune.pisa.it/doc/e-government.htm


_==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
e-mail: archim...@archicoop.it
web: _http://www.archicoop.it


_ __ 

-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: jdbc task put username instead of db name in schema file

[Ivano Luberti]

Sorry to come back on this issue: I have updated the TORQUE-39 issue on
jira but I have seen no answer to the observations I have added to the
initial ones.
I report here the link to the issue for whoever is interested:

https://issues.apache.org/jira/browse/TORQUE-39







Thomas Fischer ha scritto:
>> h, but then why make the torque user able to specify the
>>
>> torque.database.name
>>
>> property in build.properties ?
>> 
>
> correct, I overlooked that back then. Please create a jira issue.
>
>   

_
_ __ 

-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

generate omn classes only for a subset of tables

[Ivano Luberti]

Is there a way to configure Torque generator so that it generates om
classes only for a subset of the tables in a db ?
I will use the ability of torque tu support multiple database to import
some data from a secondary db, but I need to use only a small subset of
tables (5 out of 40+)  of the whole db.
I will get metadata from a MySQL db and the filter should be set either
for the jdbc task or for the om task.






-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: jdbc task put username instead of db name in schema file

[Ivano Luberti]

I certainly will, thanks

Thomas Fischer ha scritto:
>> h, but then why make the torque user able to specify the
>>
>> torque.database.name
>>
>> property in build.properties ?
>> 
>
> correct, I overlooked that back then. Please create a jira issue.
>
>  Thomas
>   

_
_ __ 

-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: jdbc task put username instead of db name in schema file

[Ivano Luberti]

h, but then why make the torque user able to specify the

torque.database.name

property in build.properties ?

Thomas Fischer ha scritto:
>> When we tried at first to generate the schema file using the jdbc task,
>> we found that the database name put in the schema file was wrong.
>> Instead of the db name there was the  username used to connect to the 
>> 
> db.
>   
>> We worked around it changing the username.
>>
>> We use Torque 3.3
>> The DB server is postgres8.3
>> The jdbc driver is postgresql-8.3-603.jdbc4.jar
>> 
>
> There was a discussion way back on the user list (or maybe even in jira) 
> of how the database should be named by the jdbc task. And the outcome was: 
> how should the generator know ? Not every database has the concept of a 
> database name. And jdbc won't provide that information anyway. So using 
> the user name seems a sensible default.
>
> Maybe we should look into a way of automatically postprocessing the schema 
> after the jdbc task.
>
>Thomas
>   

-- 
==
Archimede Informatica NEWS!
==

Realizzato il Sistema Integrato per la biglietteria della Torre di Pisa:
prenotazione, vendita, pre-vendita ed emissione dei biglietti di ingresso
alla Torre sia online che presso le biglietterie dislocate sulla piazza:

_http://www.opapisa.it/boxoffice

_Partner del Progetto Ci-Tel "Front office Telematico per il cittadino"
Ente Coordinatore Comune di Pisa

_http://www.comune.pisa.it/doc/e-government.htm


_==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
e-mail: archim...@archicoop.it
web: _http://www.archicoop.it


_ __ 

-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

jdbc task put username instead of db name in schema file

[Ivano Luberti]

When we tried at first to generate the schema file using the jdbc task,
we found that the database name put in the schema file was wrong.
Instead of the db name there was the  username used to connect to the db.
We worked around it changing the username.

We use Torque 3.3
The DB server is postgres8.3
The jdbc driver is postgresql-8.3-603.jdbc4.jar


_
_ __ 

-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: newbie question about postgres: nextval

[Ivano Luberti]

Thank you Greg I have found the docs on schema files.
For what it worths, I will put my 2 cents on the Torque vs Hibernate matter.
Usually you don't want to overwrite your sql if you are not in the early
steps of db development: you change the DDL saving the data in some way.
The utility of software like torque is greater when you are in an
advanced stage of development and it saves a loto of time in modifying
java code.
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 the schema
file and not only the sql it would be great.






Greg Monroe ha scritto:
> FYI - Schema docs are under the Generator tab.  As to the 
> Torque vs Hibernate, I agree with what Thomas said and would 
> add the following:
>
> Hibernate is supported and "marketed" by Redhat/JBoss (a
> great deal initially, but now it's a community thing). In 
> addition, they designed it on better "buzz words". E.g., it's 
> Enterprise Middle-ware designed to let programmers implement 
> business logic that is supported be a variety of back-end 
> including full blown EJB application environments (like JBoss).
>
> By contrast, IMHO, Torque is designed as a RAD tool focused 
> on making JDBC simple for programmers.  So they can get on 
> with writing business logic and not worry about many of the
> fiddly persistence details. Not only that but it is designed
> to help make long term maintenance easier.  For example: by 
> using complier constants to help identify column name changes;
> A single XML schema file that can be updated as tables change
> and re-generate the access objects; and the like.
>
>   
>> -Original Message-
>> From: Thomas Fischer [mailto:fisc...@seitenbau.net]
>> Sent: Monday, January 26, 2009 12:22 PM
>> To: Apache Torque Users List
>> Subject: Re: newbie question about postgres: nextval
>>
>> 
>>> 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
>> and Hibernate does all the persistence work.
>>
>> But it not an performance issue. As you have total control over what the
>> database does, you have more optimisation potential in Torque than in
>> Hibernate. Maybe in some special cases it is more work to optimize Torque
>> application, but it is certainly feasible.
>>
>> Thomas
>> 
> DukeCE Privacy Statement:
> Please be advised that this e-mail and any files transmitted with
> it are confidential communication or may otherwise be privileged or
> confidential and are intended solely for the individual or entity
> to whom they are addressed. If you are not the intended recipient
> you may not rely on the contents of this email or any attachments,
> and we ask that you please not read, copy or retransmit this
> communication, but reply to the sender and destroy the email, its
> contents, and all copies thereof immediately. Any unauthorized
> dissemination, distribution or copying of this communication is
> strictly prohibited.
>
> -
> To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
> For additional commands, e-mail: torque-user-h...@db.apache.org
>
>
>   

-- 
==
Archimede Informatica NEWS!
==

Realizzato il Sistema Integrato per la biglietteria della Torre di Pisa:
prenotazione, vendita, pre-vendita ed emissione dei biglietti di ingresso
alla Torre sia online che presso le biglietterie dislocate sulla piazza:

_http://www.opapisa.it/boxoffice

_Partner del Progetto Ci-Tel "Front office Telematico per il cittadino"
Ente Coordinatore Comune di Pisa

_http://www.comune.pisa.it/doc/e-government.htm


_==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
e-mail: archim...@archicoop.it
web: _http://www.archicoop.it


_ __ 

-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: newbie question about postgres: nextval

[Ivano Luberti]

I guess I need some aid in the field of comprehension ability: I tried
to start using hibernate a few times but I have never found the right
netry point in the docs, Torque has been really fast to learn at least
to produce the first classes and first code for CRUD operations.

Anyway, thanks again for your great help.


Thomas Fischer ha scritto:
>> 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 
> and Hibernate does all the persistence work.
>
> But it not an performance issue. As you have total control over what the 
> database does, you have more optimisation potential in Torque than in 
> Hibernate. Maybe in some special cases it is more work to optimize Torque 
> application, but it is certainly feasible. 
>
> Thomas
>   

-- 
==
Archimede Informatica NEWS!
==

Realizzato il Sistema Integrato per la biglietteria della Torre di Pisa:
prenotazione, vendita, pre-vendita ed emissione dei biglietti di ingresso
alla Torre sia online che presso le biglietterie dislocate sulla piazza:

_http://www.opapisa.it/boxoffice

_Partner del Progetto Ci-Tel "Front office Telematico per il cittadino"
Ente Coordinatore Comune di Pisa

_http://www.comune.pisa.it/doc/e-government.htm


_==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
e-mail: archim...@archicoop.it
web: _http://www.archicoop.it


_ __ 

-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: newbie question about postgres: nextval

[Ivano Luberti]

Greg, thanks for your answer really exhaustive.
But then where I can find a reference for the schmea file , so that I
can change or add all the db information I need ?

This ml seems really supportive: since Torque seems no more progressing
since 2007 I was fearing there was no actrivity on the list expecially
made by expert.

At this moment I'm really satisfied of Torque: I'm start using Torque
because I became familiar with its php porting (propel) and found it
really easy to use.
Can you explaim why is so overwhelmed by Hibernate ? Is there some
performance related isssue ?




Greg Monroe ha scritto:
> OK, the part about the jdbc task clears a lot up.  This task does
> the best it can using the standard meta info supplied by the 
> JDBC drivers.  Since this is a standard across all the various
> DB server types, there are some limitations when it comes to various
> "pseudo" standards that Torque supports, like native autoincrement 
> fields (and offset and limit to name some others).
>
> Native autoincrement is actually not an SQL standard.  However, since 
> most DB servers have a method of autoincrementing fields built in and 
> auto-incrementing index fields is commonly used in existing schemas, 
> Torque supports this "pseudo" standard in its runtime and SQL creation.
> But since this is implemented and reported very differently by all the
> JDBC drivers (if at all), the JDBC task can't create the correct XML
> given the information available.
>
> This is what is causing your problems.  The bottom line is that the 
> JDBC task output should always be considered a starting point that
> will need to be refined to match the actual schema needs.
>
> In general, for autoincrement id fields coming out of the JDBC task, 
> you will need to decide which method to use with automatic id fields. 
> This is done via the defaultIdMethod attribute on the database tag  or 
> the idMethod attribute on the specific table tag.  The choices are 
> idbroker (Torque's works everywhere method), native (the DB server's 
> native method) or none.  In your case, you want native.
>
> Next you will need to identify the autoincrement fields and modify
> them to include the autoincrement="true" attribute and drop any
> default values.
>
> FWIW, some other "gotchas" from the JDBC task that come to mind are:
>
> If you care about creating the tables via Torque, this does not 
> create any Index or Unique information (JDBC doesn't supply this).  
> You will have to add these in manually.
>
> The table ordering may not meet the requirement that foreign keys
> be defined prior to their use.  So you may need to move some 
> table definitions around to make sure the tables with keys come
> first.
>
> It sounds like a lot of work, but in general, it takes only a
> few minutes (or can be automated for your specific DB standard).
> Just remember that this is a small amount of time compared to what 
> it would take to write all the code that gets generated.
>
>
>
>
>   
>> -Original Message-
>> From: Ivano Luberti [mailto:lube...@archicoop.it]
>> Sent: Monday, January 26, 2009 10:15 AM
>> To: Apache Torque Users List
>> Subject: Re: newbie question about postgres: nextval
>>
>> Here it is .
>> In my prev message I didn't said that , I have defined the db using the
>> server , then I have generated the schema using the jdbc ant task and the
>> classes using the om ant task.
>> I don't want to define myself the shema file because I'm more famliar
>> with SQL and then I don't want to make Torque create or modify my DDL.
>> Finally I use Torque 3.3 version and the generator directly without using
>> Maven.
>>
>>
>>
>> Thomas Fischer ha scritto:
>> 
>>>> I'm using postgres to generate torque classes but the automatic
>>>> generation seems to make a few mistakes.
>>>> In the base class I found this java statement
>>>>
>>>> private int pkAnagrafica =
>>>> nextval('anagrafica_pk_anagrafica_seq'::regclass);
>>>>
>>>> which is marked as wrong by the compiler.
>>>>
>>>> The same happens in the copyobject method of the same class:
>>>>
>>>> copyObj.setPkAnagrafica(
>>>>
>>>> 
>>> nextval('anagrafica_pk_anagrafica_seq'::regclass));
>>>
>>>   
>>>> Is there a way to stop Torque generating these bad statements ?
>>>>
>>>> 
>>> Can you send the schema definition which you use for the table in
>>> quest

Re: newbie question about postgres: nextval

[Ivano Luberti]

Ok, now I understand why someone has choosen to change the java code of
the JDBC ant task (found it on some mailing list) !

Thomas Fischer ha scritto:
> I am surprised that the jdbc task recognizes foreign keys ? Or did you add 
> the foreign-key elements yourself ?
>
>Thomas
>   
No the foreign key have been recognized by the task.
I knew there was an issue with that but maybe the changes in postgres
8.3 have met the  the java code ?
 


_
_ __ 

-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: torque documentation about peer base beans and map classes

[Ivano Luberti]

Ok but it seems there is a broken link at the beginning to a page that
seems promising

http://db.apache.org/torque/releases/torque-3.3/runtime/documentation/relevant-classes.html

Thomas Fischer ha scritto:
>> Hello, can someone point me to some documentation explaining the role of
>> the various type of classes generated by Torque ?
>> 
>
> Documentation by example:
>
> http://db.apache.org/torque/releases/torque-3.3/tutorial/step5.html
>
>Thomas
>   

-- 
==
Archimede Informatica NEWS!
==

Realizzato il Sistema Integrato per la biglietteria della Torre di Pisa:
prenotazione, vendita, pre-vendita ed emissione dei biglietti di ingresso
alla Torre sia online che presso le biglietterie dislocate sulla piazza:

_http://www.opapisa.it/boxoffice

_Partner del Progetto Ci-Tel "Front office Telematico per il cittadino"
Ente Coordinatore Comune di Pisa

_http://www.comune.pisa.it/doc/e-government.htm


_==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
e-mail: archim...@archicoop.it
web: _http://www.archicoop.it


_ __ 

-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

Re: newbie question about postgres: nextval

[Ivano Luberti]

Here it is .
In my prev message I didn't said that , I have defined the db using the
server , then I have generated the schema using the jdbc ant task and
the classes using the om ant task.
I don't want to define myself the shema file because I'm more famliar
with SQL and then I don't want to make Torque create or modify my DDL.
Finally I use Torque 3.3 version and the generator directly without
using Maven.



Thomas Fischer ha scritto:
>> I'm using postgres to generate torque classes but the automatic
>> generation seems to make a few mistakes.
>> In the base class I found this java statement
>>
>> private int pkAnagrafica =
>> nextval('anagrafica_pk_anagrafica_seq'::regclass);
>>
>> which is marked as wrong by the compiler.
>>
>> The same happens in the copyobject method of the same class:
>>
>> copyObj.setPkAnagrafica( 
>> 
> nextval('anagrafica_pk_anagrafica_seq'::regclass));
>   
>> Is there a way to stop Torque generating these bad statements ?
>> 
>
> Can you send the schema definition which you use for the table in question 
> ? This would ease diagnostics. I suspect that you use a default value for 
> the id; this is not necessary.
>
>Thomas
>   

-- 
==
Archimede Informatica NEWS!
==

Realizzato il Sistema Integrato per la biglietteria della Torre di Pisa:
prenotazione, vendita, pre-vendita ed emissione dei biglietti di ingresso
alla Torre sia online che presso le biglietterie dislocate sulla piazza:

_http://www.opapisa.it/boxoffice

_Partner del Progetto Ci-Tel "Front office Telematico per il cittadino"
Ente Coordinatore Comune di Pisa

_http://www.comune.pisa.it/doc/e-government.htm


_==
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
e-mail: archim...@archicoop.it
web: _http://www.archicoop.it


_ __ 

http://db.apache.org/torque/dtd/database_3_3.dtd";>

























































































-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

torque documentation about peer base beans and map classes

[Ivano Luberti]

Hello, can someone point me to some documentation explaining the role of
the various type of classes generated by Torque ?


-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org

newbie question about postgres: nextval

[Ivano Luberti]

Hello I have searched the net quite a lot but I have not been able to
find the answer to this problem.

I'm using postgres to generate torque classes but the automatic
generation seems to make a few mistakes.
In the base class I found this java statement

private int pkAnagrafica =
nextval('anagrafica_pk_anagrafica_seq'::regclass);

which is marked as wrong by the compiler.

The same happens in the copyobject method of the same class:

copyObj.setPkAnagrafica( nextval('anagrafica_pk_anagrafica_seq'::regclass));

Is there a way to stop Torque generating these bad statements ?

Thanks for your attention.



_
_ __ 

-
To unsubscribe, e-mail: torque-user-unsubscr...@db.apache.org
For additional commands, e-mail: torque-user-h...@db.apache.org