Styjun

How can drunken, homicidal elves successfully conduct a wild hunt?

What was with the Miles Morales's stickers?

Should an arbiter claim draw at a K+R vs K+R endgame?

Russian equivalents of "no love lost"

Average spam confidence

At what point in time did Dumbledore ask Snape to kill him?

Comparing and find out which feature has highest shape area in QGIS?

How to tell your grandparent to not come to fetch you with their car?

Where does "0 packages can be updated." come from?

Preventing Employees from either switching to Competitors or Opening Their Own Business

Can the poison from Kingsmen be concocted?

Best way to deal with non-developers in a scrum team

How much salt (or any other substance one can find in a kitchen) do I need to add to make water boil at 104 °C?

Is it possible to 'live off the sea'

Passing an Parameter to Apex from LWC

Should I compare a std::string to "string" or "string"s?

Indirectly defined macros: Undefined macro with "@" does not trigger compile error

Inconsistent behavior of compiler optimization of unused string

Payment instructions allegedly from HomeAway look fishy to me

Orange material in grout lines - need help to identify

How do I write "Show, Don't Tell" as a person with Asperger Syndrome?

Is open-sourcing the code of a webapp not recommended?

Are there downsides to using std::string as a buffer?

How does a transformer increase voltage while decreasing the current?

Data truncated for column 'id_cliente' at row 1

SQLException: fetched column value was truncated when executing while (rs.getNext())Invalid scale size. Cannot be less than zerounable to drop table in HSQLDBstatement . executeUpdate gives date truncated for column X at row 1 errormssql_bind in PHP truncates stringMysql timestamp Data truncated for columnSelect Query and will appear to comboBox in Netbeans & mysqlHow to support column names with spaces using sqoop import?Why is my data being truncated? Warning | 1265 | Data truncated for columnErrors in client side (Android) during connecting to server side (PHP) in Netbeans

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have this program in netbeans where I need to send to my database(PHP) the client id(int) and his name(String), I am using comboBox to connect a client with a driver. In PHP i have only the id_client column(int 50) and I need to save the id and the name in that column, but i keep getting this error java.sql.SQLException: Data truncated for column 'id_client' at row 1. I have a max of 50 characters and I am only using less than 15. Please help

I have this code on formWindowOpened

 try 


 jComboBox1.removeAllItems();

 jComboBox2.removeAllItems();

 ArrayList<Cliente> lista_cliente = new ArrayList<Cliente>();

 ArrayList<Motorista> lista_motorista = new ArrayList<Motorista>();

 Manipular_BD bd = new Manipular_BD();

 bd.registarDrive();

 bd.efetuarLigacao();

 lista_cliente = bd.listarCliente();

 lista_motorista = bd.listarMotorista();

 for (int i = 0; i < bd.listarCliente().size(); i++) 

 jComboBox1.addItem(String.valueOf(lista_cliente.get(i).getId_cliente()
 + " - " + lista_cliente.get(i).getNomeCliente()));
 

 for (int i = 0; i < bd.listarMotorista().size(); i++) 

jComboBox2.addItem(String.valueOf(lista_motorista.get(i).getId_motorista() 
+ " - " + lista_motorista.get(i).getNomeMotorista()));
 

bd.fecharLigacao();

 catch (SQLException ex) 
 Logger.getLogger(ListarCliente.class.getName()).log(Level.SEVERE, null, ex);
 

And I have this code in my button to connect the client with the driver, I am not sure but I think the error might be here

 Manipular_BD bd = new Manipular_BD();
 bd.registarDrive();
 bd.efetuarLigacao();
 bd.reservar(String.valueOf(jComboBox1.getSelectedItem().toString()), 
 String.valueOf(jComboBox2.getSelectedItem().toString()));
 JOptionPane.showMessageDialog(null, "Reservado com sucesso"); 

 bd.fecharLigacao();

java netbeans truncated

share|improve this question

asked Mar 24 at 15:41

AllyAlly

11

add a comment | 

0

I have this program in netbeans where I need to send to my database(PHP) the client id(int) and his name(String), I am using comboBox to connect a client with a driver. In PHP i have only the id_client column(int 50) and I need to save the id and the name in that column, but i keep getting this error java.sql.SQLException: Data truncated for column 'id_client' at row 1. I have a max of 50 characters and I am only using less than 15. Please help

I have this code on formWindowOpened

 try 


 jComboBox1.removeAllItems();

 jComboBox2.removeAllItems();

 ArrayList<Cliente> lista_cliente = new ArrayList<Cliente>();

 ArrayList<Motorista> lista_motorista = new ArrayList<Motorista>();

 Manipular_BD bd = new Manipular_BD();

 bd.registarDrive();

 bd.efetuarLigacao();

 lista_cliente = bd.listarCliente();

 lista_motorista = bd.listarMotorista();

 for (int i = 0; i < bd.listarCliente().size(); i++) 

 jComboBox1.addItem(String.valueOf(lista_cliente.get(i).getId_cliente()
 + " - " + lista_cliente.get(i).getNomeCliente()));
 

 for (int i = 0; i < bd.listarMotorista().size(); i++) 

