bruce, thanks a lot. i am lazy so just downloaded your build with tomcat and it works.
the HelloEJB app came up.
however, it seems that there is some differences in setting up MySQL database
between your build (jboss-3.1.0alpha_tomcat-4.0.4.zip) and the one i was using before (jboss-3.0.1RC1_tomcat-4.0.4.zip)
whatever i had set up before with MySQL (which worked fine) no longer works. i am wondering if there is an additional step that is needed
for your build to set up MySQL as a datasource (java:/DefaultDS).
thanks,
--john
i only changed the mysql-service.xml file, dropped it in deploy,
and changed the java:/DefaultDS reference from Hypersonic SQL to MySqlDS in
MySqlDS.
now i am getting this strange exception in servlets:
javax.ejb.EJBException: ejbFindInRange: Table not found: SAVINGSACCOUNT in statement [select id from savingsaccount where balance between 0.00 and 990000.00]
these are the only changes i have made to make MySQL work before:
[conf]# diff standardjaws.xml ../../default/conf
17c17
< <type-mapping>MySqlDS</type-mapping>
---
> <type-mapping>Hypersonic SQL</type-mapping>
[conf]# diff standardjbosscmp-jdbc.xml ../../default/conf
16c16
< <datasource-mapping>MySqlDS</datasource-mapping>
---
> <datasource-mapping>Hypersonic SQL</datasource-mapping>
[jboss]# diff -w ./docs/examples/jca/mysql-service.xml ./server/all/deploy/mysql-service.xml
50c50
< <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://dell:3306/jbossdb</config-property>
---
> <config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://testserver3306/test</config-property>
53,54c53,54
< <config-property name="UserName" type="java.lang.String"></config-property>
< <config-property name="Password" type="java.lang.String"></config-property>
---
> <config-property name="UserName" type="java.lang.String">testuser</config-property>> <config-property name="Password" type="java.lang.String">testpassword</config-property>