jbossliferay-6oracle12cojdbcliferay-ide

ORA-24816 ... on Liferay embedded server but not on integration server


I am using Liferay IDE bundeled with Tomcat for Liferay Portal 6.1 ... Now I have some method (that I have no control on) that creates an insert statement according to some inputs and run it against the DB .. It uses internally jdbc (and oracle driver thus ... as we are dealing with Oracle DB)

This methods gives me this error : ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

which after some investigation I knew that it's a bug in oracle when a CLOB column comes before a VARCHAR column in the statement ... and thus the statement needs to be tuned

The weird thing is that it the same code works fine on the integration server (jboss) !!!

I need to know the reason as well as a way to solve it. Actually I doubt that the reason is in the oracle driver


Solution

  • I replaced the ojdbc6.jar by the one on the integration server and it worked fine