Finally .... The Authentication Issue Resolved for Connecting to PostGreSQL from Java

Hooh! So HAPPY!!! Finally, got it resolved for PostgreSQL 9.2 in Windows Environment

Inside the pg_hba.conf that is inside the folder C:\Program Files\PostGreSQL\9.2\data, navigate to the section titled "# IPv4 ...", and add this:


# IPv4 local connections:
host    all             all             0.0.0.0/0                trust
host    all             all             127.0.0.1/32            trust

For the second row, which is originally there with md5 authentication, make it trust also.

This solution is referenced to: http://www.postgresql.org/docs/9.2/static/auth-methods.html

For more details about any security issue, if your scenario is not for localhost connection. For my case, am trying to connect using localhost.

The following is a sample code used in Java:


import java.sql.*;
import java.util.*;

public class PGSample
{
  public static void main(String[] args)
  {
    Connection connection = null;
    try
    {
      // the postgresql driver string
      Class.forName("org.postgresql.Driver");
 
      // the postgresql url
      String url = "jdbc:postgresql://localhost:5432/TestDB";
   
      // get the postgresql database connection
      connection = DriverManager.getConnection(url,"pguser", "");
   
      // now do whatever you want to do with the connection
      // ...
   
    }
    catch (ClassNotFoundException e)
    {
      e.printStackTrace();
      System.exit(1);
    }
    catch (SQLException e)
    {
      e.printStackTrace();
      System.exit(2);
    }
  }
}

Note: Replace the database TestDB with the name of the DB in your pc or server. Also, replace "pguser" with the user id in your own server.

Java + PostgreSQL

http://zetcode.com/db/postgresqljavatutorial/

http://www.java-samples.com/showtutorial.php?tutorialid=202

http://alvinalexander.com/blog/post/jdbc/sample-java-jdbc-program-connect-database

Configuring: http://jdbc.postgresql.org/documentation/head/setup.html

Download Driver: http://jdbc.postgresql.org/download.html

Checking JDBC: http://stackoverflow.com/questions/4215742/how-to-test-if-jdbc-driver-is-installed-correctly-and-if-the-db-can-be-connected

Unicode and Chinese Characters in Java - Reference

The following are some reference points for above subject ...

Currently, am still busy to explore further ... so to keep my self some convenience for the research later :)

Added on 26 Apr

http://javarevisited.blogspot.com/2012/01/get-set-default-character-encoding.html

http://stackoverflow.com/questions/2622911/fix-string-encoding-in-java

http://www.tutorialspoint.com/java/java_string_getbytes.htm

http://exampledepot.8waytrips.com/egs/java.nio.charset/ConvertChar.html

http://examples.javacodegeeks.com/core-java/nio/charbuffer/convert-between-character-set-encodings-with-charbuffer/

---------------------------------------------------------------------------------------------------------------

http://docs.oracle.com/javase/7/docs/api/java/io/BufferedReader.html

http://docs.oracle.com/javase/7/docs/api/java/io/InputStreamReader.html

http://www.velocityreviews.com/forums/t592855-how-to-display-input-write-chinese-text-in-java.html

http://stackoverflow.com/questions/766361/how-to-save-chinese-characters-to-file-with-java

http://www.b-t.asia/chinese/prog-java.php

https://forums.oracle.com/forums/thread.jspa?messageID=9949628&#9949628

http://users.erols.com/eepeter/chinesecomputing/programming/java.html

http://stackoverflow.com/questions/8873121/reading-chinese-characters-into-a-string-from-a-byte-buffer

http://www.mkyong.com/java/java-convert-chinese-character-to-unicode-with-native2ascii/

http://www.mandarintools.com/javaconverter.html