Problema com table não existente

[renatosoares]

Bom dia amigos …

Primeiramente , eu estou usando um DAO Generico … tenho uma classe cliente, e a mesma esta funcionando corretamente. Para não dar problemas , eu copiei a classe cliente , e apenas substitui os atributos da classe, salvando como classe EMPRESA.

Abaixo, a classe Empresa.[color=darkblue] [/color]
[color=darkblue]@Entity
@Table(name = “EMPRESAS”)
@SequenceGenerator(name = “empresa_codigo_seq”, sequenceName = “empresa_codigo_seq”)
public class Empresa implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO, generator = “empresa_codigo_seq”)
@Column(name = “codigo”, nullable = false)
private int codigo;
@Column(name = “dataCadastro”)
@Temporal(javax.persistence.TemporalType.DATE)
private Calendar dataCadastro;
@Column(name = “cnpj”, length = 14)
private String cnpj;
@Column(name = “ie”, length = 15)
private String ie;
@Column(name = “nome”, length = 50)
private String nome;
@Column(name = “nomeFantasia”, length = 50)
private String nomeFantasia;
@Column(name = “rua”, length = 50)
private String rua;
@Column(name = “numero”, length = 10)
private String numero;
@Column(name = “bairro”, length = 50)
private String bairro;
@Column(name = “complemento”, length = 50)
private String complemento;
@Column(name = “cep”, length = 9)
private String cep;
@Column(name = “cidade”, length = 50)
private String cidade;
@Column(name = “estado”, length = 2)
private String estado;
@Column(name = “telefone1”, length = 14)
private String telefone1;
@Column(name = “telefone2”, length = 14)
private String telefone2;
@Column(name = “fax”, length = 14)
private String fax;
@Column(name = “celular”, length = 14)
private String celular;
@Column(name = “contato”, length = 50)
private String contato;
@Column(name = “site”, length = 50)
private String site;
@Column(name = “email”, length = 50)
private String email;

os geters e os setters ;

}[/color]

[color=red][color=#444444]
O erro que esta dando …
[/color][/color]
[color=red]run:
24/08/2009 09:08:22 org.hibernate.cfg.annotations.Version
INFO: Hibernate Annotations 3.3.1.GA
24/08/2009 09:08:22 org.hibernate.cfg.Environment
INFO: Hibernate 3.2.5
24/08/2009 09:08:22 org.hibernate.cfg.Environment
INFO: hibernate.properties not found
24/08/2009 09:08:22 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
24/08/2009 09:08:22 org.hibernate.cfg.Environment
INFO: using JDK 1.4 java.sql.Timestamp handling
24/08/2009 09:08:23 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Cliente
24/08/2009 09:08:23 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Cliente on table CLIENTES
24/08/2009 09:08:23 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Empresa
24/08/2009 09:08:23 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Empresa on table EMPRESAS
24/08/2009 09:08:23 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Fornecedor
24/08/2009 09:08:23 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Fornecedor on table FORNECEDORES
24/08/2009 09:08:23 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Grupo
24/08/2009 09:08:23 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Grupo on table GRUPOS
24/08/2009 09:08:23 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.SubGrupo
24/08/2009 09:08:23 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.SubGrupo on table SUBGRUPOS
24/08/2009 09:08:23 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Produto
24/08/2009 09:08:23 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Produto on table PRODUTOS
24/08/2009 09:08:23 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.CondicaoPagamento
24/08/2009 09:08:23 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.CondicaoPagamento on table CONDICAOPAGAMENTOS
24/08/2009 09:08:23 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Usuario
24/08/2009 09:08:23 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Usuario on table USUARIOS
24/08/2009 09:08:23 org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
24/08/2009 09:08:23 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
24/08/2009 09:08:23 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
24/08/2009 09:08:23 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
24/08/2009 09:08:23 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3309/bancodados
24/08/2009 09:08:23 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=root, password=****, autocommit=false}
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: MySQL, version: 6.0.2-alpha-community-nt-debug
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )
24/08/2009 09:08:24 org.hibernate.dialect.Dialect
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
24/08/2009 09:08:24 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
24/08/2009 09:08:24 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
24/08/2009 09:08:24 org.hibernate.hql.ast.ASTQueryTranslatorFactory
INFO: Using ASTQueryTranslatorFactory
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
24/08/2009 09:08:24 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
24/08/2009 09:08:24 org.hibernate.impl.SessionFactoryImpl
INFO: building session factory
24/08/2009 09:08:24 org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
Hibernate: insert into EMPRESAS (bairro, celular, cep, cidade, cnpj, complemento, contato, dataCadastro, email, estado, fax, ie, nome, nomeFantasia, numero, rua, site, telefone1, telefone2) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
24/08/2009 09:08:24 org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 1146, SQLState: 42S02
24/08/2009 09:08:24 org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Table ‘bancodados.empresas’ doesn’t exist
24/08/2009 09:08:24 forms.cadastroEmpresa btnSalvarActionPerformed
SEVERE: null
org.hibernate.exception.SQLGrammarException: could not insert: [classes.Empresa]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at dataAccessObject.HibernateDao.cadastrar(HibernateDao.java:27)
at forms.cadastroEmpresa.btnSalvarActionPerformed(cadastroEmpresa.java:576)
at forms.cadastroEmpresa.access$200(cadastroEmpresa.java:25)
at forms.cadastroEmpresa$3.actionPerformed(cadastroEmpresa.java:235)
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.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
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:2475)
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)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘bancodados.empresas’ doesn’t exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
… 44 more
CONSTRUÇÃO PARADA (tempo total: 38 segundos)[/color]

