[wsas-java-dev] [jira] Created: (WSAS-274) NPE when logging in to
the chad sample
Charitha Kankanamge (JIRA)
jira at wso2.org
Fri Jun 29 00:59:15 PDT 2007
NPE when logging in to the chad sample
--------------------------------------
Key: WSAS-274
URL: http://www.wso2.org/jira/browse/WSAS-274
Project: WSO2 WSAS
Issue Type: Bug
Components: samples
Affects Versions: Nightly
Environment: winxp, jdk15
Reporter: Charitha Kankanamge
Assigned To: Afkham Azeez
Priority: Critical
Following error occurs when trying to access to Chad console.
ERROR [2007-06-29 13:21:36,859] Unsuccessful: create table admin_user_t (c_id bigint not null, c_la
st_updated timestamp not null, c_username varchar(255) not null unique, c_password varchar(255) not
null, primary key (c_id))
ERROR [2007-06-29 13:21:36,859] Table/View 'ADMIN_USER_T' already exists in Schema 'CHAD'.
ERROR [2007-06-29 13:21:37,093] Unsuccessful: create table choice_t (c_id bigint not null, c_last_u
pdated timestamp not null, c_choice_name varchar(255) not null, c_num_of_votes integer not null, c_p
oll_id bigint not null, primary key (c_id))
ERROR [2007-06-29 13:21:37,093] Table/View 'CHOICE_T' already exists in Schema 'CHAD'.
ERROR [2007-06-29 13:21:37,812] Unsuccessful: create table poll_t (c_id bigint not null, c_last_upd
ated timestamp not null, c_poll_id varchar(255) not null unique, c_title varchar(255) not null uniqu
e, c_description varchar(255), c_is_single_vote smallint not null, c_is_stopped smallint not null, p
rimary key (c_id))
ERROR [2007-06-29 13:21:37,828] Table/View 'POLL_T' already exists in Schema 'CHAD'.
ERROR [2007-06-29 13:21:38,109] Unsuccessful: create table voted_ip_t (c_id bigint not null, c_last
_updated timestamp not null, c_ip varchar(255) not null, c_poll_id bigint not null, primary key (c_i
d))
ERROR [2007-06-29 13:21:38,109] Table/View 'VOTED_IP_T' already exists in Schema 'CHAD'.
ERROR [2007-06-29 13:21:38,265] Unsuccessful: alter table choice_t add constraint FK6CFC85567B16DBC
D foreign key (c_poll_id) references poll_t
ERROR [2007-06-29 13:21:38,265] Constraint 'FK6CFC85567B16DBCD' already exists in Schema 'CHAD'.
ERROR [2007-06-29 13:21:38,500] Unsuccessful: alter table voted_ip_t add constraint FK8474BDC17B16D
BCD foreign key (c_poll_id) references poll_t
ERROR [2007-06-29 13:21:38,500] Constraint 'FK8474BDC17B16DBCD' already exists in Schema 'CHAD'.
ERROR [2007-06-29 13:21:38,625] Unsuccessful: create table hibernate_unique_key ( next_hi integer )
ERROR [2007-06-29 13:21:38,625] Table/View 'HIBERNATE_UNIQUE_KEY' already exists in Schema 'CHAD'.
ERROR [2007-06-29 13:21:38,671] The statement was aborted because it would have caused a duplicate
key value in a unique or primary key constraint or unique index identified by 'SQL070629012136310' d
efined on 'ADMIN_USER_T'.
ERROR [2007-06-29 13:21:38,671] Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [org.wso2.wsas.sample.chad.d
ata.AdminUser]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.jav
a:2078)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.jav
a:2427)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingE
ventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:
27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.wso2.wsas.sample.chad.data.ChadPersistenceManager.addAdminUser(ChadPersistenceManager
.java:61)
at org.wso2.wsas.sample.chad.command.AddAdminUserCommand.process(AddAdminUserCommand.java:37
)
at org.wso2.wsas.sample.chad.command.CommandExecutor.execute(CommandExecutor.java:40)
at org.wso2.wsas.sample.chad.data.DatabaseChadDataProvider.<init>(DatabaseChadDataProvider.j
ava:34)
at org.wso2.wsas.sample.chad.Chad.<init>(Chad.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:
39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorIm
pl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
at org.apache.axis2.receivers.AbstractMessageReceiver.makeNewServiceObject(AbstractMessageRe
ceiver.java:181)
at org.apache.axis2.receivers.AbstractMessageReceiver.getTheImplementationObject(AbstractMes
sageReceiver.java:219)
at org.apache.axis2.rpc.receivers.RPCMessageReceiver.invokeBusinessLogic(RPCMessageReceiver.
java:67)
at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOut
MessageReceiver.java:37)
at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:9
2)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:159)
at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUt
ils.java:227)
at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:115)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
ava:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.wso2.adminui.AdminUIServletFilter.doFilter(AdminUIServletFilter.java:140)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
ava:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Htt
p11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.ja
va:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: The statement was aborted because it would have caused a duplicate
key value in a unique or primary key constraint or unique index identified by 'SQL070629012136310'
defined on 'ADMIN_USER_T'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.jav
a:2062)
... 46 more
WARN [2007-06-29 13:21:38,859] Administrator admin already exists
org.hibernate.exception.ConstraintViolationException: could not insert: [org.wso2.wsas.sample.chad.d
ata.AdminUser]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.jav
a:2078)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.jav
a:2427)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingE
ventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:
27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.wso2.wsas.sample.chad.data.ChadPersistenceManager.addAdminUser(ChadPersistenceManager
.java:61)
at org.wso2.wsas.sample.chad.command.AddAdminUserCommand.process(AddAdminUserCommand.java:37
)
at org.wso2.wsas.sample.chad.command.CommandExecutor.execute(CommandExecutor.java:40)
at org.wso2.wsas.sample.chad.data.DatabaseChadDataProvider.<init>(DatabaseChadDataProvider.j
ava:34)
at org.wso2.wsas.sample.chad.Chad.<init>(Chad.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:
39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorIm
pl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
at org.apache.axis2.receivers.AbstractMessageReceiver.makeNewServiceObject(AbstractMessageRe
ceiver.java:181)
at org.apache.axis2.receivers.AbstractMessageReceiver.getTheImplementationObject(AbstractMes
sageReceiver.java:219)
at org.apache.axis2.rpc.receivers.RPCMessageReceiver.invokeBusinessLogic(RPCMessageReceiver.
java:67)
at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOut
MessageReceiver.java:37)
at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:9
2)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:159)
at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUt
ils.java:227)
at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:115)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
ava:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.wso2.adminui.AdminUIServletFilter.doFilter(AdminUIServletFilter.java:140)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
ava:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Htt
p11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.ja
va:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: The statement was aborted because it would have caused a duplicate
key value in a unique or primary key constraint or unique index identified by 'SQL070629012136310'
defined on 'ADMIN_USER_T'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.jav
a:2062)
... 46 more
ERROR [2007-06-29 13:21:39,109] Invalid transaction state.
ERROR [2007-06-29 13:21:39,109] java.lang.NullPointerException
Steps to reproduce:
================
1. Build chad sample
2. Click on 'Application GUI' from Service Management page
3. Try to log in to Chad UI
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://www.wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the Wsas-java-dev
mailing list