Ruby on Rails
HowToSetupSybaseAdapterOnRails (Version #41)

These instructions for Sybase on Linux. To setup on Win32 with Visual Studio, go to SybaseASEonWin32. To set up on Mac OS X, go to HowToSetupSybaseAdapterOnRailsOnOSX

Used SybaseASE 12.5.1 client on Suse 7.3

Insall Sybase Open Client for linux (machine i worked on already had it installed so i did not have to do that)
Check if you can access Sybase using isql

Setup Sybase Home Directory which should ls the following ( make sure to make it addequate to your path )




user@workstation:~> ls -la $SYBASE
total 1124
drwxrwx---    2       4096 2006-06-26 16:34 .
drwxr-xr-x   66       8192 2006-06-27 10:52 ..
lrwxrwxrwx    1         46 2006-06-26 16:33 OCS -> SYBSclnt/12.5.0/sybase/OCS-12_5/
lrwxrwxrwx    1         45 2006-06-23 12:57 charsets -> SYBSclnt/12.5.0/sybase/charsets
lrwxrwxrwx    1         43 2006-06-23 12:57 config -> SYBSclnt/12.5.0/sybase/config
-rw-rw----    1      31271 2006-06-23 12:56 interfaces
-rwxrwx---    1    1101573 2006-06-23 12:55 isql
lrwxrwxrwx    1         44 2006-06-23 12:57 locales -> SYBSclnt/12.5.0/sybase/locales
-rw-rw----    1       1142 2006-06-23 12:57 sybinit.err
tpdev@nyeqlnx006:~>

Make sure that your interfaces file is properly setup.

Add enviroment variables




SYBASE=/home/user/Sybase
export SYBASE


SYBASE_LIB=/home/user/Sybase/OCS/lib

export SYBASE_LIB
#To Add To Path

#I also added locales directory ( not sure if needed but that might be the one that fixed it for me)

export PATH=.:${PATH}:$SYBASE:$SYBASE/OCS/lib:$SYBASE/locales
#NOTE: I have locales also added to that LIB path
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$SYBASE:$SYBASE/OCS/lib:$SYBASE/locales

Download Ruby Sybase Library

Edit extconfig.rb




gunzip  sybct-ruby-0.2.8.tar.gz
tar -xvf  sybct-ruby-0.2.8.tar
cd  sybct-ruby-0.2.8
vi extconfig.rb


	Set sybase variable to point to your $SYBASE directory I’ve use the full path

sybase = “/home/user/SYBASE”

I did not change anything else make make install

Copy sybct.o sybct.so sybct.rb sybsql.rb to your ruby path to find what it is do:




user@worskattion> irb
irb(main):001:0> $LOAD_PATH
=> ["/usr/local/lib/ruby/site_ruby/1.8", "/usr/local/lib/ruby/site_ruby/1.8/i686-linux", "/usr/local/lib/ruby/site_ruby", "/export/applications/usr/local/lib/ruby/1.8", "/usr/local/lib/ruby/1.8/i686-linux", "."]

in my case it was ../lib/ruby/site_ruby/1.8/i686-linux

NOTE: in ASE15 libct.so.* is called libsybct.so.*. the same applies to other 3 files. ( found by Rasika Ranaweera )

Run some tests




$bash: irb
irb(main):001:0> require 'sybsql'
=> true

if you did not succeed you would get the folowing error while including ‘sybsql’ from irb




$bash: irb
irb(main):001:0> require 'sybsql'
LoadError: libsybtcl.so: cannot open shared object file: No such file or directory - /usr/local/lib/ruby/site_ruby/1.8/i686-linux/sybct.so
        from /usr/local/lib/ruby/site_ruby/1.8/i686-linux/sybct.so
        from /usr/local/lib/ruby/site_ruby/1.8/i686-linux/sybct.rb:3
        from /usr/local/lib/ruby/site_ruby/1.8/i686-linux/sybsql.rb:4
        from (irb):1

and if you are to start rails app that uses sybase_adapter you would get the following:




database configuration specifies nonexistent sybase adapter (ActiveRecord::AdapterNotFound)

One more test to run would be using ruby isql




cd sybct-ruby-0.2.8/


tpdev@nyeqlnx006:~/sybct-ruby-0.2.8> ruby -I . ./sample/isql.rb -S HOSTNAMEFROMINTERFACE -U username -P password
!! MAX ROWCOUNT 2000 !!

1→ select count() from sysobjects

2→ go

<- select count() from sysobjects

restype =ROW_RESULT
——

1870

(row count = 1, tran state = ’completed’) 3→ quit EOF

Finally lets get Sybase to be on Rails
Edit you config/database.yml to look as following




development:
  adapter: sybase
  host: NyDbHost
  database: dbName
  username: someUser
  password: somePassoword

production: development

host: should refer to host name that was set up in the $SYBASE/interfaces file.

This is about it.
It took me about a week to get it running. Sybase support unfortenutly is very poor had to talk to many people in order to shed some light on that problem. I do thank them deeply.
—GregoryBluvshteyn

Work Arounds

noconvert ( Words of gratitude to bitsweat – on helping resolvin the issue )

In my legacy database I found PKs and FKs with the type of string. They used a string type but the value still remained numeric which would make sybase adapter to convert them to integer rather then leaving them be. I could not do update since my keys were automatically converted to integer. This are results of some tests.

Fixture


first:
  org_id: "1234"
  org_legal: "Some legal name"
  group_legal: "Some group legal name"
  org_short: "Test"

Test of default test assert_true


Loaded suite test/unit/paragon_counter_party_test
Started
E
Finished in 0.443311 seconds.
1) Error:
test_truth(ParagonCounterPartyTest):

