By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,426 Members | 3,368 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,426 IT Pros & Developers. It's quick & easy.

Advantages and disadvantages

P: 1
Expand|Select|Wrap|Line Numbers
  1. [list]what is the advantages and disadvantages of Ms SQL server and java servletts front-end on the clien end.[list]what is the advantages and disadvantages of Ms Access on the server, connected via JDBC and java on the client end.
    • what is the advantages and disadvantages of HTML on the client end,coupled with SQL server and ODBL on the server end.
Feb 27 '07 #1
Share this Question
Share on Google+
1 Reply

P: 14
You'll want to check the version of the JDBC that you are using and how it was implimented.

My first experience with JDBC (several years ago) left much to be desired. It was simply a Java layer on top of ODBC and was God Awful slow and many ODBC features were not implimented or had some sort of custom implimentation. Simple things like execute calls could not be done in a standard query statement, they had to use a separate exec entry point.

Lately though my experience is MUCH better. The current implimentation I use does not use the ODBC layer and instead goes directly to the SQL dll -- MUCH, MUCH, MUCH faster and as far as I can tell, fully implimented without custom entry points. Oh, by the way, did I tell you it's MUCH faster!

My experience is with CFMX and the JDBC that comes with it. I can round up the version information if you need it but if you are using CFMX, then as long as you are on the latest and greatest, I don't see any disadvantages.
Mar 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.