Menu
▾
▴
hibernate-issues
|
[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-470) SQL Exception using a Map within a component
From: <leg...@at...> - 2003-11-14 16:22:14
|
The following comment has been added to this issue:
Author: James Eitzmann
Created: Fri, 14 Nov 2003 10:21 AM
Body:
Program Output:
0 INFO [main] cfg.Environment - Hibernate 2.1 beta 5
10 INFO [main] cfg.Environment - hibernate.properties not found
30 INFO [main] cfg.Environment - using CGLIB reflection optimizer
70 INFO [main] cfg.Configuration - Configuration resource: /hibernate.c=
fg.xml
1924 DEBUG [main] util.DTDEntityResolver - trying to locate http://hiberna=
te.sourceforge.net/hibernate-configuration-2.0.dtd in classpath under net/s=
f/hibernate/
1934 DEBUG [main] util.DTDEntityResolver - found http://hibernate.sourcefo=
rge.net/hibernate-configuration-2.0.dtd in classpath
2384 DEBUG [main] cfg.Configuration - dialect=3Dnet.sf.hibernate.dialect.O=
racleDialect
2394 DEBUG [main] cfg.Configuration - show_sql=3Dtrue
2394 DEBUG [main] cfg.Configuration - use_outer_join=3Dtrue
2404 DEBUG [main] cfg.Configuration - java:comp/env/hibernate/SessionFacto=
ry<-org.dom4j.tree.DefaultAttribute@b02928 [Attribute: name resource value =
"test/hibernate/test.hbm.xml"]
2404 INFO [main] cfg.Configuration - Mapping resource: test/hibernate/tes=
t.hbm.xml
2444 DEBUG [main] util.DTDEntityResolver - trying to locate http://hiberna=
te.sourceforge.net/hibernate-mapping-2.0.dtd in classpath under net/sf/hibe=
rnate/
2465 DEBUG [main] util.DTDEntityResolver - found http://hibernate.sourcefo=
rge.net/hibernate-mapping-2.0.dtd in classpath
3877 INFO [main] cfg.Binder - Mapping class: test.hibernate.Test -> OBJEC=
T_STACKS
4548 DEBUG [main] cfg.Binder - Mapped property: id -> OBJECT_ID, type: str=
ing
4748 INFO [main] cfg.Binder - Mapping collection: test.hibernate.Test.tes=
tComponent.attrMap -> CONTENT_OBJECT_STORAGE_ATTR
4889 DEBUG [main] cfg.Binder - Mapped property: attrMap, type: java.util.M=
ap
6532 DEBUG [main] cfg.Binder - Mapped property: testComponent, type: test.=
hibernate.TestComponent
6532 INFO [main] cfg.Configuration - Configured SessionFactory: java:comp=
/env/hibernate/SessionFactory
6542 DEBUG [main] cfg.Configuration - properties: {java.runtime.name=3DJav=
a(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=3DC:\j=
ava\1.4.1\jre\bin, java.vm.version=3D1.4.1_02-b06, java.vm.vendor=3DSun Mic=
rosystems Inc., java.vendor.url=3Dhttp://java.sun.com/, path.separator=3D;,=
java.vm.name=3DJava HotSpot(TM) Client VM, file.encoding.pkg=3Dsun.io, use=
_outer_join=3Dtrue, user.country=3DUS, sun.os.patch.level=3DService Pack 4,=
java.vm.specification.name=3DJava Virtual Machine Specification, user.dir=
=3DC:\teams\test, java.runtime.version=3D1.4.1_02-b06, java.awt.graphicsenv=
=3Dsun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=3DC:\java\1.4.1\jre=
\lib\endorsed, os.arch=3Dx86, java.io.tmpdir=3DC:\DOCUME~1\jeitzman\LOCALS~=
1\Temp\, line.separator=3D
, java.vm.specification.vendor=3DSun Microsystems Inc., user.variant=3D, os=
.name=3DWindows 2000, sun.java2d.fontpath=3D, java.library.path=3DC:\java\1=
.4.1\bin;.;C:\winnt\system32;C:\winnt;C:\Perl\bin\;C:\cm\bin;C:\bin;C:\orac=
le\ora90\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\winnt\system32;C:\win=
nt;C:\PVCS\DIMENS~1\7.1\PROG;C:\winnt\System32\Wbem;c:\java\1.4.1\bin;C:\ja=
va\apache-ant-1.5.3-1\bin, java.specification.name=3DJava Platform API Spec=
ification, java.class.version=3D48.0, java.util.prefs.PreferencesFactory=3D=
java.util.prefs.WindowsPreferencesFactory, os.version=3D5.0, user.home=3DC:=
\Documents and Settings\jeitzman, user.timezone=3D, java.awt.printerjob=3Ds=
un.awt.windows.WPrinterJob, file.encoding=3DCp1252, java.specification.vers=
ion=3D1.4, show_sql=3Dtrue, user.name=3Djeitzman, java.class.path=3DC:\team=
s\test\classes;C:\teams\common\classes;C:\teams\common\lib\commons-collecti=
ons.jar;C:\teams\common\lib\log4j.jar;C:\teams\common\lib\commons-pool.jar;=
C:\teams\common\lib\commons-dbcp.jar;C:\teams\common\lib\commons-lang-2.0.j=
ar;C:\java\lib\classes12.jar;C:\teams\sdk\classes;C:\teams\sdk\lib\vbjorb.j=
ar;C:\teams\sdk\lib\activation.jar;C:\teams\sdk\lib\jhelp.jar;C:\teams\sdk\=
lib\mail.jar;C:\teams\sdk\lib\swingall.jar;C:\teams\sdk\lib\xerces.jar;C:\t=
eams\sdk\lib\Regexp.jar;C:\teams\sdk\lib\xml4j_2_0_15.jar;C:\teams\sdk\lib\=
Ftp.jar;C:\teams\sdk\lib\vbjapp.jar;C:\java\jboss-3.2.2RC4\client\jboss-j2e=
e.jar;C:\java\commons-lang-2.0\commons-lang-2.0.jar;C:\teams\sdk\lib\JConfi=
g.zip;C:\teams\sdk\lib\classes12.zip;C:\teams\server\classes;C:\teams\serve=
r\lib\activation.jar;C:\teams\server\lib\xml4j_2_0_15.jar;C:\teams\server\l=
ib\FPLibrary.jar;C:\teams\server\lib\vbjorb.jar;C:\teams\server\lib\Regexp.=
jar;C:\teams\server\lib\mail.jar;C:\teams\server\lib\vbjapp.jar;C:\java\hib=
ernate-2.1\hibernate2.jar;C:\java\hibernate-2.1\lib\dom4j.jar;C:\java\hiber=
nate-2.1\lib\cglib-asm.jar;C:\java\hibernate-2.1\lib\commons-lang.jar;C:\ja=
va\hibernate-2.1\lib\commons-logging.jar;C:\java\hibernate-2.1\lib\odmg.jar=
, hibernate.show_sql=3Dtrue, java.vm.specification.version=3D1.0, java.home=
=3DC:\java\1.4.1\jre, sun.arch.data.model=3D32, hibernate.dialect=3Dnet.sf.=
hibernate.dialect.OracleDialect, user.language=3Den, java.specification.ven=
dor=3DSun Microsystems Inc., awt.toolkit=3Dsun.awt.windows.WToolkit, hibern=
ate.cglib.use_reflection_optimizer=3Dtrue, java.vm.info=3Dmixed mode, java.=
version=3D1.4.1_02, java.ext.dirs=3DC:\java\1.4.1\jre\lib\ext, sun.boot.cla=
ss.path=3DC:\java\1.4.1\jre\lib\rt.jar;C:\java\1.4.1\jre\lib\i18n.jar;C:\ja=
va\1.4.1\jre\lib\sunrsasign.jar;C:\java\1.4.1\jre\lib\jsse.jar;C:\java\1.4.=
1\jre\lib\jce.jar;C:\java\1.4.1\jre\lib\charsets.jar;C:\java\1.4.1\jre\clas=
ses, java.vendor=3DSun Microsystems Inc., file.separator=3D\, hibernate.ses=
sion_factory_name=3Djava:comp/env/hibernate/SessionFactory, java.vendor.url=
.bug=3Dhttp://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=
=3DUnicodeLittle, sun.cpu.endian=3Dlittle, hibernate.use_outer_join=3Dtrue,=
dialect=3Dnet.sf.hibernate.dialect.OracleDialect, sun.cpu.isalist=3Dpentiu=
m i486 i386}
6562 INFO [main] cfg.Configuration - processing one-to-many association m=
appings
6562 DEBUG [main] cfg.Binder - Second pass for collection: test.hibernate.=
Test.testComponent.attrMap
6582 DEBUG [main] cfg.Binder - Mapped collection key: OBJECT_ID, index: AT=
TR_NAME, element: ATTR_VALUE, type: string
6582 INFO [main] cfg.Configuration - processing one-to-one association pr=
operty references
6582 INFO [main] cfg.Configuration - processing foreign key constraints
6582 DEBUG [main] cfg.Configuration - resolving reference to class: test.h=
ibernate.Test
6822 INFO [main] dialect.Dialect - Using dialect: net.sf.hibernate.dialec=
t.OracleDialect
6842 INFO [main] cfg.SettingsFactory - Use outer join fetching: true
6872 WARN [main] connection.UserSuppliedConnectionProvider - No connectio=
n properties specified - the user must supply JDBC connections
6952 INFO [main] transaction.TransactionManagerLookupFactory - No Transac=
tionManagerLookup configured (in JTA environment, use of process level read=
-write cache is not recommended)
6952 INFO [main] cfg.SettingsFactory - Use scrollable result sets: false
6962 INFO [main] cfg.SettingsFactory - JDBC 2 max batch size: 15
6962 INFO [main] cfg.SettingsFactory - echoing all SQL to stdout
6962 INFO [main] cfg.SettingsFactory - Query language substitutions: {}
6962 INFO [main] cfg.SettingsFactory - cache provider: net.sf.hibernate.c=
ache.JCSCacheProvider
7002 INFO [main] cfg.Configuration - instantiating and configuring caches
7233 INFO [main] impl.SessionFactoryImpl - building session factory
7243 DEBUG [main] impl.SessionFactoryImpl - instantiating session factory =
with properties: {java.runtime.name=3DJava(TM) 2 Runtime Environment, Stand=
ard Edition, sun.boot.library.path=3DC:\java\1.4.1\jre\bin, java.vm.version=
=3D1.4.1_02-b06, java.vm.vendor=3DSun Microsystems Inc., java.vendor.url=3D=
http://java.sun.com/, path.separator=3D;, java.vm.name=3DJava HotSpot(TM) C=
lient VM, file.encoding.pkg=3Dsun.io, use_outer_join=3Dtrue, user.country=
=3DUS, sun.os.patch.level=3DService Pack 4, java.vm.specification.name=3DJa=
va Virtual Machine Specification, user.dir=3DC:\teams\test, java.runtime.ve=
rsion=3D1.4.1_02-b06, java.awt.graphicsenv=3Dsun.awt.Win32GraphicsEnvironme=
nt, java.endorsed.dirs=3DC:\java\1.4.1\jre\lib\endorsed, os.arch=3Dx86, jav=
a.io.tmpdir=3DC:\DOCUME~1\jeitzman\LOCALS~1\Temp\, line.separator=3D
, java.vm.specification.vendor=3DSun Microsystems Inc., user.variant=3D, os=
.name=3DWindows 2000, sun.java2d.fontpath=3D, java.library.path=3DC:\java\1=
.4.1\bin;.;C:\winnt\system32;C:\winnt;C:\Perl\bin\;C:\cm\bin;C:\bin;C:\orac=
le\ora90\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\winnt\system32;C:\win=
nt;C:\PVCS\DIMENS~1\7.1\PROG;C:\winnt\System32\Wbem;c:\java\1.4.1\bin;C:\ja=
va\apache-ant-1.5.3-1\bin, java.specification.name=3DJava Platform API Spec=
ification, java.class.version=3D48.0, java.util.prefs.PreferencesFactory=3D=
java.util.prefs.WindowsPreferencesFactory, os.version=3D5.0, user.home=3DC:=
\Documents and Settings\jeitzman, user.timezone=3D, java.awt.printerjob=3Ds=
un.awt.windows.WPrinterJob, file.encoding=3DCp1252, java.specification.vers=
ion=3D1.4, show_sql=3Dtrue, user.name=3Djeitzman, java.class.path=3DC:\team=
s\test\classes;C:\teams\common\classes;C:\teams\common\lib\commons-collecti=
ons.jar;C:\teams\common\lib\log4j.jar;C:\teams\common\lib\commons-pool.jar;=
C:\teams\common\lib\commons-dbcp.jar;C:\teams\common\lib\commons-lang-2.0.j=
ar;C:\java\lib\classes12.jar;C:\teams\sdk\classes;C:\teams\sdk\lib\vbjorb.j=
ar;C:\teams\sdk\lib\activation.jar;C:\teams\sdk\lib\jhelp.jar;C:\teams\sdk\=
lib\mail.jar;C:\teams\sdk\lib\swingall.jar;C:\teams\sdk\lib\xerces.jar;C:\t=
eams\sdk\lib\Regexp.jar;C:\teams\sdk\lib\xml4j_2_0_15.jar;C:\teams\sdk\lib\=
Ftp.jar;C:\teams\sdk\lib\vbjapp.jar;C:\java\jboss-3.2.2RC4\client\jboss-j2e=
e.jar;C:\java\commons-lang-2.0\commons-lang-2.0.jar;C:\teams\sdk\lib\JConfi=
g.zip;C:\teams\sdk\lib\classes12.zip;C:\teams\server\classes;C:\teams\serve=
r\lib\activation.jar;C:\teams\server\lib\xml4j_2_0_15.jar;C:\teams\server\l=
ib\FPLibrary.jar;C:\teams\server\lib\vbjorb.jar;C:\teams\server\lib\Regexp.=
jar;C:\teams\server\lib\mail.jar;C:\teams\server\lib\vbjapp.jar;C:\java\hib=
ernate-2.1\hibernate2.jar;C:\java\hibernate-2.1\lib\dom4j.jar;C:\java\hiber=
nate-2.1\lib\cglib-asm.jar;C:\java\hibernate-2.1\lib\commons-lang.jar;C:\ja=
va\hibernate-2.1\lib\commons-logging.jar;C:\java\hibernate-2.1\lib\odmg.jar=
, hibernate.show_sql=3Dtrue, java.vm.specification.version=3D1.0, java.home=
=3DC:\java\1.4.1\jre, sun.arch.data.model=3D32, hibernate.dialect=3Dnet.sf.=
hibernate.dialect.OracleDialect, user.language=3Den, java.specification.ven=
dor=3DSun Microsystems Inc., awt.toolkit=3Dsun.awt.windows.WToolkit, hibern=
ate.cglib.use_reflection_optimizer=3Dtrue, java.vm.info=3Dmixed mode, java.=
version=3D1.4.1_02, java.ext.dirs=3DC:\java\1.4.1\jre\lib\ext, sun.boot.cla=
ss.path=3DC:\java\1.4.1\jre\lib\rt.jar;C:\java\1.4.1\jre\lib\i18n.jar;C:\ja=
va\1.4.1\jre\lib\sunrsasign.jar;C:\java\1.4.1\jre\lib\jsse.jar;C:\java\1.4.=
1\jre\lib\jce.jar;C:\java\1.4.1\jre\lib\charsets.jar;C:\java\1.4.1\jre\clas=
ses, java.vendor=3DSun Microsystems Inc., file.separator=3D\, hibernate.ses=
sion_factory_name=3Djava:comp/env/hibernate/SessionFactory, java.vendor.url=
.bug=3Dhttp://java.sun.com/cgi-bin/bugreport.cgi, sun.io.unicode.encoding=
=3DUnicodeLittle, sun.cpu.endian=3Dlittle, hibernate.use_outer_join=3Dtrue,=
dialect=3Dnet.sf.hibernate.dialect.OracleDialect, sun.cpu.isalist=3Dpentiu=
m i486 i386}
9527 DEBUG [main] impl.SessionFactoryObjectFactory - initializing class Se=
ssionFactoryObjectFactory
9557 DEBUG [main] impl.SessionFactoryObjectFactory - registered: 8a81814ef=
8dafdab00f8dafdb4a80000 (java:comp/env/hibernate/SessionFactory)
9567 INFO [main] impl.SessionFactoryObjectFactory - Factory name: java:co=
mp/env/hibernate/SessionFactory
9577 INFO [main] util.NamingHelper - JNDI InitialContext properties:{}
9597 DEBUG [main] util.NamingHelper - binding: java:comp/env/hibernate/Ses=
sionFactory
9627 WARN [main] impl.SessionFactoryObjectFactory - Could not bind factor=
y to JNDI
javax.naming.NoInitialContextException: Need to specify class name in envir=
onment or system property, or as an applet parameter, or in an application =
resource file: java.naming.factory.initial
=09at javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:6=
40)
=09at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:243=
)
=09at javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.jav=
a:280)
=09at javax.naming.InitialContext.getNameParser(InitialContext.java:429)
=09at net.sf.hibernate.util.NamingHelper.bind(NamingHelper.java:52)
=09at net.sf.hibernate.impl.SessionFactoryObjectFactory.addInstance(Session=
FactoryObjectFactory.java:90)
=09at net.sf.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.ja=
va:171)
=09at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.=
java:718)
=09at test.hibernate.Test.main(Test.java:31)
9657 DEBUG [main] impl.SessionFactoryImpl - instantiated session factory
11360 DEBUG [main] impl.SessionImpl - opened session
16338 DEBUG [main] impl.SessionImpl - find by criteria: [net.sf.hibernate.i=
mpl.CriteriaImpl$CriterionEntry@1759d12]
16348 DEBUG [main] impl.SessionImpl - flushing session
16359 DEBUG [main] impl.SessionImpl - Flushing entities and processing refe=
renced collections
16359 DEBUG [main] impl.SessionImpl - Processing unreferenced collections
16359 DEBUG [main] impl.SessionImpl - Scheduling collection removes/(re)cre=
ates/updates
16359 DEBUG [main] impl.SessionImpl - Flushed: 0 insertions, 0 updates, 0 d=
eletions to 0 objects
16359 DEBUG [main] impl.SessionImpl - Flushed: 0 (re)creations, 0 updates, =
0 removals to 0 collections
16449 DEBUG [main] impl.SessionImpl - Dont need to execute flush
16479 DEBUG [main] impl.BatcherImpl - about to open: 0 open PreparedStateme=
nts, 0 open ResultSets
16479 DEBUG [main] impl.BatcherImpl - prepared statement get: select this.O=
BJECT_ID as OBJECT_ID0_ from OBJECT_STACKS this, CONTENT_OBJECT_STORAGE_ATT=
R attrmap1_ where this.OBJECT_ID in (?) and this.OBJECT_ID=3Dattrmap1_.OBJE=
CT_ID(+)
Hibernate: select this.OBJECT_ID as OBJECT_ID0_ from OBJECT_STACKS this, CO=
NTENT_OBJECT_STORAGE_ATTR attrmap1_ where this.OBJECT_ID in (?) and this.OB=
JECT_ID=3Dattrmap1_.OBJECT_ID(+)
16489 DEBUG [main] impl.BatcherImpl - preparing statement
16599 DEBUG [main] type.StringType - binding 'e6656575d7c572592316a2d41bbc4=
f0a68a7140f' to parameter: 1
16649 DEBUG [main] loader.Loader - processing result set
16649 DEBUG [main] type.StringType - returning 'e6656575d7c572592316a2d41bb=
c4f0a68a7140f' as column: OBJECT_ID0_
16649 DEBUG [main] loader.Loader - result row: e6656575d7c572592316a2d41bbc=
4f0a68a7140f
16659 DEBUG [main] loader.Loader - Initializing object from ResultSet: e665=
6575d7c572592316a2d41bbc4f0a68a7140f
16669 DEBUG [main] loader.Loader - Hydrating entity: test.hibernate.Test#e6=
656575d7c572592316a2d41bbc4f0a68a7140f
16929 DEBUG [main] util.JDBCExceptionReporter - SQL Exception
java.sql.SQLException: Invalid column name
=09at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
=09at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
=09at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
=09at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.j=
ava:5278)
=09at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl=
.java:698)
=09at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:150=
5)
=09at net.sf.hibernate.type.StringType.get(StringType.java:14)
=09at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62)
=09at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53)
=09at net.sf.hibernate.collection.AbstractCollectionPersister.readKey(Abstr=
actCollectionPersister.java:401)
=09at net.sf.hibernate.loader.Loader.readCollectionElement(Loader.java:233)
=09at net.sf.hibernate.loader.Loader.doResultSet(Loader.java:195)
=09at net.sf.hibernate.loader.Loader.doFind(Loader.java:111)
=09at net.sf.hibernate.loader.Loader.find(Loader.java:731)
=09at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:109)
=09at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3544)
=09at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:177)
=09at test.hibernate.Test.main(Test.java:39)
16940 WARN [main] util.JDBCExceptionReporter - SQL Error: 17006, SQLState:=
null
16940 ERROR [main] util.JDBCExceptionReporter - Invalid column name
17000 DEBUG [main] impl.BatcherImpl - done closing: 0 open PreparedStatemen=
ts, 0 open ResultSets
17010 DEBUG [main] impl.BatcherImpl - closing statement
17030 DEBUG [main] util.JDBCExceptionReporter - SQL Exception
java.sql.SQLException: Invalid column name
=09at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
=09at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
=09at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
=09at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.j=
ava:5278)
=09at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl=
.java:698)
=09at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:150=
5)
=09at net.sf.hibernate.type.StringType.get(StringType.java:14)
=09at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62)
=09at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53)
=09at net.sf.hibernate.collection.AbstractCollectionPersister.readKey(Abstr=
actCollectionPersister.java:401)
=09at net.sf.hibernate.loader.Loader.readCollectionElement(Loader.java:233)
=09at net.sf.hibernate.loader.Loader.doResultSet(Loader.java:195)
=09at net.sf.hibernate.loader.Loader.doFind(Loader.java:111)
=09at net.sf.hibernate.loader.Loader.find(Loader.java:731)
=09at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:109)
=09at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3544)
=09at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:177)
=09at test.hibernate.Test.main(Test.java:39)
17040 WARN [main] util.JDBCExceptionReporter - SQL Error: 17006, SQLState:=
null
17050 ERROR [main] util.JDBCExceptionReporter - Invalid column name
17050 ERROR [main] util.JDBCExceptionReporter - SQLException occurred
java.sql.SQLException: Invalid column name
=09at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
=09at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
=09at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
=09at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.j=
ava:5278)
=09at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl=
.java:698)
=09at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:150=
5)
=09at net.sf.hibernate.type.StringType.get(StringType.java:14)
=09at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62)
=09at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53)
=09at net.sf.hibernate.collection.AbstractCollectionPersister.readKey(Abstr=
actCollectionPersister.java:401)
=09at net.sf.hibernate.loader.Loader.readCollectionElement(Loader.java:233)
=09at net.sf.hibernate.loader.Loader.doResultSet(Loader.java:195)
=09at net.sf.hibernate.loader.Loader.doFind(Loader.java:111)
=09at net.sf.hibernate.loader.Loader.find(Loader.java:731)
=09at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:109)
=09at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3544)
=09at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:177)
=09at test.hibernate.Test.main(Test.java:39)
net.sf.hibernate.JDBCException: SQLException occurred
=09at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3547)
=09at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:177)
=09at test.hibernate.Test.main(Test.java:39)
Caused by: java.sql.SQLException: Invalid column name
=09at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
=09at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
=09at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
=09at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.j=
ava:5278)
=09at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl=
.java:698)
=09at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:150=
5)
=09at net.sf.hibernate.type.StringType.get(StringType.java:14)
=09at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62)
=09at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53)
=09at net.sf.hibernate.collection.AbstractCollectionPersister.readKey(Abstr=
actCollectionPersister.java:401)
=09at net.sf.hibernate.loader.Loader.readCollectionElement(Loader.java:233)
=09at net.sf.hibernate.loader.Loader.doResultSet(Loader.java:195)
=09at net.sf.hibernate.loader.Loader.doFind(Loader.java:111)
=09at net.sf.hibernate.loader.Loader.find(Loader.java:731)
=09at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:109)
=09at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3544)
=09... 2 more
Exception in thread "main"=20
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?=
key=3DHB-470
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-470
Summary: SQL Exception using a Map within a component
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Components:=20
core
Versions:
2.1 beta 5
Assignee:=20
Reporter: James Eitzmann
Created: Fri, 14 Nov 2003 10:17 AM
Updated: Fri, 14 Nov 2003 10:18 AM
Environment: nt 2000, oracle 8.1.7, 1.4.1 sdk
Description:
I have a map within a component. When I run a query, I get an SQL exception=
: "Invalid Column Name". It appears that the SQL hibernate is generating is=
not including the columns from the mapping table. This works fine in 2.0.3=
.
Mapping doc:
<?xml version=3D"1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class=20
=09name=3D"test.hibernate.Test"=20
=09table=3D"OBJECT_STACKS"
=09dynamic-update=3D"true"
=09>
=09<id name=3D"id" column=3D"OBJECT_ID" type=3D"string">
<generator class=3D"com.artesia.server.common.TeamsIdGenerator"/>
</id>
<component=20
name=3D"testComponent"=20
class=3D"test.hibernate.TestComponent"
insert=3D"false"
update=3D"true"
>
<map
=09 name=3D"attrMap"
=09 table=3D"CONTENT_OBJECT_STORAGE_ATTR"
=09 outer-join=3D"true"
=09 batch-size=3D"16"
=09 >
=09 <key column=3D"OBJECT_ID"/>
=09 <index column=3D"ATTR_NAME" type=3D"string"/>
=09 <element column=3D"ATTR_VALUE" type=3D"string"/>
=09 </map>
=09</component>
</class>
</hibernate-mapping>
Code:
package test.hibernate;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.ArrayList;
import java.util.List;
import net.sf.hibernate.Criteria;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;
import net.sf.hibernate.expression.Expression;
import oracle.jdbc.driver.OracleDriver;
/**
*=20
*=20
*/
public class Test
{
private String _id;
private TestComponent _testComponent;
=20
=09public static void main(String[] args) throws Exception
=09{
=09=09DriverManager.registerDriver(new OracleDriver());
=09=09Connection con =3D
=09=09=09DriverManager.getConnection("jdbc:oracle:oci8:@j817", "j_adm", "j_=
adm");
=09=09SessionFactory sf =3D new Configuration().configure().buildSessionFac=
tory();
=09=09Session s =3D sf.openSession(con);
=09=09ArrayList contentIdList =3D new ArrayList(1);
=09=09contentIdList.add("e6656575d7c572592316a2d41bbc4f0a68a7140f");
=09=09Criteria c =3D s.createCriteria(Test.class);
=09=09c.add(Expression.in("id", contentIdList));
=09=09List infoList =3D c.list();
=09}
=20
=09/**
=09 * @return Returns the id.
=09 */
=09public String getId()
=09{
=09=09return _id;
=09}
=09/**
=09 * @param id The id to set.
=09 */
=09public void setId(String id)
=09{
=09=09_id =3D id;
=09}
=09/**
=09 * @return Returns the testComponent.
=09 */
=09public TestComponent getTestComponent()
=09{
=09=09return _testComponent;
=09}
=09/**
=09 * @param testComponent The testComponent to set.
=09 */
=09public void setTestComponent(TestComponent testComponent)
=09{
=09=09_testComponent =3D testComponent;
=09}
}
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators=
.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-470) SQL Exception using a Map within a component
From: <leg...@at...> - 2003-11-14 16:33:13
|
The following comment has been added to this issue:
Author: Gavin King
Created: Fri, 14 Nov 2003 10:32 AM
Body:
Please resubmit this as a properly-packaged test case in a runnable form. TIA.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-470
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-470
Summary: SQL Exception using a Map within a component
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Components:
core
Versions:
2.1 beta 5
Assignee:
Reporter: James Eitzmann
Created: Fri, 14 Nov 2003 10:17 AM
Updated: Fri, 14 Nov 2003 10:18 AM
Environment: nt 2000, oracle 8.1.7, 1.4.1 sdk
Description:
I have a map within a component. When I run a query, I get an SQL exception: "Invalid Column Name". It appears that the SQL hibernate is generating is not including the columns from the mapping table. This works fine in 2.0.3.
Mapping doc:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class
name="test.hibernate.Test"
table="OBJECT_STACKS"
dynamic-update="true"
>
<id name="id" column="OBJECT_ID" type="string">
<generator class="com.artesia.server.common.TeamsIdGenerator"/>
</id>
<component
name="testComponent"
class="test.hibernate.TestComponent"
insert="false"
update="true"
>
<map
name="attrMap"
table="CONTENT_OBJECT_STORAGE_ATTR"
outer-join="true"
batch-size="16"
>
<key column="OBJECT_ID"/>
<index column="ATTR_NAME" type="string"/>
<element column="ATTR_VALUE" type="string"/>
</map>
</component>
</class>
</hibernate-mapping>
Code:
package test.hibernate;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.ArrayList;
import java.util.List;
import net.sf.hibernate.Criteria;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;
import net.sf.hibernate.expression.Expression;
import oracle.jdbc.driver.OracleDriver;
/**
*
*
*/
public class Test
{
private String _id;
private TestComponent _testComponent;
public static void main(String[] args) throws Exception
{
DriverManager.registerDriver(new OracleDriver());
Connection con =
DriverManager.getConnection("jdbc:oracle:oci8:@j817", "j_adm", "j_adm");
SessionFactory sf = new Configuration().configure().buildSessionFactory();
Session s = sf.openSession(con);
ArrayList contentIdList = new ArrayList(1);
contentIdList.add("e6656575d7c572592316a2d41bbc4f0a68a7140f");
Criteria c = s.createCriteria(Test.class);
c.add(Expression.in("id", contentIdList));
List infoList = c.list();
}
/**
* @return Returns the id.
*/
public String getId()
{
return _id;
}
/**
* @param id The id to set.
*/
public void setId(String id)
{
_id = id;
}
/**
* @return Returns the testComponent.
*/
public TestComponent getTestComponent()
{
return _testComponent;
}
/**
* @param testComponent The testComponent to set.
*/
public void setTestComponent(TestComponent testComponent)
{
_testComponent = testComponent;
}
}
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-470) SQL Exception using a Map within a component
From: <leg...@at...> - 2003-11-14 16:35:13
|
The following comment has been added to this issue:
Author: Gavin King
Created: Fri, 14 Nov 2003 10:34 AM
Body:
oh there are attachments there. They got pushed off the browser page.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-470
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-470
Summary: SQL Exception using a Map within a component
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Components:
core
Versions:
2.1 beta 5
Assignee:
Reporter: James Eitzmann
Created: Fri, 14 Nov 2003 10:17 AM
Updated: Fri, 14 Nov 2003 10:18 AM
Environment: nt 2000, oracle 8.1.7, 1.4.1 sdk
Description:
I have a map within a component. When I run a query, I get an SQL exception: "Invalid Column Name". It appears that the SQL hibernate is generating is not including the columns from the mapping table. This works fine in 2.0.3.
Mapping doc:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class
name="test.hibernate.Test"
table="OBJECT_STACKS"
dynamic-update="true"
>
<id name="id" column="OBJECT_ID" type="string">
<generator class="com.artesia.server.common.TeamsIdGenerator"/>
</id>
<component
name="testComponent"
class="test.hibernate.TestComponent"
insert="false"
update="true"
>
<map
name="attrMap"
table="CONTENT_OBJECT_STORAGE_ATTR"
outer-join="true"
batch-size="16"
>
<key column="OBJECT_ID"/>
<index column="ATTR_NAME" type="string"/>
<element column="ATTR_VALUE" type="string"/>
</map>
</component>
</class>
</hibernate-mapping>
Code:
package test.hibernate;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.ArrayList;
import java.util.List;
import net.sf.hibernate.Criteria;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.cfg.Configuration;
import net.sf.hibernate.expression.Expression;
import oracle.jdbc.driver.OracleDriver;
/**
*
*
*/
public class Test
{
private String _id;
private TestComponent _testComponent;
public static void main(String[] args) throws Exception
{
DriverManager.registerDriver(new OracleDriver());
Connection con =
DriverManager.getConnection("jdbc:oracle:oci8:@j817", "j_adm", "j_adm");
SessionFactory sf = new Configuration().configure().buildSessionFactory();
Session s = sf.openSession(con);
ArrayList contentIdList = new ArrayList(1);
contentIdList.add("e6656575d7c572592316a2d41bbc4f0a68a7140f");
Criteria c = s.createCriteria(Test.class);
c.add(Expression.in("id", contentIdList));
List infoList = c.list();
}
/**
* @return Returns the id.
*/
public String getId()
{
return _id;
}
/**
* @param id The id to set.
*/
public void setId(String id)
{
_id = id;
}
/**
* @return Returns the testComponent.
*/
public TestComponent getTestComponent()
{
return _testComponent;
}
/**
* @param testComponent The testComponent to set.
*/
public void setTestComponent(TestComponent testComponent)
{
_testComponent = testComponent;
}
}
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X