ActiveRecord::StatementInvalid: RuntimeError: SQL Command Failed for Fixture Insert: INSERT INTO Paragon_Counterparty ([org_short], [org_legal], [group_legal], [org_id]) VALUES (‘Test’, ‘Some legal name’, ‘Some group legal name’, 1234)

Message: Implicit conversion from datatype ‘INT’ to ‘VARCHAR’ is not allowed.  Use the CONVERT function to run this query.

: INSERT INTO Paragon_Counterparty ([org_short], [org_legal], [group_legal], [org_id]) VALUES (‘Test’, ‘Some legal name’, ‘Some group legal name’, 1234)

This article is pertinent to activerecord-1.14.3 – will be fixed in 1.2

Changes that needed to be done in your activerecord sybase adapter.
\[lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/connection_adapters/sybase_adapter.rb]


#sybase_connection method add
@numconvert = config.has_key?(:numconvert) ? config[:numconvert] : true
#quote method 

#change 

  elsif value =~ /^{?[0-9]+$/o 

#to

  elsif @numconvert && force_numeric?(column) && value =~ /}-]?[0-9]$/o
#add following method somwhere under quote method def force_numeric?(column) (column.nil? || [:integer, :float, :decimal].include?(column.type)) end

Changes that needed to be done in config/database.yaml

#config/database.yaml add

numconvert: false

Question:

Is “Sybase Open Client for linux” the apparently proprietary software at: http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/openclient . If so, then I’m not certain our Sybase license allows us to use this software. Am I then out of luck? I was able to get PHP to talk to Sybase using the open source FreeTDS product. It’s frustrating to require a commercial product to do the same with Ruby/Rails.

Any advice?

reconnects

This adapter didn’t support reconnects so I submitted a patch at http://dev.rubyonrails.org/ticket/8400
I needed reconnects in order to use this in production since bouncing the webserver if we lose the DB connection isn’t really acceptable.

FreeTDS

I was having problems compiling against the latest OCS libraries. The compilation succeeded, but the connection attempts always failed, and no user name/password was being sent to the server.

I switched to the latest version of FreeTDS, and compiled against those. Everything worked perfectly.

Bath and Shower
Fragrance
Gift Sets
Hair Care
Makeup
Men’s Grooming
Shaving and Hair Removal
Skin Care
Tools and Accessories

Baby Apparel
Baby Bathing & Skin Care
Baby Bedding
Baby Car Seats
Baby Diapering
Baby Feeding
For Moms
Baby Furniture
Baby Gear
Baby Gifts
Baby Health & Baby Care
Nursery Décor
Potty Training
Baby Safety
Baby Strollers

Books – Business & Investing
Books – Children’s Books
Books – Comics & Graphic Novels
Books – Computers & Internet
Books – Cooking, Food & Wine
Books – Entertainment
Books – Gay & Lesbian
Books – Health, Mind & Body
Books – History
Books – Home & Garden
Books – Law
Books – Literature & Fiction
Books – Medicine
Books – Mystery & Thrillers
Books – Nonfiction
Books – Outdoors & Nature
Books – Parenting & Families
Books – Professional & Technical
Books – Reference
Books – Religion & Spirituality
Books – Romance
Books – Science
Books – Science Fiction & Fantasy
Books – Sports
Books – Teens
Books – Travel

Camera & Photo – Accessories
Camera & Photo – Camcorders
Camera & Photo – Digital Cameras
Camera & Photo – Film Cameras
Camera & Photo – Optics
Camera & Photo – Printers & Scanners

Health & Personal Care – Baby & Child Care
Health & Personal Care – Food & Snacks
Health & Personal Care – Health & Personal Care Outlet Store
Health & Personal Care – Health Care
Health & Personal Care – House Supplies
Health & Personal Care – Nutrition & Fitness
Health & Personal Care – Personal Care
Health & Personal Care – Sexual Wellness

Computers – Computer Add-Ons
Computers – Desktops
Computers – Handhelds & PDAs
Computers – Notebooks

Electronics – Accessories & Supplies
Electronics – Audio & Video
Electronics – Camera & Photo
Electronics – Car Electronics
Electronics – Computers & Add-Ons
Electronics – GPS & Navigation
Electronics – Home Automation & Security
Electronics – Office Electronics
Electronics – Service & Replacement Plans

Gourmet Food – Appetizers & Hors d’oeuvres
Gourmet Food – Baking Supplies
Gourmet Food – Beverages
Gourmet Food – Bread
Gourmet Food – Breakfast Foods
Gourmet Food – Candy
Gourmet Food – Cheese
Gourmet Food – Chocolate
Gourmet Food – Coffee & Tea
Gourmet Food – Cookies
Gourmet Food – Dairy Foods & Eggs
Gourmet Food – Desserts
Gourmet Food – Fruits & Vegetables
Gourmet Food – Gourmet Gifts
Gourmet Food – Jams, Jellies & Preserves
Gourmet Food – Meat, Game & Pâtés
Gourmet Food – Oils, Vinegars & Salad Dressings
Gourmet Food – Pasta, Beans, Grains & Rice
Gourmet Food – Prepared Meals
Gourmet Food – Salsas & Condiments
Gourmet Food – Seafood & Caviar
Gourmet Food – Seasonings, Herbs & Spices
Gourmet Food – Snack Food
Gourmet Food – Soups & Stocks

Grocery – Appetizers & Hors D’Oeuvres
Grocery – Baking Supplies
Grocery – Beverages
Grocery – Boxed Meals & Side Dishes
Grocery – Breads
Grocery – Breakfast Foods
Grocery – Canned & Packaged Goods
Grocery – Coffee, Tea & Cocoa
Grocery – Condiments, Sauces & Spreads
Grocery – Dairy & Eggs
Grocery – Desserts & Pastries
Grocery – Fruits & Vegetables
Grocery – Health & Family
Grocery – Herbs, Spices & Seasonings
Grocery – Household Supplies
Grocery – Meats
Grocery – Pasta & Grains
Grocery – Pet Supplies
Grocery – Seafood
Grocery – Snacks, Cookies & Candy

Home & Garden – Backyard Birding
Home & Garden – Bar Tools & Glasses
Home & Garden – Bedding & Bath
Home & Garden – Coffee, Tea & Espresso
Home & Garden – Cook’s Tools & Gadgets
Home & Garden – Cookware & Baking
Home & Garden – Cutlery
Home & Garden – Fresh Flowers & Indoor Plants
Home & Garden – Furniture & Décor
Home & Garden – Gardening Tools
Home & Garden – Grills, Smokers & Outdoor Cooking
Home & Garden – Heating & Lighting
Home & Garden – Kitchen & Table Linens
Home & Garden – Large Appliances
Home & Garden – Leisure & Fitness
Home & Garden – Outdoor Décor
Home & Garden – Patio Furniture
Home & Garden – Pest Control
Home & Garden – Pet Supplies
Home & Garden – Plants & Planting
Home & Garden – Small Appliances
Home & Garden – Tableware
Home & Garden – Vacuums, Cleaning & Storage
Home & Garden – Weather Instruments
Home & Garden – Wine Accessories

Industrial & Scientific – Adhesive Tapes
Industrial & Scientific – Fasteners
Industrial & Scientific – Industrial Abrasives
Industrial & Scientific – Industrial Adhesives
Industrial & Scientific – Industrial Cutting Tools
Industrial & Scientific – Industrial Hoses
Industrial & Scientific – Material Handling Equipment
Industrial & Scientific – Mechanical Components
Industrial & Scientific – Precision Measurement Products
Industrial & Scientific – Raw Materials

Jewelry – Accessories
Jewelry – Body Jewelry
Jewelry – Bracelets
Jewelry – Brooches & Pins
Jewelry – Charms
Jewelry – Children’s Jewelry
Jewelry – Earrings
Jewelry – Engagement
Jewelry – Jewelry Sets
Jewelry – Men’s Jewelry
Jewelry – Necklaces & Pendants
Jewelry – Religious Jewelry
Jewelry – Rings
Jewelry – Wedding & Anniversary

Kindle Store – Advice & How-to
Kindle Store – Arts & Entertainment
Kindle Store – Biographies & Memoirs
Kindle Store – Business & Investing
Kindle Store – Children’s Chapter Books
Kindle Store – Computers & Internet
Kindle Store – Fantasy
Kindle Store – Fiction
Kindle Store – History
Kindle Store – Humor
Kindle Store – Lifestyle & Home
Kindle Store – Literary Fiction
Kindle Store – Mystery & Thrillers
Kindle Store – Nonfiction
Kindle Store – Parenting & Families
Kindle Store – Politics & Current Events
Kindle Store – Reference
Kindle Store – Religion & Spirituality
Kindle Store – Romance
Kindle Store – Science
Kindle Store – Science Fiction
Kindle Store – Sports
Kindle Store – Travel

Miscellaneous – Aircraft
Miscellaneous – Antiques
Miscellaneous – Coins
Miscellaneous – Collectibles
Miscellaneous – General
Miscellaneous – Other Products
Miscellaneous – Scientific Supplies
Miscellaneous – Stamps
Miscellaneous – Vehicles
Miscellaneous – Watercraft

MP3 Downloads – MP3 Albums
MP3 Downloads – MP3 Songs

Music – Alternative Rock
Music – Blues
Music – Broadway & Vocalists
Music – Children’s Music
Music – Christian & Gospel
Music – Classic Rock
Music – Classical
Music – Country
Music – Dance & DJ
Music – Folk
Music – Hard Rock & Metal
Music – International
Music – Jazz
Music – Latin Music
Music – Miscellaneous
Music – New Age
Music – Pop
Music – R&B
Music – Rap & Hip-Hop
Music – Rock
Music – Soundtracks

