db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pflick <craterv...@yahoo.com>
Subject Timestamp error
Date Fri, 21 Mar 2008 14:17:54 GMT
I am trying to select rows using timestamp criteria in the where clause using the jdbc embedded
driver ( but  I get the following error:

SELECT * FROM mytable WHERE downloaded_dtm >= timestamp('2000-01-01 00:00:00') and downloaded_dtm
< timestamp('2009-01-01 00:00:00')
java.sql.SQLException: Column '0' not found.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.getColumn(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.getString(Unknown Source)

Any help would be appreciated.

Never miss a thing.   Make Yahoo your homepage.
View raw message