This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Regarding JDataStore DataBase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Regarding JDataStore DataBase" Watch "Regarding JDataStore DataBase" New topic

Regarding JDataStore DataBase

srinath jeyanthi

Joined: Feb 14, 2001
Posts: 18
please help me any body my question is,
i am using my java project JDataStore as backend .it is platform
independent.In this database does not support IN operator while i am updating four different records that i given IN operator where clause.And also won't support substr function also.plese give the alternate solution for this situation.
update emp set job='manager' where empno in(10,20,30);
this query is not working our JDataStore DataBase.
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
IN merely is a short form of or =
Try this:

update emp set job='manager' where
empno = 10 or
empno = 20 or
empno = 30

Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
I agree. Here's the link:
subject: Regarding JDataStore DataBase
It's not a secret anymore!