Re: Does jetspeed support db configuration for odbc jdbc?

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

Hi,

Sorry for the spam, but am stuck up with this problem, please help
me.... The problem is described below.

Yasser


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

Re: Does jetspeed support db configuration for odbc jdbc?

[David Sean Taylor <da...@bluesunrise.com>]

Parambathu Kandy, Yasser Arafat (Cognizant) wrote:
> org.apache.jetspeed.production.database.default.name=mssql
> org.apache.jetspeed.production.database.url=jdbc:odbc:PBCPortalDSN

Looks like a Microsoft SQL Server driver
We do support MS SQL
I don't think anyone has tested with your particular driver

> 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
> 
> org.springframework.jdbc.UncategorizedSQLException: (OJB operation):
> encountered SQLException [No data found]; nested exception is
> java.sql.SQLException: No data found

Apache OJB provides data access layer.
Have you checked with OJB to see if they support your driver?

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org