You can use ARRAY_GET(x,1) to retrieve individual values from an ARRAY. There is currently no way to retrieve multiple
values.
You will need to do something like
SELECT ARRAY_GET(x,1) || ',' || ARRAY_GET(x,2)
On 2014-08-18 07:19 PM, Vijit Jain wrote:
I have an issue with displaying multiple a
You should be fine just allocating a PreparedStatement on the connection object
that gets passed to the function.
H2 caches plans internally based on the query string anyway.
But if you really want to, you can call
DriverManager.getConnection("jdbc:default:connection")
But note that you'll ha
Managing prepared statements, which are allocated per-connection.
On Sunday, August 17, 2014 11:22:38 PM UTC-7, Noel Grandin wrote:
>
> Your question has already been answered, if you read the linked docs
> carefully, but why exactly are you trying to get
> the original connection anyway?
>
> T
I have an issue with displaying multiple array contents using a single runtool
script.
These are the steps that might help you to recreate the issue i encountered.
1. using runtool, against a database, in which, there is a column which is an
Array. Containing at least 4-6 values.
2. Now, t
Hi,
I investigated with a debugger and the issue occurs during the execution of:
ALTER TABLE MCProdInstance ADD COLUMN IF NOT EXISTS isTSRecorderOn int null;
I don't really understand why.Also, I tried with others customers's DB and
not issue.
Let me know if you new more information to move forw
