Re: how to insert some custom value in anidentity field

=5 and the autoincrement value is less than that. One solution would be to reserve space e.g. the lowest 10 values for your custom records by specifying the start/increment values for the identity column. regards Tony Seebregts Legolas Woodland wrote: > Hi > Thank you for reading my post.

Re: derby database browser/frontend?

Cloudscape Workbench (from IBM) works pretty well for me. regards Tony Seebregts > Hello, > > Is the a GUI browser for the apache Derby? > > That is something similar to Microsoft > SQL Server's Query Analyzer, or the MySQL > graphical frontends? > > I am deb

Re: PreparedStatement setObject() and SMALLINT

Hi Mamta, Hmmm ... sounds like an oversightin the JDBC 3.0 spec to me, but hey, I'm just a peasant. Thanks for the explanation though ! regards Tony > > > *From:* Mamta Satoor [mailto:[EMAIL PROTECTED] > *Sent:* Wednesday

PreparedStatement setObject() and SMALLINT

java.lang.Short'. Invoking setShort(..) on the same column works just fine. regards Tony Seebregts

Triggers and BLOB's

wrong or if there is any way to make this work ? regards Tony Seebregts

Re: [VOTE] Apache Derby logo

[10] *very* nice !!

RE. Generated Keys and Triggers

Problem solved - IDENTITY_VAL_LOCAL() does the trick. regards Tony Seebregts

Generated Keys and Triggers

? (other than being *really* careful about the database design :-) ). regards Tony Seebregts

Re: JDBC and WHERE IN clauses

lude it so ... regards Tony Seebregts

JDBC and WHERE IN clauses

Hi, Does anybody know of a way to use a PreparedStatement with a WHERE IN (?) clause e.g. SELECT * FROM Names WHERE ID IN (?) where the parameter is replaced by an array of e.g. int's ? regards Tony Seebregts

Re: Variable Length Parameter Lists

want to avoid declaring each overload because your overloads are changing rapidly? Are you using Java 1.5 varargs? Thanks, -Rick Tony Seebregts wrote: Hi, Is there a way to specify variable length parameter lists in a CREATE FUNCTION statement ? regards Tony Seebregts

Variable Length Parameter Lists

Hi, Is there a way to specify variable length parameter lists in a CREATE FUNCTION statement ? regards Tony Seebregts

Re. PooledConnection being closed (Part 2)

Thanks Knut, Figured out some of this about 30 minutes after posting the question but your explanation clears thing up a lot. regards Tony Seebregts Subject: Re: Re. PooledConnection being closed From: Knut Anders Hatlen <[EMAIL PROTECTED]> Date: Mon, 15 Aug 2005 18:44:41 +0200 To:

Re. PooledConnection being closed

Hi David, How are you determining that the connection is closed and that you are getting a new connection? Discovered it by mistake when I tried to reuse it - and found it was closed. Then 'printed' out the Connection object and realised that PooledConnection getConnection() was giving me an

Re. PooledConnection being closed

Ok, thanks Knut - my misunderstanding. I understood the ConnectionPoolDataSource as merely facilitating connection pooling. If it manages the actual pooling though, is there any point in handling the ConnectionEvents ? Other than for monitoring/interest ... regards Tony Seebregts

PooledConnection being closed

the idea. Any ideas ? regards Tony Seebregts