Boa noite… estou tentando inserir um registro no banco de dados… e ocorre o seguinte erro:
01/01/2002 02:55:05 org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source’ to ‘org.eclipse.jst.jee.server:Telefonia’ did not find a matching property.
01/01/2002 02:55:05 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Java\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Java/bin/client;C:/Java/bin;C:\Inprise\vbroker\bin;C:\ARQUIV~1\Borland\Delphi5\Projects\Bpl;C:\ARQUIV~1\Borland\vbroker\jre\Bin;C:\ARQUIV~1\Borland\vbroker\Bin;C:\ARQUIV~1\Borland\Delphi5\Bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\ARQUIV~1\Borland\Delphi6\Bin;C:\ARQUIV~1\Borland\Delphi6\Projects\Bpl;C:\Arquivos de programas\Java\jdk1.5.0_04\bin;C:\Inprise\vbroker\bin;C:\ARQUIV~1\Borland\Delphi5\Projects\Bpl;C:\ARQUIV~1\Borland\vbroker\jre\Bin;C:\ARQUIV~1\Borland\vbroker\Bin;C:\ARQUIV~1\Borland\Delphi5\Bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\ARQUIV~1\Borland\Delphi6\Bin;C:\ARQUIV~1\Borland\Delphi6\Projects\Bpl;C:\Arquivos de programas\Java\jdk1.5.0_04\bin;C:\Inprise\vbroker\bin;C:\ARQUIV~1\Borland\Delphi5\Projects\Bpl;C:\ARQUIV~1\Borland\vbroker\jre\Bin;C:\ARQUIV~1\Borland\vbroker\Bin;C:\ARQUIV~1\Borland\Delphi5\Bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\ARQUIV~1\Borland\Delphi6\Bin;C:\ARQUIV~1\Borland\Delphi6\Projects\Bpl;C:\Arquivos de programas\Java\jdk1.5.0_04\bin;C:\WINDOWS\System32;C:\eclipse\workspace\Telefonia;C:\Arquivos de programas\Microsoft SQL Server\80\Tools\BINN;C:\eclipse\workspace\Telefonia;C:\Arquivos de programas\Microsoft SQL Server\80\Tools\BINN;C:\eclipse\workspace\Telefonia;C:\Arquivos de programas\Microsoft SQL Server\80\Tools\BINN;;C:\Arquivos de programas\Arquivos comuns\InstallShield;
01/01/2002 02:55:05 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
01/01/2002 02:55:05 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1448 ms
01/01/2002 02:55:06 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
01/01/2002 02:55:06 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
01/01 02:55 WARN [Digester] [ManagedBeanRule]{faces-config/managed-bean} Merge(Login)
01/01 02:55 WARN [Digester] [NavigationRuleRule]{faces-config/navigation-rule} Merge(/pages/login.jsp)
01/01 02:55 WARN [Digester] [ManagedBeanRule]{faces-config/managed-bean} Merge(Localidade)
01/01 02:55 WARN [Digester] [NavigationRuleRule]{faces-config/navigation-rule} Merge(/pages/localidade.jsp)
01/01 02:55 INFO [Environment] Hibernate 3.3.0.SP1
01/01 02:55 INFO [Environment] loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=com.microsoft.sqlserver.jdbc.SQLServerDriver, hibernate.connection.isolation=${jdbc.isolation}, hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider, hibernate.max_fetch_depth=5, hibernate.dialect=org.hibernate.dialect.SQLServerDialect, hibernate.format_sql=true, hibernate.connection.username=sa, hibernate.cache.region_prefix=hibernate.test, hibernate.connection.url=jdbc:sqlserver://localhost:1433;databaseName=telnet, hibernate.bytecode.use_reflection_optimizer=false, hibernate.connection.password=, hibernate.connection.pool_size=5}
01/01 02:55 INFO [Environment] Bytecode provider name : javassist
01/01 02:55 INFO [Environment] using JDK 1.4 java.sql.Timestamp handling
01/01 02:55 INFO [Version] Hibernate Annotations 3.4.0.GA
01/01 02:55 INFO [Version] Hibernate Commons Annotations 3.1.0.GA
01/01 02:55 INFO [HibernateSearchEventListenerRegister] Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
01/01 02:55 INFO [AnnotationBinder] Binding entity from annotated class: br.com.netservice.cadastros.Localidade
01/01 02:55 INFO [EntityBinder] Bind entity br.com.netservice.cadastros.Localidade on table LOCALIDADE
01/01 02:55 INFO [AnnotationConfiguration] Hibernate Validator not found: ignoring
01/01 02:55 INFO [DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!)
01/01 02:55 INFO [DriverManagerConnectionProvider] Hibernate connection pool size: 5
01/01 02:55 INFO [DriverManagerConnectionProvider] autocommit mode: false
01/01 02:55 INFO [DriverManagerConnectionProvider] using driver: com.microsoft.sqlserver.jdbc.SQLServerDriver at URL: jdbc:sqlserver://localhost:1433;databaseName=telnet
01/01 02:55 INFO [DriverManagerConnectionProvider] connection properties: {user=sa, password=}
01/01 02:55 INFO [SettingsFactory] RDBMS: Microsoft SQL Server, version: 8.00.760
01/01 02:55 INFO [SettingsFactory] JDBC driver: Microsoft SQL Server 2005 JDBC Driver, version: 1.1.1320.0
01/01 02:55 INFO [Dialect] Using dialect: org.hibernate.dialect.SQLServerDialect
01/01 02:55 INFO [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)
01/01 02:55 INFO [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
01/01 02:55 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled
01/01 02:55 INFO [SettingsFactory] Automatic session close at end of transaction: disabled
01/01 02:55 INFO [SettingsFactory] Scrollable result sets: enabled
01/01 02:55 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): enabled
01/01 02:55 INFO [SettingsFactory] Connection release mode: auto
01/01 02:55 INFO [SettingsFactory] Maximum outer join fetch depth: 5
01/01 02:55 INFO [SettingsFactory] Default batch fetch size: 1
01/01 02:55 INFO [SettingsFactory] Generate SQL with comments: disabled
01/01 02:55 INFO [SettingsFactory] Order SQL updates by primary key: disabled
01/01 02:55 INFO [SettingsFactory] Order SQL inserts for batching: disabled
01/01 02:55 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
01/01 02:55 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
01/01 02:55 INFO [SettingsFactory] Query language substitutions: {}
01/01 02:55 INFO [SettingsFactory] JPA-QL strict compliance: disabled
01/01 02:55 INFO [SettingsFactory] Second-level cache: enabled
01/01 02:55 INFO [SettingsFactory] Query cache: disabled
01/01 02:55 INFO [SettingsFactory] Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge
01/01 02:55 INFO [RegionFactoryCacheProviderBridge] Cache provider: org.hibernate.cache.HashtableCacheProvider
01/01 02:55 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
01/01 02:55 INFO [SettingsFactory] Cache region prefix: hibernate.test
01/01 02:55 INFO [SettingsFactory] Structured second-level cache entries: disabled
01/01 02:55 INFO [SettingsFactory] Statistics: disabled
01/01 02:55 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
01/01 02:55 INFO [SettingsFactory] Default entity-mode: pojo
01/01 02:55 INFO [SettingsFactory] Named query checking : enabled
01/01 02:55 INFO [SessionFactoryImpl] building session factory
01/01 02:55 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
passou aqui
01/01 02:55 INFO [Inicializacao] --------------------aplicação inicializada com sucesso.--------------------
01/01/2002 02:55:12 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
01/01/2002 02:55:12 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
01/01/2002 02:55:12 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/94 config=null
01/01/2002 02:55:12 org.apache.catalina.startup.Catalina start
INFO: Server startup in 6660 ms
passou em login
bbb
passou em flush
passou conectou
01/01 02:55 DEBUG [StringType] binding ‘’ to parameter: 1
01/01 02:55 DEBUG [StringType] binding ‘’ to parameter: 2
01/01 02:55 DEBUG [StringType] binding ‘’ to parameter: 3
01/01 02:55 DEBUG [StringType] binding ‘’ to parameter: 4
01/01 02:55 DEBUG [StringType] binding ‘’ to parameter: 5
01/01 02:55 DEBUG [StringType] binding ‘’ to parameter: 6
01/01 02:55 DEBUG [StringType] binding ‘bbb’ to parameter: 7
01/01 02:55 DEBUG [StringType] binding ‘’ to parameter: 8
01/01 02:55 DEBUG [StringType] binding ‘’ to parameter: 9
01/01 02:55 WARN [JDBCExceptionReporter] SQL Error: 515, SQLState: 23000
01/01 02:55 ERROR [JDBCExceptionReporter] Cannot insert the value NULL into column ‘LOC_ID’, table ‘Telnet.dbo.LOCALIDADE’; column does not allow nulls. INSERT fails.
org.hibernate.exception.ConstraintViolationException: could not insert: [br.com.netservice.cadastros.Localidade]
Vejam a minha classe
package br.com.netservice.cadastros;
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 org.hibernate.Session;
import br.com.netservice.hibernate.SessionFactory;
@Entity
@Table (name="LOCALIDADE")
public class Localidade
{
@Id
@SequenceGenerator(name="LOC_ID",sequenceName="LOC_ID")
@GeneratedValue(strategy=GenerationType.AUTO, generator="LOC_ID")
@Column(name="LOC_ID")
public Integer Loc_Id;
@Column(name="LOC_NOME")
public String Nome;
@Column(name="LOC_CIDADE")
public String Cidade;
@Column(name="LOC_ORGANIZACAOINVENTARIO")
public String OrganizacaoInventario;
@Column(name="LOC_CARRIER")
public String Carrier;
@Column(name="LOC_PREFIXO")
public String Prefixo;
@Column(name="LOC_MODELOPABX")
public String ModeloPABX;
@Column(name="LOC_IPPABX")
public String IpPABX;
@Column(name="LOC_DDDCIDADE")
public String DddCidade;
@Column(name="LOC_NOINTERNO")
public String NoInterno;
public Integer getLoc_Id() {
return Loc_Id;
}
public void setLoc_Id(Integer loc_Id) {
Loc_Id = loc_Id;
}
public String getDddCidade()
{
return DddCidade;
}
public void setDddCidade(String dddCidade) {
DddCidade = dddCidade;
}
public String getModeloPABX()
{
return ModeloPABX;
}
public void setModeloPABX(String modeloPABX)
{
ModeloPABX = modeloPABX;
}
public String getIpPABX()
{
return IpPABX;
}
public void setIpPABX(String ipPABX)
{
IpPABX = ipPABX;
}
public String getNoInterno()
{
return NoInterno;
}
public void setNoInterno(String noInterno)
{
NoInterno = noInterno;
}
public String getNome()
{
return Nome;
}
public void setNome(String nome)
{
Nome = nome;
}
public String getCidade()
{
return Cidade;
}
public void setCidade(String cidade)
{
Cidade = cidade;
}
public String getOrganizacaoInventario()
{
return OrganizacaoInventario;
}
public void setOrganizacaoInventario(String organizacaoInventario)
{
OrganizacaoInventario = organizacaoInventario;
}
public String getCarrier()
{
return Carrier;
}
public void setCarrier(String carrier)
{
Carrier = carrier;
}
public String getPrefixo()
{
return Prefixo;
}
public void setPrefixo(String prefixo)
{
Prefixo = prefixo;
}
public String Inserir()
{
Session sessao = SessionFactory.currentSession();
try
{
sessao.beginTransaction();
System.out.println(this.getNome());
sessao.flush();
System.out.println("passou em flush");
if (sessao.beginTransaction().isActive())
{
System.out.println("passou conectou");
}
sessao.save(this);
System.out.println("passou em save localidade");
sessao.beginTransaction().commit();
System.out.println("passou em inserir commit");
return "sucesso";
}
catch (Exception excessao)
{
System.out.println(excessao);
return "falhou";
}
finally
{
SessionFactory.closeSession();
}
}
}
[b]vejam o meu jsp
[/b]
<%@ taglib uri=“http://java.sun.com/jsf/core” prefix=“f” %>
<%@ taglib uri=“http://java.sun.com/jsf/html” prefix=“h” %>
<%@ taglib uri=“http://java.sun.com/jsp/jstl/core” prefix=“c” %>
<f:view>
conforme mensagem, não deixa inserir valor nulo… eu tenho que declarar alguma coisa no jsp… alguém pode me ajudar… obrigado…