-->
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 » NHibernate 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
kumpfi
 Post subject: ORA-01747: invalid user.table.column, table.column, or colum
PostPosted: Tue May 20, 2008 3:29 am 
Newbie

Joined: Thu May 08, 2008 3:14 am
Posts: 16
Hello,

i generate my hbm.xml files with NConstruct 1.9.1 Lite. There are two classes with nearly the same strutcture. One class is ok and i get the IList. The second class throws the exception post in this topic.

Hibernate version:

2.0

Mapping documents:

Quote:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-lazy="false">

<class name="Storage.Server.Data.Storage.Entity.StorageEntity, Storage.Server" table="STORAGE" >

<id name="Id" column="STORAGE_ID" type="System.Decimal" unsaved-value="null">
<generator class="sequence">
<param name="sequence">STORAGE_SEQ</param>
</generator>
</id>

<property name="Area" column="AREA" access="field.pascalcase-underscore" not-null="false" type="System.Decimal" insert="true" update="true"/>
<property name="Side" column="SIDE" access="field.pascalcase-underscore" not-null="false" type="System.String" insert="true" update="true"/>
<property name="Size" column="SIZE" access="field.pascalcase-underscore" not-null="false" type="System.Decimal" insert="true" update="true"/>
<property name="Tower" column="TOWER" access="field.pascalcase-underscore" not-null="false" type="System.Decimal" insert="true" update="true"/>
<property name="Tray" column="TRAY" access="field.pascalcase-underscore" not-null="false" type="System.String" insert="true" update="true"/>


</class>
</hibernate-mapping>


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

Code:
public IList getPlacesList()
        {
            ISession session = GetSession.getSession();
            ITransaction transaction = session.BeginTransaction();

            IList placesList = session.CreateCriteria(typeof(Storage.Server.Data.Storage.Entity.StorageEntity)).List();
            foreach (Storage.Server.Data.Storage.Entity.StorageEntity place in placesList)
            {

                System.Diagnostics.Debug.WriteLine(place.Id + " last logged in at " + place.Tower);
            }

            return placesList;

        }


Full stack trace of any exception that occurs:

Quote:
11422 [12] DEBUG NHibernate.SqlCommand.SqlSelectBuilder (null) - The initial cap
acity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of:
9 for the table STORAGE storageent0_
11422 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for entity Storage.Server.Data.Storage.Entity.StorageEntity: SELECT storag
eent0_.STORAGE_ID as STORAGE1_2_0_, storageent0_.AREA as AREA2_0_, storageent0_.
SIDE as SIDE2_0_, storageent0_.SIZE as SIZE2_0_, storageent0_.TOWER as TOWER2_0_
, storageent0_.TRAY as TRAY2_0_ FROM STORAGE storageent0_ WHERE storageent0_.STO
RAGE_ID=? for update nowait
11422 [12] DEBUG NHibernate.SqlCommand.SqlSelectBuilder (null) - The initial cap
acity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of:
9 for the table STORAGE storageent0_
11422 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for entity Storage.Server.Data.Storage.Entity.StorageEntity: SELECT storag
eent0_.STORAGE_ID as STORAGE1_2_0_, storageent0_.AREA as AREA2_0_, storageent0_.
SIDE as SIDE2_0_, storageent0_.SIZE as SIZE2_0_, storageent0_.TOWER as TOWER2_0_
, storageent0_.TRAY as TRAY2_0_ FROM STORAGE storageent0_ WHERE storageent0_.STO
RAGE_ID=? for update nowait
11422 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for action NHibernate.Engine.CascadingAction+MergeCascadingAction on entit
y Storage.Server.Data.Storage.Entity.StorageEntity: SELECT storageent0_.STORAGE_
ID as STORAGE1_2_0_, storageent0_.AREA as AREA2_0_, storageent0_.SIDE as SIDE2_0
_, storageent0_.SIZE as SIZE2_0_, storageent0_.TOWER as TOWER2_0_, storageent0_.
TRAY as TRAY2_0_ FROM STORAGE storageent0_ WHERE storageent0_.STORAGE_ID=?
11437 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for action NHibernate.Engine.CascadingAction+RefreshCascadingAction on ent
ity Storage.Server.Data.Storage.Entity.StorageEntity: SELECT storageent0_.STORAG
E_ID as STORAGE1_2_0_, storageent0_.AREA as AREA2_0_, storageent0_.SIDE as SIDE2
_0_, storageent0_.SIZE as SIZE2_0_, storageent0_.TOWER as TOWER2_0_, storageent0
_.TRAY as TRAY2_0_ FROM STORAGE storageent0_ WHERE storageent0_.STORAGE_ID=?
11437 [12] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister (null) - St
atic SQL for entity: Storage.Server.Data.Storage.Entity.StatusEntity
11437 [12] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister (null) - V
ersion select: SELECT STATUS_ID FROM STATUS WHERE STATUS_ID = ?
11437 [12] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister (null) - S
napshot select: SELECT statusenti_.STATUS_ID, statusenti_.STATUS as STATUS3_ FRO
M STATUS statusenti_ WHERE statusenti_.STATUS_ID=?
11437 [12] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister (null) - I
nsert 0: NHibernate.SqlCommand.SqlCommandInfo
11437 [12] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister (null) - U
pdate 0: NHibernate.SqlCommand.SqlCommandInfo
11437 [12] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister (null) - D
elete 0: NHibernate.SqlCommand.SqlCommandInfo
11437 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for entity Storage.Server.Data.Storage.Entity.StatusEntity: SELECT statuse
nti0_.STATUS_ID as STATUS1_3_0_, statusenti0_.STATUS as STATUS3_0_ FROM STATUS s
tatusenti0_ WHERE statusenti0_.STATUS_ID=?
11437 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for entity Storage.Server.Data.Storage.Entity.StatusEntity: SELECT statuse
nti0_.STATUS_ID as STATUS1_3_0_, statusenti0_.STATUS as STATUS3_0_ FROM STATUS s
tatusenti0_ WHERE statusenti0_.STATUS_ID=?
11437 [12] DEBUG NHibernate.SqlCommand.SqlSelectBuilder (null) - The initial cap
acity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of:
9 for the table STATUS statusenti0_
11437 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for entity Storage.Server.Data.Storage.Entity.StatusEntity: SELECT statuse
nti0_.STATUS_ID as STATUS1_3_0_, statusenti0_.STATUS as STATUS3_0_ FROM STATUS s
tatusenti0_ WHERE statusenti0_.STATUS_ID=? for update
11437 [12] DEBUG NHibernate.SqlCommand.SqlSelectBuilder (null) - The initial cap
acity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of:
9 for the table STATUS statusenti0_
11437 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for entity Storage.Server.Data.Storage.Entity.StatusEntity: SELECT statuse
nti0_.STATUS_ID as STATUS1_3_0_, statusenti0_.STATUS as STATUS3_0_ FROM STATUS s
tatusenti0_ WHERE statusenti0_.STATUS_ID=? for update nowait
11437 [12] DEBUG NHibernate.SqlCommand.SqlSelectBuilder (null) - The initial cap
acity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of:
9 for the table STATUS statusenti0_
11437 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for entity Storage.Server.Data.Storage.Entity.StatusEntity: SELECT statuse
nti0_.STATUS_ID as STATUS1_3_0_, statusenti0_.STATUS as STATUS3_0_ FROM STATUS s
tatusenti0_ WHERE statusenti0_.STATUS_ID=? for update nowait
11437 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for action NHibernate.Engine.CascadingAction+MergeCascadingAction on entit
y Storage.Server.Data.Storage.Entity.StatusEntity: SELECT statusenti0_.STATUS_ID
as STATUS1_3_0_, statusenti0_.STATUS as STATUS3_0_ FROM STATUS statusenti0_ WHE
RE statusenti0_.STATUS_ID=?
11437 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for action NHibernate.Engine.CascadingAction+RefreshCascadingAction on ent
ity Storage.Server.Data.Storage.Entity.StatusEntity: SELECT statusenti0_.STATUS_
ID as STATUS1_3_0_, statusenti0_.STATUS as STATUS3_0_ FROM STATUS statusenti0_ W
HERE statusenti0_.STATUS_ID=?
11437 [12] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister (null) - St
atic SQL for entity: Storage.Server.Data.Storage.Entity.HordenEntity
11437 [12] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister (null) - V
ersion select: SELECT HORDE_ID FROM HORDEN WHERE HORDE_ID = ?
11437 [12] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister (null) - S
napshot select: SELECT hordenenti_.HORDE_ID, hordenenti_.HORDE_FREEPLACE as HORD
E2_4_, hordenenti_.HORDE_MAXPLACE as HORDE3_4_, hordenenti_.HORDE_SIZE as HORDE4
_4_, hordenenti_.HORDE_STATUS as HORDE5_4_ FROM HORDEN hordenenti_ WHERE hordene
nti_.HORDE_ID=?
11437 [12] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister (null) - I
nsert 0: NHibernate.SqlCommand.SqlCommandInfo
11437 [12] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister (null) - U
pdate 0: NHibernate.SqlCommand.SqlCommandInfo
11437 [12] DEBUG NHibernate.Persister.Entity.AbstractEntityPersister (null) - D
elete 0: NHibernate.SqlCommand.SqlCommandInfo
11437 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for entity Storage.Server.Data.Storage.Entity.HordenEntity: SELECT hordene
nti0_.HORDE_ID as HORDE1_4_0_, hordenenti0_.HORDE_FREEPLACE as HORDE2_4_0_, hord
enenti0_.HORDE_MAXPLACE as HORDE3_4_0_, hordenenti0_.HORDE_SIZE as HORDE4_4_0_,
hordenenti0_.HORDE_STATUS as HORDE5_4_0_ FROM HORDEN hordenenti0_ WHERE hordenen
ti0_.HORDE_ID=?
11437 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for entity Storage.Server.Data.Storage.Entity.HordenEntity: SELECT hordene
nti0_.HORDE_ID as HORDE1_4_0_, hordenenti0_.HORDE_FREEPLACE as HORDE2_4_0_, hord
enenti0_.HORDE_MAXPLACE as HORDE3_4_0_, hordenenti0_.HORDE_SIZE as HORDE4_4_0_,
hordenenti0_.HORDE_STATUS as HORDE5_4_0_ FROM HORDEN hordenenti0_ WHERE hordenen
ti0_.HORDE_ID=?
11437 [12] DEBUG NHibernate.SqlCommand.SqlSelectBuilder (null) - The initial cap
acity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of:
9 for the table HORDEN hordenenti0_
11437 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for entity Storage.Server.Data.Storage.Entity.HordenEntity: SELECT hordene
nti0_.HORDE_ID as HORDE1_4_0_, hordenenti0_.HORDE_FREEPLACE as HORDE2_4_0_, hord
enenti0_.HORDE_MAXPLACE as HORDE3_4_0_, hordenenti0_.HORDE_SIZE as HORDE4_4_0_,
hordenenti0_.HORDE_STATUS as HORDE5_4_0_ FROM HORDEN hordenenti0_ WHERE hordenen
ti0_.HORDE_ID=? for update
11453 [12] DEBUG NHibernate.SqlCommand.SqlSelectBuilder (null) - The initial cap
acity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of:
9 for the table HORDEN hordenenti0_
11453 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for entity Storage.Server.Data.Storage.Entity.HordenEntity: SELECT hordene
nti0_.HORDE_ID as HORDE1_4_0_, hordenenti0_.HORDE_FREEPLACE as HORDE2_4_0_, hord
enenti0_.HORDE_MAXPLACE as HORDE3_4_0_, hordenenti0_.HORDE_SIZE as HORDE4_4_0_,
hordenenti0_.HORDE_STATUS as HORDE5_4_0_ FROM HORDEN hordenenti0_ WHERE hordenen
ti0_.HORDE_ID=? for update nowait
11453 [12] DEBUG NHibernate.SqlCommand.SqlSelectBuilder (null) - The initial cap
acity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of:
9 for the table HORDEN hordenenti0_
11453 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for entity Storage.Server.Data.Storage.Entity.HordenEntity: SELECT hordene
nti0_.HORDE_ID as HORDE1_4_0_, hordenenti0_.HORDE_FREEPLACE as HORDE2_4_0_, hord
enenti0_.HORDE_MAXPLACE as HORDE3_4_0_, hordenenti0_.HORDE_SIZE as HORDE4_4_0_,
hordenenti0_.HORDE_STATUS as HORDE5_4_0_ FROM HORDEN hordenenti0_ WHERE hordenen
ti0_.HORDE_ID=? for update nowait
11453 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for action NHibernate.Engine.CascadingAction+MergeCascadingAction on entit
y Storage.Server.Data.Storage.Entity.HordenEntity: SELECT hordenenti0_.HORDE_ID
as HORDE1_4_0_, hordenenti0_.HORDE_FREEPLACE as HORDE2_4_0_, hordenenti0_.HORDE_
MAXPLACE as HORDE3_4_0_, hordenenti0_.HORDE_SIZE as HORDE4_4_0_, hordenenti0_.HO
RDE_STATUS as HORDE5_4_0_ FROM HORDEN hordenenti0_ WHERE hordenenti0_.HORDE_ID=?

11453 [12] DEBUG NHibernate.Loader.Entity.AbstractEntityLoader (null) - Static s
elect for action NHibernate.Engine.CascadingAction+RefreshCascadingAction on ent
ity Storage.Server.Data.Storage.Entity.HordenEntity: SELECT hordenenti0_.HORDE_I
D as HORDE1_4_0_, hordenenti0_.HORDE_FREEPLACE as HORDE2_4_0_, hordenenti0_.HORD
E_MAXPLACE as HORDE3_4_0_, hordenenti0_.HORDE_SIZE as HORDE4_4_0_, hordenenti0_.
HORDE_STATUS as HORDE5_4_0_ FROM HORDEN hordenenti0_ WHERE hordenenti0_.HORDE_ID
=?
11453 [12] DEBUG NHibernate.Impl.SessionFactoryImpl (null) - Instantiated sessio
n factory
11453 [12] DEBUG NHibernate.Impl.SessionFactoryImpl (null) - Checking 0 named HQ
L queries
11453 [12] DEBUG NHibernate.Impl.SessionFactoryImpl (null) - Checking 0 named SQ
L queries
11468 [12] DEBUG NHibernate.Impl.SessionImpl (null) - opened session
11484 [12] DEBUG NHibernate.Transaction.AdoTransaction (null) - Begin (Unspecifi
ed)
11484 [12] DEBUG NHibernate.Connection.DriverConnectionProvider (null) - Obtaini
ng IDbConnection from Driver
11890 [12] DEBUG NHibernate.AdoNet.AbstractBatcher (null) - Opened new IDbComman
d, open IDbCommands: 1
11890 [12] DEBUG NHibernate.AdoNet.AbstractBatcher (null) - Building an IDbComma
nd object for the SqlString: SELECT this_.STORAGE_ID as STORAGE1_2_0_, this_.ARE
A as AREA2_0_, this_.SIDE as SIDE2_0_, this_.SIZE as SIZE2_0_, this_.TOWER as TO
WER2_0_, this_.TRAY as TRAY2_0_ FROM STORAGE this_
11890 [12] INFO NHibernate.Loader.Loader (null) - SELECT this_.STORAGE_ID as STO
RAGE1_2_0_, this_.AREA as AREA2_0_, this_.SIDE as SIDE2_0_, this_.SIZE as SIZE2_
0_, this_.TOWER as TOWER2_0_, this_.TRAY as TRAY2_0_ FROM STORAGE this_
11890 [12] DEBUG NHibernate.SQL (null) - SELECT this_.STORAGE_ID as STORAGE1_2_0
_, this_.AREA as AREA2_0_, this_.SIDE as SIDE2_0_, this_.SIZE as SIZE2_0_, this_
.TOWER as TOWER2_0_, this_.TRAY as TRAY2_0_ FROM STORAGE this_
11890 [12] DEBUG NHibernate.Transaction.AdoTransaction (null) - Enlist Command
11922 [12] DEBUG NHibernate.Util.ADOExceptionReporter (null) - SQL Exception
System.Data.OracleClient.OracleException: ORA-01747: invalid user.table.column,
table.column, or column specification

at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorH
andle, Int32 rc)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statemen
tHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidD
escriptor, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statemen
tHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behav
ior)
at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior
behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) in D:\Proj
ekte\ExternalDLLs\hibernate\HibSrc\src\NHibernate\AdoNet\AbstractBatcher.cs:line
204
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverT
ypes, Boolean callable, RowSelection selection, ISessionImplementor session) in
D:\Projekte\ExternalDLLs\hibernate\HibSrc\src\NHibernate\Loader\Loader.cs:line 1
344
11937 [12] WARN NHibernate.Util.ADOExceptionReporter (null) - System.Data.Oracle
Client.OracleException: ORA-01747: invalid user.table.column, table.column, or c
olumn specification

at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorH
andle, Int32 rc)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statemen
tHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidD
escriptor, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statemen
tHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behav
ior)
at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior
behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) in D:\Proj
ekte\ExternalDLLs\hibernate\HibSrc\src\NHibernate\AdoNet\AbstractBatcher.cs:line
204
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverT
ypes, Boolean callable, RowSelection selection, ISessionImplementor session) in
D:\Projekte\ExternalDLLs\hibernate\HibSrc\src\NHibernate\Loader\Loader.cs:line 1
344
11953 [12] ERROR NHibernate.Util.ADOExceptionReporter (null) - ORA-01747: invali
d user.table.column, table.column, or column specification

