migrate-oracle-aq-to-scalardb

Generate Oracle AQ setup SQL and Java consumer code for ScalarDB migration.

12|1|Updated Mar 23, 2026
One-click install
npx skills add https://github.com/wfukatsu/nexus-architect --skill migrate-oracle-aq-to-scalardb
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: migrate-oracle-aq-to-scalardb
Source: https://github.com/wfukatsu/nexus-architect/tree/main/skills/migrate-oracle/migrate-oracle-aq-to-scalardb
Command: npx skills add https://github.com/wfukatsu/nexus-architect --skill migrate-oracle-aq-to-scalardb

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires aqapi.jar, javax.jms-api-2.0.1.jar, ojdbc11, scalardb, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill automates the migration of Oracle AQ setup and Java consumer code to ScalarDB, streamlining the process and reducing manual effort.

Core Features & Use Cases

  • SQL Generation: Automatically generates SQL for Oracle AQ setup (payload types, queues, enqueue triggers/SPs).
  • Java Consumer Code Generation: Generates Java consumer files that dequeue messages and process them using the ScalarDB Java Transaction API.
  • Use Case: If you need to migrate an Oracle AQ application to ScalarDB, this Skill can generate the necessary SQL and Java code to facilitate the migration.

Quick Start

Run the Skill with the necessary input files and specify the output directory: migrate-oracle-aq-to-scalardb -i input_directory -o output_directory.

Frequently Asked Questions about migrate-oracle-aq-to-scalardb

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I migrate Oracle AQ to ScalarDB?

Migrate Oracle AQ to ScalarDB by generating SQL for Oracle AQ setup and Java consumer files that process messages using the ScalarDB Java Transaction API. The migration requires raw schema data, a schema report, and migration strategy documentation as input.

What SQL and Java code is generated for an Oracle AQ to ScalarDB migration?

The migration generates SQL for Oracle AQ setup including payload types, queues, and enqueue triggers or stored procedures, alongside Java consumer files that dequeue messages and process them using the ScalarDB Java Transaction API.

What dependencies do I need to run an Oracle AQ to ScalarDB migration?

You need aqapi.jar, javax.jms-api-2.0.1.jar, ojdbc11, and the scalardb library to run the Oracle AQ to ScalarDB migration and execute the generated Java consumer code.

Can I automate Oracle AQ setup and Java consumer code generation for ScalarDB?

Yes, you can automate Oracle AQ setup and Java consumer code generation for ScalarDB by running the migration script with an input directory containing schema data and an output directory for the generated files.

What input files are required for Oracle AQ to ScalarDB code generation?

Oracle AQ to ScalarDB code generation requires raw schema data, a schema report, and migration strategy documentation provided in the input directory to accurately generate the necessary SQL and Java files.