db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: can't remove jar file from database (ERROR X0X13)!!!
Date Tue, 13 May 2008 13:30:00 GMT
Thanks for the detailed explanation, Sebastian. Now I think I am 
tracking you.

The situation you describe sounds odd to me. If you bring down the VM 
which is running the database, does the orphaned copy of the jar file 
disappear from the subdirectory  under the database directory?

Thanks,
-Rick

Sebastian Pfaff wrote:
> Hi Rick,
>
> tnx for your answer, i think you understood everything. I'm writing
> this mail just to clarify things.
>
> My initial problem is: I installed a jar file (via install_jar
> command). And i cannot remove it with remove_jar command. But the jar
> file resides in the jar directory of the database. If i'm trying to
> delete the jar file i get this error:
>
> ERROR X0X13: Jar file 'SAMPLE1' does not exist in schema 'APP'.
>
> So i wanted to know, if it's possible to delete the jar file manually
> from file system. The thing i want to do is something like this:
>
> rm /home/me/DATACENTER/SM_DATA_LAYER/jar/APP/SAMPLE1.jar.G1210431624637
>
> But i'm not sure if this command will create inconsistencies within
> the database and something gets broken inside the database.
>
> If i'm right informed every jar file which is installed inside the
> database will be stored in the jar directory of the database (e.g.
> My_databse/jar). If i'm wrong, please correct me.
>
> Regards
>
> Sebastian Pfaff
>
>
>
> On Tue, May 13, 2008 at 12:54 AM, Rick Hillegas
> <Richard.Hillegas@sun.com> wrote:
>   
>> Hi Sebastian,
>>
>>  I'm not sure I'm understanding your question. Please bear with me. The
>> install_jar command copies the jar file from the file system into the
>> database. The remove_jar command deletes the jar file from the database.
>> Neither command alters the external file system. If you need to delete an
>> obsolete jar file from the file system, you can use ordinary operating
>> system commands.
>>
>>
>>
>>  Hope this helps,
>>  -Rick
>>
>>  Sebastian Pfaff wrote:
>>
>>     
>>> Hi Rick,
>>>
>>> tnx for your answer! Your snippet works fine (if i install/include a
>>> new jar file, your snippet shows me this). But when i have NO NEW
>>> ADDTIONIAL jars in my database installed and if i'm executing your SQL
>>> snippet:
>>>
>>> ij> SELECT s.schemaname, f.filename FROM sys.sysschemas s,
>>> sys.sysfiles f WHERE s.schemaid = f.schemaid
>>>
>>> i get this result:
>>>
>>> SCHEMANAME
>>>                                                         |FILENAME
>>>
>>>       
>> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>     
>>> 0 rows selected
>>>
>>> the jar file ISN'T listed here (!!!), but the jar file
>>> SAMPLE1.jar.G1210431624637  _IS_STILL_ in the filesystem:
>>>
>>> ls SM_DATA_LAYER/jar/APP/
>>> SAMPLE1.jar.G1210431624637
>>>
>>> So i have only one question:
>>>
>>> How can i remove this jar file (Would it be save to remove the jar
>>> file via a manual delete on the filesystem?)?
>>>
>>> Regards && tnx in advance
>>>
>>> Sebastian
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Mon, May 12, 2008 at 6:23 PM, Rick Hillegas <Richard.Hillegas@sun.com>
>>>       
>> wrote:
>>     
>>>       
>>>> Hi Sebastian,
>>>>
>>>>  The following query will show you the names of the jar files loaded
>>>>         
>> into
>>     
>>>> your database:
>>>>
>>>>  select s.schemaname, f.filename
>>>>  from sys.sysschemas s, sys.sysfiles f
>>>>  where s.schemaid=f.schemaid
>>>>
>>>>  So, for instance, the following script runs like this for me:
>>>>
>>>>  ij> call sqlj.install_jar( '/Users/rhillegas/junk/z.txt', 'APP.Foo',
0
>>>>         
>> );
>>     
>>>>  0 rows inserted/updated/deleted
>>>>  ij> select s.schemaname, f.filename
>>>>  from sys.sysschemas s, sys.sysfiles f
>>>>  where s.schemaid=f.schemaid
>>>>  ;
>>>>  SCHEMANAME
>>>> |FILENAME
>>>>
>>>>
>>>>         
>> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>     
>>>>  APP
>>>> |FOO
>>>>
>>>>  1 row selected
>>>>  ij> call sqlj.remove_jar( 'APP.Foo', 0 );
>>>>  0 rows inserted/updated/deleted
>>>>  ij> select s.schemaname, f.filename
>>>>  from sys.sysschemas s, sys.sysfiles f
>>>>  where s.schemaid=f.schemaid
>>>>  ;
>>>>  SCHEMANAME
>>>> |FILENAME
>>>>
>>>>
>>>>         
>> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>>     
>>>>  0 rows selected
>>>>
>>>>  Hope this helps,
>>>>  -Rick
>>>>
>>>>
>>>>
>>>>  Sebastian Pfaff wrote:
>>>>
>>>>
>>>>
>>>>         
>>>>> Hello,
>>>>>
>>>>> how can i see which jars are included in my database? I want to see
>>>>> all jars which are added through a call of 'CALL sqlj.install_jar
>>>>> [...]'.
>>>>>
>>>>> the main problem is:
>>>>>
>>>>> yesterday i added a jar to my database via the call of:
>>>>>
>>>>> ij> CALL
>>>>>
>>>>>
>>>>>           
>> sqlj.install_jar('/me/netBeansPojects/java/DerbyZeroCheck/dist/DatabaseRoutines.jar',
>>     
>>>>         
>>>>> 'APP.Sample1', 0);
>>>>>
>>>>> Notice: [...]Pojects[...] is a typo but that is ok!!!
>>>>>
>>>>> You can see the jar in the filesystem:
>>>>>
>>>>> ls DATACENTER/SM_DATA_LAYER/jar/APP/
>>>>> SAMPLE1.jar.G1210431624637
>>>>>
>>>>> today i tried to remove the jar via a call of:
>>>>>
>>>>> ij> CALL sqlj.remove_jar('APP.Sample1', 0);
>>>>>
>>>>> The call above always produces this errror:
>>>>>
>>>>> ERROR X0X13: Jar file 'SAMPLE1' does not exist in schema 'APP'.
>>>>>
>>>>> here the server side stacktrace:
>>>>>
>>>>> 2008-05-12 14:44:51.422 GMT Thread[DRDAConnThread_3,5,main] (XID =
>>>>> 13623), (SESSIONID = 0), (DATABASE = SM_DATA_LAYER), (DRDAID =
>>>>> NF000001.DF1C-1025975079512780256{2}), Cleanup action starting
>>>>> 2008-05-12 14:44:51.422 GMT Thread[DRDAConnThread_3,5,main] (XID =
>>>>> 13623), (SESSIONID = 0), (DATABASE = SM_DATA_LAYER), (DRDAID =
>>>>> NF000001.DF1C-1025975079512780256{2}), Failed Statement is: CALL
>>>>> sqlj.remove_jar('APP.Sample1', 0)
>>>>> ERROR X0X13: Jar file 'SAMPLE1' does not exist in schema 'APP'.
>>>>>       at
>>>>>
>>>>>
>>>>>           
>>>> org.apache.derby.iapi.error.StandardException.newException(Unknown
>>>>
>>>>
>>>>         
>>>>> Source)
>>>>>       at org.apache.derby.impl.sql.execute.JarUtil.drop(Unknown
>>>>>           
>> Source)
>>     
>>>>>       at org.apache.derby.impl.sql.execute.JarUtil.drop(Unknown
>>>>>           
>> Source)
>>     
>>>>>       at org.apache.derby.catalog.SystemProcedures.REMOVE_JAR(Unknown
>>>>>
>>>>>
>>>>>           
>>>> Source)
>>>>
>>>>
>>>>         
>>>>>       at
>>>>>
>>>>>
>>>>>           
>>>> org.apache.derby.exe.acf81e0010x0119xdd3bxc79bx00001d72cbbd1b.g0(Unknown
>>>>
>>>>
>>>>         
>>>>> Source)
>>>>>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>>>       at
>>>>>
>>>>>
>>>>>           
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>     
>>>>         
>>>>>       at
>>>>>
>>>>>
>>>>>           
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>     
>>>>         
>>>>>       at java.lang.reflect.Method.invoke(Method.java:597)
>>>>>       at
>>>>>
>>>>>
>>>>>           
>>>> org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown
>>>>
>>>>
>>>>         
>>>>> Source)
>>>>>       at
>>>>>
>>>>>
>>>>>           
>>>> org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown
>>>>
>>>>
>>>>         
>>>>> Source)
>>>>>       at
>>>>>
>>>>>
>>>>>           
>>>> org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
>>>>
>>>>
>>>>         
>>>>> Source)
>>>>>       at
>>>>>
>>>>>
>>>>>           
>>>> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
>>>>
>>>>
>>>>         
>>>>> Source)
>>>>>       at
>>>>>
>>>>>
>>>>>           
>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
>>     
>>>>         
>>>>> Source)
>>>>>       at
>>>>>
>>>>>
>>>>>           
>> org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(Unknown
>>     
>>>>         
>>>>> Source)
>>>>>       at
>>>>>
>>>>>
>>>>>           
>>>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown
>>>>
>>>>
>>>>         
>>>>> Source)
>>>>>       at org.apache.derby.impl.drda.DRDAStatement.execute(Unknown
>>>>>           
>> Source)
>>     
>>>>>       at
>>>>>           
>> org.apache.derby.impl.drda.DRDAConnThread.parseEXCSQLSTT(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
>>>>>
>>>>> If i'm trying to include/install an additional jar file everything
>>>>>           
>> works
>>     
>>>>>           
>>>> fine:
>>>>
>>>>
>>>>         
>>>>> ij> CALL sqlj.install_jar(
>>>>>   '/me/netBeansPojects/java/DerbyZeroCheck/dist/DatabaseRoutines.jar',
>>>>> 'APP.Sample1', 0);
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>           
>>>>>> Statement executed.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>> here layout of filesystem before removing:
>>>>>
>>>>> ls DATACENTER/SM_DATA_LAYER/jar/APP/
>>>>> SAMPLE1.jar.G1210431624637  SAMPLE1.jar.G1210597561003
>>>>>
>>>>> ij> CALL sqlj.remove_jar('APP.Sample1', 0);
>>>>> Statement executed.
>>>>> ij>
>>>>>
>>>>> layout just after removing:
>>>>>
>>>>> ls DATACENTER/SM_DATA_LAYER/jar/APP/
>>>>> SAMPLE1.jar.G1210431624637
>>>>>
>>>>> It seems to be impossible to remove the file named
>>>>> 'SAMPLE1.jar.G1210431624637'! It would be nice to know, how to make
>>>>> included/installed jars visible and how to remove them if a call of
>>>>> sqlj.remove_jar fails.
>>>>>
>>>>> Is it save to remove the file manually from filesystem (e.g. rm
>>>>> SAMPLE1.jar.G1210431624637)?
>>>>>
>>>>> my environment is:
>>>>>
>>>>> Linux 2.6.25.1 && java version "1.6.0_06 && derby 10.4
>>>>>
>>>>>
>>>>> If you need additional infos, please let me know. Any help is
>>>>>           
>> appreciated.
>>     
>>>>> TNX in advance!
>>>>>
>>>>> Sebastian
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>           
>>>>         
>>     


Mime
View raw message