0003683: PDO Can not connect Pgsql ,when pg port is not 5432.

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0003683

[Quercus]

minor

always

09-09-09 18:23

11-14-10 16:34

Reporter

nam

View Status

public

Assigned To

Priority

normal

Resolution

open

Status

new

Product Version

4.0.0

Summary

0003683: PDO Can not connect Pgsql ,when pg port is not 5432.

Description

(rep by junphine)

check the source ,it seems have a bug in

DataSource getPgsqlDataSource(Env env, String dsn){

StringBuilder url = new StringBuilder();
url.append("jdbc:postgresql://" [^]
url.append(host);

if (port != null){
url.append(port);
}

url.append('/');
url.append(dbname);

}

should add "url.append(':')" before "url.append(port)".

Additional Information

Attached Files

Relationships

Notes
(0004837) db 11-14-10 16:34	Bug confirmed to still exist in Quercus as distributed within Resin 4.0.13 or separately as "Quercus 4.0.11" (sill internally calling itself 4.0.7). As noted by the original poster, the errant code can be found in: .../src/com/caucho/quercus/lib/db/PDO.java in the method getPgsqlDataSource, around line 904: if (port != null) url.append(port); Fixed code: if (port != null) { url.append(':'); url.append(port); }

Issue History
Date Modified	Username	Field	Change
09-09-09 18:23	nam	New Issue
11-14-10 16:34	db	Note Added: 0004837
11-14-10 16:37	db	Issue Monitored: db

Mantis 1.0.0rc3[^]

30 total queries executed.
26 unique queries executed.