Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: PAT + MySQL

  1. #1
    Join Date
    Mar 2009

    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!.

    Shiju V.Joseph

  2. #2
    Join Date
    Jan 2006


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


    ( I use to connect via web to IRC )

  3. #3
    pstoellberger Guest


    You just need to edit the 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?


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.