Advertisement
Guest User

Untitled

a guest
Mar 31st, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. <Resource name="jdbc/sqlserv" auth="Container"
  2. type="javax.sql.DataSource"
  3. maxActive="100" maxIdle="30" maxWait="10000"
  4. username="demonbartek"
  5. password=""
  6. driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
  7. url="jdbc:sqlserver://DEMONSQLEXPRESS:1433;databaseName=Hardwares;integratedSecurity=true;"/>
  8.  
  9. <resource-ref>
  10. <description>Connection Pool</description>
  11. <res-ref-name>jdbc/sqlserv</res-ref-name>
  12. <res-type>javax.sql.DataSource</res-type>
  13. <res-auth>Container</res-auth>
  14. </resource-ref>
  15.  
  16. (...)
  17. try {
  18. envContext = new InitialContext();
  19. Context initContext = (Context)envContext.lookup("java:/comp/env");
  20. DataSource ds = (DataSource)initContext.lookup("jdbc/sqlserv");
  21.  
  22. Connection con = ds.getConnection();
  23.  
  24. Statement stmt = con.createStatement();
  25. String query = "select * from Users";
  26. ResultSet rs = stmt.executeQuery(query);
  27.  
  28. while(rs.next())
  29. {
  30. (...)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement