hi sven,
imo this is not oql related. it's a problem of your jdbc-driver.
btw. have you tried using the official escape sequence for dates and
timestamps ?
{d `yyyy-mm-dd'} and {ts `yyyy-mm-dd HH:mm:ss.f . . .'}
hth
jakob
----- Original Message -----
From: "Efftinge, Sven" <[EMAIL PROTECTED]>
To: "'OJB Users List'" <[EMAIL PROTECTED]>
Sent: Tuesday, November 19, 2002 4:25 PM
Subject: [ODMG] OQL Problem with Dates
> Hi,
> I have this OQL-Query
> String select = "select all from de.company.dataobjects.Foo where
> date=\"2002-10-17 15:44:58.0\"";
> Date is a timestamp
>
> When I execute it with
> odmg.newOQLQuery().execute(select);
>
> I got the following Exception:
>
> java.lang.ClassCastException: java.lang.String
> at
>
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement
> .java:1372)
> at
>
org.postgresql.jdbc1.AbstractJdbc1Statement.setObject(AbstractJdbc1Statement
> .java:1398)
> at
>
org.apache.ojb.broker.platforms.PlatformDefaultImpl.setObjectForStatement(Un
> known Source)
> at
>
org.apache.ojb.broker.accesslayer.StatementManager.bindStatementValue(Unknow
> n Source)
> at
> org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
> Source)
> at
> org.apache.ojb.broker.accesslayer.StatementManager.bindStatement(Unknown
> Source)
> at org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(Unknown
> Source)
> at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
> Source)
> at
>
org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Unknow
> n Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(
> Unknown Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(Un
> known Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
> known Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
> known Source)
> at
>
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Un
> known Source)
> at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source)
>
> Any Idea, what's wrong??
>
> Sven
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
