Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bosshoff
Starting Member
9 Posts |
 Posted - 2004-10-20 : 22:28:44
|
| Dear Sirs, I have written an application in ASP based on JScript. It's a multi-site time clock program that communicates with SQL Server. Ever since I've finished it I've had nothing but trouble, and am worried that, after a few more months go by, I will begin maintaining code for IIS revisions, O/S revisions, browser revisions, etc. Since this program really does not need to be in a web environment, and merely needs to communicate with the SQL Server, I was thinking about rewriting it in Java. Why not VB, you ask? Well, I hope I don't get beaten into a pulp for saying this: I really, really hate VB. It is of course a matter of personal preference, but VB has just never made sense to me, coming from a programming background of mostly C. I was wondering if anyone else has some insight on whether this is an achievable goal in about one and one-half months of about five-hours per week of programming (I am still in college). If anyone has any examples of a GUI-based program that uses Java with SQL Server, or knows somewhere I can get such examples, I would be most appreciative. My knowledge of Java is not that developed yet, having only one practicum on it a couple semesters ago. Thanks for any help you can give me.------------------------------------------------SELECT [Hot Women] FROM anywhere WHERE [Marriage Status]='Single' AND [STDs]='0' ORDER BY [Yearly Income] DESC:) |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-20 : 22:50:01
|
| Why not C#? Or any .Net language? Think in terms of where you will be in a few years, not just today. Not knowing .Net could hurt you in the job market.Anyway, while I won't say it's impossible to do in regular Java, you're not likely to have any more success either. JScript is probably the better choice. Java support for SQL Server is nowhere near what it is for VB or .Net. Sad to say too, Java has been lagging behind .Net lately. It catches up every now and then, but it's been sliding for a while and many people are jumping onto .Net. It's still going to be useful, but I wouldn't focus on it to the exclusion of other languages.I would say too that a web-based app is still a better way to do things, simply because deployment is much easier than dealing with executables. Java won't work as well as a JScript web app would, IMHO. Also, unless you're programming very tightly to one browser, you shouldn't have all that much trouble with OS and browser upgrades for your application. If you are, it's probably the code and not the language, and you could easily have the same problems with a Java port of your existing code.Even though I like VB, I generally agree with you about it. I don't like VB.Net and won't use it, C# is my .Net choice. I still do a lot of ASP/VBScript, and JScript/JavaScript are definitely my favorites, even though I only use them in client-side web code. |
 |
|
|
bosshoff
Starting Member
9 Posts |
Posted - 2004-10-21 : 12:42:15
|
| Well I guess I'll have to look into C#. I never really considered it since C++ was quite convoluted with respect to its visual libraries. This very reason was an impetus to using web-programming, since ASP is incredibly easy to make visual. I mainly used C to program processor-intensive functions for integration with a Linux environment. Another reason I didn't mention for my leaning away from web-programming, for this project anyway, is the potential risk of allowing browser access on public-use terminals. I know that, with simple administration, access can be restricted, but I just thought it a pain to have to take so many steps just to get a program running. I would like to have a program that cannot be shut down by an employee with just enough knowledge to know that Alt-F4 shuts down applications. One solution I've been brainstorming on is requiring a management code to shutdown anything, or something like that, integrated into the program; things that aren't easily done on a web browser.------------------------------------------------SELECT [Hot Women] FROM anywhere WHERE [Marriage Status]='Single' AND [STDs]='0' ORDER BY [Yearly Income] DESC:) |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-10-21 : 12:54:41
|
| Use C#. It's gonna perform better than VB6 or Java methinks.My interactions between .Net and SQL Server are MUCH faster than they used to be with ASP 3.0 and VB6.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-10-21 : 13:01:24
|
| We have no problems at all with JAVA and websphere.ALL Data Access is done through stored procs....Brett8-) |
|
|
|
|
|
|
|
|
Java a good way to go with SQL Server?