API tools faq
paste
Guest User

Untitled

a guest
Dec 6th, 2017
127
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.14 KB | None | 0 0
raw download clone embed print report
  1. java.sql.SQLException: path to 'resources/greetings.sqlite': 'C:Deveclipseresources' does not exist
  2. at org.sqlite.core.CoreConnection.open(CoreConnection.java:192)
  3. at org.sqlite.core.CoreConnection.<init>(CoreConnection.java:76)
  4. at org.sqlite.jdbc3.JDBC3Connection.<init>(JDBC3Connection.java:25)
  5. at org.sqlite.jdbc4.JDBC4Connection.<init>(JDBC4Connection.java:24)
  6. at org.sqlite.SQLiteConnection.<init>(SQLiteConnection.java:45)
  7. at org.sqlite.JDBC.createConnection(JDBC.java:114)
  8. at org.sqlite.JDBC.connect(JDBC.java:88)
  9. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  10. at java.sql.DriverManager.getConnection(DriverManager.java:270)
  11. at demo.rest.jersey.spring.dao.JdbcGreetingDAO.getRowCount(JdbcGreetingDAO.java:29)
  12. at demo.rest.jersey.spring.GreetingService.randomGreeting(GreetingService.java:29)
  13. at demo.rest.jersey.spring.GreetingService.greet(GreetingService.java:18)
  14. at demo.rest.jersey.spring.SpringRequestResource.getHello(SpringRequestResource.java:28)
  15. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  16. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  17. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  18. at java.lang.reflect.Method.invoke(Method.java:498)
  19.  
  20. org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (path to 'resources/greetings.sqlite': 'C:Deveclipseresources' does not exist)
  21. at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
  22. at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
  23. at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
  24. at demo.rest.jersey.spring.dao.JdbcGreetingDAO.getConn(JdbcGreetingDAO.java:34)
  25. at demo.rest.jersey.spring.dao.JdbcGreetingDAO.getRowCount(JdbcGreetingDAO.java:47)
  26. at demo.rest.jersey.spring.GreetingService.randomGreeting(GreetingService.java:29)
  27. at demo.rest.jersey.spring.GreetingService.greet(GreetingService.java:18)
  28. at demo.rest.jersey.spring.SpringRequestResource.getHello(SpringRequestResource.java:28)
  29. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  30. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  31. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  32. at java.lang.reflect.Method.invoke(Method.java:498)
  33. at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:76)
  34. at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:148)
  35. at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:191)
  36. at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:243)
  37. at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:103)
  38. at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:493)
  39. at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:415)
  40. at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:104)
  41. at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:277)
  42. at org.glassfish.jersey.internal.Errors$1.call(Errors.java:272)
  43. at org.glassfish.jersey.internal.Errors$1.call(Errors.java:268)
  44. at org.glassfish.jersey.internal.Errors.process(Errors.java:316)
  45. at org.glassfish.jersey.internal.Errors.process(Errors.java:298)
  46. at org.glassfish.jersey.internal.Errors.process(Errors.java:268)
  47. at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:289)
  48. at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:256)
  49. at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:703)
  50. at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:416)
  51. at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:370)
  52. at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:389)
  53. at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:342)
  54. at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:229)
  55. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  56. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  57. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  58. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  59. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  60. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
  61. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
  62. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
  63. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
  64. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  65. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
  66. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  67. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
  68. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
  69. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
  70. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
  71. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  72. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  73. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  74. at java.lang.Thread.run(Thread.java:745)
  75. Caused by: java.sql.SQLException: path to 'resources/greetings.sqlite': 'C:Deveclipseresources' does not exist
  76. at org.sqlite.core.CoreConnection.open(CoreConnection.java:192)
  77. at org.sqlite.core.CoreConnection.<init>(CoreConnection.java:76)
  78. at org.sqlite.jdbc3.JDBC3Connection.<init>(JDBC3Connection.java:25)
  79.  
  80. import java.sql.Connection;
  81. import java.sql.DriverManager;
  82. import java.sql.ResultSet;
  83. import java.sql.SQLException;
  84. import java.sql.Statement;
  85.  
  86.  
  87. public class JdbcGreetingDAO implements GreetingDAO
  88. {
  89. private static final String DRIVER = "org.sqlite.JDBC";
  90. private static final String DBNAME = "resources/greetings.sqlite";
  91. private static final String DBURL = "jdbc:sqlite:" + DBNAME;
  92.  
  93. private Connection getConn() throws SQLException
  94. {
  95. Connection conn = null;
  96. try
  97. {
  98. Context ctx = new InitialContext();
  99. DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/greetings.sqlite");
  100. conn = ds.getConnection();
  101. }
  102. catch(NamingException ne)
  103. {
  104. System.out.println("Cannot get connection");
  105. ne.printStackTrace();
  106. }
  107. return conn;
  108. }
  109.  
  110.  
  111. @Override
  112. public void insert(String greeting) throws SQLException
  113. {
  114. Connection conn = getConn();
  115. Statement st = conn.createStatement();
  116. st.executeUpdate(String.format("INSERT INTO greetings (greeting) VALUES (%s)", greeting));
  117. }
  118. }
  119.  
  120. public class GreetingService
  121. {
  122. @Autowired
  123. private JdbcGreetingDAO dataSource;
  124.  
  125. public String addGreeting(String greeting) throws SQLException
  126. {
  127. dataSource.insert(greeting);
  128. return greeting;
  129. }
  130. }
  131.  
  132. <resource-ref>
  133. <description>Greetings Database</description>
  134. <res-ref-name>jdbc/greetings.sqlite</res-ref-name>
  135. <res-type>javax.sql.DataSource</res-type>
  136. <res-auth>Container</res-auth>
  137. </resource-ref>
  138.  
  139. <?xml version="1.0" encoding="UTF-8"?>
  140. <Context>
  141. <Resource name="jdbc/greetings.sqlite"
  142. auth="Container"
  143. type="javax.sql.DataSource"
  144. driverClassName="org.sqlite.JDBC"
  145. url="jdbc:sqlite:resources/greetings.sqlite"
  146. factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory">
  147. </Resource>
  148. </Context>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!