On Tue, 10 Oct 2000, Mike Haberman wrote:
> I would like to help get jyve2 off the ground. Can someone point
> me to the head developer? I have several ideas, but I don't want
> to duplicate ongoing efforts.
I am the one that initially started working on
jyve2. However due to my work schedule and other
such problems, I have not had a chance to work on
it for a couple months now, and it looks like I
may not have any time for a couple more months.
> 1. I. would like to get the sql standardardized so that it will work
> with db's that don't support outer joins.
Sounds good. I was going to try to keep SQL out
of the code as much as possible in favor of using
Turbine's peer model.
> 2. it look's like torque isn't providing the 'optimal' sql syntax for
> postgres. But I could be missing something. Why aren't the primary
> keys being generated with type SERIAL ?
General torque questions like that are probably
better asked on the Turbine mailing list (as
torque is really part of Turbine). Also, the
postgres schema in the jyve2 CVS tree was built
a couple months ago. It might me worthwhile to
get the latest version of Turbine/Torque and
re-generate the schema. (The template should
be in the jyve2 CVS tree somewhere. I don't
remember where though.)
> 3. Is jyve2 functional? I got the latest source from cvs, compiled
> and installed, but I am getting the following exception:
>
> org.webmacro.NotFoundException: Resource[template, navigations/null] not found:
>Unable to resolve requested resource
At least the first page of jyve2 should be
functional. It's been a while since I looked
at that, though, so there may have been some
Turbine/Webmacro changes that broke something.
I will take a look at it later this evening
and see if I can point you in the right
direction.
> I got the right paths set up in the Webmacro.properties file and
> I think I have the Turbine.properites set up right (although the
> INSTALL.txt file says stuff needs to be added, so I made my best
> guess at the stuff).
>
> any help would help :)
>
> 4. I can simulate outer joins in postgres by writing a server side
> function in PL/SQL, but this hack would only work in postgres and
> the sql being generated would have to know what backend db was
> being used. But if someone wants a short term solution for postgres,
> I can start working on it. (I need one).
>
> Let me know how I can contribute and to whom I can send private email
> to in order to get a handle on the state of the project.
You're welcome to email me privately - I'll be
happy to answer whatever questions I can.
--
Greg
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
