Previous post from me were solved ( the hard way, it's true ).
Using NH 1.2.1GA, firebird 2.x engine and FirebirdSql.Data.FirebirdClient,
version 2.0.
Now, I'm faced to two "nice" exceptions, one when inserting, the other at update time. Both originated from the client driver.
The insert exception has to do with String to Char[] cast ... ( i.e: something that is a String for NH, is a Char[] for the driver.
The update exception is more subtle. The driver throws a 'violation of PRIMARY or UNIQUE KEY constraint'.
I was checking the sql on the console ( show_sql=true ), and the "intermediate" statement ( the one with parameters of the @px form ) was correct, especially in the WHERE clause ( the passed ID was the one retrieved ).
In both cases, the exception message appears without the parameters, like this
"could not update: [Feeder.Tsdreport#942][SQL: UPDATE Tsdreport SET CHECKED = ?, DATA = ?, Datetime = ?, Dbdatatime = ?, REMOTETERMINALID = ? WHERE Tsdreportid = ?]"
or
{"could not insert: [Hidrovia_DB.Clone#f2b7fc549102493b915dda40c89c39e9][SQL: INSERT INTO CLONE (TSDID, DTA, Done, TStamp, CLONE_ID) VALUES (?, ?, ?, ?, ?)]"}
Does someone have experience with Firebird ? Who's the "culprit" ?
I downloaded and compiled the client driver, but cannot figure the "entry points" of the dll, to set a breakpoint.
Even some guidance in this topic would be useful.
TIA
Marcelo
|