You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by yasser arafat <ya...@yahoo.com> on 2006/01/10 07:11:13 UTC
Error using mssql with jetspeed 2
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.
Re: Error using mssql with jetspeed 2
Posted by Randy Watler <wa...@wispertel.net>.
Yasser,
Your configuration should look something like this for the JTDS driver:
catalina.server.home=c:/tomcat5
catalina.server.shared=${catalina.server.home}/shared/lib
org.apache.jetspeed.production.jdbc.drivers.path=
${catalina.server.shared}/jtds-0.8.1.jar
org.apache.jetspeed.production.database.default.name=mssql
org.apache.jetspeed.production.database.url=jdbc:jtds:sqlserver://hostname:1433/j2
org.apache.jetspeed.production.database.driver=net.sourceforge.jtds.jdbc.Driver
org.apache.jetspeed.production.database.user=some
org.apache.jetspeed.production.database.password=some
HTH,
Randy
On Tue, 2006-01-10 at 13:26 +0000, Aaron Evans wrote:
> yasser arafat <yasserarafat_in <at> yahoo.com> writes:
>
> >
> > 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=
>
> Do you mean MS SQL Server?
>
> So firstly, you have to provide the path to your JDBC drivers in your config.
>
> Secondly, if it is MS SQL Server you wish to connect to, may I ask why you
> are using generic ODBC drivers instead of the MS SQL Server JDBC drivers?
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: Error using mssql with jetspeed 2
Posted by Aaron Evans <aa...@yahoo.ca>.
yasser arafat <yasserarafat_in <at> yahoo.com> writes:
>
> 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=
Do you mean MS SQL Server?
So firstly, you have to provide the path to your JDBC drivers in your config.
Secondly, if it is MS SQL Server you wish to connect to, may I ask why you
are using generic ODBC drivers instead of the MS SQL Server JDBC drivers?
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org