Connecting MySQL from OpenEJB

You can use OpenEJB war to get the functionality of EJB into Tomcat.
Place the following text in openejb.xml file in config folder of Tomcat. For this setting to work your user table should have minimum one row present for root user.


JdbcDriver com.mysql.jdbc.Driver
JdbcUrl jdbc:mysql://192.168.0.101:3306/DataBaseName
UserName root
Password password
InitialSize 10
ConnectionProperties connectTimeout=10000;socketTimeout=10000;
MaxActive 1800
MaxIdle 500
MinIdle 10
MaxWait 10000
ValidationQuery select * from User where UserId='root';
TestWhileIdle true
TimeBetweenEvictionRunsMillis 10000
JtaManaged true