ant test fails

classic Classic list List threaded Threaded
21 messages Options
12
Reply | Threaded
Open this post in threaded view
|

ant test fails

Gili
Hi,

        I tried "ant test" as mentioned on your website and I get:

java.lang.NoClassDefFoundError:
org.objectstyle.cayenne.unit.CayenneTestCase at
java.lang.Class.forName0(Native Method) at
java.lang.Class.forName(Class.java:164)

        I noticed cayenne-tests.jar is missing from the classpath. Any idea how
to fix this?

Thanks,
Gili
--
http://www.desktopbeautifier.com/
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Andrus Adamchik

Just ran tests on the fresh CVS checkout and everything works fine. I  
used Java 1.4.2_08 and Ant 1.6.3.

I suspect that NoClassDefFoundError is a result of some other failure  
in a static initializer for CayenneTestCase. Check out JUnit XML  
output file for the first failed test. It should be under <cayenne-
checkout-dir>/build/test/out/internal_embedded_datasource/ . It may  
contain the information about the real cause of the error.

Andrus

On Aug 29, 2005, at 7:32 AM, Gili wrote:

> Hi,
>
>     I tried "ant test" as mentioned on your website and I get:
>
> java.lang.NoClassDefFoundError:  
> org.objectstyle.cayenne.unit.CayenneTestCase at  
> java.lang.Class.forName0(Native Method) at java.lang.Class.forName
> (Class.java:164)
>
>     I noticed cayenne-tests.jar is missing from the classpath. Any  
> idea how to fix this?
>
> Thanks,
> Gili
> --
> http://www.desktopbeautifier.com/
>
>

Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Gili

        Ah! Turned out to be a missing MySQL driver in the classpath. I'll try
to find the correct location for this...

Thanks,
Gili

Andrus Adamchik wrote:

>
> Just ran tests on the fresh CVS checkout and everything works fine. I  
> used Java 1.4.2_08 and Ant 1.6.3.
>
> I suspect that NoClassDefFoundError is a result of some other failure  
> in a static initializer for CayenneTestCase. Check out JUnit XML  output
> file for the first failed test. It should be under <cayenne-
> checkout-dir>/build/test/out/internal_embedded_datasource/ . It may  
> contain the information about the real cause of the error.
>
> Andrus
>
> On Aug 29, 2005, at 7:32 AM, Gili wrote:
>
>> Hi,
>>
>>     I tried "ant test" as mentioned on your website and I get:
>>
>> java.lang.NoClassDefFoundError:  
>> org.objectstyle.cayenne.unit.CayenneTestCase at  
>> java.lang.Class.forName0(Native Method) at java.lang.Class.forName
>> (Class.java:164)
>>
>>     I noticed cayenne-tests.jar is missing from the classpath. Any  
>> idea how to fix this?
>>
>> Thanks,
>> Gili
>> --
>> http://www.desktopbeautifier.com/
>>
>>
>
>

--
http://www.desktopbeautifier.com/
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Andrus Adamchik
Any location outside Cayenne checkout folder will work. Just add the  
full path to the driver jar to the CLASSPATH of the shell that  
started ant - Ant script will pick it up.

Andrus

On Aug 29, 2005, at 8:28 AM, Gili wrote:

>     Ah! Turned out to be a missing MySQL driver in the classpath.  
> I'll try to find the correct location for this...
>
> Thanks,
> Gili
>

Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Gili

        BTW: Now that this has been fixed I am getting NoClassDefError:
org.objectstyle.cayenne.unit.CayenneTestCase again. Looking at your ant
file I really don't see where you include cayenne-tests.jar in the
classpath.

        I never depend on the environment variable CLASSPATH on my end so maybe
that's where the problem is coming from. Shouldn't this be part of the
ant file?

Thanks,
Gili

Andrus Adamchik wrote:

> Any location outside Cayenne checkout folder will work. Just add the  
> full path to the driver jar to the CLASSPATH of the shell that  started
> ant - Ant script will pick it up.
>
> Andrus
>
> On Aug 29, 2005, at 8:28 AM, Gili wrote:
>
>>     Ah! Turned out to be a missing MySQL driver in the classpath.  
>> I'll try to find the correct location for this...
>>
>> Thanks,
>> Gili
>>
>
>

--
http://www.desktopbeautifier.com/
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Holger Hoffstätte-2
Gili wrote:
>     I never depend on the environment variable CLASSPATH on my end so
> maybe that's where the problem is coming from. Shouldn't this be part of
> the ant file?

I am not sure what exactly the problem is, but in the past it has never,
ever been necessary to set or depend on the environment CLASSPATH. I would
have regarded such a dependency as bug and fixed it.

-h
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Andrus Adamchik
In reply to this post by Gili

On Aug 29, 2005, at 8:48 AM, Gili wrote:

>
>     I never depend on the environment variable CLASSPATH on my end  
> so maybe that's where the problem is coming from. Shouldn't this be  
> part of the ant file?

Ant script uses CLASSPATH as an easy extension point allowing to  
include drivers, otherwise the script is self-contained. Tests are  
included directly from the build folder, not the jar:

...
<pathelement path="build/tests/classes"/>
...


Andrus

Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Gili

        Yes but this classpath entry is included at compile-time, not runtime.
Don't you need to add it to the "test" target?

Gili

Andrus Adamchik wrote:

>
> On Aug 29, 2005, at 8:48 AM, Gili wrote:
>
>>
>>     I never depend on the environment variable CLASSPATH on my end  so
>> maybe that's where the problem is coming from. Shouldn't this be  part
>> of the ant file?
>
>
> Ant script uses CLASSPATH as an easy extension point allowing to  
> include drivers, otherwise the script is self-contained. Tests are  
> included directly from the build folder, not the jar:
>
> ...
> <pathelement path="build/tests/classes"/>
> ...
>
>
> Andrus
>
>

--
http://www.desktopbeautifier.com/
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Gili

        Actually you're right, we reference a variable with id "classpath"
which contains the path you mentioned. Still, the class is not resolving
at runtime even though I can go into the directory and I see it there...
How odd.

Gili

Gili wrote:

>
>     Yes but this classpath entry is included at compile-time, not
> runtime. Don't you need to add it to the "test" target?
>
> Gili
>
> Andrus Adamchik wrote:
>
>>
>> On Aug 29, 2005, at 8:48 AM, Gili wrote:
>>
>>>
>>>     I never depend on the environment variable CLASSPATH on my end  
>>> so maybe that's where the problem is coming from. Shouldn't this be  
>>> part of the ant file?
>>
>>
>>
>> Ant script uses CLASSPATH as an easy extension point allowing to  
>> include drivers, otherwise the script is self-contained. Tests are  
>> included directly from the build folder, not the jar:
>>
>> ...
>> <pathelement path="build/tests/classes"/>
>> ...
>>
>>
>> Andrus
>>
>>
>

--
http://www.desktopbeautifier.com/
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Gili

        The test failure has something to do with cayenne.test.connection

        If I run "ant test" all tests pass just fine. If, however, I run "ant
test -Dcayenne.test.connection=example1" with example1 defined as:

example1.cayenne.adapter = org.objectstyle.cayenne.dba.mysql.MySQLAdapter
example1.jdbc.username = cayenne
example1.jdbc.password = cayenne
example1.jdbc.url = jdbc:mysql://localhost/cayenne
example1.jdbc.driver = com.mysql.jdbc.Driver

        then it fails.

Gili

Gili wrote:

>
>     Actually you're right, we reference a variable with id "classpath"
> which contains the path you mentioned. Still, the class is not resolving
> at runtime even though I can go into the directory and I see it there...
> How odd.
>
> Gili
>
> Gili wrote:
>
>>
>>     Yes but this classpath entry is included at compile-time, not
>> runtime. Don't you need to add it to the "test" target?
>>
>> Gili
>>
>> Andrus Adamchik wrote:
>>
>>>
>>> On Aug 29, 2005, at 8:48 AM, Gili wrote:
>>>
>>>>
>>>>     I never depend on the environment variable CLASSPATH on my end  
>>>> so maybe that's where the problem is coming from. Shouldn't this be  
>>>> part of the ant file?
>>>
>>>
>>>
>>>
>>> Ant script uses CLASSPATH as an easy extension point allowing to  
>>> include drivers, otherwise the script is self-contained. Tests are  
>>> included directly from the build folder, not the jar:
>>>
>>> ...
>>> <pathelement path="build/tests/classes"/>
>>> ...
>>>
>>>
>>> Andrus
>>>
>>>
>>
>

--
http://www.desktopbeautifier.com/
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Andrus Adamchik

Settings look good. Can you connect to this DB using MySQL tools  
outside Cayenne? Does "cayenne" instance exist? Also check the  
generated test XML files - they may contain the clues on why this  
happens.

Andrus


On Aug 29, 2005, at 9:27 AM, Gili wrote:

>
>     The test failure has something to do with cayenne.test.connection
>
>     If I run "ant test" all tests pass just fine. If, however, I  
> run "ant test -Dcayenne.test.connection=example1" with example1  
> defined as:
>
> example1.cayenne.adapter =  
> org.objectstyle.cayenne.dba.mysql.MySQLAdapter
> example1.jdbc.username = cayenne
> example1.jdbc.password = cayenne
> example1.jdbc.url = jdbc:mysql://localhost/cayenne
> example1.jdbc.driver = com.mysql.jdbc.Driver
>
>     then it fails.
>
> Gili
>
> Gili wrote:
>
>>     Actually you're right, we reference a variable with id  
>> "classpath" which contains the path you mentioned. Still, the  
>> class is not resolving at runtime even though I can go into the  
>> directory and I see it there... How odd.
>> Gili
>> Gili wrote:
>>
>>>
>>>     Yes but this classpath entry is included at compile-time, not  
>>> runtime. Don't you need to add it to the "test" target?
>>>
>>> Gili
>>>
>>> Andrus Adamchik wrote:
>>>
>>>
>>>>
>>>> On Aug 29, 2005, at 8:48 AM, Gili wrote:
>>>>
>>>>
>>>>>
>>>>>     I never depend on the environment variable CLASSPATH on my  
>>>>> end  so maybe that's where the problem is coming from.  
>>>>> Shouldn't this be  part of the ant file?
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Ant script uses CLASSPATH as an easy extension point allowing  
>>>> to  include drivers, otherwise the script is self-contained.  
>>>> Tests are  included directly from the build folder, not the jar:
>>>>
>>>> ...
>>>> <pathelement path="build/tests/classes"/>
>>>> ...
>>>>
>>>>
>>>> Andrus
>>>>
>>>>
>>>>
>>>
>>>
>
> --
> http://www.desktopbeautifier.com/
>
>

Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Gili

        Yes, I can connect using the mysql client and I see tables have been
