Torque.init() requires an absolute pathname. It's a bummer. I put the true pathname in another properties file so that I do not have to hard-code it in the program. This does mean, however, that I have to know the absolute path where, in my case, Tomcat is installed. Here is my initialisation code
apiResources = ResourceBundle.getBundle("betapi"); if (!Torque.isInit()) { String configFile = apiResources.getString ("betapi.torqueconfig"); try { Torque.init(configFile); } catch (TorqueException e) { context.log(e,"Cannot initalise Torque: " + e.toString() ); e.printStackTrace(System.err); System.exit(1); } } and betapi.properties contains: betapi.torqueconfig= /users/rxm1676/workspace/pmfeditor/WEB-INF/classes/Torque.properties In cases where I build on one machine but run on another I have a little shell script that that runs on installation. It tracks down the appropriate line in betapi.properties and adjusts it so suit where the code is actually installed. |---------+----------------------------> | | "salwa idrissi" | | | <[EMAIL PROTECTED]| | | fr> | | | | | | | | | 15-Mar-2005 14:19| | | Please respond to| | | "Apache Torque | | | Users List" | | | <[EMAIL PROTECTED]| | | pache.org> | | | | |---------+----------------------------> >-------------------------------------------------------------------------------------------------------------------------| | | | | | | | To: "Apache Torque Users List" <torque-user@db.apache.org> | | | | cc: | | Subject: Re: Torque and jsp | >-------------------------------------------------------------------------------------------------------------------------| the problem is not confusing presentation and model but when i compile in jdev i have the exception "Could not open file Torque.properties"because i must put it in a specific directory in jdev that i don't know. this is the code: affichage.jsp: <table width="165" border="0" cellpadding="2" cellspacing="0" class ="textindex"> <% Iterator i; List listecr=(List)session.getAttribute("liste"); i = listecr.iterator(); while ( i.hasNext() ) { Ecriture monecriture = (Ecriture) i.next(); %> <tr> <td width="8" align="center"> <%= monecriture.getCodeetape()%> </td> </tr> <% } %> </table> actionaccueil.java public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { HttpSession session=request.getSession(); AddEcriture test=new AddEcriture(); test.afficher(); session.setAttribute("liste",test.getListecrs()); return mapping.findForward("success"); } } AddEcriture.java: package si.av; import java.util.*; import org.apache.torque.Torque; import org.apache.torque.util.Criteria; import si.av.om.*; public class AddEcriture { List listecrs; public List getListecrs() {return listecrs;} public void afficher() { try{ Torque.init("Torque.properties"); Criteria critaffichage=new Criteria(); critaffichage.addAscendingOrderByColumn(EcriturePeer.NSEQUENCE); listecrs=EcriturePeer.doSelect(critaffichage); } catch(Exception e){e.printStackTrace();} } } --------------------------------- Découvrez nos promotions exclusives "destination de la Tunisie, du Maroc, des Baléares et la Rép. Dominicaine sur Yahoo! Voyages. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]