JSTL Date Format Question

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

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[] for the column aliased Date when it's retrieved using ResultSet.getObject(). You could add c:out

RE: JSTL Date Format Question

c:out value=${row.Date.class} / produced a blank for the date column. My JDBC driver is mm.mysql-2.0.11-bin.jar which can be downloaded from http://prdownloads.sourceforge.net/mmmysql/mm.mysql-2.0.11-you-must-unjar-me .jar Regards. -Original Message- From: Shawn Bayern [mailto:[EMAIL

RE: JSTL Date Format Question

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. This might be because the DATE_FORMAT function

RE: JSTL Date Format Question

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.

RE: JSTL Date Format Question

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.

RE: JSTL Date Format Question

This is unfortunate as I need to return one record per user per date in my query, necessitating the DATE_FORMAT( ) function in my select. I'm using MYSQL as a temporary development platform until a specific ORACLE server becomes available. Do you think that the proper date will be displayed

plans for include

Does anyone know if there are plans to improve jsp:include or create a new include in jstl? The reason I ask is because jsp:include page={url | %=expr%} / will only take simple strings. it would be nice if one could dynamically build the appropriate include path/filename and pass it to the

Re: plans for include

On Mon, 1 Apr 2002, peter lin wrote: Does anyone know if there are plans to improve jsp:include or create a new include in jstl? Yes, JSTL introduces c:import, which (as I think I say in my book) you can think of as jsp:include: the next generation. :-) -- Shawn Bayern Author, JSP

Re: plans for include

thanks for reminding. I totally forgot about that. peter Shawn Bayern wrote: On Mon, 1 Apr 2002, peter lin wrote: Does anyone know if there are plans to improve jsp:include or create a new include in jstl? Yes, JSTL introduces c:import, which (as I think I say in my book) you

jstl sql dataSource configuration help

Hi. I am a student taking a class in JSP's and my current project is to use the jstl in a web-app tied into a database. I believe the problem I am having derives from getting a datasource. my jsp code is: sql:query var=stuff dataSource=${dataSource} SELECT * FROM articles/sql:query

Re: jstl sql dataSource configuration help

On Mon, 1 Apr 2002, James Hazel wrote: my jsp code is: sql:query var=stuff dataSource=${dataSource} SELECT * FROM articles/sql:query c:out value=Query completed. Rows returned are: / c:out value=$stuff.getSize() / I configured the dataSource as a class implementing the

[OFF-TOPIC] Re: jstl sql dataSource configuration help

On Monday 01 April 2002 04:45 pm, James Hazel wrote: I am a student taking a class in JSP's and my current project is to use the jstl in a web-app tied into a database. I believe the problem I am having derives from getting a datasource. When I was a kid I took Fortran (and Prime assembly!)

Problems installing UltraDev extension

I have been using the UltraDev 4.0 Custom Tag Library Extension with a standalone instance of Tomcat but when I try to use UltraDev while I have an instance of Tomcat running that was started by Jbuilder 6 the Java SecurityManager is enabled and I get a stack trace from Tomcat instead of the list

RE: EL

Thank you, I understand. Maybe a stupid question, but why Java is not used as EL? Is not it possible to just generate JSP script in the page with minor substitution of variable names to pageContext.getAttribute() calls? Sorry I am not very professional in this area yet, so just a question. Best

Libraries misunderstanding

Hello, I use TC 4.0.3, my web app used XML parser and transformer (throught the XML Jakarta project FOP). On JSP which are only using JSTL I have an XML tranformer Exception, so I have to put xalan.jar in my TC/common/lib. I do not understand why putting this jar file in my web app WEB-INF/lib