Re: [Dynapi-Help] Re: IOElement/SODA and Java

[Andrew G. <an...@zo...>]

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
>
>