CHS
Introduction
CHS is a showcase of the integration between Cocoon, Hibernate and Spring.
This component is made available outside of the main Cocoon CVS repository because it relies on Hibernate which is LGPL licensed and as such cannot be added to Apache's CVS repository.
Howto (for Cocoon 2.1.6)
- Configure local.blocks.properties and make sure that the "forms" block is included and the "hsqldb" block is excluded.
- Configure local.build.properties and make sure that the
exclude.validate.jars=true line is not commented.
- From your Cocoon 2.1 working directory, go to src/blocks.
- Fetch the source code from SVN: svn co http://svn.cocoondev.org/repos/chs/spring.
- Paste the contents of the spring/jars-snippet.xml file into the lib/jars.xml file under the root of the Cocoon working directory.
- Paste the following element in the gump.xml file under the root of the Cocoon working directory:
<project name="cocoon-block-spring" status="unstable">
<package>org.apache.cocoon</package>
<ant target="gump-block">
<property name="block-name" value="spring"/>
<property name="version" value="@@DATE@@"/>
</ant>
<depend project="cocoon" inherit="all"/>
<library name="aopalliance"/>
<library name="c3p0"/>
<library name="cglib-full"/>
<library name="commons-dbcp"/>
<library name="commons-pool"/>
<library name="connector"/>
<library name="dom4j"/>
<library name="jta"/>
<library name="odmg"/>
<library name="proxool"/>
<library name="spring-aop"/>
<library name="spring-context"/>
<library name="spring-core"/>
<library name="spring-dao"/>
<library name="spring-orm"/>
<library name="spring-web"/>
<library name="hsqldb"/>
<library name="hibernate2"/>
<work nested="tools/anttasks"/>
<home nested="build/cocoon-@@DATE@@"/>
<jar name="blocks/spring-block.jar"/>
<nag from="Gump" to="dev@cocoon.apache.org"/>
</project>
Now you can build Cocoon as usual.
You can find the Spring Petstore sample under http://localhost:8888/samples/blocks/spring/
Project resources
- Mailing list: http://lists.cocoondev.org/mailman/listinfo
- SVN: http://svn.cocoondev.org/repos/chs/


