RE: Connecting to keel's hsqldb?

Thanks. I'll give it a go. When (if?) I make any progress I'll add my findings to the Wiki.

- Justin 


--
ThatOne Company
http://www.thatone.com/

-----Original Message-----
From: user-keelframework.org-admin-rI8AND0JKYOgdSakss0wQjfEH8FBEnyy@public.gmane.org [mailto:[email protected]] On Behalf Of Michael Nash JGlobal.com
Sent: Thursday, April 08, 2004 2:32 PM
To: user-6VIttnCrOeJXNEnpj1eHPNi2O/[email protected]
Cc: Calvin Smith; user-keelframework.org-rI8AND0JKYOgdSakss0wQjfEH8FBEnyy@public.gmane.org
Subject: Re: [Keel User] Connecting to keel's hsqldb?

Calvin:

Had a further thought on the below. Can you try doing an "ant -Ddeploy.name=yourdeployname tests" and see if it succeeds? This task runs all of Keel's unit tests, including tests on beans & persistence. It should trip up on any problem that's causing the below.

If not, then the next step will be to make a test that *does* trip up, so we don't hit a problem like this again!

Mike

On Thu, 8 Apr 2004 13:05:58 -0700
"Calvin Smith" <[email protected]> wrote:

> Hi,
> 
> I'm just getting started with Keel, so forgive me if there are any 
> silly mistakes in what follows. I'm on my way to getting persistance 
> working with hsqldb and hibernate services, but I've run into a couple 
> of problems.
> 
> First, I would like to see what hsql has in the database, and have 
> been trying to connect to the hsqldb that is running inside keel, but 
> I can't get the connect string, user, and password correct. I've tried 
> various ports and URLs for the two standard hsql URLs 
> (jdbc:hsqldb:<database> and jdbc:hsqldb:hsql://<host>:<port>, 
> including port 9001, which I think is the standard port, but I always 
> get a "Connection refused" error. Can anybody tell me what the default 
> database url is for hsqldb in keel, or which file this would be configured in?
> 
> Second, and this is the underlying problem I'm having with hsql and 
> hibernate, it seems that I am able to add objects created from 
> information a user submitted, but when I retrieve an object later, it 
> always seems to return the same object, regardless of what I've set 
> the field to for the retrieve.
> 
> I'm adding like so:
> 
> Persistent m = pf.create("tax.ZipTaxRate"); m.setField("newZipCode", 
> request.getParameter("newZipCode"));
> m.setField("newTaxRate", request.getParameter("newTaxRate"));
> m.add();
> 
> And this works with no errors. For the sake of the example, let's say 
> I did this twice, with different zip codes and tax rates each time.
> 
> The problem is that when I later try to retrieve an object, it always 
> retrieves the first object added, even when the field for the retrieve 
> (newZipCode, which is the key) has been set to the zip code of the 
> second object.
> 
> Here is how I'm trying to retrieve the object:
> 
> Persistent m = pf.create("tax.ZipTaxRate"); String zipCode = (String) 
> request.getParameter("zipCode"); m.setField("newZipCode", zipCode); // 
> zipCode is the value of the second object I added
> m.retrieve();			
> ZipRate zipRate = (ZipRate) m.getBean(); // simple bean with two 
> fields, newZipCode & newTaxRate
> 
> When I do zipRate.getNewTaxRate(), I get the value for the first 
> object, not the object that has the key I submitted. Maybe I'm doing 
> something wrong here, or perhaps I'm running into some kind of cache 
> issue. Does this problem ring a bell for anybody?
> 
> cheers,
> 
> Calvin
> 
> --
> 
> ThatOne Company
> 
> http://www.thatone.com/
> 
> _______________________________________________
> User mailing list
> [email protected]
> http://lists.keelframework.org/listinfo.cgi/user-keelframework.org


--
Michael Nash

JGlobal Ltd
Next-Generation Web Application Development and Open Source Support http://www.jglobal.com

Bahamas Commerce and Trade
Offshore eCommerce Hosting and Business Services http://www.bahamascommerce.com

_______________________________________________
User mailing list
[email protected]
http://lists.keelframework.org/listinfo.cgi/user-keelframework.org