portals-jetspeed-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yasser arafat <yasserarafat...@yahoo.com>
Subject Error using mssql with jetspeed 2
Date Tue, 10 Jan 2006 06:11:13 GMT
  hi,
  I have been trying to create a custom portal for the past three weeks. I have one running
with the default db hsql. The requirement to use mssql was enforced. So i did the following
  1) Configured the build.properties 
  *************************mssql************************
  org.apache.jetspeed.production.database.default.name=mssql
  org.apache.jetspeed.production.database.url=jdbc:odbc:pbcportal
  org.apache.jetspeed.production.database.user=some
  org.apache.jetspeed.production.database.password=some
  org.apache.jetspeed.production.database.driver=sun.jdbc.odbc.JdbcOdbcDriver
  org.apache.jetspeed.production.jdbc.drivers.path= 
  2) ran the cmd maven j2:portal.genapp - it created the portal structure
  3) maven war:install - created the war file.
  4) maven j2:quickStart - created teh tables in the mssql db and deployed the portal with
sample portlets in tomcats dir.
  5) started the server and when accessing the page found the following errors.
  Please look into the following trace and provide me a solution. Thanks in advance.
  regards,
  Yasser
  In the page
  javax.servlet.ServletException: Fatal error encountered while processing portal request:
org.apache.jetspeed.pipeline.PipelineException: org.apache.jetspeed.pipeline.PipelineException:
org.apache.jetspeed.pipeline.PipelineException: org.springframework.jdbc.UncategorizedSQLException:
(OJB operation): encountered SQLException [No data found]; nested exception is java.sql.SQLException:
No data found 
  In the console
  org.apache.ojb.broker.PersistenceBrokerException: Error reading class type: org.
  apache.jetspeed.profiler.rules.impl.StandardProfilingRule from result set, curre
  nt read field was ojbConcreteClass
  at org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readValuesFrom
  (RowReaderDefaultImpl.java:231)
  at org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readObjectArra
  yFrom(RowReaderDefaultImpl.java:199)
  at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(R
  sIterator.java:450)
  at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:275
  )
  at org.apache.ojb.broker.accesslayer.ChainingIterator.next(ChainingItera
  tor.java:322)
  at org.apache.ojb.broker.accesslayer.BasePrefetcher.prefetchRelationship
  (BasePrefetcher.java:107)
  at org.apache.ojb.broker.core.QueryReferenceBroker.performRetrievalTasks
  (QueryReferenceBroker.java:347)
  at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(
  QueryReferenceBroker.java:169)
  at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(
  QueryReferenceBroker.java:251)
  at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(
  QueryReferenceBroker.java:271)
  at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery
  (PersistenceBrokerImpl.java:1367)
  at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionB
  yQuery(DelegatingPersistenceBroker.java:338)
  at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionB
  yQuery(DelegatingPersistenceBroker.java:338)
  at org.springframework.orm.ojb.PersistenceBrokerTemplate$3.doInPersisten
  ceBroker(PersistenceBrokerTemplate.java:216)
  at org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(Persist
  enceBrokerTemplate.java:167)
  at org.springframework.orm.ojb.PersistenceBrokerTemplate.executeFind(Per
  sistenceBrokerTemplate.java:188)
  at org.springframework.orm.ojb.PersistenceBrokerTemplate.getCollectionBy
  Query(PersistenceBrokerTemplate.java:214)
  at org.apache.jetspeed.profiler.impl.JetspeedProfilerImpl.getRulesForPri
  ncipal(JetspeedProfilerImpl.java:414)
  at org.apache.jetspeed.profiler.impl.JetspeedProfilerImpl.getProfileLoca
  tors(JetspeedProfilerImpl.java:436)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
  java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
  sorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:324)
  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
  on(AopUtils.java:284)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
  inpoint(ReflectiveMethodInvocation.java:155)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
  ReflectiveMethodInvocation.java:122)
  at org.springframework.transaction.interceptor.TransactionInterceptor.in
  voke(TransactionInterceptor.java:56)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
  ReflectiveMethodInvocation.java:144)
  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
  cAopProxy.java:174)
  at $Proxy1.getProfileLocators(Unknown Source)
  at org.apache.jetspeed.profiler.impl.ProfilerValveImpl.invoke(ProfilerVa
  lveImpl.java:140)
  at org.apache.jetspeed.pipeline.JetspeedPipeline$Invocation.invokeNext(J
  etspeedPipeline.java:166)
  at org.apache.jetspeed.security.impl.LoginValidationValveImpl.invoke(Log
  inValidationValveImpl.java:143)
  at org.apache.jetspeed.pipeline.JetspeedPipeline$Invocation.invokeNext(J
  etspeedPipeline.java:166)
  at org.apache.jetspeed.security.impl.PasswordCredentialValveImpl.invoke(
  PasswordCredentialValveImpl.java:148)
  at org.apache.jetspeed.pipeline.JetspeedPipeline$Invocation.invokeNext(J
  etspeedPipeline.java:166)
  at org.apache.jetspeed.localization.impl.LocalizationValveImpl.invoke(Lo
  calizationValveImpl.java:168)
  at org.apache.jetspeed.pipeline.JetspeedPipeline$Invocation.invokeNext(J
  etspeedPipeline.java:166)
  at org.apache.jetspeed.security.impl.AbstractSecurityValve$1.run(Abstrac
  tSecurityValve.java:117)
  at java.security.AccessController.doPrivileged(Native Method)
  at javax.security.auth.Subject.doAsPrivileged(Subject.java:437)
  at org.apache.jetspeed.security.impl.AbstractSecurityValve.invoke(Abstra
  ctSecurityValve.java:111)
  at org.apache.jetspeed.pipeline.JetspeedPipeline$Invocation.invokeNext(J
  etspeedPipeline.java:166)
  at org.apache.jetspeed.container.url.impl.PortalURLValveImpl.invoke(Port
  alURLValveImpl.java:55)
  at org.apache.jetspeed.pipeline.JetspeedPipeline$Invocation.invokeNext(J
  etspeedPipeline.java:166)
  at org.apache.jetspeed.capabilities.impl.CapabilityValveImpl.invoke(Capa
  bilityValveImpl.java:128)
  at org.apache.jetspeed.pipeline.JetspeedPipeline$Invocation.invokeNext(J
  etspeedPipeline.java:166)
  at org.apache.jetspeed.pipeline.JetspeedPipeline.invoke(JetspeedPipeline
  .java:145)
  at org.apache.jetspeed.engine.JetspeedEngine.service(JetspeedEngine.java
  :231)
  at org.apache.jetspeed.engine.JetspeedServlet.doGet(JetspeedServlet.java
  :232)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
  icationFilterChain.java:237)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
  ilterChain.java:157)
  at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
  atcher.java:704)
  at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica
  tionDispatcher.java:474)
  at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
  ispatcher.java:409)
  at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
  patcher.java:312)
  at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.j
  ava:670)
  at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.jav
  a:637)
  at org.apache.jsp.index_jsp._jspService(index_jsp.java:45)
  at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
  at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
  .java:324)
  at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
  92)
  at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
  icationFilterChain.java:237)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
  ilterChain.java:157)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
  alve.java:214)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
  eContext.java:104)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
  a:520)
  at org.apache.catalina.core.StandardContextValve.invokeInternal(Standard
  ContextValve.java:198)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
  alve.java:152)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
  eContext.java:104)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
  torBase.java:462)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
  eContext.java:102)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
  a:520)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
  ava:137)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
  eContext.java:104)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
  ava:118)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
  eContext.java:102)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
  a:520)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
  ve.java:109)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv
  eContext.java:104)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav
  a:520)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
   
  at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:16
  0)
  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
  :799)
  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
  ssConnection(Http11Protocol.java:705)
  at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java
  :577)
  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
  ool.java:683)
  at java.lang.Thread.run(Thread.java:534)
  Caused by: java.sql.SQLException: No data found
  at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7139)
  at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3908)
  at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:
  5702)
  at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:356)
   
  at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:413)
   
  at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResul
  tSet.java:224)
  at org.apache.ojb.broker.metadata.JdbcTypesHelper$T_Varchar.readValueFro
  mResultSet(JdbcTypesHelper.java:404)
  at org.apache.ojb.broker.metadata.JdbcTypesHelper$BaseType.getObjectFrom
  Column(JdbcTypesHelper.java:324)
  at org.apache.ojb.broker.metadata.JdbcTypesHelper$BaseType.getObjectFrom
  Column(JdbcTypesHelper.java:303)
  at org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readValuesFrom
  (RowReaderDefaultImpl.java:224)
  ... 92 more


			
---------------------------------
Yahoo! Photos
 Got holiday prints? See all the ways to get quality prints in your hands ASAP.
Mime
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message