Re: HSQLDB standalone in webapp?

From: Kevin J. Menard, Jr. (nirvdru..egativetwenty.net)
Date: Tue Oct 26 2004 - 10:37:45 EDT

  • Next message: Andrus Adamchik: "Re: HSQLDB standalone in webapp?"

    On Oct 26, 2004, at 10:18 AM, Gentry, Michael wrote:

    > Would you believe I was just looking into that over the weekend?
    > Substitute Tomcat for Jetty, though.

    Well, I'm glad then. You got to do all the dirty work :-) Well, I did
    spend a fair amount of time on it, I just don't have much to show for
    it.

    >
    > The solution I initially came up with -- and their might be a better
    > way
    > -- is to add some <property> tags in the .application file to specify
    > the path/etc (basically, any custom configuration key/value pairs).
    > Then you can read the property and set the connection dictionary/etc.

    Hmm . . . I guess this is the part I could use some pointers on. How
    do you do this programmatically? I thought the complication would be
    the specification of the db path in the jdbc url in the datanode file.
    But if that can be set at run time, then I guess it isn't that big of
    an issue.

    >
    > I was going to post the Tapestry-specific code bits to the
    > tapestry-user
    > mailing list, but I can include it here, too, if anyone else is
    > interested. I haven't gotten to the point yet of setting the
    > connection
    > dictionary, but that's pretty easy once you have the values.

    I'm on both lists, so I'll get it either way. It might be interesting
    for others though.

    >
    > /dev/mrg
    >
    > PS. I'm also leaning towards running HSQLDB in server mode from within
    > the Tapestry application, so I can still access it (the database) while
    > the application is running. Just a thought for you.

    Are you looking to run a dedicated server, or using the HSQLDB servlet?
      Being able to connect with other processes would be nice, but I was
    looking for the "easiest" path.

    Thanks,
    Kevin



    This archive was generated by hypermail 2.0.0 : Tue Oct 26 2004 - 10:40:55 EDT