Stuart Belden wrote:

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]>


hi

if i have crated a new table do i need to create a new object ?
cant i directly access the connection and execute a query to insert data into that table?>
which is the class to get the connection for jetspeed?
thanks
sangam dash



--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>



Reply via email to