db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dacia <axel.tisc...@gmx.de>
Subject Problems create SQL Function
Date Mon, 18 May 2009 12:22:36 GMT

Hi there

I try to create some SQL function, but I stuck:

[code]
create function getDate(timeNumber bigint) returns date
> language java external name
> 'java.util.Date(time)'
> parameter style java no sql;
0 rows inserted/updated/deleted
[/code]

now:

[code]
ij> values getDate(1234566712345667789);
ERROR 42X51: The class 'java.util' does not exist or is inaccessible. This
can happen if the class is not public.
ERROR XJ001: Java exception: 'java.util: java.lang.ClassNotFoundException'.
[/code]


What is wrong ?
 Thanx
-- 
View this message in context: http://www.nabble.com/Problems-create-SQL-Function-tp23595863p23595863.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message