You need to add the "-i" switch to postmaster (-o -i to pg_ctl I
think) to enable tcp/ip connections. Please see the PostgreSQL
documentation.
2005/9/8, R Rajendran <[EMAIL PROTECTED]>:
> Hi,
>
> When I connect Struts to Postgresql 8.0 database using DataSource object I
> get the following error messages:
>
> Source:
>
> DataSource dataSource = null;
>
> try {
> dataSource = getDataSource(request);
> conn = dataSource.getConnection();
>
> /* working
> Class.forName("org.postgresql.Driver");
> conn =
> DriverManager.getConnection("jdbc:postgresql://192.168.1.22:5432/omsdb","postgres","postgres");
> */
>
> stmt = conn.createStatement();
> String sql = "select * from stocks where "
> + "symbol ='" + symbol + "'";
> rs = stmt.executeQuery("select * from stocks where "
> + "symbol ='" + symbol + "'");
> }catch(){..}
> *************************************************
> struts-config.xml:
>
> <data-source type="org.postgresql.jdbc2.optional.SimpleDataSource">
>
> <set-property property="driverClassName"
>
> value="org.postgresql.Driver" />
>
> <set-property property="url"
>
> value="jdbc:postgresql://192.168.1.22:5432/omsdb" />
>
> <set-property property="username"
>
> value="postgres" />
>
> <set-property property="password"
>
> value="postgres" />
>
> </data-source>
>
> *****************************************************
>
>
>
> I am getting the following error message while running the struts application:
>
> INFO: Failed to create a non-pooled connection for null at
> jdbc:postgresql://localhost/null?prepareThreshold=0:
> org.postgresql.util.PSQLException: Connection refused. Check that the
> hostname and port are correct and that the postmaster is accepting TCP/IP
> connections.
>
> Connection refused. Check that the hostname and port are correct and that the
> postmaster is accepting TCP/IP connections.
>
> Could anyone tell me how to resolve this issue.
>
>
> Thanks
> Raj
>
>
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> 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]
