Apparently, DerbyDialect was defined to be a subclass of DB2Dialect so in
SQLFunctionsTest there's this line inside a DB2Dialect only block:
s.find("from Simple s where repeat('foo', 3) = 'foofoofoo'");
but apparently, "repeat" is not a function supported by Derby.
Here's the error log:
16:37:07,823 INFO Environment:443 - Hibernate 3.0 beta 1
16:37:07,823 INFO Environment:456 - hibernate.properties not found
16:37:07,839 INFO Environment:489 - using CGLIB reflection optimizer
16:37:07,839 INFO Environment:519 - using JDK 1.4 java.sql.Timestamp handling
16:37:07,948 INFO Configuration:408 - Mapping resource:
org/hibernate/test/legacy/AltSimple.hbm.xml
16:37:08,042 DEBUG DTDEntityResolver:42 - trying to locate
http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under
org/hibernate/
16:37:08,042 DEBUG DTDEntityResolver:50 - found
http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
16:37:08,276 INFO HbmBinder:445 - Mapping class:
org.hibernate.test.legacy.Simple -> SIMP
16:37:08,339 DEBUG HbmBinder:885 - Mapped property: name -> name
16:37:08,339 DEBUG HbmBinder:885 - Mapped property: address -> address
16:37:08,339 DEBUG HbmBinder:885 - Mapped property: count -> count_
16:37:08,339 DEBUG HbmBinder:885 - Mapped property: date -> date_
16:37:08,339 DEBUG HbmBinder:885 - Mapped property: pay -> pay
16:37:08,432 DEBUG HbmBinder:885 - Mapped property: other -> other
16:37:08,448 INFO Configuration:408 - Mapping resource:
org/hibernate/test/legacy/Broken.hbm.xml
16:37:08,448 DEBUG DTDEntityResolver:42 - trying to locate
http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under
org/hibernate/
16:37:08,448 DEBUG DTDEntityResolver:50 - found
http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
16:37:08,495 INFO HbmBinder:445 - Mapping class:
org.hibernate.test.legacy.Broken -> BROKE
16:37:08,510 DEBUG HbmBinder:885 - Mapped property: id -> id
16:37:08,510 DEBUG HbmBinder:885 - Mapped property: otherId -> otherId
16:37:08,510 DEBUG HbmBinder:885 - Mapped property: timestamp -> timestamp
16:37:08,589 INFO HbmBinder:395 - Mapping joined-subclass:
org.hibernate.test.legacy.Fixed -> FIX
16:37:08,604 DEBUG HbmBinder:885 - Mapped property: set
16:37:08,604 DEBUG HbmBinder:885 - Mapped property: list -> list
16:37:08,604 INFO Configuration:408 - Mapping resource:
org/hibernate/test/legacy/Blobber.hbm.xml
16:37:08,604 DEBUG DTDEntityResolver:42 - trying to locate
http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath under
org/hibernate/
16:37:08,620 DEBUG DTDEntityResolver:50 - found
http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd in classpath
16:37:08,651 INFO HbmBinder:445 - Mapping class:
org.hibernate.test.legacy.Blobber -> Blobber
16:37:08,651 DEBUG HbmBinder:885 - Mapped property: id -> id
16:37:08,651 DEBUG HbmBinder:885 - Mapped property: blob -> blob_
16:37:08,651 DEBUG HbmBinder:885 - Mapped property: clob -> clob_
16:37:08,667 INFO Dialect:90 - Using dialect:
org.hibernate.dialect.DerbyDialect
16:37:08,682 DEBUG Configuration:983 - Preparing to build session factory with
filters : {}
16:37:08,682 INFO Configuration:780 - processing extends queue
16:37:08,682 INFO Configuration:784 - processing collection mappings
16:37:08,682 DEBUG HbmBinder:2099 - Second pass for collection:
org.hibernate.test.legacy.Fixed.set
16:37:08,682 INFO HbmBinder:1723 - Mapping collection:
org.hibernate.test.legacy.Fixed.set -> BROKE
16:37:08,682 DEBUG HbmBinder:2113 - Mapped collection key: FIX_ID,
OTHER_FIX_ID, one-to-many: org.hibernate.test.legacy.Broken
16:37:08,698 INFO Configuration:793 - processing association property
references
16:37:08,714 INFO Configuration:820 - processing foreign key constraints
16:37:08,714 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Broken
16:37:08,714 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Simple
16:37:08,714 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Fixed
16:37:08,995 INFO Dialect:90 - Using dialect:
org.hibernate.dialect.DerbyDialect
16:37:08,995 DEBUG SQLExceptionConverterFactory:52 - Using dialect defined
converter
16:37:08,995 INFO SettingsFactory:97 - Generate SQL with comments: disabled
16:37:09,010 INFO SettingsFactory:101 - Order SQL updates by primary key:
disabled
16:37:09,010 INFO SettingsFactory:265 - Query translator:
org.hibernate.hql.classic.ClassicQueryTranslatorFactory
16:37:09,010 INFO SettingsFactory:109 - Query language substitutions: {}
16:37:09,026 INFO DriverManagerConnectionProvider:41 - Using Hibernate
built-in connection pool (not for production use!)
16:37:09,026 INFO DriverManagerConnectionProvider:42 - Hibernate connection
pool size: 20
16:37:09,026 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
16:37:09,573 INFO DriverManagerConnectionProvider:80 - using driver:
org.apache.derby.jdbc.EmbeddedDriver at URL: jdbc:derby:testDB10.1;create=true
16:37:09,573 INFO DriverManagerConnectionProvider:83 - connection properties:
{}
16:37:09,573 DEBUG DriverManagerConnectionProvider:93 - total checked-out
connections: 0
16:37:09,589 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC
connection
16:37:11,307 DEBUG DriverManagerConnectionProvider:115 - created connection to:
jdbc:derby:testDB10.1;create=true, Isolation Level: 2
16:37:11,323 DEBUG DriverManagerConnectionProvider:129 - returning connection
to pool, pool size: 1
16:37:11,323 INFO SettingsFactory:158 - Scrollable result sets: enabled
16:37:11,323 DEBUG SettingsFactory:162 - Wrap result sets: disabled
16:37:11,323 INFO SettingsFactory:166 - JDBC3 getGeneratedKeys(): enabled
16:37:11,339 INFO TransactionFactoryFactory:31 - Using default transaction
strategy (direct JDBC transactions)
16:37:11,339 INFO TransactionManagerLookupFactory:33 - No
TransactionManagerLookup configured (in JTA environment, use of read-write or
transactional second-level cache is not recommended)
16:37:11,339 INFO SettingsFactory:178 - Automatic flush during
beforeCompletion(): disabled
16:37:11,339 INFO SettingsFactory:181 - Automatic session close at end of
transaction: disabled
16:37:11,339 INFO SettingsFactory:252 - Cache provider:
org.hibernate.cache.EhCacheProvider
16:37:11,354 INFO SettingsFactory:189 - Second-level cache: enabled
16:37:11,354 INFO SettingsFactory:191 - Optimize cache for minimal puts:
disabled
16:37:11,354 INFO SettingsFactory:199 - Query cache: disabled
16:37:11,354 INFO SettingsFactory:210 - Statistics: disabled
16:37:11,354 INFO SettingsFactory:214 - Deleted entity synthetic identifier
rollback: disabled
16:37:11,401 INFO SessionFactoryImpl:133 - building session factory
16:37:11,401 DEBUG SessionFactoryImpl:142 - Session factory constructed with
filter configurations : {}
16:37:11,401 DEBUG SessionFactoryImpl:145 - instantiating session factory with
properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard
Edition, sun.boot.library.path=D:\j2sdk1.4.2_04\jre\bin,
java.vm.version=1.4.2_04-b05, java.vm.vendor=Sun Microsystems Inc.,
java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java
HotSpot(TM) Client VM, file.encoding.pkg=sun.io, idea.launcher.port=7535,
user.country=US, sun.os.patch.level=Service Pack 2,
java.vm.specification.name=Java Virtual Machine Specification,
user.dir=C:\Documents and Settings\dmclean\IdeaProjects\hibernate test,
java.runtime.version=1.4.2_04-b05,
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment,
java.endorsed.dirs=D:\j2sdk1.4.2_04\jre\lib\endorsed, os.arch=x86,
java.io.tmpdir=C:\DOCUME~1\dmclean\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=,
os.name=Windows XP, sun.java2d.fontpath=,
java.library.path=D:\j2sdk1.4.2_04\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program
Files\ATI Technologies\ATI Control Panel;D:\Program
Files\Sonic\MyDVD;C:\Program Files\Common Files\Sonic Shared;C:\Program
Files\Common Files\Roxio Shared\DLLShared, java.specification.name=Java
Platform API Specification, java.class.version=48.0,
java.util.prefs.PreferencesFactory=java.util.prefs.WindowsPreferencesFactory,
os.version=5.1, user.home=C:\Documents and Settings\dmclean,
user.timezone=America/New_York,
java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=windows-1252,
java.specification.version=1.4,
hibernate.connection.driver_class=org.apache.derby.jdbc.EmbeddedDriver,
java.class.path=D:\j2sdk1.4.2_04\jre\lib\charsets.jar;D:\j2sdk1.4.2_04\jre\lib\jce.jar;D:\j2sdk1.4.2_04\jre\lib\jsse.jar;D:\j2sdk1.4.2_04\jre\lib\plugin.jar;D:\j2sdk1.4.2_04\jre\lib\rt.jar;D:\j2sdk1.4.2_04\jre\lib\sunrsasign.jar;D:\j2sdk1.4.2_04\jre\lib\ext\dnsns.jar;D:\j2sdk1.4.2_04\jre\lib\ext\ldapsec.jar;D:\j2sdk1.4.2_04\jre\lib\ext\localedata.jar;D:\j2sdk1.4.2_04\jre\lib\ext\sunjce_provider.jar;C:\Documents
and Settings\dmclean\IdeaProjects\hibernate test\classes;D:\Program
Files\IBM\derby-snapshot\derby.jar;D:\Program
Files\IBM\derby-snapshot\derbytools.jar;D:\Program
Files\hibernate-3.0beta1\hibernate-3.0\hibernate3.jar;D:\idea\v4.5\lib\junit.jar;D:\Program
Files\hibernate-3.0beta1\hibernate-3.0\lib\antlr-2.7.4.jar;D:\Program
Files\hibernate-3.0beta1\hibernate-3.0\lib\commons-collections-2.1.1.jar;D:\Program
Files\hibernate-3.0beta1\hibernate-3.0\lib\commons-logging-1.0.4.jar;D:\Program
Files\hibernate-3.0beta1\hibernate-3.0\lib\cglib-full-2.0.2.jar;D:\Program
Files\hibernate-3.0beta1\hibernate-3.0\lib\dom4j-1.5.2.jar;D:\Program
Files\hibernate-3.0beta1\hibernate-3.0\lib\ehcache-1.1.jar;C:\Documents and
Settings\dmclean\IdeaProjects\APT\Libraries\j2ee.jar;D:\Program
Files\hibernate-3.0beta1\hibernate-3.0\lib\jaxen-1.1-beta-4.jar;C:\Documents
and Settings\dmclean\IdeaProjects\hibernate test;D:\Program
Files\logging-log4j-1.2.9\dist\lib\log4j-1.2.9.jar;D:\idea\v4.5\lib\idea_rt.jar,
user.name=dmclean, java.vm.specification.version=1.0,
java.home=D:\j2sdk1.4.2_04\jre, sun.arch.data.model=32,
hibernate.connection.url=jdbc:derby:testDB10.1;create=true,
hibernate.dialect=org.hibernate.dialect.DerbyDialect, user.language=en,
java.specification.vendor=Sun Microsystems Inc.,
awt.toolkit=sun.awt.windows.WToolkit,
hibernate.cglib.use_reflection_optimizer=true, java.vm.info=mixed mode,
java.version=1.4.2_04, java.ext.dirs=D:\j2sdk1.4.2_04\jre\lib\ext,
sun.boot.class.path=D:\j2sdk1.4.2_04\jre\lib\rt.jar;D:\j2sdk1.4.2_04\jre\lib\i18n.jar;D:\j2sdk1.4.2_04\jre\lib\sunrsasign.jar;D:\j2sdk1.4.2_04\jre\lib\jsse.jar;D:\j2sdk1.4.2_04\jre\lib\jce.jar;D:\j2sdk1.4.2_04\jre\lib\charsets.jar;D:\j2sdk1.4.2_04\jre\classes,
java.vendor=Sun Microsystems Inc., file.separator=\,
hibernate.hbm2ddl.auto=create-drop,
idea.launcher.library=D:\idea\v4.5\bin\breakgen.dll,
java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi,
sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little,
sun.cpu.isalist=pentium i486 i386}
16:37:11,464 WARN Configurator:126 - No configuration found. Configuring
ehcache from ehcache-failsafe.xml found in the classpath:
jar:file:/D:/Program%20Files/hibernate-3.0beta1/hibernate-3.0/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
16:37:11,510 DEBUG CacheFactory:39 - instantiating cache region:
org.hibernate.test.legacy.Simple usage strategy: nonstrict-read-write
16:37:11,510 WARN EhCacheProvider:97 - Could not find configuration
[org.hibernate.test.legacy.Simple]; using defaults.
16:37:11,557 DEBUG EhCacheProvider:100 - started EHCache region:
org.hibernate.test.legacy.Simple
16:37:11,620 DEBUG CacheFactory:39 - instantiating cache region:
org.hibernate.test.legacy.Broken usage strategy: nonstrict-read-write
16:37:11,635 WARN EhCacheProvider:97 - Could not find configuration
[org.hibernate.test.legacy.Broken]; using defaults.
16:37:11,635 DEBUG EhCacheProvider:100 - started EHCache region:
org.hibernate.test.legacy.Broken
16:37:11,667 DEBUG CacheFactory:39 - instantiating cache region:
org.hibernate.test.legacy.Fixed.set usage strategy: nonstrict-read-write
16:37:11,667 WARN EhCacheProvider:97 - Could not find configuration
[org.hibernate.test.legacy.Fixed.set]; using defaults.
16:37:11,667 DEBUG EhCacheProvider:100 - started EHCache region:
org.hibernate.test.legacy.Fixed.set
16:37:11,698 DEBUG AbstractCollectionPersister:404 - Static SQL for collection:
org.hibernate.test.legacy.Fixed.set
16:37:11,698 DEBUG AbstractCollectionPersister:405 - Row insert: update BROKE
set FIX_ID=?, OTHER_FIX_ID=? where id=? and otherId=?
16:37:11,698 DEBUG AbstractCollectionPersister:407 - Row delete: update BROKE
set FIX_ID=null, OTHER_FIX_ID=null where FIX_ID=? and OTHER_FIX_ID=? and id=?
and otherId=?
16:37:11,698 DEBUG AbstractCollectionPersister:408 - One-shot delete: update
BROKE set FIX_ID=null, OTHER_FIX_ID=null where FIX_ID=? and OTHER_FIX_ID=?
16:37:11,714 DEBUG BasicEntityPersister:2032 - Static SQL for entity:
org.hibernate.test.legacy.Simple
16:37:11,714 DEBUG BasicEntityPersister:2034 - Version select: select id_ from
SIMP where id_ =?
16:37:11,714 DEBUG BasicEntityPersister:2035 - Snapshot select: select
simple_.id_, simple_.name as name0_, simple_.address as address0_,
simple_.count_ as count_0_, simple_.date_ as date_0_, simple_.pay as pay0_,
simple_.other as other0_ from SIMP simple_ where simple_.id_=?
16:37:11,729 DEBUG BasicEntityPersister:2037 - Insert 0: insert into SIMP
(name, address, count_, date_, pay, other, id_) values (?, ?, ?, ?, ?, ?, ?)
16:37:11,729 DEBUG BasicEntityPersister:2038 - Update 0: update SIMP set
name=?, address=?, count_=?, date_=?, pay=?, other=? where id_=?
16:37:11,729 DEBUG BasicEntityPersister:2039 - Delete 0: delete from SIMP
where id_=?
16:37:11,792 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Simple: select simple0_.id_ as id_1_, simple0_.name
as name0_1_, simple0_.address as address0_1_, simple0_.count_ as count_0_1_,
simple0_.date_ as date_0_1_, simple0_.pay as pay0_1_, simple0_.other as
other0_1_, simple1_.id_ as id_0_, simple1_.name as name0_0_, simple1_.address
as address0_0_, simple1_.count_ as count_0_0_, simple1_.date_ as date_0_0_,
simple1_.pay as pay0_0_, simple1_.other as other0_0_ from SIMP simple0_ left
outer join SIMP simple1_ on simple0_.other=simple1_.id_ where simple0_.id_=?
16:37:11,792 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Simple: select simple0_.id_ as id_1_, simple0_.name
as name0_1_, simple0_.address as address0_1_, simple0_.count_ as count_0_1_,
simple0_.date_ as date_0_1_, simple0_.pay as pay0_1_, simple0_.other as
other0_1_, simple1_.id_ as id_0_, simple1_.name as name0_0_, simple1_.address
as address0_0_, simple1_.count_ as count_0_0_, simple1_.date_ as date_0_0_,
simple1_.pay as pay0_0_, simple1_.other as other0_0_ from SIMP simple0_ left
outer join SIMP simple1_ on simple0_.other=simple1_.id_ where simple0_.id_=?
16:37:11,807 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Simple: select simple0_.id_ as id_0_, simple0_.name
as name0_0_, simple0_.address as address0_0_, simple0_.count_ as count_0_0_,
simple0_.date_ as date_0_0_, simple0_.pay as pay0_0_, simple0_.other as
other0_0_ from SIMP simple0_ where simple0_.id_=? for update with rr
16:37:11,823 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Simple: select simple0_.id_ as id_0_, simple0_.name
as name0_0_, simple0_.address as address0_0_, simple0_.count_ as count_0_0_,
simple0_.date_ as date_0_0_, simple0_.pay as pay0_0_, simple0_.other as
other0_0_ from SIMP simple0_ where simple0_.id_=? for update with rr
16:37:11,823 DEBUG BasicEntityPersister:2032 - Static SQL for entity:
org.hibernate.test.legacy.Blobber
16:37:11,823 DEBUG BasicEntityPersister:2034 - Version select: select id from
Blobber where id =?
16:37:11,823 DEBUG BasicEntityPersister:2035 - Snapshot select: select
blobber_.id, blobber_.blob_ as blob_3_, blobber_.clob_ as clob_3_ from Blobber
blobber_ where blobber_.id=?
16:37:11,823 DEBUG BasicEntityPersister:2037 - Insert 0: insert into Blobber
(blob_, clob_, id) values (?, ?, ?)
16:37:11,823 DEBUG BasicEntityPersister:2038 - Update 0: update Blobber set
blob_=?, clob_=? where id=?
16:37:11,839 DEBUG BasicEntityPersister:2039 - Delete 0: delete from Blobber
where id=?
16:37:11,839 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Blobber: select blobber0_.id as id0_, blobber0_.blob_
as blob_3_0_, blobber0_.clob_ as clob_3_0_ from Blobber blobber0_ where
blobber0_.id=?
16:37:11,839 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Blobber: select blobber0_.id as id0_, blobber0_.blob_
as blob_3_0_, blobber0_.clob_ as clob_3_0_ from Blobber blobber0_ where
blobber0_.id=?
16:37:11,854 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Blobber: select blobber0_.id as id0_, blobber0_.blob_
as blob_3_0_, blobber0_.clob_ as clob_3_0_ from Blobber blobber0_ where
blobber0_.id=? for update with rr
16:37:11,854 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Blobber: select blobber0_.id as id0_, blobber0_.blob_
as blob_3_0_, blobber0_.clob_ as clob_3_0_ from Blobber blobber0_ where
blobber0_.id=? for update with rr
16:37:11,854 DEBUG BasicEntityPersister:2032 - Static SQL for entity:
org.hibernate.test.legacy.Broken
16:37:11,854 DEBUG BasicEntityPersister:2034 - Version select: select
"timestamp" from BROKE where id =? and otherId =?
16:37:11,854 DEBUG BasicEntityPersister:2035 - Snapshot select: select
broken_.id, broken_.otherId, broken_."timestamp" as y3_1_ from BROKE broken_
where broken_.id=? and broken_.otherId=?
16:37:11,870 DEBUG BasicEntityPersister:2037 - Insert 0: insert into BROKE
("timestamp", id, otherId) values (?, ?, ?)
16:37:11,870 DEBUG BasicEntityPersister:2038 - Update 0: update BROKE set
"timestamp"=? where id=? and otherId=? and "timestamp"=?
16:37:11,870 DEBUG BasicEntityPersister:2039 - Delete 0: delete from BROKE
where id=? and otherId=? and "timestamp"=?
16:37:11,870 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Broken: select broken0_.id as id0_, broken0_.otherId
as otherId0_, broken0_."timestamp" as y3_1_0_, broken0_1_.list as list2_0_,
case when broken0_1_.BROKE_ID is not null then 1 when broken0_.id is not null
then 0 else -1 end as clazz_0_ from BROKE broken0_ left outer join FIX
broken0_1_ on broken0_.id=broken0_1_.BROKE_ID and
broken0_.otherId=broken0_1_.OTHER_BROKE_ID where broken0_.id=? and
broken0_.otherId=?
16:37:11,870 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Broken: select broken0_.id as id0_, broken0_.otherId
as otherId0_, broken0_."timestamp" as y3_1_0_, broken0_1_.list as list2_0_,
case when broken0_1_.BROKE_ID is not null then 1 when broken0_.id is not null
then 0 else -1 end as clazz_0_ from BROKE broken0_ left outer join FIX
broken0_1_ on broken0_.id=broken0_1_.BROKE_ID and
broken0_.otherId=broken0_1_.OTHER_BROKE_ID where broken0_.id=? and
broken0_.otherId=?
16:37:11,885 DEBUG BasicEntityPersister:2032 - Static SQL for entity:
org.hibernate.test.legacy.Fixed
16:37:11,885 DEBUG BasicEntityPersister:2034 - Version select: select
"timestamp" from BROKE where id =? and otherId =?
16:37:11,885 DEBUG BasicEntityPersister:2035 - Snapshot select: select
fixed_.BROKE_ID, fixed_.OTHER_BROKE_ID, fixed_1_."timestamp" as y3_1_,
fixed_.list as list2_ from FIX fixed_ inner join BROKE fixed_1_ on
fixed_.BROKE_ID=fixed_1_.id and fixed_.OTHER_BROKE_ID=fixed_1_.otherId where
fixed_.BROKE_ID=? and fixed_.OTHER_BROKE_ID=?
16:37:11,885 DEBUG BasicEntityPersister:2037 - Insert 0: insert into BROKE
("timestamp", id, otherId) values (?, ?, ?)
16:37:11,885 DEBUG BasicEntityPersister:2038 - Update 0: update BROKE set
"timestamp"=? where id=? and otherId=? and "timestamp"=?
16:37:11,901 DEBUG BasicEntityPersister:2039 - Delete 0: delete from BROKE
where id=? and otherId=? and "timestamp"=?
16:37:11,901 DEBUG BasicEntityPersister:2037 - Insert 1: insert into FIX
(list, BROKE_ID, OTHER_BROKE_ID) values (?, ?, ?)
16:37:11,901 DEBUG BasicEntityPersister:2038 - Update 1: update FIX set list=?
where BROKE_ID=? and OTHER_BROKE_ID=?
16:37:11,901 DEBUG BasicEntityPersister:2039 - Delete 1: delete from FIX where
BROKE_ID=? and OTHER_BROKE_ID=?
16:37:11,901 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Fixed: select fixed0_.BROKE_ID as id0_,
fixed0_.OTHER_BROKE_ID as otherId0_, fixed0_1_."timestamp" as y3_1_0_,
fixed0_.list as list2_0_ from FIX fixed0_ inner join BROKE fixed0_1_ on
fixed0_.BROKE_ID=fixed0_1_.id and fixed0_.OTHER_BROKE_ID=fixed0_1_.otherId
where fixed0_.BROKE_ID=? and fixed0_.OTHER_BROKE_ID=?
16:37:11,917 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Fixed: select fixed0_.BROKE_ID as id0_,
fixed0_.OTHER_BROKE_ID as otherId0_, fixed0_1_."timestamp" as y3_1_0_,
fixed0_.list as list2_0_ from FIX fixed0_ inner join BROKE fixed0_1_ on
fixed0_.BROKE_ID=fixed0_1_.id and fixed0_.OTHER_BROKE_ID=fixed0_1_.otherId
where fixed0_.BROKE_ID=? and fixed0_.OTHER_BROKE_ID=?
16:37:11,917 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Fixed: select fixed0_.BROKE_ID as id0_,
fixed0_.OTHER_BROKE_ID as otherId0_, fixed0_1_."timestamp" as y3_1_0_,
fixed0_.list as list2_0_ from FIX fixed0_ inner join BROKE fixed0_1_ on
fixed0_.BROKE_ID=fixed0_1_.id and fixed0_.OTHER_BROKE_ID=fixed0_1_.otherId
where fixed0_.BROKE_ID=? and fixed0_.OTHER_BROKE_ID=? for update with rr
16:37:11,917 DEBUG EntityLoader:91 - Static select for entity
org.hibernate.test.legacy.Fixed: select fixed0_.BROKE_ID as id0_,
fixed0_.OTHER_BROKE_ID as otherId0_, fixed0_1_."timestamp" as y3_1_0_,
fixed0_.list as list2_0_ from FIX fixed0_ inner join BROKE fixed0_1_ on
fixed0_.BROKE_ID=fixed0_1_.id and fixed0_.OTHER_BROKE_ID=fixed0_1_.otherId
where fixed0_.BROKE_ID=? and fixed0_.OTHER_BROKE_ID=? for update with rr
16:37:11,932 DEBUG OneToManyLoader:94 - Static select for one-to-many
org.hibernate.test.legacy.Fixed.set: select set0_.FIX_ID as FIX_ID__,
set0_.OTHER_FIX_ID as OTHER_FI5___, set0_.id as id__, set0_.otherId as
otherId__, set0_.id as id0_, set0_.otherId as otherId0_, set0_."timestamp" as
y3_1_0_, set0_1_.list as list2_0_, case when set0_1_.BROKE_ID is not null then
1 when set0_.id is not null then 0 else -1 end as clazz_0_ from BROKE set0_
left outer join FIX set0_1_ on set0_.id=set0_1_.BROKE_ID and
set0_.otherId=set0_1_.OTHER_BROKE_ID where set0_.FIX_ID=? and
set0_.OTHER_FIX_ID=?
16:37:11,948 DEBUG SessionFactoryObjectFactory:39 - initializing class
SessionFactoryObjectFactory
16:37:11,948 DEBUG SessionFactoryObjectFactory:76 - registered:
c4b6d4ee01829b9c0101829b9efc0000 (unnamed)
16:37:11,948 INFO SessionFactoryObjectFactory:82 - Not binding factory to
JNDI, no JNDI name configured
16:37:11,948 DEBUG SessionFactoryImpl:237 - instantiated session factory
16:37:11,964 INFO Dialect:90 - Using dialect:
org.hibernate.dialect.DerbyDialect
16:37:11,964 INFO Configuration:780 - processing extends queue
16:37:11,964 INFO Configuration:784 - processing collection mappings
16:37:11,964 INFO Configuration:793 - processing association property
references
16:37:11,964 INFO Configuration:820 - processing foreign key constraints
16:37:11,964 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Broken
16:37:11,964 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Simple
16:37:11,964 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Fixed
16:37:11,979 INFO Configuration:780 - processing extends queue
16:37:11,979 INFO Configuration:784 - processing collection mappings
16:37:11,979 INFO Configuration:793 - processing association property
references
16:37:11,979 INFO Configuration:820 - processing foreign key constraints
16:37:11,979 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Broken
16:37:11,979 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Simple
16:37:11,979 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Fixed
16:37:11,995 INFO SchemaExport:100 - Running hbm2ddl schema export
16:37:11,995 INFO SchemaExport:121 - exporting generated schema to database
16:37:11,995 INFO DriverManagerConnectionProvider:41 - Using Hibernate
built-in connection pool (not for production use!)
16:37:11,995 INFO DriverManagerConnectionProvider:42 - Hibernate connection
pool size: 20
16:37:12,010 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
16:37:12,010 INFO DriverManagerConnectionProvider:80 - using driver:
org.apache.derby.jdbc.EmbeddedDriver at URL: jdbc:derby:testDB10.1;create=true
16:37:12,010 INFO DriverManagerConnectionProvider:83 - connection properties:
{}
16:37:12,010 DEBUG DriverManagerConnectionProvider:93 - total checked-out
connections: 0
16:37:12,010 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC
connection
16:37:12,010 DEBUG DriverManagerConnectionProvider:115 - created connection to:
jdbc:derby:testDB10.1;create=true, Isolation Level: 2
16:37:12,026 DEBUG SchemaExport:136 - alter table FIX drop constraint
FK10FF5DB75FB11
16:37:12,432 DEBUG SchemaExport:142 - Unsuccessful: alter table FIX drop
constraint FK10FF5DB75FB11
16:37:12,432 DEBUG SchemaExport:143 - 'ALTER TABLE' cannot be performed on
'FIX' because it does not exist.
16:37:12,448 DEBUG SchemaExport:136 - alter table SIMP drop constraint
FK26D6796527F10
16:37:12,448 DEBUG SchemaExport:142 - Unsuccessful: alter table SIMP drop
constraint FK26D6796527F10
16:37:12,448 DEBUG SchemaExport:143 - 'ALTER TABLE' cannot be performed on
'SIMP' because it does not exist.
16:37:12,448 DEBUG SchemaExport:136 - alter table BROKE drop constraint
FK3C88799D64F4F19
16:37:12,448 DEBUG SchemaExport:142 - Unsuccessful: alter table BROKE drop
constraint FK3C88799D64F4F19
16:37:12,448 DEBUG SchemaExport:143 - 'ALTER TABLE' cannot be performed on
'BROKE' because it does not exist.
16:37:12,464 DEBUG SchemaExport:136 - drop table FIX
16:37:12,479 DEBUG SchemaExport:142 - Unsuccessful: drop table FIX
16:37:12,479 DEBUG SchemaExport:143 - 'DROP TABLE' cannot be performed on 'FIX'
because it does not exist.
16:37:12,479 DEBUG SchemaExport:136 - drop table SIMP
16:37:12,479 DEBUG SchemaExport:142 - Unsuccessful: drop table SIMP
16:37:12,479 DEBUG SchemaExport:143 - 'DROP TABLE' cannot be performed on
'SIMP' because it does not exist.
16:37:12,479 DEBUG SchemaExport:136 - drop table Blobber
16:37:12,479 DEBUG SchemaExport:142 - Unsuccessful: drop table Blobber
16:37:12,479 DEBUG SchemaExport:143 - 'DROP TABLE' cannot be performed on
'BLOBBER' because it does not exist.
16:37:12,479 DEBUG SchemaExport:136 - drop table BROKE
16:37:12,495 DEBUG SchemaExport:142 - Unsuccessful: drop table BROKE
16:37:12,495 DEBUG SchemaExport:143 - 'DROP TABLE' cannot be performed on
'BROKE' because it does not exist.
16:37:12,495 DEBUG SchemaExport:136 - drop table next_hi
16:37:12,495 DEBUG SchemaExport:142 - Unsuccessful: drop table next_hi
16:37:12,510 DEBUG SchemaExport:143 - 'DROP TABLE' cannot be performed on
'NEXT_HI' because it does not exist.
16:37:12,510 DEBUG SchemaExport:154 - create table FIX (
BROKE_ID bigint not null,
OTHER_BROKE_ID varchar(255) not null,
list varchar(255) for bit data,
primary key (BROKE_ID, OTHER_BROKE_ID)
)
16:37:12,995 DEBUG SchemaExport:154 - create table SIMP (
id_ bigint not null,
name varchar(255),
address varchar(255),
count_ integer not null unique,
date_ timestamp,
pay float,
other bigint,
primary key (id_)
)
16:37:13,339 DEBUG SchemaExport:154 - create table Blobber (
id integer not null,
blob_ blob(255),
clob_ clob(255),
primary key (id)
)
16:37:13,557 DEBUG SchemaExport:154 - create table BROKE (id bigint not null,
otherId varchar(255) not null, "timestamp" timestamp not null, FIX_ID bigint,
OTHER_FIX_ID varchar(255), primary key (id, otherId))
16:37:13,792 DEBUG SchemaExport:154 - alter table FIX add constraint
FK10FF5DB75FB11 foreign key (BROKE_ID, OTHER_BROKE_ID) references BROKE
16:37:13,932 DEBUG SchemaExport:154 - alter table SIMP add constraint
FK26D6796527F10 foreign key (other) references SIMP
16:37:14,135 DEBUG SchemaExport:154 - alter table BROKE add constraint
FK3C88799D64F4F19 foreign key (FIX_ID, OTHER_FIX_ID) references FIX
16:37:14,339 DEBUG SchemaExport:154 - create table next_hi (
next_hi integer
)
16:37:14,417 DEBUG SchemaExport:154 - insert into next_hi values ( 0 )
16:37:14,682 INFO SchemaExport:166 - schema export complete
16:37:14,698 DEBUG JDBCExceptionReporter:26 - SQL Warning
SQL Warning: Database 'testDB10.1' not created, connection made to existing
database instead.
at
org.apache.derby.impl.jdbc.EmbedSQLWarning.newEmbedSQLWarning(EmbedSQLWarning.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at
org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at
org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at
org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:123)
at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:86)
at
org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:239)
at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:990)
at org.hibernate.test.TestCase.buildSessionFactory(TestCase.java:89)
at org.hibernate.test.TestCase.setUp(TestCase.java:112)
at junit.framework.TestCase.runBare(TestCase.java:125)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.textui.TestRunner.doRun(TestRunner.java:116)
at
com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57)
at junit.textui.TestRunner.start(TestRunner.java:172)
at
com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTestRunner2.java:23)
at
com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:97)
at
com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
16:37:14,714 WARN JDBCExceptionReporter:34 - SQL Warning: 10000, SQLState:
01J01
16:37:14,729 WARN JDBCExceptionReporter:35 - Database 'testDB10.1' not
created, connection made to existing database instead.
16:37:14,729 DEBUG DriverManagerConnectionProvider:129 - returning connection
to pool, pool size: 1
16:37:14,729 INFO DriverManagerConnectionProvider:147 - cleaning up connection
pool: jdbc:derby:testDB10.1;create=true
16:37:14,729 INFO Dialect:90 - Using dialect:
org.hibernate.dialect.DerbyDialect
16:37:14,729 INFO Configuration:780 - processing extends queue
16:37:14,729 INFO Configuration:784 - processing collection mappings
16:37:14,729 INFO Configuration:793 - processing association property
references
16:37:14,729 INFO Configuration:820 - processing foreign key constraints
16:37:14,745 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Broken
16:37:14,745 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Simple
16:37:14,745 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Fixed
16:37:14,745 INFO Configuration:780 - processing extends queue
16:37:14,745 INFO Configuration:784 - processing collection mappings
16:37:14,745 INFO Configuration:793 - processing association property
references
16:37:14,745 INFO Configuration:820 - processing foreign key constraints
16:37:14,745 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Broken
16:37:14,760 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Simple
16:37:14,760 DEBUG Configuration:863 - resolving reference to class:
org.hibernate.test.legacy.Fixed
16:37:14,760 INFO SessionFactoryImpl:356 - Checking 0 named queries
16:37:14,823 DEBUG SessionImpl:214 - opened session
16:37:14,823 DEBUG JDBCTransaction:38 - begin
16:37:14,823 DEBUG AbstractBatcher:377 - opening JDBC connection
16:37:14,823 DEBUG DriverManagerConnectionProvider:93 - total checked-out
connections: 0
16:37:14,823 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC
connection, pool size: 0
16:37:14,839 DEBUG JDBCTransaction:42 - current autocommit status: false
16:37:14,839 DEBUG DefaultSaveOrUpdateEventListener:148 - saving transient
instance
16:37:14,839 DEBUG AbstractSaveEventListener:122 - saving
[org.hibernate.test.legacy.Simple#10]
16:37:14,870 DEBUG SessionImpl:959 - find: from Simple s where repeat('foo', 3)
= 'foofoofoo'
16:37:14,901 DEBUG QueryTranslatorImpl:170 - compiling query
16:37:14,964 DEBUG AbstractFlushingEventListener:47 - flushing session
16:37:14,964 DEBUG AbstractFlushingEventListener:148 - Flushing entities and
processing referenced collections
16:37:14,964 DEBUG AbstractFlushingEventListener:184 - Processing unreferenced
collections
16:37:14,964 DEBUG AbstractFlushingEventListener:198 - Scheduling collection
removes/(re)creates/updates
16:37:14,964 DEBUG AbstractFlushingEventListener:73 - Flushed: 1 insertions, 0
updates, 0 deletions to 1 objects
16:37:14,979 DEBUG AbstractFlushingEventListener:79 - Flushed: 0 (re)creations,
0 updates, 0 removals to 0 collections
16:37:14,979 DEBUG Printer:78 - listing entities:
16:37:14,979 DEBUG Printer:85 - org.hibernate.test.legacy.Simple{other=null,
pay=null, address=null, date=null, count=0, name=Simple 1}
16:37:14,979 DEBUG ActionQueue:213 - changes must be flushed to space: SIMP
16:37:14,979 DEBUG DefaultAutoFlushEventListener:42 - Need to execute flush
16:37:14,979 DEBUG AbstractFlushingEventListener:248 - executing flush
16:37:14,979 DEBUG BasicEntityPersister:1639 - Inserting entity:
[org.hibernate.test.legacy.Simple#10]
16:37:14,995 DEBUG AbstractBatcher:252 - about to open PreparedStatement (open
PreparedStatements: 0, globally: 0)
16:37:14,995 DEBUG SQL:290 - insert into SIMP (name, address, count_, date_,
pay, other, id_) values (?, ?, ?, ?, ?, ?, ?)
16:37:14,995 DEBUG AbstractBatcher:341 - preparing statement
16:37:15,057 DEBUG BasicEntityPersister:1451 - Dehydrating entity:
[org.hibernate.test.legacy.Simple#10]
16:37:15,089 DEBUG AbstractBatcher:260 - about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
16:37:15,089 DEBUG AbstractBatcher:361 - closing statement
16:37:15,089 DEBUG AbstractFlushingEventListener:275 - post flush
16:37:15,104 DEBUG QueryTranslatorImpl:227 - HQL: from
org.hibernate.test.legacy.Simple s where repeat('foo', 3) = 'foofoofoo'
16:37:15,104 DEBUG QueryTranslatorImpl:228 - SQL: select simple0_.id_ as id_,
simple0_.name as name0_, simple0_.address as address0_, simple0_.count_ as
count_0_, simple0_.date_ as date_0_, simple0_.pay as pay0_, simple0_.other as
other0_ from SIMP simple0_ where (repeat('foo' , 3)='foofoofoo' )
16:37:15,104 DEBUG AbstractBatcher:252 - about to open PreparedStatement (open
PreparedStatements: 0, globally: 0)
16:37:15,120 DEBUG SQL:290 - select simple0_.id_ as id_, simple0_.name as
name0_, simple0_.address as address0_, simple0_.count_ as count_0_,
simple0_.date_ as date_0_, simple0_.pay as pay0_, simple0_.other as other0_
from SIMP simple0_ where (repeat('foo' , 3)='foofoofoo' )
16:37:15,120 DEBUG AbstractBatcher:341 - preparing statement
16:37:15,182 DEBUG JDBCExceptionReporter:49 - SQL Exception
ERROR 42Y03: 'REPEAT' is not recognized as a function or procedure.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at
org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(StaticMethodCallNode.java)
at
org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(JavaToSQLValueNode.java)
at
org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(BinaryOperatorNode.java)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(BinaryComparisonOperatorNode.java)
at
org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(DMLStatementNode.java)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java)
at
org.apache.derby.impl.sql.compile.ReadCursorNode.bind(ReadCursorNode.java)
at org.apache.derby.impl.sql.compile.CursorNode.bind(CursorNode.java)
at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java)
at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java)
at
org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:349)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:300)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:81)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:978)
at org.hibernate.loader.Loader.doQuery(Loader.java:346)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:193)
at org.hibernate.loader.Loader.doList(Loader.java:1303)
at org.hibernate.loader.Loader.list(Loader.java:1286)
at
org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:872)
at org.hibernate.impl.SessionImpl.find(SessionImpl.java:973)
at org.hibernate.impl.SessionImpl.find(SessionImpl.java:945)
at
org.hibernate.test.legacy.SQLFunctionsTest.testSQLFunctions(SQLFunctionsTest.java:315)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at junit.framework.TestCase.runTest(TestCase.java:154)
at org.hibernate.test.TestCase.runTest(TestCase.java:128)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.textui.TestRunner.doRun(TestRunner.java:116)
at
com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57)
at junit.textui.TestRunner.start(TestRunner.java:172)
at
com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTestRunner2.java:23)
at
com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:97)
at
com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
16:37:15,229 WARN JDBCExceptionReporter:57 - SQL Error: 20000, SQLState: 42Y03
16:37:15,229 ERROR JDBCExceptionReporter:58 - 'REPEAT' is not recognized as a
function or procedure.
16:37:15,245 DEBUG JDBCExceptionReporter:49 - could not execute query [select
simple0_.id_ as id_, simple0_.name as name0_, simple0_.address as address0_,
simple0_.count_ as count_0_, simple0_.date_ as date_0_, simple0_.pay as pay0_,
simple0_.other as other0_ from SIMP simple0_ where (repeat('foo' ,
3)='foofoofoo' )]
ERROR 42Y03: 'REPEAT' is not recognized as a function or procedure.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at
org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(StaticMethodCallNode.java)
at
org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(JavaToSQLValueNode.java)
at
org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(BinaryOperatorNode.java)
at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(BinaryComparisonOperatorNode.java)
at
org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(DMLStatementNode.java)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java)
at
org.apache.derby.impl.sql.compile.ReadCursorNode.bind(ReadCursorNode.java)
at org.apache.derby.impl.sql.compile.CursorNode.bind(CursorNode.java)
at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java)
at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java)
at
org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:349)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:300)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:81)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:978)
at org.hibernate.loader.Loader.doQuery(Loader.java:346)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:193)
at org.hibernate.loader.Loader.doList(Loader.java:1303)
at org.hibernate.loader.Loader.list(Loader.java:1286)
at
org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:872)
at org.hibernate.impl.SessionImpl.find(SessionImpl.java:973)
at org.hibernate.impl.SessionImpl.find(SessionImpl.java:945)
at
org.hibernate.test.legacy.SQLFunctionsTest.testSQLFunctions(SQLFunctionsTest.java:315)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at junit.framework.TestCase.runTest(TestCase.java:154)
at org.hibernate.test.TestCase.runTest(TestCase.java:128)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.textui.TestRunner.doRun(TestRunner.java:116)
at
com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57)
at junit.textui.TestRunner.start(TestRunner.java:172)
at
com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTestRunner2.java:23)
at
com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:97)
at
com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
16:37:15,323 WARN JDBCExceptionReporter:57 - SQL Error: 20000, SQLState: 42Y03
16:37:15,323 ERROR JDBCExceptionReporter:58 - 'REPEAT' is not recognized as a
function or procedure.
16:37:15,339 DEBUG SessionImpl:232 - closing session
16:37:15,339 DEBUG SessionImpl:311 - disconnecting session
16:37:15,339 DEBUG AbstractBatcher:392 - closing JDBC connection (open
PreparedStatements: 1, globally: 1) (open ResultSets: 0, globally: 0)
16:37:15,339 DEBUG JDBCExceptionReporter:26 - SQL Warning
SQL Warning: Database 'testDB10.1' not created, connection made to existing
database instead.
at
org.apache.derby.impl.jdbc.EmbedSQLWarning.newEmbedSQLWarning(EmbedSQLWarning.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at
org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at
org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:121)
at
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1367)
at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:989)
at org.hibernate.test.TestCase.buildSessionFactory(TestCase.java:89)
at org.hibernate.test.TestCase.setUp(TestCase.java:112)
at junit.framework.TestCase.runBare(TestCase.java:125)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.textui.TestRunner.doRun(TestRunner.java:116)
at
com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57)
at junit.textui.TestRunner.start(TestRunner.java:172)
at
com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTestRunner2.java:23)
at
com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:97)
at
com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
16:37:15,432 INFO DriverManagerConnectionProvider:147 - cleaning up connection
pool: jdbc:derby:testDB10.1;create=true
16:37:15,479 WARN JDBCExceptionReporter:34 - SQL Warning: 10000, SQLState:
01J01
16:37:15,479 WARN JDBCExceptionReporter:35 - Database 'testDB10.1' not
created, connection made to existing database instead.
16:37:15,495 DEBUG DriverManagerConnectionProvider:129 - returning connection
to pool, pool size: 1
16:37:15,495 INFO SessionFactoryImpl:713 - closing
16:37:15,495 INFO DriverManagerConnectionProvider:147 - cleaning up connection
pool: jdbc:derby:testDB10.1;create=true
16:37:15,510 INFO SchemaExport:100 - Running hbm2ddl schema export
16:37:15,510 INFO SchemaExport:121 - exporting generated schema to database
16:37:15,510 INFO DriverManagerConnectionProvider:41 - Using Hibernate
built-in connection pool (not for production use!)
16:37:15,510 INFO DriverManagerConnectionProvider:42 - Hibernate connection
pool size: 20
16:37:15,510 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
16:37:15,526 INFO DriverManagerConnectionProvider:80 - using driver:
org.apache.derby.jdbc.EmbeddedDriver at URL: jdbc:derby:testDB10.1;create=true
16:37:15,526 INFO DriverManagerConnectionProvider:83 - connection properties:
{}
16:37:15,526 DEBUG DriverManagerConnectionProvider:93 - total checked-out
connections: 0
16:37:15,526 DEBUG DriverManagerConnectionProvider:109 - opening new JDBC
connection
16:37:15,542 DEBUG DriverManagerConnectionProvider:115 - created connection to:
jdbc:derby:testDB10.1;create=true, Isolation Level: 2
16:37:15,542 DEBUG SchemaExport:136 - alter table FIX drop constraint
FK10FF5DB75FB11
16:37:15,589 DEBUG SchemaExport:136 - alter table SIMP drop constraint
FK26D6796527F10
16:37:15,667 DEBUG SchemaExport:136 - alter table BROKE drop constraint
FK3C88799D64F4F19
16:37:15,776 DEBUG SchemaExport:136 - drop table FIX
16:37:15,870 DEBUG SchemaExport:136 - drop table SIMP
16:37:16,073 DEBUG SchemaExport:136 - drop table Blobber
16:37:16,167 DEBUG SchemaExport:136 - drop table BROKE
16:37:16,260 DEBUG SchemaExport:136 - drop table next_hi
16:37:16,339 INFO SchemaExport:166 - schema export complete
16:37:16,339 DEBUG JDBCExceptionReporter:26 - SQL Warning
SQL Warning: Database 'testDB10.1' not created, connection made to existing
database instead.
at
org.apache.derby.impl.jdbc.EmbedSQLWarning.newEmbedSQLWarning(EmbedSQLWarning.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
at
org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
at
org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at
org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:123)
at org.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:95)
at
org.hibernate.impl.SessionFactoryImpl.close(SessionFactoryImpl.java:747)
at org.hibernate.test.TestCase.runTest(TestCase.java:152)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at junit.textui.TestRunner.doRun(TestRunner.java:116)
at
com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57)
at junit.textui.TestRunner.start(TestRunner.java:172)
at
com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTestRunner2.java:23)
at
com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:97)
at
com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
16:37:16,354 WARN JDBCExceptionReporter:34 - SQL Warning: 10000, SQLState:
01J01
16:37:16,370 WARN JDBCExceptionReporter:35 - Database 'testDB10.1' not
created, connection made to existing database instead.
16:37:16,370 DEBUG DriverManagerConnectionProvider:129 - returning connection
to pool, pool size: 1
16:37:16,370 INFO DriverManagerConnectionProvider:147 - cleaning up connection
pool: jdbc:derby:testDB10.1;create=true
org.hibernate.exception.SQLGrammarException: could not execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:59)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1306)
at org.hibernate.loader.Loader.list(Loader.java:1286)
at
org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:872)
at org.hibernate.impl.SessionImpl.find(SessionImpl.java:973)
at org.hibernate.impl.SessionImpl.find(SessionImpl.java:945)
at
org.hibernate.test.legacy.SQLFunctionsTest.testSQLFunctions(SQLFunctionsTest.java:315)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.hibernate.test.TestCase.runTest(TestCase.java:128)
at
com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: SQL Exception: 'REPEAT' is not recognized as a function or procedure.
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java)
at
org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:349)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:300)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:81)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:978)
at org.hibernate.loader.Loader.doQuery(Loader.java:346)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:193)
at org.hibernate.loader.Loader.doList(Loader.java:1303)
... 29 more
Process finished with exit code -1
