Re: Database?

Tue, 17 Dec 2002 18:00:02 -0800 

Sangam Dash wrote:


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




Hi



i did what i could do for this database thing

i need some help to finish this one

what i did

<%@ page language="java"

        session="false"

%>

<%@ taglib uri='/WEB-INF/templates/jsp/tld/template.tld' 
prefix='jetspeed' %>

<%String jspeid = (String) request.getAttribute("js_peid");

%>

<form method="post" action="<jetspeed:dynamicUri/>">

<p>

<b>Please Enter your email address to subscribe to our Newsletters</b>

   <table>

     <tr>

   <td><input type='text' name='email' value=''></td>

   <td><input type="submit" name="eventSubmit_doInsert" value="Submit"/>

</td>

   </tr>

   </table>

</p>

<input type="hidden" name="js_peid" value="<%=jspeid%>">

<input type="hidden" name="action" value="portlets.SubscriptionAction"/>

</form>

this is the jsp file i have created

put it inside the registry

<portlet-entry name="SubscriptionJSP" hidden="false" type="ref"

       parent="JSP" application="false">

       <meta-info>

           <title>Subscription JSP</title>

           <description>Subscription JSP Portlet</description>

       </meta-info>

       <parameter name="template" value="Subscription.jsp" hidden="true"

              cachedOnName="true" cachedOnValue="true"/>

       <parameter name="action" value="portlets.SubscriptionAction" 
hidden="true"/>

       <media-type ref="html"/>

       <url cachedOnURL="true"/>

       <category group="Jetspeed">demo</category>

       <category group="Jetspeed">jsp.demo</category>

   </portlet-entry>

then created a java class extending JspPortletAction which has a method 
doInsert(rundata, portlet)

the jsp page with the text field and the button shows up in the portlet

when i enter something and press enter it doesnt do anything

the log debug messages doesnt show anywhere in the log files?

do i need to go for Velocity or how shud i do this

its really confusing

are the jsp templates are not working properly in the jetspeed1.4b2?

please help me

thanks

sangam dash







--

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

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
























					Reply via email to