check out pointbase (written in java) at www.pointbase.com there's a free dev version.
-----Original Message----- From: Jason Bainbridge [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 3:46 PM To: Tomcat Users List Subject: [OT] Re: What Oracle is best? Oracle is an enterprise level commercial Database Management System ie. $$$ where MySQL is an Open Source alternative designed mainly for web application uses (although this may change with their partnership with SAP). These DBMS's can be used within servlets and JSP's by using the appropriate JDBC driver. I believe the current release of Oracle is 9iR2, if you have a requirement to use Oracle you would want to look into using that version but it isn't just a download and install type affair, there are licenses to worry about and the actual install can be a real pain at times. Do you want to just use a database backend for your web application? In that case you're best of with MySQL or PostgresSQL depending on what sort of featureset you require. Regards, -- Jason Bainbridge http://jblinux.org On Tue, 10 Jun 2003 03:36, Jonathan Michael Nowacki wrote: > Just wondering what kind of oracle programs do I need to get Tomcat to > access an SQL database. I have servlets already written that work on > another Sun OS machine that I still have access to. Is there a way I can > query the OS to find out what versions of oracle are installed? The RPM > command obviously doesn't work (since it is a Sun OS), and I don't have > root permissions of course. > If I can't query the Sun OS what versions of Oracle do you recommend. > I tried browsing the oracle homepage and google searches but that just > made me more confused from the vast number of choices. Also do I need > sqlplus or JDBC if I have j2sdk, tomcat, and MySQL? > > > This is whats already installed: > ----------------------------------------------- > tomcat4-webapps-4.1.24-full.2jpp > tomcat4-4.1.24-full.2jpp > tomcat4-admin-webapps-4.1.24-full.2jpp > j2re1.4.1_02 > j2sdkee1.4 > j2sdk1.4.1_02 > redhat 8 > standard MySQL that comes with Redhat 8 Linux > > > > Sample Servlet code that works on another computer > ---------------------------------------------------- > import javax.servlet.*; > import javax.servlet.http.*; > import java.io.*; > import java.util.*; > import java.sql.*; > public class MultiServlet extends HttpServlet { > /** > * Initialize global variables > */ > public void init(ServletConfig config) throws ServletException { > super.init(config); > } > /** > * Process the HTTP Post request > */ > public void doPost(HttpServletRequest request, HttpServletResponse > response) > throws ServletException, IOException { > > String category = request.getParameter("category"); > > response.setContentType("text/html"); > PrintWriter out = new PrintWriter (response.getOutputStream()); > out.println("<html>"); > out.println("<head><title>Advanced Search</title></head>"); > out.println("<body><table border=1 cellpadding = 5 cellspacing = 0>"); > > try > { > System.out.println ("\n before registering driver \n"); > DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); > System.out.println (" before GET Connection \n"); > Connection conn = DriverManager.getConnection > ("jdbc:oracle:thin:@dbserv.uits.indiana.edu:1521:OED1","s3jm013","s3jm013") >; System.out.println (" before STatement \n"); > Statement stmt = conn.createStatement(); > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]