[
https://issues.apache.org/jira/browse/DERBY-5438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen resolved DERBY-5438.
---------------------------------------
Resolution: Fixed
Fix Version/s: 10.9.0.0
10.8.2.2
Issue & fix info: (was: Patch Available)
Committed revision 1177589.
Merged to 10.8 and committed revision 1177591.
> Empty MAPS table in toursdb
> ---------------------------
>
> Key: DERBY-5438
> URL: https://issues.apache.org/jira/browse/DERBY-5438
> Project: Derby
> Issue Type: Bug
> Components: Demos/Scripts
> Affects Versions: 10.7.1.1, 10.8.1.2, 10.8.2.1
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Fix For: 10.8.2.2, 10.9.0.0
>
> Attachments: d5438.diff
>
>
> The toursdb that's bundled with 10.7.1.1 and 10.8.1.2 (and the 10.8.2.1
> release candidate) has no rows in the MAPS table. Version 10.6.2.1 had three
> rows in that table:
> ij> select * from maps;
> MAP_ID |MAP_NAME |REGION |AREA
> |PHOTO_FORMAT |PICTURE
>
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> 1 |North Ocean |Cup Island |1776.1100
> |gif
> |4749463839613601fe00f70000000000800000008000808000000080800080008080808080c0c0c0ff000000ff00ffff000000ffff00ff00ffffffffff00000&
> 2 |Middle Ocean |Small Island |1166.7700
> |gif
> |47494638396192008e00f70000000000800000008000808000000080800080008080808080c0c0c0ff000000ff00ffff000000ffff00ff00ffffffffff00000&
> 3 |South Ocean |Witch Island |9117.9000
> |gif
> |474946383961f602f301f70000000000800000008000808000000080800080008080808080c0c0c0ff000000ff00ffff000000ffff00ff00ffffffffff00000&
> 3 rows selected
> Building it on a clean trunk and looking at generated/toursdb/toursdb.out
> gives the following hint:
> FAIL -- unexpected exception: java.sql.SQLException: Database 'toursDB' not
> found.
> java.sql.SQLException: Database 'toursDB' not found.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:98)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:142)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:148)
> at
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:227)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java:3085)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(EmbedConnection.java:735)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:414)
> at
> org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java:73)
> at
> org.apache.derby.impl.jdbc.EmbedConnection40.<init>(EmbedConnection40.java:51)
> at
> org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Driver40.java:70)
> at
> org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:248)
> at
> org.apache.derby.jdbc.AutoloadedDriver.connect(AutoloadedDriver.java:146)
> at java.sql.DriverManager.getConnection(DriverManager.java:582)
> at java.sql.DriverManager.getConnection(DriverManager.java:207)
> at toursdb.insertMaps.main(insertMaps.java:51)
> Caused by: java.sql.SQLException: Database 'toursDB' not found.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:122)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:71)
> ... 14 more
> I suspect this was introduced by the changes in DERBY-3986 when the
> destination directory for toursdb was changed.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