Musical Instruments – Band & Orchestra
Musical Instruments – Bass Guitars
Musical Instruments – DJ, Electronic Music & Karaoke
Musical Instruments – Drums & Percussion
Musical Instruments – Folk & World Instruments
Musical Instruments – Guitars
Musical Instruments – Instrument Accessories
Musical Instruments – Keyboards
Musical Instruments – Live Sound & Stage
Musical Instruments – Recording Equipment

Office Products – Business Presentation Supplies
Office Products – Educational Supplies
Office Products – Mailroom Supplies
Office Products – Office Furniture & Accessories
Office Products – Office Lighting
Office Products – Office Supplies

Cell Phones & Service – All
Cell Phones & Service – Bluetooth
Cell Phones & Service – Camera
Cell Phones & Service – E-mail
Cell Phones & Service – Flip
Cell Phones & Service – Kid’s
Cell Phones & Service – Mobile Broadband Cards
Cell Phones & Service – MP3
Cell Phones & Service – PDA
Cell Phones & Service – Prepaid
Cell Phones & Service – Video
Cell Phones & Service – Wi-Fi

Software – Business & Office
Software – Children’s Software
Software – Education & Reference
Software – Graphics
Software – Home & Hobbies
Software – Language & Travel
Software – Linux
Software – Macintosh
Software – Networking
Software – Operating Systems
Software – Outlet
Software – Personal Finance
Software – Programming
Software – Software for Handhelds
Software – Utilities
Software – Video & Music
Software – Web Development

Toys & Games – Action Figures
Toys & Games – Activities & Amusements
Toys & Games – Arts & Crafts
Toys & Games – Bikes, Skates & Ride-Ons
Toys & Games – Construction, Blocks & Models
Toys & Games – Dolls
Toys & Games – Electronics for Kids
Toys & Games – Games
Toys & Games – Hobbies
Toys & Games – Kids’ Furniture & Room Décor
Toys & Games – Learning & Education
Toys & Games – Music
Toys & Games – Party Supplies
Toys & Games – Play Vehicles
Toys & Games – Preschool
Toys & Games – Pretend Play & Dress-up
Toys & Games – Puzzles
Toys & Games – Sports & Outdoor Play
Toys & Games – Stuffed Animals & Plush
Toys & Games – Toy Figures & Playsets

Unbox Video Downloads – International
Unbox Video Downloads – Movies
Unbox Video Downloads – Nonfiction
Unbox Video Downloads – TV

DVD – Action & Adventure
DVD – African American Cinema
DVD – Animation
DVD – Anime & Manga
DVD – Art House & International
DVD – Classics
DVD – Comedy
DVD – Cult Movies
DVD – Documentary
DVD – Drama
DVD – Educational
DVD – Fitness & Yoga
DVD – Gay & Lesbian
DVD – Horror
DVD – Kids & Family
DVD – Military & War
DVD – Music Video & Concerts
DVD – Musicals & Performing Arts
DVD – Mystery & Suspense
DVD – Science Fiction & Fantasy
DVD – Special Interests
DVD – Sports
DVD – Television
DVD – Westerns

"Computer & Video Games – ":http://astore.amazon.com/vgamesbuy-20

VHS – Action & Adventure
VHS – African American Cinema
VHS – Animation
VHS – Anime & Manga
VHS – Art House & International
VHS – Boxed Sets
VHS – Classics
VHS – Comedy
VHS – Cult Movies
VHS – Documentary
VHS – Drama
VHS – Educational
VHS – Fitness
VHS – Gay & Lesbian
VHS – Horror
VHS – Kids & Family
VHS – Military & War
VHS – Music Video & Concerts
VHS – Musicals & Performing Arts
VHS – Mystery & Suspense
VHS – Science Fiction & Fantasy
VHS – Spanish Language
VHS – Special Interests
VHS – Sports
VHS – Television
VHS – Westerns
VHS – Widescreen

Watches – Accessories
Watches – Casual Watches
Watches – Collectible Watches
Watches – Dress Watches
Watches – Fashion Watches
Watches – Pocket Watches
Watches – Sport Watches