From: Jerry H. <jer...@ho...> - 2003-12-08 05:51:40
|
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! 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. 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 |
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 |
From: Andrew G. <an...@zo...> - 2004-08-26 23:52:33
|
- Apologies to the list for replying to an off-list message here. I have no other way of replying. - Hello Hector, Yes, the work was all put into the CVS repository. You should be able to get it with these cvs commands: cvs -d ":pserver:ano...@cv...:/cvsroot/dynapi" login cvs -d ":pserver:ano...@cv...:/cvsroot/dynapi" co sodaservlet I did try to add these instructions to an article on the dynapi home page, but was never able to get my login to work. If you have any questions about this work or if you want any help, feel free to ask. regards, Andrew Gillett PS Hector, I was unable to reply directly to you because when I tried I got: 550 5.1.1 <hector dot candia at isol dot com dot mx>... User unknown (I've mangled the email address slightly with dots and ats) Hector Candia wrote: > Hi Andrew, > > > > I am trying to implement Dynapi Soda in a java environment, is it > possible to get your work about the implementation of the java server > side of the SODA-RPC? > > > > Thanks a lot in advance, > > > > Hector Candia > |
From: Andrew G. <an...@zo...> - 2003-12-08 06:24:55
|
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 > > |
From: Doug M. <do...@cr...> - 2003-12-08 07:25:00
Attachments:
remotscr.zip
|
If you are using IIS then ther is always repost scripting: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rmscpt/Html /rmscpt.asp It uses a small applet to transfer objects to and from the server. great for DB connectivity. you write the code that returns the recordset in ASP then send teh recordset backt o the client JS as an object. works in IE4+ and NS 4.x (havne't tried mozilla) The porject files are attached in zip format ----- Original Message ----- From: "Jerry Hammann" <jer...@ho...> To: <dyn...@li...> Sent: Monday, December 08, 2003 12:51 AM Subject: Re: [Dynapi-Help] Re: IOElement/SODA and Java > 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! > > 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. > > 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 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.548 / Virus Database: 341 - Release Date: 12/5/2003 |