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 Srinivasarao Sri <sr...@yahoo.com> on 2004/12/07 15:35:36 UTC

Exception while integrating with sqlserver ...help needed

Team,
I am tring to integrate jetspeed with sqlserver and getting the following exception while starting serever. Can you please tell me what I have to do.
 
 
Reason: 
        org.apache.jetspeed.om.profile.ProfileException: java.lang.NullPointerException
      
 

Get/Post Data:
template  = /html/ShowError.vm 
 

Stacktrace:
      
          org.apache.jetspeed.om.profile.ProfileException: java.lang.NullPointerException
 at org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfile(JetspeedProfilerService.java:502)
 at org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(JetspeedProfilerService.java:245)
 at org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(JetspeedProfilerService.java:528)
 at org.apache.jetspeed.services.Profiler.getProfile(Profiler.java:87)
 at org.apache.jetspeed.modules.actions.JetspeedAccessController.doPerform(JetspeedAccessController.java:74)
 at org.apache.turbine.modules.Action.perform(Action.java:87)
 at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
 at org.apache.turbine.Turbine.doGet(Turbine.java:529)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
 at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:432)
 at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:356)
 at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430)
 at org.apache.jsp.index_jsp._jspService(index_jsp.java:43)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
 at java.lang.Thread.run(Thread.java:536)
 
 
Thanks in advance,
Srinivas
 
 

		
---------------------------------
Do you Yahoo!?
 Yahoo! Mail - Easier than ever with enhanced search. Learn more.

Re: Exception while integrating with sqlserver ...help needed

Posted by Srinivasarao Sri <sr...@yahoo.com>.
Hi
Dan And Roger,
 
I added the following lines  in torque.properties file.
torque.dsfactory.default.connection.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver
torque.dsfactory.default.connection.url = jdbc:microsoft:sqlserver://localhost:1433
torque.dsfactory.default.connection.user =  jspeed
torque.dsfactory.default.connection.password = jspeed
torque.database.adaptor=MSSQL
torque.database.adaptor.MSSQL=com.microsoft.jdbc.sqlserver.SQLServerDriver
Now its working fine.
Thanks a lot for your guidence.
Srinivas

Roger Ruttimann <ro...@apache.org> wrote:
In addition to Dan's notes make sure that you have the the database 
permissions set correctly.
MySql for example includes the server name for the user (e.g. 
admin@localhost). You need to grant access to the user you define in the 
Torque properties for your jetspeed database.

Roger

Dan Moore wrote:

>Hello,
>
>I get this exception whenever I can't connect to my database (Oracle,
>but that doesn't matter).
>
>I'd check your Torque.properties to make sure that the connection
>information is correct and that your database is running.
>
>Dan
>
>--- Srinivasarao Sri wrote:
>
> 
>
>>Team,
>>I am tring to integrate jetspeed with sqlserver and getting the
>>following exception while starting serever. Can you please tell me
>>what I have to do.
>> 
>> 
>>Reason: 
>> org.apache.jetspeed.om.profile.ProfileException:
>>java.lang.NullPointerException
>> 
>> 
>>
>>Get/Post Data:
>>template = /html/ShowError.vm 
>> 
>>
>>Stacktrace:
>> 
>> org.apache.jetspeed.om.profile.ProfileException:
>>java.lang.NullPointerException
>> at
>>
>> 
>>
>org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfile(JetspeedProfilerService.java:502)
> 
>
>> at
>> 
>>
>
>...snip...
>
> 
>
>> 
>>Thanks in advance,
>>Srinivas
>> 
>> 
>>
>> 
>>---------------------------------
>>Do you Yahoo!?
>> Yahoo! Mail - Easier than ever with enhanced search. Learn more.
>> 
>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
> 
>


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


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: Exception while integrating with sqlserver ...help needed

Posted by Roger Ruttimann <ro...@apache.org>.
In addition to Dan's notes make sure that you have the the database 
permissions set correctly.
MySql for example includes the server name for the user (e.g. 
admin@localhost). You need to grant access to the user you define in the 
Torque properties for your jetspeed database.

Roger

Dan Moore wrote:

>Hello,
>
>I get this exception whenever I can't connect to my database (Oracle,
>but that doesn't matter).
>
>I'd check your Torque.properties to make sure that the connection
>information is correct and that your database is running.
>
>Dan
>
>--- Srinivasarao Sri <sr...@yahoo.com> wrote:
>
>  
>
>>Team,
>>I am tring to integrate jetspeed with sqlserver and getting the
>>following exception while starting serever. Can you please tell me
>>what I have to do.
>> 
>> 
>>Reason: 
>>        org.apache.jetspeed.om.profile.ProfileException:
>>java.lang.NullPointerException
>>      
>> 
>>
>>Get/Post Data:
>>template  = /html/ShowError.vm 
>> 
>>
>>Stacktrace:
>>      
>>          org.apache.jetspeed.om.profile.ProfileException:
>>java.lang.NullPointerException
>> at
>>
>>    
>>
>org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfile(JetspeedProfilerService.java:502)
>  
>
>> at
>>    
>>
>
>...snip...
>
>  
>
>> 
>>Thanks in advance,
>>Srinivas
>> 
>> 
>>
>>		
>>---------------------------------
>>Do you Yahoo!?
>> Yahoo! Mail - Easier than ever with enhanced search. Learn more.
>>    
>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org
>
>
>  
>


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


Re: Exception while integrating with sqlserver ...help needed

Posted by Dan Moore <mo...@yahoo.com>.
Hello,

I get this exception whenever I can't connect to my database (Oracle,
but that doesn't matter).

I'd check your Torque.properties to make sure that the connection
information is correct and that your database is running.

Dan

--- Srinivasarao Sri <sr...@yahoo.com> wrote:

> Team,
> I am tring to integrate jetspeed with sqlserver and getting the
> following exception while starting serever. Can you please tell me
> what I have to do.
>  
>  
> Reason: 
>         org.apache.jetspeed.om.profile.ProfileException:
> java.lang.NullPointerException
>       
>  
> 
> Get/Post Data:
> template  = /html/ShowError.vm 
>  
> 
> Stacktrace:
>       
>           org.apache.jetspeed.om.profile.ProfileException:
> java.lang.NullPointerException
>  at
>
org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfile(JetspeedProfilerService.java:502)
>  at

...snip...

>  
> Thanks in advance,
> Srinivas
>  
>  
> 
> 		
> ---------------------------------
> Do you Yahoo!?
>  Yahoo! Mail - Easier than ever with enhanced search. Learn more.


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