java - Unable to make JDBC Connection [jdbc:derby://localhost:1527/db_thermium;create=true] -
i trying, first time, use javadb (apache derby) database, graduation project (it technician), having trouble in connecting pre created database.
i'm using hibernate connection framework can't connection done! ahead trace of exception, try persist object @ database 1ยบ time.
exception in thread "main" org.hibernate.hibernateexception: unable make jdbc connection [jdbc:derby://localhost:1527/db_thermium;create=true] @ org.hibernate.engine.jdbc.connections.internal.basicconnectioncreator.createconnection(basicconnectioncreator.java:60) @ org.hibernate.engine.jdbc.connections.internal.pooledconnections.addconnections(pooledconnections.java:106) @ org.hibernate.engine.jdbc.connections.internal.pooledconnections.<init>(pooledconnections.java:40) @ org.hibernate.engine.jdbc.connections.internal.pooledconnections.<init>(pooledconnections.java:19) @ org.hibernate.engine.jdbc.connections.internal.pooledconnections$builder.build(pooledconnections.java:138) @ org.hibernate.engine.jdbc.connections.internal.drivermanagerconnectionproviderimpl.buildpool(drivermanagerconnectionproviderimpl.java:110) @ org.hibernate.engine.jdbc.connections.internal.drivermanagerconnectionproviderimpl.configure(drivermanagerconnectionproviderimpl.java:74) @ org.hibernate.boot.registry.internal.standardserviceregistryimpl.configureservice(standardserviceregistryimpl.java:94) @ org.hibernate.service.internal.abstractserviceregistryimpl.initializeservice(abstractserviceregistryimpl.java:237) @ org.hibernate.service.internal.abstractserviceregistryimpl.getservice(abstractserviceregistryimpl.java:207) @ org.hibernate.internal.abstractsharedsessioncontract.getjdbcconnectionaccess(abstractsharedsessioncontract.java:424) @ org.hibernate.engine.jdbc.internal.jdbccoordinatorimpl.<init>(jdbccoordinatorimpl.java:102) @ org.hibernate.internal.abstractsharedsessioncontract.<init>(abstractsharedsessioncontract.java:194) @ org.hibernate.internal.abstractsessionimpl.<init>(abstractsessionimpl.java:29) @ org.hibernate.internal.sessionimpl.<init>(sessionimpl.java:246) @ org.hibernate.internal.sessionfactoryimpl$sessionbuilderimpl.opensession(sessionfactoryimpl.java:1193) @ org.hibernate.internal.sessionfactoryimpl.buildentitymanager(sessionfactoryimpl.java:572) @ org.hibernate.internal.sessionfactoryimpl.createentitymanager(sessionfactoryimpl.java:559) @ org.hibernate.internal.sessionfactoryimpl.createentitymanager(sessionfactoryimpl.java:154) @ gerenciador.entitymanagerutil.getentitymanager(entitymanagerutil.java:16) @ gerenciador.genericdao.salvar(genericdao.java:27) @ main.programa.inserirelemento(programa.java:32) @ main.programa.iniciar(programa.java:19) @ main.programa.main(programa.java:14) main.programa.main(programa.java:14) .here persistence file text:
<?xml version="1.0" encoding="utf-8"?> <persistence xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd" version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"> <persistence-unit name="teste" transaction-type="resource_local"> <properties> <property name="javax.persistence.jdbc.driver" value="org.apache.derby.jdbc.embeddeddriver" /> <property name="javax.persistence.jdbc.username" value="usuario" /> <property name="javax.persistence.jdbc.password" value="123" /> <property name="javax.persistence.jdbc.url" value="jdbc:derby://localhost:1527/db_thermium;create=true" /> <property name="hibernate.dialect" value="org.hibernate.dialect.derbydialect"/> <property name="show_sql" value="true"/> <property name="hibernate.temp.use_jdbc_metadata_defaults" value="false"/> </properties> </persistence-unit> </persistence> .the entitymanager class:
package gerenciador; import javax.persistence.entitymanager; import javax.persistence.entitymanagerfactory; import javax.persistence.persistence; public class entitymanagerutil { private static entitymanagerfactory emf = null; public static entitymanager getentitymanager() { if (emf == null){ emf = persistence.createentitymanagerfactory("teste"); } return emf.createentitymanager(); } public static entitymanagerfactory getemf() { return emf; } public static void closeentityfactory() { if (emf != null) emf.close(); } } .the genericdao:
package gerenciador; import java.io.serializable; import java.util.list; import javax.inject.inject; import javax.persistence.entitymanager; import javax.persistence.entitymanagerfactory; import javax.persistence.entitytransaction; import javax.persistence.criteria.criteriabuilder; import javax.persistence.criteria.criteriaquery; public abstract class genericdao<t, extends serializable> { @inject private class<t> persistedclass; protected genericdao() { } protected genericdao(class<t> persistedclass) { this(); this.persistedclass = persistedclass; } public t salvar(t entity) { entitymanager em = entitymanagerutil.getentitymanager(); entitytransaction t = em.gettransaction(); t.begin(); em.persist(entity); em.flush(); t.commit(); entitymanagerutil.closeentityfactory(); return entity; } public t atualizar(t entity) { entitymanager em = entitymanagerutil.getentitymanager(); entitytransaction t = em.gettransaction(); t.begin(); em.merge(entity); em.flush(); t.commit(); entitymanagerutil.closeentityfactory(); return entity; } public void remover(i id) { t entity = encontrar(id); entitymanager em = entitymanagerutil.getentitymanager(); entitytransaction t = em.gettransaction(); t.begin(); t mergedentity = em.merge(entity); em.remove(mergedentity); em.flush(); t.commit(); entitymanagerutil.closeentityfactory(); } public list<t> getlist() { entitymanager em = entitymanagerutil.getentitymanager(); criteriabuilder builder = em.getcriteriabuilder(); criteriaquery<t> query = builder.createquery(persistedclass); query.from(persistedclass); return em.createquery(query).getresultlist(); } public t encontrar(i id) { entitymanager em = entitymanagerutil.getentitymanager(); return em.find(persistedclass, id); } } 
Comments
Post a Comment