Jeremy-

I tried:

1) adding getting the meta data of column_type_name to the process_result_set 
method in the jdbc adapter:
2) changed the method process_result_set_convert to pass the column_type_name 
to the convert_type_proc
3) then in my sqlanywhere specific jdbc adapter I override the 
convert_type_proc and that will call super.

This worked for all the jdbc data types via the default super and allowed me to 
convert "smallint" to a boolean.

The gist is updated with this code:  https://gist.github.com/gditrick/6240781

Do you see a problem with this approach?  I know this makes smallint a boolean 
no matter if the user wants a smallint.  But the native one will be doing that 
anyway.  Shame SqlAnywhere does not a boolean type.  In our java code and 
stored procs, we use either a smallint or a char of 'Y' or 'N'.  I could switch 
this to the char approach, but looking at the other adapters, I like using the 
smallint.  Thoughts?

With this change and the alter table changes:  The jdbc sqlanywhere integration 
test results are 539 tests, 0 failing, only 2 pending.

-GregD

 

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to