bug adapter firebird 2.1.2 ?

rubyonrails-talk
1

mydb.fdb on windows firebird 2.0.3.12981 step_1 gbak.exe -v -t -user sysdba -password ****** 127.0.0.1/3050:D:\webdb \PROD\mydb..fdb D:\webdb\back\mydb.fbk

on server linux firebird 2.1.2.18118 step_2 linux-server:# ftp mydb.fbk step_3 linux-server:# gbak -c -v ... mydb.fbk mydb.fdb

2

Hi Mary,

I'm Italian but I write the response in eglish (sorry for my poor english)...

Some time ago I had a problem like your under FireBird 1.5.x and FireRuby 0.4.1 just after a db restore.

The issue was with casting function on the rails firebird adapter the error was something like "cannot cast CAST(DECIMAL(0,0)"...

I remember that I was able to solve the problem on firebird_adapter.rb executing something like sql_query.gsub!("DECIMAL(0,0)", "DECIMAL(0,18)") before the returning row.

Hope it helps...

3

Gianluca Tessarolo wrote:

Hi Mary,

I'm Italian but I write the response in eglish (sorry for my poor english)...

Some time ago I had a problem like your under FireBird 1.5.x and FireRuby 0.4.1 just after a db restore.

The issue was with casting function on the rails firebird adapter the error was something like "cannot cast CAST(DECIMAL(0,0)"...

I remember that I was able to solve the problem on firebird_adapter.rb executing something like sql_query.gsub!("DECIMAL(0,0)", "DECIMAL(0,18)") before the returning row.

Hope it helps...

Il mio problema è che non viene generato nessun errore. Semplicemente il valore è aumentato di un fattore 100. Il problema sembra dei metodi di classe tranne find. Ciao

4

Ok ho visto…

mi sembra che stai comprando l’errore con versioni diverse dei vari camponenti:

windows (ok) => FireBird 2.0 + activerecord-firebird-adapter + FireRuby

linux (errore) => FireBird 2.1 + fb_adapter + fb

Magari sto dicendo una cosa ovvia o magari banale ma secondo me dovresti provare a utilizzare su linux gli stessi componenti che stai utilizzando su windows (activerecord-firebird-adapter + FireRuby)