| Issue 8: | Use tomcat Datasource for Oracle connection | |
| 1 person starred this issue and may be notified of changes. | Back to list |
Replace web app datasource with tomcat datasource
Sep 17, 2014
Project Member
#1
ntanh...@gmail.com
Sep 17, 2014
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();
}
}
}
|