added into the cayenne database so *something* is working properly. I've
attached a sample XML file I get back from the tests. It doesn't seem to
give much information.

Gili

Andrus Adamchik wrote:

>
> Settings look good. Can you connect to this DB using MySQL tools  
> outside Cayenne? Does "cayenne" instance exist? Also check the  
> generated test XML files - they may contain the clues on why this  happens.
>
> Andrus
>
>
> On Aug 29, 2005, at 9:27 AM, Gili wrote:
>
>>
>>     The test failure has something to do with cayenne.test.connection
>>
>>     If I run "ant test" all tests pass just fine. If, however, I  run
>> "ant test -Dcayenne.test.connection=example1" with example1  defined as:
>>
>> example1.cayenne.adapter =  
>> org.objectstyle.cayenne.dba.mysql.MySQLAdapter
>> example1.jdbc.username = cayenne
>> example1.jdbc.password = cayenne
>> example1.jdbc.url = jdbc:mysql://localhost/cayenne
>> example1.jdbc.driver = com.mysql.jdbc.Driver
>>
>>     then it fails.
>>
>> Gili
>>
>> Gili wrote:
>>
>>>     Actually you're right, we reference a variable with id  
>>> "classpath" which contains the path you mentioned. Still, the  class
>>> is not resolving at runtime even though I can go into the  directory
>>> and I see it there... How odd.
>>> Gili
>>> Gili wrote:
>>>
>>>>
>>>>     Yes but this classpath entry is included at compile-time, not  
>>>> runtime. Don't you need to add it to the "test" target?
>>>>
>>>> Gili
>>>>
>>>> Andrus Adamchik wrote:
>>>>
>>>>
>>>>>
>>>>> On Aug 29, 2005, at 8:48 AM, Gili wrote:
>>>>>
>>>>>
>>>>>>
>>>>>>     I never depend on the environment variable CLASSPATH on my  
>>>>>> end  so maybe that's where the problem is coming from.  Shouldn't
>>>>>> this be  part of the ant file?
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Ant script uses CLASSPATH as an easy extension point allowing  to  
>>>>> include drivers, otherwise the script is self-contained.  Tests
>>>>> are  included directly from the build folder, not the jar:
>>>>>
>>>>> ...
>>>>> <pathelement path="build/tests/classes"/>
>>>>> ...
>>>>>
>>>>>
>>>>> Andrus
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>
>> --
>> http://www.desktopbeautifier.com/
>>
>>
>
>
--
http://www.desktopbeautifier.com/

<?xml version="1.0" encoding="UTF-8" ?>
<testsuite errors="1" failures="0" name="org.objectstyle.cayenne.access.DataContextBinaryPKTst" tests="1" time="0.0">
  <properties>
    <property name="file.encoding.pkg" value="sun.io"></property>
    <property name="scope.jar" value="scope-bin-1.0.1.jar"></property>
    <property name="test.env.JAVA_HOME" value="C:\Program Files\Java\jdk1.5.0_04"></property>
    <property name="java.home" value="C:\Program Files\Java\jdk1.5.0_04\jre"></property>
    <property name="test.env.BOOST_HOME" value="C:\Program Files\boost_1_32_0"></property>
    <property name="mockrunner.jar" value="mockrunner-0.2.9.jar"></property>
    <property name="test.env.PATHEXT" value=".COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH"></property>
    <property name="test.env.TRAY_HOME" value="C:\Documents and Settings\Gili\My Documents\blueeye\trunk\com\be\tray"></property>
    <property name="emma.ant.jar" value="emma_ant-2.1.5214.jar"></property>
    <property name="test.env.USERPROFILE" value="C:\Documents and Settings\Gili"></property>
    <property name="compile.debug" value="true"></property>
    <property name="test.exclude" value="${test.exclude}"></property>
    <property name="test.env.ProgramFiles" value="C:\Program Files"></property>
    <property name="jgoodies.looks.jar" value="looks-1.3.1.jar"></property>
    <property name="test.env.PERL_HOME" value="C:\Program Files\Perl\bin"></property>
    <property name="java.endorsed.dirs" value="C:\Program Files\Java\jdk1.5.0_04\jre\lib\endorsed"></property>
    <property name="ant-junit.jar" value="ant-junit-1.6.5.jar"></property>
    <property name="test.env.ANT_HOME" value="C:\Program Files\ant-1.6.5"></property>
    <property name="test.env.PROMPT" value="$P$G"></property>
    <property name="jms.jar" value="jms-1.0.2b.jar"></property>
    <property name="sun.os.patch.level" value="Service Pack 2"></property>
    <property name="java.vendor.url" value="http://java.sun.com/"></property>
    <property name="test.env.VS71COMNTOOLS" value="C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\"></property>
    <property name="cayenne.test.connection" value="example1"></property>
    <property name="java.version" value="1.5.0_04"></property>
    <property name="java.vendor.url.bug" value="http://java.sun.com/cgi-bin/bugreport.cgi"></property>
    <property name="commons.logging.jar" value="commons-logging-1.0.4.jar"></property>
    <property name="test.env.USERDOMAIN" value="STALKER"></property>
    <property name="commons.lang.jar" value="commons-lang-2.1.jar"></property>
    <property name="user.name" value="Gili"></property>
    <property name="sun.io.unicode.encoding" value="UnicodeLittle"></property>
    <property name="test.resources" value="src/tests/resources"></property>
    <property name="sun.jnu.encoding" value="Cp1252"></property>
    <property name="java.runtime.name" value="Java(TM) 2 Runtime Environment, Standard Edition"></property>
    <property name="project.version" value="1.2-dev"></property>
    <property name="java.specification.name" value="Java Platform API Specification"></property>
    <property name="user.timezone" value=""></property>
    <property name="test.env.SystemDrive" value="C:"></property>
    <property name="path.separator" value=";"></property>
    <property name="test.env.JAVAMAIL_HOME" value="C:\Program Files\javamail-1.3.2"></property>
    <property name="test.env.USERNAME" value="Gili"></property>
    <property name="test.env.PROGUARD_HOME" value="C:\Program Files\proguard3.3.2"></property>
    <property name="test.env.JAI_HOME" value="C:\Program Files\jai"></property>
    <property name="test.env.ANT_CMD_LINE_ARGS" value="test -Dcayenne.test.connection example1"></property>
    <property name="project.name" value="cayenne"></property>
    <property name="file.encoding" value="Cp1252"></property>
    <property name="build" value="build"></property>
    <property name="test.env.COMPUTERNAME" value="STALKER"></property>
    <property name="servlet.jar" value="servlet-2.4.jar"></property>
    <property name="test.output" value="build/tests/out/example1"></property>
    <property name="ant.file" value="C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\build-tests.xml"></property>
    <property name="ant.jar" value="ant-1.6.5.jar"></property>
    <property name="test.env.ALLUSERSPROFILE" value="C:\Documents and Settings\All Users"></property>
    <property name="java.io.tmpdir" value="C:\DOCUME~1\Gili\LOCALS~1\Temp\"></property>
    <property name="user.language" value="en"></property>
    <property name="test.env.CYGWIN_HOME" value="C:\cygwin"></property>
    <property name="hsqldb.jar" value="hsqldb-1.7.3.3.jar"></property>
    <property name="test.env.PROCESSOR_REVISION" value="0209"></property>
    <property name="line.separator" value="
"></property>
    <property name="test.env.WINLAF_HOME" value="C:\Program Files\winlaf"></property>
    <property name="test.env.PROCESSOR_IDENTIFIER" value="x86 Family 15 Model 2 Stepping 9, GenuineIntel"></property>
    <property name="commons.dbcp.jar" value="commons-dbcp-1.2.1.jar"></property>
    <property name="regression.delete_objects_per_table" value="20"></property>
    <property name="test.env.LOGONSERVER" value="\\STALKER"></property>
    <property name="regression.commits_per_schema" value="3"></property>
    <property name="test.dist.src" value="dist/cayenne-1.2-dev/src/tests"></property>
    <property name="test.env.NUMBER_OF_PROCESSORS" value="2"></property>
    <property name="ashwood.jar" value="ashwood-1.1.jar"></property>
    <property name="java.vm.info" value="mixed mode, sharing"></property>
    <property name="sun.desktop" value="windows"></property>
    <property name="jdom.jar" value="jdom-1.0.jar"></property>
    <property name="java.vm.specification.name" value="Java Virtual Machine Specification"></property>
    <property name="ant.file.null" value="C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\build-tests.xml"></property>
    <property name="test.env._USE_CLASSPATH" value="yes"></property>
    <property name="compile.deprecation" value="false"></property>
    <property name="test.env._JAVACMD" value="C:\Program Files\Java\jdk1.5.0_04\bin\java.exe"></property>
    <property name="test.env.MAVEN_HOME" value="C:\Program Files\Maven 1.0.2"></property>
    <property name="test.env.JACE_HOME" value="C:\Documents and Settings\Gili\My Documents\jace\release"></property>
    <property name="test.env.Path" value="C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Executive Software\Diskeeper\;C:\Program Files\Subversion\bin;C:\Program Files\jprofiler4\bin\windows;c:\util;C:\Program Files\ant-1.6.5\bin;C:\Program Files\Maven 1.0.2\bin;C:\Program Files\TextPad 4;C:\Program Files\Java\jdk1.5.0_04\bin;C:\cygwin\bin"></property>
    <property name="cayenne.test.report" value="${cayenne.test.report}"></property>
    <property name="regression.max_foreign_keys_per_table" value="4"></property>
    <property name="test.env.HIBERNATE_HOME" value="C:\Program Files\hibernate-3.0"></property>
    <property name="java.awt.printerjob" value="sun.awt.windows.WPrinterJob"></property>
    <property name="vpp.jar" value="foundrylogic-vpp-2.2.1.jar"></property>
    <property name="test.report" value="build/tests/report/example1"></property>
    <property name="junit.jar" value="junit-3.8.1.jar"></property>
    <property name="test.env.APR_ICONV_PATH" value="C:\Program Files\Subversion\iconv"></property>
    <property name="test.src" value="src/tests/java"></property>
    <property name="test.env.JAF_HOME" value="C:\Program Files\jaf-1.0.2"></property>
    <property name="ant.version" value="Apache Ant version 1.6.5 compiled on June 2 2005"></property>
    <property name="test.env.TMP" value="C:\DOCUME~1\Gili\LOCALS~1\Temp"></property>
    <property name="test.env.ANT_OPTS" value="-Xmx250m"></property>
    <property name="emma.jar" value="emma-2.1.5214.jar"></property>
    <property name="test.env.windir" value="C:\WINDOWS"></property>
    <property name="regression.schema_count" value="10"></property>
    <property name="test.build" value="build/tests"></property>
    <property name="os.name" value="Windows XP"></property>
    <property name="java.specification.vendor" value="Sun Microsystems Inc."></property>
    <property name="test.env.CYGWIN" value="ntsec tty"></property>
    <property name="java.vm.name" value="Java HotSpot(TM) Client VM"></property>
    <property name="test.env.ComSpec" value="C:\WINDOWS\system32\cmd.exe"></property>
    <property name="java.library.path" value="C:\Program Files\Java\jdk1.5.0_04\jre\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Executive Software\Diskeeper\;C:\Program Files\Subversion\bin;C:\Program Files\jprofiler4\bin\windows;c:\util;C:\Program Files\ant-1.6.5\bin;C:\Program Files\Maven 1.0.2\bin;C:\Program Files\TextPad 4;C:\Program Files\Java\jdk1.5.0_04\bin;C:\cygwin\bin"></property>
    <property name="test.env.MYSQL_HOME" value="C:\Program Files\MySQL"></property>
    <property name="ant.java.version" value="1.5"></property>
    <property name="test.env.CommonProgramFiles" value="C:\Program Files\Common Files"></property>
    <property name="basedir" value="C:\Documents and Settings\Gili\My Documents\cayenne\cayenne"></property>
    <property name="java.class.version" value="49.0"></property>
    <property name="velocity.jar" value="velocity-dep-1.3.jar"></property>
    <property name="ant.home" value="C:\Program Files\ant-1.6.5"></property>
    <property name="jgoodies.forms.jar" value="forms-1.0.3.jar"></property>
    <property name="dist" value="dist/cayenne-1.2-dev"></property>
    <property name="test.env.XPP3_HOME" value="C:\Program Files\xpp3"></property>
    <property name="test.env.CLIENTNAME" value="Console"></property>
    <property name="jgroups.jar" value="jgroups-2.2.7.jar"></property>
    <property name="log4j.jar" value="log4j-1.2.9.jar"></property>
    <property name="sun.boot.library.path" value="C:\Program Files\Java\jdk1.5.0_04\jre\bin"></property>
    <property name="sun.management.compiler" value="HotSpot Client Compiler"></property>
    <property name="java.awt.graphicsenv" value="sun.awt.Win32GraphicsEnvironment"></property>
    <property name="user.variant" value=""></property>
    <property name="test.env.NSIS_HOME" value="C:\Program Files\NSIS"></property>
    <property name="commons.collections.jar" value="commons-collections-3.1.jar"></property>
    <property name="test.env.JAXEN_HOME" value="C:\Program Files\jaxen-1.1-beta-6"></property>
    <property name="commons.beanutils.jar" value="commons-beanutils-1.6.1.jar"></property>
    <property name="java.vm.specification.version" value="1.0"></property>
    <property name="bcel.jar" value="bcel-5.1.jar"></property>
    <property name="test.env.FP_NO_HOST_CHECK" value="NO"></property>
    <property name="test.env.CAYENNE_HOME" value="C:\Program Files\cayenne-1.1.2"></property>
    <property name="awt.toolkit" value="sun.awt.windows.WToolkit"></property>
    <property name="sun.cpu.isalist" value=""></property>
    <property name="cayenne.test.config" value="${cayenne.test.config}"></property>
    <property name="java.ext.dirs" value="C:\Program Files\Java\jdk1.5.0_04\jre\lib\ext"></property>
    <property name="os.version" value="5.1"></property>
    <property name="dist.base" value="dist"></property>
    <property name="user.home" value="C:\Documents and Settings\Gili"></property>
    <property name="test.env.TEMP" value="C:\DOCUME~1\Gili\LOCALS~1\Temp"></property>
    <property name="java.vm.vendor" value="Sun Microsystems Inc."></property>
    <property name="regression.new_objects_per_table" value="40"></property>
    <property name="test.env.CACTUS_HOME" value="C:\Program Files\Cactus"></property>
    <property name="test.env.SESSIONNAME" value="Console"></property>
    <property name="test.env.DOM4J_HOME" value="C:\Program Files\dom4j"></property>
    <property name="user.dir" value="C:\Documents and Settings\Gili\My Documents\cayenne\cayenne"></property>
    <property name="ognl.jar" value="ognl-2.6.7.jar"></property>
    <property name="regression.max_references_per_table" value="4"></property>
    <property name="sun.cpu.endian" value="little"></property>
    <property name="otherlib.dir" value="otherlib"></property>
    <property name="test.bin" value="src/tests/bin"></property>
    <property name="java.vm.version" value="1.5.0_04-b05"></property>
    <property name="test.env.XSTREAM_HOME" value="C:\Program Files\xstream-1.1.2"></property>
    <property name="java.class.path" value="C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\ant-junit-1.6.5.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\commons-dbcp-1.2.1.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\commons-pool-1.2.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\emma-2.1.5214.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\emma_ant-2.1.5214.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\foundrylogic-vpp-2.2.1.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\jdom-1.0.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\jgroups-2.2.7.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\junit-3.8.1.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\mockrunner-0.2.9.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\servlet-2.4.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\spring-1.1.5.jar;C:\Program Files\ant-1.6.5\lib\ant-antlr.jar;C:\Program Files\ant-1.6.5\lib\ant-apache-bcel.jar;C:\Program Files\ant-1.6.5\lib\ant-apache-bsf.jar;C:\Program Files\ant-1.6.5\lib\ant-apache-log4j.jar;C:\Program Files\ant-1.6.5\lib\ant-apache-oro.jar;C:\Program Files\ant-1.6.5\lib\ant-apache-regexp.jar;C:\Program Files\ant-1.6.5\lib\ant-apache-resolver.jar;C:\Program Files\ant-1.6.5\lib\ant-commons-logging.jar;C:\Program Files\ant-1.6.5\lib\ant-commons-net.jar;C:\Program Files\ant-1.6.5\lib\ant-icontract.jar;C:\Program Files\ant-1.6.5\lib\ant-jai.jar;C:\Program Files\ant-1.6.5\lib\ant-javamail.jar;C:\Program Files\ant-1.6.5\lib\ant-jdepend.jar;C:\Program Files\ant-1.6.5\lib\ant-jmf.jar;C:\Program Files\ant-1.6.5\lib\ant-jsch.jar;C:\Program Files\ant-1.6.5\lib\ant-junit.jar;C:\Program Files\ant-1.6.5\lib\ant-launcher.jar;C:\Program Files\ant-1.6.5\lib\ant-netrexx.jar;C:\Program Files\ant-1.6.5\lib\ant-nodeps.jar;C:\Program Files\ant-1.6.5\lib\ant-starteam.jar;C:\Program Files\ant-1.6.5\lib\ant-stylebook.jar;C:\Program Files\ant-1.6.5\lib\ant-swing.jar;C:\Program Files\ant-1.6.5\lib\ant-trax.jar;C:\Program Files\ant-1.6.5\lib\ant-vaj.jar;C:\Program Files\ant-1.6.5\lib\ant-weblogic.jar;C:\Program Files\ant-1.6.5\lib\ant-xalan1.jar;C:\Program Files\ant-1.6.5\lib\ant-xslp.jar;C:\Program Files\ant-1.6.5\lib\ant.jar;C:\Program Files\ant-1.6.5\lib\xercesImpl.jar;C:\Program Files\ant-1.6.5\lib\xml-apis.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\dist\cayenne-1.2-dev\lib\cayenne.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\build\tests\classes;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\build\tests\deps;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\dist\cayenne-1.2-dev\lib\mysql-connector-java-3.1.8-bin.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\hsqldb-1.7.3.3.jar"></property>
    <property name="os.arch" value="x86"></property>
    <property name="compile.optimize" value="true"></property>
    <property name="cayenne.test.failure" value="true"></property>
    <property name="test.filter" value="**/*Tst.class"></property>
    <property name="test.env.OS" value="Windows_NT"></property>
    <property name="test.env.HOMEDRIVE" value="C:"></property>
    <property name="site.dir" value="dist/site"></property>
    <property name="java.vm.specification.vendor" value="Sun Microsystems Inc."></property>
    <property name="commons.pool.jar" value="commons-pool-1.2.jar"></property>
    <property name="file.separator" value="\"></property>
    <property name="regression.max_loops_per_table" value="3"></property>
    <property name="java.runtime.version" value="1.5.0_04-b05"></property>
    <property name="sun.boot.class.path" value="C:\Program Files\Java\jdk1.5.0_04\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_04\jre\classes"></property>
    <property name="coverage.dir" value="build/tests/coverage"></property>
    <property name="test.env.APPDATA" value="C:\Documents and Settings\Gili\Application Data"></property>
    <property name="javacc.jar" value="javacc-3.2.jar"></property>
    <property name="test.env.SystemRoot" value="C:\WINDOWS"></property>
    <property name="user.country" value="CA"></property>
    <property name="test.env.PROCESSOR_ARCHITECTURE" value="x86"></property>
    <property name="regression.loop_count" value="10"></property>
    <property name="java.vendor" value="Sun Microsystems Inc."></property>
    <property name="spring.jar" value="spring-1.1.5.jar"></property>
    <property name="test.env.HOMEPATH" value="\Documents and Settings\Gili"></property>
    <property name="java.specification.version" value="1.5"></property>
    <property name="test.env.PROCESSOR_LEVEL" value="15"></property>
    <property name="sun.arch.data.model" value="32"></property>
  </properties>
  <error message="org.objectstyle.cayenne.unit.CayenneTestCase" type="java.lang.NoClassDefFoundError">java.lang.NoClassDefFoundError: org.objectstyle.cayenne.unit.CayenneTestCase
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:164)
</error>
  <system-out><![CDATA[]]></system-out>
  <system-err><![CDATA[]]></system-err>
