"The problem is more about if there are any database configuration differences between the two runs ?"
No, there are no differences!
I am using exactly this maven archetype:
group id:
org.jboss.weld.archetype
artifact id:
weld-jsf-jee
There is a import.sql script.
You can use this maven project to trace the failure:
When deploying with maven and do NOT "add" the project to the jboss tools "add and remove.."-dialog for synchronization,
then the import.sql script works without problems.
When NOT using maven and "add" the project to the jboss tools "add and remove.."-dialog for synchronization,
then the jboss throws the error described above.