I am always very annoyed when my Oracle user is automatically expired and locked. This is done automatically at 180 days in some installations. The following are some very easy steps for a question that everybody is asking again and again on forums. STEP 1: Connect to the DB sqlplus / as sysdba STEP 2:… Read More »
The following are some interesting SQL Server related links: A lot of times you have to relocate the data and log files of a SQL Server. It can be that the default installation was not OK or you change the storage. The following tutorial is very useful Move System Databases Using SQL Server with R… Read More »
A fabulous piece from Rick Osgood on Hacking Microsoft SQL Server Without a Password. Using a man in the middle attach and ARP spoofing with a combination of free tools like Wireshark, Ettercap filters is able to hijack the SQL connection and execute arbitrary queries instead of the real queries. He manages even to create… Read More »
Sometimes the db2 exceptions are cryptic or hidden by the application layer. In this case the only way to find the db2 SQL exception is to investigate in db2 logs. First check the log level setup in the Database Manager Configuration. Log in as the user under which db2 instance runs, in my case db2inst1.… Read More »
Yet another thread of DB2 errors from an EJB application that connects to a DB2 instance. The reported thread of errors: [7/13/16 12:46:38:670 IST] 00000098 SqlExceptionH Z org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions [jcc][t4][102][10040][4.19.26] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions… Read More »
Sometimes Java and databases do not use the same standards to represent data. This can lead to strange exceptions for which sometimes can be hard to pin point the cause. We have the following Exception reported in the enterprise application log. Let’s analyse the errors. [7/13/16 12:46:32:752 IST] 00001456 SqlExceptionH Z org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions SQL Error:… Read More »
Especially when creating a demo image of an enterprise system we want to have a smaller footprint than the full system that was cloned. The same is true when the image is used for volume benchmarks. Between different benchmark sessions we want to clean the old test data and maybe in the end we want… Read More »
In a setup having an enterprise application depending on a database instance where some tables are defined as nicknames to tables from a federated database, it can happen to get this very cryptic DB2 error. I already had a post related to this case when the setup uses access to a federated database https://blog.voina.in/db2-sql-error-30090-caused-by-read-only-table-nickname-to-a-federated-database/. You… Read More »
I wanted to move my test db2 installation based on a Fedora Core 23 to a RHEL7 virtual machine without having to reinstall everything and not lose any data. This is in fact cloning my test environment database. This is not an easy task as is not officially supported by IBM but the beauty of… Read More »
Sometimes working with Hibernate you get the following error in case a persist is executed on an object with dependencies. com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: Error for batch element #1: The insert or update value of the FOREIGN KEY “INST1.MESSAGE.FK_1FUTL48XT47HPPGH0YXQM1MIJ” is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=4.13.127 From IBM… Read More »