Ooops, resolved... CHAR != VARCHAR2 :S
Sorry...
ForzaPupi.2 wrote:
>
> Hi,
>
> is it possible that a query run from ibatis doesn't work, and the same
> (*hopefully*) query run from my sql client (Squirrel) works??? This
> happens only on a particular table, and using a query with an Example
> class generated from Ibator.
> Now the details...
>
> DDL of the table:
>
> CREATE TABLE BT_PARAMETRI
> (
> CF_VENDITORE char(16) NOT NULL,
> CHIAVE char(20) NOT NULL,
> CODICE char(20) NOT NULL,
> VALORE varchar2(200),
> DT_INSERIMENTO date DEFAULT sysdate
> );
> CREATE UNIQUE INDEX NEMOBT1X ON BT_PARAMETRI
> (
> CF_VENDITORE,
> CHIAVE,
> CODICE
> );
>
> Java code:
> BtParamDAOImpl btpd = new BtParamDAOImpl(sqlMap);
> ...
>
> BtParamExample paramExample = new BtParamExample();
> paramExample.createCriteria()
> .andCfVenditoreEqualTo(System.getProperty("cf.eproject"))
> .andChiaveEqualTo(System.getProperty("param.code.delete.file.policy"))
> .andCodiceEqualTo(parCode)
> ;
> logger.info(btpd.countBtParamByExample(paramExample));
>
> ...
>
> The example class, the DAO are ibator-generated.
>
> Now, the log form ibatis:
>
> 2009-11-19 11:03:14,002 [main] DEBUG java.sql.Connection - {conn-100004}
> Preparing Statement: select count(*) from NEMO.BT_PARAMETRI
>
> where ( CF_VENDITORE =
> ? and CHIAVE = ? and
> CODICE = ?
>
> )
> 2009-11-19 11:03:14,003 [main] DEBUG java.sql.PreparedStatement -
> {pstm-100005} Executing Statement: select count(*) from
> NEMO.BT_PARAMETRI where (
>
> CF_VENDITORE = ? and CHIAVE = ?
>
> and CODICE = ?
>
> )
> 2009-11-19 11:03:14,003 [main] DEBUG java.sql.PreparedStatement -
> {pstm-100005} Parameters: [03595150289, CBI_ESITI, DELETE]
> 2009-11-19 11:03:14,003 [main] DEBUG java.sql.PreparedStatement -
> {pstm-100005} Types: [java.lang.String, java.lang.String,
> java.lang.String]
> 2009-11-19 11:03:14,005 [main] DEBUG java.sql.ResultSet - {rset-100006}
> ResultSet
> 2009-11-19 11:03:14,006 [main] DEBUG java.sql.ResultSet - {rset-100006}
> Header: [COUNT(*)]
> 2009-11-19 11:03:14,006 [main] DEBUG java.sql.ResultSet - {rset-100006}
> Result: [0]
>
> NOW, if I execute the following query from Squirrel....
>
> select count(*) from NEMO.BT_PARAMETRI where
> ( CF_VENDITORE = '03595150289'
> and CHIAVE = 'CBI_ESITI' and
> CODICE = 'DELETE'
>
> )
>
> I get COUNT(*) = 1!!!
>
> I tried to make similar queries on different tables from the same schema,
> and the queries work....
> How's that possible... any clue?
>
> Thanks!
>
--
View this message in context:
http://old.nabble.com/-Ibator--Problem-with-query-*byExample-tp26421259p26421261.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
