Title: Using WHERE IN along with AND
I have the following and it throws a UncategorizedSQL exception…
SELECT
R.ORD_ID AS ORD_ID,
PART_ID,
CLNT_ID_N,
PLAN_N,
yes, you're right. it was caused by a buggy trigger. thanx.
Larry Meadors wrote:
Hmm, well it is certainly a pgsql issue - http://tinyurl.com/bbfnw
Larry
On 7/14/05, Michael Zurke <[EMAIL PROTECTED]> wrote:
hi Daniel,
PostgreSQL 8.0.2.
tried to run the same query on the console and had no
Hmm, well it is certainly a pgsql issue - http://tinyurl.com/bbfnw
Larry
On 7/14/05, Michael Zurke <[EMAIL PROTECTED]> wrote:
> hi Daniel,
>
> PostgreSQL 8.0.2.
> tried to run the same query on the console and had no problems, though.
>
> Daniel Henrique Ferreira e Silva wrote:
> > Hi Mischa,
hi Daniel,
PostgreSQL 8.0.2.
tried to run the same query on the console and had no problems, though.
Daniel Henrique Ferreira e Silva wrote:
Hi Mischa,
Usually SQL exceptions are due to failures in your database engine.
Which database engine are you using?
Cheers,
Daniel Silva.
On 7/14/05,
Hi Mischa,
Usually SQL exceptions are due to failures in your database engine.
Which database engine are you using?
Cheers,
Daniel Silva.
On 7/14/05, Michael Zurke <[EMAIL PROTECTED]> wrote:
> hi,
>
> getting this error
>
> --- The error occurred in Test.xml.
> --- The error occurred while ap
hi,
getting this error
--- The error occurred in Test.xml.
--- The error occurred while applying a parameter map.
--- Check the deleteTest-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ERROR: cache lookup failed for type 0
Caused by: java.sql.SQLE
Hi Honda,
I think the best and simple approach you can take in this situation is
using a List instead of a HashMap (sorry Vic :).
Having a list would allow you to do something like this:
SELECT
*
FROM
table
#[]#
Cheers,
Daniel Silva.
On 7/14/05, Hond
Well
First of all, I'm not the author of that post
I only give some extra help to ensure that, in my opinion that's not a bug:)
What's more, I totally agree with you
Cheers
Darek Dober
- Original Message -
From: "Larry Meadors" <[EMAIL PROTECTED]>
To:
Sent: Thursday, July 14, 2005 2:
* Larry Meadors wrote (14/07/2005 13:35):
> On 7/14/05, Chris Lear <[EMAIL PROTECTED]> wrote:
>> * Ron Grabowski wrote (14/07/2005 13:18):
>> > The Java version of iBATIS has support for logging all sql sent to
>> > the database. Here's some sample output:
>> >
>> > http://issues.apache.org/jira/b
Not exactly Chris.
These come from the PreparedStatementLogProxy class, which is a proxy
to PreparedStatement that logs to the java.sql.PreparedStatement
logger.
Larry
On 7/14/05, Chris Lear <[EMAIL PROTECTED]> wrote:
> * Ron Grabowski wrote (14/07/2005 13:18):
> > The Java version of iBATIS has
* Ron Grabowski wrote (14/07/2005 13:18):
> The Java version of iBATIS has support for logging all sql sent to the
> database. Here's some sample output:
>
> http://issues.apache.org/jira/browse/IBATISNET-35
That's DEBUG output from the java.sql.PreparedStatement class. It's not
quite the same a
I am not an oracle guy, so maybe i am missing something really
obvious...but why would you do this as a string? It just seems like a
really fragile way to deal with this situation.
Larry
On 7/14/05, Darek Dober <[EMAIL PROTECTED]> wrote:
>
> I think, it is not a bug :)
>
> It doesn't work for
p6spy is also a great sql logging tool.
On 7/14/05, Ron Grabowski <[EMAIL PROTECTED]> wrote:
> The Java version of iBATIS has support for logging all sql sent to the
> database. Here's some sample output:
>
> http://issues.apache.org/jira/browse/IBATISNET-35
>
> --- Kris Rasmussen <[EMAIL PROTE
I think, it is not a bug :)
It doesn't work for me.
But this does
insert into testddo (col) values (to_date('2005-07-14 16:06:48','-mm-dd
hh24:mi:ss'));
hours: 16 should be declared as HH24 not hh
Anyway:)
Darek Dober
- Original Message -
From: "Larry Meadors" <[EMAIL PROT
The Java version of iBATIS has support for logging all sql sent to the
database. Here's some sample output:
http://issues.apache.org/jira/browse/IBATISNET-35
--- Kris Rasmussen <[EMAIL PROTECTED]> wrote:
> Thanks Clinton,
>
> I will look into this myself when I have more time. I wish there we
PLEASE! PLEASE! PLEASE!
If you are not 99.999% sure it is a bug, do not put it in JIRA.
Larry
On 7/14/05, leo zhang (JIRA) wrote:
> [
> http://issues.apache.org/jira/browse/IBATIS-170?page=comments#action_12315824
> ]
>
> leo zhang commented on IBATIS-170:
> -
Hello
this is what i tried
select * from test1 where
substring(type1,1,1) < '0' and
substring(type1,2,1)< '0'
i think it works
--- Larry Meadors <[EMAIL PROTECTED]> wrote:
> Brute force?
>
> select * from test1
> where type1 not like '%1%'
> and type1 not like '%2%'
> and type1 not like '
Hallo list users!
i have one HashMap with ID's. is it possible to create one SQL query
SELECT * FROM table WHERE id IN (1,2,3,4) ?
where can i find some examples of iterate tag ?
Best regards,
H0nd4
18 matches
Mail list logo