I made the following changes from what appears here:
1) The file to change in step 1 is local.blocks.properties
2) From the jar.xml changes on the referred page, the spring-web entry needs to have the ".jar" extension added.
3) At this point, the cocoon build fails with "File optional/aopalliance.jar is declared in lib/jars.xml, but doesn't appear in the lib/ directory".
I tried copying the JAR files into the optional/lib directory manually, but got errors that spring/lib JAR files were present but not in jars.xml.
So I deleted the copied JARS back out of optional/lib and changed the jars.xml entries to point to spring/lib/*.jar.
4) Finally, several JAR files that are in spring/lib are missing entries for jars.xml. If they are not included, the build.sh process fails:
commons-dbcp-1.1.jar
commons-pool-1.1.jar
xdoclet-1.2.1.jar
xdoclet-hibernate-module-1.2.1.jar
xdoclet-xdoclet-module-1.2.1.jar
xjavadoc-1.0.3.jar
After this, cocoon builds but doesn't run. When I try to start up cocoon, I get:
WARN!! ERROR@file:/home/pedxing/cocoon-2.1.6/build/webapp/WEB-INF/web.xml line:727 col:11 : org.xml.sax.SAXParseException: The content of element type "web-app" must match "(icon?, ...
Needless to say, line 727 column 11 is just beyond the end of the well-formed, validated file.
Does anyone have any suggestions? What should I have done to make this work with cocoon 2.1.6?
Thanks for spotting the errors and let me know if there are still problems.
Thanks,
Dustin
I just tried installing the CHS block again (as apparently I had deleted the Cocoon build where I had managed to get it built before, which was from a few months back...)
I have the same problems Bruce did. This is on a fresh download of the cocoon-2.1.6 tarball and following your instructions to the letter.
Just before this, I had gone down the same path as Bruce, copying jars by hand, then having to add missing entries to jars.xml, and finally hitting what I decided was a dead end (the complaints about things in spring/lib present but not named in jars.xml).
So, like I said, I deleted eveything and rebuilt from scratch using fresh downloads and making sure to follow your instructions verbatim. So, things don't look fixed to me! :-/
Please advise!
? mark
WRT fetching lazy collections with size(), you are right, it's just that I started with that and then discovered how easier it is with OpenSessionInViewFilter, but I never went back to eliminate that code.
WARN!! ERROR@file:/home/pedxing/cocoon-2.1.6/build/webapp/WEB-INF/web.xml line:727 col:11 : org.xml.sax.SAXParseException: The content of element type "web-app" must match "(icon?, ...
I did everything on a clean Cocoon source.
Does it have to be done that way? If I want to use the Hibernate SchemExport and SchemaUpdate tools from Ant, then I have to have a plain old hibernate.properties or hibernate.cfg.xml file anway...
Also, CHS would not start in Cocoon 2.1.7, so I backed out asm-1.5.2.jar and asm-util-1.5.2.jar to asm-1.4.3.jar and asm-util-1.4.3.jar. Then the app loaded and worked fine in Tomcat 5.0.
Still errors out with the web-app error seen above in Jetty.
THe order is
context-params
filters
filer-mappings
filters
servlets
for example the xweb for the context param may look like:
<xweb xpath="/web-app"
unless="context-param/param-name[. = 'contextConfigLocation']"
insert-after="context-param[position() = last()]"
>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>
classpath:org/codehaus/xfire/spring/xfire.xml,
classpath:conf/spring/dao.xml
</param-value>
</context-param>
</xweb>
The xweb for the filter may look like:
<xweb xpath="/web-app"
unless="filter/filter-name[. = 'HibernateSessionInViewFilter']"
insert-after="filter[position() = last()]"
>
<filter>
<filter-name>HibernateSessionInViewFilter</filter-name>
<filter-class>org.springframework.orm.hibernate3.support.OpenSessionInViewFilter</filter-class>
<init-param>
<param-name>sessionFactoryBeanName</param-name>
<param-value>dbSessionFactory</param-value>
</init-param>
</filter>
</xweb>
and so on...
Hope this helps :)
servlet-mappings
i tried to compile chs with cocoon 2.1.7 but received out of heap mem errors (see below).
Seems I have a misconfiguration since there should not be the need to compile 5514 sources. Can you help?
Greetings,
Mitja
cocoon-block-spring-compile:
Compiling 5514 source files to C:\Java\cocoon\cocoon-2.1.7\build\cocoon-2.1.7\bl
ocks\spring\dest
The system is out of resources.
Consult the following stack trace for details.
java.lang.OutOfMemoryError: Java heap space
BUILD FAILED
C:\Java\cocoon\cocoon-2.1.7\tools\targets\compile-build.xml:244: The following e
rror occurred while executing this line:
C:\Java\cocoon\cocoon-2.1.7\build\cocoon-2.1.7\temp\blocks-build.xml:2822: The f
ollowing error occurred while executing this line:
C:\Java\cocoon\cocoon-2.1.7\build\cocoon-2.1.7\temp\blocks-build.xml:85: Compile
failed; see the compiler error output for details.
- Memory problem was due to missing dir="src/blocks/spring" (see Buzz Gundersons post)
- Jetty start problems were solved by Rolf Kulemanns hint. I used comments to enforce the order of appearance. Also I had to change src/blocks/faces/conf/faces-listener.xweb since it enlisted itself atop of the config. This is an example of my xweb insert-after entries:
<xweb xpath="/web-app"
unless="filter/filter-name[. = 'OpenSessionInViewFilter']"
insert-after="comment()[contains(., 'xweb filter configuration')]">
These are the comments that need to be placed in src/webapp/WEB-INF/web.xml:
<!-- xweb icon configuration -->
<!-- xweb display-name configuration -->
<!-- xweb description configuration -->
<!-- xweb distributable configuration -->
<!-- xweb context-param configuration -->
<!-- xweb filter configuration -->
<!-- xweb filter-mapping configuration -->
<!-- xweb listener configuration -->
<!-- xweb servlet configuration -->
<!-- xweb servlet-mapping configuration -->
<!-- xweb session-config configuration -->
<!-- xweb mime-mapping configuration -->
<!-- xweb welcome-file-list configuration -->
<!-- xweb error-page configuration -->
<!-- xweb taglib configuration -->
<!-- xweb resource-env-ref configuration -->
<!-- xweb resource-ref configuration -->
<!-- xweb security-constraint configuration -->
<!-- xweb login-config configuration -->
<!-- xweb security-role configuration -->
<!-- xweb env-entry configuration -->
<!-- xweb ejb-ref configuration -->
<!-- xweb ejb-local-ref configuration -->
- Also I made the mistake to move jar files. These need to stay where they are in order to generate the hibernate mappings.
- Finally: be sure to exchange asm and asm-util jars as Buzz said.
Ugo: Thank you for this integration example.
Greetings,
Mitja
It seems there is a general issue with patching together web.xml if more and more blocks require entries in web.xml.
Does anyone have a good solution.
Also I still seem to have another issue. I had to replace the asm and asm-util jars. Cocoon 2.1.8 is at 2.0 now, I had to put 1.4.3 back in and I wonder why.
Now I can see the shop, but all product lists are empty and I get lots of Exceptions when I start Cocoon (built-in Jetty). I guess this is related, or did I overlook any initial DB population mechanism?
Need to research this later ...
Does anyone care for a patch once I got this working again? It took me quite some time to grasp that mechaism with using XML comments as anchors for the XPatch tasks. It works fine, I just didn't get what was mean straight in the first place.
Besides the following exceptions that I just ignored, all of the above discussed about splitting up the xweb file, replacing the asm files, etc. still remains valid.
-------------------- Loading --------------------
Processing repository: .\tools\jetty\lib,.\lib\endorsed
-------------------- Executing -----------------
Main Class: org.mortbay.jetty.Server
14:03:36.875 EVENT Checking Resource aliases
14:03:37.625 EVENT Starting Jetty/4.2.23
14:03:41.906 EVENT Started WebApplicationContext[/,./build/webapp]
14:03:42.375 EVENT Loading root WebApplicationContext
INFO [main] (XmlBeanDefinitionReader.java:116) - Loading XML bean definitions from class path resource [org/apache/cocoon/petstore/spring/applicationContext.xml]
INFO [main] (AbstractXmlApplicationContext.java:67) - Bean factory for application context [Root XmlWebApplicationContext]: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [hsqlServer,myDataSource,sessionFactory,transactionManager,categoryDAO,productDAO,itemDAO,supplierDAO,userDAO,stateCountryDAO,orderDAO,petStoreServiceTarget,petStoreService]; Root of BeanFactory hierarchy
INFO [main] (AbstractApplicationContext.java:262) - 13 beans defined in ApplicationContext [Root XmlWebApplicationContext]
INFO [main] (AbstractApplicationContext.java:354) - No MessageSource found for context [Root XmlWebApplicationContext]: using empty default
INFO [main] (AbstractApplicationContext.java:371) - No ApplicationEventMulticaster found for context [Root XmlWebApplicationContext]: using default
INFO [main] (UiApplicationContextUtils.java:67) - No ThemeSource found for [Root XmlWebApplicationContext]: using ResourceBundleThemeSource
INFO [main] (AbstractApplicationContext.java:391) - Refreshing listeners
INFO [main] (DefaultListableBeanFactory.java:221) - Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [hsqlServer,myDataSource,sessionFactory,transactionManager,categoryDAO,productDAO,itemDAO,supplierDAO,userDAO,stateCountryDAO,orderDAO,petStoreServiceTarget,petStoreService]; Root of BeanFactory hierarchy]
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'hsqlServer'
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'myDataSource'
Starting HSQL server...
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'sessionFactory'
[Server@787d6a]: [Thread[hsqldb server,5,main]]: checkRunning(false) entered
[Server@787d6a]: [Thread[hsqldb server,5,main]]: checkRunning(false) exited
[Server@787d6a]: Startup sequence initiated from main() method
[Server@787d6a]: Loaded properties from [C:\src\cocoon-2.1.8\server.properties]
[Server@787d6a]: Initiating startup sequence...
INFO [main] (Environment.java:462) - Hibernate 2.1.4
INFO [main] (Environment.java:491) - hibernate.properties not found
INFO [main] (Environment.java:522) - using CGLIB reflection optimizer
[Server@787d6a]: Server socket opened successfully in 281 ms.
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.Account -> Usertable
[Server@787d6a]: Database [index=0, id=0, db=file:C:\src\cocoon-2.1.8\build\webapp\WEB-INF\db\cocoondb, alias=] opened sucessfully in 938 ms.
[Server@787d6a]: Startup sequence completed in 1250 ms.
[Server@787d6a]: 2005-11-30 14:03:45.156 HSQLDB server 1.8.0 is online
[Server@787d6a]: To close normally, connect and execute SHUTDOWN SQL
[Server@787d6a]: From command line, use [Ctrl]+[C] to abort abruptly
INFO [main] (Binder.java:560) - Mapping collection: org.apache.cocoon.petstore.model.Account.groups -> Membership
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.Billing -> Billing
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.Category -> Category
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.Country -> Country
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.Group -> Grouptable
INFO [main] (Binder.java:560) - Mapping collection: org.apache.cocoon.petstore.model.Group.users -> Membership
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.Inventory -> Inventory
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.Item -> Item
INFO [main] (Binder.java:560) - Mapping collection: org.apache.cocoon.petstore.model.Item.attributes -> ItemAttributes
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.LineItem -> LineItem
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.Order -> Orders
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.Product -> Product
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.Shipping -> Shipping
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.State -> State
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.Supplier -> Supplier
INFO [main] (Binder.java:229) - Mapping class: org.apache.cocoon.petstore.model.User -> Usertable
INFO [main] (Binder.java:560) - Mapping collection: org.apache.cocoon.petstore.model.User.groups -> Membership
INFO [main] (LocalSessionFactoryBean.java:403) - Building new Hibernate SessionFactory
INFO [main] (Configuration.java:613) - processing one-to-many association mappings
INFO [main] (Binder.java:1168) - Mapping collection: org.apache.cocoon.petstore.model.Category.products -> Product
INFO [main] (Binder.java:1168) - Mapping collection: org.apache.cocoon.petstore.model.Order.lineItems -> LineItem
INFO [main] (Binder.java:1168) - Mapping collection: org.apache.cocoon.petstore.model.Product.items -> Item
INFO [main] (Configuration.java:622) - processing one-to-one association property references
INFO [main] (Configuration.java:647) - processing foreign key constraints
INFO [main] (Dialect.java:82) - Using dialect: net.sf.hibernate.dialect.HSQLDialect
INFO [main] (SettingsFactory.java:62) - Use outer join fetching: false
INFO [main] (ConnectionProviderFactory.java:53) - Initializing connection provider: org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
INFO [main] (TransactionManagerLookupFactory.java:33) - No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended)
INFO [main] (SettingsFactory.java:102) - Use scrollable result sets: true
INFO [main] (SettingsFactory.java:105) - Use JDBC3 getGeneratedKeys(): false
INFO [main] (SettingsFactory.java:108) - Optimize cache for minimal puts: false
INFO [main] (SettingsFactory.java:117) - Query language substitutions: {}
INFO [main] (SettingsFactory.java:128) - cache provider: net.sf.ehcache.hibernate.Provider
INFO [main] (Configuration.java:1093) - instantiating and configuring caches
WARN [main] (Configurator.java:126) - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/C:/src/cocoon-2.1.8/build/webapp/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Group. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Shipping. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.State. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.User.groups. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.LineItem. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Inventory. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Category.products. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Category. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Item.attributes. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Account.groups. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Account. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Order.lineItems. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Group.users. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.User. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Supplier. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Order. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Product.items. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Country. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Product. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Item. Configuring using the defaultCache settings.
WARN [main] (Plugin.java:96) - Could not find configuration for org.apache.cocoon.petstore.model.Billing. Configuring using the defaultCache settings.
INFO [main] (SessionFactoryImpl.java:119) - building session factory
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.Billing, BulkBeanException: Property is private (property setOrder)
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.Category, BulkBeanException: Property is private (property setProducts)
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.Shipping, IllegalArgumentException: Cannot find matching method/constructor
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.Product, BulkBeanException: Property is private (property setItems)
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.User, IllegalArgumentException: Cannot find matching method/constructor
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.Inventory, BulkBeanException: Property is private (property setItem)
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.Account, IllegalArgumentException: Cannot find matching method/constructor
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.Item, BulkBeanException: Property is private (property setInventory)
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.Order, BulkBeanException: Property is private (property setAccount)
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.LineItem, BulkBeanException: Property is private (property setOrder)
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.Group, BulkBeanException: Property is private (property setGroupname)
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.Supplier, IllegalArgumentException: Cannot find matching method/constructor
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.Country, BulkBeanException: Property is private (property setName)
INFO [main] (ReflectHelper.java:176) - reflection optimizer disabled for: org.apache.cocoon.petstore.model.State, BulkBeanException: Property is private (property setName)
INFO [main] (SessionFactoryObjectFactory.java:82) - no JNDI name configured
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'transactionManager'
INFO [main] (HibernateTransactionManager.java:328) - Using DataSource [org.apache.commons.dbcp.BasicDataSource@17b40fe] of Hibernate SessionFactory for HibernateTransactionManager
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'categoryDAO'
INFO [main] (XmlBeanDefinitionReader.java:116) - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'DB2'
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'HSQL'
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'MS-SQL'
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'MySQL'
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'Oracle'
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'Informix'
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'PostgreSQL'
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'Sybase'
INFO [main] (SQLErrorCodesFactory.java:167) - SQLErrorCodes loaded: [HSQL Database Engine, Oracle, Sybase SQL Server, Microsoft SQL Server, Informix Dynamic Server, PostgreSQL, DB2*, MySQL]
INFO [main] (SQLErrorCodesFactory.java:197) - Looking up default SQLErrorCodes for DataSource
INFO [main] (SQLErrorCodesFactory.java:263) - Database Product Name is HSQL Database Engine
INFO [main] (SQLErrorCodesFactory.java:264) - Driver Version is 1.8.0
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'productDAO'
INFO [main] (SQLErrorCodesFactory.java:197) - Looking up default SQLErrorCodes for DataSource
INFO [main] (SQLErrorCodesFactory.java:202) - Database product name found in cache for DataSource [org.apache.commons.dbcp.BasicDataSource@17b40fe]. Name is 'HSQL Database Engine'.
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'itemDAO'
INFO [main] (SQLErrorCodesFactory.java:197) - Looking up default SQLErrorCodes for DataSource
INFO [main] (SQLErrorCodesFactory.java:202) - Database product name found in cache for DataSource [org.apache.commons.dbcp.BasicDataSource@17b40fe]. Name is 'HSQL Database Engine'.
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'supplierDAO'
INFO [main] (SQLErrorCodesFactory.java:197) - Looking up default SQLErrorCodes for DataSource
INFO [main] (SQLErrorCodesFactory.java:202) - Database product name found in cache for DataSource [org.apache.commons.dbcp.BasicDataSource@17b40fe]. Name is 'HSQL Database Engine'.
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'userDAO'
INFO [main] (SQLErrorCodesFactory.java:197) - Looking up default SQLErrorCodes for DataSource
INFO [main] (SQLErrorCodesFactory.java:202) - Database product name found in cache for DataSource [org.apache.commons.dbcp.BasicDataSource@17b40fe]. Name is 'HSQL Database Engine'.
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'stateCountryDAO'
INFO [main] (SQLErrorCodesFactory.java:197) - Looking up default SQLErrorCodes for DataSource
INFO [main] (SQLErrorCodesFactory.java:202) - Database product name found in cache for DataSource [org.apache.commons.dbcp.BasicDataSource@17b40fe]. Name is 'HSQL Database Engine'.
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'orderDAO'
INFO [main] (SQLErrorCodesFactory.java:197) - Looking up default SQLErrorCodes for DataSource
INFO [main] (SQLErrorCodesFactory.java:202) - Database product name found in cache for DataSource [org.apache.commons.dbcp.BasicDataSource@17b40fe]. Name is 'HSQL Database Engine'.
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'petStoreServiceTarget'
INFO [main] (LocalSessionFactoryBean.java:485) - Dropping database schema for Hibernate SessionFactory
INFO [main] (SQLErrorCodesFactory.java:197) - Looking up default SQLErrorCodes for DataSource
INFO [main] (SQLErrorCodesFactory.java:202) - Database product name found in cache for DataSource [org.apache.commons.dbcp.BasicDataSource@17b40fe]. Name is 'HSQL Database Engine'.
INFO [main] (Dialect.java:82) - Using dialect: net.sf.hibernate.dialect.HSQLDialect
INFO [main] (Configuration.java:613) - processing one-to-many association mappings
INFO [main] (Configuration.java:622) - processing one-to-one association property references
INFO [main] (Configuration.java:647) - processing foreign key constraints
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Billing drop constraint FK5CACBA5B39175796
java.sql.SQLException: Table not found: BILLING in statement [alter table Billing]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Billing drop constraint FK5CACBA5B68AC491
java.sql.SQLException: Table not found: BILLING in statement [alter table Billing]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Billing drop constraint FK5CACBA5BD1B
java.sql.SQLException: Table not found: BILLING in statement [alter table Billing]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Usertable drop constraint FK8CCE16C339175796
java.sql.SQLException: Table not found: USERTABLE in statement [alter table Usertable]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Usertable drop constraint FK8CCE16C368AC491
java.sql.SQLException: Table not found: USERTABLE in statement [alter table Usertable]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table LineItem drop constraint FK4AAEE947C3DF62D1
java.sql.SQLException: Table not found: LINEITEM in statement [alter table LineItem]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Membership drop constraint FK26EF63F6117D5FDA
java.sql.SQLException: Table not found: MEMBERSHIP in statement [alter table Membership]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Membership drop constraint FK26EF63F6CE2B3226
java.sql.SQLException: Table not found: MEMBERSHIP in statement [alter table Membership]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Membership drop constraint FK26EF63F6CE2B3226C178CB3B
java.sql.SQLException: Table not found: MEMBERSHIP in statement [alter table Membership]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Product drop constraint FK50C664CF302BCFE
java.sql.SQLException: Table not found: PRODUCT in statement [alter table Product]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Orders drop constraint FK8D444F05B9D38A2D
java.sql.SQLException: Table not found: ORDERS in statement [alter table Orders]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Item drop constraint FK22EF339CDBF9CC
java.sql.SQLException: Table not found: ITEM in statement [alter table Item]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Item drop constraint FK22EF33ED8DCCEF
java.sql.SQLException: Table not found: ITEM in statement [alter table Item]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Inventory drop constraint FKFF02393CD1B
java.sql.SQLException: Table not found: INVENTORY in statement [alter table Inventory]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table ItemAttributes drop constraint FK791350EA317B13
java.sql.SQLException: Table not found: ITEMATTRIBUTES in statement [alter table ItemAttributes]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Supplier drop constraint FKA0B65DEC39175796
java.sql.SQLException: Table not found: SUPPLIER in statement [alter table Supplier]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Supplier drop constraint FKA0B65DEC68AC491
java.sql.SQLException: Table not found: SUPPLIER in statement [alter table Supplier]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Shipping drop constraint FKE51541CE39175796
java.sql.SQLException: Table not found: SHIPPING in statement [alter table Shipping]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Shipping drop constraint FKE51541CED1B
java.sql.SQLException: Table not found: SHIPPING in statement [alter table Shipping]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Shipping drop constraint FKE51541CE68AC491
java.sql.SQLException: Table not found: SHIPPING in statement [alter table Shipping]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$1.doInHibernate(LocalSessionFactoryBean.java:493)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.dropDatabaseSchema(LocalSessionFactoryBean.java:487)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:125)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
INFO [main] (LocalSessionFactoryBean.java:514) - Creating database schema for Hibernate SessionFactory
INFO [main] (SQLErrorCodesFactory.java:197) - Looking up default SQLErrorCodes for DataSource
INFO [main] (SQLErrorCodesFactory.java:202) - Database product name found in cache for DataSource [org.apache.commons.dbcp.BasicDataSource@17b40fe]. Name is 'HSQL Database Engine'.
INFO [main] (Dialect.java:82) - Using dialect: net.sf.hibernate.dialect.HSQLDialect
INFO [main] (Configuration.java:613) - processing one-to-many association mappings
INFO [main] (Configuration.java:622) - processing one-to-one association property references
INFO [main] (Configuration.java:647) - processing foreign key constraints
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: create table LineItem (id INTEGER NOT NULL IDENTITY, sku VARCHAR(30) not null, listPrice NUMERIC, description VARCHAR(255), order_ INTEGER not null, quantity INTEGER not null, position INTEGER)
java.sql.SQLException: Unexpected token: POSITION in statement [create table LineItem (id INTEGER NOT NULL IDENTITY, sku VARCHAR(30) not null, listPrice NUMERIC, description VARCHAR(255), order_ INTEGER not null, quantity INTEGER not null, position]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$2.doInHibernate(LocalSessionFactoryBean.java:522)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.createDatabaseSchema(LocalSessionFactoryBean.java:516)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:126)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table LineItem add constraint FK4AAEE947C3DF62D1 foreign key (order_) references Orders
java.sql.SQLException: Table not found: LINEITEM in statement [alter table LineItem]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$2.doInHibernate(LocalSessionFactoryBean.java:522)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.createDatabaseSchema(LocalSessionFactoryBean.java:516)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:126)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
WARN [main] (LocalSessionFactoryBean.java:582) - Unsuccessful schema statement: alter table Membership add constraint FK26EF63F6CE2B3226C178CB3B foreign key (userid) references Usertable
java.sql.SQLException: Constraint already exists in statement [alter table Membership add constraint FK26EF63F6CE2B3226C178CB3B foreign key (userid) references Usertable]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.executeSchemaScript(LocalSessionFactoryBean.java:579)
at org.springframework.orm.hibernate.LocalSessionFactoryBean$2.doInHibernate(LocalSessionFactoryBean.java:522)
at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:200)
at org.springframework.orm.hibernate.LocalSessionFactoryBean.createDatabaseSchema(LocalSessionFactoryBean.java:516)
at org.apache.cocoon.petstore.spring.service.PetStoreServiceImpl.initialize(PetStoreServiceImpl.java:126)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1087)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1061)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:287)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:205)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:136)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:236)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:284)
at org.springframework.web.context.support.XmlWebApplicationContext.refresh(XmlWebApplicationContext.java:131)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:156)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:97)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:48)
at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationContext.java:448)
at org.mortbay.http.HttpServer.start(HttpServer.java:663)
at org.mortbay.jetty.Server.main(Server.java:429)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at Loader.invokeMain(Unknown Source)
at Loader.run(Unknown Source)
at Loader.main(Unknown Source)
INFO [main] (AbstractBeanFactory.java:200) - Creating shared instance of singleton bean 'petStoreService'
INFO [main] (CollectionFactory.java:55) - Using JDK 1.4 collections
INFO [main] (ContextLoader.java:98) - Using context class [org.springframework.web.context.support.XmlWebApplicationContext] for root WebApplicationContext
INFO [main] (ContextLoader.java:101) - Published root WebApplicationContext [org.springframework.web.context.support.XmlWebApplicationContext: displayName=[Root XmlWebApplicationContext]; startup date=[Wed Nov 30 14:03:42 CET 2005]; root of ApplicationContext hierarchy; config locations=[classpath:org/apache/cocoon/petstore/spring/applicationContext.xml]; ] as ServletContext attribute with name [interface org.springframework.web.context.WebApplicationContext.ROOT]
INFO [main] (GenericFilterBean.java:106) - Initializing filter 'OpenSessionInViewFilter'
INFO [main] (GenericFilterBean.java:126) - Filter 'OpenSessionInViewFilter' configured successfully
14:03:50.546 WARN!! Delete existing temp dir c:\DOKUME~1\xgxttsl\LOKALE~1\Temp\Jetty__8888__ for WebApplicationContext[/,./build/webapp]
trying to register database
trying to register database
ERROR [main] (DiskStore.java:595) - IOException reading index. Creating new index.
INFO [main] (QuartzScheduler.java:194) - Quartz Scheduler v.1.5.0 created.
INFO [main] (RAMJobStore.java:138) - RAMJobStore initialized.
INFO [main] (DirectSchedulerFactory.java:331) - Quartz scheduler 'Cocoon
INFO [main] (DirectSchedulerFactory.java:333) - Quartz scheduler version: 1.5.0
INFO [main] (QuartzScheduler.java:399) - Scheduler Cocoon_$_Wed_Nov_30_14:03:55_CET_2005 started.
WARN! *** JMS block is installed but jms client library not found. ***
- For the jms block to work you must install and start a JMS server and place the client jar in WEB-INF/lib.
- The default server, OpenJMS is configured in cocoon.xconf but is not bundled with Cocoon.
WARN [main] (XindiceServlet.java:147) - The database 'db' root directory has been set to C:\src\cocoon-2.1.8\build\webapp\WEB-INF\db. Keep in mind that if a war upgrade will take place the database will be lost.
INFO [main] (Database.java:262) - Database points to C:\src\cocoon-2.1.8\build\webapp\WEB-INF\db
INFO [main] (Collection.java:1516) - [main] '/db/system/SysSymbols' Set object system_SysConfig
INFO [main] (Collection.java:1458) - [main] '/db/system/SysConfig' Set document database.xml
INFO [main] (Collection.java:1516) - [main] '/db/system/SysSymbols' Set object meta_Metas
INFO [main] (Collection.java:1516) - [main] '/db/system/SysSymbols' Set object meta_Metas_system_SysConfig
INFO [main] (XindiceServlet.java:167) - Database 'db' successfully opened
INFO [main] (XindiceServlet.java:205) - Xindice server successfully started
14:04:02.734 EVENT Started SocketListener on 0.0.0.0:8888
14:04:02.750 EVENT Started org.mortbay.jetty.Server@1f14ceb
INFO [PoolThread-3] (JdbcTransactionObjectSupport.java:60) - JDBC 3.0 Savepoint class is available
Building jar: C:\$Workspace\cocoon-2.1.9-spring\build\cocoon\blocks\slop-block.jar
Created dir: C:\$Workspace\cocoon-2.1.9-spring\build\cocoon\blocks\slop\samples
cocoon-block-spring-prepare:
Created dir: C:\$Workspace\cocoon-2.1.9-spring\build\cocoon\blocks\spring\dest
BUILD FAILED
C:\$Workspace\cocoon-2.1.9-spring\tools\targets\compile-build.xml:262: The following error occurred while executing this line:
C:\$Workspace\cocoon-2.1.9-spring\build\cocoon\temp\blocks-build.xml:3626: The following error occurred while executing this line:
C:\$Workspace\cocoon-2.1.9-spring\build\cocoon\temp\blocks-build.xml:95: srcdir
"C:\java" does not exist!
well I don't know what solved the problem but after this :
disable blocks faces, petstore and taglib
+ create empty folder c:/java
+ build clean
it solved my problem ...
there is no build/webapp/samples/blocks/spring folder ...
any suggestion ?