2007 2:03 AM
To: user@ofbiz.apache.org
Subject: Re: Accessing database through bsh script.
Are you sure about these results? The test case sounds really funny, but
however it was done if the same operations are being done with both this
sort of difference would REALLY surprise me. In the fir
t took an averate of 6 msecs to do the executeQuery
call and 23 msecs to do the delegator call.
Skip
-Original Message-
From: Jonathon -- Improov [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 16, 2007 3:44 AM
To: user@ofbiz.apache.org
Subject: Re: Accessing database through bsh sc
It was more to see reaction and mostly to let know people not aware of this
post. Also because I saw some exchanges on the ML about
the possible Adam's return in the "OFBiz team".
Jacques
De : "Jonathon -- Improov" <[EMAIL PROTECTED]>
> JLR,
>
> You mean... to write a parser that parses raw "OFB
JLR,
You mean... to write a parser that parses raw "OFBiz SQL" (with OFBiz data types), and translates
that into RDBMS-specific SQL?
Jonathon
Jacques Le Roux wrote:
I did not resist to resurrect this old thread :
http://www.nabble.com/Dev---RFC%3A-ofbiz-entity-sql%2890--done%29-tf1313496.htm
I did not resist to resurrect this old thread :
http://www.nabble.com/Dev---RFC%3A-ofbiz-entity-sql%2890--done%29-tf1313496.html#a3500828
FWIW
Jacques
De : "Jacques Le Roux" <[EMAIL PROTECTED]>
> http://ofbiz.apache.org/docs/entity.html look at Grouping and Summary Data
>
> Jacques
>
> De : "
[mailto:[EMAIL PROTECTED]
Sent: Sunday, September 16, 2007 3:44 AM
To: user@ofbiz.apache.org
Subject: Re: Accessing database through bsh script.
20msec of what total? That is, what percentage is that 20msec?
I'm assuming there is grouping and summary data in the query?
Another important que
uery, is there a seca
> involved,
> >> etc.
> >>
> >> Skip
> >>
> >> -Original Message-
> >> From: vijay Si [mailto:[EMAIL PROTECTED]
> >> Sent: Saturday, September 15, 2007 10:28 AM
> >> To: user@ofbiz.ap
query, is there a seca involved,
etc.
Skip
-Original Message-
From: vijay Si [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 15, 2007 10:28 AM
To: user@ofbiz.apache.org
Subject: Re: Accessing database through bsh script.
Jonathon
It seems that other option left is to use a jdbc con
Vijay,
> It seems that other option left is to use a jdbc connection to database.
BJ Freeman's suggestion with org.ofbiz.entity.jdbc.SQLProcessor will serve you here. It's as close
to using raw JDBC as you can get. Any more raw than that, and you may be cursing and swearing
about how manual an
ginal Message-
From: vijay Si [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 15, 2007 10:28 AM
To: user@ofbiz.apache.org
Subject: Re: Accessing database through bsh script.
Jonathon
It seems that other option left is to use a jdbc connection to database. Is
it also imperative then, tha
http://ofbiz.apache.org/docs/entity.html look at Grouping and Summary Data
Jacques
De : "vijay Si" <[EMAIL PROTECTED]>
> Is there any funtionality provided for using aggregate functions
> (sum,min,max..) and count() for querrying to data base through bsh.
>
> for egg: how can we write following
gt; To: user@ofbiz.apache.org
> Subject: Re: Accessing database through bsh script.
>
>
> Jonathon
>
> It seems that other option left is to use a jdbc connection to database.
> Is
> it also imperative then, that for very complex querries having
> "groupby".
Subject: Re: Accessing database through bsh script.
Jonathon
It seems that other option left is to use a jdbc connection to database. Is
it also imperative then, that for very complex querries having
"groupby"..."having" and other clauses it is better to use jdbc method of
c
From: vijay Si [mailto:[EMAIL PROTECTED]
Sent: Saturday, September 15, 2007 9:11 AM
To: user@ofbiz.apache.org
Subject: Re: Accessing database through bsh script.
Hi Jonathon,
i cannot use the view-entity for querrying, as it would cause a performance
hit. Is there any other method to get the abov
look at
framework/webtools/webapp/webtools/WEB-INF/actions/entity/EntitySQLProcessor.bsh
vijay Si sent the following on 9/15/2007 10:27 AM:
> Jonathon
>
> It seems that other option left is to use a jdbc connection to database. Is
> it also imperative then, that for very complex querries having
>
Jonathon
It seems that other option left is to use a jdbc connection to database. Is
it also imperative then, that for very complex querries having
"groupby"..."having" and other clauses it is better to use jdbc method of
connection.
How does it affect the ofbiz philosophy of architecture if i us
There's no other (easy) way to query database, aside from using the Entity Engine (which was what
I suggested).
If you're worried about performance hit with a huge (and unconditional) cross-product, see
http://www.nabble.com/forum/ViewPost.jtp?post=12590081&framed=y and
https://issues.apache.o
Hi Jonathon,
i cannot use the view-entity for querrying, as it would cause a performance
hit. Is there any other method to get the above querry. Do u know of any
ways to do it through bsh script.
Regards
On 9/15/07, Jonathon -- Improov <[EMAIL PROTECTED]> wrote:
>
> Use the GenericDelegator an
Use the GenericDelegator and related classes, I think. Or maybe not. I can't recall the aggregate
functions there.
The entity definitions do have those, though. The ? Oh yes, the
.
Try using DynamicViewEntity to construct a .
Jonathon
vijay Si wrote:
Is there any funtionality provided for u
19 matches
Mail list logo