Signsoft intelliBO Reference
User guide
Introduction
Installation
Content of the JAR archives
Configuration
Licensing
Introduction to JDO
General Concept
Datastores
The Mapping Descriptor File
Structure and Elements of a JDO File
How to specify persistent fields and attributes
Minimal Sample
Working with JDO
PersistenceManager and PersistenceManagerFactory
Storing objects in the database
Get objects from the database
JDOExceptions
First Steps
Database
Sample structure
A Sample Ant Script
Business objects
Class Person
The mapping file Person.jdo
The JDO file in general
Description of Person.jdo
Creation of Person.jdo with the Signsoft intelliBO Eclipse plug-in
Enhancing the class Person
Creating the data source
Application
System configuration with ibo-config.xml
Persistence Manager
Creating new objects
Finding Objects
Deleting Objects
Application class Main.java
Sources of errors
Licence not found
Problems with the Enhancer
Classes are enhanced
Classes are not enhanced
Enhanced business classes not found
Ibo-config.xml not found
Mappings and Relations
Field Mappings
Direct Field Mapping
Code Mapping
Serialized Object Mapping
Enumeration Mapping
Enumerations in JDOQLQueries
Virtual Field Mapping
Multi Src Field Mapping
Exchange Operations
Mapping of SQL types
Standard types
BLOB and CLOB fields
Relationship Mappings
One-To-One Relation Mapping
Bidirectional Relation
One-To-Many Relation Mapping
Bidirectional Relation
Many-To-Many Relation Mapping
Bidirectional Relation
Optional Relations
Cascade Delete
Attibute Types in Relations
Collection Type
Map Type
Array Type
Constraints
Aggregated Mappings
Aggregated Object Mapping
Aggregated Collection Mapping
Inheritance
Each Class in a separate Table
Relationships between Tables
All Classes in one Table
Redundant Fields
Inheritance Provider
Object Identity
Application Identity
Datastore Identity
Automatic Object Id Generation (Object Identity Generators)
Sequence Table
User-Defined Object Id Generators
Get Object By Id
Queries
Running queries
Filtering
JDOQL Query Language
String Operations
Parameters
Variables
Filtering For NULL-Values
Ordering
Supported Query Languages
JDOQL
SQL
ResultSet Queries
Executing SQL Commands Directly
Using SQL and JDOQL together in one query
Loading of dependent Attributes
Result Set Size
Use of Result Types
List as Result Type
Extended Result Types
Optimizing JDOQL Query-SQL
In Memory Query
Bulk Queries
Bulk Delete
Bulk Update
Filters in Bulk Queries
Fetchplans
Definition of fetch groups
Detachable Instances
Defining detachable instances
Detaching instances
Explicit detachment
Detach after commit
Detach on close
Working with detached instances
Attaching instances
Locking
Pessimistic Locking
Optimistic Locking
Using timestamp or version
User defined Optimistic Locking
Cache
Levels Of Cache
Shared Cache Visibility Scope
Local Cache
Shared Cache
Distributed Shared Cache
Configuration Reference
Cache Reference Types
Object Cloning
Changing The Cache Implementation
Distributed Cache Options
API Reference
Cache And CacheManager
Logging
Logging Domains
Logging Setup
Configuration File
Source Code
Application Server Integration
Overview IntelliBO Extensions
System configuration
Introduction
Programmatic Configuration
Configuration With An Option File
File based Configuration
Use of the configuration file
Overview ibo-config.xml
System configuration settings
Register Persistence-Capable Classes
Security Provider
Enviroment Setup
Query Setup
Resource Setup
Sample Configuration File
Referential Integrity
The fkrelations.xml file
Usage
Database Support Drivers
Oracle 8
Oracle 9
Oracle 10
DB2 UDB
Derby
Firebird
H2
HSQL
Informix
Mckoi
Microsoft SQLServer
MySQL
PostgreSQL
Sybase
Tools documentation
Introduction
Apache Ant Tasks for Signsoft intelliBO Tools
License Tool
Verifier
Enhancer
Schema Generator
Generated Files
Usage
Experimential Tools
Migration guide
Introduction Migration
Migration guide to Signsoft intelliBO 4.0
Getting started
Check list
Setting up Signsoft intelliBO4
Setting up your development environment
Changing the Build-System
Changes in the archive structure
Changes in the intelliBO tools
JDO-Mappings
Adapting the application code
The new ibo-config.xml format
The new logging system
Exception handling
Interface relocations
Interface enhancements
Discontinued features
Trouble shooting
Important bug fixes
Incomplete Fetch Groups
Undefinable object state after close
Vagabond persistent objects
Careless object id checks
Access to deleted objects
Override of other PersistenceManager's configurations
Forgetful shared cache
Too strict SQL joins
Careless parameter type check
Closing persistence managers with open transactions
Alternating object identity
Setting up a test environment
Migration guide to Signsoft intelliBO 4.1
Samples documentation
Introduction
Structure
Run the Sample
Samples Overview
First Steps
Field Mappings
Relationship Mappings
Inheritance Mappings
Object Id
Locking
Queries
Fetchplans
Detachable Instances
Optimizations
Advanced
Architecture
JSF Sample
Spring Samples
Swing Sample
Struts Sample
EJB Samples
Error codes
0xxx... Mapping Errors
1xxx... Core System Errors
2xxx... System Errors
3xxx... Query Service Errors
4xxx... Transaction Service Errors
5xxx... Lock Service and Shared Cache Errors
6xxx... Object Id Generator Errors
7xxx... Resource Service Errors
8xxx... Communication Errors
9xxx... Miscellaneous Errors
API documentations
JDO API (JavaDoc)
Additional documents (pdf)
JDO 1 specification
JDO 2 specification
JPA specification