Win a copy of Micro Frontends in Action this week in the Server-Side JavaScript and NodeJS forum!

Rich Brockway

Ranch Hand
+ Follow
since Oct 25, 2001
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Rich Brockway

Originally posted by Dana Hanna:
I wrote a SQL ODBC toold in Java - it reads from "c:\WINDOWS\system32\ODBC.INI" and parses out the databases. It also launches the ODBC config window by spawning "c:\WINDOWS\system32\odbcad32.exe"
(on win 95-ME and XP), on 2K and NT replace WINDOWS with WINNT.
BTW - check out SquirrelSQL on www.sourceforge.net to see a JDBC driver search and connection saving mechanism...


Dana,
Thanks for the tip. I'll check it out.
Rich

Originally posted by Gregg Bolinger:

You make a valid argument Rich. I'm glad you got something useful out of this thread. Good luck.


Gregg,
Thanks.
Rich
All,
I appreciate everyone's feedback on this. I do not want this to escalate into a full blown battle of SUN vs. Microsoft or Java vs. Microsoft.
I'm going to dig into JNI and call the appropriate DLLs to display the dialog. Yes, it is Windows only solution. However, at this point, that is all I need. If the application is ever moved to another OS, I'll address the issue then.
Thanks,
Rich
Simon,
That is exactly what I am looking to find.
Rich

Originally posted by Gregg Bolinger:

It breaks platform independence because Microsoft Windows is the only OS that provides some sort of Datasource Bridge (ODBC). So this task would be specific to Windows. Even though your program would be written specifically for the Windows platform, you should be able to take it to any OS and run it without a hitch. Providing a Windows only solution in the API would break that.



Gregg,
I totally disagree. It would list the available data sources for that platform. For example, Windows would list ODBC data sources as well as others. On Unix, it could list the drivers that system provides via something like iODBC.
In the end, the VMs have to have different implementations to support different platforms.
Rich
[ December 18, 2003: Message edited by: Rich Brockway ]

Originally posted by Ernest Friedman-Hill:

As I said, real databases let you get this information from the query language. It's not Java's job to work around a deficiency in Microsoft Access.


Ernest,
Again, I want a list of the data sources from JDBC. Getting the data from Access is trivial.
Rich

Originally posted by Gregg Bolinger:

I used the feel the same way. However, it is outside of the goal of Sun's JAVA to do something like this. As Java is a write once run anywhere HIGH LEVEL language, it wouldn't make since to provide Windows specific functionality to the core Java API.
The OLE DB/ADO/ADO.NET solution has an easy function call to allow the user to do this.
Of course it does. That API was written by Microsoft for Microsoft.
We have no desire to invest a heap of money in a JDBC driver.
Who does? That is why most of them are free.


Gregg,
Exactly how does supplying a list of data sources break so called "platform independence?" It does not. When they built the library, all they had to do was figure out a standard way to get the data sources.
Rich

Originally posted by Paul Wheaton:

Evidence that you come from a MicroSoft world?
Welcome to Java. If you have work to get done, you don't have to drag in the executive and bean counters for permission for every little thing. Damn near everything is free.


Paul,
I have not looked at every single DBMS out there. When I did a few years ago, most of the DBMSs did not have a free driver. As a matter of fact, the "smaller" DBMSs required a per seat license fee.
As for Microsoft, you very rarely if ever paid for the data access library. Microsoft provided DAO, ADO and ADO.NET for free.
Rich

Originally posted by Ernest Friedman-Hill:

Well, then you should probably consider building your prototype using that particular alphabet soup rather than Java. Since the whole concept of an "ODBC data source" is platform-dependent, and irrelevant anyplace but Windows, so you might as well just build a Windows-only solution.
Note that by definition, a true relational database offers uniform access to all information through the query language -- including the names of available catalogs (the closest SQL concept to the "data source.") Just because the implementors of the JDBC-ODBC bridge (not written by Sun, incidentally, but by a contractor) didn't go out of their way to work around the inadequacies of the ODBC "technology" is no reason to criticise the Java platform as a whole. If you want to use databases on a computer, Java works just fine. If, on the other hand, you want to use Access on Windows, well, hand Bill your pound of flesh and do it the officially sanctioned way. Don't use a caliper to pound a rusty nail.


Ernest,
No one mentioned the mythical "platform independence." You mean build once debug everywhere.
I was criticizing the JDBC architecture; it has a huge hole. If Microsoft found a way to work this miracle, SUN should have been able to do this as well. Plainly, it was an oversight.
As for giving Bill a pound of flesh, C# (.NET SDK) and ADO.NET are both free.
In the end, SUN AND Microsoft are both corporations focusing on maximizing profit. One is not holier than the other.
Rich

