Tomcat BOS 5.8
Hello, my system works with BOS 5.8 runtime libraries, eh tried to configure it to work with the apache server and throws me the following Error
Bonita Error: bp_Pa_1
errors during parsing of environment:
error : couldn't interpret the dom model : org.hibernate.HibernateException: Could not find datasource
Show files to update
C:\Program Files\Apache Software Foundation\Apache Tomcat 7.0.27\bin\setenv.bat
-------------------------
@echo on
rem Sets some variables
set BONITA_HOME="-DBONITA_HOME=%CATALINA_HOME%\bonita"
set LOG_OPTS="-Djava.util.logging.config.file=%CATALINA_HOME%\external\logging\logging.properties"
set SECURITY_OPTS="-Djava.security.auth.login.config=%CATALINA_HOME%\conf\bonita\jaas-standard.cfg"
set JAVA_OPTS=%JAVA_OPTS% %LOG_OPTS% %SECURITY_OPTS% %BONITA_OPTS% %BONITA_HOME% -Dfile.encoding=UTF-8 -Xshare:auto
-Xms512m -Xmx1024m -XX:MaxPermSize=256m -XX:+HeapDumpOnOutOfMemoryError
--------------------------
C:\Program Files\Apache Software Foundation\Apache Tomcat 7.0.27\conf\context.xml
---------------------------remove < in Resource because the forum did not show the line
Resource name="jdbc/bonita_journal" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="IntraC3ud1D" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/bonita_journal"/>
Resource name="jdbc/bonita_history" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="IntraC3ud1D" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/bonita_history"/>'
--------------------------
catalina.properties
-----------------------
common.loader=${catalina.base}/lib,${catalina.base}/lib/*.jar,${catalina.home}/lib,${catalina.home}/lib/*.jar,${catalina.home}/lib/bonita/*.jar
---------------------------
C:\Program Files\Apache Software Foundation\Apache Tomcat 7.0.27\bonita\server\default\conf\bonita-journal.properties
------------------------
# MYSQL
hibernate.dialect org.hibernate.dialect.MySQL5InnoDBDialect
bonita.hibernate.interceptor org.ow2.bonita.env.interceptor.MySQLDescNullFirstInterceptor
hibernate.connection.datasource jdbc/bonita_journal
---------------------------
C:\Program Files\Apache Software Foundation\Apache Tomcat 7.0.27\bonita\server\default\conf\bonita-history.properties
------------------------
# MYSQL
hibernate.dialect org.hibernate.dialect.MySQL5InnoDBDialect
bonita.hibernate.interceptor org.ow2.bonita.env.interceptor.MySQLDescNullFirstInterceptor
hibernate.connection.datasource jdbc/bonita_history
---------------------------
thanks
Comments
hello, why are you still using Bonita 5.8 ? any chance you upgrade to 5.10 or that you swtich to 6.2 ?
Can you get to the bonita_journal and bonita_history by loging in with the mysql client and the credentials you've provided?
I do not know how you could do it, Might you help me or indicate as
thanks
How I would solve the problem migrating to version 5.10?
Go to a command prompt to your MySQL\bin directory (in my case: C:\Program Files\MySQL\MySQL Server 5.6\bin) and type mysql -u [username] -p. Hit enter and type the password. Now see if you can do the following:
show databases;
(bonita_journal and bonita_history should show)
use bonita_journal;
show tables;
(does this show any tables?)
quit;
(quit mysql client and goes back to command prompt)
Sorry had misunderstood prove the username and password and it works correctly. I could see the databases and tables
Anyone can help me with this problem? yet I fail to solve