Applying Hibernate to persist Java3D virtual scene in Oracle

A Java3D virtual scene includes not only 3D models but also other elements. To operate Java3D virtual scene as a whole in object-relational databases, a persistent scheme based on Hibernate was used to persist Java3D virtual scene in Oracle. According to the tree structure of Java3D virtual scene, 8 persistent classes and their bi-directional associations were created through Hibernate Object/Relational Mapping and association mappings. The 3D models were stored and modeled in Oracle 11g Spatial. Two custom java classes to map SDO_GEOMETRY data type of Oracle 11g Spatial were also developed to solve the problem that Hibernate does not provide support for mapping this type at present. The object-oriented 3D queries can be used in the persistent scheme, including Shap3D queries, partial Shap3D queries, attribute queries and 3D spatial queries. The developed 3D spatial queries supporting Oracle 11g spatial functions such as SDO_RELATE, SDO_WITHIN_DISTANCE, SDO_FILTE, SDO_INSIDE, SDO_ANYINTERACT and SDO_NN can be executed through Hibernate Query Language and Query by Criteria. The object-oriented 3D operations for the Java3D virtual scene objects can be effectively executed in Oracle through Hibernate persistent technologies.