From anders@columbia.edu Fri Jul 21 09:29:07 2000 Date: Thu, 20 Jul 2000 18:52:51 -0400 (EDT) From: "[a-nders]" To: Gordon A. Campbell Subject: jdbc project -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 i think we may have a good jdbc project in the wings for you. definately a doable one. tomorrow we're meeting about a new project that they want to do. it involves making relationship graphs on the fly. i mentioned that i'd played around with a java applet that does almost exactly what we want and is one of the examples that comes with the jdk. the applet just draws them on the screen and they wiggle around and so forth; these people just want a static image produced. so it's a matter of doing the applet -> gif conversion that you've been working on. but the applet never needs to be shown client side, so it can all just be hacked into one servlet rather than having to serialize the applet and all that crap. the jdbc comes in because they want to be able to add new relationships to the database from a web interface. i hacked together a quick demo of it at http://ccnmtl.dhs.org/network/example.pl that generates the parameters that are passed to the applet on the fly from a postgres database and has a form for adding new relationships. basically 90% of what we need. all that's left is to freeze it and write it out as a gif. i figure that while we're going to have to do that via a servlet, we might as well do the whole thing in a servlet, including the database stuff... i'll explain it all tomorrow if this isn't clear. at any rate, i think it would be a good project to show off the power of servlets and REAL databases. . . . .............. ......... . ............................ ........ -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.2 iQA/AwUBOXeCyjqwMDD0o+1UEQIecwCgtzO8TC41A4PAzFbw/GrZuX2U2PoAnjdG HR2jqFGEwnGGgDjy/MPZZ1yF =ojeL -----END PGP SIGNATURE-----