Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <Resource name="jdbc/sqlserv" auth="Container"
- type="javax.sql.DataSource"
- maxActive="100" maxIdle="30" maxWait="10000"
- username="demonbartek"
- password=""
- driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
- url="jdbc:sqlserver://DEMONSQLEXPRESS:1433;databaseName=Hardwares;integratedSecurity=true;"/>
- <resource-ref>
- <description>Connection Pool</description>
- <res-ref-name>jdbc/sqlserv</res-ref-name>
- <res-type>javax.sql.DataSource</res-type>
- <res-auth>Container</res-auth>
- </resource-ref>
- (...)
- try {
- envContext = new InitialContext();
- Context initContext = (Context)envContext.lookup("java:/comp/env");
- DataSource ds = (DataSource)initContext.lookup("jdbc/sqlserv");
- Connection con = ds.getConnection();
- Statement stmt = con.createStatement();
- String query = "select * from Users";
- ResultSet rs = stmt.executeQuery(query);
- while(rs.next())
- {
- (...)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement