Bugs item #10328, was opened at 2007-04-24 07:56 You can respond by visiting: http://rubyforge.org/tracker/?func=detail&atid=7857&aid=10328&group_id=2014
Category: AR-JDBC
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Error while evaluating nil.toString
Initial Comment:
Running JRoR with Oracle, some tables work OK but for example this one seems to
have something against me:
>> XCi.find(179499432135590475)
ActiveRecord::StatementInvalid: NoMethodError: You have a nil object when you
didn't expect it!
The error occurred while evaluating nil.toString: SELECT * FROM
sdesk.cdm_configuration_items_x WHERE
(sdesk.cdm_configuration_items_x.xcit_cit_oid = 179499432135590475)
from
C:/ruby/jruby/jruby/lib/ruby/gems/1.8/gems/ActiveRecord-JDBC-0.2.3/lib/active_record/connection_adapters/jdbc_adapter.rb:651:in
`log_no_bench'
from
C:/ruby/jruby/jruby/lib/ruby/gems/1.8/gems/ActiveRecord-JDBC-0.2.3/lib/active_record/connection_adapters/jdbc_adapter.rb:630:in
`select'
from
C:/ruby/jruby/jruby/lib/ruby/gems/1.8/gems/ActiveRecord-JDBC-0.2.3/lib/active_record/connection_adapters/jdbc_adapter.rb:581:in
`select_all'
from
C:/ruby/jruby/jruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:427:in
`find_by_sql'
from
C:/ruby/jruby/jruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:998:in
`find_every'
from
C:/ruby/jruby/jruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1032:in
`find_one'
from
C:/ruby/jruby/jruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:1014:in
`find_from_ids'
from
C:/ruby/jruby/jruby/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/base.rb:419:in
`find'
from (irb):>> 1:in `binding'
The table looks like this:
Name Null? Type
----------------------------------------- -------- ----------------------------
XCIT_CIT_OID NOT NULL NUMBER(18)
XCIT_PER_OID NUMBER(18)
XCIT_COD_OID NUMBER(18)
XCIT_COD_OID000001 NUMBER(18)
XCIT_COD_OID000002 NUMBER(18)
XCIT_COD_OID000003 NUMBER(18)
XCIT_COD_OID000004 NUMBER(18)
XCIT_COD_OID000005 NUMBER(18)
XCIT_COD_OID000006 NUMBER(18)
XCIT_COD_OID000007 NUMBER(18)
XCIT_ORG_OID NUMBER(18)
XCIT_LOC_OID NUMBER(18)
XCIT_CITBOOLEAN15 NUMBER(1)
XCIT_CITBOOLEAN14 NUMBER(1)
XCIT_CITBOOLEAN13 NUMBER(1)
XCIT_WARRANTYDATE DATE
XCIT_RCD_OID NUMBER(18)
XCIT_CITBOOLEAN12 NUMBER(1)
XCIT_CITBOOLEAN11 NUMBER(1)
XCIT_UNIQUE NUMBER(1)
XCIT_RCD_OID000001 NUMBER(18)
XCIT_CITBOOLEAN10 NUMBER(1)
XCIT_CITBOOLEAN9 NUMBER(1)
XCIT_CINUMBER15 NUMBER(10)
XCIT_CINUMBER14 NUMBER(10)
XCIT_CINUMBER13 NUMBER(10)
XCIT_ORG_OID000001 NUMBER(18)
XCIT_CINUMBER12 NUMBER(10)
XCIT_CITBOOLEAN8 NUMBER(1)
XCIT_PURCHASEDATE DATE
XCIT_PRICE NUMBER(12,2)
XCIT_CITBOOLEAN7 NUMBER(1)
XCIT_MCT_OID NUMBER(18)
XCIT_CITBOOLEAN5 NUMBER(1)
XCIT_CITBOOLEAN6 NUMBER(1)
XCIT_CITBOOLEAN4 NUMBER(1)
XCIT_CITBOOLEAN3 NUMBER(1)
XCIT_CITBOOLEAN2 NUMBER(1)
XCIT_CITBOOLEAN1 NUMBER(1)
XCIT_CITDURATION2 FLOAT(126)
XCIT_CINUMBER5 NUMBER(10)
XCIT_CINUMBER4 NUMBER(10)
XCIT_CINUMBER3 NUMBER(10)
XCIT_CINUMBER2 NUMBER(10)
XCIT_CITDURATION1 FLOAT(126)
XCIT_CINUMBER1 NUMBER(10)
XCIT_CIDATE5 DATE
XCIT_CIDATE4 DATE
XCIT_CIDATE3 DATE
XCIT_CIDATE2 DATE
XCIT_CIDATE1 DATE
XCIT_COD_OID000008 NUMBER(18)
XCIT_COD_OID000009 NUMBER(18)
XCIT_COD_OID000010 NUMBER(18)
XCIT_COD_OID000011 NUMBER(18)
XCIT_CINUMBER11 NUMBER(10)
XCIT_COD_OID000012 NUMBER(18)
XCIT_COD_OID000013 NUMBER(18)
XCIT_WOG_OID NUMBER(18)
XCIT_PER_OID000001 NUMBER(18)
XCIT_ORG_OID000002 NUMBER(18)
XCIT_CIDATE10 DATE
XCIT_CIDATE9 DATE
XCIT_CIDATE8 DATE
XCIT_CIDATE7 DATE
XCIT_CIDATE6 DATE
XCIT_SRV_OID NUMBER(18)
XCIT_SRV_OID000001 NUMBER(18)
XCIT_CINUMBER10 NUMBER(10)
XCIT_CINUMBER9 NUMBER(10)
XCIT_CINUMBER8 NUMBER(10)
XCIT_CINUMBER7 NUMBER(10)
XCIT_CINUMBER6 NUMBER(10)
XCIT_SEL_OID NUMBER(18)
XCIT_MAXINSTALLATIONS NUMBER(10)
XCIT_COD_OID000014 NUMBER(18)
XCIT_COD_OID000015 NUMBER(18)
XCIT_COD_OID000016 NUMBER(18)
XCIT_COD_OID000017 NUMBER(18)
XCIT_COD_OID000018 NUMBER(18)
XCIT_COD_OID000019 NUMBER(18)
XCIT_COD_OID000020 NUMBER(18)
XCIT_COD_OID000021 NUMBER(18)
XCIT_COD_OID000022 NUMBER(18)
XCIT_COD_OID000023 NUMBER(18)
XCIT_COD_OID000024 NUMBER(18)
XCIT_COD_OID000025 NUMBER(18)
XCIT_COD_OID000026 NUMBER(18)
XCIT_COD_OID000027 NUMBER(18)
XCIT_RCD_OID000002 NUMBER(18)
XCIT_RCD_OID000003 NUMBER(18)
XCIT_RCD_OID000004 NUMBER(18)
XCIT_RCD_OID000005 NUMBER(18)
XCIT_PLANDOWNSTATTIMESTAMP DATE
XCIT_RCD_OID000006 NUMBER(18)
For example, this table works ok (atleast with the rows I've tested with):
Name Null? Type
----------------------------------------- -------- ----------------------------
CIT_OID NOT NULL NUMBER(18)
CIT_ATTACHMENT_EXISTS NUMBER(1)
CIT_CAT_OID NUMBER(18)
CIT_COREID VARCHAR2(50 CHAR)
CIT_CORRESPTODEF_OID NUMBER(18)
CIT_CPU_OID NUMBER(18)
CIT_CREATED DATE
CIT_DESCRIPTION VARCHAR2(255 CHAR)
CIT_ID NUMBER(20)
CIT_LOC_OID NUMBER(18)
CIT_LOCKSEQ NUMBER(9)
CIT_MODIFIED DATE
CIT_NAME1 VARCHAR2(255 CHAR)
CIT_NOTSELECTABLE NUMBER(1)
CIT_OSMAN_OID NUMBER(18)
CIT_OSTYP_OID NUMBER(18)
CIT_OSVER_OID NUMBER(18)
CIT_POO_OID NUMBER(18)
CIT_REMARK VARCHAR2(255 CHAR)
CIT_SEARCHCODE VARCHAR2(50 CHAR)
CIT_SOURCEID VARCHAR2(80 CHAR)
CIT_SRD_OID NUMBER(18)
CIT_SUBTYPE NUMBER(18)
CIT_TEM_OID NUMBER(18)
CIT_TMZ_OID NUMBER(18)
REG_CREATED_BY_OID NUMBER(18)
REG_MODIFIED_BY_OID NUMBER(18)
The data for the malfunctioning row/table is as follows:
XCIT_CIT_OID 179499432135590475
XCIT_PER_OID {null}
XCIT_COD_OID {null}
XCIT_COD_OID000001 {null}
XCIT_COD_OID000002 {null}
XCIT_COD_OID000003 {null}
XCIT_COD_OID000004 {null}
XCIT_COD_OID000005 {null}
XCIT_COD_OID000006 {null}
XCIT_COD_OID000007 {null}
XCIT_ORG_OID {null}
XCIT_LOC_OID {null}
XCIT_CITBOOLEAN15 {null}
XCIT_CITBOOLEAN14 {null}
XCIT_CITBOOLEAN13 {null}
XCIT_WARRANTYDATE {null}
XCIT_RCD_OID {null}
XCIT_CITBOOLEAN12 {null}
XCIT_CITBOOLEAN11 {null}
XCIT_UNIQUE 0
XCIT_RCD_OID000001 3094610402
XCIT_CITBOOLEAN10 0
XCIT_CITBOOLEAN9 {null}
XCIT_CINUMBER15 {null}
XCIT_CINUMBER14 {null}
XCIT_CINUMBER13 {null}
XCIT_ORG_OID000001 {null}
XCIT_CINUMBER12 {null}
XCIT_CITBOOLEAN8 {null}
XCIT_PURCHASEDATE {null}
XCIT_PRICE {null}
XCIT_CITBOOLEAN7 {null}
XCIT_MCT_OID {null}
XCIT_CITBOOLEAN5 {null}
XCIT_CITBOOLEAN6 {null}
XCIT_CITBOOLEAN4 {null}
XCIT_CITBOOLEAN3 {null}
XCIT_CITBOOLEAN2 {null}
XCIT_CITBOOLEAN1 0
XCIT_CITDURATION2 {null}
XCIT_CINUMBER5 {null}
XCIT_CINUMBER4 {null}
XCIT_CINUMBER3 {null}
XCIT_CINUMBER2 {null}
XCIT_CITDURATION1 {null}
XCIT_CINUMBER1 {null}
XCIT_CIDATE5 {null}
XCIT_CIDATE4 {null}
XCIT_CIDATE3 {null}
XCIT_CIDATE2 {null}
XCIT_CIDATE1 {null}
XCIT_COD_OID000008 {null}
XCIT_COD_OID000009 {null}
XCIT_COD_OID000010 {null}
XCIT_COD_OID000011 {null}
XCIT_CINUMBER11 {null}
XCIT_COD_OID000012 {null}
XCIT_COD_OID000013 {null}
XCIT_WOG_OID {null}
XCIT_PER_OID000001 {null}
XCIT_ORG_OID000002 {null}
XCIT_CIDATE10 {null}
XCIT_CIDATE9 {null}
XCIT_CIDATE8 {null}
XCIT_CIDATE7 {null}
XCIT_CIDATE6 {null}
XCIT_SRV_OID {null}
XCIT_SRV_OID000001 {null}
XCIT_CINUMBER10 {null}
XCIT_CINUMBER9 {null}
XCIT_CINUMBER8 {null}
XCIT_CINUMBER7 {null}
XCIT_CINUMBER6 {null}
XCIT_SEL_OID {null}
XCIT_MAXINSTALLATIONS 1
XCIT_COD_OID000014 {null}
XCIT_COD_OID000015 {null}
XCIT_COD_OID000016 {null}
XCIT_COD_OID000017 {null}
XCIT_COD_OID000018 {null}
XCIT_COD_OID000019 {null}
XCIT_COD_OID000020 {null}
XCIT_COD_OID000021 {null}
XCIT_COD_OID000022 {null}
XCIT_COD_OID000023 {null}
XCIT_COD_OID000024 {null}
XCIT_COD_OID000025 {null}
XCIT_COD_OID000026 {null}
XCIT_COD_OID000027 {null}
XCIT_RCD_OID000002 3940654247379112
XCIT_RCD_OID000003 259403075925467760
XCIT_RCD_OID000004 281479546601622
XCIT_RCD_OID000005 {null}
XCIT_PLANDOWNSTATTIMESTAMP 2007-03-29 10:17:55
XCIT_RCD_OID000006 3940654246330546
The SQL statement in the error message returns the valid row when copy/pasted
to the SQL-prompt.
----------------------------------------------------------------------
>Comment By: Ola Bini (olabini)
Date: 2007-08-11 15:31
Message:
This was a problem with the handling of certain types. It has been fixed on
trunk.
----------------------------------------------------------------------
You can respond by visiting:
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=10328&group_id=2014
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel
