Tomcat BOS 5.8

Q&A
1

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

---------------------------

 
 
I hope you can help me

thanks
2

Sorry had misunderstood prove the username and password and it works correctly. I could see the databases and tables

3

hello, why are you still using Bonita 5.8 ? any chance you upgrade to 5.10 or that you swtich to 6.2 ?

4

Can you get to the bonita_journal and bonita_history by loging in with the mysql client and the credentials you've provided?

5

I do not know how you could do it, Might you help me or indicate as

thanks

6

How I would solve the problem migrating to version 5.10?

7

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)

8

Sorry had misunderstood prove the username and password and it works correctly. I could see the databases and tables

9

Anyone can help me with this problem? yet I fail to solve

10

Can you get it running with the default HSQL database?