Guest User

Untitled

a guest
May 4th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.79 KB | None | 0 0
  1. java.sql.SQLException: java.sql.SQLException: Illegal hour value '58' for java.sql.Time type in value '58:13:01.
  2. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
  3. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
  4. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
  5. at com.mysql.jdbc.ResultSetRow.getTimeFast(ResultSetRow.java:970)
  6. at com.mysql.jdbc.ByteArrayRow.getTimeFast(ByteArrayRow.java:223)
  7. at com.mysql.jdbc.ResultSetImpl.getTimeInternal(ResultSetImpl.java:5926)
  8. at com.mysql.jdbc.ResultSetImpl.getTime(ResultSetImpl.java:5662)
  9. at com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4898)
  10. at Gerencia_Proyectos.frmIndicadores.jButton1MouseClicked(frmIndicadores.java:116)
  11. at Gerencia_Proyectos.frmIndicadores.access$000(frmIndicadores.java:23)
  12. at Gerencia_Proyectos.frmIndicadores$1.mouseClicked(frmIndicadores.java:64)
  13. at java.awt.AWTEventMulticaster.mouseClicked(AWTEventMulticaster.java:270)
  14. at java.awt.Component.processMouseEvent(Component.java:6536)
  15. at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
  16. at java.awt.Component.processEvent(Component.java:6298)
  17. at java.awt.Container.processEvent(Container.java:2236)
  18. at java.awt.Component.dispatchEventImpl(Component.java:4889)
  19. at java.awt.Container.dispatchEventImpl(Container.java:2294)
  20. at java.awt.Component.dispatchEvent(Component.java:4711)
  21. at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
  22. at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4534)
  23. at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
  24. at java.awt.Container.dispatchEventImpl(Container.java:2280)
  25. at java.awt.Window.dispatchEventImpl(Window.java:2746)
  26. at java.awt.Component.dispatchEvent(Component.java:4711)
  27. at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
  28. at java.awt.EventQueue.access$500(EventQueue.java:97)
  29. at java.awt.EventQueue$3.run(EventQueue.java:709)
  30. at java.awt.EventQueue$3.run(EventQueue.java:703)
  31. at java.security.AccessController.doPrivileged(Native Method)
  32. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
  33. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
  34. at java.awt.EventQueue$4.run(EventQueue.java:731)
  35. at java.awt.EventQueue$4.run(EventQueue.java:729)
  36. at java.security.AccessController.doPrivileged(Native Method)
  37. at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
  38. at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
  39. at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
  40. at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
  41. at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
  42. at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
  43. at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
  44. at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
  45.  
  46. ry {
  47. Class.forName("com.mysql.jdbc.Driver");
  48.  
  49. Connection conexion = DriverManager.getConnection("jdbc:mysql://192.168.0.14:3306/bd_requerimiento", "root", "SistemasDaca");
  50. Statement st = conexion.createStatement();
  51. ResultSet rst = st.executeQuery(" select sec_to_time(TIMESTAMPDIFF(second,r.fecha_envio_rq,a.fecha_aprobacion)) as 'Tiempo demorado entre fecha de envio y autorizacion',sec_to_time(TIMESTAMPDIFF(second,a.fecha_aprobacion,vba.fecha_aprobacion)) as 'Tiempo demorado entre fecha de autorizacion y almacén',sec_to_time(TIMESTAMPDIFF(second,vba.fecha_aprobacion,vbl.fecha_aprobacion)) as 'Tiempo demorado entre fecha de almacén y logística',sec_to_time(TIMESTAMPDIFF(second,vbl.fecha_aprobacion,vbo.fecha_aprobacion)) as 'Tiempo demorado entre fecha de logística y obra',sec_to_time(TIMESTAMPDIFF(second,r.fecha_envio_rq,vbo.fecha_aprobacion)) as 'Tiempo total demorado' from requerimiento r join autorizacion a on r.cod_rq=a.cod_rq join vb_almacen vba on r.cod_rq=vba.cod_rq join vb_logistica vbl on r.cod_rq=vbl.cod_rq join vb_obra vbo on r.cod_rq=vbo.cod_rq where r.cod_rq ="+txtcod_rq.getText()+ "");
  52. ResultSetMetaData rsmt = rst.getMetaData();
  53. int nrocolumnas = rsmt.getColumnCount();
  54. DefaultTableModel modelo = new DefaultTableModel();
  55. this.tablaindicadores.setModel(modelo);
  56. for (int x = 1; x <= nrocolumnas; x++) {
  57. modelo.addColumn(rsmt.getColumnLabel(x));
  58.  
  59. }
  60.  
  61. while (rst.next()) {
  62. Object[] fila = new Object[nrocolumnas];
  63.  
  64. for (int y = 0; y < nrocolumnas; y++) {
  65. fila[y] = rst.getObject(y + 1);
  66.  
  67. }
  68.  
  69. modelo.addRow(fila);
  70.  
  71. }
  72.  
  73. } catch (ClassNotFoundException ce) {
  74. ce.printStackTrace();
  75. } catch (SQLException se) {
  76.  
  77. se.printStackTrace();
  78. }
Add Comment
Please, Sign In to add comment