Dear All
It is very urgent please......
I developed an application of a attendance system in Java and MySQL.
But I am facing the given problem.
When I get the attendance register of five employees it is working
fine and report is opened.
But when I send the command for more than five employees then I
receive the error like this
SQLException: Communications link failure due to underlying exception:
Because there are several queries are using with in while loop in my
application.
I saw our mysql server Key Efficiency hitrate reaching 100%, is there
any setting in Mysql to increase key_cache_size setting?
I am using the given
* winxp
* mysql-connector-java-5.0.3-bin.jar
* MySQL 5.0.18-nt-log via TCP/IP
* jdk1.7.0
Thanks in advance.
The error is given below.
SQLException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.BindException: Address already in use: connect
STACKTRACE:
java.net.SocketException: java.net.BindException: Address already in
use: connect
at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:
156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:
266)
at java.sql.DriverManager.getConnection(DriverManager.java:
579)
at java.sql.DriverManager.getConnection(DriverManager.java:
243)
at biopayroll.jdbcConnection.myStringGet(jdbcConnection.java:
258)
at
biopayroll.rep_emp_attendance_register.get_gh_holiday(rep_emp_attendance_register.java:
693)
at
biopayroll.rep_emp_attendance_register.jButton4ActionPerformed(rep_emp_attendance_register.java:
311)
at biopayroll.rep_emp_attendance_register.access
$300(rep_emp_attendance_register.java:33)
at biopayroll.rep_emp_attendance_register
$4.actionPerformed(rep_emp_attendance_register.java:250)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:
2018)
at javax.swing.AbstractButton
$Handler.actionPerformed(AbstractButton.java:2341)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:
402)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:
252)
at java.awt.Component.processMouseEvent(Component.java:6504)
at javax.swing.JComponent.processMouseEvent(JComponent.java:
3321)
at java.awt.Component.processEvent(Component.java:6269)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4860)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4686)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:
4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2713)
at java.awt.Component.dispatchEvent(Component.java:4686)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:707)
at java.awt.EventQueue.access$000(EventQueue.java:101)
at java.awt.EventQueue$3.run(EventQueue.java:666)
at java.awt.EventQueue$3.run(EventQueue.java:664)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain
$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain
$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:680)
at java.awt.EventQueue$4.run(EventQueue.java:678)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain
$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:677)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:
211)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:
128)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:
117)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:
90)
** END NESTED EXCEPTION **
--
You received this message because you are subscribed to the Google Groups
"JPassion.com: Java Programming" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/jpassion_java?hl=en.