</testsuite>
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Mike Kienenberger
In reply to this post by Gili
If you use "ant test", it will default to a in-memory HSQLDB database
for testing.
So it's still probably an issue with your mysql driver not being found.

On 8/29/05, Gili <[hidden email]> wrote:

>
>         The test failure has something to do with cayenne.test.connection
>
>         If I run "ant test" all tests pass just fine. If, however, I run "ant
> test -Dcayenne.test.connection=example1" with example1 defined as:
>
> example1.cayenne.adapter = org.objectstyle.cayenne.dba.mysql.MySQLAdapter
> example1.jdbc.username = cayenne
> example1.jdbc.password = cayenne
> example1.jdbc.url = jdbc:mysql://localhost/cayenne
> example1.jdbc.driver = com.mysql.jdbc.Driver
>
>         then it fails.
>
> Gili
>
> Gili wrote:
> >
> >     Actually you're right, we reference a variable with id "classpath"
> > which contains the path you mentioned. Still, the class is not resolving
> > at runtime even though I can go into the directory and I see it there...
> > How odd.
> >
> > Gili
> >
> > Gili wrote:
> >
> >>
> >>     Yes but this classpath entry is included at compile-time, not
> >> runtime. Don't you need to add it to the "test" target?
> >>
> >> Gili
> >>
> >> Andrus Adamchik wrote:
> >>
> >>>
> >>> On Aug 29, 2005, at 8:48 AM, Gili wrote:
> >>>
> >>>>
> >>>>     I never depend on the environment variable CLASSPATH on my end
> >>>> so maybe that's where the problem is coming from. Shouldn't this be
> >>>> part of the ant file?
> >>>
> >>>
> >>>
> >>>
> >>> Ant script uses CLASSPATH as an easy extension point allowing to
> >>> include drivers, otherwise the script is self-contained. Tests are
> >>> included directly from the build folder, not the jar:
> >>>
> >>> ...
> >>> <pathelement path="build/tests/classes"/>
> >>> ...
> >>>
> >>>
> >>> Andrus
> >>>
> >>>
> >>
> >
>
> --
> http://www.desktopbeautifier.com/
>
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Gili

        <sigh> I give up. The XML file explicitly complains
"java.lang.NoClassDefFoundError:
org.objectstyle.cayenne.unit.CayenneTestCase" so I really don't see how
this could be a problem with my drivers. I dumped the mysql driver into
the /otherlib directory and added

        <include name="mysql-connector-java-3.1.8-bin.jar"/>

to build-tests.xml

        Is there a way to force Ant to fail on nonexistant paths or files? I've
tried just about anything. I can't figure out what else could be wrong.

Gili

Mike Kienenberger wrote:

> If you use "ant test", it will default to a in-memory HSQLDB database
> for testing.
> So it's still probably an issue with your mysql driver not being found.
>
> On 8/29/05, Gili <[hidden email]> wrote:
>
>>        The test failure has something to do with cayenne.test.connection
>>
>>        If I run "ant test" all tests pass just fine. If, however, I run "ant
>>test -Dcayenne.test.connection=example1" with example1 defined as:
>>
>>example1.cayenne.adapter = org.objectstyle.cayenne.dba.mysql.MySQLAdapter
>>example1.jdbc.username = cayenne
>>example1.jdbc.password = cayenne
>>example1.jdbc.url = jdbc:mysql://localhost/cayenne
>>example1.jdbc.driver = com.mysql.jdbc.Driver
>>
>>        then it fails.
>>
>>Gili
>>
>>Gili wrote:
>>
>>>    Actually you're right, we reference a variable with id "classpath"
>>>which contains the path you mentioned. Still, the class is not resolving
>>>at runtime even though I can go into the directory and I see it there...
>>>How odd.
>>>
>>>Gili
>>>
>>>Gili wrote:
>>>
>>>
>>>>    Yes but this classpath entry is included at compile-time, not
>>>>runtime. Don't you need to add it to the "test" target?
>>>>
>>>>Gili
>>>>
>>>>Andrus Adamchik wrote:
>>>>
>>>>
>>>>>On Aug 29, 2005, at 8:48 AM, Gili wrote:
>>>>>
>>>>>
>>>>>>    I never depend on the environment variable CLASSPATH on my end
>>>>>>so maybe that's where the problem is coming from. Shouldn't this be
>>>>>>part of the ant file?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>Ant script uses CLASSPATH as an easy extension point allowing to
>>>>>include drivers, otherwise the script is self-contained. Tests are
>>>>>included directly from the build folder, not the jar:
>>>>>
>>>>>...
>>>>><pathelement path="build/tests/classes"/>
>>>>>...
>>>>>
>>>>>
>>>>>Andrus
>>>>>
>>>>>
>>>>
>>--
>>http://www.desktopbeautifier.com/
>>
>
>

--
http://www.desktopbeautifier.com/
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Andrus Adamchik
The real problem is that JUnit doesn't report problems in static  
initializers. Time to switch to TestNG or maybe rewrite  
CayenneTestResources and CayenneTestCase static{} blocks.

Anyway, looking at your test XML output, you are using JDK 1.5:

<property name="java.vm.version" value="1.5.0_04-b05"></property>

I think I saw a few problems with Unit tests and 1.5 in the past  
(though Cayenne itself works fine on 1.5). Try installing JDK 1.4 in  
parallel with 1.5 and rerun the unit tests with 1.4. It is a good  
idea anyway. We are trying to keep Cayenne runtime 1.3 compatible and  
Modeler - 1.4 compatible, so any patches you may submit shouldn't  
have 1.5 API.

Andrus


On Aug 29, 2005, at 11:00 AM, Gili wrote:

>     <sigh> I give up. The XML file explicitly complains  
> "java.lang.NoClassDefFoundError:  
> org.objectstyle.cayenne.unit.CayenneTestCase" so I really don't see  
> how this could be a problem with my drivers. I dumped the mysql  
> driver into the /otherlib directory and added
>
>     <include name="mysql-connector-java-3.1.8-bin.jar"/>
>
> to build-tests.xml
>
>     Is there a way to force Ant to fail on nonexistant paths or  
> files? I've tried just about anything. I can't figure out what else  
> could be wrong.
>
> Gili
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Gili

        Ok, moving the static block into the constructor fixed it. I defined a
static variable isInitialized to ensure this code is only run once.

        Anyway, on further debugging I found that the reason the tests are
failing is because

     protected AccessStack buildAccessStack() {
         return
CayenneTestResources.getResources().getAccessStack(TEST_ACCESS_STACK);
     }

        returns null. Any ideas why?

Gili

Andrus Adamchik wrote:

> The real problem is that JUnit doesn't report problems in static  
> initializers. Time to switch to TestNG or maybe rewrite  
> CayenneTestResources and CayenneTestCase static{} blocks.
>
> Anyway, looking at your test XML output, you are using JDK 1.5:
>
> <property name="java.vm.version" value="1.5.0_04-b05"></property>
>
> I think I saw a few problems with Unit tests and 1.5 in the past  
> (though Cayenne itself works fine on 1.5). Try installing JDK 1.4 in  
> parallel with 1.5 and rerun the unit tests with 1.4. It is a good  idea
> anyway. We are trying to keep Cayenne runtime 1.3 compatible and  
> Modeler - 1.4 compatible, so any patches you may submit shouldn't  have
> 1.5 API.
>
> Andrus
>
>
> On Aug 29, 2005, at 11:00 AM, Gili wrote:
>
>>     <sigh> I give up. The XML file explicitly complains  
>> "java.lang.NoClassDefFoundError:  
>> org.objectstyle.cayenne.unit.CayenneTestCase" so I really don't see  
>> how this could be a problem with my drivers. I dumped the mysql  
>> driver into the /otherlib directory and added
>>
>>     <include name="mysql-connector-java-3.1.8-bin.jar"/>
>>
>> to build-tests.xml
>>
>>     Is there a way to force Ant to fail on nonexistant paths or  
>> files? I've tried just about anything. I can't figure out what else  
>> could be wrong.
>>
>> Gili
>
>

--
http://www.desktopbeautifier.com/
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Gili
In reply to this post by Andrus Adamchik

        Ok, I've fixed all the problems I can find and now I am seeing actual
problem reports from Cayenne. I was told you guys test mysql on your end
so I find this confusing -- if I didn't know better I would say this is
showing bugs in Cayenne's MySQL support. See the attached XML file (one
of the many failed tests). Any ideas?

Gili

