Erro ao tentar conectar o java DB no eclipse
(desconsiderem a outra mensagem por favor)
Colega,
tentei conectar o javadb no eclipse, estou fazendo aula de hibernate. Meu codigo é:
public static void main(String[] args) {
// TODO Auto-generated method stub
SessionFactory sessionFactory = (SessionFactory) new AnnotationConfiguration()
.setProperty(hibernate.dialect,org.hibernate.dialect.DerbyDialect)
.setProperty(hibernate.connection.driver_class,org.apache.derby.jdbc.ClientDriver)
.setProperty(hibernate.connection.url,jdbc:derby://localhost:1521/myJavaDb)
.setProperty(hibernate.connection.username,java)
.setProperty(hibernate.connection.password,java)
.setProperty(hibernate.show_sql,true)
.setProperty(hibernate.format_sql,true)
.setProperty(hibernate.c3pO.acquire_increment,1)
.setProperty(hibernate.c3pO.idle_test_period,100)
.setProperty(hibernate.c3pO.max_size,10)
.setProperty(hibernate.c3pO.max_statements,0)
.setProperty(hibernate.c3pO.min_size,5)
.setProperty(hibernate.c3pO.timeout,100)
.addAnnotatedClass(Users.class)
.buildSessionFactory();
Session session = sessionFactory.openSession();
session.beginTransaction();
Users user = (Users) session.get(Users.class,1);
System.out.println(The user is+user.getMyName());
session.getTransaction().commit();
session.close();
sessionFactory.close();
}
}
quando executei deu o seguinte erro:
Fev 24, 2012 10:46:22 PM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
Fev 24, 2012 10:46:22 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.0.1.Final}
Fev 24, 2012 10:46:22 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Fev 24, 2012 10:46:22 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Fev 24, 2012 10:46:23 PM org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator c3p0ProviderPresent
WARN: HHH000022: c3p0 properties were encountered, but the org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider provider class was not found on the classpath; these properties are going to be ignored.
Fev 24, 2012 10:46:23 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000402: Using Hibernate built-in connection pool (not for production use!)
Fev 24, 2012 10:46:23 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20
Fev 24, 2012 10:46:23 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: false
Fev 24, 2012 10:46:23 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [org.apache.derby.jdbc.ClientDriver] at URL [jdbc:derby://localhost:1521/myJavaDb]
Fev 24, 2012 10:46:23 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=java, password=****}
Fev 24, 2012 10:46:23 PM org.hibernate.engine.jdbc.internal.JdbcServicesImpl configure
WARN: HHH000342: Could not obtain connection to query metadata : Dados insuficientes ao ler da rede - esperado um mínimo de 6 bytes mas recebido apenas 0 bytes. A conexão foi encerrada.
Fev 24, 2012 10:46:23 PM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.DerbyDialect
Fev 24, 2012 10:46:23 PM org.hibernate.dialect.DerbyDialect <init>
WARN: HHH000430: The DerbyDialect dialect has been deprecated; use one of the version-specific dialects instead
Fev 24, 2012 10:46:23 PM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
INFO: HHH000422: Disabling contextual LOB creation as connection was null
Fev 24, 2012 10:46:23 PM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000399: Using default transaction strategy (direct JDBC transactions)
Fev 24, 2012 10:46:23 PM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
Fev 24, 2012 10:46:24 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 40000, SQLState: 08006
Fev 24, 2012 10:46:24 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: Dados insuficientes ao ler da rede - esperado um mínimo de 6 bytes mas recebido apenas 0 bytes. A conexão foi encerrada.
Exception in thread main org.hibernate.exception.JDBCConnectionException: Could not open connection
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:67)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:304)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:169)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160)
at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1263)
at firstHibernateApp.Main.main(Main.java:34)
Caused by: java.sql.SQLNonTransientConnectionException: Dados insuficientes ao ler da rede - esperado um mínimo de 6 bytes mas recebido apenas 0 bytes. A conexão foi encerrada.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:190)
at org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:173)
at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:276)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:297)
... 5 more
Caused by: org.apache.derby.client.am.DisconnectException: Dados insuficientes ao ler da rede - esperado um mínimo de 6 bytes mas recebido apenas 0 bytes. A conexão foi encerrada.
at org.apache.derby.client.net.Reply.fill(Unknown Source)
at org.apache.derby.client.net.Reply.ensureALayerDataInBuffer(Unknown Source)
at org.apache.derby.client.net.Reply.readDssHeader(Unknown Source)
at org.apache.derby.client.net.Reply.startSameIdChainParse(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.readExchangeServerAttributes(Unknown Source)
at org.apache.derby.client.net.NetConnection.readServerAttributesAndKeyExchange(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowServerAttributesAndKeyExchange(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source)
at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown Source)
... 11 more
Pode me ajudar, estou usando o eclipse.
Obrigado!
Nilo Souza
Curtidas 0
Respostas
Robson Teixeira
24/02/2012
Não sei muito sobre o derby mas tenta ver se o derby está iniciado pois no NetBeans já vem configurado com o derby e no próprio IDE você tem a op de inicializar o javaDB(que é o derby).
espero ter ajudado.
att
robson
espero ter ajudado.
att
robson
GOSTEI 0
Dyego Carmo
24/02/2012
Pelo visto pode ser tambem algum firewall , desabilite o firewall e inicie o derby no seu netbeans ( na parte de servicos/servidores)
Atenciosamente
Atenciosamente
GOSTEI 0