User defined variables and Resin Server

[Maurice Mills]

I am working on a web app that is to be deployed on a Resin Server using MySQL 3.23.

The problem I am having is that I need to define a SQL variable that I can use in queries. When I do this, it is only available within the context of the connection it is defined in, but I need it to be available in all connections that are created by Resin.

I will not have access to the Resin configuration file, or control over the startup of MySQL, so this all needs to be done in application files.

We originally started development on a Tomcat server and I could put "select @var:=value" in the validationQuery parameter of the DataSource definition in Tomcat's server.xml file. This worked fine and the variable was defined across all new connections created by Tomcat.

When we found out it was to be deployed to a Resin Server, we discovered this problem.

Does anyone have any suggestions on how to solve this problem?

Thanks,
Maury