choky10 Posted November 11, 2017 Share Posted November 11, 2017 (edited) Hello i want to know the MAX USER CONNECTIONS is because i close the connection?or what this i code i want ask for help because after 4 search, i get the MAX USER CONNECTIONS error ListarClientes.javaHere i put the rows and columns to the Table, and i ask for the SQL public void ListarClients(String consulta, DefaultTableModel modelo) throws SQLException{ String sql = consulta; Connection con = Conexion.connect(); try { Statement s = con.createStatement(); ResultSet rs = s.executeQuery(sql); ResultSetMetaData metaDatos = rs.getMetaData(); // Se obtiene el número de columnas. int numeroColumnas = metaDatos.getColumnCount(); Object[] etiquetas = new Object[numeroColumnas]; for (int i = 0; i < numeroColumnas; i++){ // Nuevamente, para ResultSetMetaData la primera columna es la 1. etiquetas[i] = metaDatos.getColumnLabel(i + 1); } modelo.setColumnIdentifiers(etiquetas); while (rs.next()){ Object [] fila = new Object[numeroColumnas]; for (int i=0;i<numeroColumnas;i++) fila[i] = rs.getObject(i+1); // El primer indice en rs es el 1, no el cero, por eso se suma 1. modelo.addRow(fila); cerrar(); rs.close(); } } catch (SQLException ex) { JOptionPane.showMessageDialog(null, ex); } } 1 SEARCH1 RUN 1 TIME WHEN I OPEN THE SEARCH.JAVA WITH THE METODO ALL(); - WITH THIS WHEN THE FRAME GET OPEN THE DATA IS PREPARE AND IS IN THE TABLE public void all(){ Usuarios u = new Usuarios(); DefaultTableModel modelo = new DefaultTableModel(); String consulta = "SELECT * FROM clientes"; try { u.ListarClients(consulta, modelo); } catch (SQLException ex) { Logger.getLogger(BuscarCliente.class.getName()).log(Level.SEVERE, null, ex); } tabla.setModel(modelo); } 2.- SEARCH.. IN THE BOX I put the data to search and i click in search button, this button jave this method: IN THIS MOMMENT all is ok.. Usuarios u = new Usuarios(); DefaultTableModel modelo = new DefaultTableModel(); String consulta = "SELECT * FROM clientes WHERE rfc LIKE '"+rfc.getText()+"%'"; try { u.ListarClients(consulta, modelo); } catch (SQLException ex) { Logger.getLogger(BuscarCliente.class.getName()).log(Level.SEVERE, null, ex); } tabla.setModel(modelo); 3.- i doe another search with the same method... 4.- i doe another and the error max connections show in this momment the SQLExeception 5.- IF I CLOSE THE PROJECT AND RUN AGAIN THE CONSOLE IS BUG IN THE SQLExecption Max Users Connections and the program cant continue.. What i doe wrong?My code i dont close the connections ?or what? Edited November 11, 2017 by choky10 Quote Link to comment Share on other sites More sharing options...
Luigi123 Posted November 11, 2017 Share Posted November 11, 2017 Moved to Customer Service. Quote Link to comment Share on other sites More sharing options...
Krydos Posted November 12, 2017 Share Posted November 12, 2017 See if this helps https://stackoverflow.com/a/2225275 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.