Displaying 20 results from an estimated 30000 matches similar to: "Determining which tables are available (oracle)"
2011 Sep 02
3
problems with oracle xe server connection
i''m working on ubuntu 11.04; i need to create some rails application
with oracle database on local computer.
i installed: ruby 1.9.2, rails 3.1, oracle 10g XE, rubu-oci8 2.0.6,
gem ''activerecord-oracle_enhanced-adapter'', create database user named
''orak'' with password ''orakpass'' through 127.0.0.1:8080/apex, i maked
new application
2010 Feb 06
0
I can only halfway connect to oracle
Gurus...
If I set up my project to use SQLite (so it can come up) and attempt to
connect to oracle via:
oracle_connect = $application_properties[$connect_string]
oracle_conn = OCI8.new(oracle_id, oracle_password, oracle_connect)
where oracle_connect equals ''//bobs.big.boy.gov:1521/D09'' (with or w/o
the introductory //) my rails app connect to the oracle database just
fine.
If
2010 Dec 15
3
ORA-12514: TNS:listener d oes not currently know of service requested in connect descriptor (OCIEr
Hi I am a new to ROR and learning this framework from various tutorials.
I have my new application and had the rails generate scaffold get going
but after this when I first ran the rake db:migrate I got this ERROR!
ORA-12514:
TNS:listener d
oes not currently know of service requested in connect descriptor
(OCIError)
I''m using database which is on a server and have used the tnsnames.ora
2010 Apr 27
3
"ORA-12154: TNS:..." error after successful oracle connection
Hi,
After a few days of struggling, I was able to run this command
successfully.
ruby -r oci8 -e "OCI8.new(''xxx_dba'', ''xxx'', ''//xxxx:1521/
xxxxx.xxx.org'').exec(''SELECT 1 from dual'') {|r| puts r.join}"
I got "1.0" as output and I got my prompt back.
So, I went back to the RoR app that I am working on,
2005 Jul 27
7
Oracle OCI8, or "am I going crazy?"
All of a sudden, on three different systems, the "server_ip_address/sid_name"
syntax in database.yml has stopped working for me.
I can''t even do a OCI8.new(blah blah blah) statement from an IRB shell.
I get "ORA-12541: TNS:no listener", or some variant, depending on how I phrase it.
On systems where I have a real deal client installed, and OCI can find the
tnsnames
2006 Jul 28
0
cannot read a table in Oracle when scaffold''ing
I installed Ruby, Rails (using gems install rails -v 1.0.0 --remote),
the OCI driver for windows to access Oracle (C:\> ruby
ruby-oci8-0.1.13-mswin.rb).
I create a an application in rails (C:\> rails tabella)
I have a table called tabella in Oracle in the RAILSDB database.
I modify my database.yml to read:
development:
adapter: oci
username: ruby
password: ruby
host: RAILSDB
I
2006 Jan 10
5
Oracle 10g Express - generate scaffold gives error
Hello,
I have Oracle XE installed.
I have a table USERS.
When I try to generate a scaffold it gives me this error.
I tried also with Mysql and it worked.
E:\radrails\projects\MPS>ruby script\generate scaffold user
exists app/controllers/
exists app/helpers/
create app/views/user
exists test/functional/
dependency model
exists app/models/
exists
2005 Apr 25
0
Oracle connection problem: rails ok!
Thanks Dan
That fixed it.
> Date: Sun, 24 Apr 2005 22:32:34 -0700
> From: Dan Peterson <dpiddy-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
> Subject: Re: [Rails] Oracle connection problem: ruby ok, rails not ok.
> To: rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> Message-ID: <56d3286d0504242232471fe782-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org>
>
2008 Jun 11
6
how to create new database to oracle ?
i have rails-2.1.0
my database.yml
development:
adapter: oracle
database: pe
username: or
password: or
>rake db:create
>rake db:version --->Current version: 0
>rake db:migrate
rake aborted!
ORA-12154: TNS:could not resolve the connect identifier specified
(See full trace by running task with --trace)
is above idea is possible, then how ?
and
i thing i should give service
2009 Sep 11
0
oracle_enhanced problem connection
Hello,
I have a problem connecting to the development Oracle database but not
to production, despite using the same credentials and connecting to the
same database.
The database is a legacy app that needs a new enhanced front end, so I''m
not designing a new database just interacting with the existing one.
Here is my database.yml:
development:
adapter: oracle_enhanced
user: user
2012 Jun 08
1
Announce: puppetlabs_spec_helper 0.1.0 Available
puppetlabs_spec_helper is a Rubygem to make writing and running module spec
tests using rspec-puppet easier. It includes a set of common rake tasks and
a spec_helper that correctly initializes puppet and rspec-puppet for
testing.
The code is available on github at
http://github.com/puppetlabs/puppetlabs_spec_helper. Patches are welcome.
To convert a module with existing spec tests to use the
2009 Mar 05
0
Insert using Rake Task
Hi,
Anyone can help me, I run my source code using rake task. It seems no
error was trace, but when I look the table it doesn''t insert.I select
the data here MysqlDB.Tablename and update/insert here
SQLserverDB.TableName.
# Start Here
# rake mysqldata_select:sqldata_update
def clean_html(html)
new_html = strip_tags(html) # remove html tags
new_html = decode_entities(new_html) #
2013 Feb 01
0
rake db:migrate failing against oracle
Hello All --
I am using jruby 1.6.7.2 with rails 3.2.11 to create a brown bag for
several other developers. I cannot get the migration to work to save my
life...
In my database yaml file I have the following:
---
development:
adapter: jdbc
driver: oracle.jdbc.driver.OracleDriver
url: jdbc:oracle:thin:@localhost:1521:xe
username: brownbag
password: brownbag
pool: 500
---
When I run:
2011 Apr 20
6
rake db:create fails
Hello folks,
I´m here trying to find the way to solve my problem.
When i try to run
rake db:create or rake db:create:all
the process stops and the databases are not created.
I change the directives, putting --trace before the rake db:create and
the steps are
C:\appws\cookbook>rake db:create --trace
(in C:/appws/cookbook)
** Invoke db:create (first_time)
** Invoke db:load_config (first_time)
2005 Mar 21
3
Oracle Adapter on Mac OS X?
I had previously gotten Maik Schmidt''s patch for Oracle working, but
now am trying the official Oracle adapter with the latest Rails. I''ve
been trying to get the OCI8 connector to install under OS X, but get
the following error. Has anyone gotten it working?
----
[waterdog:~/Desktop/ruby-oci8-0.1.9] stmpjmpr% ruby setup.rb config
---> lib
---> lib/DBD
---> lib/DBD/OCI8
2011 Apr 26
1
problem populating table using rake db:fixtures:load
I''m running Rails 3 and I''m trying to populate a table using rake
db:fixtures:load, and I''m getting a "Could not find" file error.
The table is called stores, and I''ve confirmed that it exists, and the
data is in stores.yml in my test/fixtures directory. The command I''m
running is rake db:fixtures:load FIXTURES=stores.
The error message
2009 Apr 14
1
Oracle oci8 => OCIError: OCI Library Initialization Error
I''m trying to get ActiveRecord working with an Oracle DB over the
instant client.
On a 32bit machine, I can require ''oci8'':
Linux xxx.xxx.xxx.xxx 2.6.9-78.0.17.ELsmp #1 SMP Thu Mar 5 04:52:17 EST
2009 i686 i686 i386 GNU/Linux
irb(main):001:0> require ''oci8''
=> true
However, on a 64bit machine:
Linux xxx.xxx.xxx.xxx 2.6.18-128.1.6.el5 #1 SMP Tue
2009 May 05
3
Oracle-JRuby error
I am trying to migrate from RoR/MYSql to JRoR/Oracle. I am using Active
Record JDBC to talk to the database. The Migration process to create and
populate the database tables has been painful. My latest issue is the
method new_date is undefined in the JDBC adapter. I have the following
gems installed:
*** LOCAL GEMS ***
actionmailer (2.2.2)
actionpack (2.2.2)
activerecord (2.2.2)
2008 Feb 22
2
Connecting to Oracle from Rails 2.0.2
Long afternoon, but finally got it. Hope this spares you some pain:
Installation instructions mainly based on:
http://ruby.about.com/od/enterprise/ss/ruby_oracle.htm
Install Oracle Instant Client:
mkdir C:\oracle
cd c:\oracle
Get the following files from here:
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
and unzip them into the c:\oracle\
unzip
2008 Sep 15
0
Instant Client: Connecting Oracle and Mac
Hi,
I am having a terrible time installing Instant Client to connect my
Mac and an Oracle db.
I am using the following instructions:
http://www.foliosus.com/2007/11/19/connecting-ruby-on-rails-to-oracle-on-an-intel-mac-in-leopard-mac-osx-105/?css=Banksia
All goes seemingly well until the Compile the ruby-oci8 library
section.
ruby setup.rb config
returns the following error message: