Error connecting when user has no password
От | Ed Tyrrill |
---|---|
Тема | Error connecting when user has no password |
Дата | |
Msg-id | 3250F281630BD6418DCF23E78151979B0ADB83@hermes.avamar.com обсуждение исходный текст |
Ответы |
Re: Error connecting when user has no password
|
Список | pgsql-jdbc |
I am in the process of moving our application from postgresql 7.2.1-5 to 7.3.6-7. I also changed the jdbc driver we use from pg72jdbc2.jar to pg73jdbc2.jar. I can no longer get a connection for users that have no password from java. I couldn't figure out why I couldn't get a connection with our usual user that has no database password, and then on a hunch tried using a different user that has a password, and everything worked fine. The no password user can connect using psql with no problems. The postgres upgrade is just one part of our platform update from red hat 7.3 to enterprise linux 3, and java 1.4.2 to 5.0. So it could possibly be something with the new java version as well, but the exception I get is in the postgres jdbc driver code: A connection error has occurred: FATAL: Password authentication failed for user "admin" at org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Con nection.java:202) at org.postgresql.Driver.connect(Driver.java:122) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.avamar.mc.datatap.ConnectionPool.createConnections(ConnectionPool.java:1 84) ConnectionPool.java line 184 is basically this: Connection con = DriverManager.getConnection( connectURL, "admin", "" ); This all worked fine with 7.2.1.5, and before that with some version of 7.1. Thanks in advance for any assistance. Ed
В списке pgsql-jdbc по дате отправления: