Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544344. I/O error during "CreateFile (open)" operation for file "SIGADM.FDB"
- Error while trying to open file
- null
- at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:120)
- at org.firebirdsql.jdbc.AbstractDriver.connect(AbstractDriver.java:136)
- at java.sql.DriverManager.getConnection(Unknown Source)
- at java.sql.DriverManager.getConnection(Unknown Source)
- at br.com.realsysten.SigadmWS.ConectaFireBird.obtemConexao(ConectaFireBird.java:21)
- at br.com.realsysten.SigadmWS.MesaDAO.buscarTodos(MesaDAO.java:14)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
- at java.lang.reflect.Method.invoke(Unknown Source)
- at org.apache.axis2.rpc.receivers.RPCUtil.invokeServiceClass(RPCUtil.java:256)
- at org.apache.axis2.rpc.receivers.RPCInOnlyMessageReceiver.invokeBusinessLogic(RPCInOnlyMessageReceiver.java:70)
- at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:106)
- at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:169)
- at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:176)
- at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:163)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
- at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
- at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
- at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)
- at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)
- at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
- at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
- at java.lang.Thread.run(Unknown Source)
- Caused by: org.firebirdsql.gds.GDSException: I/O error during "CreateFile (open)" operation for file "SIGADM.FDB"
- Error while trying to open file
- null
- at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2098)
- at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2048)
- at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.internalAttachDatabase(AbstractJavaGDSImpl.java:463)
- at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscAttachDatabase(AbstractJavaGDSImpl.java:411)
- at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:105)
- at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:509)
- at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:65)
- at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:118)
- ... 38 more
- private static final String URL = "jdbc:firebirdsql://localhost/SIGADM.FDB";
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- public class ConectaFireBird {
- private static final String URL = "jdbc:firebirdsql://localhost/SIGADM.FDB";
- private static final String User= "SYSDBA";
- private static final String Senha = "masterkey";
- public static Connection obtemConexao() throws SQLException{
- try {
- Class.forName("org.firebirdsql.jdbc.FBDriver");
- } catch (ClassNotFoundException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- return DriverManager.getConnection(URL, User, Senha);
- }
- }
- public class Mesa {
- private int id;
- private String barras;
- private String tipo;
- private String data;
- private int lugares;
- private String situacao;
- private String descricao;
- private double credito;
- public Mesa(){
- }
- public Mesa(int id, String barras, String tipo, String data, int lugares, String situacao, String descricao,
- double credito) {
- super();
- this.id = id;
- this.barras = barras;
- this.tipo = tipo;
- this.data = data;
- this.lugares = lugares;
- this.situacao = situacao;
- this.descricao = descricao;
- this.credito = credito;
- }
- public int getId() {
- return id;
- }
- public void setId(int id) {
- this.id = id;
- }
- public String getBarras() {
- return barras;
- }
- public void setBarras(String barras) {
- this.barras = barras;
- }
- public String getTipo() {
- return tipo;
- }
- public void setTipo(String tipo) {
- this.tipo = tipo;
- }
- public String getData() {
- return data;
- }
- public void setData(String data) {
- this.data = data;
- }
- public int getLugares() {
- return lugares;
- }
- public void setLugares(int lugares) {
- this.lugares = lugares;
- }
- public String getSituacao() {
- return situacao;
- }
- public void setSituacao(String situacao) {
- this.situacao = situacao;
- }
- public String getDescricao() {
- return descricao;
- }
- public void setDescricao(String descricao) {
- this.descricao = descricao;
- }
- public double getCredito() {
- return credito;
- }
- public void setCredito(double credito) {
- this.credito = credito;
- }
- }
- import java.sql.Connection;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.util.ArrayList;
- public class MesaDAO {
- public ArrayList<Mesa> buscarTodos(){
- ArrayList<Mesa> lista = new ArrayList<Mesa>();
- try {
- Connection conn = ConectaFireBird.obtemConexao();
- String querry = "SELECT * FROM CONTROLE";
- PreparedStatement stmt = conn.prepareStatement(querry);
- ResultSet rSet = stmt.executeQuery();
- while(rSet.next()){
- Mesa mesa = new Mesa();
- mesa.setId(rSet.getInt(1));
- mesa.setBarras(rSet.getString(2));
- mesa.setTipo(rSet.getString(3));
- mesa.setData(rSet.getString(4));
- mesa.setLugares(rSet.getInt(5));
- mesa.setSituacao(rSet.getString(6));
- mesa.setDescricao(rSet.getString(7));
- mesa.setCredito(rSet.getDouble(8));
- lista.add(mesa);
- }
- conn.close();
- } catch (Exception e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- return lista;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement