-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 
  Previous topic | Next topic 
Author Message
sorin7486
 Post subject: firebird sql 104 error...
PostPosted: Thu Jan 25, 2007 11:40 am 
Beginner
Beginner

Joined: Thu Aug 03, 2006 3:43 am
Posts: 45
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.2.1.ga

Mapping documents:
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Jan 25, 2007 3:23:55 PM by Hibernate Tools 3.2.0.beta8 -->
<hibernate-mapping>
    <class name="org.kobit.ofam.service.model.Benutzer" table="BENUTZER" dynamic-update="true" dynamic-insert="true">
        <id name="id" type="java.lang.Long">
            <meta attribute="use-in-equals">true</meta>
            <column name="ID" />
            <generator class="assigned">
                <param name="sequence">Benutzer_id</param>
            </generator>
        </id>
        <version column="XVERSION" name="xversion" access="property" unsaved-value="null" type="java.lang.Long" />
        <many-to-one name="benutzerRolle" class="org.kobit.ofam.service.model.BenutzerRolle" fetch="select">
            <column name="BENUTZER_ROLLE" not-null="true" />
        </many-to-one>
        <many-to-one name="sprache" class="org.kobit.ofam.service.model.Sprache" fetch="select">
            <column name="SPRACHE" not-null="true" />
        </many-to-one>
        <property name="account" type="java.lang.String">
            <column name="ACCOUNT" length="30" not-null="true" unique="true" />
        </property>
        <property name="passwd" type="java.lang.String">
            <column name="PASSWD" length="120" not-null="true" />
        </property>
        <property name="realName" type="java.lang.String">
            <column name="REAL_NAME" length="100" not-null="true" unique="true" />
        </property>
        <property name="home" type="java.lang.String">
            <column name="HOME" length="100" />
        </property>
        <property name="EMail" type="java.lang.String">
            <column name="E_MAIL" length="100" not-null="true" />
        </property>
        <property name="telefon1" type="java.lang.String">
            <column name="TELEFON1" length="30" not-null="true" />
        </property>
        <property name="telefon2" type="java.lang.String">
            <column name="TELEFON2" length="30" />
        </property>
        <property name="telefon3" type="java.lang.String">
            <column name="TELEFON3" length="30" />
        </property>
        <property name="telefon4" type="java.lang.String">
            <column name="TELEFON4" length="30" />
        </property>
        <property name="briefAnrede" type="java.lang.String">
            <column name="BRIEF_ANREDE" length="100" not-null="true" />
        </property>
        <property name="briefGruss" type="java.lang.String">
            <column name="BRIEF_GRUSS" length="100" not-null="true" />
        </property>
        <property name="benutzerGesperrtJn" type="java.lang.Boolean">
            <column name="BENUTZER_GESPERRT_JN" not-null="true" />
        </property>
        <property name="benutzercockpitJn" type="java.lang.Boolean">
            <column name="BENUTZERCOCKPIT_JN" not-null="true" />
        </property>
        <property name="kennwortLaeuftNichtAbJn" type="java.lang.Boolean">
            <column name="KENNWORT_LAEUFT_NICHT_AB_JN" not-null="true" />
        </property>
        <property name="standarddrucker" type="java.lang.String">
            <column name="STANDARDDRUCKER" length="200" />
        </property>
        <property name="xorder" type="java.lang.Long">
            <column name="XORDER" not-null="true" />
        </property>
        <property name="xdelJn" type="java.lang.Boolean">
            <column name="XDEL_JN" not-null="true" />
        </property>
        <property name="xinsertedAt" type="timestamp">
            <column name="XINSERTED_AT" length="19" not-null="true" />
        </property>
        <property name="xinsertedBy" type="java.lang.Long">
            <column name="XINSERTED_BY" not-null="true" />
        </property>
        <property name="xchangedAt" type="java.util.Date">
            <column name="XCHANGED_AT" length="10" />
        </property>
        <property name="xchangedBy" type="java.lang.Long">
            <column name="XCHANGED_BY" />
        </property>
        <set name="benutzerMads" inverse="true" cascade="none">
            <meta attribute="property-type">java.util.Collection</meta>
            <key>
                <column name="BENUTZER" not-null="true" />
            </key>
            <one-to-many class="org.kobit.ofam.service.model.BenutzerMad" />
        </set>
    </class>
