Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: PAT + MySQL

  1. #1
    Join Date
    Mar 2009
    Posts
    4

    Question PAT + MySQL

    Hi ,

    PAT plugin is working with the embedded HSQL database , but when I try to configure the bi-server with MySQL its showing an error "Failed to get a Session ID: Cannot create a new Session."

    any idea how to resolve this!.

    Thanks
    Shiju V.Joseph

  2. #2
    Join Date
    Jan 2006
    Posts
    205

    Default

    Best place for quick support on PAT is the IRC group -

    ##pentaho.pat

    ( I use http://webchat.freenode.net to connect via web to IRC )

  3. #3
    pstoellberger Guest

    Default

    You just need to edit the application.properties and the pat-hibernate.cfg.xml to use the mysql dialect

    unfortunately i have discovered a weird behaviour with hibernate DB type. so you might want to change the column schemaData to 'text' instead of varchar(255) - otherwise you might experience some erorrs when uploading new schema files.

    if the error is "can't create session ID" then the general setup is not working correctly... .can you paste the exception lines from your catalina.out or pat.log file?

    -Paul

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.