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
<[EMAIL PROTECTED]> 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
<[EMAIL PROTECTED]>
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
