Category Archives: Programming

DB2: SQL Error: -803, SQLState: 23505 due to NON-UTF8 character in parameter

By | October 24, 2017
0 Comment

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 »

CVS: Add a missing tag by date for a CVS project release

By | February 8, 2017
0 Comment

Sometimes you discover that you forgot to tag on CVS a test release that made it on the production system. The issue starts when you discovered that in the mean time you or someone else already added new functionality on the development branch. In the following I will create a tag only based on the… Read More »

Java: Inspect Websphere Application Server Logs with Ostros Log Viewer

By | February 8, 2017
0 Comment

Working with Enterprise applications deployed on Websphere Application Server ND and having to determine some issues from the logs sometimes can be a handful. The sheer amount of information that is spilled by the container in the logs is overwhelming. Usually I end up having to find the needle in the haystack looking into 5… Read More »

DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null

By | February 21, 2019
2 Comments

This error is the DB2 cryptic way of informing you that a value which an insert query tries to insert in a table is too large. Usually when using java + hibernate we can define a member of an EJB as: @Column(length = 10) protected String receiver; If somehow when the object is created we… Read More »

DB2 + Websphere : Feature is not implemented: PreparedStatement.setBinaryStream

By | February 8, 2017
0 Comment

From a very strange reason after updating the hibernate4 from version 4.1.4 to 4.2.5 there was suddenly a weird behaviour of the EJB3.1 enterprise application I am working on. A piece of code that commits to the database an object (ProcessingStatus) containing a BLOB was throwing the following: [1/31/16 23:37:15:922 EET] 000000eb AbstractBatch Z org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl… Read More »

Hibernate+DB2 : Adding new primitive data type member to an entity issue

By | February 8, 2017
0 Comment

This is an annoying issues of hibernate with DB2. Trying to add a new primitive type to an already existing entity will result in an error when updating the associated database table. As a result no update of the schema is done. Why is that ? When adding to an entity a new primitive type… Read More »