topic encountering a problem with db.create in Alfresco Archive

encountering a problem with db.create

sebastian_s — Sun, 23 May 2010 13:56:25 GMT

Hello,I am trying to use Activiti with SQL-server. For one of the first steps I prepared a create and a drop-script for SQL-server. I placed them in the approbiate locations insinde the activiti-engine.jar. In the setup-directory I created a file called build.mssql.properties and changed from h2 to

Re: encountering a problem with db.create

jeff1 — Mon, 24 May 2010 03:19:51 GMT

hi, sebastian.
have a look at the method stack:


at java.io.Reader.<init>(Reader.java:61)
at java.io.InputStreamReader.<init>(InputStreamReader.java:55)
at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:774)

then dive into the source code, you will find the NP is caused by missing resource.
it's really probable because of the file bellow is NOT found:


org/activiti/db/create/activiti.mssql.create.sql

try /org/activiti/db/create/activiti.mssql.create.sql to replace org/activiti/db/create/activiti.mssql.create.sqladd up '/' and try again. because if without the '/' it stands for relative path to the somewhat class(maybe SQLExec)

Re: encountering a problem with db.create

sebastian_s — Mon, 24 May 2010 07:37:59 GMT

Thanks for the hint. I had a problem with the classpath. I solved it by putting the scripts in a jar-file. Afterwards it was fine.

Re: encountering a problem with db.create

jeff1 — Mon, 24 May 2010 08:17:58 GMT

yes, it's caused by missing resource in classpath, alternatively first, an unmatched path is given, second, the resource is even not exsit in classpath, third, wrong classloader.
anyway, cheers.