[Basicportal-maillist] Setup: Poolman, Realms, Postgres

[John M. <jo...@ea...>]

Hi,

I realize this is not a portal question specifically but I hope somebody may
have a sample setup for me to look at????

The problem occurs when I try to start Apache with my new Realm and get


Catalina.start: LifecycleException:  Exception opening database connection:
jav
a.sql.SQLException: org.postgresql.Driver
LifecycleException:  Exception opening database connection:
java.sql.SQLExcepti
on: org.postgresql.Driver
        at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:681)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1173)

        at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:347
)


My realm is configured as follows in the server.xml (my database name is
test on the computer named remote)


		<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
					 driverName="org.postgresql.Driver"
   					connectionURL="jdbc:postgresql://remote:5432/test"
  					 connectionName="postgres"
   					connectionPassword="postgres"
  					 userTable="base_users"
   					userNameCol="email_id"
   					userCredCol="password"
   					userRoleTable="base_users"
  					 roleNameCol="role_code"/>


Poolman is configured as follows:


<datasource>
		<!-- ============================== -->
		<!-- Physical Connection Attributes -->
		<!-- ============================== -->
		<!-- Standard JDBC Driver info -->
		<dbname>testdb</dbname>
		<jndiName>jndi-testdb</jndiName>
		<driver>org.postgresql.Driver</driver>
		<url>jdbc:postgresql://remote:5432/test</url>
		<username>postgres</username>
		<password/>


I setup poolman and got the initial pages running but I run into a problem
when I try to add something.  I figured it was the Realm setup.  I tried
adding the Realm, but now Tomcat will not start.

I am using the pgjdbc2.jar driver for PostgreSQL.  and have placed it in the
common\lib folder

Is anyone using Postgres with Poolman and could they show me their Realm
entry?