cess under Windows will help.
With kind regards
Thomas
> We are using the Derby in network server mode.
> It is configured as datasource in WildFly 9.0.1
> Our application runs on this WildFly and connecting to the Derby via
> Hibernate.
>
> The setup with Windows Server 2012
;what I want?
>
>TIA,
Hi,
Can this problem be solved by an correlating sub select?!
Maybe something like this:
Select * from x where not exists ( select 1 from y where x.a = y.a and x.b =
y.b )
Or like your first SQL but convert to string and concatenate that would work
but probably very slow as no index could be used.
With kind regards
Thomas
in a
ServletListener.contextDestroyed() method?
With kind regards
Thomas
Many Thanks Rick - deleting the ".lck" files in the root directory solved
the issue.
Hi,
I am getting below error even after the derby server and the server machine
had been shutdown and brought up again. Might this indicate the data base is
corrupt? Is ther any way to further diagnose what is going on?
Thanks
java.util.concurrent.ExecutionException: java.lang.RuntimeException:
Thomas writes:
>
>
> Hi,
>
> is there any way to tell Derby where to store the derby.log file?
> (note: I am not referring to the database log file here, but to the file
> into which protocoll messages are logged).
>
> If not, what is the logic used to det
Hi,
is there any way to tell Derby where to store the derby.log file?
(note: I am not referring to the database log file here, but to the file
into which protocoll messages are logged).
If not, what is the logic used to determine where this is stored?
Thanks
Rick Hillegas writes:
I am running the 10.9.1.0 server using the basic security manager with the
default security policy settings.
Trying to inspect the system property settings from a stored procedure which
includes using java.lang.System.getProperty() I am getting:
Error: The exception 'java.
27; column.
SQLState: 4251E
ErrorCode: -1
But I am not trying to select the password column!?
Thanks
Thomas
f a system
property? I have not found a system procedure for this.
Thanks for looking into this again.
Kind regards
Thomas
Hi,
is there a way to find out when the password of the user logged in will
expire so an application can display a message like "Your password will
expire in x days. Do you want to change it now?"
Thanks
Dag,
I am not using CA certs, but self-signed certificates. Would you mind having a
look at my server truststore file if I email it to you?
Kind regards
Thomas
Ups - had attached this answer to the wrong mail tread first.
Thanks. Let me know if you want me to share with you the keystores used or the
scripts run for starting the server/ij.
Thanks. Let me know if you want me to share with you the keystores used or the
scripts run for starting the server/ij.
yes, I did check the docs. My serverTrustStore was populated as described in the
manual, i.e.
"Install a client certificate in the server's trust store:
keytool -import -alias aDerbyClient -file aClient.cert
-keystore serverTrustStore.key"
As said my expectation was installing just the c
Hi,
currently trying to switch from basic authentication to peer Authentication, but
having trouble with understanding serverTrustStore content.
Have gone through the following scenarios:
1) in my current set-up I am starting the network server and the client(s) with
basic authentication - this wo
favoured over the other when having Oracle
portability in mind?
Thanks a lot for sharing your experience and advise.
Kind regards
Thomas
Hi,
I am trying to export a comma separated list from the syscatalog tables to a
file which holds the following information:
schemaname, tablename, columnname, columdatatype and javadatatype.
e.g.
appl, mytable, column2, char(1), java.lang.String
appl, mytable, column2, integer, java.lang.Integer
> Hi Thomas,
>
> I think you'd need to add a REFERENCING clause to the trigger definition
> and pass in the new value as an argument to the procedure. Something
> like:
>
> CREATE TRIGGER "TR_XY"
> AFTER INSERT
> ON "TBL_XY&quo
Rick Hillegas writes:
>
> On 10/21/12 11:45 PM, Thomas Hill wrote:
> > CREATE TRIGGER "TR_XY"
> >AFTER INSERT
> >ON "TBL_XY"
> >FOR EACH ROW
> >CALL PROCEDURE "SP_xy"('xyz', 0);
> Hi Thomas,
>
Hello,
the Wiki mentions a trigger can also call a procedure rather than scripting the
SQL statement on the create trigger statement. The documentation as far as I can
see does not give an example of that.
Would this be the right syntax?
CREATE TRIGGER "TR_XY"
AFTER INSERT
ON "TBL_XY"
FOR E
at shows how to create an
application database which makes use of native authentication?
Thanks a lot in advance
Thomas
Hi,
can someone please share an example how the Client side application code to call
procedure looks like when I want my stored procedure to return TWO resultsets?
The derby Wiki (extract see below) says 'WORK IN PROGRESS' in the section where
documentation on this had been started.
CallableStatem
if I understand correctly you need a 'group by' in your query;
so like
SELECT day("dtmDateCompleted") as "Day",
"A"."strName" AS "Category",
COUNT(*)
FROM "tblAssetCategory" "AC"
INNER JOIN "tblAsset" "A" ON "AC"."id" = "A"."intCategoryID"
INNER JOIN "tblWorkOrd
conn.getMetaData().getUserName() seems to be exactly what I have been looking
for
Thanks for this and also all the feedback I have received on my initial question
Regards
Thomas
27; tab that I would suspect they are getting
via such mechanisms.
In the derby docs I am afraid one hardly finds details on the subject.
Thanks Thomas
s for your support
Thomas
Thanks Knut for pointing me in the right direction.
t; varchar(128))
LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL SECURITY DEFINER
MODIFIES SQL DATA EXTERNAL NAME '...SP_getRole'
;
HOWEVER when running this now row is returned!
I also tried
" WHERE CURRENT_ROLE='\\\"DB_READER\\\"'";
but this also did not lead to success.
Any hints appreciated.
Thanks
Thomas
Hi Team,
We are using derby-10.4.1.3 in our application. Recently, we faced an
issue in using this derby database with an exception
java.sql.SQLTransactionRollbackException: A lock could not be obtained
within the time requested
I would like to know under what scenario this exception could occur
David,
I am afraid Derby doesn't implement variables - I had been looking for this
myself also some time back when writing Derby scripts for test data
creation/manipulation. I finally ended up writing small Java programs where
needed instead of or on top of just scripts. Since a couple of days I a
ated, by someone else working independently."
I would really like to reproduce the results, to understand what you
have tested exactly, and to find out how fast H2 is in those tests.
> I would
> still encourage people to do their own benchmarking when making
> decisions on performance.
Me too :-)
Regards,
Thomas
ny results. Remove the benchmark results from your
web site or we will sue you." Unfortunately I don't have this email
any more :-) With open source, you have open mailing lists and you can
discuss it. Also the licenses tend to be more liberal.
Regards,
Thomas
okay, the address already in use being due to too quick request attempts might
be an explanation. I have in the meantime found out that, although the address
already in use error is given and the log does not contain the normal 'server
started and ready to accept connections' statements ==> the ser
Hi Morten,
thanks for your reply "on the address already in user issue". The Network Server
is hosted on the internet and my provider tells me that nothing else is using
the port and their tests would indicate that - the normal (Linux) start/stop
scripts coming with Derby are being used - when the
way to get the database up and running again. Even after a
complete shutdown and restart of the server I continue to get the 'another
instance...' error. So I am not sure if my database might have been corrupted??
Any way to find out what is going on?
Thanks
Thomas
Wed Feb 23 20:2
>From time to time I am running into the following situation
with my hosted Derby Network Server (in the hosted environment
the Tomcat start (/stop) script is used to also start (/stop)
Derby) hwne attempting to start the server:
Sun Feb 20 18:25:11 CET 2011 : Security manager installed
using the
> This means that a) you are running with the Java security manager
> enabled, and b) you need to add a missing SocketPermission to the
> derby.jar codebare in a policy file, cf.
>
ad a) yes, the security manager enabled is the default java security manager
which is what is confirmed in derby.log
I have now tested the following two scenarios in conjunction with the network
driver:
1) using system-wide properties rather than data-base level properties
2) as you suggested, supply the properties as command line parameters
ad 1) when trying to connect using IJ I continue to receive error 0800
n you please advise on next steps?, i.e. should I create a JIRA issue
immediately or will/should someone from the development try to reproduce
first?
Regards
Thomas
Thanks for reading my post. Any help to get Derby work with LDAP would be
greatly appreciated.
What I am trying to achieve and what I have done so far:
I would like to prepare my system for production use and migrate off the
BUILTIN authentication system to use LDAP as external directory servic
Hi,
is it possible to run for example a network server in version 10.6 in parallel
to running the current version 10.7 on one and the same (server) machine? If so,
how would a client program like IJ know to which server to connect to?
Thanks
I will try to summarise my experiences in the wiki once I have completed my full
round trip of what I am/was trying to achieve:
1) have a JAVA provider (in Germany) host a Derby Network Server for me - done
2) have them run the Derby Server using SSL encryption and peer authentication -
done
3) be
After many hours of further investigation I have been able to overcome all road
blocks and now successfully use SSL certificates (created and signed using
openSSL and converted in jks keystores using keytool) and peer Authentication
between server and client. I wish though the certificate expiry da
Hi,
I am stuck with this problem and would appreciate any help.
Thanks
Thomas
MD5: 8D:D4:44:B6:37:EC:51:CD:25:85:E8:F1:0A:A9:30:2D
SHA1: E7:04:DB:FC:DA:16:FE:46:88:56:C5:0B:65:D5:0F:DF:AC:0E:A1:D7
Signature algorithm name: SHA1withRSA
Version: 3
Any help would be greatly appreciated.
Thanks
Thomas
Sonny Laskar writes:
>
>
> Dear All,I am new to Derby.I have forgotten the username/password set for
connecting to my derby database.Now when I tried to connect , i get the invalid
authentication error (ERROR 08004: Connection refused : Invalid
authentication.)Please let me know if I can reset
re? can I still use self-signed certificates? do I need
a specific algorithm / type of certificate? (RSA instead of DES)?
Thanks for your support
Thomas
Hi,
can someone please advise what is determining the language which will be seen in
error messages? Is this depend on the locale of the machine? I am currently
seeing messages in german, but would like to switch to english, but don't know
how to do that.
Thanks in advance
Thomas
Hi,
is there a way to make scripts stop (and the transaction rollbacked) when an
error is thrown rather than IJ just continuing the execution with the next
statement?
Thanks
When implementing the data model for my application using Derby and coding some
stored procedures in JAVA over the past months I have asked myself a couple of
times along the way what the best approach to fulfil some 'standard'
requirements would be - general requirements which I would expect most
Hi,
on 10th July I implemented SSL encryption between my network server and its
clients. The certificates were self-generated using the keytool utility.
I am starting the server requesting peer authentication. I am starting IJ with
proper references to my client keystore. When trying to connect to
when calling commit I am no longer getting error 25001.
Now I have a different problem: the lifetime of the set role seems to be limited
to the stored procedure itself - after returning to the main program my role is
NULL again. I have double-checked using the debugger and confirmed that the set
The procedure is the first call to the data base after opening the connection,
so there is no transaction open/pending from outside this procedure.
Within the procedure itself however I need to query the catalog to see if a
role
is already set and only if this is not the case set the role as ne
Hi,
can someone please advise if it is possible to execute a 'set role' command
within a stored procedure? My code runs fine when being part of the java
program, but throws "ERROR 25001: Invalid transaction state: active SQL
transaction." when put inside a java stored procedure. Some documentation
I've used launch4j (http://sourceforge.net/projects/launch4j/) to package
multiple JARs into a single Windows executable.
Or, you can un-JAR derby.jar (jar -xf derby.jar), add your class files to the
same directories, and re-JAR everything into one.
Regards,
Thomas Taylor
-Ori
I have now entered an improvement request in JIRA - or to be more precise I have
added to and voted for existing request derby-4551.
Hi,
can someone please advise how the password of a user can be changed? My database
requires authentication, is using the BUILTIN authentication provider and I have
defined users as database properties using the system procedure
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.user.xxx,...
I
confirm that with
the firewall turned off you can connect to the derby network server.
FYI. you will normally see a “Connection Timeout” message when either the
destination (server) IP address is wrong, or the network server has not
started.
Best regards,
Thomas Taylor
From: Fabricio
Do I understand correctly that, if my procedures had been defined by the
database owner (which they were in my case), then additional grants would not be
required => would Derby support running routines with definer's privileges? If
so, I would file an improvement request.
For the time being, is t
Hi,
having set-up SQL authorisation I would like to grant data modification rights
(insert, update, delete) to stored procedures only.
I was assuming that granting executing rights on a routine using GRANT EXECUTE
ON PROCEDURE to appl_user (with appl_user being a role) would automatically
grant th
Thanks a lot for the help. Now everything is working fine.
Regards
Thomas
here is the script which can be executed to reproduce the problem
-- create an embedded database that is encrypted and
-- specify user 'derby' when initially creating the database so this user
-- will be or can become the database owner
connect 'jdbc:derby:SecuredDB;create=true;
dataEncryption=
n explicitely granting select permission to the user, then I can
select data as expected - but obviously I want to avoid the overhead
of needing to grant permissions on objects to individual users, but only
to roles and then maintain user rights via role assignments.
Thanks
Thomas
Thomas writes:
can someone please confirm that stepping through the Java code of a stored
procedure is indeed possible? no sure why there is no feedback - is it trivial
and must be me / my specific set-up why it doesn't work for me? or am I trying
to do something that is not possible?
Hi,
I need to come back to this subject after many hours of trying to get this to
run over the weekend
I have followed Bryan's advice to my previous post (some weeks ago) and moved
to an embedded database scenario as suggested as this was supposed to remove
the complexity involved when try
Hi,
as Derby currently does not support timezone aware date/time data types,
my application that can run in local/embedded data base mode but also in
networked/network server mode needs to convert input dates into UTC before
storing (and back to local timezone if wanted when displaying stored
in
sorry for me using the 'post' action instead of the 'follow-up' action - I
wanted to put this as a last remark on my previous / related query
Okay thanks. The approach should work for me!
Note: although I would have preferred to
be able to accept data supplied for the "normal" columns (e.g. payload) and
silently have the system correct the "tech" columns (e.g. createdBy/On,
updatedBy/On) in case needed by overwriting user input
rather
CURRENT_USER
within the trigger function).
Any suggestions? Is there really no way this can be achieved in Derby?
(other than maybe putting the tech cols on a separate table and joining the
two base tables in a view so that at least in read operations it would look
like the tech cols are held on the same table?)
Thanks
Thomas
mistake was accessing rte."IDs" which is a view instead of "TBL_IDs" which is
the base table. Also rewrote procedure to use updatable resultset rather
separate select for update and update statement.
Hi,
I am trying to execute a select for update statement and receive the error
message shown on the subject line although I think I had respected all
requirements for such a statement.
Here is the Java code of the stored procedure:
==
public static void
Hi,
I would like to execute a series of statements in IJ where the value returned by
the function call executed in one statement is passed as a parameter to the next
statement calling another procedure.
Example:
CALL "SF_addClient"('lastname', 'firstname')
==> this function creates a new client
Hi,
any tipps from anyone which would help to debug java stored procedures?
Not being able/knowing how to debug the code executed by the database
using the eclipse debugger, I have included System.out.println statements
into the procedures, but have no idea where these end up when running
again
Hi,
I was wondering whether it would be possible to debug java stored procedures
loaded into the database in a jar file using the eclipse debugger.
Debugging of my java stub program works fine, but when trying to step into the
callable statement by which the java procedure call is envoked, eclips
The problem was the numbering of parameters in the registerOutParameter and the
setxxx Statement:
instead of
CallableStatement cs = conn.prepareCall("{ call APPL.\"myFunction\"(?, ?)");
cs.registerOutParameter(1, java.sql.Types.VARCHAR);
cs.setString(1, parm1);
cs.setString(2, parm2);
CallableSta
Hello,
can't find the reason for the following issue:
(Derby 10.5.3.0 network server running on a Linux server, the java function has
been loaded into the database as part of a jar file, server running without
security policy).
When trying to call a procedure from a java program I am getting erro
Hi,
I am having problems wanting to migrate from eclipse 3.4 ganymede (under which I
had successfully used the plugins) to eclipse 3.5 galileo.
A fresh install of the current eclipse version has created the folder structure:
'C:\eclipse-reporting-galileo-SR1-win32 v3.5_2009' (root folder I define
Hi,
can anyone please confirm whether an order by clause is supported in derby
10.5.3 or not? The manuals contain no reference to this and reading through Jira
I was under the impression that this should (now) be possible. However when
trying to create a view using a select query which has an orde
Bryan
you are right - I typed the wrong port in my write up; it should have been
what you stated and documented in the wiki:
==> http://localhost:8080/derby/derbynet ?
Regards
Thomas
d stored in a separate location and not within the tomcat
hierarchy.
Hope this write up helps people looking for some guidance (beyond what is
documented in the admin guide) on topic.
Regards
Thomas
0/derby/, I am getting http 404
the requested resource is not available.
10) when typing http://localhost:8180/derby/derbynet into the browser instead
I am getting HTTP 500 'Wrapper can not find servlet
org.apache.drda.NetServlet or a class it depends on'
Can someone please advise what is still needed or what I do wrong?
Thanks
Thomas
ystem.
Regards
Thomas
1,1,1);' ==> when passing wrong data types I
received 'VARCHAR' can not hold types 'INTEGER'
'CALL derby."TF_Clients_AI2"();' ==> derby."TF_Clients_AI2" is not a recognised
function or procedure.
Still confusing and I wonder what the problem will have been once it was solved
(if it ever will).
Thomas
derby.Functions is a class and TF_Clients_AI2 a method.
the java code reads:
package derbyPk;
public class Functions {
public static void TF_Clients_AI2(int iRowID, String vcClientID, String
vcClientName) throws SQLException
{
...
}
}
As said all of this worked fine when running the
lients_AI2 which is defined as public.
Thanks for your help
Thomas
Hi,
what I have done now is
1) opened up a root terminal session on the server
2) checked CLASSPATH with echo $CLASSPATH command -> emtpy
3) defined the CLASSPATH=/var/lib/derby/db-derby-10.5.3.0-bin/lib/
4) exported the CLASSPATH
5) checked CLASSPATH setting again and now the path was returned
6)
me\eclipse-ganymede-SR1\eclipse\plugins\
org.apache.derby.core_10.5.1\derbytools.jar
OS name: Windows XP
OS architecture: x86
OS version: 5.1
Java user name: Thomas
Java user home: C:\Dokumente und Einstellungen\Thomas
Java user dir: C:\Daten\eclipse ganymede\derby
java.specification.
om after the update coming fom the second trigger - whereas I would have only
had one entry in case I could have overwritten transition variable content in
the first place with whatever would have been stored there prior to this being
written back to the data base.
Regards
Thomas
om after the update coming fom the second trigger - whereas I would have only
had one entry in case I could have overwritten transition variable content in
the first place with whatever would have been stored there prior to this being
written back to the data base.
Regards
Thomas
Hi,
passing the values worked fine, so I can now log the new values into my audit
log table.
Do you know if it would be possible to CHANGE the new values as well?
Background: Let's say my Client table has a column 'CreatedBy' in which I want
to store the role of the user that inserted the row. F
Hi,
thanks for your reply.
the trigger needs to execute multiple SQL statement, which is why I am using an
external procedure. I will try passing in the values as you suggest.
Regards
Thomas
Hi,
after having closed down Eclipse going in again and rebuilding from scratch the
trigger could be created and actually worked for the first time without throwing
the syntax error. Strange, as I am not aware I have changed anything. So
although not fully understanding what is / was going on here
Hi,
have created the following procedure and trigger:
CREATE PROCEDURE "TF_ClientsAI"()
LANGUAGE JAVA
PARAMETER STYLE JAVA
MODIFIES SQL DATA
EXTERNAL NAME 'derbyPk.Functions.TF_ClientsAI';
-- DROP TRIGGER "TR_ClientsAI";
CREATE TRIGGER "TR_ClientsAI"
AFTER INSERT
ON rte."Clients"
REFEREN
Hi,
I am trying to use an after insert trigger defined on a table to log values of
each row that gets inserted in a audit trail table.
The error I am getting which I do not understand / know how to resolve is a
syntax error:
ERROR 38000: The exception 'java.sql.SQLException: Syntax error:
Encou
Finally spotted the problem.
The method definition should have read:
public static void spGetNextID( int iNextVal[], String vcIDName )
(not public static int spGetNextID...)
and the line trying to return the integer at the end
return iNextVal[0];
needed to be removed.
Now it works
Throwable e) {
System.out.println(e);
}
}
}
Seems I need to call the procedure fully qualified as 'DERBY.spGetNextID' as
otherwise I am getting an error that no procedure or funtion was found.
Hope you can easily spot what I am unable to find.
Regards
Thomas
rby manual which is
given for 'contains data' honestly doesn't make sense to me) and when using a
procedure I could update data, but with a procedure not return any value.
However I need to update data and return the new value so that I know which ID
has been assigned. Can you help with the solution of this please?
Thanks again
Thomas
for Derby, so haven't tried a
similar approach here.
Best Regards,
Thomas Taylor
-Original Message-
From: Alessandro Bottoni [mailto:alexbott...@yahoo.it]
Sent: Thursday, July 09, 2009 10:48 AM
To: Derby Discussion
Subject: Re: How would you implement a record-level versioning
o use ORDINAL_POSITION to
recreate the sequencing of columns within the index.
If not, you might try looking at the thread/link that Rick Hillegas sent
(http://www.nabble.com/How-can-I-fetch-constraint-attribute-on-Column-Level-
from-SYS-Tables---td19554573.html#a19554573)
Thomas
INFOTECH Soft
1 - 100 of 285 matches
Mail list logo