<?xml version="1.0" encoding="UTF-8" ?>
<testsuite errors="0" failures="1" name="org.objectstyle.cayenne.CDOMany2OneNoRevTst" tests="1" time="0.031">
  <properties>
    <property name="file.encoding.pkg" value="sun.io"></property>
    <property name="scope.jar" value="scope-bin-1.0.1.jar"></property>
    <property name="test.env.JAVA_HOME" value="C:\Program Files\Java\jdk1.5.0_04"></property>
    <property name="java.home" value="C:\Program Files\Java\jdk1.5.0_04\jre"></property>
    <property name="test.env.BOOST_HOME" value="C:\Program Files\boost_1_32_0"></property>
    <property name="mockrunner.jar" value="mockrunner-0.2.9.jar"></property>
    <property name="test.env.PATHEXT" value=".COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH"></property>
    <property name="test.env.TRAY_HOME" value="C:\Documents and Settings\Gili\My Documents\blueeye\trunk\com\be\tray"></property>
    <property name="emma.ant.jar" value="emma_ant-2.1.5214.jar"></property>
    <property name="test.env.USERPROFILE" value="C:\Documents and Settings\Gili"></property>
    <property name="compile.debug" value="true"></property>
    <property name="test.exclude" value="${test.exclude}"></property>
    <property name="test.env.ProgramFiles" value="C:\Program Files"></property>
    <property name="jgoodies.looks.jar" value="looks-1.3.1.jar"></property>
    <property name="test.env.PERL_HOME" value="C:\Program Files\Perl\bin"></property>
    <property name="java.endorsed.dirs" value="C:\Program Files\Java\jdk1.5.0_04\jre\lib\endorsed"></property>
    <property name="ant-junit.jar" value="ant-junit-1.6.5.jar"></property>
    <property name="test.env.ANT_HOME" value="C:\Program Files\ant-1.6.5"></property>
    <property name="test.env.PROMPT" value="$P$G"></property>
    <property name="jms.jar" value="jms-1.0.2b.jar"></property>
    <property name="sun.os.patch.level" value="Service Pack 2"></property>
    <property name="java.vendor.url" value="http://java.sun.com/"></property>
    <property name="test.env.VS71COMNTOOLS" value="C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\Tools\"></property>
    <property name="cayenne.test.connection" value="example1"></property>
    <property name="java.version" value="1.5.0_04"></property>
    <property name="java.vendor.url.bug" value="http://java.sun.com/cgi-bin/bugreport.cgi"></property>
    <property name="commons.logging.jar" value="commons-logging-1.0.4.jar"></property>
    <property name="test.env.USERDOMAIN" value="STALKER"></property>
    <property name="commons.lang.jar" value="commons-lang-2.1.jar"></property>
    <property name="user.name" value="Gili"></property>
    <property name="sun.io.unicode.encoding" value="UnicodeLittle"></property>
    <property name="test.resources" value="src/tests/resources"></property>
    <property name="sun.jnu.encoding" value="Cp1252"></property>
    <property name="java.runtime.name" value="Java(TM) 2 Runtime Environment, Standard Edition"></property>
    <property name="project.version" value="1.2-dev"></property>
    <property name="java.specification.name" value="Java Platform API Specification"></property>
    <property name="user.timezone" value=""></property>
    <property name="test.env.SystemDrive" value="C:"></property>
    <property name="path.separator" value=";"></property>
    <property name="test.env.JAVAMAIL_HOME" value="C:\Program Files\javamail-1.3.2"></property>
    <property name="test.env.USERNAME" value="Gili"></property>
    <property name="test.env.PROGUARD_HOME" value="C:\Program Files\proguard3.3.2"></property>
    <property name="test.env.JAI_HOME" value="C:\Program Files\jai"></property>
    <property name="test.env.ANT_CMD_LINE_ARGS" value="test -Dcayenne.test.connection example1"></property>
    <property name="project.name" value="cayenne"></property>
    <property name="file.encoding" value="Cp1252"></property>
    <property name="build" value="build"></property>
    <property name="test.env.COMPUTERNAME" value="STALKER"></property>
    <property name="servlet.jar" value="servlet-2.4.jar"></property>
    <property name="test.output" value="build/tests/out/example1"></property>
    <property name="ant.file" value="C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\build-tests.xml"></property>
    <property name="ant.jar" value="ant-1.6.5.jar"></property>
    <property name="test.env.ALLUSERSPROFILE" value="C:\Documents and Settings\All Users"></property>
    <property name="java.io.tmpdir" value="C:\DOCUME~1\Gili\LOCALS~1\Temp\"></property>
    <property name="user.language" value="en"></property>
    <property name="test.env.CYGWIN_HOME" value="C:\cygwin"></property>
    <property name="hsqldb.jar" value="hsqldb-1.7.3.3.jar"></property>
    <property name="test.env.PROCESSOR_REVISION" value="0209"></property>
    <property name="line.separator" value="
