Dedicated Servers Shared Servers Database Resident Connection Pooling When a client request is received, a new server process and a session are created for the client. When the first request is received from a client, the Dispatcher process places this request on a common queue. The request is picked up by an available shared [...]
Posts Tagged ‘Oracle’
Differences Between Dedicated Servers, Shared Servers, and Database Resident Connection Pooling (DRCP)
Posted in Oracle, tagged 11g, database, DRCP, Oracle on 2008/12/02 | Leave a Comment »
How to Connect to Oracle via JDBC
Posted in Oracle, tagged database, jdbc, Oracle on 2008/08/27 | Leave a Comment »
What is JDBC and what is it used for? JDBC is a set of classes and interfaces written in Java to allow other Java programs to send SQL statements to a relational database management system.Oracle provides three categories of JDBC drivers: JDBC Thin Driver (No local Net8 installation required/ handy for applets) JDBC OCI for [...]
How to install the Rails Oracle adapter
Posted in Rails, tagged adapter, Oracle, Rails on 2008/07/04 | Leave a Comment »
How to install the Oracle adapter This has been asked many times on rails-talk mailing list, so I want to summarize: sudo gem install activerecord-oracle-adapter –source http://gems.rubyonrails.org (Since ActiveRecord Oracle Adapter is moving to Rubyforge. “–source http://gems.rubyonrails.org” will be omitted ) or check it out from svn: svn co http://svn.rubyonrails.org/rails/adapters/oracle/lib/active_record/connection_adapters/ And note that [...]
Ruby-OCI8 1.0.2 gem available, a big thanks to Kubo. I’m glad to have proposed this and made a little contribution. To install Ruby-OCI8 via gem, follow these steps: su – root rpm -ivh oracle-instantclient-basic-11.1.0.1-1.rpm oracle-instantclient-devel-11.1.0.1-1.rpm (download link; or install oracle full client) export LD_LIBRARY_PATH=/usr/lib/oracle/11.1.0.1/client/lib:$LD_LIBRARY_PATH cd /usr/lib/oracle/11.1.0.1/client/lib ln -s libclntsh.so.11.1 libclntsh.so gem install ruby-oci8 In one [...]
ORA-17410: No more data to read from socket
Posted in Oracle, tagged database, Oracle on 2008/06/17 | 2条评论»
When using two JDBC connections accessing the same Oracle database, “SqlException : No more data to read from socket” thrown. This is because your database doesn’t support connection sharing, or it’s a dedicated server that will not respond to different clients. Solution 1: $ dbca –Configuration & Migration Tool —-database Configuration Assistant Select radio button [...]
Rails Oracle adapter is Getting Enhanced
Posted in Oracle, Rails, tagged adapter, Oracle, Rails on 2008/05/07 | Leave a Comment »
Raimonds Simanovskis is "planning to create activerecord-oracle-enhanced-adapter where to put my monkey patches of original adapter". It’s a good news since Rails Oracle Adapter svn respository has been in silence for a few months. This guy posted an idea "Oracle adapter for Ruby on Rails" on Oracle MIX 3 months ago, but seems that he [...]
