Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: Deploy Pat-0.6-SNAPSHOT.war

  1. #1
    Join Date
    Feb 2010
    Posts
    14

    Default Deploy Pat-0.6-SNAPSHOT.war

    Dear all,
    I'm trying to deploy Pat-0.6-SNAPSHOT.war in Tomcat.
    Can I add sql server driver to the list of driver that appears when I click on the connection button? I have my own database in Sql Server.
    Thanks for your reply.
    Giuseppe

  2. #2

    Default

    If I'm not mistaken you put the driver in webapp/pat.../WEB-INF/lib and restart.

    We've not really tested on MSSQL so let us know if you have any issues.

    Thanks for trying.

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  3. #3
    pstoellberger Guest

    Default

    yeah web-inf/lib is the correct path

    when you run it in java 6 it just has to be somewhere on the classpath if i'm not mistaken

    -paul

  4. #4
    Join Date
    Feb 2010
    Posts
    14

    Default

    Thank you for your quick reply Tom and Paul.
    Unfortunately, if I simple put the jar under the directory web-inf/lib and restart tomcat, nothing change, in fact in the list appear the driver already loaded.
    Giuseppe

  5. #5

    Default

    That list is dynamic and should adjust depending on which jar's it finds, if its not automatically added to the list, it will be something we need to look at
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  6. #6
    Join Date
    Feb 2010
    Posts
    14

    Default

    Hi guys,
    I did some test. If I delete the jar related to Mysql (mysql-connector-java-5.1.6.jar) in the list box mysql disappear. But if I add something unknown like sqljdbc4.jar for Sql Server nothing happens. The drivers are mapped somewhere? Thanks a lot
    Giuseppe

  7. #7
    pstoellberger Guest

    Default

    no the drivers are not mapped
    but our JDBC driver finder scans the libs for classes that can be recognized as java.sql.Driver classes.

    we never had any problems with that

    are you running tomcat with Java 1.6? I just read that sqljdbc4.jar needs Java 1.6

    p.s: sorry for the late reply

  8. #8
    Join Date
    Jan 2006
    Posts
    245

    Default

    Gius,

    could the jar file be corrupted? If so it cannot be accessed by the finder process and the driver isn't recognized. Try to open it manually just to verify everything is ok ...

    Hope this helps.
    S.
    Follow Me on Twitter: sramazzina
    My Skype account: sramazzina
    My Blog
    View my profile on LinkedIn: http://www.linkedin.com/in/sramazzina
    Author of Pentaho Data Integration Kitchen How-To and Pentaho Business Analytics Cookbook

    Join us on IRC server Freenode.net, channel ##pentaho ##saiku

  9. #9
    Join Date
    Feb 2010
    Posts
    14

    Default

    The problem is the driver...probably I have both sqljdbc4.jar and sqljdbc.jar,maybe they are in conflict...When I use only the sqljdbc.jar everything is ok... Thanks a lot,
    Giuseppe

  10. #10
    Join Date
    Oct 2007
    Posts
    235

    Default

    Hi Giuseppe

    Yeah I have seen that before. If you have both drivers in the class path they conflict. No idea why, just removed one to make it work. Seems to be a problem with the jvm or drivers (more likely the drivers) Just make sure you only have one of the jars and every thing is usually fine.

    Good luck

    Wil
    SQL: as much of a standard as the English language

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.