Tomcat BOS 5.8

1
0
-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

Comments

Submitted by ttoine on Mon, 01/27/2014 - 14:54

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

Submitted by martijnburger on Mon, 01/27/2014 - 15:17

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

Submitted by fmelossi on Mon, 01/27/2014 - 15:57

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

thanks

Submitted by fmelossi on Mon, 01/27/2014 - 15:58

How I would solve the problem migrating to version 5.10?

Submitted by martijnburger on Mon, 01/27/2014 - 16:31

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)

Submitted by fmelossi on Tue, 01/28/2014 - 14:03

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

Submitted by fmelossi on Mon, 02/10/2014 - 19:40

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

1 answer

1
0
-1

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

Comments

Submitted by martijnburger on Tue, 01/28/2014 - 14:46

Can you get it running with the default HSQL database?

Notifications