Hi
I am not able to retrive the data from Object[]. Below is the code
StringBuffer q = new StringBuffer("select T.CLI_ID, " +
"T.CLI_ADDR_TYP_CD " +
"from " +
" TABLE T, TABLE2 T2" +
"where " +
"T2.cli_id = T.CLI_ID " +
"and " + "T2.id='100');
query = session.createSQLQuery(q.toString());
List plist = query.list();
Object obj[] = (Object[]) plist.get(0);
if (obj != null) {
for(int i=0; i<obj.length;i++){
System.out.println("DATA>>"+ obj[i]);
}
}
I have three records for above sql result. and i want to get all records from the list.
Here in sysout,i could only see the only one charcter of the coloumn data,
Request you to help me.

Babu.

Sorry double post, cause of bad internet connection.

Hi,

have you checked, if you really get an Array of Objects?
You won't get a CalssCastException, cause Object[] and Object are both only simple references.

"plist.get(0)" may return an Object of your Class that represents your
TABLE T.

Use this to check the type.


Also the implicit call of toString() on Object, may not be appropriate. "System.out.println("DATA>>"+ obj[i]); "

"T.CLI_ADDR_TYP_CD" may be another Array of objects.

Hope this helps.

Greetings Michael

' [Ljava.lang.Object;' is the result which i got from sysout you provided, I believe this is Object array. I have the CLI_ID of 10 digit but in sysout it is showing only 1 digit the same case is with the CLI_ADDR_TYP_CD where it shows only 1 character.

Hi, yeah this indicates an Objectarray.
Also I was wrong in the above post, you should get an ClassCastExecption if it is not an array. What I ment is that in the below example: "o = array;" would not raise an exception.



produces this output.


as expected:


So it is quite likely that the objects in your for-clause are another type, which had overriden toString(), cause you don't get the above results.

So you should check this types.
E. G.:


Greetings Michael

Here is the console output :-

SystemOut O java.lang.Character
SystemOut O DATA>>1
SystemOut O java.lang.Character
SystemOut O DATA>>E

I dont understand why it is showing Character obj. It has to be the String type. I am in confusion now, the same code i had already used and that is working fine. Its really mess with me. The data type for the DB field is also varchar. Please suggest.

Hi,

how does your mappings look like?

If you try to read an existing database, without mapped classes you may have an look here:
http://www.hibernate.org/hib_docs/tools/reference/en/html/reverseengineering.html

But I have no experience with that. Otherwise varChar to string should be default.

Your Id normally shouldn't be a String, unless you use a natural key. So normally I would expect an Object array, with an subclass of Number in first place and a String in second place.

How big are the varchars in your database? What is the expected result?

You don't use an oracle database?

5.2.2. Basic value types (Hibernate manual)


Greetings Michael