How does it handle Oracle's unique DATE type?

It helps map Oracle DATE to Ruby Time objects and suggests using TRUNC or explicit ranges for accurate date filtering.

Can I use standard SQL pagination like LIMIT?

No, this skill guides you to use Oracle's ROWNUM syntax for limiting results and provides translation tables for developers coming from PostgreSQL.

Why is JDBC connection pool size important for JRuby?

Since JRuby uses real threads without a Global Interpreter Lock (GIL), the skill ensures your pool size matches your Puma thread count to prevent connection exhaustion.

Does this skill support standard Rails migrations?

No, it emphasizes using specialized migration folders as EBS DDL is typically managed by DBAs rather than standard Rails migrations.

Oracle JRuby for Rails

Name: Oracle JRuby for Rails
Author: Grupo-AFAL

byGrupo-AFAL

•

数据库管理

Facilitates the development and debugging of Rails applications using JRuby and the oracle_enhanced adapter for Oracle Database and EBS integrations.

This skill provides specialized technical patterns for developers working with JRuby and the oracle_enhanced adapter, specifically tailored for environments like Oracle EBS. It bridges the gap between ActiveRecord and the unique requirements of Oracle Database, offering precise guidance on Oracle::Base models, raw SQL execution using ROWNUM instead of LIMIT, and handling Oracle-specific DATE and CLOB types. It also includes critical configurations for JDBC connection pools and JRuby threading to ensure high-performance database interactions in non-GIL environments.

主要功能

01Implementation patterns for Oracle::Base and EBS table mapping

02Guidance on managing CLOB columns and avoiding adapter-specific pitfalls

031 GitHub stars

04Performance tuning for JDBC connection pools and JRuby threading

05Optimized raw SQL execution using Oracle-specific syntax like ROWNUM

06Handling of Oracle DATE types and multi-byte VARCHAR2 settings

使用场景

01Writing performant raw SQL queries that avoid PostgreSQL-to-Oracle dialect errors

02Mapping legacy Oracle EBS tables to Rails models without standard primary keys

03Debugging connection timeouts and thread-safety issues in JRuby production environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add grupo-afal/claude-plugins oracle-jruby

For use in Claude.ai and ChatGPT

主要功能

01Implementation patterns for Oracle::Base and EBS table mapping

02Guidance on managing CLOB columns and avoiding adapter-specific pitfalls

031 GitHub stars

04Performance tuning for JDBC connection pools and JRuby threading

05Optimized raw SQL execution using Oracle-specific syntax like ROWNUM

06Handling of Oracle DATE types and multi-byte VARCHAR2 settings

使用场景

01Writing performant raw SQL queries that avoid PostgreSQL-to-Oracle dialect errors

02Mapping legacy Oracle EBS tables to Rails models without standard primary keys

03Debugging connection timeouts and thread-safety issues in JRuby production environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add grupo-afal/claude-plugins oracle-jruby

For use in Claude.ai and ChatGPT