Package lib.exceptions

Examples of lib.exceptions.SQLPersistenceMechanismException

313
314
315
316
317
318
319
320
321
322
323
    } catch (PersistenceMechanismException e) {
      throw new RepositoryException(ExceptionMessages.EXC_FALHA_BD);
    } catch (SQLException e) {
      e.printStackTrace();
      throw new SQLPersistenceMechanismException(ExceptionMessages.EXC_FALHA_BD,sql);
    } finally {
      try {
        mp.releaseCommunicationChannel();
      } catch (PersistenceMechanismException e) {
        throw new RepositoryException(e.getMessage());
View Full Code Here
353
354
355
356
357
358
359
360
361
362
363
      stmt.close();

    } catch (PersistenceMechanismException e) {
      throw new RepositoryException("PersistenceMechanismException: " + e.getMessage());
    } catch (SQLException e) {
      throw new SQLPersistenceMechanismException("SQLException: " + e.getMessage(),sql);
    } finally {
      try {
        mp.releaseCommunicationChannel();
      } catch (PersistenceMechanismException e) {
        throw new RepositoryException("PersistenceMechanismException: " + e.getMessage());
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
        resultSet.close();
        stmt.close();

      } catch (SQLException e) {
        throw new SQLPersistenceMechanismException(ExceptionMessages.EXC_FALHA_BD, consulta);
      }

      // Consulta na tabela ao c�digo gerado pelo trecho anterior.
      // Caso o c�digo j� esteja em uso uma exce��o � levantada.
      String sql = null;
      try {
        stmt = (Statement) mp.getCommunicationChannel();
        sql = "SELECT * FROM scbs_endereco WHERE codigo = '" + end.getId() + "'";
        resultSet = stmt.executeQuery(sql);

        if (resultSet.next()) {
          throw new ObjectAlreadyInsertedException(ExceptionMessages.EXC_JA_EXISTE);
        }
        resultSet.close();
        stmt.close();
      } catch (SQLException e) {
        throw new SQLPersistenceMechanismException(ExceptionMessages.EXC_FALHA_BD, sql);
      }

      // Essa �ltima etapa da inser��o insere de fato os valores
      // recebidos no objeto do par�metro com c�digo e
      // identificador devidamente alterados
      try {
        sql = "INSERT INTO scbs_endereco VALUES(";

        //sql += end.getId() + ",";
        sql += "'" + end.getId() + "',";
        sql += "'" + end.getStreet() + "',";
        sql += "'" + end.getComplement() + "',";
        sql += "'" + end.getZip() + "',";
        sql += "'" + end.getState() + "',";
        sql += "'" + end.getPhone() + "',";
        sql += "'" + end.getCity() + "',";
        sql += "'" + end.getNeighbourhood() + "')";

        stmt = (Statement) this.mp.getCommunicationChannel();
        stmt.executeUpdate(sql);
        stmt.close();

      } catch (SQLException e) {
        throw new SQLPersistenceMechanismException(ExceptionMessages.EXC_FALHA_BD, sql);
      }
    } catch (PersistenceMechanismException e) {
      throw new RepositoryException(ExceptionMessages.EXC_FALHA_INCLUSAO);
    }
   
View Full Code Here
188
189
190
191
192
193
194
195
196
197
      stmt.close();

    } catch (PersistenceMechanismException e) {
      throw new RepositoryException(ExceptionMessages.EXC_FALHA_BD);
    } catch (SQLException e) {
      throw new SQLPersistenceMechanismException(ExceptionMessages.EXC_FALHA_BD,sql);
    }

    return end;
  }
View Full Code Here
55
56
57
58
59
60
61
62
63
            resultSet.close();
            stmt.close();           
        } catch (PersistenceMechanismException e) {
            throw new RepositoryException(e.getMessage());
        } catch (SQLException e) {
            throw new SQLPersistenceMechanismException(e.getMessage(),sql);
        }
        return response;
  }
View Full Code Here
85
86
87
88
89
90
91
92
93
    } catch (PersistenceMechanismException e) {
      e.printStackTrace();
      throw new RepositoryException(ExceptionMessages.EXC_FALHA_BD);
    } catch (SQLException e) {
      e.printStackTrace();
      throw new SQLPersistenceMechanismException(ExceptionMessages.EXC_FALHA_BD,sql);
    }
    return new ConcreteIterator(listatd);
  }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
                sql += td.getManifestation() + "','";
                sql += td.getDuration() + "')";              
                stmt.executeUpdate(sql);
                stmt.close();
            } catch (SQLException e) {
                throw new SQLPersistenceMechanismException(e.getMessage(),sql);
            } catch (PersistenceMechanismException e) {
                throw new RepositoryException(e.getMessage());
            } finally {
                try {
                    mp.releaseCommunicationChannel();
View Full Code Here
169
170
171
172
173
174
175
176
177
178
179
      td.setId(codigo);

    } catch (PersistenceMechanismException e) {
      throw new RepositoryException(e.getMessage());
    } catch (SQLException e) {
      throw new SQLPersistenceMechanismException(e.getMessage(),sql);
    } finally {
      try {
        mp.releaseCommunicationChannel();
      } catch (PersistenceMechanismException e) {
        throw new RepositoryException(e.getMessage());
View Full Code Here
264
265
266
267
268
269
270
271
272
273
    } catch (PersistenceMechanismException e) {
      throw new RepositoryException(ExceptionMessages.EXC_FALHA_BD);
    } catch (SQLException e) {
      e.printStackTrace();
      throw new SQLPersistenceMechanismException(ExceptionMessages.EXC_FALHA_BD,sql);
    }
   
    return td;
  }
View Full Code Here
55
56
57
58
59
60
61
62
  public synchronized PreparedStatement getPreparedStatement(String sql)
      throws RepositoryException {
    try {
      return getCommunicationChannel(false).prepareStatement(sql);
    } catch (SQLException ex) {
      throw new SQLPersistenceMechanismException("SQLException: " + ex.getMessage(),sql);
    }
  }
View Full Code Here
TOP

Related Classes of lib.exceptions.SQLPersistenceMechanismException

  • healthwatcher.data.rdb.AddressRepositoryRDB
  • healthwatcher.data.rdb.ComplaintRepositoryRDB
  • healthwatcher.data.rdb.DiseaseTypeRepositoryRDB
  • healthwatcher.data.rdb.EmployeeRepositoryRDB
  • healthwatcher.data.rdb.HealthUnitRepositoryRDB
  • healthwatcher.data.rdb.SpecialityRepositoryRDB
  • healthwatcher.data.rdb.SymptomRepositoryRDB
  • lib.persistence.PersistenceMechanism
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.