Oracle Database
-
Frontpage
Retiring Sequences and Database Triggers with ADF 12c
What Is a UUID Some features from JAVA can retire creation of thousands database sequences for populating the ID columns in each table. In the past, the best practice was to create a table with a unique key column, primary key, creating a sequence and then creating a trigger with PL/SQL code for populating these […]
-
Frontpage
SQLBuilder Configuration (Configure JDeveloper to work with MS SQL Server)
This blog post is written to show how we can solve errors with SQLBuilder in ADF application on JDeveloper and WebLogic Server (the example uses MS SQL Server for a database). These errors usually appear when we use a database different from the Oracle Databases. For example: java.lang.ClassCastException: weblogic.jdbc.wrapper.PoolConnection_weblogic_jdbc_sqlserverbase_ddah cannot be cast tooracle.jdbc.OracleConnection To […]
-
Frontpage
Oracle DB - Monitor with nagios using check oracle health
This tutorial explains how to set-up the check_oracle_health script (credits to Gerhard Lausser) to work on your Nagios environment on CentOS (or any RedHat based Linux). This nagios plugin allows to monitor many oracle DB parameters – like tablespaces size, session, process count, SGA pool etc. Check it out on the author’s webset. The hardest […]
