similar to: Database Error Messages

I''ve been runnning Perl under Apache for a while but have decided to try using Ruby-on-Rails. My current database is postgreSQL 8.1. I have no problem connecting to it using Perl or PHP 5. However, I''m obviously missing something ''cos no matter what I do I cannot connect to the database from RoR. I have followed all of the instructions I could find and when I start

Hi, We have worked on a problem of connection: Connect to two databases with a single ActiveRecord::Base model class within the same action The main difficulty is how to disconnect the actual connection properly and then let the ActiveRecord establishes a new one. The actual function "remove_connection" removes the connection, but its doesn''t unbind the link between rails and

Hi I am trying to get RoR to work with Postgresql 8,2.5 (latest stable version) Steps taken 1. Download Postgresql 1.82 and installed successfully 2. Edited my Database.yml development: adapter: postgresql database: test_development username: postgres password: xxx host: localhost test: adapter: postgresql database: test_test username: postgres password: xxx host: localhost

I need to store rather large data in the database using blobs. I''ve been working with Rails and have designed a proof-of-concept setup that works pretty well, except there''s a considerable performance hit with very large files due to the fact that ActiveRecord loads the entire blob into memory before the data can get passed to send_data. I know at least one person is going

Hi, I really need help to understand what is happening while Rails connect to a database, (we area actually using postgresql, so my example will be with postgresql) What I understand is Rails is able to connect to different DB. Actually, this is what we want, and we have made some tests, everything is juste fine. However, all these tests lead us to some important questions that we did find the

I need to make a simple read-only web query page that allows the user to enter in a longitude and latitude and get a list of areas within which those coordinates occur. I have a postgis (postgresql) databases that contain shape files for county, township, range and section. I can query these databases in the following way from within postgresql in the database county county=# SELECT name_lc

Hi, We have experienced some problems with ActiveRecord::Base class of Ruby-Rails. We are building a web-application based on the Ruby-rails framework and the web-application needs to access to difference databases, so we do not pre-define our database accesses in the database.yml file. In fact, we are using the ActiveRecord::Base.establish_connection() to connect to our database, the function

I''m a noob to rails and i could use some help. Fedora Core 5 Ruby 1.8.4 Rails 1.1.2 Postgres for My Database Using webrick for testing at the monent but have lighttpd installed but the service is diabled. Here are my steps that i fillow. In my home directory i type rails test #cd test #sudo chmod -R 775 log #sudo chmod -R 775 public #ruby script/server Then i make my postgres database

I am unable to connect to my databases. Here is the error I am getting: MysqlError (Can''t connect to local MySQL server through socket ''/var/run/mysqld/mysqld.sock'' (2)): Here is my database.yml: # MySQL (default setup). Versions 4.1 and 5.0 are recommended. # # Get the fast C bindings: # gem install mysql # (on OS X: gem install mysql --

i have installed the asterisk 1.6 before that installed the necessary packages in Debian, * i followed the steps as follows, root at astserver: ~# apt-get install unixodbc unixodbc-dev odbc-postgresql postgresql-8.1 postgresql-contrib postgresql-dev * then i installed the asterisk 1.6 version with the odbc modules as in the selected list. * then i created the database as asterisk and the user

Since interpreting defaults in the database has been ripped out (for PostgreSQL at least), what''s the standard way of specifying defaults now? Right now, I''m doing this: # model def create self.datetime = Time.now super end I hate it. I know there are the ''*_at/on'' automatic fields, but that''ll entail combing through all my code changing

Since upgrading to rails 1.0 I keep getting a parse error in database.yml. I have tried multiple configurations of both mysql and postgres and continue getting this error message when trying to generate a model or scaffold. -Andrew

Been thinking about playing with PostgreSQL. When I did my research, on the PostgreSQL site, there were a few tools they "recommended" for design, display of schemas, etc. Open System Architect seemed to fit my demands, but unfortunately, the installation documents do not exist, at least the links go in a circle to nowhere. There's a binary which I assume can be executed, but at

When saving a data frame with long character variable, approximately longer than 30000 characters, to a text field in PostgreSQL, using RODBC on Windows XP, I get a timestamp saved to the database instead. Is there any way to extend the number of characters that a text variable can receive? Here are the details of my case (simplified): I'm using PostgreSQL to create a table CREATE TABLE

Hi, I''m using postgresql 8.1, rails 1.0, and I have a strange problem on a datetime field (timestamp without time zone in postgresql). As shown below, the field "value" sometimes returns a string, and sometimes a Time instance, depending of where the value is used....: * breakpoint session _from inside an instance method_ of the object: value => "1996-05-01

Is there way to get the scaffold command to work with PostgreSQL database views? -- Posted via http://www.ruby-forum.com/.

Hi List, I am reading table from postgres database into R session using RJDBC, table contains 150 columns and 200000 rows. Sample code is as below, which works fine with smaller tables. ######################################################################## db_driver <- mydir$db_driver db_jar_file <- mydir$db_jar_file db_server <- mydir$db_server db_server_lgn <- mydir$db_server_lgn

Hello everybody, Whatever I use as the host address of my PostgreSQL database server, I always get a connection if I'm accessing the database from R on the same machine and none if I'm trying to do so from a remote client. PostgreSQL is running on a windows xp machine as the RDBMS, JDBC, R, DBI package, RODBC package, rJava package and RpgSQL package are installed locally and remotely.

Hi All, I have a R script which returns a set of records from the postgresql to the Java program and I want to print those records in Java.My script is like this: library(RPostgreSQL) fnct1 <- function() { drv <- dbDriver("PostgreSQL") r <- dbConnect(drv, host='local', port='1234',dbname='db', user='user',

I have a wizard which consists of two pages. To keep it simple let''s say that the first page asks the user to select a state from the drop down menu. In case the user doesn''t select any state, an error message needs to be displayed. Ideally I would like to do something like this. def new selected_value = params[:addevent][:state_id] if selected_value == "-1"