Invalid column type SQLException with ATG Repository

Recently I was seeing this exception.

CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: Invalid column type
        at atg.adapter.gsa.GSAItemDescriptor.executeQuery(
        at atg.adapter.gsa.GSAView.executeUncachedQuery(
        at atg.adapter.gsa.GSAView.executeQuery(
        at atg.repository.rql.RqlStatement.executeQuery(

For the longest time I could not figure out what this meant and then it dawned on me as I laid in bed.

ATG expects certain Java class types for certain repository types which correspond to certain class types. I talk about this in my Date and Timestamp Repository Data Types post.

I was trying to do this RQL query:

      lastModified > ?0

with this parameter:

      java.util.Calendar param = java.util.Calendar.getInstance();

When I changed the parameter to type:


I no longer saw this exception which makes sense because the lastModified property is of data-type timestamp.

Leave a Reply

Your email address will not be published. Required fields are marked *