Question about 'jdbcType='

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Question about 'jdbcType='

François Schiettecatte
Hi

I remember seeing something about "jdbcType=" not being needed anymore in xml maps for columns which can contain NULL values, is that the case or am I mis-remmembering?


Cheers

François

--
François Schiettecatte
http://fschiettecatte.wordpress.com/


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: Question about 'jdbcType='

Bekkum Odd-Rune
Could it be this?

orb

---------------------------------------------------------------------
Hi.

To get it to work I've added :OTHER on all INSERT and UPDATE statements.
I can do check out and build and test it tomorrow.
I've created Jira ticket IBATIS-762.

Thanks,
Odd-Rune.

Thanks.  A few others have reported this, but until now I didn't understand what was happening.  It's unusual for Postgres to allow Types.OTHER for setNull.  Indeed I did remove that code.  I don't think it should be a problem to put it back.  I'll try to commit something tonight, and if you're willing to check out from SVN and do a build to test it out, that would be great.

If you get a chance, could you file a Jira ticket for this?

Thanks much,
Clinton

On Tue, Mar 16, 2010 at 6:34 AM, Bekkum Odd-Rune <[hidden email]<mailto:[hidden email]>> wrote:
Hi.

I've used ibatis 2.3.4, and are now starting to use 3.0.
I'm using Postgres 8.4.

I'm trying to figure out why I have to specify jdbcType on those columns that can be set to null.
Why was the default "Types.OTHER" removed?

Version 2.3.4:
from ParameterMap.java
      if (jdbcType != JdbcTypeRegistry.UNKNOWN_TYPE) {
        ps.setNull(i + 1, jdbcType);
      } else {
        ps.setNull(i + 1, Types.OTHER);
      }

Version 3.0.242:
from BaseTypeHandler.java
    if (parameter == null) {
      if (jdbcType == null) {
        throw new TypeException("JDBC requires that the JdbcType must be specified for all nullable parameters.");
      }
      ps.setNull(i, jdbcType.TYPE_CODE);
    } else {
      setNonNullParameter(ps, i, parameter, jdbcType);
    }

Thanks,
Odd-Rune.


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]
-----Original Message-----
From: François Schiettecatte [mailto:[hidden email]]
Sent: 20. mai 2010 14:18
To: [hidden email]
Subject: Question about 'jdbcType='

Hi

I remember seeing something about "jdbcType=" not being needed anymore in xml maps for columns which can contain NULL values, is that the case or am I mis-remmembering?


Cheers

François

--
François Schiettecatte
http://fschiettecatte.wordpress.com/


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Question about 'jdbcType='

Clinton Begin
In reply to this post by François Schiettecatte
That is the case for most situations, but make sure to grab the latest release.

It's still a best practice and a JDBC requirement.  All iBATIS will do is fill it in with Types.OBJECT or Types.Other to try to force the null.

Clinton

2010/5/20 François Schiettecatte <[hidden email]>
Hi

I remember seeing something about "jdbcType=" not being needed anymore in xml maps for columns which can contain NULL values, is that the case or am I mis-remmembering?


Cheers

François

--
François Schiettecatte
http://fschiettecatte.wordpress.com/


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]


Loading...