geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hivie7510 <heath.i...@audatex.com>
Subject Setting derby.database.classpath lock failure
Date Wed, 21 Jan 2009 19:42:32 GMT

For starters, i am a complete newbie, so slam if you wish.
I am trying to create a function in java for derby that will return the day
of week, aka SUNDAY,MONDAY, etc.  So this is what I have tried:
CALL SQLJ.install_jar('c:\DateFunction.jar',
'APP.RFRTracker."DateFunction!"', 0);


--Set the class path for the DateFunction
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
'derby.database.classpath',
'APP.DateFunction!')


create function app.dayOfWeek
    ( dateValue date )
    returns int
    parameter style java
    no sql
    language java
    external name 'mynamespace.DateFunctions.dayOfWeek'
;

The problem is in the second call to the the class path.  Derby fails to
obtain a lock.  I am not sure if that is because Geronimo is also connected
or what is the deal. I am the only user (human) in the console.  I am trying
to use the procedure outlined in 
http://mail-archives.apache.org/mod_mbox/db-derby-user/200510.mbox/%3C43418926.6010407@sun.com%3E
http://mail-archives.apache.org/mod_mbox/db-derby-user/200510.mbox/%3C43418926.6010407@sun.com%3E
.  I am trying to load the jars in the database because I thought that this
would be easier, because I  do not know how to set the classpath to inlcude
another directory or if there is already a directory in geronimo that is
designed for this.

Any help is appreciated,
Thanks
Heath
-- 
View this message in context: http://www.nabble.com/Setting-derby.database.classpath-lock-failure-tp21590716s134p21590716.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.


Mime
View raw message