DB Error + NullPointerException

[Daniel569]

Hallo,

wenn ich versuche in meinen Programm Daten in einer DB zu speichern, erhalte ich folgende Fehlermeldungen und Exceptions:

INFO - exporting generated schema to database
ERROR - Unsuccessful: create table Mitarbeiter (id integer generated by default as identity (start with 1), name varchar(255), vorname varchar(255), position varchar(255), stundensatz varchar(255), primary key (id))
ERROR - Unexpected token: POSITION in statement [create table Mitarbeiter (id integer generated by default as identity (start with 1), name varchar(255), vorname varchar(255), position]
INFO - schema export complete

Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at gui.MErfassungView.actionPerformed(MErfassungView.java:223)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Folgender Programmcode dazu:


Klasse1

public void actionPerformed (ActionEvent e){
		if (e.getSource() == saveBtn) { 						
			Transaction trx  = null;
			Session session = HibernateUtil.getSessionFactory().openSession();
			try {			
			Transaction tx = session.beginTransaction();			
			Mitarbeiter ma = new Mitarbeiter();
			ma.setName(nachName.getText());
			ma.setVorname(vorName.getText());
	        ma.setPosition(posSelection.getText());	       
			ma.setStundensatz(stundenSatz.getText());
			session.save(ma);		    
	        tx.commit();
	        HibernateUtil.shutdown(); }
			catch( HibernateException ex ) {
			      if( trx != null )
			        try { trx.rollback(); } catch( HibernateException exRb ) {}
			      throw new RuntimeException( ex.getMessage() );
			    } finally {
			      try { if( session != null ) session.close(); } catch( Exception exCl ) {}
			    }
	        
			nachName.setEditable(false);
			vorName.setEditable(false);
			position.setEnabled(false);
			stundenSatz.setEditable(false);	
			System.out.println("Speichern"); } 
...

Klasse Mitarbeiter

package auftrag;

public class Mitarbeiter {
	  private int    _id;
	  private String _name;
	  private String _vorname;
	  private String _position;
	  private String _stundensatz;	

	  public int    getId()      	{ return _id; }
	  public String getName()    	{ return _name; }
	  public String getVorname()   	{ return _vorname; }
	  public String getPosition()   { return _position; }
	  public String getStundensatz(){ return _stundensatz; }	 

	  public void setId( int id ) { this._id = id; }
	  public void setName( String name ) { this._name = name; }
	  public void setVorname( String  vorname ) { this._vorname = vorname; }
	  public void setPosition( String position ) { this._position = position; }
	  public void setStundensatz( String stundensatz ) { this._stundensatz = stundensatz; }	  
	}

Was mach ich falsch? Habe schon stundenlang gesucht und alles Mögliche versucht, jedoch ohne Erfolg...

Danke schonmal,

Daniel

 

[SlaterB]

vielleicht ist position ein reserviertes KeyWord, probiere einen anderen Namen

 

[Daniel569]

Hey, vielen vielen dank. Genau das war es... die NullPointerException hatte noch ne andere Ursache, war dann aber auch kein problem mehr.

Nochmal Danke. Und ich hab wirklich gedacht, ich werd bescheuert... :wink: :wink: