quick note on basic portal installation

Hi there,

Just a quick note about the installation of basic portal. To give you some 
background, I have just started tinkering with MVC and recently installed 
basic portal to get some more experience. Nothing like a working example. 
Kudos to Vic and the rest of the contributors. Greatly appreciated.

My note is related to the postgres installation actually. Initial symptom 
was that upon entry I was getting a "[Exception in:/do/contentLstModule] 
null" displayed. Upon further investigation I found out that my 
tomcat/logs/catalina.out had the following exception:

DEBUG [Thread-5] (BasicDAOImpl.java:98) - 
URL:jdbc:postgresql:net//localhost:5432/basicportal
DEBUG [Thread-5] (BasicDAOImpl.java:99) - User:xxxxxx
DEBUG [Thread-5] (BasicDAOImpl.java:100) - password:xxxxxx
DEBUG [Thread-5] (BasicDAOImpl.java:101) - 
driver:org.sourceforge.jxdbcon.JXDBConDriver
BBug ***java.lang.RuntimeException: An I/O error occured: 
java.net.ConnectException: Connection refused

End result was that postgres was not setup to accept TCP/IP connections. 
My Linux system is Gentoo and the default install doesn't allow TCP/IP 
connection and you have to manually enable it. To enable it, you have to 
make sure that the startup options includes a "-i" option. (For your Linux 
system, you could look in /etc/init.d/postgres if that's where you start 
the db from. In my case all options are separate from init scripts in 
/etc/conf.d/postgres)

On another note, here's some code to test your connection to the postgres 
database.

import java.sql.*;

public class postgres {
    public static void main(String[] args) {
        System.out.println("trying...");
        try {
            String url = new
                String("jdbc:postgresql:net//localhost:5432/basicportal");
            String usr = new String("xxxxxx");
            String pwd = new String("xxxxxx"); //postgres usr/password
            System.out.println("finding driver...");
            Class.forName("org.sourceforge.jxdbcon.JXDBConDriver");
            System.out.println("creating driverManager...");
            Connection db = DriverManager.getConnection(url,usr,pwd);
            System.out.println("creating statement...");
            Statement st = db.createStatement();
            System.out.println("executing query...");
            ResultSet rs = st.executeQuery("select * from base_content");
            System.out.println("looping data...");
            while(rs.next()) {
                System.out.print("Column 1 returned ");
                System.out.println(rs.getString(1));
            }
            System.out.println("loop finished, closing connection");
            rs.close();
            st.close();
        }
        catch( Exception e) {
            System.out.println("Exception encountered: " + e);
        }
    }
}

Regards,
--
Haroon Rafique
<[email protected]>