I have a query that selects records from a datetime column using the JSTL
and MYSQL. When I output the rows to a JSP page I'm getting the following:
Anderau, Eoma BASEL [B@b6421
Andersson, Lisa BASEL [B@5acb2b
[B@5092c0
A variable that prints a string starting with [B is likely a primitive
byte array (byte[]). This means that the MYSQL JDBC driver you're using
is probably returning a byte[] for the column aliased Date when it's
retrieved using ResultSet.getObject(). You could add
c:out
PROTECTED]]
Sent: Monday, April 01, 2002 12:09 PM
To: Tag Libraries Users List
Subject: Re: JSTL Date Format Question
A variable that prints a string starting with [B is likely a primitive
byte array (byte[]). This means that the MYSQL JDBC driver you're using
is probably returning a byte
://prdownloads.sourceforge.net/mmmysql/mm.mysql-2.0.11-you-must-unjar-me
.jar
Regards.
-Original Message-
From: Shawn Bayern [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 12:09 PM
To: Tag Libraries Users List
Subject: Re: JSTL Date Format Question
A variable that prints
On Mon, 1 Apr 2002, Shawn Bayern wrote:
Okay, I looked at the JDBC driver's code. It returns a byte[] in cases
where the underlying object is java.sql.Types.LONGVARBINARY. For some
reason, then, it looks like MySQL is returning a LONGVARBINARY column for
the one you're labeling Date.
On Mon, 1 Apr 2002, Henri Yandell wrote:
Okay, I looked at the JDBC driver's code. It returns a byte[] in cases
where the underlying object is java.sql.Types.LONGVARBINARY. For some
reason, then, it looks like MySQL is returning a LONGVARBINARY column for
the one you're labeling Date.
under ORACLE? If so,
I'll move on to other things.
-Original Message-
From: Shawn Bayern [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 2:02 PM
To: Tag Libraries Users List
Subject: RE: JSTL Date Format Question
Okay, I looked at the JDBC driver's code. It returns a byte