PDA

View Full Version : PAT + MySQL



shijujoe
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!. :)

Thanks
Shiju V.Joseph

mikegreen
05-05-2010, 08:47 AM
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 )

pstoellberger
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?

-Paul