Alta eroare baze de date 4.1b

[dfreddie]

Am facut update la Castor si ReportEnginen, update la bazele de date (4.1.0 erau bifate cu verde) ... si tot imi da eroare cand vreau sa ma log-ez.!
Va rog frumos ajutati-ma!!


java.lang.NumberFormatException: For input string: "Eroare logare!!"
   at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
   at java.lang.Integer.parseInt(Integer.java:481)
   at java.lang.Integer.<init>(Integer.java:636)
   at mirabit.gest.util.HelperPass.makeConn(HelperPass.java:262)
   at org.apache.jsp.AdmWebgestControl_jsp._jspService(AdmWebgestControl_jsp.java:406)
   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
   at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
   at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
   at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
   at java.lang.Thread.run(Thread.java:679)
JSP(/webgest/AdmWebgestControl.jsp)  ----vers app:4.1.0beta
JSP(/webgest/AdmWebgestControl.jsp)------nu exista a000wginfo
JSP(/webgest/AdmWebgestControl.jsp)------versap:4.1--versdb:
java.lang.NumberFormatException: For input string: "eroare"
   at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
   at java.lang.Integer.parseInt(Integer.java:481)
   at java.lang.Integer.<init>(Integer.java:636)
   at org.apache.jsp.AdmWebgestControl_jsp._jspService(AdmWebgestControl_jsp.java:437)
   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
   at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
   at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
   at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
   at java.lang.Thread.run(Thread.java:679)
JSP(/webgest/WebgestLogin.jsp)------Load page cu log:notok
JSP(/webgest/AdmWebgestControl.jsp) --Load page cu op:login
JSP(/webgest/AdmWebgestControl.jsp)  ----begin login la webgest  webgest-----2011-10-15  16:56:08 --ip:10.0.0.101
JSP(/webgest/AdmWgListFirme.jsp)  -----Load page
JSP(/webgest/WGStat.jsp)  -Load page...
JSP(/webgest/WGStat.jsp)  --logvis:true
JSP(/webgest/WGStat.jsp)  begin inreg ip:10.0.0.101
JSP(null)  --Load page
JSP(/webgest/AdmWgListFirme.jsp)  -----Load page
JSP(/webgest/WGStat.jsp)  -Load page...
JSP(/webgest/WGStat.jsp)  --logvis:true
JSP(/webgest/WGStat.jsp)  begin inreg ip:10.0.0.101
JSP(/webgest/WebgestLogin.jsp)------Load page cu log:null
JSP(/webgest/Setup.jsp)------Load page cu op: null
JSP(/webgest/Setup.jsp)------Load page cu op: login
JSP(/webgest/Setup.jsp)------Load page cu op: setparam
JSP(/webgest/Setup.jsp)------Load page cu op: setparam
JSP(/webgest/WebgestLogin.jsp)------Load page cu log:null
JSP(/webgest/AdmWebgestControl.jsp) --Load page cu op:login
JSP(/webgest/AdmWebgestControl.jsp)  ----begin login la webgest  admin-----2011-10-15  16:57:20 --ip:10.0.0.101
java.sql.SQLException: com.mysql.jdbc.Driver
   at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:243)
   at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:176)
   at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:659)
   at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:601)
   at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:464)
   at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:130)
   at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:112)
   at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:99)
   at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:123)
   at mirabit.gest.util.HelperPass.getConnRedir(HelperPass.java:151)
   at mirabit.gest.util.HelperPass.makeConn(HelperPass.java:259)
   at org.apache.jsp.AdmWebgestControl_jsp._jspService(AdmWebgestControl_jsp.java:406)
   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
   at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
   at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
   at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:300)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
   at java.lang.Thread.run(Thread.java:679)
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
   at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
   at java.security.AccessController.doPrivileged(Native Method)
   at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
   at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
   at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
   at java.lang.Class.forName0(Native Method)
   at java.lang.Class.forName(Class.java:264)
   at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:236)
   ... 33 more
java.lang.NumberFormatException: For input string: "Eroare logare!!"
   at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
   at java.lang.Integer.parseInt(Integer.java:481)
   at java.lang.Integer.<init>(Integer.java:636)
   at mirabit.gest.util.HelperPass.makeConn(HelperPass.java:262)
   at org.apache.jsp.AdmWebgestControl_jsp._jspService(AdmWebgestControl_jsp.java:406)
   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
   at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
   at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
   at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:300)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
   at java.lang.Thread.run(Thread.java:679)
JSP(/webgest/AdmWebgestControl.jsp)  ----vers app:4.1.0beta
JSP(/webgest/AdmWebgestControl.jsp)------nu exista a000wginfo
JSP(/webgest/AdmWebgestControl.jsp)------versap:4.1--versdb:
java.lang.NumberFormatException: For input string: "eroare"
   at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
   at java.lang.Integer.parseInt(Integer.java:481)
   at java.lang.Integer.<init>(Integer.java:636)
   at org.apache.jsp.AdmWebgestControl_jsp._jspService(AdmWebgestControl_jsp.java:437)
   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
   at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
   at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:185)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:151)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:269)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515)
   at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:300)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
   at java.lang.Thread.run(Thread.java:679)
JSP(/webgest/WebgestLogin.jsp)------Load page cu log:notok

[dfreddie]

Eroarea este: Eroare conexiune jdbc la baza de date!

[vios]

 Si eu  am facut update la bazele de date (4.1.0 erau bifate cu verde) ,
si imi da eroare cand vreau sa ma log-ez !
root cause

javax.servlet.ServletException: java.lang.NoClassDefFoundError: org/apache/tomcat/jdbc/pool/PoolConfiguration
   org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
   org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
   org.apache.jsp.AdmWebgestControl_jsp._jspService(AdmWebgestControl_jsp.java:4404)
   org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
   org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
   org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

Se pare ca avem aceeasi erroare :

java.lang.NoClassDefFoundError: org/apache/tomcat/jdbc/pool/PoolConfiguration

[vios]

Ce Tomcat folosesti ?
Eu am Tomcat 6.0.26 , si cred ca probele au fost facute pe Tomcat 7
La tine se poate ca ar fi ceva problema cu jdbc.Drivers :

java.sql.SQLException: com.mysql.jdbc.Driver

[dfreddie]

Tomcat 7.0.21 si apoi 7.0.22 (ultimul).
Eu am mai facut update si la mysql-connector ... fara rezultate.

[vios]

 Am instalat si eu Tomcat 7.0.22 in afara sistemului, si acum ma pot loga ca si admin
vad toate firmele la logare insa dupa ce aleg una imi da erroare :
Versiunea bazei de date  este incompatibila cu cea a aplicatiei 4.1 !!!
( desi am rulat update la toate firmele inainte )

 Daca incerc sa ma loghez ca si user eoarea este ca si la tine :
Eroare conexiune jdbc la baza de date!
Ce versiune de mysql_connector ai ?
La mine e  - mysql_connector_java_5.0.4
Pot sa ma loghez ca si superadmin  si imi permite sa schimb si parola.

[dfreddie]

5.1.18 ... cred ca ultimul.

[elis]

Din greșeală am pus un war intermediar la download. Îmi cer scuze pentru neplăcerile provocate! Încercați cu download-ul de azi.

[vios]

Da asta era problema !
Am pus war-ul nou, am refacut datele la versiunea 4.0,
am rulat inca o data update date la versiunea 4.1 si
acum functioneaza normal.
Din probele facute pana acum nu au aparut probleme.

[dfreddie]

Acum si la mine e totul OK. Multumesc frumos!!!