Problema com table não existente

24 de agosto de 2009 16 respostas

renatosoares 24 de agosto de 2009

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 <a href="http://3.3.1.GA">3.3.1.GA</a>

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 …

16 Respostas

renatosoares 24 de ago. de 2009

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

emmanuelrock 24 de ago. de 2009

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

renatosoares 24 de ago. de 2009

Ola amigo, bom dia

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

criei esta classe.

public void chamarEmpresa() {

<a href="//empresa.setDataCadastro">//empresa.setDataCadastro</a>(data);

<a href="//empresa.setCodigo">//empresa.setCodigo</a>(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 24 de ago. de 2009

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 24 de ago. de 2009

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]

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

Por favor preciso de ajuda…

emmanuelrock 24 de ago. de 2009

Coloque o novo erro ae pra gente ver…

renatosoares 24 de ago. de 2009

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 <a href="http://3.3.1.GA">3.3.1.GA</a>

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 24 de ago. de 2009

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

wagner_a_lima 24 de ago. de 2009

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 24 de ago. de 2009

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.

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

/*
 * 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;
    }
     
}

Obrigado, aguardo respostas.

emmanuelrock 24 de ago. de 2009

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

renatosoares 24 de ago. de 2009

emmanuelrock:
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.

/*
 * 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;
    }

    
}

A classe Cliente, esta funcionando corretamente.

emmanuelrock 24 de ago. de 2009

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

renatosoares 24 de ago. de 2009

Oi Emmanuel ,

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

Obrigado.

renatosoares 24 de ago. de 2009

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 24 de ago. de 2009

É 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…

Criado 24 de agosto de 2009

Ultima resposta 24 de ago. de 2009

Respostas 16

Participantes 3

16 Respostas

Topicos relacionados