tutorials.de Buch-Aktion 05/2012
ERLEDIGT
JA
ANTWORTEN
2
ZUGRIFFE
1590
EMPFEHLEN
  • An Twitter übertragen
  • An Facebook übertragen
AUF DIESES THEMA
ANTWORTEN
  1. 23.04.10 12:49 #1
    7bkahnt 7bkahnt ist offline Mitglied Silber
    Registriert seit
    Apr 2010
    Beiträge
    61
    Hallo Leute ich hoffe Ihre könnt mir helfen,
    ich wollte mich mal näher mit Hibernate beschäftigen und ein erstes Tutorial machen. Aber wie es meist so ist, funktioniert das erste Programm schon nicht.
    Ich benutze MyEclipse, habe ein neues Project angelegt und per Add Hibernate Capabilities die notwendigen jar´s alle in der Build Path. Der Oracle-Treiber oracle14.jar befindet sich ebenfalls in der Build Path.
    Muss ich sonst noch irgendetwas machen? In den Tutorials steht eigentlich nichts anderes.

    Das Testprogramm soll 3 Kurse in der Datenbank anlegen und sie auflisten (Physik,Chemie und Mathe).
    Eigentlich benutze ich eine Oracle-Datenbank. So wie ich das verstanden habe, wird durch die hsql.jar aber ein hsqlserver zur Verfügung gestellt, welcher irgendwie auch eine Datenbank zur Verfügung stellt (weil alle Tutorials eigentlich mit "org.hsqldb.jdbcDriver" beschrieben sind).
    Ich habe jetzt erstmal den Quellcode im Bezu auf meine Oracle-Datenbank genommen.
    Hab ich dort vielleicht einen Fehler? Ich komme hier nicht weiter...

    Hier erstmal der Code zum Testprogramm:

    Course.java:
    Code java:
    1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43

    package com.vaannila.course;
 
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
 
 
@Entity
@Table(name="COURSES")
public class Course {
 
    private long courseId;
    private String courseName;
 
    public Course() {
    }
 
    public Course(String courseName) {
        this.courseName = courseName;
    }
 
    @Id
    @GeneratedValue
    @Column(name="COURSE_ID")
    public long getCourseId() {
        return this.courseId;
    }
 
    public void setCourseId(long courseId) {
        this.courseId = courseId;
    }
 
    @Column(name="COURSE_NAME", nullable=false)
    public String getCourseName() {
        return this.courseName;
    }
 
    public void setCourseName(String courseName) {
        this.courseName = courseName;
    }
}


    HibernatUtil:
    Code java:
    1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

    package com.vaannila.util;
 
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;
 
public class HibernateUtil {
    private static final SessionFactory sessionFactory;
    static {
        try {
            sessionFactory = new AnnotationConfiguration().configure()
                    .buildSessionFactory();
        } catch (Throwable ex) {
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        }
    }
 
    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }
}



    die hibernate.cfg:
    Code java:
    1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

    <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:XE</property>
        <property name="hibernate.connection.username">system</property>
        <property name="connection.password">adminadmin</property>
        <property name="connection.pool_size">1</property>
        <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
        <property name="show_sql">true</property>
        <property name="hbm2ddl.auto">create</property>
        <mapping class="com.vaannila.course.Course" />
    </session-factory>
</hibernate-configuration>


    und letztendlich die main.java:
    Code java:
    1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107

    package com.vaannila.course;
 
import java.util.List;
import java.util.Iterator;
 
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;
 
import com.vaannila.util.HibernateUtil;
 
public class Main {
 
    public static void main(String[] args) {
        Main obj = new Main();
        Long courseId1 = obj.saveCourse("Physics");
        Long courseId2 = obj.saveCourse("Chemistry");
        Long courseId3 = obj.saveCourse("Maths");
        obj.listCourse();
        obj.updateCourse(courseId3, "Mathematics");
        obj.deleteCourse(courseId2);
        obj.listCourse();
    }
    
    public Long saveCourse(String courseName)
    {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = null;
        Long courseId = null;
        try {
            transaction = session.beginTransaction();
            Course course = new Course();
            course.setCourseName(courseName);
            courseId = (Long) session.save(course);
            transaction.commit();
        } catch (HibernateException e) {
            if(transaction!=null){
            transaction.rollback();
            e.printStackTrace();}
            else{System.out.println("transaction=null");}
        } finally {
            session.close();
        }
        return courseId;
    }
    
    public void listCourse()
    {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = null;
        try {
            transaction = session.beginTransaction();
            List courses = session.createQuery("from Course").list();
            for (Iterator iterator = courses.iterator(); iterator.hasNext();)
            {
                Course course = (Course) iterator.next();
                System.out.println(course.getCourseName());
            }
            transaction.commit();
        } catch (HibernateException e) {
            if(transaction!=null){
                transaction.rollback();
                e.printStackTrace();}
                else{System.out.println("transaction=null");}
        } finally {
            session.close();
        }
    }
    
    public void updateCourse(Long courseId, String courseName)
    {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = null;
        try {
            transaction = session.beginTransaction();
            Course course = (Course) session.get(Course.class, courseId);
            course.setCourseName(courseName);
            transaction.commit();
        } catch (HibernateException e) {
            if(transaction!=null){
                transaction.rollback();
                e.printStackTrace();}
                else{System.out.println("transaction=null");}
        } finally {
            session.close();
        }
    }
    
    public void deleteCourse(Long courseId)
    {
        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = null;
        try {
            transaction = session.beginTransaction();
            Course course = (Course) session.get(Course.class, courseId);
            session.delete(course);
            transaction.commit();
        } catch (HibernateException e) {
            if(transaction!=null){
                transaction.rollback();
                e.printStackTrace();}
                else{System.out.println("transaction=null");}
        } finally {
            session.close();
        }
    }
}

    Am Ende bekomme ich immer den Fehler:

    14:01:52,591 INFO Version:15 - Hibernate Annotations 3.4.0.GA
    14:01:52,601 INFO Environment:560 - Hibernate 3.3.2.GA
    14:01:52,601 INFO Environment:593 - hibernate.properties not found
    14:01:52,601 INFO Environment:771 - Bytecode provider name : javassist
    14:01:52,611 INFO Environment:652 - using JDK 1.4 java.sql.Timestamp handling
    14:01:52,661 INFO Version:14 - Hibernate Commons Annotations 3.1.0.GA
    14:01:52,661 INFO Configuration:1474 - configuring from resource: /hibernate.cfg.xml
    14:01:52,661 INFO Configuration:1451 - Configuration resource: /hibernate.cfg.xml
    14:01:52,721 INFO Configuration:1589 - Configured SessionFactory: null
    14:01:52,721 INFO HibernateSearchEventListenerRegister:53 - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
    14:01:52,761 INFO AnnotationBinder:419 - Binding entity from annotated class: com.vaannila.course.Course
    14:01:52,781 INFO EntityBinder:422 - Bind entity com.vaannila.course.Course on table COURSES
    14:01:52,811 INFO Version:17 - Hibernate Validator 3.1.0.GA
    14:01:52,851 INFO DriverManagerConnectionProvider:64 - Using Hibernate built-in connection pool (not for production use!)
    14:01:52,851 INFO DriverManagerConnectionProvider:65 - Hibernate connection pool size: 1
    14:01:52,851 INFO DriverManagerConnectionProvider:68 - autocommit mode: false
    14:01:52,861 INFO DriverManagerConnectionProvider:103 - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@localhost:1521:XE
    14:01:52,861 INFO DriverManagerConnectionProvider:109 - connection properties: {user=system, password=****}
    14:01:53,001 INFO SettingsFactory:114 - RDBMS: Oracle, version: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
    14:01:53,001 INFO SettingsFactory:115 - JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0XE
    14:01:53,021 INFO Dialect:175 - Using dialect: org.hibernate.dialect.HSQLDialect
    14:01:53,021 INFO TransactionFactoryFactory:59 - Using default transaction strategy (direct JDBC transactions)
    14:01:53,021 INFO TransactionManagerLookupFactory:80 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
    14:01:53,021 INFO SettingsFactory:161 - Automatic flush during beforeCompletion(): disabled
    14:01:53,021 INFO SettingsFactory:165 - Automatic session close at end of transaction: disabled
    14:01:53,021 INFO SettingsFactory:172 - JDBC batch size: 15
    14:01:53,021 INFO SettingsFactory:175 - JDBC batch updates for versioned data: disabled
    14:01:53,021 INFO SettingsFactory:180 - Scrollable result sets: enabled
    14:01:53,021 INFO SettingsFactory:188 - JDBC3 getGeneratedKeys(): enabled
    14:01:53,021 INFO SettingsFactory:196 - Connection release mode: auto
    14:01:53,031 INFO SettingsFactory:223 - Default batch fetch size: 1
    14:01:53,031 INFO SettingsFactory:227 - Generate SQL with comments: disabled
    14:01:53,031 INFO SettingsFactory:231 - Order SQL updates by primary key: disabled
    14:01:53,031 INFO SettingsFactory:235 - Order SQL inserts for batching: disabled
    14:01:53,031 INFO SettingsFactory:397 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
    14:01:53,031 INFO ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory
    14:01:53,031 INFO SettingsFactory:243 - Query language substitutions: {}
    14:01:53,031 INFO SettingsFactory:248 - JPA-QL strict compliance: disabled
    14:01:53,031 INFO SettingsFactory:253 - Second-level cache: enabled
    14:01:53,031 INFO SettingsFactory:257 - Query cache: disabled
    14:01:53,031 INFO SettingsFactory:382 - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
    14:01:53,031 INFO SettingsFactory:267 - Optimize cache for minimal puts: disabled
    14:01:53,031 INFO SettingsFactory:276 - Structured second-level cache entries: disabled
    14:01:53,031 INFO SettingsFactory:296 - Echoing all SQL to stdout
    14:01:53,031 INFO SettingsFactory:305 - Statistics: disabled
    14:01:53,031 INFO SettingsFactory:309 - Deleted entity synthetic identifier rollback: disabled
    14:01:53,031 INFO SettingsFactory:324 - Default entity-mode: pojo
    14:01:53,031 INFO SettingsFactory:328 - Named query checking : enabled
    14:01:53,061 INFO SessionFactoryImpl:193 - building session factory
    14:01:53,171 INFO SessionFactoryObjectFactory:105 - Not binding factory to JNDI, no JNDI name configured
    14:01:53,181 INFO SchemaExport:226 - Running hbm2ddl schema export
    14:01:53,181 INFO SchemaExport:251 - exporting generated schema to database
    14:01:53,211 ERROR SchemaExport:348 - Unsuccessful: create table COURSES (COURSE_ID bigint generated by default as identity (start with 1), COURSE_NAME varchar(255) not null, primary key (COURSE_ID))
    14:01:53,221 ERROR SchemaExport:349 - ORA-00907: Rechte Klammer fehlt

    14:01:53,221 INFO SchemaExport:268 - schema export complete
    14:01:53,251 DEBUG SQL:111 - insert into COURSES (COURSE_ID, COURSE_NAME) values (null, ?)
    Hibernate: insert into COURSES (COURSE_ID, COURSE_NAME) values (null, ?)
    14:01:53,291 WARN JDBCExceptionReporter:100 - SQL Error: 904, SQLState: 42000
    14:01:53,291 ERROR JDBCExceptionReporter:101 - ORA-00904: "COURSE_NAME": ungültiger Bezeichner

    org.hibernate.exception.SQLGrammarException: could not insert: [com.vaannila.course.Course]
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2176)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2656)
    at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
    at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.j ava:321)
    at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java :130)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveO rUpdateEventListener.java:210)
    at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventList ener.java:56)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventL istener.java:195)
    at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:5 0)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventList ener.java:93)
    at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:563)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:551)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:547)
    at com.vaannila.course.Main.saveCourse(Main.java:34)
    at com.vaannila.course.Main.main(Main.java:16)
    Caused by: java.sql.SQLException: ORA-00904: "COURSE_NAME": ungültiger Bezeichner

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
    at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java :94)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
    ... 17 more
    14:01:53,301 DEBUG SQL:111 - insert into COURSES (COURSE_ID, COURSE_NAME) values (null, ?)
    Hibernate: insert into COURSES (COURSE_ID, COURSE_NAME) values (null, ?)
    14:01:53,301 WARN JDBCExceptionReporter:100 - SQL Error: 904, SQLState: 42000
    14:01:53,301 ERROR JDBCExceptionReporter:101 - ORA-00904: "COURSE_NAME": ungültiger Bezeichner

    org.hibernate.exception.SQLGrammarException: could not insert: [com.vaannila.course.Course]
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2176)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2656)
    at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
    at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.j ava:321)
    at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java :130)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveO rUpdateEventListener.java:210)
    at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventList ener.java:56)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventL istener.java:195)
    at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:5 0)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventList ener.java:93)
    at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:563)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:551)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:547)
    at com.vaannila.course.Main.saveCourse(Main.java:34)
    at com.vaannila.course.Main.main(Main.java:17)
    Caused by: java.sql.SQLException: ORA-00904: "COURSE_NAME": ungültiger Bezeichner

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
    at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java :94)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
    ... 17 more
    14:01:53,301 DEBUG SQL:111 - insert into COURSES (COURSE_ID, COURSE_NAME) values (null, ?)
    Hibernate: insert into COURSES (COURSE_ID, COURSE_NAME) values (null, ?)
    14:01:53,301 WARN JDBCExceptionReporter:100 - SQL Error: 904, SQLState: 42000
    14:01:53,301 ERROR JDBCExceptionReporter:101 - ORA-00904: "COURSE_NAME": ungültiger Bezeichner

    org.hibernate.exception.SQLGrammarException: could not insert: [com.vaannila.course.Course]
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2176)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2656)
    at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
    at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.j ava:321)
    at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java :130)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveO rUpdateEventListener.java:210)
    at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventList ener.java:56)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventL istener.java:195)
    at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:5 0)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventList ener.java:93)
    at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:563)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:551)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:547)
    at com.vaannila.course.Main.saveCourse(Main.java:34)
    at com.vaannila.course.Main.main(Main.java:18)
    Caused by: java.sql.SQLException: ORA-00904: "COURSE_NAME": ungültiger Bezeichner

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
    at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java :94)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
    ... 17 more
    14:01:53,411 DEBUG SQL:111 - select course0_.COURSE_ID as COURSE1_0_, course0_.COURSE_NAME as COURSE2_0_ from COURSES course0_
    Hibernate: select course0_.COURSE_ID as COURSE1_0_, course0_.COURSE_NAME as COURSE2_0_ from COURSES course0_
    14:01:53,411 WARN JDBCExceptionReporter:100 - SQL Error: 904, SQLState: 42000
    14:01:53,411 ERROR JDBCExceptionReporter:101 - ORA-00904: "COURSE0_"."COURSE_NAME": ungültiger Bezeichner

    org.hibernate.exception.SQLGrammarException: could not execute query
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.loader.Loader.doList(Loader.java:2235)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
    at org.hibernate.loader.Loader.list(Loader.java:2124)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    at com.vaannila.course.Main.listCourse(Main.java:53)
    at com.vaannila.course.Main.main(Main.java:19)
    Caused by: java.sql.SQLException: ORA-00904: "COURSE0_"."COURSE_NAME": ungültiger Bezeichner

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
    at org.hibernate.loader.Loader.doQuery(Loader.java:697)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
    at org.hibernate.loader.Loader.doList(Loader.java:2232)
    ... 9 more
    Exception in thread "main" java.lang.IllegalArgumentException: id to load is required for loading
    at org.hibernate.event.LoadEvent.<init>(LoadEvent.java:74)
    at org.hibernate.event.LoadEvent.<init>(LoadEvent.java:56)
    at org.hibernate.impl.SessionImpl.get(SessionImpl.java:840)
    at org.hibernate.impl.SessionImpl.get(SessionImpl.java:836)
    at com.vaannila.course.Main.updateCourse(Main.java:76)
    at com.vaannila.course.Main.main(Main.java:20)
    Geändert von 7bkahnt (23.04.10 um 14:06 Uhr)
     
    Zitieren Zitieren
  2. 23.04.10 13:11 #2
    Avatar von Artorius
    Artorius Artorius ist offline Mitglied Plutonium
    Registriert seit
    Feb 2010
    Beiträge
    222
    Hi!
    Laut Fehlermeldung würde ich mal darauf tippen, dass du keine log4j.properties Datei angelegt hast? !
    Falls dem so ist,, hier http://www.galileocomputing.de/katal...BnlhE#level3~6 unter Punkt 1.1.6 steht, wies geht

    Grüße!
     
    Wenn du eine weise Antwort verlangst, musst du vernünftig fragen.
    (Johann Wolfgang von Goethe)
    ----------------------------------------------------------------------
    FLEXibler Java Entwickler
    Zitieren Zitieren
  3. 23.04.10 13:43 #3
    7bkahnt 7bkahnt ist offline Mitglied Silber
    Registriert seit
    Apr 2010
    Beiträge
    61
    So ich habe meinen Post nochmal geändert.
    Jetzt funktioniert es auch.Aber erst nachdem ich eine Tabelle namens "Courses" angelegt habe und den Dialekt auf OracleDialect umgestellt habe.
    Müsste aber nicht eigentlich die Tabelle von sich aus erstellt werden, aufgrund von
    Code java:
    1

    <property name="hbm2ddl.auto">create</property>
    ?
    Geändert von 7bkahnt (23.04.10 um 14:35 Uhr)
     
    Zitieren Zitieren
« Standart-Emailprogramm des Users nutzen | Array abspeichern »

Ähnliche Themen

  1. [Hibernate] Problem mit Annotations
    Von AndreBrueck im Forum Relationale Datenbanksysteme
    Antworten: 0
    Letzter Beitrag: 28.06.09, 22:01
  2. Spring2 + Hibernate + Annotations + Service + DAO > insert ?
    Von Nobody im Forum Enterprise Java (JEE, J2EE, Spring & Co.)
    Antworten: 8
    Letzter Beitrag: 15.05.09, 12:00
  3. Hibernate Annotations
    Von drezze im Forum Java
    Antworten: 0
    Letzter Beitrag: 28.11.08, 08:36
  4. Spring 2.5.5 JBoss 4.2.2 Hibernate-Annotations (Dringend !)
    Von Smokey67 im Forum Enterprise Java (JEE, J2EE, Spring & Co.)
    Antworten: 5
    Letzter Beitrag: 21.09.08, 18:47
  5. Hibernate hat Probleme mit Annotations
    Von Tobias Köhler im Forum Enterprise Java (JEE, J2EE, Spring & Co.)
    Antworten: 13
    Letzter Beitrag: 27.03.08, 15:46