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)

Select the correct Dialect and it will work fine. There are two Oracle Dialects - on is for 9i. I am using 3.2.1 with 8i (8is JDBC driver).

Thank you for your reply, I am ok now.