Re: Orion 1.0 PetStore Demo DB

2000-06-21 Thread Magnus Stenman
m: "Kalvar, Kirk" <[EMAIL PROTECTED]> To: "Orion-Interest" <[EMAIL PROTECTED]> Sent: Tuesday, June 20, 2000 5:52 PM Subject: Orion 1.0 PetStore Demo DB > What is the datasource for Orion's website implentation of the PetStore? > I've been using hsql bu

Re: Orion 1.0 PetStore Demo DB

2000-06-21 Thread Kalvar, Kirk
Apparently HypersonicSQL had some difficulty processing the following query against the PetStore dB: SELECT itemid, listprice, unitcost, attr1, a.productid, name, descn from item a, product b WHERE a.productid = b.productid and b.productid in (SELECT productid from product

Orion 1.0 PetStore Demo DB

2000-06-20 Thread Kalvar, Kirk
What is the datasource for Orion's website implentation of the PetStore? I've been using hsql but the catalog query doesn't execute properly. I've been using JDBCTest to test the query stmt but something isn't quite right. Kirk S. Kalvar, Software Engineer DRS Electronic Systems Group