JBoss AS 7 - Datasource configuration for postgresql

Hi

     This Article i describe how to create Datasource in JBoss AS 7.

 

If you are using the 1.6 JVM, then you should Download JDBC4 postgresql Driver.

 

Install the JDBC4 postgresql Driver as a JBoss 7 deployment

 

  • After downloading postgressql driver jar file. just move the postgressql driver jar file into Jboss 7 installation directory under standalone/deployments (jboss-as-web-7.0.0.Final/standalone/deployments).
  • Restart your jboss server
  • Then go to the url and type http://localhost:8080/
  • click Administration console.

jbossAdmin.png

In Jboss  Administration console you can press New datasource button, enter datasource name and jndi name then click next button.

step1.png

step 2 : select postgresql driver. click Next

 

step2.png

Step 3:  enter connection URL jdbc:postgresql://localhost:5432/template1 , Username and Password.

 

step3.png

finally click Done.

 

 

Testing the Postgressql Datasource


Using the test client you may now verify the proper installation of your datasource.

 

When testing a newly configured datasource we suggest using some very basic JDBC client code embedded in a JSP page  client.jsp

 

<%@page

    import="java.util.*,javax.naming.*,javax.sql.DataSource,java.sql.*"%>

 

<%

        DataSource ds = null;

        Connection con = null;

        Statement stmt = null;

        InitialContext ic;

        try {

            ic = new InitialContext();

            ds = (DataSource) ic.lookup("java:/SampleDS");

 

            con = ds.getConnection();

            stmt = con.createStatement();

 

            ResultSet rs = stmt.executeQuery("select * from login");

            while (rs.next()) {

                out.println("<br> " + rs.getString("username") + " | "

                        + rs.getString("password"));

            }

            rs.close();

            stmt.close();

        } catch (Exception e) {

            out.println("Exception thrown ");

            e.printStackTrace();

        } finally {

            if (con != null) {

                con.close();

            }

        }

    %>