[wsas-java-dev] [jira] Resolved: (WSAS-274) NPE when logging in to
the chad sample
Afkham Azeez (JIRA)
jira at wso2.org
Sat Jun 30 05:56:15 PDT 2007
[ http://www.wso2.org/jira/browse/WSAS-274?page=all ]
Afkham Azeez resolved WSAS-274.
-------------------------------
Fix Version/s: Nightly
Resolution: Fixed
Fixed
> 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
> Fix For: Nightly
>
>
> 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