James Atkinson wrote:
> I was thinking of Perl and MySQL, however how easy/difficult would it be to
> migrate an Access db to a MySQL db? Also, are there any Linux based ASP
> solutions available? (Sorry...I kinda like ASP...sue me :))
Willing to run (learn) Java??
I have a setup of;
Apache WebServer + Apache JServ Servlet Engine + Apache JSSI + PostgreSQL.
You write servlets that are either mounted at an URI, or included as a
<servlet> tag in your HTML pages, and you can do all your stuff in there.
Connecting to PostgreSQL is pretty simple with the default JDBC driver,
however, not very good in handling multi MB ResultSets.
The basics...
Class.forName( "postgresql.Driver" );
Connection conn = DriverManager.connect( "jdbc:postgresql:mydatabase", "me",
"mypassword" );
That is typically done in the Servlet init() method.
In the doGet, doPost or service() methods you put things like;
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery( "SELECT * FROM mytable WHERE whatever > 10" );
Niclas
-
To unsubscribe from this list: send the line "unsubscribe linux-newbie" in
the body of a message to [EMAIL PROTECTED]
Please read the FAQ at http://www.linux-learn.org/faqs
