How to establish JDBC Connection in JSF 2.0 using Oracle Database ?

[rajarshi roy]

How to establish JDBC Connection in JSF 2.0 using Oracle Database ?

Till now I have been using JSP,and I used the method given below to establish JDBC connection.The database is the same,the application server is different,it is Tomcat 6.0 and it runs JSF 2.0 properly.But the same method does not work.Am I missing some configuration here?

private PageContext pg = null;
private String DriverName = "oracle.jdbc.driver.OracleDriver";
private String UserName = "apps";

private String Password = "P@1nkiller";
private String ip = "172.16.117.1";
private String SID = "ORADB";

public Connection getAnyJDBCConnection()
{
Connection con = null;

try
{
Class.forName(DriverName);
url = "jdbc:oracle:thin:@" + ip + ":" + port + ":" + SID;
con = DriverManager.getConnection(url, UserName, Password);
System.out.println("connection is established" + con);
}
catch(Exception e)
{
System.out.println("Class not found" + e);
}

return con;
}

[Tim Holloway]

If you're using an advanced system like JSF, you really shouldn't be using basic JDBC connection management. It's like coupling a toy train engine to a set of commuter railway cars. You should consider using a Connection Pool, instead.

Also, "it does not work" doesn't really tell us anything. http://www.coderanch.com/how-to/java/TellTheDetails