API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 25th, 2016
110
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.93 KB | None | 0 0
raw download clone embed print report
  1. org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544344. I/O error during "CreateFile (open)" operation for file "SIGADM.FDB"
  2. Error while trying to open file
  3. null
  4. at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:120)
  5. at org.firebirdsql.jdbc.AbstractDriver.connect(AbstractDriver.java:136)
  6. at java.sql.DriverManager.getConnection(Unknown Source)
  7. at java.sql.DriverManager.getConnection(Unknown Source)
  8. at br.com.realsysten.SigadmWS.ConectaFireBird.obtemConexao(ConectaFireBird.java:21)
  9. at br.com.realsysten.SigadmWS.MesaDAO.buscarTodos(MesaDAO.java:14)
  10. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  11. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  12. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  13. at java.lang.reflect.Method.invoke(Unknown Source)
  14. at org.apache.axis2.rpc.receivers.RPCUtil.invokeServiceClass(RPCUtil.java:256)
  15. at org.apache.axis2.rpc.receivers.RPCInOnlyMessageReceiver.invokeBusinessLogic(RPCInOnlyMessageReceiver.java:70)
  16. at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:106)
  17. at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:169)
  18. at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:176)
  19. at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:163)
  20. at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
  21. at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  22. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
  23. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
  24. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  25. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
  26. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
  27. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
  28. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
  29. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  30. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
  31. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  32. at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
  33. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
  34. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
  35. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)
  36. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)
  37. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)
  38. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)
  39. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  40. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  41. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  42. at java.lang.Thread.run(Unknown Source)
  43. Caused by: org.firebirdsql.gds.GDSException: I/O error during "CreateFile (open)" operation for file "SIGADM.FDB"
  44. Error while trying to open file
  45. null
  46. at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2098)
  47. at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2048)
  48. at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.internalAttachDatabase(AbstractJavaGDSImpl.java:463)
  49. at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscAttachDatabase(AbstractJavaGDSImpl.java:411)
  50. at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:105)
  51. at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:509)
  52. at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:65)
  53. at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:118)
  54. ... 38 more
  55.  
  56. private static final String URL = "jdbc:firebirdsql://localhost/SIGADM.FDB";
  57.  
  58. import java.sql.Connection;
  59. import java.sql.DriverManager;
  60. import java.sql.SQLException;
  61.  
  62. public class ConectaFireBird {
  63.  
  64. private static final String URL = "jdbc:firebirdsql://localhost/SIGADM.FDB";
  65. private static final String User= "SYSDBA";
  66. private static final String Senha = "masterkey";
  67.  
  68. public static Connection obtemConexao() throws SQLException{
  69. try {
  70. Class.forName("org.firebirdsql.jdbc.FBDriver");
  71. } catch (ClassNotFoundException e) {
  72. // TODO Auto-generated catch block
  73. e.printStackTrace();
  74. }
  75.  
  76. return DriverManager.getConnection(URL, User, Senha);
  77. }
  78.  
  79.  
  80. }
  81.  
  82. public class Mesa {
  83.  
  84. private int id;
  85. private String barras;
  86. private String tipo;
  87. private String data;
  88. private int lugares;
  89. private String situacao;
  90. private String descricao;
  91. private double credito;
  92.  
  93. public Mesa(){
  94. }
  95.  
  96. public Mesa(int id, String barras, String tipo, String data, int lugares, String situacao, String descricao,
  97. double credito) {
  98. super();
  99. this.id = id;
  100. this.barras = barras;
  101. this.tipo = tipo;
  102. this.data = data;
  103. this.lugares = lugares;
  104. this.situacao = situacao;
  105. this.descricao = descricao;
  106. this.credito = credito;
  107. }
  108.  
  109. public int getId() {
  110. return id;
  111. }
  112.  
  113. public void setId(int id) {
  114. this.id = id;
  115. }
  116.  
  117. public String getBarras() {
  118. return barras;
  119. }
  120.  
  121. public void setBarras(String barras) {
  122. this.barras = barras;
  123. }
  124.  
  125. public String getTipo() {
  126. return tipo;
  127. }
  128.  
  129. public void setTipo(String tipo) {
  130. this.tipo = tipo;
  131. }
  132.  
  133. public String getData() {
  134. return data;
  135. }
  136.  
  137. public void setData(String data) {
  138. this.data = data;
  139. }
  140.  
  141. public int getLugares() {
  142. return lugares;
  143. }
  144.  
  145. public void setLugares(int lugares) {
  146. this.lugares = lugares;
  147. }
  148.  
  149. public String getSituacao() {
  150. return situacao;
  151. }
  152.  
  153. public void setSituacao(String situacao) {
  154. this.situacao = situacao;
  155. }
  156.  
  157. public String getDescricao() {
  158. return descricao;
  159. }
  160.  
  161. public void setDescricao(String descricao) {
  162. this.descricao = descricao;
  163. }
  164.  
  165. public double getCredito() {
  166. return credito;
  167. }
  168.  
  169. public void setCredito(double credito) {
  170. this.credito = credito;
  171. }
  172.  
  173. }
  174.  
  175. import java.sql.Connection;
  176. import java.sql.PreparedStatement;
  177. import java.sql.ResultSet;
  178. import java.util.ArrayList;
  179.  
  180. public class MesaDAO {
  181.  
  182. public ArrayList<Mesa> buscarTodos(){
  183. ArrayList<Mesa> lista = new ArrayList<Mesa>();
  184.  
  185. try {
  186. Connection conn = ConectaFireBird.obtemConexao();
  187. String querry = "SELECT * FROM CONTROLE";
  188. PreparedStatement stmt = conn.prepareStatement(querry);
  189. ResultSet rSet = stmt.executeQuery();
  190.  
  191. while(rSet.next()){
  192. Mesa mesa = new Mesa();
  193.  
  194. mesa.setId(rSet.getInt(1));
  195. mesa.setBarras(rSet.getString(2));
  196. mesa.setTipo(rSet.getString(3));
  197. mesa.setData(rSet.getString(4));
  198. mesa.setLugares(rSet.getInt(5));
  199. mesa.setSituacao(rSet.getString(6));
  200. mesa.setDescricao(rSet.getString(7));
  201. mesa.setCredito(rSet.getDouble(8));
  202.  
  203. lista.add(mesa);
  204. }
  205.  
  206. conn.close();
  207. } catch (Exception e) {
  208. // TODO Auto-generated catch block
  209. e.printStackTrace();
  210. }
  211. return lista;
  212. }
  213.  
  214. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!