From: Jerry H. <jer...@ho...> - 2003-12-09 00:19:53
|
I got your Soda code up and running in JSP! That's awesome! Thanks! A few glitches though . . . 1. The ant build file initially failed because it was looking for jars in sodaservlet/logging/jars that were not there. They were, however, in sodaservlet/soda/jars. I just copied the jars folder over to the logging subdirectory and everything worked fine. 2. Your Choose a Language pull-down menu does not warn someone when no language has been selected. I kept getting a javascript error at line 44 until I used the pull-down menu and selected Java. Everything works after accounting for these two issues. Thanks also, for your advice on accessing a database. I have my form validation and business logic residing in javascript files on the client already (which sounds like what you are using soda-rpc to do on the server-side) so my database calls do take place after the business logic is applied. I send the query variables to the server and get the query results back from the server as a text string and then create loads of javascript objects from parsing the text string and applying business logic again on the client-side (I've been using Brent Ashley's JSRS up to this point in my prototype environment) with no page refresh. I'll have to see if one more layer of abstraction from the the soda-rpc allows me to do the database calls. I suspect that I'm just not thinking it through right, though - soda-rpc shouldn't care what I do on the server-side - it just needs to send some data, wait for code to be run and a result to be made available and then return that result. Its quite possible that your Java code might not "hang" the way the ASP code does. Wishful thinking? . . . Thanks again! Jerry ----Original Message Follows---- From: Andrew Gillett <an...@zo...> Reply-To: dyn...@li... To: dyn...@li... Subject: Re: [Dynapi-Help] Re: IOElement/SODA and Java Date: Mon, 08 Dec 2003 17:24:42 +1100 Jerry Hammann wrote: >Hi Andrew, > >While Raymond gets up and running, could you send your files to my e-mail >at jha...@ch.... I would love to see your work! ok > >Have you tried to do SODA-RPC to a database yet? I'm having some troubles >with server-side objects. Any advice you could give connecting to MySQL or >Access would be greatly appreciated. No. I've done the basic RPC mechanism, including all the type coercion that has to happen on the server side. File uploads are on my todo list. I haven't even looked at the database stuff. IMO, database access should be a layer that sits behind the business logic. It should happen on the server. It would never have occurred to me to try and access a database directly from a browser using SODA. I wouldn't even try to make a java servlet try to translate soda database calls into generic JDBC calls. JDBC is so messy and every JDBC driver is different and it would be a lot of work and it would probably never work properly across different databases anyway. My approach would be to put all the database access code into java classes on the server, perhaps using a proper persistence layer such as hibernate. The use SODA-RPC to fetch the data from your java classes. If all you want is quick & dirty access to a database, then you're probably better off using JScript or VBScript or some such on the server - especially if your database is "access". regards, Andrew. > >Regards, > >Jerry > > >----Original Message Follows---- >From: Andrew Gillett <an...@zo...> >Reply-To: dyn...@li... >To: dyn...@li... >Subject: Re: [Dynapi-Help] Re: IOElement/SODA and Java >Date: Mon, 08 Dec 2003 13:52:47 +1100 > >Jerry Hammann wrote: > >>Andrew Gillett mentioned on 2003-11-11 that he had created a server-side >>Java version of the SODA-RPC component using servlet technology. >> >>Just to verify, does the servlet interact with a client-side JVM or are >>JVM-less environments supported? > > >No client-side JVM. Just the standard DynAPI library. You can build a rich >browser-based UI that interacts with your server side business logic - no >page redraws - and no plugins! > >> >>Have the questions surrounding where/how to distribute this server-side >>Java version been resolved? Where can I get a copy of these files? > > >No. I would like to establish a DynAPI sub-project for the servlet, but I >haven't yet had any response from the dynapi site administrators. My >alternative is to establish a seperate sourceforge project just for the >servlet. > >Now that Raymond's back :) , perhaps he may be able to steer me in the >right direction? > >> >>I'm very excited to see this in action! > > >Yes, the DynAPI SODA / RPC mechanism certainly does open some very exciting >possibilities. > > >Andrew. > >> >>Jerry Hammann > > > > > > > >------------------------------------------------------- >This SF.net email is sponsored by: IBM Linux Tutorials. >Become an expert in LINUX or just sharpen your skills. Sign up for IBM's >Free Linux Tutorials. Learn everything from the bash shell to sys admin. >Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click >_______________________________________________ >Dynapi-Help mailing list >Dyn...@li... >https://lists.sourceforge.net/lists/listinfo/dynapi-help > >_________________________________________________________________ >Tired of slow downloads and busy signals? Get a high-speed Internet >connection! Comparison-shop your local high-speed providers here. >https://broadband.msn.com > > > >------------------------------------------------------- >This SF.net email is sponsored by: IBM Linux Tutorials. >Become an expert in LINUX or just sharpen your skills. Sign up for IBM's >Free Linux Tutorials. Learn everything from the bash shell to sys admin. >Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click >_______________________________________________ >Dynapi-Help mailing list >Dyn...@li... >https://lists.sourceforge.net/lists/listinfo/dynapi-help > > ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ Dynapi-Help mailing list Dyn...@li... https://lists.sourceforge.net/lists/listinfo/dynapi-help _________________________________________________________________ Take advantage of our best MSN Dial-up offer of the year six months @$9.95/month. Sign up now! http://join.msn.com/?page=dept/dialup |