</hibernate-mapping>


Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:
Code:
2007-01-25 15:35:14,335 DEBUG org.hibernate.SQL - select this_.ID as ID10_2_, this_.XVERSION as XVERSION10_2_, this_.BENUTZER_ROLLE as BENUTZER3_10_2_, this_.SPRACHE as SPRACHE10_2_, this_.ACCOUNT as ACCOUNT10_2_, this_.PASSWD as PASSWD10_2_, this_.REAL_NAME as REAL7_10_2_, this_.HOME as HOME10_2_, this_.E_MAIL as E9_10_2_, this_.TELEFON1 as TELEFON10_10_2_, this_.TELEFON2 as TELEFON11_10_2_, this_.TELEFON3 as TELEFON12_10_2_, this_.TELEFON4 as TELEFON13_10_2_, this_.BRIEF_ANREDE as BRIEF14_10_2_, this_.BRIEF_GRUSS as BRIEF15_10_2_, this_.BENUTZER_GESPERRT_JN as BENUTZER16_10_2_, this_.BENUTZERCOCKPIT_JN as BENUTZE17_10_2_, this_.KENNWORT_LAEUFT_NICHT_AB_JN as KENNWORT18_10_2_, this_.STANDARDDRUCKER as STANDAR19_10_2_, this_.XORDER as XORDER10_2_, this_.XDEL_JN as XDEL21_10_2_, this_.XINSERTED_AT as XINSERTED22_10_2_, this_.XINSERTED_BY as XINSERTED23_10_2_, this_.XCHANGED_AT as XCHANGED24_10_2_, this_.XCHANGED_BY as XCHANGED25_10_2_, benutzerro2_.ID as ID12_0_, benutzerro2_.XVERSION as XVERSION12_0_, benutzerro2_.BEZ00 as BEZ3_12_0_, benutzerro2_.BEZ01 as BEZ4_12_0_, benutzerro2_.BEZ02 as BEZ5_12_0_, benutzerro2_.BEZ03 as BEZ6_12_0_, benutzerro2_.BEZ04 as BEZ7_12_0_, benutzerro2_.BEZ05 as BEZ8_12_0_, benutzerro2_.ADMIN_JN as ADMIN9_12_0_, benutzerro2_.READONLY_JN as READONLY10_12_0_, benutzerro2_.XORDER as XORDER12_0_, benutzerro2_.XDEL_JN as XDEL12_12_0_, benutzerro2_.XINSERTED_AT as XINSERTED13_12_0_, benutzerro2_.XINSERTED_BY as XINSERTED14_12_0_, benutzerro2_.XCHANGED_AT as XCHANGED15_12_0_, benutzerro2_.XCHANGED_BY as XCHANGED16_12_0_, sprache3_.ID as ID81_1_, sprache3_.XVERSION as XVERSION81_1_, sprache3_.NUMMER as NUMMER81_1_, sprache3_.LOCALE as LOCALE81_1_, sprache3_.BEZ00 as BEZ5_81_1_, sprache3_.BEZ01 as BEZ6_81_1_, sprache3_.BEZ02 as BEZ7_81_1_, sprache3_.BEZ03 as BEZ8_81_1_, sprache3_.BEZ04 as BEZ9_81_1_, sprache3_.BEZ05 as BEZ10_81_1_, sprache3_.XORDER as XORDER81_1_, sprache3_.XDEL_JN as XDEL12_81_1_, sprache3_.XINSERTED_AT as XINSERTED13_81_1_, sprache3_.XINSERTED_BY as XINSERTED14_81_1_, sprache3_.XCHANGED_AT as XCHANGED15_81_1_, sprache3_.XCHANGED_BY as XCHANGED16_81_1_ from OFAM.BENUTZER this_ inner join OFAM.BENUTZER_ROLLE benutzerro2_ on this_.BENUTZER_ROLLE=benutzerro2_.ID inner join OFAM.SPRACHE sprache3_ on this_.SPRACHE=sprache3_.ID where this_.ACCOUNT=? and this_.XDEL_JN=?
Hibernate: select this_.ID as ID10_2_, this_.XVERSION as XVERSION10_2_, this_.BENUTZER_ROLLE as BENUTZER3_10_2_, this_.SPRACHE as SPRACHE10_2_, this_.ACCOUNT as ACCOUNT10_2_, this_.PASSWD as PASSWD10_2_, this_.REAL_NAME as REAL7_10_2_, this_.HOME as HOME10_2_, this_.E_MAIL as E9_10_2_, this_.TELEFON1 as TELEFON10_10_2_, this_.TELEFON2 as TELEFON11_10_2_, this_.TELEFON3 as TELEFON12_10_2_, this_.TELEFON4 as TELEFON13_10_2_, this_.BRIEF_ANREDE as BRIEF14_10_2_, this_.BRIEF_GRUSS as BRIEF15_10_2_, this_.BENUTZER_GESPERRT_JN as BENUTZER16_10_2_, this_.BENUTZERCOCKPIT_JN as BENUTZE17_10_2_, this_.KENNWORT_LAEUFT_NICHT_AB_JN as KENNWORT18_10_2_, this_.STANDARDDRUCKER as STANDAR19_10_2_, this_.XORDER as XORDER10_2_, this_.XDEL_JN as XDEL21_10_2_, this_.XINSERTED_AT as XINSERTED22_10_2_, this_.XINSERTED_BY as XINSERTED23_10_2_, this_.XCHANGED_AT as XCHANGED24_10_2_, this_.XCHANGED_BY as XCHANGED25_10_2_, benutzerro2_.ID as ID12_0_, benutzerro2_.XVERSION as XVERSION12_0_, benutzerro2_.BEZ00 as BEZ3_12_0_, benutzerro2_.BEZ01 as BEZ4_12_0_, benutzerro2_.BEZ02 as BEZ5_12_0_, benutzerro2_.BEZ03 as BEZ6_12_0_, benutzerro2_.BEZ04 as BEZ7_12_0_, benutzerro2_.BEZ05 as BEZ8_12_0_, benutzerro2_.ADMIN_JN as ADMIN9_12_0_, benutzerro2_.READONLY_JN as READONLY10_12_0_, benutzerro2_.XORDER as XORDER12_0_, benutzerro2_.XDEL_JN as XDEL12_12_0_, benutzerro2_.XINSERTED_AT as XINSERTED13_12_0_, benutzerro2_.XINSERTED_BY as XINSERTED14_12_0_, benutzerro2_.XCHANGED_AT as XCHANGED15_12_0_, benutzerro2_.XCHANGED_BY as XCHANGED16_12_0_, sprache3_.ID as ID81_1_, sprache3_.XVERSION as XVERSION81_1_, sprache3_.NUMMER as NUMMER81_1_, sprache3_.LOCALE as LOCALE81_1_, sprache3_.BEZ00 as BEZ5_81_1_, sprache3_.BEZ01 as BEZ6_81_1_, sprache3_.BEZ02 as BEZ7_81_1_, sprache3_.BEZ03 as BEZ8_81_1_, sprache3_.BEZ04 as BEZ9_81_1_, sprache3_.BEZ05 as BEZ10_81_1_, sprache3_.XORDER as XORDER81_1_, sprache3_.XDEL_JN as XDEL12_81_1_, sprache3_.XINSERTED_AT as XINSERTED13_81_1_, sprache3_.XINSERTED_BY as XINSERTED14_81_1_, sprache3_.XCHANGED_AT as XCHANGED15_81_1_, sprache3_.XCHANGED_BY as XCHANGED16_81_1_ from OFAM.BENUTZER this_ inner join OFAM.BENUTZER_ROLLE benutzerro2_ on this_.BENUTZER_ROLLE=benutzerro2_.ID inner join OFAM.SPRACHE sprache3_ on this_.SPRACHE=sprache3_.ID where this_.ACCOUNT=? and this_.XDEL_JN=?
2007-01-25 15:35:14,737 WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: 335544569, SQLState: HY000
2007-01-25 15:35:14,737 ERROR org.hibernate.util.JDBCExceptionReporter - GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 2086
.
2007-01-25 15:35:14,739 DEBUG org.kobit.ofam.gui.security.UserDetailsServiceImpl - Username root not found!org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: could not execute query



Name and version of the database you are using:
firebird 2


hello,

This application runs ok on HSQL db but for some reason when I move to firebird it gives out this 104 error whatever data I try to retrieve...

any idea anybody ???

tnx
Top
 Profile  
 
sorin7486
 Post subject:
PostPosted: Fri Jan 26, 2007 8:30 am 
Beginner
Beginner

Joined: Thu Aug 03, 2006 3:43 am
Posts: 45
I found the solution... it seems in firebird you can't use schema_mane.table_name in query's. You just have to specify the table name and it all works.. I removed the default_schema from configuration files and everything is ok now.
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.