Re: Webshark

Hi Antonio,
thanks for your reply.
I configured Webshark with SQLServer and I login correctly, both as admin and as user. But when I want to go to task management or administration I get this error:

SharkClientService -> Unexpected error while user admin loggs on
com.lutris.dods.builder.generator.query.DataObjectException: Unable to load data for UserDO id=1002203, error = : Data Object Error: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid column name: name
 at org.enhydra.shark.usergroup.data.UserDO.checkLoad(UserDO.java:536)
 at org.enhydra.shark.usergroup.data.UserDO.getPasswd(UserDO.java:2515)
 at org.enhydra.shark.authentication.DODSAuthenticationManager.validateUser(DODSAuthenticationManager.java:85)
 at org.enhydra.shark.SharkUtilities.validateUser(SharkUtilities.java:754)
 at org.enhydra.shark.SharkConnectionImpl.connect(SharkConnectionImpl.java:59)
 at org.enhydra.shark.SharkConnectionImpl.connect(SharkConnectionImpl.java:40)
 at webshark.JSPUtilities.connect(JSPUtilities.java:364)
 at org.apache.jsp.client_jsp._jspService(client_jsp.java:193)
 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:292)
 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(ApplicationFilterChain.java:237)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
 at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
 at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
 at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
 at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
 at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
 at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)

Any idea?
Thanks

Gennaro Leo
  ----- Original Message ----- 
  From: Antonio Huang 
  To: [email protected] 
  Sent: Thursday, August 04, 2005 4:30 AM
  Subject: Re: [shark] Webshark


  hi Gennaro,using these steps:
  1. see the readme,unzip distribution/webshark.war to tomcat/webapps.
  2. open webshark\WEB-INF\conf\Shark.conf,configure it connect sql server:

  DatabaseManager.DB.sharkdb.JdbcDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver

  #DatabaseManager.DB.sharkdb.Connection.Url="jdbc:hsqldb:/holst/Programme/Shark-1.0/db/hsql/hsql"
  #DatabaseManager.DB.sharkdb.Connection.Url=jdbc:hsqldb:hsql://localhost:9001
  #DatabaseManager.DB.sharkdb.Connection.Url=jdbc:hsqldb:/temp/hsql
  #DatabaseManager.DB.sharkdb.Connection.Url="jdbc:hsqldb:@@/WEB-INF/db/hsql/hsql"
  DatabaseManager.DB.sharkdb.Connection.Url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shark;SelectMethod=cursor

  DatabaseManager.DB.sharkdb.Connection.User=sa

  DatabaseManager.DB.sharkdb.Connection.Password=sa

  3. copy sqlserver jdbc jar(msbase.jar、mssqlserver.jar、msutil.jar) to tomcat\common\lib。

  finished these steps,you can run on sql server.But webshark have some error for needing fixed,you need fixed the JSPUtilities.java.

  ---
  Regards,
  Antonio Huang
  E-mail:[email protected]

    ----- Original Message ----- 
    From: Gennaro Leo 
    To: [email protected] 
    Sent: Monday, August 01, 2005 10:06 PM
    Subject: Re: [shark] Webshark


    Could you explain me how to configure it with sql server?

    Thanks

    Gennaro Leo
      ----- Original Message ----- 
      From: 黄越戈 
      To: [email protected] 
      Sent: Thursday, July 14, 2005 5:03 AM
      Subject: Re: [shark] Webshark


      hi Gennaro Leo,
      I just downloaded webshark.zip and fixed some codes,now can run with sql server. Have some problems:
      1):webshark used with shark 1.0.If want to use shark 1.1,need replaces some files and fix code.
      2):webshark's code has some bugs in JSPUtilities.java,need fix.

        ----- Original Message ----- 
        From: Gennaro Leo 
        To: [email protected] 
        Sent: Wednesday, July 13, 2005 6:54 PM
        Subject: [shark] Webshark


        Hi,
        did anyone use the "Webshark" application dowloaded from http://www.smartblu.de/webshark.zip ?
        I'd like to configure with a Microsoft SqlServer database.
        Could anyone help me?

        Thanks

        Gennaro Leo


------------------------------------------------------------------------



        --
        You receive this message as a subscriber of the [email protected] mailing list.
        To unsubscribe: mailto:[email protected]
        For general help: mailto:[email protected]?subject=help
        ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



--------------------------------------------------------------------------



      --
      You receive this message as a subscriber of the [email protected] mailing list.
      To unsubscribe: mailto:[email protected]
      For general help: mailto:[email protected]?subject=help
      ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



--------------------------------------------------------------------------


      No virus found in this incoming message.
      Checked by AVG Anti-Virus.
      Version: 7.0.323 / Virus Database: 267.8.13/47 - Release Date: 12/07/2005



----------------------------------------------------------------------------



    --
    You receive this message as a subscriber of the [email protected] mailing list.
    To unsubscribe: mailto:[email protected]
    For general help: mailto:[email protected]?subject=help
    ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



------------------------------------------------------------------------------



  --
  You receive this message as a subscriber of the [email protected] mailing list.
  To unsubscribe: mailto:[email protected]
  For general help: mailto:[email protected]?subject=help
  ObjectWeb mailing lists service home page: http://www.objectweb.org/wws



------------------------------------------------------------------------------


  No virus found in this incoming message.
  Checked by AVG Anti-Virus.
  Version: 7.0.338 / Virus Database: 267.9.9/62 - Release Date: 02/08/2005

--
You receive this message as a subscriber of the [email protected] mailing list.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws