JRuby PLS_INTEGER, BINARY_INTEGER NULL value becomes 0 about ruby-plsql HOT 5 CLOSED

I did some debugging and it seems that JDBC driver is returning value 0 when called

    def get_bind_variable(stmt, i, type)
      case type.to_s.to_sym
      when :Fixnum, :Bignum, :Integer
        stmt.getInt(i)
...

Its line 308 in jdbc_connection.rb
Maybe we shouldn't be using getInt for Oracle PLS_ITEGER type and the suptypes / synonyms of it.
I have no JDBC to investigate it, except for googling.

from ruby-plsql.

Good spot! I think you're right. We should perhaps try with getObject - at least to check for null.

from ruby-plsql.

Looking at the code - I suspect that maybe there is a similar issue with :Float.

I just checked: seems binary_{float|double} are working fine.

from ruby-plsql.

@jgebal , may you take a look at #86 - I think it solves the problem.

from ruby-plsql.

Will look at it next week or Sunday evening. Im on holidays till then.

*sent from mobile
2 cze 2015 23:16 "Yavor Nikolov" [email protected] napisał(a):

@jgebal https://github.com/jgebal , may you take a look at #86
#86 - I think it solves the
problem.

—
Reply to this email directly or view it on GitHub
#84 (comment).

from ruby-plsql.