Thanks for ideas, Dag -- On Wed September 19 2007, Dag H. Wanvik wrote: > Mikhail Umorin writes: > > As for the IncompatibleClassChangeError, I don't know why you get this > here, you may want to print out any nested exceptions you get, which > might provide more information on the cause. > (http://java.sun.com/javase/6/docs/api/java/sql/SQLException.html#getNextEx >ception()) . > > Also, do you see anything in derby.log on the server? here is more details on the nested exceptions (I submitted a but report and waiting for its confirmation): ---SQLException Caught--- SQLState: XJ001 Severity: -1 Message: Java exception: ': java.lang.IncompatibleClassChangeError'. org.apache.derby.client.am.SqlException: Java exception: ': java.lang.IncompatibleClassChangeError'. at org.apache.derby.client.am.ResultSet.completeSqlca(Unknown Source) at org.apache.derby.client.net.NetResultSetReply.parseFetchError(Unknown Source) at org.apache.derby.client.net.NetResultSetReply.parseCNTQRYreply(Unknown Source) at org.apache.derby.client.net.NetResultSetReply.readFetch(Unknown Source) at org.apache.derby.client.net.ResultSetReply.readFetch(Unknown Source) at org.apache.derby.client.net.NetResultSet.readFetch_(Unknown Source) at org.apache.derby.client.am.ResultSet.flowFetch(Unknown Source) at org.apache.derby.client.net.NetCursor.getMoreData_(Unknown Source) at org.apache.derby.client.am.Cursor.next(Unknown Source) at org.apache.derby.client.am.ResultSet.nextX(Unknown Source) at org.apache.derby.client.am.ResultSet.next(Unknown Source) at meteorology.TAtmosphere.averageSurfaceQuery(TAtmosphere.java:906) at meteorology.TAtmosphere.temperature(TAtmosphere.java:341) at meteorology.TAtmosphere.temperature(TAtmosphere.java:321) at interactors.SmallLakeSetting.stepSetup(SmallLakeSetting.java:146) at simulation.Simulation.stepSetup(Simulation.java:141) at simulation.LakeWacoSimulation.stepSetup(LakeWacoSimulation.java:564) at simulation.Simulation.execute(Simulation.java:195) at runs.LakeWacoSimulationRun.main(LakeWacoSimulationRun.java:42) ---SQLException Caught--- # # An unexpected error has been detected by Java Runtime Environment: # # Internal Error (53484152454432554E54494D450E435050020F), pid=10433, tid=2 # # Java VM: Java HotSpot(TM) Server VM (1.6.0_02-b05 mixed mode) # An error report file with more information is saved as hs_err_pid10433.log # # If you would like to submit a bug report, please visit: # http://java.sun.com/webapps/bugreport/crash.jsp # derbyError.log says: Server is ready to accept connections on port 1527. Server is ready to accept connections on port 1527. Connection number: 1. ---------------------------------------------------------------- 2007-09-20 00:26:26.437 GMT: Booting Derby version The Apache Software Foundation - Apache Derby - 10.1.1.1 - (292855): instance c013800d-0115-204e-e638-000013609dc5 on database directory /home/user0106/derbyDB/reservoirDB Database Class Loader started - derby.database.classpath='' 2007-09-20 00:26:26.632 GMT Thread[DRDAConnThread_4,5,derby.daemons] (DATABASE = reservoirDB), (DRDAID = {1}), Cloudscape Network Server connected to database reservoirDB Connection number: 2. ---------------------------------------------------------------- 2007-09-20 00:26:26.669 GMT: Booting Derby version The Apache Software Foundation - Apache Derby - 10.1.1.1 - (292855): instance a816c00e-0115-204e-e638-000013609dc5 on database directory /home/user0106/derbyDB/streamDB Database Class Loader started - derby.database.classpath='' 2007-09-20 00:26:26.681 GMT Thread[DRDAConnThread_5,5,derby.daemons] (DATABASE = streamDB), (DRDAID = {2}), Cloudscape Network Server connected to database streamDB Connection number: 3. ---------------------------------------------------------------- 2007-09-20 00:26:26.704 GMT: Booting Derby version The Apache Software Foundation - Apache Derby - 10.1.1.1 - (292855): instance 601a400f-0115-204e-e638-000013609dc5 on database directory /home/user0106/derbyDB/weatherDB Database Class Loader started - derby.database.classpath='' 2007-09-20 00:26:26.716 GMT Thread[DRDAConnThread_6,5,derby.daemons] (DATABASE = weatherDB), (DRDAID = {3}), Cloudscape Network Server connected to database weatherDB 2007-09-20 00:26:31.028 GMT Thread[DRDAConnThread_6,5,derby.daemons] (XID = 31), (SESSIONID = 0), (DATABASE = weatherDB), (DRDAID = NF000001.O2FB-4124733118469966341{3}), Cleanup action starting 2007-09-20 00:26:31.029 GMT Thread[DRDAConnThread_6,5,derby.daemons] (XID = 31), (SESSIONID = 0), (DATABASE = weatherDB), (DRDAID = NF000001.O2FB-4124733118469966341{3}), Failed Statement is: Select min(datetime) from instant_weather inner join instant_surface on instant_weather.instant_weather_id = instant_surface.instant_weather_id where datetime >= ? and dry_bulb_temperature IS NOT NULL java.lang.IncompatibleClassChangeError at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.doProjection(Unknown Source) at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source) at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source) at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.writeFDODTA(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.writeQRYDTA(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source) at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source) Cleanup action completed Connection number: 4. Shutdown successful. Connection number: 1. Connection number: 2. Connection number: 3. Connection number: 4. Connection number: 5. Connection number: 6. Connection number: 7. Connection number: 8. Connection number: 9. Connection number: 10. Connection number: 11. Connection number: 12. Connection number: 13. Connection number: 14. Connection number: 15. Connection number: 16. Connection number: 17. Connection number: 18. Connection number: 19. Connection number: 20. > > As for compiling Derby with JDK 1.6: > > I think i use a plain "xalan.jar", which in addition to xalan-j2-2.7.0 > contains some supporting packages, perhaps that is why you have an > compile time issue with xpath and serializer. > (see http://xml.apache.org/xalan-j/downloads.html). I downloaded latest xalan distribution binary (xalan-j_2_7_0-bin-2jars.tar.gz). Added jars to the CLASSPATH. They do contain org.apache.xpath and other packages but ant still complains that they are missing. > > As for the problem with the the abstract method > (EmbedDatabaseMetaData), this line in ant.properties is wrong: > > j14lib=/usr/local/jdk1.6.0_02/jre/lib > > It should point to the JDK 1.4, not to JDK 1.6, even if you use the > 1.6 compiler. (Derby needs to compile some of the sources with a > JDK1.4 source level and runtime, in order for the resulting product to > be runnable on multiple platform versions). > Does this mean that apps compiled under java 1.6 may not be cross-platform? Could this be the reason why I get the error because some derby classes were compiled with 1.4 level but those classes are different in jvm 1.6? Thank you for the input, Mikhail