Hello,
How do I use bind variables for the SQL statements having IN clause. F.ex
SELECT id, name FROM t
WHERE id in (10,20,30)
As the IN list will have 'n' number of values, I am not able to specify fixed
number of bind variables like
SELECT id, name FROM t
WHERE id in (?,?,?)
As our
Hello,
has anybody worked with DdlUtils, Derby and Oracle? I would like to transfer
data from an Oracle DB to Derby is DdlUtils the right tool to use?
Problem is I also have some stored procedures which I need to port to Derby.
Any chance of doing this?
Cheers,
Pete
Hello.
I have an application which initialises a database upon first start then
immediately starts using it.
Initialisation consists in writing objects through jpa. After commit is
done, the program starts and reads back those data.
Unfortunatly unless i set a slight sleep() after commit, data
Hi Sameer,
You might try using a temporary table to hold the values in the IN list.
For more details, see the section in the Derby Reference Manual titled
DECLARE GLOBAL TEMPORARY TABLE statement. Here's an example of this
technique.
Regards,
-Rick
autocommit off;
ij drop table t;
0 rows
Initialisation consists in writing objects through jpa. After commit is
done, the program starts and reads back those data.
I haven't heard of any problems involving a delay after commit in Derby
itself. Perhaps jpa is not committing the data when you think it is, or
perhaps your program is
Peter Neu wrote:
Hello,
has anybody worked with DdlUtils, Derby and Oracle? I would like to transfer
data from an Oracle DB to Derby is DdlUtils the right tool to use?
Problem is I also have some stored procedures which I need to port to Derby.
Any chance of doing this?
Derby doesn't
Hi,
On Apr 18, 2007, at 3:05 AM, frederic barachant wrote:
Hello.
I have an application which initialises a database upon first start
then immediately starts using it.
Initialisation consists in writing objects through jpa. After
commit is done, the program starts and reads back those
Bryan Pendleton a écrit :
Initialisation consists in writing objects through jpa. After commit
is done, the program starts and reads back those data.
I haven't heard of any problems involving a delay after commit in Derby
itself. Perhaps jpa is not committing the data when you think it is, or
Craig L Russell a écrit :
Hi,
Are the reader and writer in different processes? Then caching is
definitely on your list of to be investigated.
If there's no caching, I can't think of anything that might cause this.
Another possibility is that you are not managing relationships
correctly
I would ask this question on the ddlutils list. ddlutils looks like a
great export/import utility, but it may not handle complexities like
stored procedures. In particular, Oracle stored procedures are
generally written in PL/SQL, and Derby's procedures are written in Java.
It would have to
frederic barachant wrote:
Craig L Russell a écrit :
Hi,
Are the reader and writer in different processes? Then caching is
definitely on your list of to be investigated.
If there's no caching, I can't think of anything that might cause this.
Another possibility is that you are not
In my application, I have a blocking queue that different processes can add
database tasks to. We need this because we need to have the application start
up instantly and not wait a few seconds for the DB to initialize.
There is one process that handles all database operations and takes items
Hi,
I am tryin to build the derby source using eclipse. I am using this link i
found on the derby wiki
-
http://wiki.apache.org/db-derby/BuildingDerby#head-0c0abaf557bc2cfe0efdbdd9a6098de1db0f6bb2
I have followed the instructions in building.txt but when I build i see a
lot of errors such as
On 4/17/07, Stanley Bradbury [EMAIL PROTECTED] wrote:
Nat Gross wrote:
If all users access the database via a J2ee or JEE application server,
which Derby mode is recommended?
1. Performance wise.
2. Db Admin wise.
Thanks;
nat
Since the App server provides nework connectivity most
On 4/18/07, Dimple Bhatia [EMAIL PROTECTED] wrote:
Hi,
I am tryin to build the derby source using eclipse. I am using this link i
found on the derby wiki
-
http://wiki.apache.org/db-derby/BuildingDerby#head-0c0abaf557bc2cfe0efdbdd9a6098de1db0f6bb2
I have followed the instructions in building.txt
15 matches
Mail list logo
