db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From acemcclou...@comcast.net
Subject Hibernate: problem two
Date Mon, 17 Jan 2005 21:41:31 GMT
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



Mime
View raw message