How to access to data stored into java.lang.object?

Question

I have a table product(id, name, cost) and a query

Select id, name from product where name='TV'

which returns two rows.
The result of this query is stored into a list of java.lang.object (list contains 2 objects containing the data I need).

How can I access to product.name and product.id?

List <Object> result = catalogServiceLocal.customQueryProd("s4"); //This is the query I am calling to execute SQL code.

    System.out.println("Size of List  "+result.size());
    System.out.println("List " + result.toString());

And the result is :

6:39:42,877 INFO  [stdout] (MSC service thread 1-7) Size of List    2
16:39:42,878 INFO  [stdout] (MSC service thread 1-7) List    [[Ljava.lang.Object;@661b6318, [Ljava.lang.Object;@1006f107]

It might help if you edit your question to add the code you're using so we can see how you're ending up with a java.lang.object. — Nanhydrin
– Nanhydrin, Commented Jun 26, 2015 at 15:39
Object is a superclass of every single class in Java, so that doesn't tell us much. And there are many ways to read SQL tables in Java. We'll need some more details (i.e. the code you're using) before we can answer this. — Bernhard Barker
– Bernhard Barker, Commented Jun 26, 2015 at 15:45

Joop Eggen · Accepted Answer · 2015-06-26 16:00:18Z

1

I think the following should do:

for (Object record : result) {
    Object[] fields = (Object[]) record;
    String id = (String) fields[0];
    String name = (String) fields[1];
    System.out.printf("id: %s, name: %s%n", id, name);
}

The toString shows that result is a list of two Object arrays. Two records evidently. Every object array might be id+name fields, probably of type String.

Types in java use a short-hand: [ for array.

answered Jun 26, 2015 at 16:00

Joop Eggen

110k8 gold badges89 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to access to data stored into java.lang.object?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related