Exception

[Rose88]

here's the exception that I've received :

Exception in thread "AWT-EventQueue-0" java.util.MissingFormatArgumentException: Format specifier 's'
	at java.util.Formatter.format(Formatter.java:2432)
	at java.util.Formatter.format(Formatter.java:2367)
	at java.lang.String.format(String.java:2769)
	at DB.tblDoctor.addDoctor(tblDoctor.java:153)
	at logic.Doctor.insertDoctor(Doctor.java:13)
	at GUI.Mazkera.Dr.add_dr.add_dr_btActionPerformed(add_dr.java:252)
	at GUI.Mazkera.Dr.add_dr.access$0(add_dr.java:244)
	at GUI.Mazkera.Dr.add_dr$1.actionPerformed(add_dr.java:94)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
	at javax.swing.JToggleButton$ToggleButtonModel.setPressed(JToggleButton.java:291)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
	at java.awt.Component.processMouseEvent(Component.java:6263)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
	at java.awt.Component.processEvent(Component.java:6028)
	at java.awt.Container.processEvent(Container.java:2041)
	at java.awt.Component.dispatchEventImpl(Component.java:4630)
	at java.awt.Container.dispatchEventImpl(Container.java:2099)
	at java.awt.Component.dispatchEvent(Component.java:4460)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
	at java.awt.Container.dispatchEventImpl(Container.java:2085)
	at java.awt.Window.dispatchEventImpl(Window.java:2478)
	at java.awt.Component.dispatchEvent(Component.java:4460)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

here's the code where the Exception shows:

	public void addDoctor(){
		String msg=String.format("INSERT INTO tblDoctor" +
				"((LicenseNum,FirstName,surName,Specialization,StartWorkingDate)" 
	         	+" VALUES (%s,'%s','%s','%s','%s','%s')"
	         	,LicenseNum,FirstName,surName,Specialization,StartWorkingDate);
		try{
			DBconn.s.execute(msg);
		}
		catch(Exception e){
			System.out.print(e.getMessage());
		}
	}

I don't understand this Exception! can anyone help?

[PhHein]

Have a look at the examples in the Formatter API
Formatter (Java Platform SE 6)

[JosAH]

+" VALUES (%s,'%s','%s','%s','%s','%s')"
,LicenseNum,FirstName,surName,Specialization,Start WorkingDate);

Count your Strings; the format specifying String wants to see six of them.

kind regards,

Jos