Since you are the first person to every complain about this, I assume you have some very weird configuration issues. As for what the exact problem is I have no idea. If you want to see the exact code used to load the values look at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil. If you want to see the generated sql increase your log level to DEBUG for category org.jboss.ejb.plugins.cmp.
One possibility is you are not actually connecting to Oracle but some other database, such as the built in default database hypersonic.