Database

error invoking target irman ioracle of makefile

If you run into the error “error invoking target irman ioracle of makefile” while trying to install Oracle Database, and the log shows a missing ljavavm12 library, you may need to copy the java library like so:

cp ./u01/app/oracle/product/12.1.0/db_1/javavm/jdk/jdk6/lib/libjavavm12.a ./u01/app/oracle/product/12.1.0/db_1/lib/
By |November 22nd, 2013|Database|0 Comments

Double the Oracle DB connections from JBoss you expect?


  • <no-tx-separate-pools/>
     – Pool Transactional and non-Transactional connections separately.  Using this option will cause your total pool size to be twice max-pool-size because two actual pools will be created.  Used to fix problems with Oracle.
By |November 11th, 2013|Database, JBoss|0 Comments

MSSQL, jTDS, NVARCHAR and Slow Indexes

An application I’ve built is going into production soon. It’s the first application I’ve been involved with which will be using MSSQL server in production, I have some learning about MSSQL to do. After some research, I ended up using the jDTS JDBC driver instead of the Microsoft JDBC driver (which […]

By |May 23rd, 2009|Database, Java|4 Comments

Oracle Export (exp) and Initial Extent Size Issues

If you have a large database in Oracle, with a tablespace with say 2 gigabytes worth of data in it, and you then go in a delete a large number of rows from a large number of tables, and shrink it down to about 300 megabytes worth of data, and then you create an Oracle […]

By |March 8th, 2008|Database|2 Comments

An Easy Way to Drop All of the Tables in Your Tablespace in Oracle

run this command:

select 'drop table ', table_name, 'cascade constraints;' from user_tables;

Then copy the output and run that as a sql script.

By |March 8th, 2008|Database|0 Comments