Menu ▾ ▴

is-null help

Open Discussion
Damon Torgerson
2003-10-06
2003-10-09

  • Damon Torgerson

    Damon Torgerson - 2003-10-06

    Hello and thanks for the great tool,

    New to SQL Unit. Downloaded 2.1 and attempting to use the new is-null feature.

    Tried <param id="1" is-null="true" type="VARCHAR" /> and got the error below. Am I missing something really simple?

    Thanks,
    Damon

    procs.test:
      [sqlunit] Malformed XML: Error on line 51: Attribute "is-null" must be declared for element type "param".
      [sqlunit] net.sourceforge.sqlunit.SQLUnitException: One or more SQLUnit Tests failed, see the error log for details
      [sqlunit]     at net.sourceforge.antsqlunittask.SqlunitTask.execute(SqlunitTask.java:88)
      [sqlunit]     at org.apache.tools.ant.Task.perform(Task.java:341)
      [sqlunit]     at org.apache.tools.ant.Target.execute(Target.java:309)
      [sqlunit]     at org.apache.tools.ant.Target.performTasks(Target.java:336)
      [sqlunit]     at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
      [sqlunit]     at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
      [sqlunit]     at org.apache.tools.ant.Task.perform(Task.java:341)
      [sqlunit]     at org.apache.tools.ant.Target.execute(Target.java:309)
      [sqlunit]     at org.apache.tools.ant.Target.performTasks(Target.java:336)
      [sqlunit]     at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
      [sqlunit]     at org.apache.tools.ant.Project.executeTargets(Project.java:1255)
      [sqlunit]     at org.apache.tools.ant.Main.runBuild(Main.java:609)
      [sqlunit]     at org.apache.tools.ant.Main.start(Main.java:196)
      [sqlunit]     at org.apache.tools.ant.Main.main(Main.java:235)

     

    • Sowmya S

      Sowmya S - 2003-10-07

      Hi

      I tested the same thing but that is working fine.I think problem is somewhere else.Just post the whole xml file

      sowmya

       

    • Sujit Pal

      Sujit Pal - 2003-10-07

      Its probably because the order of the attributes matter. Can you see if this works?
      <param id="1" type="VARCHAR" is-null="true" />
      The order as declared in the DTD is as follows: (id, type, is-null, inout). Just checked, and it specifies the same order in the manual as well.
      So, what can I tell you? It sucks, I know... :-)

      -sujit

       

    • Damon Torgerson

      Damon Torgerson - 2003-10-08

      Thank you very much for your help. The problem was my reference to the 1.8 dtd. Updated it to 2.1 and everything is golden.

      Thanks again,
      Damon

       

    • Sujit Pal

      Sujit Pal - 2003-10-09

      Just curious, did you have to change the order? I noticed this problem in another project using JDOM 1.6 (I think).

      -sujit

       

Log in to post a comment.