Thanks Charles,
I want to avoid using bind(). Here's my situation:
- my program has a client, a server
- the server contains OJB, and Java
- the client is .NET
- I want to pass OQL statements as a string from the client to the server.
For the OQL parameters, java.lang.Object[] cannot be my choice, since the
web service protocol doesn't marshal that. But if I marshal the parameters
as String[], i need some extra info to convert those strings back to their
related data type
- But if I bind a java.sql.Date object as a java.lang.String object, the
Oracle driver gives me an error (while some other JDBC drivers are fine)
- allowing the OQL statement to be generated on the client makes the search
more flexible
----- Original Message -----
From: "Charles Anthony" <[EMAIL PROTECTED]>
To: "'OJB Users List'" <[EMAIL PROTECTED]>
Sent: Monday, March 17, 2003 6:45 PM
Subject: RE: OQL datetime string
> Instead of doing that, bind a variable in the query...
> I don't use OQL, but off the top off my head
>
> OQLQuery q = odmg.newOQLQuery().create("select user from " +
> Users.class.getName() + "
> where modifiedOn<={0}")
> q.bind(theDateTimeValueAsADate);
>
>
> >-----Original Message-----
> >From: Thomas Phan [mailto:[EMAIL PROTECTED]
> >Sent: 17 March 2003 10:41
> >To: OJB Users List
> >Subject: OQL datetime string
> >
> >
> >Hi,
> >
> >Is there an escaped string format for datetime in OQL that
> >allows all JDBC
> >drivers to:
> >
> >odmg.newOQLQuery().create("select user from " +
> >Users.class.getName() + "
> >where modifiedOn<='2003-03-17'"); <- I'm not sure about the
> >"modifiedOn<='2003-03-17'" part
> >
> >In JDBC, we can "select * from Users where modifiedOn<={d
> >'2003-03-17'}"
> >
> >
> >FYI,
> >
> >CREATE TABLE Users(
> > userId VARCHAR2(50) NOT NULL,
> >...
> > createdBy VARCHAR2(50),
> > createdOn DATE,
> > modifiedBy VARCHAR2(50),
> > modifiedOn DATE,
> > CONSTRAINT PK_Users PRIMARY KEY (userId)
> >);
> >
> >Thanks
> >
> >Thomas
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >
>
>
> This email and any attachments are strictly confidential and are intended
> solely for the addressee. If you are not the intended recipient you must
> not disclose, forward, copy or take any action in reliance on this message
> or its attachments. If you have received this email in error please notify
> the sender as soon as possible and delete it from your computer systems.
> Any views or opinions presented are solely those of the author and do not
> necessarily reflect those of HPD Software Limited or its affiliates.
>
> At present the integrity of email across the internet cannot be
guaranteed
> and messages sent via this medium are potentially at risk. All liability
> is excluded to the extent permitted by law for any claims arising as a re-
> sult of the use of this medium to transmit information by or to
> HPD Software Limited or its affiliates.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
