1) Not sure if torque you can deal with different datasources, but I know in hibernate you can ask it to work from a connection that you supply. So now you get that connection from any data source you like.
Creating databases for each user is bad idea I think. I think there should be one database per application, no matter what this application is doing. So if you application is creating other applications, then you might want to create new database for those new apps. 2 ) Whatever you use for authentication will take care of your cookies. If you want an authentication filter that's pretty much done, email me. HTH, Pritpal Dhaliwal -----Original Message----- From: Gregory Seidman [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 11:09 AM To: Struts users mailing list Subject: Integration with other web apps I am embarking on a project which is primarily for my own use, but I have some hopes of commercializing it later. The business plan would involve licensing it for use on commercial websites I don't control. I see three major challenges in integrating with an existing site (ignoring details about different container software): 1) Database usage Right now all of my data, including user authentication, is in the database. This is fine for when there is a single dataset, but I expect each user (group of users) to have a completely independent set of data. I'm evaluating using Torque for DB interaction, but I don't know if there is a good way to choose a separate datasource depending on the user. Another aspect is calling Torque to build the database when a user who has not used my feature comes along. That may or may not involve creating a new database for the user, since the site may already be set up with a database for each user; it is likely, however, to involve creating a new set of tables. Presumably I need a table naming scheme which will minimize the chances that there will be a conflict. 2) User authentication Basically, I expect that a user will be logged in to the site as a whole, and I should be able to just read their cookie and authenticate it. I am, however, unsure how such cookies are usually dealt with on the backend (e.g. is the cookie usually user and pass, or is it some unique identifier that matches in the database, or does the identifier match automatically in the server-side runtime the way a session cookie does?). 3) Page layout I actually expect it to be reasonably easy to handle layout customization with with Tiles. I'm not sure how well the various Struts tags deal with CSS (do all the HTML tags allow class attributes?). I wrote a prototype several months ago in straight JSP (with some custom tags), gave it up as unmaintainable, and recently finished reading Struts Kickstart. My purpose in posting this to the list is to get the benefit of the membership's collective experience. Is Torque a good choice? Is creating a separate database for each user unacceptable from the point of view of a website which provides services on a per-user basis? Is Tiles sufficient for customizing layout and such? Any suggestions, tales of woe, or design critiques are appreciated. Please do not CC me; I am subscribed to the list. --Greg --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]