zawieszanie programu w trakcie wykonywania akcji przycisku

0

Cześć, proszę o pomoc i przejrzenie poniższego kodu. Jestem początkujący. Proszę o opinie i uwagi co waszym zdaniem jest do poprawy oraz jak mogę naprawić bład, który dzieje sie podczas działania programu.
Gdy wykonuje akcję naciśniecia (zawsze gdy trzeci raz chce ją wykonać) przycisku TechnicalNote.bFinalChoose , to zawiesza mi program. Dokładnie w tym miejscu wykona changePriority(), a changeDate_A juz nie

try {
	    			  	changeStatus();
	    		  		changePriority();
	    		  		changeDate_A();
	    		  } catch (TorqueException ex1) {
	    		  		ex1.printStackTrace();
	    		  }

Cały kod klasy:

public class TechnicalNoteController implements SelectionListener {
	
	private TechnicalNote technicalNote;
	private EditorHostInterface editor;
	private TechnicalNoteRead technicalread;
	private TechnicalNoteUpdateButton technicalNoteUpdateButton;
	PagesControl pagesControl;
	Ticket ticket;
	IProgressMonitor monitor;
	
	Shell parent = new Shell();
	
	private long ts_id = 0;
	private String takenserial;
	private long t_id = 0;
	private long pi_id = 0;
	private long date;
	
	TechnicalNoteController (TechnicalNote technicalNote) {
		this.technicalNote = technicalNote;
		this.editor = technicalNote.editor;
		
		hookListeners();
	
		TechnicalNote.rbNecessary.addSelectionListener(this);
		TechnicalNote.rbRecommended.addSelectionListener(this);
		TechnicalNote.rbAccessories.addSelectionListener(this);
		TechnicalNote.rbMechanical.addSelectionListener(this);
		TechnicalNote.rbUsed.addSelectionListener(this);
		TechnicalNote.rbPolish.addSelectionListener(this);
		TechnicalNote.rbEnglish.addSelectionListener(this);
		TechnicalNote.rbDevice.addSelectionListener(this);
		TechnicalNote.rbPrinter.addSelectionListener(this);
		TechnicalNote.rbOther.addSelectionListener(this);
	
		
		
		TechnicalNote.bChoose.addListener(SWT.Selection, new Listener(){
			 public void handleEvent(Event e) {
		          switch (e.type) {
		          case SWT.Selection:
		        	if (TechnicalNote.rbNecessary.getSelection()){  
		        			PagesControl.taNecessary.append("\n"+getElement()+" "+ getDescription()); //$NON-NLS-1$ //$NON-NLS-2$
		        		}
		        	if (TechnicalNote.rbRecommended.getSelection()){  
		        			PagesControl.taRecommended.append("\n"+getElement()+" "+ getDescription()); //$NON-NLS-1$ //$NON-NLS-2$
			        	}
		        	if (TechnicalNote.rbAccessories.getSelection()){  
		        			PagesControl.taAccessories.append("\n"+getElement()+" "+ getDescription()); //$NON-NLS-1$ //$NON-NLS-2$
			        	}
		            break;
		          }
		        }
		});
		
		
		
		TechnicalNote.bFinalChoose.addListener(SWT.Selection, new Listener(){
	      public void handleEvent(Event e) {
	    	  
	    	  getTicketId();
	    	  saveTicket();
	    	  
	    	  if (TechnicalNote.rbPolish.getSelection() || TechnicalNote.rbEnglish.getSelection()){
	    	  MessageBox messageBox = new MessageBox (parent, SWT.YES | SWT.NO);   //działa trzeba bylo shell nowy dodac
	    	  messageBox.setText("Czy napewno zatwierdzić?"); //$NON-NLS-1$
	    	  messageBox.setMessage("Zgłoszenie: "+ PagesControl.ticketNo.getText() +"\n" + "Numer seryjny: "+ takenserial); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
	    	  int buttonID = messageBox.open();
	    	  switch(buttonID){
	    	  case SWT.YES:
	    		  
	    		  try {
	    			  	changeStatus();
	    		  		changePriority();
	    		  		changeDate_A();
	    		  } catch (TorqueException ex1) {
	    		  		ex1.printStackTrace();
	    		  }
				
	    		  refreshTicket();
	    		  	
	    		  PagesControl.taAllDescription.append(getFinal());
	    		  
	    		  saveTicket();
	    		  
	    		  try {
	    			  technicalNoteUpdateButton = new TechnicalNoteUpdateButton();
	    		  } catch (TorqueException ex) {
	    			  ex.printStackTrace();
	    		  } catch (SQLException ex) {
	    			  ex.printStackTrace();
	    		  }
	    		  
	    		  //refreshProductNote();
	    		  break;
	    		  
	    	  case SWT.NO:
	    		  //cancel
	    		 
	    		  break;
	    	  }
				
	    	  }
	      }
	});
		
	}
	
	
	public void changeStatus() throws TorqueException{
		
		String ccc = PagesControl.ticketNo.getText();
   	  	Criteria crit = new Criteria();
   	  	crit.add(TicketPeer.TICKET_NO, ccc);
   	  
   	  	try {
   	  		List<Ticket> list = TicketPeer.doSelect(crit);
			
			if(list.size()>0){
				t_id = list.get(0).getId();
				
			}
   	  	} catch (TorqueException ex) {
			ex.printStackTrace();
		}
		
		Connection conn = Torque.getConnection();
		
		try{
		Statement st = conn.createStatement();
		boolean rs = st.execute("UPDATE ticket SET status='1'" + "WHERE id='"+ t_id +"'"); //$NON-NLS-2$ //$NON-NLS-3$
		
		st.close();
		}catch (Exception e) {
            e.printStackTrace();
		}
	}
	
	public void changePriority() throws TorqueException{

		Connection conn = Torque.getConnection();
	
		try{
			Statement st = conn.createStatement();
			boolean rs = st.execute("UPDATE ticket SET priority='0'" + "WHERE id='"+ t_id +"'");  //$NON-NLS-1$//$NON-NLS-2$ //$NON-NLS-3$
	
			st.close();
		}catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public void changeDate_A() throws TorqueException{
		
		long chDate = sp.common.util.Ut.setToday(date);
		
		Connection conn = Torque.getConnection();
		
		try{
			Statement st = conn.createStatement();
			boolean rs = st.execute("UPDATE ticket SET _A='"+ chDate +"'" + "WHERE id='"+ t_id +"'"); //$NON-NLS-2$ //$NON-NLS-3$
	
			st.close();
		}catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	public void refreshTicket(){
		
		if(TicketEditor.editorInstance !=null){
			TicketEditor.editorInstance.refresh();
		}
	    
	}
	
	public void saveTicket(){
		
		if(TicketEditor.editorInstance !=null){
			TicketEditor.editorInstance.doSave(monitor);
		}
	}

	
	
	public void getTicketId(){
		String sss = PagesControl.ticketNo.getText();
		
   	  	Criteria crit1 = new Criteria();
   	  	crit1.add(TicketPeer.TICKET_NO, sss);
   	  
   	  	try {
   	  		List<Ticket> list1 = TicketPeer.doSelect(crit1);
			
			if(list1.size()>0){
				ts_id = list1.get(0).getId();
				
			}
   	  	} catch (TorqueException ex) {
			ex.printStackTrace();
		}
   	  	getProdInstId();
	}
	
	public void getProdInstId(){
		
		Criteria crit2 = new Criteria();
   	  	crit2.add(TicketProdInstPeer.TICKET_ID, ts_id);
   	  
   	  	try {
   	  		List<TicketProdInst> list2 = TicketProdInstPeer.doSelect(crit2);
			
			if(list2.size()>0){
				pi_id = list2.get(0).getProdInstId();
				
			}
   	  	} catch (TorqueException ex) {
			ex.printStackTrace();
		}
		getSerialNumberIdSerial();
	}
	
	public void getSerialNumberIdSerial(){
		Criteria crit3 = new Criteria();
		crit3.add(ProdInstPeer.ID, pi_id);
		try{
			List<ProdInst>list3 = ProdInstPeer.doSelect(crit3);
		
			if(list3.size()>0){
				takenserial = list3.get(0).getSerialNo();
			}
		
			}catch (TorqueException ex) {
				ex.printStackTrace();
			}
	}
	
	@Override
	public void widgetSelected(SelectionEvent e) {
		
		try {
			technicalread = new TechnicalNoteRead(this);
		} catch (IOException ex) {
			ex.printStackTrace();
		}
		
	// Device choose start	
		if (TechnicalNote.rbDevice.getSelection() && TechnicalNote.rbNecessary.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyDeviceNecessaryPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyDeviceMechanicalPL());
		}
		
		if (TechnicalNote.rbDevice.getSelection() && TechnicalNote.rbRecommended.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyDeviceRecommendedPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyDeviceMechanicalPL());
		}
			
		if (TechnicalNote.rbDevice.getSelection() && TechnicalNote.rbAccessories.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyDeviceAccessoriesPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyDeviceMechanicalPL());
		}
			
		if (TechnicalNote.rbDevice.getSelection() && TechnicalNote.rbNecessary.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyDeviceNecessaryEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyDeviceMechanicalEN());
		}
			
		if (TechnicalNote.rbDevice.getSelection() && TechnicalNote.rbRecommended.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyDeviceRecommendedEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyDeviceMechanicalEN());
		}
			
		if (TechnicalNote.rbDevice.getSelection() && TechnicalNote.rbAccessories.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyDeviceAccessoriesEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyDeviceMechanicalEN());
		}
			
		if (TechnicalNote.rbDevice.getSelection() && TechnicalNote.rbNecessary.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyDeviceNecessaryPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyDeviceUsedPL());
		}
			
		if (TechnicalNote.rbDevice.getSelection() && TechnicalNote.rbRecommended.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyDeviceRecommendedPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyDeviceUsedPL());
		}
			
		if (TechnicalNote.rbDevice.getSelection() && TechnicalNote.rbAccessories.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyDeviceAccessoriesPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyDeviceUsedPL());
		}
			
		if (TechnicalNote.rbDevice.getSelection() && TechnicalNote.rbNecessary.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyDeviceNecessaryEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyDeviceUsedEN());
		}
			
		if (TechnicalNote.rbDevice.getSelection() && TechnicalNote.rbRecommended.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyDeviceRecommendedEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyDeviceUsedEN());
		}
			
		if (TechnicalNote.rbDevice.getSelection() && TechnicalNote.rbAccessories.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyDeviceAccessoriesEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyDeviceUsedEN());
		}
	//Device choose end
		
	// Printer choose start	
		if (TechnicalNote.rbPrinter.getSelection() && TechnicalNote.rbNecessary.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyPrinterNecessaryPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyPrinterMechanicalPL());
		}
		
		if (TechnicalNote.rbPrinter.getSelection() && TechnicalNote.rbRecommended.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyPrinterRecommendedPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyPrinterMechanicalPL());
		}
			
		if (TechnicalNote.rbPrinter.getSelection() && TechnicalNote.rbAccessories.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyPrinterAccessoriesPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyPrinterMechanicalPL());
		}
			
		if (TechnicalNote.rbPrinter.getSelection() && TechnicalNote.rbNecessary.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyPrinterNecessaryEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyPrinterMechanicalEN());
		}
			
		if (TechnicalNote.rbPrinter.getSelection() && TechnicalNote.rbRecommended.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyPrinterRecommendedEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyPrinterMechanicalEN());
		}
			
		if (TechnicalNote.rbPrinter.getSelection() && TechnicalNote.rbAccessories.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyPrinterAccessoriesEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyPrinterMechanicalEN());
		}
			
		if (TechnicalNote.rbPrinter.getSelection() && TechnicalNote.rbNecessary.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyPrinterNecessaryPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyPrinterUsedPL());
		}
			
		if (TechnicalNote.rbPrinter.getSelection() && TechnicalNote.rbRecommended.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyPrinterRecommendedPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyPrinterUsedPL());
		}
			
		if (TechnicalNote.rbPrinter.getSelection() && TechnicalNote.rbAccessories.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyPrinterAccessoriesPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyPrinterUsedPL());
		}
			
		if (TechnicalNote.rbPrinter.getSelection() && TechnicalNote.rbNecessary.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyPrinterNecessaryEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyPrinterUsedEN());
		}
			
		if (TechnicalNote.rbPrinter.getSelection() && TechnicalNote.rbRecommended.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyPrinterRecommendedEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyPrinterUsedEN());
		}
			
		if (TechnicalNote.rbPrinter.getSelection() && TechnicalNote.rbAccessories.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyPrinterAccessoriesEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyPrinterUsedEN());
		}
	//Printer choose end
		
	// Other choose start	
		if (TechnicalNote.rbOther.getSelection() && TechnicalNote.rbNecessary.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyOtherNecessaryPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyOtherMechanicalPL());
		}
		
		if (TechnicalNote.rbOther.getSelection() && TechnicalNote.rbRecommended.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyOtherRecommendedPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyOtherMechanicalPL());
		}
			
		if (TechnicalNote.rbOther.getSelection() && TechnicalNote.rbAccessories.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyOtherAccessoriesPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyOtherMechanicalPL());
		}
			
		if (TechnicalNote.rbOther.getSelection() && TechnicalNote.rbNecessary.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyOtherNecessaryEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyOtherMechanicalEN());
		}
			
		if (TechnicalNote.rbOther.getSelection() && TechnicalNote.rbRecommended.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyOtherRecommendedEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyOtherMechanicalEN());
		}
			
		if (TechnicalNote.rbOther.getSelection() && TechnicalNote.rbAccessories.getSelection() && TechnicalNote.rbMechanical.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyOtherAccessoriesEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyOtherMechanicalEN());
		}
			
		if (TechnicalNote.rbOther.getSelection() && TechnicalNote.rbNecessary.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyOtherNecessaryPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyOtherUsedPL());
		}
			
		if (TechnicalNote.rbOther.getSelection() && TechnicalNote.rbRecommended.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyOtherRecommendedPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyOtherUsedPL());
		}
			
		if (TechnicalNote.rbOther.getSelection() && TechnicalNote.rbAccessories.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbPolish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyOtherAccessoriesPL());
			TechnicalNote.cbDescription.setItems(technicalread.getMyOtherUsedPL());
		}
			
		if (TechnicalNote.rbOther.getSelection() && TechnicalNote.rbNecessary.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyOtherNecessaryEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyOtherUsedEN());
		}
			
		if (TechnicalNote.rbOther.getSelection() && TechnicalNote.rbRecommended.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyOtherRecommendedEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyOtherUsedEN());
		}
			
		if (TechnicalNote.rbOther.getSelection() && TechnicalNote.rbAccessories.getSelection() && TechnicalNote.rbUsed.getSelection() && TechnicalNote.rbEnglish.getSelection())
		{
			TechnicalNote.cbElement.setItems(technicalread.getMyOtherAccessoriesEN());
			TechnicalNote.cbDescription.setItems(technicalread.getMyOtherUsedEN());
		}
	//Other choose end
		
	}

	
	@Override
	public void widgetDefaultSelected(SelectionEvent e) {
	}
	
	protected String getElement()
	{
		return TechnicalNote.cbElement.getText();
	}
	
	protected String getDescription()
	{
		return TechnicalNote.cbDescription.getText();
	}
	
	protected String getOthers(){
		if (TechnicalNote.cBattery.getSelection() && TechnicalNote.rbPolish.getSelection())
			return "Bateria: Tak"; //$NON-NLS-1$
		if (TechnicalNote.cBattery.getSelection() && TechnicalNote.rbEnglish.getSelection())
			return "Battery: yes"; //$NON-NLS-1$
		return ""; //$NON-NLS-1$
	}
	protected String getOthers1(){
		if (TechnicalNote.cStylus.getSelection() && TechnicalNote.rbPolish.getSelection())
			return "Rysik: Tak"; //$NON-NLS-1$
		if (TechnicalNote.cStylus.getSelection() && TechnicalNote.rbEnglish.getSelection())
			return "Stylus: yes"; //$NON-NLS-1$
		return ""; //$NON-NLS-1$
	}
	protected String getOthers2(){
		if (TechnicalNote.cSealOK.getSelection() && TechnicalNote.rbPolish.getSelection())
			return "Plomby Weilandt Elektronik: ok"; //$NON-NLS-1$
		if (TechnicalNote.cSealOK.getSelection() && TechnicalNote.rbEnglish.getSelection())
			return "Seal Weilandt Elektronik: ok"; //$NON-NLS-1$
		return ""; //$NON-NLS-1$
	}
	protected String getOthers3(){
		if (TechnicalNote.cSealNOT.getSelection() && TechnicalNote.rbPolish.getSelection())
			return "Plomby Weilandt Elektronik: uszkodzone/brak"; //$NON-NLS-1$
		if (TechnicalNote.cSealNOT.getSelection() && TechnicalNote.rbEnglish.getSelection())
			return "Seal Weilandt Elektronik: damaged/missing"; //$NON-NLS-1$
		return ""; //$NON-NLS-1$
	}
	
	
	@SuppressWarnings("nls")
	protected String getFinal() {
		if (TechnicalNote.rbPolish.getSelection())
			return ("+++Naprawy niezbedne:"+"\n"+ PagesControl.taNecessary.getText()+"\n"+"\n"+ "+++Naprawy zalecane:"+"\n"+
					PagesControl.taRecommended.getText()+"\n"+"\n"+ "+++Akcesoria:"+"\n"+ PagesControl.taAccessories.getText()+"\n"+ "\n"+
					"+++Uwagi:"+"\n"+"Gwarancja tylko na wymienione części!"+"\n"+ PagesControl.cautions.getText()+"\n"+"\n"+ getOthers()+"\n"+ getOthers1()+"\n"+
					getOthers2()+"\n"+ getOthers3()+"\n"+ "System operacyjny: "+ 
					PagesControl.cbDeviceSystem.getText()+"\n"+ "Model lasera: "+PagesControl.cbLaserModel.getText()+"\n"+ 
					"Technik: "+PagesControl.cbEngineer.getText());
		
		if (TechnicalNote.rbEnglish.getSelection())
			return ("+++Necessary repairs:"+"\n"+ PagesControl.taNecessary.getText()+"\n"+ "\n"+ "+++Recommended repairs:"+"\n"+ 
					PagesControl.taRecommended.getText()+"\n"+ "\n"+ "+++Accessories to buy:"+"\n"+ PagesControl.taAccessories.getText()+
					"\n"+ "\n"+ "+++Cautions:"+"\n"+"Warranty only for exchanged spare parts!"+"\n"+ PagesControl.cautions.getText()+"\n"+"\n"+ getOthers()+"\n"+ getOthers1()+"\n"+
					getOthers2()+"\n"+ getOthers3()+"\n"+ "Device System: "+ 
					PagesControl.cbDeviceSystem.getText()+"\n"+ "Scan engine model: "+ PagesControl.cbLaserModel.getText()+"\n"+ 
					"Technican: "+PagesControl.cbEngineer.getText());
		
		return "";
		
	}
	
	
	private void hookListeners() {
		
	}

	
	public void dispose() {
	
	}

}
1
  1. Spawnujesz nowy wątek / submitujesz do jakiegś executora / odpalasz przez completable future w jakimś fork join poolu (domyślnym lub nie)
  2. Kod tragiczny, 90% to bezmyślny copypaste.
0

Pomijając tragedię tego kodu to wydaje mi się, że masz autoCommit false i deadlockują Ci się transakcje (dostajesz różne połączenia z puli i niescommitowane statementy na nich wiszą)
Żeby to sprawdzić dodaj po kazdym st.execute linijkę Transaction.commit(conn);.

0

Dzieki za pomoc:)
@jarekr000000 teraz działa jak należy.
Macie racje co do kodu, ale małymi kroczkami do przodu. Dopiero się uczę, a to było zrobione żeby dodać nowe funkcje do istniejącego programu.
Z czasem, mam nadzieję, że bedę pisał kod zgodny z zasadami i czytelny. Jeszcze raz dzięki!

1 użytkowników online, w tym zalogowanych: 0, gości: 1