You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by hivie7510 <he...@audatex.com> on 2009/01/21 20:42:32 UTC
Setting derby.database.classpath lock failure
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.