Por favor, me ajudem …

[renatosoares]

Alguem por favor , me ajude … faltou alguma informação para estar passando para voces estarem me ajudando … por favor preciso muito de ajuda.

[emmanuelrock]

Olá, tente colocar mais um ‘?’ dentro da estrutura values.

[renatosoares]

Olá, tente colocar mais um ‘?’ dentro da estrutura values.

Ola amigo, bom dia

da uma olhada fazendo favor , como eu estou passando os atributos …

criei esta classe.

public void chamarEmpresa() {
//empresa.setDataCadastro(data);
//empresa.setCodigo(Integer.parseInt(txtFieldCodigo.getText()));
empresa.setNome(txtFieldNome.getText());
empresa.setNomeFantasia(txtFieldNomeFantasia.getText());
empresa.setCnpj(txtFieldCNPJ.getText());
empresa.setIe(txtFieldIE.getText());
empresa.setRua(txtFieldRua.getText());
empresa.setNumero(txtFieldNumero.getText());
empresa.setBairro(txtFieldBairro.getText());
empresa.setCep(txtFieldCEP.getText());
empresa.setComplemento(txtFieldComplemento.getText());
empresa.setCidade(txtFieldCidade.getText());
empresa.setEstado(comboBoxEstado.getName());
empresa.setTelefone1(txtFieldTelefone1.getText());
empresa.setTelefone2(txtFieldTelefone2.getText());
empresa.setFax(txtFieldFax.getText());
empresa.setCelular(txtFieldCelular.getText());
empresa.setContato(txtFieldContato.getText());
empresa.setSite(txtFieldSite.getText());
empresa.setEmail(txtFieldEmail.getText());
}

obrigado … aguado respostas …

[wagner_a_lima]

Observe que o nome da sua classe é Empresa e sua tabela no banco é EMPRESAS.
Logo, em sua consulta você deve utilizar o nome de sua classe e seus atributos.

Veja se é isso.
Quando conseguir resolver, não se esqueça de colocar [RESOLVIDO]

[renatosoares]

[quote=wagner_a_lima]Observe que o nome da sua classe é Empresa e sua tabela no banco é EMPRESAS.
Logo, em sua consulta você deve utilizar o nome de sua classe e seus atributos.

Veja se é isso.
Quando conseguir resolver, não se esqueça de colocar [RESOLVIDO] [/quote]

Bom dia Wagner …
fiz o que voce falou … troquei empresas por empresa … e continua dando o mesmo problema …

Por favor preciso de ajuda…

[emmanuelrock]

Coloque o novo erro ae pra gente ver…

[renatosoares]

Coloque o novo erro ae pra gente ver…

Aqui amigo … segue abaixo novo erro … conforme as sugestões de voces.

[color=red] run:
24/08/2009 11:43:49 org.hibernate.cfg.annotations.Version
INFO: Hibernate Annotations 3.3.1.GA
24/08/2009 11:43:49 org.hibernate.cfg.Environment
INFO: Hibernate 3.2.5
24/08/2009 11:43:49 org.hibernate.cfg.Environment
INFO: hibernate.properties not found
24/08/2009 11:43:49 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : cglib
24/08/2009 11:43:49 org.hibernate.cfg.Environment
INFO: using JDK 1.4 java.sql.Timestamp handling
24/08/2009 11:43:49 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Cliente
24/08/2009 11:43:50 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Cliente on table CLIENTES
24/08/2009 11:43:50 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Empresa
24/08/2009 11:43:50 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Empresa on table empresa
24/08/2009 11:43:50 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Fornecedor
24/08/2009 11:43:50 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Fornecedor on table FORNECEDORES
24/08/2009 11:43:50 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Grupo
24/08/2009 11:43:50 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Grupo on table GRUPOS
24/08/2009 11:43:50 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.SubGrupo
24/08/2009 11:43:50 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.SubGrupo on table SUBGRUPOS
24/08/2009 11:43:50 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Produto
24/08/2009 11:43:50 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Produto on table PRODUTOS
24/08/2009 11:43:50 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.CondicaoPagamento
24/08/2009 11:43:50 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.CondicaoPagamento on table CONDICAOPAGAMENTOS
24/08/2009 11:43:50 org.hibernate.cfg.AnnotationBinder bindClass
INFO: Binding entity from annotated class: classes.Usuario
24/08/2009 11:43:50 org.hibernate.cfg.annotations.EntityBinder bindTable
INFO: Bind entity classes.Usuario on table USUARIOS
24/08/2009 11:43:50 org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
24/08/2009 11:43:50 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
24/08/2009 11:43:50 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
24/08/2009 11:43:50 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
24/08/2009 11:43:50 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3309/bancodados
24/08/2009 11:43:50 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=root, password=****, autocommit=false}
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: MySQL, version: 6.0.2-alpha-community-nt-debug
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )
24/08/2009 11:43:51 org.hibernate.dialect.Dialect
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
24/08/2009 11:43:51 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
24/08/2009 11:43:51 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
24/08/2009 11:43:51 org.hibernate.hql.ast.ASTQueryTranslatorFactory
INFO: Using ASTQueryTranslatorFactory
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory createCacheProvider
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
24/08/2009 11:43:51 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
24/08/2009 11:43:51 org.hibernate.impl.SessionFactoryImpl
INFO: building session factory
24/08/2009 11:43:51 org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
Hibernate: insert into empresa (bairro, celular, cep, cidade, cnpj, complemento, contato, dataCadastro, email, estado, fax, ie, nome, nomeFantasias, numero, rua, site, telefone1, telefone2) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
24/08/2009 11:43:51 org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 1146, SQLState: 42S02
24/08/2009 11:43:51 org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Table ‘bancodados.empresa’ doesn’t exist
24/08/2009 11:43:51 forms.cadastroEmpresa btnSalvarActionPerformed
SEVERE: null
org.hibernate.exception.SQLGrammarException: could not insert: [classes.Empresa]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at dataAccessObject.HibernateDao.cadastrar(HibernateDao.java:27)
at forms.cadastroEmpresa.btnSalvarActionPerformed(cadastroEmpresa.java:576)
at forms.cadastroEmpresa.access$200(cadastroEmpresa.java:25)
at forms.cadastroEmpresa$3.actionPerformed(cadastroEmpresa.java:235)
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.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
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:2475)
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)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘bancodados.empresa’ doesn’t exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
… 44 more
CONSTRUÇÃO PARADA (tempo total: 18 segundos)
[/color]

Por favor amigos … peço ajuda.

[emmanuelrock]

Qual o nome da sua tabela no banco, empresas, empresa, EMPRESA?

[wagner_a_lima]

Você poderia postar sua query? E como emmanuelrock solicitou qual o nome da tabela no banco? Poste novamente sua classe Empresa.

Sem querer ser o certinho (ou chato), coloca os códigos entre a tag code. . Fica melhor de ajudar.

[renatosoares]

[quote=wagner_a_lima]Você poderia postar sua query? E como emmanuelrock solicitou qual o nome da tabela no banco? Poste novamente sua classe Empresa.

Sem querer ser o certinho (ou chato), coloca os códigos entre a tag code. . Fica melhor de ajudar.[/quote]

Boa tarde Wagner … segue abaixo a minha classe Empresa. Teóricamente a classe empresa, teria que gerar automaticamente no banco.

[code]/*

• To change this template, choose Tools | Templates
• and open the template in the editor.
  */
  package classes;

