File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC and Linux Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC and Linux" Watch "JDBC and Linux" New topic

JDBC and Linux

kenneth ga

Joined: Aug 05, 2004
Posts: 9
I have installed RedHat 6.1 on a machine with mysql server running.
I am using mm jdbc driver for mysql and the files are uncompressed into the Linux box.
A sample program is created which issue jdbc call to the mysql database. The applet is compiled and run from the client PC with mm jdbc driver uncompressed to my PC. The mm jdbc driver path is added to the PC's class path.
That's all I have done so far. If I want to put the application on the Linux box and calls it via an html page without having the client PC to carry the mmJDBC driver, how can I do that? Has someone got experience in this kind of setup?
I really want to have everything runs on the Linux server (web server) and the client PC just simply use the browser to access.
Ahmad Zawawi

Joined: Apr 02, 2000
Posts: 2
you can go with the JSP/servlet solution to call JDBC queries of your client and give him the output. But that means that you have to install JServ or Allaire JRun (i dont recommend this because it had been a big pain in the ass)....
or you can go the old-fashion way and write a cgi script (in Perl or shell script - whatever) that calls your Java application and pipes its output to your client... (that's a fast way of doing things - but it is not the recommended way for the long run). Of course your Java Output would be plain HTML....
[ This is afterall what Servlets are there for ]
any more help i'll be happy to answer your questions...

I agree. Here's the link:
subject: JDBC and Linux
It's not a secret anymore!