"></property>
    <property name="test.env.WINLAF_HOME" value="C:\Program Files\winlaf"></property>
    <property name="test.env.PROCESSOR_IDENTIFIER" value="x86 Family 15 Model 2 Stepping 9, GenuineIntel"></property>
    <property name="commons.dbcp.jar" value="commons-dbcp-1.2.1.jar"></property>
    <property name="regression.delete_objects_per_table" value="20"></property>
    <property name="test.env.LOGONSERVER" value="\\STALKER"></property>
    <property name="regression.commits_per_schema" value="3"></property>
    <property name="test.dist.src" value="dist/cayenne-1.2-dev/src/tests"></property>
    <property name="test.env.NUMBER_OF_PROCESSORS" value="2"></property>
    <property name="ashwood.jar" value="ashwood-1.1.jar"></property>
    <property name="java.vm.info" value="mixed mode, sharing"></property>
    <property name="sun.desktop" value="windows"></property>
    <property name="jdom.jar" value="jdom-1.0.jar"></property>
    <property name="java.vm.specification.name" value="Java Virtual Machine Specification"></property>
    <property name="ant.file.null" value="C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\build-tests.xml"></property>
    <property name="test.env._USE_CLASSPATH" value="yes"></property>
    <property name="compile.deprecation" value="false"></property>
    <property name="test.env._JAVACMD" value="C:\Program Files\Java\jdk1.5.0_04\bin\java.exe"></property>
    <property name="test.env.MAVEN_HOME" value="C:\Program Files\Maven 1.0.2"></property>
    <property name="test.env.JACE_HOME" value="C:\Documents and Settings\Gili\My Documents\jace\release"></property>
    <property name="test.env.Path" value="C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Executive Software\Diskeeper\;C:\Program Files\Subversion\bin;C:\Program Files\jprofiler4\bin\windows;c:\util;C:\Program Files\ant-1.6.5\bin;C:\Program Files\Maven 1.0.2\bin;C:\Program Files\TextPad 4;C:\Program Files\Java\jdk1.5.0_04\bin;C:\cygwin\bin"></property>
    <property name="cayenne.test.report" value="${cayenne.test.report}"></property>
    <property name="regression.max_foreign_keys_per_table" value="4"></property>
    <property name="test.env.HIBERNATE_HOME" value="C:\Program Files\hibernate-3.0"></property>
    <property name="java.awt.printerjob" value="sun.awt.windows.WPrinterJob"></property>
    <property name="vpp.jar" value="foundrylogic-vpp-2.2.1.jar"></property>
    <property name="test.report" value="build/tests/report/example1"></property>
    <property name="junit.jar" value="junit-3.8.1.jar"></property>
    <property name="test.env.APR_ICONV_PATH" value="C:\Program Files\Subversion\iconv"></property>
    <property name="test.src" value="src/tests/java"></property>
    <property name="test.env.JAF_HOME" value="C:\Program Files\jaf-1.0.2"></property>
    <property name="ant.version" value="Apache Ant version 1.6.5 compiled on June 2 2005"></property>
    <property name="test.env.TMP" value="C:\DOCUME~1\Gili\LOCALS~1\Temp"></property>
    <property name="test.env.ANT_OPTS" value="-Xmx250m"></property>
    <property name="emma.jar" value="emma-2.1.5214.jar"></property>
    <property name="test.env.windir" value="C:\WINDOWS"></property>
    <property name="regression.schema_count" value="10"></property>
    <property name="test.build" value="build/tests"></property>
    <property name="os.name" value="Windows XP"></property>
    <property name="java.specification.vendor" value="Sun Microsystems Inc."></property>
    <property name="test.env.CYGWIN" value="ntsec tty"></property>
    <property name="java.vm.name" value="Java HotSpot(TM) Client VM"></property>
    <property name="test.env.ComSpec" value="C:\WINDOWS\system32\cmd.exe"></property>
    <property name="java.library.path" value="C:\Program Files\Java\jdk1.5.0_04\jre\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\Program Files\DesktopBeautifier;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Executive Software\Diskeeper\;C:\Program Files\Subversion\bin;C:\Program Files\jprofiler4\bin\windows;c:\util;C:\Program Files\ant-1.6.5\bin;C:\Program Files\Maven 1.0.2\bin;C:\Program Files\TextPad 4;C:\Program Files\Java\jdk1.5.0_04\bin;C:\cygwin\bin"></property>
    <property name="test.env.MYSQL_HOME" value="C:\Program Files\MySQL"></property>
    <property name="ant.java.version" value="1.5"></property>
    <property name="test.env.CommonProgramFiles" value="C:\Program Files\Common Files"></property>
    <property name="basedir" value="C:\Documents and Settings\Gili\My Documents\cayenne\cayenne"></property>
    <property name="java.class.version" value="49.0"></property>
    <property name="velocity.jar" value="velocity-dep-1.3.jar"></property>
    <property name="ant.home" value="C:\Program Files\ant-1.6.5"></property>
    <property name="jgoodies.forms.jar" value="forms-1.0.3.jar"></property>
    <property name="dist" value="dist/cayenne-1.2-dev"></property>
    <property name="test.env.XPP3_HOME" value="C:\Program Files\xpp3"></property>
    <property name="test.env.CLIENTNAME" value="Console"></property>
    <property name="jgroups.jar" value="jgroups-2.2.7.jar"></property>
    <property name="log4j.jar" value="log4j-1.2.9.jar"></property>
    <property name="sun.boot.library.path" value="C:\Program Files\Java\jdk1.5.0_04\jre\bin"></property>
    <property name="sun.management.compiler" value="HotSpot Client Compiler"></property>
    <property name="java.awt.graphicsenv" value="sun.awt.Win32GraphicsEnvironment"></property>
    <property name="user.variant" value=""></property>
    <property name="test.env.NSIS_HOME" value="C:\Program Files\NSIS"></property>
    <property name="commons.collections.jar" value="commons-collections-3.1.jar"></property>
    <property name="test.env.JAXEN_HOME" value="C:\Program Files\jaxen-1.1-beta-6"></property>
    <property name="commons.beanutils.jar" value="commons-beanutils-1.6.1.jar"></property>
    <property name="java.vm.specification.version" value="1.0"></property>
    <property name="bcel.jar" value="bcel-5.1.jar"></property>
    <property name="test.env.FP_NO_HOST_CHECK" value="NO"></property>
    <property name="test.env.CAYENNE_HOME" value="C:\Program Files\cayenne-1.1.2"></property>
    <property name="awt.toolkit" value="sun.awt.windows.WToolkit"></property>
    <property name="sun.cpu.isalist" value=""></property>
    <property name="cayenne.test.config" value="${cayenne.test.config}"></property>
    <property name="java.ext.dirs" value="C:\Program Files\Java\jdk1.5.0_04\jre\lib\ext"></property>
    <property name="os.version" value="5.1"></property>
    <property name="dist.base" value="dist"></property>
    <property name="user.home" value="C:\Documents and Settings\Gili"></property>
    <property name="test.env.TEMP" value="C:\DOCUME~1\Gili\LOCALS~1\Temp"></property>
    <property name="java.vm.vendor" value="Sun Microsystems Inc."></property>
    <property name="regression.new_objects_per_table" value="40"></property>
    <property name="test.env.CACTUS_HOME" value="C:\Program Files\Cactus"></property>
    <property name="test.env.SESSIONNAME" value="Console"></property>
    <property name="test.env.DOM4J_HOME" value="C:\Program Files\dom4j"></property>
    <property name="user.dir" value="C:\Documents and Settings\Gili\My Documents\cayenne\cayenne"></property>
    <property name="ognl.jar" value="ognl-2.6.7.jar"></property>
    <property name="regression.max_references_per_table" value="4"></property>
    <property name="sun.cpu.endian" value="little"></property>
    <property name="otherlib.dir" value="otherlib"></property>
    <property name="test.bin" value="src/tests/bin"></property>
    <property name="java.vm.version" value="1.5.0_04-b05"></property>
    <property name="test.env.XSTREAM_HOME" value="C:\Program Files\xstream-1.1.2"></property>
    <property name="java.class.path" value="C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\ant-junit-1.6.5.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\commons-dbcp-1.2.1.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\commons-pool-1.2.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\emma-2.1.5214.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\emma_ant-2.1.5214.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\foundrylogic-vpp-2.2.1.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\jdom-1.0.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\jgroups-2.2.7.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\junit-3.8.1.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\mockrunner-0.2.9.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\mysql-connector-java-3.1.8-bin.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\servlet-2.4.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\otherlib\spring-1.1.5.jar;C:\Program Files\ant-1.6.5\lib\ant-antlr.jar;C:\Program Files\ant-1.6.5\lib\ant-apache-bcel.jar;C:\Program Files\ant-1.6.5\lib\ant-apache-bsf.jar;C:\Program Files\ant-1.6.5\lib\ant-apache-log4j.jar;C:\Program Files\ant-1.6.5\lib\ant-apache-oro.jar;C:\Program Files\ant-1.6.5\lib\ant-apache-regexp.jar;C:\Program Files\ant-1.6.5\lib\ant-apache-resolver.jar;C:\Program Files\ant-1.6.5\lib\ant-commons-logging.jar;C:\Program Files\ant-1.6.5\lib\ant-commons-net.jar;C:\Program Files\ant-1.6.5\lib\ant-icontract.jar;C:\Program Files\ant-1.6.5\lib\ant-jai.jar;C:\Program Files\ant-1.6.5\lib\ant-javamail.jar;C:\Program Files\ant-1.6.5\lib\ant-jdepend.jar;C:\Program Files\ant-1.6.5\lib\ant-jmf.jar;C:\Program Files\ant-1.6.5\lib\ant-jsch.jar;C:\Program Files\ant-1.6.5\lib\ant-junit.jar;C:\Program Files\ant-1.6.5\lib\ant-launcher.jar;C:\Program Files\ant-1.6.5\lib\ant-netrexx.jar;C:\Program Files\ant-1.6.5\lib\ant-nodeps.jar;C:\Program Files\ant-1.6.5\lib\ant-starteam.jar;C:\Program Files\ant-1.6.5\lib\ant-stylebook.jar;C:\Program Files\ant-1.6.5\lib\ant-swing.jar;C:\Program Files\ant-1.6.5\lib\ant-trax.jar;C:\Program Files\ant-1.6.5\lib\ant-vaj.jar;C:\Program Files\ant-1.6.5\lib\ant-weblogic.jar;C:\Program Files\ant-1.6.5\lib\ant-xalan1.jar;C:\Program Files\ant-1.6.5\lib\ant-xslp.jar;C:\Program Files\ant-1.6.5\lib\ant.jar;C:\Program Files\ant-1.6.5\lib\xercesImpl.jar;C:\Program Files\ant-1.6.5\lib\xml-apis.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\dist\cayenne-1.2-dev\lib\cayenne.jar;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\build\tests\classes;C:\Documents and Settings\Gili\My Documents\cayenne\cayenne\build\tests\deps"></property>
    <property name="os.arch" value="x86"></property>
    <property name="compile.optimize" value="true"></property>
    <property name="test.env.HOMEDRIVE" value="C:"></property>
    <property name="test.filter" value="**/*Tst.class"></property>
    <property name="test.env.OS" value="Windows_NT"></property>
    <property name="site.dir" value="dist/site"></property>
    <property name="java.vm.specification.vendor" value="Sun Microsystems Inc."></property>
    <property name="commons.pool.jar" value="commons-pool-1.2.jar"></property>
    <property name="file.separator" value="\"></property>
    <property name="regression.max_loops_per_table" value="3"></property>
    <property name="java.runtime.version" value="1.5.0_04-b05"></property>
    <property name="sun.boot.class.path" value="C:\Program Files\Java\jdk1.5.0_04\jre\lib\rt.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\i18n.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\jce.jar;C:\Program Files\Java\jdk1.5.0_04\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.5.0_04\jre\classes"></property>
    <property name="coverage.dir" value="build/tests/coverage"></property>
    <property name="test.env.APPDATA" value="C:\Documents and Settings\Gili\Application Data"></property>
    <property name="javacc.jar" value="javacc-3.2.jar"></property>
    <property name="test.env.SystemRoot" value="C:\WINDOWS"></property>
    <property name="user.country" value="CA"></property>
    <property name="test.env.PROCESSOR_ARCHITECTURE" value="x86"></property>
    <property name="regression.loop_count" value="10"></property>
    <property name="java.vendor" value="Sun Microsystems Inc."></property>
    <property name="test.env.HOMEPATH" value="\Documents and Settings\Gili"></property>
    <property name="test.env.PROCESSOR_LEVEL" value="15"></property>
    <property name="java.specification.version" value="1.5"></property>
    <property name="spring.jar" value="spring-1.1.5.jar"></property>
    <property name="sun.arch.data.model" value="32"></property>
  </properties>
  <testcase classname="junit.framework.TestSuite$1" name="warning" time="0.015">
    <failure message="Exception in constructor: testNewAdd (java.lang.RuntimeException: Error generating schema
        at org.objectstyle.cayenne.unit.CayenneTestResources.init(CayenneTestResources.java:156)
        at org.objectstyle.cayenne.unit.CayenneTestCase.&lt;init&gt;(CayenneTestCase.java:98)
        at org.objectstyle.cayenne.CayenneDOTestBase.&lt;init&gt;(CayenneDOTestBase.java:72)
        at org.objectstyle.cayenne.CDOMany2OneNoRevTst.&lt;init&gt;(CDOMany2OneNoRevTst.java:70)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at junit.framework.TestSuite.createTest(TestSuite.java:131)
        at junit.framework.TestSuite.addTestMethod(TestSuite.java:114)
        at junit.framework.TestSuite.&lt;init&gt;(TestSuite.java:75)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:277)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:1072)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:682)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeOrQueue(JUnitTask.java:1434)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:632)
        at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
        at org.apache.tools.ant.Task.perform(Task.java:364)
        at org.apache.tools.ant.Target.execute(Target.java:341)
        at org.apache.tools.ant.Target.performTasks(Target.java:369)
        at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
        at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
        at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
        at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
        at org.apache.tools.ant.Main.runBuild(Main.java:668)
        at org.apache.tools.ant.Main.startAnt(Main.java:187)
        at org.apache.tools.ant.Main.start(Main.java:150)
        at org.apache.tools.ant.Main.main(Main.java:240)
)" type="junit.framework.AssertionFailedError">junit.framework.AssertionFailedError: Exception in constructor: testNewAdd (java.lang.RuntimeException: Error generating schema
        at org.objectstyle.cayenne.unit.CayenneTestResources.init(CayenneTestResources.java:156)
        at org.objectstyle.cayenne.unit.CayenneTestCase.&lt;init&gt;(CayenneTestCase.java:98)
        at org.objectstyle.cayenne.CayenneDOTestBase.&lt;init&gt;(CayenneDOTestBase.java:72)
        at org.objectstyle.cayenne.CDOMany2OneNoRevTst.&lt;init&gt;(CDOMany2OneNoRevTst.java:70)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
)
</failure>
  </testcase>
  <system-out><![CDATA[INFO  QueryLogger: CREATE TABLE SIMPLE_LOCKING_TEST (DESCRIPTION VARCHAR(200) NULL, LOCKING_TEST_ID INT NOT NULL, NAME VARCHAR(100) NULL, PRIMARY KEY (LOCKING_TEST_ID))
INFO  QueryLogger: CREATE TABLE DATE_LOCKING_TEST (DATE_LOCK DATE NULL, DATE_LOCKING_TEST_ID INT NOT NULL, NAME VARCHAR(100) NULL, PRIMARY KEY (DATE_LOCKING_TEST_ID))
INFO  QueryLogger: CREATE TABLE TIME_LOCKING_TEST (NAME VARCHAR(100) NULL, TIME_LOCK DATETIME NULL, TIME_LOCKING_TEST_ID INT NOT NULL, PRIMARY KEY (TIME_LOCKING_TEST_ID))
INFO  QueryLogger: CREATE TABLE REL_LOCKING_TEST (NAME VARCHAR(100) NULL, REL_LOCKING_TEST_ID INT NOT NULL, SIMPLE_LOCKING_TEST_ID INT NULL, PRIMARY KEY (REL_LOCKING_TEST_ID))
INFO  QueryLogger: CREATE TABLE LOCKING_HELPER (LOCKING_HELPER_ID INT NOT NULL, NAME VARCHAR(100) NULL, REL_LOCKING_TEST_ID INT NULL, PRIMARY KEY (LOCKING_HELPER_ID))
INFO  QueryLogger: CREATE TABLE CLIENT_COMPANY (CLIENT_COMPANY_ID INT NOT NULL, NAME VARCHAR(100) NULL, PRIMARY KEY (CLIENT_COMPANY_ID))
INFO  QueryLogger: CREATE TABLE DEPARTMENT (DEPARTMENT_ID INT NOT NULL, MANAGER_ID INT NULL, NAME VARCHAR(100) NOT NULL, PRIMARY KEY (DEPARTMENT_ID))
INFO  QueryLogger: CREATE TABLE PERSON (CLIENT_COMPANY_ID INT NULL, CLIENT_CONTACT_TYPE VARCHAR(50) NULL, DEPARTMENT_ID INT NULL, NAME VARCHAR(100) NOT NULL, PERSON_ID INT NOT NULL, PERSON_TYPE CHAR(2) NOT NULL, SALARY FLOAT NULL, PRIMARY KEY (PERSON_ID))
INFO  QueryLogger: CREATE TABLE ADDRESS (ADDRESS_ID INT NOT NULL, CITY VARCHAR(100) NULL, PERSON_ID INT NOT NULL, PRIMARY KEY (ADDRESS_ID))
INFO  QueryLogger: CREATE TABLE DELETE_RULE_TEST2 (DEL_RULE_TEST2_ID INT NOT NULL, PRIMARY KEY (DEL_RULE_TEST2_ID))
INFO  QueryLogger: CREATE TABLE DELETE_RULE_TEST1 (DEL_RULE_TEST1_ID INT NOT NULL, TEST2_ID INT NOT NULL, PRIMARY KEY (DEL_RULE_TEST1_ID))
INFO  QueryLogger: CREATE TABLE FLATTENED_TEST_1 (FT1_ID INT NOT NULL, NAME VARCHAR(100) NOT NULL, PRIMARY KEY (FT1_ID))
INFO  QueryLogger: CREATE TABLE RELATIONSHIP_HELPER (NAME VARCHAR(100) NULL, RELATIONSHIP_HELPER_ID INT NOT NULL, PRIMARY KEY (RELATIONSHIP_HELPER_ID))
INFO  QueryLogger: CREATE TABLE TO_ONEFK2 (TO_ONEFK2_PK INT NOT NULL, PRIMARY KEY (TO_ONEFK2_PK))
INFO  QueryLogger: CREATE TABLE DELETE_RULE_TEST3 (DELETE_RULE_TEST_3_FK INT NULL, DELETE_RULE_TEST_3_ID INT NOT NULL, PRIMARY KEY (DELETE_RULE_TEST_3_ID))
INFO  QueryLogger: CREATE TABLE CLOB_MASTER (CLOB_COLUMN LONGTEXT NULL, CLOB_MASTER_ID INT NOT NULL, NAME VARCHAR(254) NULL, PRIMARY KEY (CLOB_MASTER_ID))
INFO  QueryLogger: CREATE TABLE CLOB_DETAIL (CLOB_DETAIL_ID INT NOT NULL, CLOB_MASTER_ID INT NULL, NAME VARCHAR(254) NULL, PRIMARY KEY (CLOB_DETAIL_ID))
INFO  QueryLogger: CREATE TABLE DELETE_RULE_FLATA (FLATA_ID INT NOT NULL, PRIMARY KEY (FLATA_ID))
INFO  QueryLogger: CREATE TABLE DELETE_RULE_FLATB (FLATB_ID INT NOT NULL, PRIMARY KEY (FLATB_ID))
INFO  QueryLogger: CREATE TABLE FLATTENED_TEST_2 (FT1_ID INT NULL, FT2_ID INT NOT NULL, NAME VARCHAR(100) NOT NULL, PRIMARY KEY (FT2_ID))
INFO  QueryLogger: CREATE TABLE DELETE_RULE_JOIN (FLATA_ID INT NOT NULL, FLATB_ID INT NOT NULL, PRIMARY KEY (FLATA_ID, FLATB_ID))
INFO  QueryLogger: CREATE TABLE MEANINGFUL_FK (MEANIGNFUL_FK_ID INT NOT NULL, RELATIONSHIP_HELPER_ID INT NOT NULL, PRIMARY KEY (MEANIGNFUL_FK_ID))
INFO  QueryLogger: CREATE TABLE REFLEXIVE_AND_TO_ONE (NAME VARCHAR(100) NULL, PARENT_ID INT NULL, REFLEXIVE_AND_TO_ONE_ID INT NOT NULL, RELATIONSHIP_HELPER_ID INT NULL, PRIMARY KEY (REFLEXIVE_AND_TO_ONE_ID))
INFO  QueryLogger: CREATE TABLE TO_ONEFK1 (TO_ONEFK1_FK INT NOT NULL, TO_ONEFK1_PK INT NOT NULL, PRIMARY KEY (TO_ONEFK1_PK))
INFO  QueryLogger: CREATE TABLE FLATTENED_TEST_3 (FT2_ID INT NULL, FT3_ID INT NOT NULL, NAME VARCHAR(100) NOT NULL, PRIMARY KEY (FT3_ID))
INFO  QueryLogger: CREATE TABLE COMPLEX_JOIN (EXTRA_COLUMN VARCHAR(50) NULL, FT1_FK INT NULL, FT3_FK INT NULL, PK INT NOT NULL, PRIMARY KEY (PK))
INFO  QueryLogger: CREATE TABLE SMALLINT_TEST (ID INT NOT NULL, SMALLINT_COL SMALLINT NULL, PRIMARY KEY (ID))
INFO  QueryLogger: CREATE TABLE TINYINT_TEST (ID INT NOT NULL, TINYINT_COL TINYINT NULL, PRIMARY KEY (ID))
INFO  QueryLogger: CREATE TABLE CHAR_PK_TEST (OTHER_COL CHAR(10) NULL, PK_COL CHAR(10) NOT NULL, PRIMARY KEY (PK_COL))
INFO  QueryLogger: CREATE TABLE GALLERY (GALLERY_ID INT NOT NULL, GALLERY_NAME VARCHAR(100) NOT NULL, PRIMARY KEY (GALLERY_ID))
INFO  QueryLogger: CREATE TABLE DATE_TEST (DATE_COLUMN DATE NULL, DATE_TEST_ID INT NOT NULL, TIMESTAMP_COLUMN DATETIME NULL, TIME_COLUMN TIME NULL, PRIMARY KEY (DATE_TEST_ID))
INFO  QueryLogger: CREATE TABLE BINARY_PK_TEST1 (BIN_ID VARBINARY(32) NOT NULL, NAME VARCHAR(10) NULL, PRIMARY KEY (BIN_ID))
INFO  QueryLogger: CREATE TABLE FLOAT_TEST (FLOAT_COL FLOAT NULL, ID INT NOT NULL, PRIMARY KEY (ID))
INFO  QueryLogger: CREATE TABLE ARTIST (ARTIST_ID INT NOT NULL, ARTIST_NAME CHAR(254) NOT NULL, DATE_OF_BIRTH DATE NULL, PRIMARY KEY (ARTIST_ID))
INFO  QueryLogger: CREATE TABLE BLOB_TEST (BLOB_COL LONGBLOB NULL, BLOB_TEST_ID INT NOT NULL, PRIMARY KEY (BLOB_TEST_ID))
INFO  QueryLogger: CREATE TABLE EXHIBIT (CLOSING_DATE DATETIME NOT NULL, EXHIBIT_ID INT NOT NULL, GALLERY_ID INT NOT NULL, OPENING_DATE DATETIME NOT NULL, PRIMARY KEY (EXHIBIT_ID))
INFO  QueryLogger: CREATE TABLE DECIMAL_PK_TST (DECIMAL_PK DECIMAL NOT NULL, NAME VARCHAR(100) NULL, PRIMARY KEY (DECIMAL_PK))
INFO  QueryLogger: CREATE TABLE GENERATED_COLUMN_COMP_M (ID INT NOT NULL, NAME VARCHAR(100) NULL, PRIMARY KEY (ID))
INFO  QueryLogger: CREATE TABLE MEANINGFUL_PK_TEST1 (DESCR VARCHAR(50) NULL, PK_ATTRIBUTE INT NOT NULL, PRIMARY KEY (PK_ATTRIBUTE))
INFO  QueryLogger: CREATE TABLE MEANINGFUL_PK_DEP (DESCR VARCHAR(50) NULL, MASTER_PK INT NULL, PK_ATTRIBUTE INT NOT NULL, PRIMARY KEY (PK_ATTRIBUTE))
INFO  QueryLogger: CREATE TABLE BINARY_PK_TEST2 (DETAIL_NAME VARCHAR(10) NULL, FK_ID VARBINARY(32) NULL, ID INT NOT NULL, PRIMARY KEY (ID))
INFO  QueryLogger: CREATE TABLE CLOB_TEST (CLOB_COL LONGTEXT NULL, CLOB_TEST_ID INT NOT NULL, PRIMARY KEY (CLOB_TEST_ID))
INFO  QueryLogger: CREATE TABLE PAINTING1 (ARTIST_ID INT NULL, ESTIMATED_PRICE DECIMAL(10, 2) NULL, GALLERY_ID INT NULL, PAINTING_ID INT NOT NULL, PAINTING_TITLE VARCHAR(255) NOT NULL, PRIMARY KEY (PAINTING_ID))
INFO  QueryLogger: CREATE TABLE GENERATED_COLUMN_TEST2 (GENERATED_COLUMN INT NOT NULL AUTO_INCREMENT, NAME VARCHAR(100) NULL, PRIMARY KEY (GENERATED_COLUMN))
INFO  QueryLogger: CREATE TABLE BIT_TEST (BIT_COLUMN BIT NOT NULL, ID INT NOT NULL, PRIMARY KEY (ID))
INFO  QueryLogger: CREATE TABLE COMPOUND_PK_TEST (KEY1 VARCHAR(20) NOT NULL, KEY2 VARCHAR(20) NOT NULL, NAME VARCHAR(255) NULL, PRIMARY KEY (KEY1, KEY2))
INFO  QueryLogger: CREATE TABLE GENERATED_COLUMN_TEST (GENERATED_COLUMN INT NOT NULL AUTO_INCREMENT, NAME VARCHAR(250) NULL, PRIMARY KEY (GENERATED_COLUMN))
INFO  QueryLogger: CREATE TABLE NO_PK_TEST (ATTRIBUTE1 INT NULL)
INFO  QueryLogger: CREATE TABLE ARTGROUP (GROUP_ID INT NOT NULL, NAME VARCHAR(100) NOT NULL, PARENT_GROUP_ID INT NULL, PRIMARY KEY (GROUP_ID))
INFO  QueryLogger: CREATE TABLE CHAR_FK_TEST (FK_COL CHAR(10) NULL, NAME VARCHAR(100) NULL, PK INT NOT NULL, PRIMARY KEY (PK))
INFO  QueryLogger: CREATE TABLE PAINTING (ARTIST_ID INT NULL, ESTIMATED_PRICE DECIMAL(10, 2) NULL, GALLERY_ID INT NULL, PAINTING_ID INT NOT NULL, PAINTING_TITLE VARCHAR(255) NOT NULL, PRIMARY KEY (PAINTING_ID))
INFO  QueryLogger: CREATE TABLE GENERATED_COLUMN_DEP (GENERATED_COLUMN_FK INT NOT NULL, NAME VARCHAR(100) NULL, PRIMARY KEY (GENERATED_COLUMN_FK))
INFO  QueryLogger: CREATE TABLE ARTIST_EXHIBIT (ARTIST_ID INT NOT NULL, EXHIBIT_ID INT NOT NULL, PRIMARY KEY (ARTIST_ID, EXHIBIT_ID))
INFO  QueryLogger: CREATE TABLE ARTIST_GROUP (ARTIST_ID INT NOT NULL, GROUP_ID INT NOT NULL, PRIMARY KEY (ARTIST_ID, GROUP_ID))
INFO  QueryLogger: CREATE TABLE GENERATED_COLUMN_COMP_KEY (AUTO_PK INT NOT NULL, GENERATED_COLUMN INT NOT NULL AUTO_INCREMENT, NAME VARCHAR(100) NULL, PROPAGATED_PK INT NOT NULL, PRIMARY KEY (AUTO_PK, GENERATED_COLUMN, PROPAGATED_PK))
ERROR CayenneTestResources: Error generating schema...
java.sql.SQLException: Incorrect table definition; there can be only one auto column and it must be defined as a key
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
        at com.mysql.jdbc.Statement.execute(Statement.java:911)
        at org.objectstyle.cayenne.unit.AbstractAccessStack.createSchema(AbstractAccessStack.java:299)
        at org.objectstyle.cayenne.unit.SimpleAccessStack.createSchema(SimpleAccessStack.java:149)
        at org.objectstyle.cayenne.unit.CayenneTestResources.rebuildSchema(CayenneTestResources.java:190)
        at org.objectstyle.cayenne.unit.CayenneTestResources.init(CayenneTestResources.java:152)
        at org.objectstyle.cayenne.unit.CayenneTestCase.<init>(CayenneTestCase.java:98)
        at org.objectstyle.cayenne.CayenneDOTestBase.<init>(CayenneDOTestBase.java:72)
        at org.objectstyle.cayenne.CDOMany2OneNoRevTst.<init>(CDOMany2OneNoRevTst.java:70)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at junit.framework.TestSuite.createTest(TestSuite.java:131)
        at junit.framework.TestSuite.addTestMethod(TestSuite.java:114)
        at junit.framework.TestSuite.<init>(TestSuite.java:75)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:277)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeInVM(JUnitTask.java:1072)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:682)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeOrQueue(JUnitTask.java:1434)
        at org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTask.java:632)
        at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
        at org.apache.tools.ant.Task.perform(Task.java:364)
        at org.apache.tools.ant.Target.execute(Target.java:341)
        at org.apache.tools.ant.Target.performTasks(Target.java:369)
        at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
        at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
        at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:40)
        at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
        at org.apache.tools.ant.Main.runBuild(Main.java:668)
        at org.apache.tools.ant.Main.startAnt(Main.java:187)
        at org.apache.tools.ant.Main.start(Main.java:150)
        at org.apache.tools.ant.Main.main(Main.java:240)
]]></system-out>
  <system-err><![CDATA[]]></system-err>
