Issue 8: Use tomcat Datasource for Oracle connection
Status:  Accepted
Owner:
Project Member Reported by ntanh...@gmail.com, Sep 17, 2014
Replace web app datasource with tomcat datasource
Sep 17, 2014
Project Member #1 ntanh...@gmail.com
https://www.liferay.com/community/wiki/-/wiki/Main/Add+Datasource+to+Portlet
Add the following line to tomcat-7.0.42/conf/context.xml
 
<Resource name="jdbc/oracle"
     auth="Container"
     type="javax.sql.DataSource"
     maxActive="10"
     maxIdle="30"
     maxWait="10000"
     username="htlyktt"
     password="admin"
     driverClassName="oracle.jdbc.driver.OracleDriver"
     url="jdbc:oracle:thin:@localhost:1521:xe"/>
Sep 17, 2014
Project Member #2 ntanh...@gmail.com
Using this code to get datasource
public class ConnectionDatasource {
	public static DataSource datasource  = null;
	static {
		String DATASOURCE_CONTEXT = "java:comp/env/jdbc/oracle";
	     try {
	    	 Context initialContext = new InitialContext();
	    	 datasource = (DataSource)initialContext.lookup(DATASOURCE_CONTEXT);
		     if (datasource != null) {
		     //result = datasource.getConnection();
		    	 System.out.println("Lookup datasource.");
		     //Statement stmt = result.createStatement();
		     }else{
		    	 System.out.println("Can not find datasource.");
		     }
		} catch (NamingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} 
	}
       
}