Open source projects from Tomas Frastia alias Tome

How to setup Custom XPATH Functions in OSB on Domain-level

There are many articles that describe how to set Custom XPATH functions in OSB but only in the Product-level i.e. …create custom XPath … package it …and custom XPath function… copy to OSB_ORACLE_HOME/config/xpath-functions/ but if you want to have a Custom XPath functions in OSB on the Domain-level then these functions must be copied to […]

, , , , , , ,

How to parse filtered rows from XLSX (Excel) file with Apache POI


If you want to parse the filtered rows from the XLSX (i.e. Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File Format) file with using Apache POI (Java API for Microsoft Documents), you can do it  so easily with using the method: org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRow.isSetHidden(), see example: //… List<Integer> filteredRows = new ArrayList<Integer>(); for (CTRow row : […]

, , , ,

How to delete assets from the OER 11g database


The Oracle Enterprise Repository 11g allows to delete assets i.e.  asset status=’Deleted’, but these assets are not really removed from the database. So, for delete all assets from the database, I created a simple SQL script which deletes all assets which have status = ‘Deleted’: delete from assetxml where assetid in (select a.ID from assets […]

, , , , ,

SQL Developer 4.0: how to change the location of Java home

SQL Developer

If you want to change the location of the Java home for Oracle SQL Developer then you can do this in the file: product.config with variable: SetJavaHome For Windows(The location of user files are often configured during installation): %APPDATA%\sqldeveloper\<version>\product.conf For Unix/Linux/Mac/Solaris: $HOME/./sqldeveloper/version/product.conf e.g. for windows: C:\Users\tomecode\AppData\Roaming\sqldeveloper\\product.conf and variable forlocation of the Java home is: SetJavaHome […]


Book review of: Getting Started with Oracle SOA B2B Integration : A Hands-On Tutorial

Getting Started with Oracle SOA B2B Integration: A Hands-On Tutorial

I got an offer from Packt Publishing to write a review of a new book: Getting Started with Oracle SOA B2B Integration : A Hands-On Tutorial.   So, my review is: This book is really handy tutorial that allows you to quickly become familiar with the problematics of the Oracle B2B. I read a book […]

, , , , ,

Maven: Creating dynamic project during the build the maven project

With the Maven plugin:maven-install-plugin and goal: install-file you can create dynamically Maven project without defining  the pom.xml file i.e.: install tempary (dynamic) the Maven project (ZIP, EAR, JAR, etc) from the parent project to the local repository. The following example shows an example: pom.xml file, where the parent project: demo-project during the build, create and […]

, ,

Previous Posts

Theme author: Engine: