getObject() method is not returning the proper result.

[nitss bhavsar]

hello,
I am writing jdbc code that firing a query "select sysdate from dual" on database so, when i get the result from that by invoking getObject() method on result set ,is giving me only date not time...but my expected result should be like it should return date and time both.

my code is

 public boolean invoke(final Context c)
    {
        final Connection connection = getConnection("Executing SQL Query");
        try
        {
            final PreparedStatement preparedStatement = connection.prepareStatement(querySQL);
            try
            {
                setParameters(-1, preparedStatement, "Executing SQL Query", null);
                final ResultSet resultSet = preparedStatement.executeQuery();
                try
                {
                    if (!resultSet.next())
                    {
                        mappedResult = Collections.EMPTY_LIST;
                        indexedResult = Collections.EMPTY_LIST;
                        return true;
                    }
                    final ResultSetMetaData metaData = resultSet.getMetaData();
                    final int columnCount = metaData.getColumnCount();
                    final String[] columnNames = new String[columnCount];
                    for (int i = 0; i < columnNames.length; i++)
                    {
                        final String columnLabel = metaData.getColumnLabel(i + 1);
                        if (StringUtils.isEmpty(columnLabel))
                            columnNames[i] = metaData.getColumnName(i + 1);
                        else
                            columnNames[i] = columnLabel;

                    }
                    int noResults = 0;
                    try
                    {
	                    mappedResult = new ArrayList<Map<String, Object>>();
	                    indexedResult = new ArrayList<Object[]>();
	                    do
	                    {
	                        final HashMap<String, Object> hashMap = new HashMap<String, Object>();
	                        mappedResult.add(hashMap);
	                        final Object[] array = new Object[columnCount];
	                        indexedResult.add(array);
                            for (int i = 0; i < columnCount; ++i)
                            {
                                final String name = columnNames[i];
                                [color=darkred]Object object = resultSet.getObject(i+1);[/color]
                               
                                if (object instanceof BigDecimal)
                                {
                                    final BigDecimal bigDecimal = ((BigDecimal) object);
                                    try
                                    {
                                        object = bigDecimal.longValueExact();
                                    }
                                    catch (ArithmeticException e)
                                    {
                                        // ignore
                                        final double v = bigDecimal.doubleValue();
                                        if (BigDecimal.valueOf(v).equals(bigDecimal))
                                            object = v;

                                    }
                                }
                                else if (object instanceof BigInteger)
                                {
                                    final BigInteger bigInteger = ((BigInteger) object);
                                    final long l = bigInteger.longValue();
                                    if (BigInteger.valueOf(l).equals(bigInteger))
                                        object = l; // nothing lost here
                                }
                                hashMap.put(name, object);
                                array[i] = object;
                            }
	                        noResults ++;
	                    } 
	                    while (resultSet.next());
                    }
                    catch(OutOfMemoryError e) 
                    {
                    	mappedResult = Collections.EMPTY_LIST;
                    	indexedResult = Collections.EMPTY_LIST;
                    	logger.error("Got out of memory error in query " + querySQL + 
                    			" with mapped parameters " + mappedParameters + 
                    			" indexed parameters " + indexedParameters + 
                    			" fetched rowcount: " + noResults, e);
                    	throw e;
                    }
                }
                finally
                {
                    ResourceUtils.sql.SafeClose(resultSet);
                }
            }
            finally
            {
                ResourceUtils.sql.SafeClose(preparedStatement);
            }

        }
        catch (SQLException e)
        {
            throw ResourceUtils.sql.Create(database).translate("Executing SQL Query", querySQL, e);
        }
        finally
        {
            ResourceUtils.sql.SafeClose(connection);
        }

        return true;
 
}

getting result:
2012-04-12 00:00:00.0

expected result:
2012-04-12 15:36:56.0

so please do reply its urgent,
regards

[Wendy L Gibbons]

have you tried getting the datatype from the metadata? and using that to use the more appropriate get method, so you want to use getDate().

I know oracle returns all number as NUMBER setting the precision and length, so I THINK oracle is quite good in it's meta data returned.