import java.io.Serializable;
import java.util.Calendar;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
import javax.persistence.Temporal;

/**
*

• @author Renato Soares
  */
  @Entity
  @Table(name = “empresa”)
  @SequenceGenerator(name = “empresa_codigo_seq”, sequenceName = “empresa_codigo_seq”)
  public class Empresa implements Serializable {

  private static final long serialVersionUID = 1L;

  @Id
  @GeneratedValue(strategy = GenerationType.AUTO, generator = “empresa_codigo_seq”)
  @Column(name = “codigo”, nullable = false)
  private int codigo;

  @Column(name = “dataCadastro”)
  @Temporal(javax.persistence.TemporalType.DATE)
  private Calendar dataCadastro;
  @Column(name = “cnpj”, length = 14)
  private String cnpj;
  @Column(name = “ie”, length = 15)
  private String ie;
  @Column(name = “nome”, length = 50)
  private String nome;
  @Column(name = “nomeFantasias”, length = 50)
  private String nomeFantasias;
  @Column(name = “rua”, length = 50)
  private String rua;
  @Column(name = “numero”, length = 10)
  private String numero;
  @Column(name = “bairro”, length = 50)
  private String bairro;
  @Column(name = “complemento”, length = 50)
  private String complemento;
  @Column(name = “cep”, length = 9)
  private String cep;
  @Column(name = “cidade”, length = 50)
  private String cidade;
  @Column(name = “estado”, length = 2)
  private String estado;
  @Column(name = “telefone1”, length = 14)
  private String telefone1;
  @Column(name = “telefone2”, length = 14)
  private String telefone2;
  @Column(name = “fax”, length = 14)
  private String fax;
  @Column(name = “celular”, length = 14)
  private String celular;
  @Column(name = “contato”, length = 50)
  private String contato;
  @Column(name = “site”, length = 50)
  private String site;
  @Column(name = “email”, length = 50)
  private String email;

  public String getBairro() {
  return bairro;
  }

  public void setBairro(String bairro) {
  this.bairro = bairro;
  }

  public String getCelular() {
  return celular;
  }

  public void setCelular(String celular) {
  this.celular = celular;
  }

  public String getCep() {
  return cep;
  }

  public void setCep(String cep) {
  this.cep = cep;
  }

  public String getCidade() {
  return cidade;
  }

  public void setCidade(String cidade) {
  this.cidade = cidade;
  }

  public String getCnpj() {
  return cnpj;
  }

  public void setCnpj(String cnpj) {
  this.cnpj = cnpj;
  }

  public int getCodigo() {
  return codigo;
  }

  public void setCodigo(int codigo) {
  this.codigo = codigo;
  }

  public String getComplemento() {
  return complemento;
  }

  public void setComplemento(String complemento) {
  this.complemento = complemento;
  }

  public String getContato() {
  return contato;
  }

  public void setContato(String contato) {
  this.contato = contato;
  }

  public Calendar getDataCadastro() {
  return dataCadastro;
  }

  public void setDataCadastro(Calendar dataCadastro) {
  this.dataCadastro = dataCadastro;
  }

  public String getEmail() {
  return email;
  }

  public void setEmail(String email) {
  this.email = email;
  }

  public String getEstado() {
  return estado;
  }

  public void setEstado(String estado) {
  this.estado = estado;
  }

  public String getFax() {
  return fax;
  }

  public void setFax(String fax) {
  this.fax = fax;
  }

  public String getIe() {
  return ie;
  }

  public void setIe(String ie) {
  this.ie = ie;
  }

  public String getNome() {
  return nome;
  }

  public void setNome(String nome) {
  this.nome = nome;
  }

  public String getNomeFantasias() {
  return nomeFantasias;
  }

  public void setNomeFantasias(String nomeFantasias) {
  this.nomeFantasias = nomeFantasias;
  }

  public String getNumero() {
  return numero;
  }

  public void setNumero(String numero) {
  this.numero = numero;
  }

  public String getRua() {
  return rua;
  }

  public void setRua(String rua) {
  this.rua = rua;
  }

  public String getSite() {
  return site;
  }

  public void setSite(String site) {
  this.site = site;
  }

  public String getTelefone1() {
  return telefone1;
  }

  public void setTelefone1(String telefone1) {
  this.telefone1 = telefone1;
  }

  public String getTelefone2() {
  return telefone2;
  }

  public void setTelefone2(String telefone2) {
  this.telefone2 = telefone2;
  }

}
[/code]

