Jacek Laskowski wrote:
It seems I've done petstore.ear deployment. I haven't looked at it in
much details so some configs are just to satisfy Geronimo.
Does anyone know why it happens:
HTTP ERROR: 500
Populate exception occured :
create table category_details (catid char(10) not null,
name varchar(80) not null, image varchar(255) null,
descn varchar(255) null, locale char(10) not null,
constraint pk_category_details primary key (catid, locale),
constraint fk_category_details_1 foreign key (catid)
references category (catid))
RequestURI=/petstore/Populate
and the server logs:
14:09:53,127 INFO [Container] Started HttpContext[/,/]
Syntax error: Encountered "null" at line 3, column 57.
14:10:36,379 WARN [/petstore]
/petstore/Populate?success_page=//supplier/populating.jsp%3fforcefully%3dfalse&forcefully=false:
ERROR 42X01: Syntax error: Encountered "null" at line 3, column 57.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at
org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(ParserImpl.java)
at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java)
at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java)
at
org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)
at
org.apache.derby.iapi.jdbc.BrokeredConnection.prepareStatement(BrokeredConnection.java)
at
org.tranql.connector.jdbc.ConnectionHandle.prepareStatement(ConnectionHandle.java:231)
at
com.sun.j2ee.blueprints.petstore.tools.populate.PopulateUtils.executeSQLStatement(PopulateUtils.java:66)
at
com.sun.j2ee.blueprints.petstore.tools.populate.PopulateUtils.executeSQLStatement(PopulateUtils.java:58)
at
com.sun.j2ee.blueprints.petstore.tools.populate.CategoryDetailsPopulator.createTables(CategoryDetailsPopulator.java:99)
at
com.sun.j2ee.blueprints.petstore.tools.populate.CategoryPopulator.createTables(CategoryPopulator.java:101)
at
com.sun.j2ee.blueprints.petstore.tools.populate.CatalogPopulator.createTables(CatalogPopulator.java:95)
at
com.sun.j2ee.blueprints.petstore.tools.populate.PopulateServlet.populate(PopulateServlet.java:160)
at
com.sun.j2ee.blueprints.petstore.tools.populate.PopulateServlet.doPost(PopulateServlet.java:118)
at
com.sun.j2ee.blueprints.petstore.tools.populate.PopulateServlet.doGet(PopulateServlet.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at
org.apache.geronimo.jetty.JettyServletHolder.handle(JettyServletHolder.java:92)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:832)
at
com.sun.j2ee.blueprints.signon.web.SignOnFilter.doFilter(SignOnFilter.java:154)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)
at
com.sun.j2ee.blueprints.encodingfilter.web.EncodingFilter.doFilter(EncodingFilter.java:77)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)
at
org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:171)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)
at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:623)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
14:10:36,409 WARN [ServletHandler]
/petstore/Populate?success_page=//supplier/populating.jsp%3fforcefully%3dfalse&forcefully=false:
ERROR 42X01: Syntax error: Encountered "null" at line 3, column 57.
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
at
org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(ParserImpl.java)
at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java)
at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java)
at
org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)
at
org.apache.derby.iapi.jdbc.BrokeredConnection.prepareStatement(BrokeredConnection.java)
at
org.tranql.connector.jdbc.ConnectionHandle.prepareStatement(ConnectionHandle.java:231)
at
com.sun.j2ee.blueprints.petstore.tools.populate.PopulateUtils.executeSQLStatement(PopulateUtils.java:66)
at
com.sun.j2ee.blueprints.petstore.tools.populate.PopulateUtils.executeSQLStatement(PopulateUtils.java:58)
at
com.sun.j2ee.blueprints.petstore.tools.populate.CategoryDetailsPopulator.createTables(CategoryDetailsPopulator.java:99)
at
com.sun.j2ee.blueprints.petstore.tools.populate.CategoryPopulator.createTables(CategoryPopulator.java:101)
at
com.sun.j2ee.blueprints.petstore.tools.populate.CatalogPopulator.createTables(CatalogPopulator.java:95)
at
com.sun.j2ee.blueprints.petstore.tools.populate.PopulateServlet.populate(PopulateServlet.java:160)
at
com.sun.j2ee.blueprints.petstore.tools.populate.PopulateServlet.doPost(PopulateServlet.java:118)
at
com.sun.j2ee.blueprints.petstore.tools.populate.PopulateServlet.doGet(PopulateServlet.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at
org.apache.geronimo.jetty.JettyServletHolder.handle(JettyServletHolder.java:92)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:832)
at
com.sun.j2ee.blueprints.signon.web.SignOnFilter.doFilter(SignOnFilter.java:154)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)
at
com.sun.j2ee.blueprints.encodingfilter.web.EncodingFilter.doFilter(EncodingFilter.java:77)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)
at
org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:171)
at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:823)
at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:623)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Jacek
