We use Junits after the compile (same Ant script) to verify that
not only the XML is fine, but that the code (SQL and Java) actually
works.
Randy
-Original Message-
From: Steven Pannell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 30, 2007 3:53 AM
To: user-java@iba
Could you include the SQL Exception that you are receiving?
Randy
-Original Message-
From: Jonathan Tse [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 25, 2007 4:47 AM
To: user-java@ibatis.apache.org
Subject: Strange behaviour when column is null
Hi all,
I exp
If there are no entries in table Child then the SQL statement will
not return any records. To return the records from Parent with no
children, you need to use a LEFT OUTER JOIN.
I would suggest using your tool's SQL interpreter to get the query
right before trying to incorporate that i
I'm pretty sure you don't need the BEGIN/END tags or the commit. You
want:
Randy
-Original Message-
From: navrsale [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 21, 2006 7:14 PM
To: user-java@ibatis.apache.org
Subject: executing several delete statements as one
The problem is likely in the
com/aoc/ito/atoms/ibatis/SCSP0006.xml file. From the error message I
would guess you are using a element instead of a
element to call a stored procedure.
Randy
-Original Message-
From: smita_b [mailto:[EMAIL PROTECTED]
Sent: Friday, Nove
I think your problem might be that your SQL doesn't have a result
column ELEMENTO. I believe you should change your SQL to:
select
TIPO_RIGA_ID, ELEMENTO - 1 AS ELEMENTO, NOME, TIPO_ELEMENTO_ID
from TIPI_DATO_RIGA
where tipo_dato_id = #id:INTEGER#
so that the result set contains the correc
I'm trying to invoke a stored procedure in Postgres, but I get
an error from the Postgres driver saying (The entire stack trace for the
exception is at the end of the email):
org.postgresql.util.PSQLException: A CallableStatement function was
executed and the return was of type java.sql.T
