Need help on connect to postgresql
От | Apichart Asavarojpanich |
---|---|
Тема | Need help on connect to postgresql |
Дата | |
Msg-id | F103PrPrvCWO6hm8Ua800000073@hotmail.com обсуждение исходный текст |
Список | pgsql-jdbc |
Hi! I'm try to use java to connect to PostgreSQL7.2.1 by using JDBC driver (pgjdbc2.jar). I add up this line on pg_hba.conf under data directory as the following. "host all 172.16.1.0 255.255.255.0 password userpasswds" and create userpasswds file by using pg_password My client machine IP is 172.16.1.100 and I can use pgaccess to connect to my database without any problem but I cannot connect to database by using java code. This is the part that generating an error when debugging. "line 1 Class.forName("org.postgresql.Driver"); line 2 System.out.println("Driver registered"); line 3 Connection conn = DriverManager.getConnection(url, logname, passwd); line 4 System.out.println("Database connected"); " After line 2 it create this errors. "Driver registered Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.security.AccessControlException: access denied (java.net.SocketPermission Ldna resolve) Stack Trace: java.security.AccessControlException: access denied (java.net.SocketPermission Ldna resolve) at java.security.AccessControlContext.checkPermission(AccessControlContext.java:270) at java.security.AccessController.checkPermission(AccessController.java:401) at java.lang.SecurityManager.checkPermission(SecurityManager.java:542) at java.lang.SecurityManager.checkConnect(SecurityManager.java:1042) at java.net.InetAddress.getAllByName0(InetAddress.java:909) at java.net.InetAddress.getAllByName0(InetAddress.java:890) at java.net.InetAddress.getAllByName(InetAddress.java:884) at java.net.InetAddress.getByName(InetAddress.java:814) at java.net.InetSocketAddress.<init>(InetSocketAddress.java:109) at java.net.Socket.<init>(Socket.java:118) at org.postgresql.PG_Stream.<init>(PG_Stream.java:41) at org.postgresql.Connection.openConnection(Connection.java:134) at org.postgresql.Driver.connect(Driver.java:149) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at rmidemo.StudentImpl.initializeDB(StudentImpl.java:28) at rmidemo.StudentImpl.<init>(StudentImpl.java:12) at rmidemo.StudentServer.main(StudentServer.java:12) End of Stack Trace" It looks like that an access denied occurs but I use the same username and password to access Postgresql when using pgaccess or pgadmin on the same client machine. Both are fine without any problem. Please give me any clue to fine the reason. Please help Thanks in advance Chart my email is "apicharta@hotmail.com" _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx
В списке pgsql-jdbc по дате отправления: