Mais problemas Access + java [ muito urgente ]

2 respostas
G

e ae galera, blz?

To desesperadasso, preciso entregar o programa agora a tarde e tah dando um erro nada a ver aki.

Dá o seguinte erro do access:

“O atributo naum pode ser definido agora”

Alguém sabe o q eh e como resolver isso?

eh extremamente urgente, to desesperado :frowning:

2 Respostas

P

Coloca um trecho do código, se possível…

Imagino que vc esteja tentando inicializar uma variável de forma incorreta… Talvez uma variável não estática da classe dentro de um método estático… Mas explica melhor o contexto e o problema, senão não dá pra ajudar… :wink:

Abs

G

Olha q elucidativo :roll:

General error
java.sql.SQLException: General error
	at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)
	at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source)
	at Ocorrencias.DataAccess.novoContato(DataAccess.java:312)
	at Ocorrencias.Principal$SaveAction.actionPerformed(Principal.java:316)
	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.AWTEventMulticaster.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.pumpOneEventForHierarchy(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)

“General error”.

Ajuda mto na hora de debugar…

método para inserir os cadastros, onde está dando SQLException

public boolean novoContato ( Contato person, Ocorrencia ocor )
		throws DataAccessException
	{
		
		try {

			int result;
			
			String temp = person.getNome();
			
			StringTokenizer tokens = new StringTokenizer ( temp );

			String nome = "";

			while ( tokens.hasMoreTokens() )
				nome += tokens.nextToken();
			
			sqlInsertContato.setString ( 1, nome );
			sqlInsertContato.setString ( 2, person.getMail() );
			sqlInsertContato.setString ( 3, person.getExtraMails() );
			sqlInsertContato.setString ( 4, person.getTelRes() );
			sqlInsertContato.setString ( 5, person.getTelCom() );
			sqlInsertContato.setString ( 6, person.getTelCel() );
			sqlInsertContato.setString ( 7, person.getFax() );
			sqlInsertContato.setString ( 8, person.getExtraTels() );
			sqlInsertContato.setInt ( 9, person.getId() );
			
			result = sqlInsertContato.executeUpdate();
			
			
			if ( result == 0 ) {
				connection.rollback();
				return false;
			}
		
			sqlInsertOcorrencia.setString  ( 1, ocor.getOcorrencia() );
			sqlInsertOcorrencia.setInt ( 2, person.getId() );
			sqlInsertOcorrencia.setDate ( 3, ocor.getData() );
			
			result = sqlInsertOcorrencia.executeUpdate();
			
			if ( result == 0 ) {
				connection.rollback();
				return false;
			}
				
			connection.commit();
			return true;
			
		}
		
		
		catch ( SQLException sqle ) {
			System.err.println ( sqle.getMessage() );
			sqle.printStackTrace();
			
		}
		
	
		return false;
	}
Criado 11 de agosto de 2005
Ultima resposta 11 de ago. de 2005
Respostas 2
Participantes 2