Skip to content

DB Ninja v0.1.2 - Linux development/test preview

Pre-release
Pre-release

Choose a tag to compare

@milesplay milesplay released this 11 Oct 05:11
78f4809

DB Ninja 0.1.2 - Linux development/test preview

Development and test environments only. Do not install or run in production.
This is a community customization, not a PTC-certified product.

Commit: 78f4809f7ac2e69a956f0093ff46d68a5deb3d4c

What changed

  • oracle-check.sql now reports analyze_any_check
    from session_privs: WARN when ANALYZE ANY is absent (every capture
    then reports ORA-20000 and examines every table at stop), otherwise PASS.
    The check is a read-only SELECT.
  • preflight now warns (non-fatal) when codebase/WEB-INF/log4jMethodServer.properties
    defines a top-level Log4j filter, because SQL evidence is then UNAVAILABLE.
    Commented-out entries and appender filters are ignored.
  • DATABASE-SETUP.md makes the ANALYZE ANY grant an
    explicit pre-install decision and shows how to verify it in a new session.
    COMPATIBILITY.md and
    OPERATIONS.md document both prerequisites.
  • AGENTS.md makes every WARN from preflight or
    oracle-check.sql a mandatory stop that requires the owner's explicit
    decision. After the first authorized capture, agents must confirm that
    neither warning appears before reporting success.

The runtime Java sources, custom JAR, ClassInfo files and generated-model
baseline are unchanged from 0.1.0. The original build timestamp is preserved.
This tooling/documentation patch does not require a runtime redeployment or
restart. Existing installations should run the updated preflight and
oracle-check.sql and resolve any WARN with the owner.

Download and install

Download both assets below:

  • WindchillDbNinja-0.1.2-linux-x64.zip - the complete tracked source/install
    package, including custom compiled resources, DDL, tools and English docs.
  • SHA256SUMS - the ZIP's SHA-256 checksum.

Run sha256sum -c SHA256SUMS before extraction. Follow
INSTALL.md and AGENTS.md.
Do not download just the JAR; the source, metadata and deployment resources
are part of the verified package contract.

The binary profile is unchanged from 0.1.1: Linux x64, Windchill Services
13.0.2.11 build32 (13.0.2.0 CPS11), Corretto 17.0.12, Oracle 19c, traditional
codebase
. Different profiles require target generation and separate
qualification. Windows is unsupported as shipped.

Verification and limits

  • 300 of 301 Node tests passed (0 skipped, 0 TODO). The one failure,
    fresh prebuilt installation plans every runtime resource from the checkout without live writes or old artifacts, is environmental: the prebuilt
    profile requires Java 17 and the publishing host runs JDK 21
    (Prebuilt Java major version mismatch). It also failed before this change.
  • check:publication --require-prebuilt passed: 160 reviewed files, with the
    Git index matching the reviewed working tree.
  • The ZIP was built with git archive from tag v0.1.2. It has a single
    WindchillDbNinja-0.1.2/ root, its 160 files match the tag exactly, and
    schema-package.mjs verify passed on the extracted copy.
  • The Java assertion suite and validate.mjs all --prebuilt were not rerun
    for this release; the runtime artifacts are unchanged from 0.1.0.
  • Not yet covered: a regression test for the new preflight Log4j warning,
    and classification of multi-line ORA messages in capture health.

No Oracle grants, DDL, live deployment, restart or capture was performed for
this publication.
DBA approval and runtime acceptance remain separate
requirements. A repository link never supplies credentials or authorization.

See the changelog.
No licensed PTC/Oracle libraries, site configuration or private evidence is included.