Guest User

Untitled

a guest
Aug 19th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.74 KB | None | 0 0
  1. javax.servlet.ServletException: org.glassfish.jersey.server.ContainerException: java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null'
  2. org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:432)
  3. org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:370)
  4. org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:389)
  5. org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:342)
  6. org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:229)
  7. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  8.  
  9. <GlobalNamingResources>
  10. . . .
  11. <Resource name="jdbc/db_anwinity" auth="Container"
  12. type="javax.sql.DataSource"
  13. driverClassName="org.postgresql.Driver"
  14. url="jdbc:postgresql://127.0.0.1:5432/xxxx"
  15. username="xxxx"
  16. password="xxxx"
  17. maxTotal="20"
  18. maxIdle="10"
  19. maxWaitMillis="15000" />
  20. </GlobalNamingResources>
  21.  
  22. <?xml version="1.0" encoding="UTF-8"?>
  23. <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
  24. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  25. xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
  26.  
  27. <resource-ref>
  28. <description>xxxx Connection</description>
  29. <res-ref-name>jdbc/xxxx</res-ref-name>
  30. <res-type>javax.sql.DataSource</res-type>
  31. <res-auth>Container</res-auth>
  32. </resource-ref>
  33.  
  34. <servlet>
  35. <servlet-name>Anwinity Test App</servlet-name>
  36. <servlet-class>org.glassfish.jersey.servlet.ServletContainer</servlet-class>
  37. <init-param>
  38. <param-name>jersey.config.server.provider.packages</param-name>
  39. <param-value>com.anwinity.webapps.test</param-value>
  40. </init-param>
  41. <load-on-startup>1</load-on-startup>
  42. </servlet>
  43. <servlet-mapping>
  44. <servlet-name>Anwinity Test App</servlet-name>
  45. <url-pattern>/api/*</url-pattern>
  46. </servlet-mapping>
  47. </web-app>
  48.  
  49. package com.anwinity.webapps.test;
  50.  
  51. import java.sql.Connection;
  52. import java.sql.ResultSet;
  53. import java.sql.Statement;
  54. import java.util.ArrayList;
  55. import java.util.List;
  56. import javax.naming.InitialContext;
  57. import javax.sql.DataSource;
  58. import javax.ws.rs.GET;
  59. import javax.ws.rs.Path;
  60. import javax.ws.rs.Produces;
  61. import javax.ws.rs.core.MediaType;
  62. import javax.ws.rs.core.Response;
  63.  
  64. @Path("test")
  65. public class TestResource {
  66.  
  67. @GET
  68. @Produces(MediaType.APPLICATION_JSON)
  69. public Response test() throws Exception {
  70.  
  71. // InitialContext ctx = new InitialContext();
  72. // DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/xxxx");
  73. Context initContext = new InitialContext();
  74. Context envContext = (Context)initContext.lookup("java:/comp/env");
  75. DataSource ds = (DataSource)envContext.lookup("jdbc/xxxx");
  76. if(ds == null) {
  77. System.out.println(":(");
  78. return Response.noContent().build();
  79. }
  80. else {
  81. try(Connection conn = ds.getConnection()) {
  82. String sql = "select * from test";
  83. try(Statement stmt = conn.createStatement()) {
  84. List<Integer> list = new ArrayList<>();
  85. try(ResultSet rs = stmt.executeQuery(sql)) {
  86. while(rs.next()) {
  87. int i = rs.getInt(1);
  88. System.out.println(i);
  89. list.add(i);
  90. }
  91. TestResponse resp = new TestResponse();
  92. resp.setN(list.stream().mapToInt(i -> i).toArray());
  93. return Response.ok(resp).build();
  94. }
  95. }
  96. }
  97. }
  98.  
  99. }
  100. }
Add Comment
Please, Sign In to add comment