11953 [12] DEBUG NHibernate.AdoNet.AbstractBatcher (null) - Closed IDbCommand, o
pen IDbCommands: 0
11953 [12] DEBUG NHibernate.Util.ADOExceptionReporter (null) - could not execute
query
[ SELECT this_.STORAGE_ID as STORAGE1_2_0_, this_.AREA as AREA2_0_, this_.SIDE a
s SIDE2_0_, this_.SIZE as SIZE2_0_, this_.TOWER as TOWER2_0_, this_.TRAY as TRAY
2_0_ FROM STORAGE this_ ]

System.Data.OracleClient.OracleException: ORA-01747: invalid user.table.column,
table.column, or column specification

at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorH
andle, Int32 rc)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statemen
tHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidD
escriptor, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statemen
tHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behav
ior)
at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior
behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) in D:\Proj
ekte\ExternalDLLs\hibernate\HibSrc\src\NHibernate\AdoNet\AbstractBatcher.cs:line
204
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverT
ypes, Boolean callable, RowSelection selection, ISessionImplementor session) in
D:\Projekte\ExternalDLLs\hibernate\HibSrc\src\NHibernate\Loader\Loader.cs:line 1
363
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParamet
ers queryParameters, Boolean returnProxies) in D:\Projekte\ExternalDLLs\hibernat
e\HibSrc\src\NHibernate\Loader\Loader.cs:line 411
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionIm
plementor session, QueryParameters queryParameters, Boolean returnProxies) in D:
\Projekte\ExternalDLLs\hibernate\HibSrc\src\NHibernate\Loader\Loader.cs:line 187

at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParamete
rs queryParameters) in D:\Projekte\ExternalDLLs\hibernate\HibSrc\src\NHibernate\
Loader\Loader.cs:line 1803
11968 [12] WARN NHibernate.Util.ADOExceptionReporter (null) - System.Data.Oracle
Client.OracleException: ORA-01747: invalid user.table.column, table.column, or c
olumn specification

at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorH
andle, Int32 rc)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statemen
tHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidD
escriptor, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statemen
tHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behav
ior)
at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior
behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) in D:\Proj
ekte\ExternalDLLs\hibernate\HibSrc\src\NHibernate\AdoNet\AbstractBatcher.cs:line
204
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverT
ypes, Boolean callable, RowSelection selection, ISessionImplementor session) in
D:\Projekte\ExternalDLLs\hibernate\HibSrc\src\NHibernate\Loader\Loader.cs:line 1
363
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParamet
ers queryParameters, Boolean returnProxies) in D:\Projekte\ExternalDLLs\hibernat
e\HibSrc\src\NHibernate\Loader\Loader.cs:line 411
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionIm
plementor session, QueryParameters queryParameters, Boolean returnProxies) in D:
\Projekte\ExternalDLLs\hibernate\HibSrc\src\NHibernate\Loader\Loader.cs:line 187

at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParamete
rs queryParameters) in D:\Projekte\ExternalDLLs\hibernate\HibSrc\src\NHibernate\
Loader\Loader.cs:line 1803
11968 [12] ERROR NHibernate.Util.ADOExceptionReporter (null) - ORA-01747: invali
d user.table.column, table.column, or column specification


Name and version of the database you are using:

Oracle 10g

Table:

Code:
CREATE TABLE "WAFERHANDLER"."STORAGE"
   (   "STORAGE_ID" NUMBER(*,0) NOT NULL ENABLE,
   "TOWER" NUMBER(*,0),
   "SIDE" VARCHAR2(4000 BYTE),
   "AREA" NUMBER(*,0),
   "TRAY" VARCHAR2(4000 BYTE),
   "SIZE" NUMBER(*,0),
    CONSTRAINT "STORAGE_PK" PRIMARY KEY ("STORAGE_ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "WAFERHANDLER"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "WAFERHANDLER" ;
Top
 Profile  
 
kumpfi
 Post subject: Re: ORA-01747: invalid -PROBLEM RESOLVED
PostPosted: Tue May 20, 2008 3:53 am 
Newbie

Joined: Thu May 08, 2008 3:14 am
Posts: 16
Hello i found the solution of my problem:

SIZE is a resserved word from oracle, but nhibernate didn't recognise this. I changed the name of the column on DB and storage.hbm.xml.

Problem is solved!
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 » NHibernate 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.