</testsuite>
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Andrus Adamchik
What version of MySQL are you using? I have 4.0.24 on Mac OS X and  
this statement works just fine.

I found an indication on google that it can be a problem with some  
versions of MySQL (so the statement needs to contain  
"'type=myisam'"). Autoincrements are a new feature in Cayenne and  
hasn't been tested across the board.

I guess if you could open a bug report (http://objectstyle.org/ 
cayenne/bugs-features.html) with your MySQL version, so that I can  
try to reproduce it. In your own checkout copy you can fix it by  
overriding "createTable" in the MySQLAdapter to generate syntax like  
this:

CREATE TABLE my_table (
  ...
) type=myisam;


Andrus



On Aug 29, 2005, at 1:32 PM, Gili wrote:

> INFO  QueryLogger: CREATE TABLE GENERATED_COLUMN_COMP_KEY (AUTO_PK  
> INT NOT NULL, GENERATED_COLUMN INT NOT NULL AUTO_INCREMENT, NAME  
> VARCHAR(100) NULL, PROPAGATED_PK INT NOT NULL, PRIMARY KEY  
> (AUTO_PK, GENERATED_COLUMN, PROPAGATED_PK))
> ERROR CayenneTestResources: Error generating schema...
> java.sql.SQLException: Incorrect table definition; there can be  
> only one auto column and it must be defined as a key
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
>     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
>     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
>     at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
>     at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
>     at com.mysql.jdbc.Statement.execute(Statement.java:911)
>     at org.objectstyle.cayenne.unit.AbstractAccessStack.createSchema
> (AbstractAccessStack.java:299)
>     at org.objectstyle.cayenne.unit.SimpleAccessStack.createSchema
> (SimpleAccessStack.java:149)
>

Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Gili

        I am using MySQL 4.1.12-nt and I only have InnoDB support installed (I
think). Isn't it possible for this statement to work on InnoDB
databases? I think they've become the default DB type as of MySQL 4.1

