View Full Version : PAT + MySQL

05-04-2010, 05:36 AM
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

05-05-2010, 08:47 AM
Best place for quick support on PAT is the IRC group -


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

05-06-2010, 04:10 AM
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?