Hello:

I had a problem like related by Henri
Yandell (see
http://www.mail-archive.com/[EMAIL PROTECTED]/msg42819.html),
but instead use Oracle I am using SQL
Server. When I try insert a Null
parameter in a Insert Query I get this
message: "Not implemented (type is
java.sql.Types.OTHER)". I am using
jTds driver, but MS official driver
has the same problem (But does not
explain about Types.Other).
I read original Source of jTds and I
see that this message above is thrown
from a method called
createParameterMapping() from
ParameterUtils class. I don't
understand why they made this, but
anyway it is a problem from driver,
not form QueryRunner.
My solution was create a QueryRunner
subclass, where I overridden
fillStatement() method like this:

            if (params == null) {
                return;
            }

            for(int i = 0; i <
params.length; i++) {
                stmt.setObject(i + 1,
params[i]);
            }

I don't verify if current parameter is
null or not. And this works.
What do you think?

Thanks,

Rafael Ubiratam Clemente Afonso
[EMAIL PROTECTED]
---------------------------------
Where is Debug?
Debug is on the Table!
 
__________________________________________________________________________
Acabe com aquelas janelinhas que pulam na sua tela.
AntiPop-up UOL - � gr�tis!
http://antipopup.uol.com.br/



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to