[ http://issues.apache.org/jira/browse/DERBY-1479?page=all ]

Andrew McIntyre updated DERBY-1479:
-----------------------------------

    Attachment: jartest3.jar

Attempting to connect to the database in this jar, which was created with Derby 
10.0, illustrates the problem with soft upgrade. The problem can be reproduced 
with ij by trying to connect to the database in this jar as follows:

$ java org.apache.derby.tools.ij
ij version 10.1
ij> connect 'jdbc:derby:jar:({pathtothejarfile}/jartest3.jar)jartest';
ERROR XJ040: Failed to start database 
'jar:(/Users/andrewm/derby10/testdir/jar/jartest3.jar)jartest', see the next 
exception for details.
ERROR 40XD1: Container was opened in read-only mode.  

ij is unable to establish a connection and it is not possible to perform any 
actions on the database in the jar. If the database in the jar is upgraded to 
the 10.1 format, it is possible to connect to the database and select data from 
the table in the database. Post-upgrade:

$ java org.apache.derby.tools.ij
ij version 10.1
ij> connect 'jdbc:derby:jar:({pathtothejarfile}/jartest4.jar)jartest';
ij> select * from t1;
C1         |C2         
-----------------------
1          |2          
3          |4          


> A Derby 10.0 database in a jar cannot be accessed by Derby 10.1
> ---------------------------------------------------------------
>
>          Key: DERBY-1479
>          URL: http://issues.apache.org/jira/browse/DERBY-1479
>      Project: Derby
>         Type: Bug

>   Components: Store
>     Versions: 10.1.3.1, 10.1.2.1, 10.1.1.0
>     Reporter: Andrew McIntyre
>      Fix For: 10.2.0.0, 10.1.4.0, 10.1.3.2
>  Attachments: jartest3.jar
>
> Attempting to connect to a database in a jar created with Derby 10.0 fails 
> when trying to connect with Derby 10.1. The following error is thrown:
> ERROR XJ040: Failed to start database 'jar:(pathtojarfile)pathinjar', see the 
> next exception for details.
> ERROR 40XD1: Container was opened in read-only mode. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Reply via email to