[es] - Problem sa java JPA aplikacijom

glamoc

Član broj: 125620
Poruke: 346
212.200.65.*

+1 Profil

^{08.11.2010. u 16:57 - pre 163 meseci}

Pokusavam napraviti najjednostavniju java JPA aplikaciju ali se ne uspevam povezati sa bazom.
Konfiguracion fajl persistence.xml izgleda ovako:

Code:
<?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="firstJPA">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        
        <properties>
            <property name="hibernate.archive.autodetection" value="class, hbm"/>
            <property name="hibernate.show_sql" value="true"/>
            <property name="hibernate.format_sql" value="true"/>
            <property name="hibernate.connection.driver_class" value="org.hsqldb.jdbcDriver"/>
            <property name="hibernate.connection.url" value="jdbc:hsqldb:hsql://localhost/students"/>
            <property name="hibernate.connection.username" value="root"/>
            <property name="hibernate.connection.password" value=""/>

            
        </properties>
    </persistence-unit>
</persistence>

a greska koju mi prijavi je:

Code:
17:03:05,390 WARN SettingsFactory:144 - Could not obtain connection metadata
java.sql.SQLException: socket creation error
    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
    at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
    at org.hsqldb.jdbcDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
    at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)
    at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
    at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
    at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
    at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
    at org.vojko.jpa.App.main(App.java:16)

Sta je ustvari HSQL?Na netu nadjoh da je to neki ubrzani SQL.Ja sam podigao obican SQL.Ako treba pokrenuti nesto specijalno da bi ovo radilo molio bih za pomoc.

Kad covjeka napusti Sunce njegovog zavicaja ko ce mu posvijetliti na putu povratka

Odgovor na temu

_Abraxas
myth

Član broj: 154070
Poruke: 61
*.dynamic.sbb.rs.

Profil

Re: Problem sa java JPA aplikacijom

^{08.11.2010. u 21:06 - pre 163 meseci}

Ukoliko zelis da koristis "obican SQL", pod kojim verovatno podrazumevas MySQL Server, potrebno je da promenis:

a) hibernate.connection.driver_class : com.mysql.jdbc.Driver
b) hibernate.dialect : org.hibernate.dialect.MySQLDialect
c) hibernate.connection.url : jdbc:mysql://localhost:3306/testdb (pretpostavljam da si MySQL Server podigao na default portu, a to je 3306)

Naravno, potrebno je da u classpath imas setovan jar u kome se nalazi driver za MySQL ili da ukljucis ovaj jar u projekat.

Ukoliko zelis da koristis HSQLDB, mislim da je potrebno da promenis url u jdbc:hsqldb:mem:testdb. Shema ce se cuvati u operativnoj memoriji. HSQLDB se cesto koristi prilikom unit i integracionog testiranja.

Pozdrav. :)

Odgovor na temu