How can I create a java.sql.Array of Strings?

Question

Possible Duplicate:
How to create ArrayList (ArrayList<T>) from array (T[]) in Java

I have:

String[] time = {"22:22:22","22:22:23"};
Array asd = null;

How can I put something like asd=time ?

Edit your question to increase it's clarity. Not much info for people to go on in answering. — Valchris, Nov 05 '10 at 19:52
@BobJarvis Please keep the SQL and JDBC tags. Even though the OP didn't state it explicitly in the question, some of his comments clearly shows that the question _is_ actually related to SQL: https://stackoverflow.com/questions/4108679/how-do-i-cast-from-string-to-array/4109407#comment4423786_4108729 — Grodriguez, Jan 19 '18 at 11:21

Grodriguez · Answer 1 · 2010-11-05T19:45:38.563

22

I assume that what you actually need is a java.sql.Array, since you mention jdbc and setArray in some of your comments.

Three options:

Try Connection.createArrayOf(). This might or might not be available, depending on the JDBC driver you are using.
Write your own class that implements java.sql.Array. Here is an example for PostgreSQL.
Some implementations, such as Oracle's, provide utility methods to work with arrays. Check the documentation of your JDBC driver.

edited Nov 05 '10 at 19:45

answered Nov 05 '10 at 19:38

Grodriguez

In the example of PostgreSQL, there is no method where we can pass the List or Arrays to get the java.sql.Array. – Shiva kumar Nov 16 '21 at 16:27

score 5 · Answer 2 · answered Nov 05 '10 at 18:05

5

The Array class is not an actual array. Instead it is a helper class that has static methods to help with arrays.

You may be looking to use ArrayList or something like it. You could use it using List<String> asd = Arrays.asList(time)

answered Nov 05 '10 at 18:05

Alan Geleynse

The problem is that i want to use a method in the jdbc driver framework that inserts arrays into sql databases this method is something like setArray(int arg0, Array arg1) and it only acepts the Array array type what should i do i tried another array types including arralist and nothing is working – Edu Nov 05 '10 at 18:27
anyone that can help me? – Edu Nov 05 '10 at 18:59
What method are you trying to use? – Alan Geleynse Nov 05 '10 at 19:08
Yes, Array has a set of static methods, so I was suggesting using Arrays.asList instead. But it now looks like he was trying to use java.sql.Arrays, so my answer does not apply. @Grodriguez seems to have the correct answer. – Alan Geleynse Nov 05 '10 at 19:47

score 0 · Answer 3 · edited May 23 '17 at 12:17

0

Array is an interface, not a class. Are you referring to ArrayList?!

new ArrayList<Element>(Arrays.asList(array))

edited May 23 '17 at 12:17

Community

answered Nov 05 '10 at 18:02

EboMike

The problem is that i want to use a method in the jdbc driver framework that inserts arrays into sql databases this method is something like setArray(int arg0, Array arg1) and it only acepts the Array array type what should i do i tried another array types including arralist and nothing is working – Edu Nov 05 '10 at 18:26
What error do you get when you give it a string array? What error you get when you give it an ArrayList? – Daniel Standage Nov 05 '10 at 19:27

3 Answers3