MySQL Forums
Forum List  »  Newbie

User defined variables and Resin Server
Posted by: Maurice Mills
Date: August 11, 2004 05:54AM

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?


Options: ReplyQuote

Written By
User defined variables and Resin Server
August 11, 2004 05:54AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.