jboss3.2.1 has a oracle9i jdbc driver and our project uses oracle8i as database. When I deploy our project to jboss3.2.1, hibernate2 composes sql for associative table like "left outer join". But oracle8i does not support this kind of sql. I guess the reason is hiberate2 composes sql by special jdbc driver, now jboss3.2.1 using oracle9i jdbc driver.
How can I resolve this problem?
I tried to use 8i jdbc driver in my project and yes, it deployed in jboss. But it also created sql "left outer join". And I found it had some error when start jboss:

15:10:09,399 ERROR [JDBCExceptionReporter] Apparently wrong driver class specified for URL: class: oracle.jdbc.driver.OracleDriver, url: jdbc:oracle:thin:@10.60.2.8:1521:db129; - nested throwable: (org.jboss.resource.JBossResourceException:
Apparently wrong driver class specified for URL: class: oracle.jdbc.driver.OracleDriver, url: jdbc:oracle:thin:@10.60.2.8:1521:db129)

Try not to cross post. I answered this in the other forum. Setup the Oracle dialect correctly.