struct for the url
parameter on the resource tag in your context.xml:
url="jdbc:mysql://[hostname]/[dbname]?useOldAliasMetadataBehavior=true"
Hope this helps.
Glyn
On Mon, Dec 12, 2011 at 8:18 AM, Mikolaj Rydzewski wrote:
> On Mon, 12 Dec 2011 08:07:31 -0500, Glyn Thomas wrote:
>
Mikolaj,
if I run the same query in the MySql client it works correctly (column
names correctly aliased).
Thanks
Glyn
On Mon, Dec 12, 2011 at 8:18 AM, Mikolaj Rydzewski wrote:
> On Mon, 12 Dec 2011 08:07:31 -0500, Glyn Thomas wrote:
>
> The following test JSP shows the problem:
>&g
y and Subject are both aliased in the query. Description
is not a directly requested in the query, but is returning the contents of
sd1.description.
I seem to recall having a similar issue when first porting to OSX and
having to set backward compatibility somewhere, but can't find my records
for this anywhere. Anyone got any ideas?
Thanks
Glyn Thomas
n? Is there an error message in Tomcat's log?
When you execute the query in MySQL, do you get exactly the same
results as on the old system? In particular, are the column names what
you expect?
--
Len
On Sat, Aug 2, 2008 at 20:02, Glyn Thomas <[EMAIL PROTECTED]> wrote:
> I am in
en iterate through the rows using:
Rows that retrieve directly from the image_tbl work correctly e.g.
${row.ImageID} will display the image ID.
However, elements from the joined tables, such as ${row.Country} and
${row.SubjectID} don't get retrieved.
Any ideas?
Thanks,
Glyn Thomas
