schema diff xslt error in development build: 117.3

[MacH G]

Hi ,

i am facing xslt transformation error in the following scenario

DB : Postgres

Operation : schemadiff

When i give the style sheet paramter as -styleSheet=wbdiff2pg.xslt the application is throwing the error 

Compare results written to C:\..\..\DB Compare1173\migrate_prod-16-03-2015.xml

XSLT Stylesheet C:\Users\219008\Documents\Ashok\Multi Project\DB Compare1173\wbdiff2pg.xslt not found. Transformation will not be applied!

Execution time: 40.72s

The xslt files are in the folder "xslt"

And apparently it is looking for the file in the current folder. My current folder name is DB Compare1173

when i move all the xslt files in the root folder it throws the following null pointer exception

Error when processing C:\..\..\DB Compare1173\wbdiff2pg.xslt: java.lang.NullPointerException

java.lang.NullPointerException

        at workbench.util.XsltTransformer.transform(XsltTransformer.java:180)

        at workbench.sql.wbcommands.WbSchemaDiff.execute(WbSchemaDiff.java:326)

        at workbench.sql.StatementRunner.runStatement(StatementRunner.java:559)

        at workbench.sql.BatchRunner.executeScript(BatchRunner.java:845)

        at workbench.sql.BatchRunner.runScript(BatchRunner.java:750)

        at workbench.sql.BatchRunner.runScript(BatchRunner.java:519)

        at workbench.sql.BatchRunner.execute(BatchRunner.java:541)

        at workbench.WbManager.runBatch(WbManager.java:1072)

        at workbench.WbManager.startApplication(WbManager.java:923)

        at workbench.WbManager.main(WbManager.java:1216)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at workbench.WbStarter.main(WbStarter.java:141)

Execution time: 41.95s

[MacH G]

the command i am using is

java -jar sqlworkbench.jar 

-command='WbSchemaDiff 
-referenceProfile="DMEmptyDBBackupV2" 
-targetProfile="DMEmptyDBBackupV1" -
includeTableGrants=true 
-includeProcedures=true 
-file=migrate_prod-%DATE%.xml 
-styleSheet=wbdiff2pg.xslt 
-xsltOutput=./migrate_prod-%DATE%.sql'

And my root folder is C:\..\..\DB Compare1173

[Thomas Kellerer]

Hi,

you need to specify the full path to the XSLT file.

I will change that for the next (dev) build to assume that relative filenames are searched in the XSLT directory of the installation.

Regards
Thomas

MacH G wrote on 16.03.2015 14:43:
> Hi ,
>
> i am facing xslt transformation error in the following scenario
>
> DB : Postgres
> Operation : schemadiff
>
> When i give the style sheet paramter as -styleSheet=wbdiff2pg.xslt the application is throwing the error
>

> *Compare results written to C:\..\..\DB Compare1173\migrate_prod-16-03-2015.xml*
> *XSLT Stylesheet C:\Users\219008\Documents\Ashok\Multi Project\DB Compare1173\wbdiff2pg.xslt not found. Transformation will not be applied!*
> *Execution time: 40.72s*
>
> The xslt files are in the folder "*xslt*"
>
> And apparently it is looking for the file in the current folder. My current folder name is *DB Compare1173*
> *
> *

> when i move all the xslt files in the root folder it throws the following null pointer exception
>

> *Error when processing C:\..\..\DB Compare1173\wbdiff2pg.xslt: java.lang.NullPointerException*
> *java.lang.NullPointerException*
> * at workbench.util.XsltTransformer.transform(XsltTransformer.java:180)*
> * at workbench.sql.wbcommands.WbSchemaDiff.execute(WbSchemaDiff.java:326)*
> * at workbench.sql.StatementRunner.runStatement(StatementRunner.java:559)*
> * at workbench.sql.BatchRunner.executeScript(BatchRunner.java:845)*
> * at workbench.sql.BatchRunner.runScript(BatchRunner.java:750)*
> * at workbench.sql.BatchRunner.runScript(BatchRunner.java:519)*
> * at workbench.sql.BatchRunner.execute(BatchRunner.java:541)*
> * at workbench.WbManager.runBatch(WbManager.java:1072)*
> * at workbench.WbManager.startApplication(WbManager.java:923)*
> * at workbench.WbManager.main(WbManager.java:1216)*
> * at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)*
> * at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)*
> * at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)*
> * at java.lang.reflect.Method.invoke(Unknown Source)*
> * at workbench.WbStarter.main(WbStarter.java:141)*
> *Execution time: 41.95s*
>
> --
> You received this message because you are subscribed to the Google Groups "SQL Workbench/J - DBMS independent SQL tool" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to sql-workbenc...@googlegroups.com <mailto:sql-workbenc...@googlegroups.com>.
> For more options, visit https://groups.google.com/d/optout.

[MacH G]

I tried that still no luck :(

On Monday, 16 March 2015 19:13:10 UTC+5:30, MacH G wrote:

[Thomas Kellerer]

Ah! Similar error as the one already fixed in 117.1: you need to specify a fully qualified name for the -file parameter as well
Using -file=./migrate_prod.xml might even be enough.

Sorry for the trouble, I will fix that.