Re: Max query length 255? - Tim Pizey - com.mysql.lists.win32

4 messages in com.mysql.lists.win32Re: Max query length 255?

From	Sent On	Attachments
Tim Pizey	19 Jul 1999 04:37
Tim Pizey	19 Jul 1999 05:08
Tim Pizey	19 Jul 1999 10:21
Tim Pizey	20 Jul 1999 05:10

Subject:	Re: Max query length 255?
From:	Tim Pizey (ti...@paneris.co.uk)
Date:	07/20/1999 05:10:55 AM
List:	com.mysql.lists.win32

Sorry to bog the list down.

The problem was actaully caused by using a sub-select and bad error handling.

Sorry again TimP

At 12:37 19/07/99 +0100, Tim Pizey wrote:

It appears that there is a maximum length of 255 characters for a query string. can this be right?

When in interactive mode I can create a multi-line query, but I am using jdbc.

I am running win95, Apache 1.3.4, Jserv 1.0b3, Webmacro 0.89.1 and Mysql 3.21.29a-gamma-debug

I have installed both the mm_mysql_jdbc-1.0 and twz1.1.0.4 jdbc drivers.

The first fails silently, the second gives:

org.webmacro.servlet.HandlerException: java.lang.Exception: Can't find user: java.sql.SQLException: E0610 Error in executeQuery() E0606 executeQuery() error -- E0701 Error in getResult(). E0708 Command results in error - 1064 parse error near 'SELECT userpermissions.groupname FROM userpermissions, userresources, userresour' at line 1 sqlString: SELECT userpermissions.groupname FROM userpermissions, userresources, userresourcetypes WHERE userpermissions.resource = userresources.id AND userresources.resource = 'AdminTables' AND userresources.type =userresourcetypes.id AND userresourcetypes.type = 'handlers'

Note that the query string is 266 chars long.

The same code works on unix/postgres.