jComboBox2.addItem(String.valueOf(lista_motorista.get(i).getId_motorista() 
+ " - " + lista_motorista.get(i).getNomeMotorista()));
 

bd.fecharLigacao();

 catch (SQLException ex) 
 Logger.getLogger(ListarCliente.class.getName()).log(Level.SEVERE, null, ex);
 

And I have this code in my button to connect the client with the driver, I am not sure but I think the error might be here

 Manipular_BD bd = new Manipular_BD();
 bd.registarDrive();
 bd.efetuarLigacao();
 bd.reservar(String.valueOf(jComboBox1.getSelectedItem().toString()), 
 String.valueOf(jComboBox2.getSelectedItem().toString()));
 JOptionPane.showMessageDialog(null, "Reservado com sucesso"); 

 bd.fecharLigacao();

java netbeans truncated

share|improve this question

asked Mar 24 at 15:41

AllyAlly

11

add a comment | 

I have this program in netbeans where I need to send to my database(PHP) the client id(int) and his name(String), I am using comboBox to connect a client with a driver. In PHP i have only the id_client column(int 50) and I need to save the id and the name in that column, but i keep getting this error java.sql.SQLException: Data truncated for column 'id_client' at row 1. I have a max of 50 characters and I am only using less than 15. Please help

I have this code on formWindowOpened

 try 


 jComboBox1.removeAllItems();

 jComboBox2.removeAllItems();

 ArrayList<Cliente> lista_cliente = new ArrayList<Cliente>();

 ArrayList<Motorista> lista_motorista = new ArrayList<Motorista>();

 Manipular_BD bd = new Manipular_BD();

 bd.registarDrive();

 bd.efetuarLigacao();

 lista_cliente = bd.listarCliente();

 lista_motorista = bd.listarMotorista();

 for (int i = 0; i < bd.listarCliente().size(); i++) 

 jComboBox1.addItem(String.valueOf(lista_cliente.get(i).getId_cliente()
 + " - " + lista_cliente.get(i).getNomeCliente()));
 

 for (int i = 0; i < bd.listarMotorista().size(); i++) 

jComboBox2.addItem(String.valueOf(lista_motorista.get(i).getId_motorista() 
+ " - " + lista_motorista.get(i).getNomeMotorista()));
 

bd.fecharLigacao();

 catch (SQLException ex) 
 Logger.getLogger(ListarCliente.class.getName()).log(Level.SEVERE, null, ex);
 

And I have this code in my button to connect the client with the driver, I am not sure but I think the error might be here

 Manipular_BD bd = new Manipular_BD();
 bd.registarDrive();
 bd.efetuarLigacao();
 bd.reservar(String.valueOf(jComboBox1.getSelectedItem().toString()), 
 String.valueOf(jComboBox2.getSelectedItem().toString()));
 JOptionPane.showMessageDialog(null, "Reservado com sucesso"); 

 bd.fecharLigacao();

java netbeans truncated

share|improve this question

asked Mar 24 at 15:41

AllyAlly

11

 try 


 jComboBox1.removeAllItems();

 jComboBox2.removeAllItems();

 ArrayList<Cliente> lista_cliente = new ArrayList<Cliente>();

 ArrayList<Motorista> lista_motorista = new ArrayList<Motorista>();

 Manipular_BD bd = new Manipular_BD();

 bd.registarDrive();

 bd.efetuarLigacao();

 lista_cliente = bd.listarCliente();

 lista_motorista = bd.listarMotorista();

 for (int i = 0; i < bd.listarCliente().size(); i++) 

 jComboBox1.addItem(String.valueOf(lista_cliente.get(i).getId_cliente()
 + " - " + lista_cliente.get(i).getNomeCliente()));
 

 for (int i = 0; i < bd.listarMotorista().size(); i++) 

jComboBox2.addItem(String.valueOf(lista_motorista.get(i).getId_motorista() 
+ " - " + lista_motorista.get(i).getNomeMotorista()));
 

bd.fecharLigacao();

 catch (SQLException ex) 
 Logger.getLogger(ListarCliente.class.getName()).log(Level.SEVERE, null, ex);
 

 Manipular_BD bd = new Manipular_BD();
 bd.registarDrive();
 bd.efetuarLigacao();
 bd.reservar(String.valueOf(jComboBox1.getSelectedItem().toString()), 
 String.valueOf(jComboBox2.getSelectedItem().toString()));
 JOptionPane.showMessageDialog(null, "Reservado com sucesso"); 

 bd.fecharLigacao();

share|improve this question

asked Mar 24 at 15:41

AllyAlly

11

share|improve this question

asked Mar 24 at 15:41

AllyAlly

11

asked Mar 24 at 15:41

AllyAlly

11

asked Mar 24 at 15:41

AllyAlly

11