Gili

Andrus Adamchik wrote:

> What version of MySQL are you using? I have 4.0.24 on Mac OS X and  this
> statement works just fine.
>
> I found an indication on google that it can be a problem with some  
> versions of MySQL (so the statement needs to contain  "'type=myisam'").
> Autoincrements are a new feature in Cayenne and  hasn't been tested
> across the board.
>
> I guess if you could open a bug report (http://objectstyle.org/ 
> cayenne/bugs-features.html) with your MySQL version, so that I can  try
> to reproduce it. In your own checkout copy you can fix it by  overriding
> "createTable" in the MySQLAdapter to generate syntax like  this:
>
> CREATE TABLE my_table (
>  ...
> ) type=myisam;
>
>
> Andrus
>
>
>
> On Aug 29, 2005, at 1:32 PM, Gili wrote:
>
>> INFO  QueryLogger: CREATE TABLE GENERATED_COLUMN_COMP_KEY (AUTO_PK  
>> INT NOT NULL, GENERATED_COLUMN INT NOT NULL AUTO_INCREMENT, NAME  
>> VARCHAR(100) NULL, PROPAGATED_PK INT NOT NULL, PRIMARY KEY  (AUTO_PK,
>> GENERATED_COLUMN, PROPAGATED_PK))
>> ERROR CayenneTestResources: Error generating schema...
>> java.sql.SQLException: Incorrect table definition; there can be  only
>> one auto column and it must be defined as a key
>>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
>>     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
>>     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
>>     at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
>>     at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
>>     at com.mysql.jdbc.Statement.execute(Statement.java:911)
>>     at org.objectstyle.cayenne.unit.AbstractAccessStack.createSchema
>> (AbstractAccessStack.java:299)
>>     at org.objectstyle.cayenne.unit.SimpleAccessStack.createSchema
>> (SimpleAccessStack.java:149)
>>
>
>

--
http://www.desktopbeautifier.com/
Reply | Threaded
Open this post in threaded view
|

Re: ant test fails

Gili
In reply to this post by Andrus Adamchik

        I did ant clean and tried again. Now it looks like MySQL is simply
dieing because of too many open connections. My server is capped at 100
connections and I can see Cayenne opening up tons of them but never
closing it. The tests/out directory contain reports that indicate "too
many connections" too.

        Any idea where this configuration value is set? Meaning, how many
connections Cayenne will use under junit?

Gili
12