Does jetspeed support db configuration for odbc jdbc?

["Parambathu Kandy, Yasser Arafat (Cognizant)" <Ya...@cognizant.com>]

Hi,



My project has to use a DSN (odbc jdbc bridge) to connect to the
database.

So I changed my build.properties for the db configuration as



org.apache.jetspeed.production.database.default.name=mssql

org.apache.jetspeed.production.database.url=jdbc:odbc:PBCPortalDSN

org.apache.jetspeed.production.database.user=dbuser

org.apache.jetspeed.production.database.password=dbuser

org.apache.jetspeed.production.database.driver=sun.jdbc.odbc.JdbcOdbcDri
ver



The Jetspeed installation went fine, data got inserted into the
database(SQL), the server also got started with

all the sample wars deployed, but when I accesses the default page, it
threw the following error,



Questions:

1)       does jetspeed support this configuration?

2)       I cannot use a type 4 driver to connect to the db (SQL) due to
network constraints, so is there an alternative to solve this problem???



I tried to drop and recreate the db schema generated by Jetspeed, but it
gives me the same error. I use tomcat 5.0.28 and j2sdk1.4.2_10.



Thanks in advance,

Yasser



Error:

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

org.apache.jetspeed.engine.JetspeedServlet.doGet(JetspeedServlet.java:23
5)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java
:670)

org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:6
37)
        org.apache.jsp.index_jsp._jspService(index_jsp.java:45)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja
va:324)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)









This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.

  Visit us at http://www.cognizant.com