hi everyone. I am stumped!
I have code that is part of a simple persistent object manager.
The system takes an object, builds an update statement, and
builds the parameter list.
I keep getting an abnormal program termination. Hoever as you
can see in the modified code segment below, I can run the same query
with the same data that is hand keyed and it works fine.
Below, you can see that the dynamically created arrays and the
hand keyed one are identical, but one always aborts and one works
fine. I am running ruby 1.8 on windows 2000 using the pragmatic
programmers installer.
Does anyone have any ideas?
Walt
This one ends in a segmentation fault
original code
def update(obj)
raise SpomDBClosedException.new if closed?
executeCount = 0
dbObject = @spom.getObjectMapping(obj.class)
dbHandle.prepare(dbObject.updateSQL) do |sth|
params = []
dbObject.nonKeyFields.each{|field| params <<
field.toDB(obj)}
dbObject.keyFields.each{|field| params
<<field.toDB(obj)}
executeCount = sth.execute(*params)
end
executeCount
end
end original code
this modified version works. The main difference is that I am
executing the update with a fixed array, not the dynamically computed
array. It also has some code to compare the dynamically computed
array, and the fixed one. It appears that they are identical,
however,
the dynamically created one always ends with :
C:/ruby/lib/ruby/site_ruby/1.8/DBD/ODBC/ODBC.rb:202: [BUG]
Segmentation fault
ruby 1.8.0 (2003-05-26) [i386-mswin32]
abnormal program termination
modified code
def update(obj)
raise SpomDBClosedException.new if closed?
executeCount = 0
dbObject = @spom.getObjectMapping(obj.class)
dbHandle.prepare(dbObject.updateSQL) do |sth|
params = []
dbObject.nonKeyFields.each{|field| params <<
field.toDB(obj)}
dbObject.keyFields.each{|field| params
<<field.toDB(obj)}
puts “computed data"
puts compData = params.join(”,")
compClasses = params.collect{|i| i.class}
puts compClasses.join(",")
keyed = [Date.today, ‘aaa’, ‘POIL’, ‘line1’, ‘line2’, ‘city’, ‘st’,
‘zip’, ‘country’, ‘p’, ‘1’, ‘2’, ‘3’, ‘4’, ‘5’, ‘6’, ‘7’, ‘8’, ‘9’,
‘10’, Date.today, ‘-’ , ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, 20, 21, ‘sic’,
‘disp’, ‘oth3’, “31”, “32”, “33”, “34”, “35”, ‘POIL’, 999999]
puts ““
puts “hand keyed data"
puts keyedData = keyed.join(”,”)
keyedClasses = keyed.collect{|i| i.class}
puts keyedClasses.join(”,")
puts ""
puts "size (#{params.size}) same? #{params.size == keyed.size}"
puts "raw data same? #{params == keyed}"
puts "joined data same? #{compData == keyedData}"
puts “raw classes same #{compClasses == keyedClasses}”
#note nothing prints
params.each_with_index do |p, index|
puts “******* #{index} does NOT equal data” if p != keyed[index]
puts “******* #{index} does NOT equal class” if p.class !=
keyed[index].class
end
params = keyed #NOTE: replace dynamic data with keyed data
executeCount = sth.execute(*params)
end
executeCount
end
end modified code
···
***** OUTPUT *****
computed data
2003-07-
12,aaa,POIL,line1,line2,city,st,zip,country,p,1,2,3,4,5,6,7,8,9,10,200
3-07-12,-,20,21,sic,disp,oth3,31,32,33,34,35,POIL,999999
Date,String,String,String,String,String,String,String,String,String,St
ring,String,String,String,String,String,String,String,String,String,Da
te,String,String,String,String,String,String,String,String,Fixnum,Fixn
um,String,String,String,String,String,String,String,String,String,Fixn
um
hand keyed data
2003-07-
12,aaa,POIL,line1,line2,city,st,zip,country,p,1,2,3,4,5,6,7,8,9,10,200
3-07-12,-,20,21,sic,disp,oth3,31,32,33,34,35,POIL,999999
Date,String,String,String,String,String,String,String,String,String,St
ring,String,String,String,String,String,String,String,String,String,Da
te,String,String,String,String,String,String,String,String,Fixnum,Fixn
um,String,String,String,String,String,String,String,String,String,Fixn
um
size (41) same? true
raw data same? true
joined data same? true
raw classes same true
Walter Szewelanczyk
IS Director
M.W. Sewall & CO. email : walter@mwsewall.com
259 Front St. Phone : (207) 442-7994 x 128
Bath, ME 04530 Fax : (207) 443-6284