That is just the basic configuration. Hope that helps.
enviroment.rb
config.gem “ruby-plsql”, :lib => “ruby_plsql”
models/some_model.rb
require “ruby_plsql”
class SomeModel < ActiveRecord::Base
def persist
plsql.connection = ActiveRecord::Base.connection.
raw_connection.connection
appraisal_id = plsql.bra_customhr_eval_pk.create_appraisal(
:p_employee_number => self.appraisee.employee_number,
:p_appraisal_template_id => @avalTemplate[0].template_id,
:p_period_start_date => @avalTemplate[0].valid_from,
:p_period_end_date => @avalTemplate[0].valid_until,
:p_business_group_id => self.appraisee.business_group_id,
:p_appraisal_id => nil,
:p_object_version_number => nil)[:p_appraisal_id
end
end
I finally got jndi with jboos to work in jruby on rails . Bellow is an example of files configuration.
I was getting the bellow error:
javax.naming.NamingException has no valid JNDI binding
=====oracle-ds.xml=====
<?xml version=”1.0″ encoding=”ISO-8859-1″?>
<datasources>
<!– Início: Datasource Technip –>
<local-tx-datasource>
<jndi-name>simu3</jndi-name>
<connection-url>jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:simu3</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>login</user-name>
<password>password</password>
<attribute name=”MinSize”>5</attribute>
<attribute name=”MaxSize”>20</attribute>
<attribute name=”BlockingTimeoutMillis”>5000</attribute>
<attribute name=”IdleTimeoutMinutes”>15</attribute>
<idle-timeout-minutes>5</idle-timeout-minutes>
</local-tx-datasource>
</datasources>
=====warble.rb=====
have to enable the line in warble.rb like this:
# Additional files/directories to include, above those in config.dirs
config.includes = FileList["jboss-web.xml"]
# JNDI data source name
config.webxml.jndi = “jdbc/simu3″
=====database.yml=====
production:
adapter: jdbc
jndi: “java:/simu3″
driver: oracle.jdbc.driver.OracleDriver
=====jboss-web.xml=====
<?xml version=”1.0″ encoding=”UTF-8″?>
<jboss-web>
<resource-ref>
<res-ref-name>jdbc/simu3</res-ref-name>
<jndi-name>java:/simu3</jndi-name>
</resource-ref>
</jboss-web>
The most important thing was the creation of jboss-web.xml