Originally posted by Simon Lee:
Rich,
What do you mean by "ODBC/JDBC data sources" ???


Simon,
My application is essentially a data mining and data transformation application. The user needs to be able to use data from whatever data sources he or she has on the client machine. So, the user needs to see a list of the data sources. For example, in OLE DB/ADO/ADO.NET, you make a simple function call to display a dialog which displays all the drivers and lets them select a driver and a data source. For example, the user can select the Access driver and select an Access database. I was looking for similar functionality in JDBC.
Thanks,
Rich

Originally posted by Jamie Robertson:
In this day and age, you won't find many people using JDBC-ODBC drivers in production anyways. The deployment and maintenance of thick client programs using JDBC-ODBC bridge on individual PC's is frustrating at best. For all apps ( web and thick clint ), type 4 drivers are more reliable, scalable and are better performers on the whole. Also, type 4 drivers are readily available for almost all databases which begs the question why would someone limit themselves to the JDBC-ODBC bridge anyways?
What you are proposing can be easily implemented via a properties/preferences file anyways.
Jamie
[ December 16, 2003: Message edited by: Jamie Robertson ]


Jamie,
First off, this is for a prototype application. We have no desire to invest a heap of money in a JDBC driver.
Finally, if this was something which could be accomplished with a simple "properties/preferences file," I would have completed it long ago. Your "solution" has a hole the size of Texas in it. How do you allow the user to select data sources added outside your application? You simply cannot. You need someone to physically add the new data source; this is unacceptable because there could be new unique data sources on each client machine every few days. The OLE DB/ADO/ADO.NET solution has an easy function call to allow the user to do this.

Rich
Joe,
I really appreciated the reply. If this is really the case, it is yet another example of how Microsoft's OLE DB/ADO/ADO.NET is superior in functionality to SUN's JDBC. In my opinion, this should really be built in to the data access library.
Rich
[ December 16, 2003: Message edited by: Rich Brockway ]
All,
I'm looking for source code or a component to export information from a database table to XML.
I would appreciate any suggestions.
If this has already been covered in another thread, please post a link.
Thanks,
Rich
All,
I have a need in my application to present the user with a list of all available ODBC/JDBC data sources so he or she can select one.
After searching Google, the closest thing I found was the following:
////////////////////////////////////////////////////////////////////
Enumeration enum = DriverManager.getDrivers();
System.out.println(" Before - while (enum.hasMoreElements())");
while (enum.hasMoreElements())
{
System.out.println("Has Driver");
System.out.println(enum.nextElement().toString());
}
System.out.println(" After - while (enum.hasMoreElements())");

////////////////////////////////////////////////////////////////////

It returns nothing. Am I missing something here?
I appreciate any help.
Thanks,
Rich

Originally posted by sonny kher:
yeah right, how about i give you a dozen links that say there are hundreds of thousands of unfilled position in IT? ofcourse they will be pre-2001. times change my friend and soon enough they will change again.


Sonny,
If these "job openings" are real, why are there so many unemployed or underemployed people? Why do you insist on sticking up for "big business" and the ITTA? Do you really believe there are that many actual positions paying the "prevailing" wage for the required skill set?
Again, I will point to the facts. In the last thirty days, there have been four jobs offered on JavaRanch's "Jobs Offered" board. Why are so many people who post on this board discouraged? Why are so many graduates of Computer Science and computer training programs unemployed or underemployed?
I'm challenging you to bring forth the "mythical" 425,000 openings. First, I will draft a contract which will pay me a finder's fee for each qualified applicant. Second, we will have each company sign the contract and agree to pay the prevailing wage for the given skill set and location. Third, I will simply post the jobs on Dice and watch the resumes fly in. Unless they are looking for a seven foot four inch three hundred pound jockey, it is that easy.
However, if they are looking for a unique skill set, they must be willing to pay. If they are, they will find people to fill the positions. If not, they will claim they "cannot fill" this position. What they are really saying is we are not willing to pay for the skill set this position requires.
If you really believe there is a shortage, you need to consider a different career path. Find people to fill those positions. Even if you fill 1/425 of the "positions" at a mere $100 a piece each year, that is a nice living.
What I�m seeing, in my "high tech" city, is the direct opposite. The high tech consulting and placement agencies are drying out. I�ve had several recruiters call me to dig up sales leads. Of course, I�m not very helpful.
Rich
[This message has been edited by Rich Brockway (edited December 17, 2001).]
18 years ago