After much fustration I managed to get it working but thanks for your help it
was greatly appreciated.
Peter Crowther wrote:
Given that the samples run fine, this doesn't look like a Tomcat issue. I
suspect you'd have better luck on a MySQL, Hibernate or x-planner list.
I'm slightly bemused that the username in the error message is in
UPPERCASE
when you've specified it in lower case - is something assuming particular
case-sensitivity on MySQL?
- Peter
2009/12/7 joe_sad joesadd...@gmail.com
Hi,
I am trying to configure Tomcat so that I can run x-planner plus on it.
I have been following some tutorials but don't seem to be getting
anywhere
with it.
Im getting what looks like some database errors when running Tomcat with
my
xplanner plus application in the web apps dir. If the xplanner app is not
there then I do not getting any errors. Also the example applications
seem
to work fine.
The errors that I am getting are sql.SQLException: User not found:
XPLANNER
I have created a user using this script in mysql
GRANT ALL PRIVILEGES ON xplanner.* TO 'xplanner'@'localhost' IDENTIFIED
BY
'xp' WITH GRANT OPTION;
Also in the xplanner file :
xplanner.properties
xplanner-custom.properties
I have changed the connection part to this:
# Hibernate MySQL Configuration
hibernate.dialect=com.technoetic.xplanner.db.hibernate.XPlannerMySQLDialect
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.dbname=xplanner
hibernate.connection.url=jdbc:mysql://localhost/
hibernate.connection.username=xplanner
hibernate.connection.password=xp
xplanner.migration.databasetype=mysql
xplanner.migration.patchpath=patches:com.technoetic.xplanner.upgrade:com.technoetic.xplanner.security.install
Any advice would be much appreciated
Thanks in advance
--
View this message in context:
http://old.nabble.com/Setting-up-x-planner-plus-using-Tomcat-tp26680216p26680216.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
--
View this message in context:
http://old.nabble.com/Setting-up-x-planner-plus-using-Tomcat-tp26680216p26682691.html
Sent from the Tomcat - User mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org