If you are planning to deploy jetspeed I'd suggest moving to another db; Postgres, MySQL, whatever...
I assume you can do a dump of the table structure and data of Hypersonic into any other db. I've never used Hypersonic, so I know nothing about it. The new jetspeed tutorial has a nice section on using the existing database browser portlet. That portlet may or may not fit your needs. http://www.bluesunrise.com/jetspeed-docs/JetspeedTutorial.htm I do db access like this: A velocity template submits to a java class which uses a session bean to do all the db work. Search the archive on setting up Jetspeed to work with another database; there is a lot of info in regards to that. stu >>> [EMAIL PROTECTED] 12/17/02 01:03PM >>> When i created the table do i need to dump it so that it will go to the jetspeed.script file inside WEB-INF/db folder? or where shud it be? Sangam Dash wrote: > Hi > > I am able to create a table inside the hypersonic database. > Now i need to access the table from a portlet and insert some data > into it. > What is the best way to do it? > Are there already available portlets for database transactions? > Or should i create my create own jsp file which will be inside the > portlet and will access the database through a java class ? > > Thanks for all the help > Sangam Dash > Stuart Belden wrote: > >> What database are you using? Hypersonic? MySQL? DB2? Sybase? >> >> You can add the tables by hand, or I image Turbine has a class >> somewhere that will let you execute arbitrary sql. >> I use EJBs to read/write from the db in most cases unless I'm doing a >> quick dirty read of some table. >> >> >> >>>>> [EMAIL PROTECTED] 12/16/02 06:46PM >>> >>>>> >>>> >> Hi >> >> I am a new user to use the jetspeed database. I am not sure how to >> use that. >> Can i create tables in that database? >> then how? >> I have a portlet that will write something to the database? >> What is the best way to do that? >> Please suggest... >> Thanks >> sangam dash >> >> >> >> -- >> To unsubscribe, e-mail: >> <mailto:[EMAIL PROTECTED]> >> For additional commands, e-mail: >> <mailto:[EMAIL PROTECTED]> >> >> >> >> -- >> To unsubscribe, e-mail: >> <mailto:[EMAIL PROTECTED]> >> For additional commands, e-mail: >> <mailto:[EMAIL PROTECTED]> >> >> >> > > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