Obrigado, aguardo respostas.

[emmanuelrock]

Acesse o banco de dados e veja se existe a tabela ‘empresa’. Lembrando-se do caso de Java ser case sensitive.

[renatosoares]

Acesse o banco de dados e veja se existe a tabela ‘empresa’. Lembrando-se do caso de Java ser case sensitive.

Boa tarde Emmanuel ,

A classe Empresa, nem chega a ser criada no banco.

Segue abaixo, a minha classe CLIENTE … eu apenas tirei alguns atributos da classe cliente , e salvei como EMPRESA.

[code]/*

• To change this template, choose Tools | Templates
• and open the template in the editor.
  */
  package classes;

import java.io.Serializable;
import java.util.Calendar;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
import javax.persistence.Temporal;

/**
*

• @author Renato Soares
  */
  @Entity
  @Table(name = “CLIENTES”)
  @SequenceGenerator(name = “cliente_codigo_seq”, sequenceName = “cliente_codigo_seq”)
  public class Cliente implements Serializable {

  private static final long serialVersionUID = 1L;

  @Id
  @GeneratedValue(strategy = GenerationType.AUTO, generator = “cliente_codigo_seq”)
  @Column(name = “codigo”, nullable = false)
  private int codigo;

  @Column(name = “dataCadastro”)
  @Temporal(javax.persistence.TemporalType.DATE)
  private Calendar dataCadastro;
  @Column(name = “tipoPessoa”, length = 1)
  private int tipoPessoa;
  @Column(name = “cpf”, length = 11)
  private String cpf;
  @Column(name = “rg”, length = 19)
  private String rg;
  @Column(name = “cnpj”, length = 14)
  private String cnpj;
  @Column(name = “ie”, length = 15)
  private String ie;
  @Column(name = “nome”, length = 50)
  private String nome;
  @Column(name = “nomeFantasia”, length = 50)
  private String nomeFantasia;
  @Column(name = “rua”, length = 50)
  private String rua;
  @Column(name = “numero”, length = 10)
  private String numero;
  @Column(name = “bairro”, length = 50)
  private String bairro;
  @Column(name = “complemento”, length = 50)
  private String complemento;
  @Column(name = “cep”, length = 9)
  private String cep;
  @Column(name = “cidade”, length = 50)
  private String cidade;
  @Column(name = “estado”, length = 2)
  private String estado;
  @Column(name = “telefone1”, length = 14)
  private String telefone1;
  @Column(name = “telefone2”, length = 14)
  private String telefone2;
  @Column(name = “fax”, length = 14)
  private String fax;
  @Column(name = “celular”, length = 14)
  private String celular;
  @Column(name = “contato”, length = 50)
  private String contato;
  @Column(name = “site”, length = 50)
  private String site;
  @Column(name = “email”, length = 50)
  private String email;
  @Column(name = “endCobranca”, length = 50)
  private String endCobranca;
  @Column(name = “numeroCobranca”, length = 10)
  private String numemroCobranca;
  @Column(name = “bairroCobranca”, length = 50)
  private String bairroCobranca;
  @Column(name = “complementoCobranca”, length = 50)
  private String complementoCobranca;
  @Column(name = “cepCobranca”, length = 9)
  private String cepCobranca;
  @Column(name = “cidadeCobranca”, length = 50)
  private String cidadeCobranca;
  @Column(name = “estadoCobranca”, length = 50)
  private String estadoCobranca;

  public String getNumemroCobranca() {
  return numemroCobranca;
  }

  public void setNumemroCobranca(String numemroCobranca) {
  this.numemroCobranca = numemroCobranca;
  }

  public int getTipoPessoa() {
  return tipoPessoa;
  }

  public void setTipoPessoa(int tipoPessoa) {
  this.tipoPessoa = tipoPessoa;
  }

  public String getComplementoCobranca() {
  return complementoCobranca;
  }

  public void setComplementoCobranca(String complementoCobranca) {
  this.complementoCobranca = complementoCobranca;
  }

  public String getBairro() {
  return bairro;
  }

  public void setBairro(String bairro) {
  this.bairro = bairro;
  }

  public String getBairroCobranca() {
  return bairroCobranca;
  }

  public void setBairroCobranca(String bairroCobranca) {
  this.bairroCobranca = bairroCobranca;
  }

  public String getCelular() {
  return celular;
  }

  public void setCelular(String celular) {
  this.celular = celular;
  }

  public String getCep() {
  return cep;
  }

  public void setCep(String cep) {
  this.cep = cep;
  }

  public String getCepCobranca() {
  return cepCobranca;
  }

  public void setCepCobranca(String cepCobranca) {
  this.cepCobranca = cepCobranca;
  }

  public String getCidade() {
  return cidade;
  }

  public void setCidade(String cidade) {
  this.cidade = cidade;
  }

  public String getCidadeCobranca() {
  return cidadeCobranca;
  }

  public void setCidadeCobranca(String cidadeCobranca) {
  this.cidadeCobranca = cidadeCobranca;
  }

  public String getCnpj() {
  return cnpj;
  }

  public void setCnpj(String cnpj) {
  this.cnpj = cnpj;
  }

  public Integer getCodigo() {
  return codigo;
  }

  public void setCodigo(Integer codigo) {
  this.codigo = codigo;
  }

  public String getComplemento() {
  return complemento;
  }

  public void setComplemento(String complemento) {
  this.complemento = complemento;
  }

  public String getContato() {
  return contato;
  }

  public void setContato(String contato) {
  this.contato = contato;
  }

  public String getCpf() {
  return cpf;
  }

  public void setCpf(String cpf) {
  this.cpf = cpf;
  }

  public Calendar getDataCadastro() {
  return dataCadastro;
  }

  public void setDataCadastro(Calendar dataCadastro) {
  this.dataCadastro = dataCadastro;
  }

  public String getEmail() {
  return email;
  }

  public void setEmail(String email) {
  this.email = email;
  }

  public String getEndCobranca() {
  return endCobranca;
  }

  public void setEndCobranca(String endCobranca) {
  this.endCobranca = endCobranca;
  }

  public String getEstado() {
  return estado;
  }

  public void setEstado(String estado) {
  this.estado = estado;
  }

  public String getEstadoCobranca() {
  return estadoCobranca;
  }

  public void setEstadoCobranca(String estadoCobranca) {
  this.estadoCobranca = estadoCobranca;
  }

  public String getFax() {
  return fax;
  }

  public void setFax(String fax) {
  this.fax = fax;
  }

  public String getIe() {
  return ie;
  }

  public void setIe(String ie) {
  this.ie = ie;
  }

  public String getNome() {
  return nome;
  }

  public void setNome(String nome) {
  this.nome = nome;
  }

  public String getNomeFantasia() {
  return nomeFantasia;
  }

  public void setNomeFantasia(String nomeFantasia) {
  this.nomeFantasia = nomeFantasia;
  }

  public String getNumero() {
  return numero;
  }

  public void setNumero(String numero) {
  this.numero = numero;
  }

  public String getRg() {
  return rg;
  }

  public void setRg(String rg) {
  this.rg = rg;
  }

  public String getRua() {
  return rua;
  }

  public void setRua(String rua) {
  this.rua = rua;
  }

  public String getSite() {
  return site;
  }

  public void setSite(String site) {
  this.site = site;
  }

  public String getTelefone1() {
  return telefone1;
  }

  public void setTelefone1(String telefone1) {
  this.telefone1 = telefone1;
  }

  public String getTelefone2() {
  return telefone2;
  }

  public void setTelefone2(String telefone2) {
  this.telefone2 = telefone2;
  }

}
[/code]

A classe Cliente, esta funcionando corretamente.

[emmanuelrock]

Boa tarde Renato. O erro é que você está querendo alterar uma tabela que não existe no banco de dados.

[renatosoares]

Boa tarde Renato. O erro é que você está querendo alterar uma tabela que não existe no banco de dados.

Oi Emmanuel ,

Por favor, no caso , qual seria a melhor solução, para arrumar o erro. E sim criar a tablea.

Obrigado.

[renatosoares]

Amigos, obrigado pela ajuda … o problema era o que o Emmanuel havia falado, esta tentando alterar uma tabela, e ela não existia … apenas criei a tabela.

De momento, muito obrigado a todos por terem me ajudado.

Tenham um bom dia.

[emmanuelrock]

É meu amigo você vai ter que criar a tabela no banco de dados. No meu caso eu uso a ferramenta gráfica do My SQL que pode ser baixada aqui: http://dev.mysql.com/downloads/gui-tools/5.0.html . Qualquer coisa estamos ae…