vif-devel — VIF developers

[Vif-devel] Eclipse configuration for VIF

[Luthiger S. B. <ben...@id...>]

Dear Ramesh Ale

=20

> I solved the problem with the Database driver.

Very good. How did you achieve this? What was the problem?

=20

To start developing, you have to download/checkout the projects VIF, VIF
Framework, vifapp, VIF Test and VIF Framework Test (see
http://vif.cvs.sourceforge.net/vif/).

The dependencies are as follows:

=20

VIF Framework needs to have the following jars on the build path:

activation.jar

jaxp.jar

mail.jar

servlet-api.jar

=20

VIF references VIF Framework and additionally needs to have the
following jars on the build path:

lucene-1.4.3.jar

mail.jar

servlet-api.jar

xalan.jar

xercesImpl.jar

=20

vifapp contains the XSL stylesheets and other resources. It references
VIF and VIF Framework. In my IDE, I have jasper_runtime.jar and
servlet_api.jar on the build path of this project, but I don't remember
whether this is really needed.

=20

Try to run and debug the application from the IDE. I use the Sysdeo
Tomcat launcher plug-in to do this (see
http://www.eclipsetotale.com/tomcatPlugin.html).

=20

When you have successfully configured the application in your Eclipse
IDE, we can look at the task 'Webmail integrated in the administration
part' you could implement.

=20

Regards,

Benno

=20

=20

From: ale ramesh [mailto:ale...@ya...]=20
Sent: Samstag, 3. November 2007 16:49
To: vif...@li...
Cc: Luthiger Stoll Benno
Subject: Re: [Vif-devel] Problem with driver

=20

Hi Luthiger,

I got the mail which u have sent to the mailing list. I solved the
problem with the Database driver.
And i think now the application is in good shape.
Please tell me to what to do next?

I have installed Eclipse europa  Version: 3.3.0. Do i have to install
any frame work?

Thanks & Regards,
Ramesh Ale  =20

----- Original Message ----
From: Luthiger Stoll Benno <ben...@id...>
To: ale ramesh <ale...@ya...>
Sent: Thursday, November 1, 2007 2:12:54 PM
Subject: FW: [Vif-devel] Problem with driver

Dear Ramesh Ale

=20

Did you receive the mail I sent to the list yesterday? Have you been
able to solve the problem with the information given?=20

=20

Regards,

Benno

=20

=20


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20

Re: [Vif-devel] Problem with driver

[ale r. <ale...@ya...>]

Hi Luthiger,=0A=0AI got the mail which u have sent to the mailing list. I s=
olved the problem with the Database driver.=0AAnd i think now the applicati=
on is in good shape.=0APlease tell me to what to do next?=0A=0AI have insta=
lled Eclipse europa  Version: 3.3.0. Do i have to install any frame work?=
=0A=0AThanks & Regards,=0ARamesh Ale    =0A=0A----- Original Message ----=
=0AFrom: Luthiger Stoll Benno <ben...@id...>=0ATo: ale ramesh =
<ale...@ya...>=0ASent: Thursday, November 1, 2007 2:12:54 PM=0ASubj=
ect: FW: [Vif-devel] Problem with driver=0A=0A=0A=0A=0A =0A =0A=0A<!--=0A _=
filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}=0A _filtered =
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}=0A/* Style Definitions =
*/=0A p.MsoNormal, li.MsoNormal, div.MsoNormal=0A=09{margin:0cm;margin-bott=
om:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}=0Aa:li=
nk, span.MsoHyperlink=0A=09{color:blue;text-decoration:underline;}=0Aa:visi=
ted, span.MsoHyperlinkFollowed=0A=09{color:purple;text-decoration:underline=
;}=0Ap.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph=0A=09{ma=
rgin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt;margin-b=
ottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}=0Ap=
..msochpdefault, li.msochpdefault, div.msochpdefault=0A=09{margin-right:0cm;=
margin-left:0cm;font-size:10.0pt;font-family:"Times New Roman", "serif";}=
=0Aspan.emailstyle17=0A=09{font-family:"Calibri", "sans-serif";color:#1F497=
D;}=0Aspan.emailstyle20=0A=09{font-family:"Calibri", "sans-serif";color:#1F=
497D;}=0Aspan.emailstyle21=0A=09{font-family:"Calibri", "sans-serif";color:=
#1F497D;}=0Aspan.EmailStyle22=0A=09{font-family:"Calibri", "sans-serif";col=
or:#1F497D;}=0Aspan.EmailStyle23=0A=09{font-family:"Calibri", "sans-serif";=
color:#1F497D;}=0A.MsoChpDefault=0A=09{font-size:10.0pt;}=0A _filtered {mar=
gin:72.0pt 72.0pt 72.0pt 72.0pt;}=0Adiv.Section1=0A=09{}=0A-->=0A=0A=0A=0A=
=0A=0A=0ADear Ramesh Ale=0A =0A=0A  =0A =0A=0ADid you receive the mail I se=
nt to the list yesterday? Have you=0Abeen able to solve the problem with th=
e information given? =0A =0A=0A  =0A =0A=0ARegards,=0A =0A=0ABenno=0A=0A=0A=
=0A=0A=0A=0A=0A__________________________________________________=0ADo You =
Yahoo!?=0ATired of spam?  Yahoo! Mail has the best spam protection around =
=0Ahttp://mail.yahoo.com 

Re: [Vif-devel] Java developers with XSLT knowledge.

[ale r. <ale...@ya...>]

Hi Luthigar,=0A=0AAt last i created the database successfully. This time wh=
en i ran the command=0AD:\VIF project\scripts\MySql> installdb dummy=0Ai go=
t some output like Create table and so on...But no error.=0A=0ABut as you m=
entioned in the installation document for  JNDI connection lookup i copied =
the mysql-connector-java-3.0.17-ga-bin.jar file to C:\Program Files\Apache =
Software Foundation\Tomcat 5.0\common\endorsed path same way i copied the f=
iles activation.jar and mail.jar files also =0A=0ABut when i copied this li=
nk in my browser http://localhost:8080/vifapp/admin?requestType=3DcreateSU&=
userId=3DsuId&passwd=3DsuPasswd=0AI am getting an error =0A"An error occurr=
ed in the application. Please contact the administrator."=0A=0Aand one more=
 issue i entered this link in my browser http://localhost:8080/vifapp/forum=
?requestType=3Dmaster&body=3Dstartup when i entered user name as 'MyUser' a=
nd password as 'MyPassword'  i am getting an error  like  "org.apache.commo=
ns.dbcp.SQLNestedException: Cannot create JDBC driver=0Aof class '' for con=
nect URL 'null', cause: No suitable driver" =0A =0AWhat should i do to get =
rid of this errors?=0AI have subscribed to the VIF  devel mailing list just=
 now only...=0ASo from next time onwards do u want me to send all my doubts=
 to this mailing list or to your mail ID?=0A=0AThanks & Regards,=0ARamesh A=
le =0A=0A  =0A=0A----- Original Message ----=0AFrom: Luthiger Stoll Benno <=
ben...@id...>=0ATo: ale ramesh <ale...@ya...>=0ACc: vi=
f-...@li...=0ASent: Monday, October 29, 2007 11:11:13 PM=
=0ASubject: RE: Java developers with XSLT knowledge.=0A=0A=0A=0A=0A =0A =0A=
=0A<!--=0A _filtered {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2=
 4;}=0A _filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}=0A _=
filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}=0A/* Style Def=
initions */=0A p.MsoNormal, li.MsoNormal, div.MsoNormal=0A=09{margin:0cm;ma=
rgin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif"=
;}=0Aa:link, span.MsoHyperlink=0A=09{color:blue;text-decoration:underline;}=
=0Aa:visited, span.MsoHyperlinkFollowed=0A=09{color:purple;text-decoration:=
underline;}=0Ap.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph=
=0A=09{margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt=
;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "ser=
if";}=0Ap.msochpdefault, li.msochpdefault, div.msochpdefault=0A=09{margin-r=
ight:0cm;margin-left:0cm;font-size:10.0pt;font-family:"Times New Roman", "s=
erif";}=0Aspan.emailstyle17=0A=09{font-family:"Calibri", "sans-serif";color=
:#1F497D;}=0Aspan.emailstyle20=0A=09{font-family:"Calibri", "sans-serif";co=
lor:#1F497D;}=0Aspan.EmailStyle21=0A=09{font-family:"Calibri", "sans-serif"=
;color:#1F497D;}=0A.MsoChpDefault=0A=09{font-size:10.0pt;}=0A _filtered {ma=
rgin:72.0pt 72.0pt 72.0pt 72.0pt;}=0Adiv.Section1=0A=09{}=0A-->=0A=0A=0A=0A=
=0A=0A=0ADear Ramesh Ale=0A =0A=0A  =0A =0A=0ACongrats to you success in th=
e exam ;-)=0A =0A=0AAnd thanks for your reply.=0A =0A=0A  =0A =0A=0AWith th=
e information you provided I clearly see what went wrong:=0A =0A=0AAfter na=
vigating to the scripts directory (i.e. D:\VIF=0Aproject\scripts\MySql\) yo=
u have to call the installdb.bat script (what you do=0Ais, you pipe this sc=
ript into the MySQL command). Therefore, try the following=0A(we assume you=
 root password for you MySQL database is =A1hypersecret=A2):=0A =0A=0A=3D=
=3D=3D=0A =0A=0AD:\VIF project\scripts\MySql> installdb dummy hypersecret=
=0A =0A=0A=3D=3D=3D=0A =0A=0AIf you take a look at installdb.bat, you see t=
hat this script=0Acalls (among other things) the CreateTables.bat script. C=
reateTables.bat again=0Acalls =0A =0A=0Amysql -u root -p hypersecret  < tab=
le_tblMember.sql =0A =0A=0Aand many other sql scripts.=0A =0A=0A  =0A =0A=
=0ATherefore, it=A2s the job of the InstallDb and CreateTables=0Ascripts to=
 pipe the sql statements into the MySQL command. It=A2s your job=0Ato start=
 this process by calling =A1InstallDb=A2 with the correct=0Aparameters.=0A =
=0A=0A  =0A =0A=0ARegards,=0A =0A=0ABenno=0A =0A=0A  =0A =0A=0APS: I cc a c=
opy to the vif-devel mailing list. I suggest you subscribe=0Ato this list (=
see http://sourceforge.net/mail/?group_id=3D29728)=0Afor that we can discus=
s further using this list. This way, we can document=0Aproblems or misconce=
ptions and how they can be solved.=0A =0A=0A  =0A =0A=0A  =0A =0A=0A=0A=0A=
=0A=0AFrom: ale ramesh=0A[mailto:ale...@ya...] =0A=0ASent: Montag, =
29. Oktober 2007 18:21=0A=0ATo: Luthiger Stoll Benno=0A=0ASubject: Re: Java=
 developers with XSLT knowledge.=0A =0A=0A=0A=0A=0A=0A=0A=0A  =0A =0A=0A=0A=
=0A=0A=0AHi Luthigar,=0A=0A=0A=0ASorry for the delayed reply.Actually i was=
 preparing for the SCJP 5.0 and i=0Acracked the exam with 76%.=0A=0A=0A=0AI=
 am still not able to run the scripts and here is the scenario of the scrip=
ts.=0A=0A1) I opened the command window and navigated to the path where the=
 InstallDB is=0Athere then the path in the command prompt is D:\VIF project=
\scripts\MySql=0A=0A2) (Mysql.exe is set to environement variables) then i =
entered the command like=0Athis =0A=0A            D:\VIF=0Aproject\scripts\=
MySql>mysql -u root -p <installdb.bat =0A=0Athen it is asking for the passw=
ord and i entered the root password and then i=0Agot the output like this=
=0A=0A   Enter password: *****=0A=0A--------------=0A=0Arem=0A=0Arem Instal=
ls MySQL database and tables for the application VIF=0A=0Arem (c) Benno Lut=
higer, Aktion HIP=0A=0AECHO OFF=0A=0AIF "%~1" =3D=3D "" (=0A=0A  ECHO Usage=
: InstallDb path_to_mySQL sqlRootPassword=0A=0A  ECHO   e.g. InstallDb c:=
=0A=0A--------------=0A=0A=0A=0AERROR at line 1: Unknown command '\m'.=0A=
=0A=0A=0AD:\VIF project\scripts\MySql>mysql -u root -p <installdb.bat=0A=0A=
Enter password: *****=0A=0AERROR 1064 (42000) at line 1: You have an error =
in your SQL syntax; check the=0Ama=0A=0Anual that corresponds to your MySQL=
 server version for the right syntax to use=0An=0A=0Aear 'rem=0A=0Arem Inst=
alls MySQL database and tables for the application VIF=0A=0Arem (c) Benno' =
at line 1   =0A=0A=0A=0AThis is happening because of the line ECHO   e.g. I=
nstallDb=0Ac:\programs\mysql\bin myPassword present in the InstallDB.bat so=
 i deleted=0Athat line then i got output like this=0A=0A=0A=0AEnter passwor=
d: *****=0A=0AERROR 1064 (42000) at line 1: You have an error in your SQL s=
yntax; check the=0Ama=0A=0Anual that corresponds to your MySQL server versi=
on for the right syntax to use=0An=0A=0Aear 'rem=0A=0Arem Installs MySQL da=
tabase and tables for the application VIF=0A=0Arem (c) Benno' at line 1 =0A=
=0A=0A=0APlease suggest me how to how to proceed in this issue.=0A=0A=0A=0A=
Thanks & Regards,=0A=0ARamesh Ale=0A =0A=0A=0A=0A----- Original Message ---=
-=0A=0AFrom: Luthiger Stoll Benno <ben...@id...>=0A=0ATo: ale =
ramesh <ale...@ya...>=0A=0ASent: Tuesday, October 23, 2007 2:17:31 =
PM=0A=0ASubject: RE: Java developers with XSLT knowledge.=0A =0A=0A=0A=0ADe=
ar Ramesh Ale=0A =0A=0A =0A =0A=0ADie you found the time to solve the probl=
ems you encountered=0Awith the scripts to initialize the database?=0A =0A=
=0AYou have to run the InstallDb batch with to arguments: the first=0Ais th=
e path to your MySQL installation (i.e. the directory containing the=0Amysq=
l.exe), the second is the password of the MySQL root user. However, if you=
=A2ve=0Aadded your MySQL installation to your platform=A2s path, you can pr=
ovide a dummy=0Aparameter (i.e. placeholder) as first parameter.=0A =0A=0A =
=0A =0A=0ARegards,=0A =0A=0ABenno=0A =0A=0A =0A =0A=0A=0A=0A=0A=0AFrom: ale=
 ramesh=0A[mailto:ale...@ya...] =0A=0ASent: Freitag, 19. Oktober 20=
07 15:20=0A=0ATo: Luthiger Stoll Benno=0A=0ASubject: Re: Java developers wi=
th XSLT knowledge.=0A =0A=0A=0A=0A=0A=0A=0A=0A =0A =0A=0A=0A=0A=0A=0AHi,=0A=
=0A=0A=0AI have downloaded eclipse 3.3.0 IDE and i am  working on  Windows =
XP.=0A=0AI followed the steps given in the http://vif.sourceforge.net/insta=
ll.html =0Ato setup database.But i could not create database table.Please e=
xplain me briefly=0Ahow to run the scripts to create Database.=0A=0A=0A=0AT=
hanks & Regards,=0A=0ARamesh Ale.=0A =0A=0A=0A=0A----- Original Message ---=
-=0A=0AFrom: Luthiger Stoll Benno <ben...@id...>=0A=0ATo: ale =
ramesh <ale...@ya...>=0A=0ASent: Thursday, October 18, 2007 1:30:14=
 PM=0A=0ASubject: RE: Java developers with XSLT knowledge.=0A =0A=0A=0A=0AD=
ear Ramesh Ale=0A =0A=0A =0A =0A=0A- And i have downloaded all the required=
 softwares.=0A=0AGreat, please=0Atell me if you encounter any problems for =
that I can fix or improve the=0Ainstallation process. Which OS and IDE do y=
ou use for development? I=A2m working with=0AEclipse on Windows XP. =0A =0A=
=0A =0A =0A=0AI=A2ve assigned you to=0Athe task =A1Webmail integrated in th=
e administration part=A2. This should be a=0Aminor challenge, but is a good=
 starting point to learn the application and,=0Aabove all,=0Aa very importa=
nt feature for the VIF application.=0A =0A=0AI=A2ve given you CVS=0Awrite-a=
ccess. Please start a new branch if you start developing.=0A =0A=0A =0A =0A=
=0AWhen=0Ayou have the application working, you can download the source cod=
e. You need=0Athe projects VIF, VIF Framework and vifapp for development as=
 well as VIF Test=0Aand VIF Framework Test for testing. If you=A2re using E=
clipse for development, I can=0Asend you precise information concerning pro=
ject configuration.=0A =0A=0A =0A =0A=0AWhen=0Ayou feel ready, I can send y=
ou more information about the task =A1Webmail integrated=0Ain the administr=
ation part=A2.=0A =0A=0A =0A =0A=0ARegards,=0A =0A=0ABenno=0A =0A=0A =0A =
=0A=0A =0A =0A=0A=0A=0A=0A=0AFrom: ale ramesh=0A[mailto:ale...@ya...=
m] =0A=0ASent: Mittwoch, 17. Oktober 2007 20:41=0A=0ATo: Luthiger Stoll Ben=
no=0A=0ASubject: Re: Java developers with XSLT knowledge.=0A =0A=0A=0A=0A=
=0A=0A=0A=0A =0A =0A=0A=0A=0A=0A=0AHi,=0A=0A=0A=0AThanks for selecting me f=
or this project.I have gone through the http://vif.sourceforge.net=0A. I am=
 very much interested in this project.And i have downloaded all the=0Arequi=
red softwares.=0A=0A=0A=0AI have gone through the list of tasks to be assig=
ned.Assign me any task,i don't=0Ahave  any preference regarding this,But le=
t me tell you one thing=0Athat  i am good at  java programming and  i am al=
so good=0Aat  Servlets. =0A=0A=0A=0AOnce again i am very much interested in=
 this project and i really think i can=0Asignificantly contribute to this p=
roject.=0A=0AI am ready for the next necessary steps.=0A=0A=0A=0AThanks & R=
egards,=0A=0ARamesh Ale.   =0A =0A=0A=0A=0A----- Original Message ----=0A=
=0AFrom: Luthiger Stoll Benno <ben...@id...>=0A=0ATo: Ramesh <=
ale...@us...>;=0Aa...@us...=0A=0A=
Sent: Wednesday, October 17, 2007 2:40:21 PM=0A=0ASubject: RE: Java develop=
ers with XSLT knowledge.=0A=0A=0A=0ADear Ramesh Ale=0A=0A=0A=0AThank you fo=
r your interest, and yes, I would like to work with you. =0A=0A=0A=0ADid yo=
u take a look at the project's home page yet (http://vif.sourceforge.net/=
=0A)? You can find there some information about the project's vision and th=
e=0Aframework it uses. =0A=0A=0A=0AMaybe it's a good idea to download and i=
nstall the actual release (Rel. 0.8.3)=0Aof the project. You can also take =
a look at the source code (in the CVS or=0Adistributed with the release). O=
n http://vif.sourceforge.net/application/walkthrogh.html=0Ayou get informat=
ion for a walk through the forum application.=0A=0AI've published a list of=
 task on the project's mailing list. The list is=0Aavailable on http://sour=
ceforge.net/tracker/?group_id=3D29728&atid=3D397061 =0Atoo. With these impr=
essions you should be able to decide whether you want to=0Ainvest in my pro=
ject or not.=0A=0APlease tell me if this complies with your interest. Pleas=
e tell me also your=0Adevelopment preferences. =0A=0A=0A=0AIf I get a posit=
ive feedback from you, we can discuss the next steps you could=0Aturn to.=
=0A=0A=0A=0ARegards,=0A=0ABenno Luthiger=0A=0A=0A=0A_______________________=
_______________=0A=0AETH Zurich=0A=0ABenno Luthiger=0A=0AIT Services=0A=0AW=
EP J 14, Weinbergstrasse 109=0A=0A8092 Zurich, Switzerland=0A=0A=0A=0ATel: =
+41 44 632 57 65=0A=0A______________________________________=0A=0A=0A=0A=0A=
=0A=0A=0A-----Original Message-----=0A=0AFrom: Nobody [mailto:nobody@sc8-sf=
-web21.sourceforge.net] On Behalf Of Ramesh=0A=0ASent: Mittwoch, 17. Oktobe=
r 2007 08:30=0A=0ATo: akt...@us...=0A=0ACc: ale_ramesh@=
users.sourceforge.net=0A=0ASubject: RE: Java developers with XSLT knowledge=
..=0A=0A=0A=0A=0A=0AMessage body follows:=0A=0A=0A=0AHi,=0A=0A=0A=0A  This i=
s Ramesh,Working as a Programmer Analyst in=0A=0ACognizant Technology Solut=
ions for the last one year.=0A=0AI am looking for an opportunity to improve=
 my development=0A=0Askills...=0A=0A=0A=0ALanguages Known: C,Core Java,Swin=
gs,JDBC.=0A=0A=0A=0ATechnologies : Servlets,JSP.=0A=0A=0A=0ADatabase :SQL=
=0A=0A=0A=0AWorked in following projects.=0A=0A=0A=0A1)CCC Insurance projec=
t.=0A=0A2)International Next Generation Apply(e-Apply) Banking=0A=0Aapplica=
tion.=0A=0A=0A=0ALooking forward to join your team,Please give me a chance =
to=0A=0Adevelop my skills.=0A=0A=0A=0AWaiting for your reply=0A=0AThanks & =
Regards,=0A=0ARamesh Ale=0A=0A=0A=0A--=0A=0AThis message has been sent to y=
ou, a registered SourceForge.net user,=0A=0Aby another site user, through t=
he SourceForge.net site.  This message=0A=0Ahas been delivered to your Sour=
ceForge.net=0Amail alias.  You may reply=0A=0Ato this message using the "Re=
ply" feature of your email client, or=0A=0Ausing the messaging facility of =
SourceForge.net=0Aat:=0A=0Ahttps://sourceforge.net/sendmessage.php?touser=
=3D1910658=0A=0A =0A=0A=0A=0A=0A =0A =0A=0A=0A=0A=0A=0A=0A=0A=0A=0A________=
__________________________________________=0A=0ADo You Yahoo!?=0A=0ATired o=
f spam? Yahoo! Mail has the best spam protection around =0A=0Ahttp://mail.y=
ahoo.com =0A =0A=0A=0A=0A=0A=0A=0A=0A =0A =0A=0A=0A=0A=0A=0A=0A=0A=0A=0A___=
_______________________________________________=0A=0ADo You Yahoo!?=0A=0ATi=
red of spam? Yahoo! Mail has the best spam protection around =0A=0Ahttp://m=
ail.yahoo.com =0A =0A=0A=0A=0A=0A=0A=0A=0A  =0A =0A=0A=0A=0A=0A=0A=0A=0A=0A=
=0A__________________________________________________=0A=0ADo You Yahoo!?=
=0A=0ATired of spam? Yahoo! Mail has the best spam protection around =0A=0A=
http://mail.yahoo.com =0A =0A=0A=0A=0A=0A=0A=0A=0A=0A=0A___________________=
_______________________________=0ADo You Yahoo!?=0ATired of spam?  Yahoo! M=
ail has the best spam protection around =0Ahttp://mail.yahoo.com 

Re: [Vif-devel] Java developers with XSLT knowledge.

[Luthiger S. B. <ben...@id...>]

Dear Ramesh Ale

=20

Congrats to you success in the exam ;-)

And thanks for your reply.

=20

With the information you provided I clearly see what went wrong:

After navigating to the scripts directory (i.e. D:\VIF =
project\scripts\MySql\) you have to call the installdb.bat script (what =
you do is, you pipe this script into the MySQL command). Therefore, try =
the following (we assume you root password for you MySQL database is =
'hypersecret'):

=3D=3D=3D

D:\VIF project\scripts\MySql> installdb dummy hypersecret

=3D=3D=3D

If you take a look at installdb.bat, you see that this script calls =
(among other things) the CreateTables.bat script. CreateTables.bat again =
calls=20

mysql -u root -p hypersecret  < table_tblMember.sql=20

and many other sql scripts.

=20

Therefore, it's the job of the InstallDb and CreateTables scripts to =
pipe the sql statements into the MySQL command. It's your job to start =
this process by calling 'InstallDb' with the correct parameters.

=20

Regards,

Benno

=20

PS: I cc a copy to the vif-devel mailing list. I suggest you subscribe =
to this list (see http://sourceforge.net/mail/?group_id=3D29728) for =
that we can discuss further using this list. This way, we can document =
problems or misconceptions and how they can be solved.

=20

=20

From: ale ramesh [mailto:ale...@ya...]=20
Sent: Montag, 29. Oktober 2007 18:21
To: Luthiger Stoll Benno
Subject: Re: Java developers with XSLT knowledge.

=20

Hi Luthigar,

Sorry for the delayed reply.Actually i was preparing for the SCJP 5.0 =
and i cracked the exam with 76%.

I am still not able to run the scripts and here is the scenario of the =
scripts.
1) I opened the command window and navigated to the path where the =
InstallDB is there then the path in the command prompt is D:\VIF =
project\scripts\MySql
2) (Mysql.exe is set to environement variables) then i entered the =
command like this=20
            D:\VIF project\scripts\MySql>mysql -u root -p <installdb.bat =

then it is asking for the password and i entered the root password and =
then i got the output like this
   Enter password: *****
--------------
rem
rem Installs MySQL database and tables for the application VIF
rem (c) Benno Luthiger, Aktion HIP
ECHO OFF
IF "%~1" =3D=3D "" (
  ECHO Usage: InstallDb path_to_mySQL sqlRootPassword
  ECHO   e.g. InstallDb c:
--------------

ERROR at line 1: Unknown command '\m'.

D:\VIF project\scripts\MySql>mysql -u root -p <installdb.bat
Enter password: *****
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; =
check the ma
nual that corresponds to your MySQL server version for the right syntax =
to use n
ear 'rem
rem Installs MySQL database and tables for the application VIF
rem (c) Benno' at line 1  =20

This is happening because of the line ECHO   e.g. InstallDb =
c:\programs\mysql\bin myPassword present in the InstallDB.bat so i =
deleted that line then i got output like this

Enter password: *****
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; =
check the ma
nual that corresponds to your MySQL server version for the right syntax =
to use n
ear 'rem
rem Installs MySQL database and tables for the application VIF
rem (c) Benno' at line 1=20

Please suggest me how to how to proceed in this issue.

Thanks & Regards,
Ramesh Ale

----- Original Message ----
From: Luthiger Stoll Benno <ben...@id...>
To: ale ramesh <ale...@ya...>
Sent: Tuesday, October 23, 2007 2:17:31 PM
Subject: RE: Java developers with XSLT knowledge.

Dear Ramesh Ale

=20

Die you found the time to solve the problems you encountered with the =
scripts to initialize the database?

You have to run the InstallDb batch with to arguments: the first is the =
path to your MySQL installation (i.e. the directory containing the =
mysql.exe), the second is the password of the MySQL root user. However, =
if you=A2ve added your MySQL installation to your platform=A2s path, you =
can provide a dummy parameter (i.e. placeholder) as first parameter.

=20

Regards,

Benno

=20

From: ale ramesh [mailto:ale...@ya...]=20
Sent: Freitag, 19. Oktober 2007 15:20
To: Luthiger Stoll Benno
Subject: Re: Java developers with XSLT knowledge.

=20

Hi,

I have downloaded eclipse 3.3.0 IDE and i am  working on  Windows XP.
I followed the steps given in the =
http://vif.sourceforge.net/install.html  to setup database.But i could =
not create database table.Please explain me briefly how to run the =
scripts to create Database.

Thanks & Regards,
Ramesh Ale.

----- Original Message ----
From: Luthiger Stoll Benno <ben...@id...>
To: ale ramesh <ale...@ya...>
Sent: Thursday, October 18, 2007 1:30:14 PM
Subject: RE: Java developers with XSLT knowledge.

Dear Ramesh Ale

=20

- And i have downloaded all the required softwares.
Great, please tell me if you encounter any problems for that I can fix =
or improve the installation process. Which OS and IDE do you use for =
development? I=A2m working with Eclipse on Windows XP.=20

=20

I=A2ve assigned you to the task =A1Webmail integrated in the =
administration part=A2. This should be a minor challenge, but is a good =
starting point to learn the application and, above all, a very important =
feature for the VIF application.

I=A2ve given you CVS write-access. Please start a new branch if you =
start developing.

=20

When you have the application working, you can download the source code. =
You need the projects VIF, VIF Framework and vifapp for development as =
well as VIF Test and VIF Framework Test for testing. If you=A2re using =
Eclipse for development, I can send you precise information concerning =
project configuration.

=20

When you feel ready, I can send you more information about the task =
=A1Webmail integrated in the administration part=A2.

=20

Regards,

Benno

=20

=20

From: ale ramesh [mailto:ale...@ya...]=20
Sent: Mittwoch, 17. Oktober 2007 20:41
To: Luthiger Stoll Benno
Subject: Re: Java developers with XSLT knowledge.

=20

Hi,

Thanks for selecting me for this project.I have gone through the =
http://vif.sourceforge.net <http://vif.sourceforge.net/>  . I am very =
much interested in this project.And i have downloaded all the required =
softwares.

I have gone through the list of tasks to be assigned.Assign me any =
task,i don't have  any preference regarding this,But let me tell you one =
thing that  i am good at  java programming and  i am also good at  =
Servlets.=20

Once again i am very much interested in this project and i really think =
i can significantly contribute to this project.
I am ready for the next necessary steps.

Thanks & Regards,
Ramesh Ale.  =20

----- Original Message ----
From: Luthiger Stoll Benno <ben...@id...>
To: Ramesh <ale...@us...>; =
akt...@us...
Sent: Wednesday, October 17, 2007 2:40:21 PM
Subject: RE: Java developers with XSLT knowledge.

Dear Ramesh Ale

Thank you for your interest, and yes, I would like to work with you.=20

Did you take a look at the project's home page yet =
(http://vif.sourceforge.net/ )? You can find there some information =
about the project's vision and the framework it uses.=20

Maybe it's a good idea to download and install the actual release (Rel. =
0.8.3) of the project. You can also take a look at the source code (in =
the CVS or distributed with the release). On =
http://vif.sourceforge.net/application/walkthrogh.html =
<http://vif.sourceforge.net/application/walkthrogh..html>  you get =
information for a walk through the forum application.
I've published a list of task on the project's mailing list. The list is =
available on =
http://sourceforge.net/tracker/?group_id=3D29728&atid=3D397061  too. =
With these impressions you should be able to decide whether you want to =
invest in my project or not.
Please tell me if this complies with your interest. Please tell me also =
your development preferences.=20

If I get a positive feedback from you, we can discuss the next steps you =
could turn to.

Regards,
Benno Luthiger

______________________________________
ETH Zurich
Benno Luthiger
IT Services
WEP J 14, Weinbergstrasse 109
8092 Zurich, Switzerland

Tel: +41 44 632 57 65
______________________________________



-----Original Message-----
From: Nobody [mailto:no...@sc...] On Behalf Of =
Ramesh
Sent: Mittwoch, 17. Oktober 2007 08:30
To: akt...@us...
Cc: ale...@us...
Subject: RE: Java developers with XSLT knowledge.


Message body follows:

Hi,

  This is Ramesh,Working as a Programmer Analyst in
Cognizant Technology Solutions for the last one year.
I am looking for an opportunity to improve my development
skills...

Languages Known: C,Core Java,Swings,JDBC.

Technologies : Servlets,JSP.

Database :SQL

Worked in following projects.

1)CCC Insurance project.
2)International Next Generation Apply(e-Apply) Banking
application.

Looking forward to join your team,Please give me a chance to
develop my skills.

Waiting for your reply
Thanks & Regards,
Ramesh Ale

--
This message has been sent to you, a registered SourceForge.net user,
by another site user, through the SourceForge.net site.  This message
has been delivered to your SourceForge.net mail alias.  You may reply
to this message using the "Reply" feature of your email client, or
using the messaging facility of SourceForge.net at:
https://sourceforge.net/sendmessage.php?touser=3D1910658=20

=20


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20

=20


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20

=20


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20

[Vif-devel] Removed deprecated methods in VIF framework.

[Luthiger S. B. <ben...@id...>]

Dear Harry

Did you find the time to work on the pluggable sinks task?

I've made a little work in the framework packages: I've removed =
deprecated methods and unused fields that caused Java compiler warnings. =
I've tagged this version with 'FW_Rel_0_9_7_5'. You can check out this =
version to clean up your IDE.

Regards,
Benno

______________________________________
Benno Luthiger
WEP J 14
ETH Zurich
8092 Zurich, Switzerland

Tel: +41 44 632 57 65
______________________________________

Re: [Vif-devel] Problem with database access

[Luthiger S. B. <ben...@id...>]

Dear Harry

It seems that you encounter the same problem I've faced once. This has =
to do with the JNDI lookup mechanism I guess.

I've been able to solve the problem by changing the attributes in the =
Tomcat instances server.xml.
When I set the attributes of the <Host> element as follows:
      <Host name=3D"localhost" appBase=3D"webapps"=20
            unpackWARs=3D"true" autoDeploy=3D"false" />
the application was able to create the JNDI context and, therefore, to =
lookup the resources.

When I set autoDeploy=3D"true", I recognized that my changes to the =
context.xml (in $TOMCAT/webapps/vifapp/META-INF/context.xml) where =
overwritten by the original context.xml provided by the vifapp.war.

HTH
Benno


-----Original Message-----
From: vif...@li... =
[mailto:vif...@li...]On Behalf Of Harry =
Glasgow
Sent: Dienstag, 20. Juni 2006 15:39
To: vif...@li...
Subject: Re: [Vif-devel] Vif-devel Digest, Vol 1, Issue 93


Dear Benno,

I have made some progress. I am able to get the smoke to show the =
database information but only if I use the tomcat administration console =
to create the data source. jdbc/VIF exists in the vifapp resources but =
is initially unconfigured. Which file configures this? I have tried =
changing vifapp\META-INF\Context.xml and restarting but it does not =
alter things.

Also I have substituted the servlet jar from tomcat and can now compile =
the code base, thanks.

Regards,
Harry

=20

Re: [Vif-devel] Vif-devel Digest, Vol 1, Issue 93

[Harry G. <har...@gm...>]

Dear Benno,

I have made some progress. I am able to get the smoke to show the database
information but only if I use the tomcat administration console to create
the data source.
jdbc/VIF<http://localhost:8080/admin/resources/setUpDataSource.do?objectName=Catalina%3Atype%3DResource%2Cresourcetype%3DContext%2Cpath%3D%2Fvifapp%2Chost%3Dlocalhost%2Cclass%3Djavax.sql.DataSource%2Cname%3Djdbc%252FVIF&resourcetype=Context&path=%2Fvifapp&host=localhost&domain=Catalina>exists
in the vifapp resources but is initially unconfigured. Which file
configures this? I have tried changing vifapp\META-INF\Context.xml and
restarting but it does not alter things.

Also I have substituted the servlet jar from tomcat and can now compile the
code base, thanks.

Regards,
Harry


On 6/20/06, vif...@li... <
vif...@li...> wrote:
>
> Send Vif-devel mailing list submissions to
>        vif...@li...
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        https://lists.sourceforge.net/lists/listinfo/vif-devel
> or, via email, send a message with subject or body 'help' to
>        vif...@li...
>
> You can reach the person managing the list at
>        vif...@li...
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Vif-devel digest..."
>
>
> Today's Topics:
>
>   1. Problem with database access (Luthiger Stoll  Benno)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 19 Jun 2006 15:14:58 +0200
> From: "Luthiger Stoll  Benno" <ben...@id...>
> Subject: [Vif-devel] Problem with database access
> To: "Harry Glasgow" <har...@gm...>
> Cc: "VIF Devel Mailinglist \(E-mail\)"
>        <vif...@li...>
> Message-ID: <E3E...@EX...>
> Content-Type: text/plain;       charset="iso-8859-1"
>
> Dear Harry
>
> Did you try the smoke test (http://localhost:8080/forum?requestType=smoke
> )?
> If all is correct, you should see there three sections: Servlet Container,
> Java and Database.
> However, I guess that the section "Database" is missing. I encountered
> such problems and was able to solve them by copying the MySQL-JDBC driver
> into the Tomcat's endorsed directory (see remarks on
> http://vif.sourceforge.net/InstallAndRun.html). The path to the Tomcat's
> endorsed directory is displayed on the smoke test page too.
>
> Concerning the other error you got:
> You may be correct and the servlet.jar provided by the war file is
> outdated.
> In my development environment I use the jars coming with Tomcat. Maybe
> it's a good idea to drop the servlet.jar from the application as the come
> in correct version with the servlet container anyway.
>
> PS: I send a copy of this mail to the project's mailing list to document
> the issue and how to solve it.
>
> Regards,
> Benno
>
> -----Original Message-----
> From: Harry Glasgow [mailto:har...@gm...]
> Sent: Montag, 19. Juni 2006 14:21
> To: Luthiger Stoll Benno
> Subject: Re: Java developers with XSLT knowledge.
>
>
> Hi Benno,
>
> I have had a look around the project's home page and have begun reading
> some of the documentation. The concept is very interesting and it would be
> great to help progress the application.
>
> I have run the war in Tomcat and, using the installation instructions, I
> was able to get as far as the createSU request type, but then got an error.
> The error log says:
>
> at org.hip.kernel.bom.impl.DomainObjectHomeImpl.getDBAdapter
> DomainObjectHomeImpl.java:421)[...]
> Caused by: java.lang.NullPointerException
> at org.hip.kernel.bom.impl.DBAdapterSelector.isDBType(
> DBAdapterSelector.java:89)
> at org.hip.kernel.bom.impl.DBAdapterSelector.initialize(
> DBAdapterSelector.java:77)
> at org.hip.kernel.bom.impl.DBAdapterSelector.<init>(DBAdapterSelector.java
> :63)
> at org.hip.kernel.bom.impl.DBAdapterSelector.<clinit>(
> DBAdapterSelector.java:48)
> ... 42 more
>
> I will try to work out what is in error soon.
>
> Also I have done an anonymous download of the source and get a compile
> error in AbstractRequestHandler at line 151 because getRequestURL() is
> unknown for HttpServletRequest. I am using the jars from the war file. Is
> the servlet.jar the correct version?
>
> When I am able to run the site successfully, it will be easier to
> investigate the tasks and perhaps be able to resolve some. I am more
> interested with the client / web side of applications but I am adaptable if
> required.
>
> Regards,
> Harry Glasgow
>
>
>
> ------------------------------
>
>
>
> ------------------------------
>
> _______________________________________________
> Vif-devel mailing list
> Vif...@li...
> https://lists.sourceforge.net/lists/listinfo/vif-devel
>
>
> End of Vif-devel Digest, Vol 1, Issue 93
> ****************************************
>

[Vif-devel] Problem with database access

[Luthiger S. B. <ben...@id...>]

Dear Harry

Did you try the smoke test =
(http://localhost:8080/forum?requestType=3Dsmoke)?
If all is correct, you should see there three sections: Servlet =
Container, Java and Database.
However, I guess that the section "Database" is missing. I encountered =
such problems and was able to solve them by copying the MySQL-JDBC =
driver into the Tomcat's endorsed directory (see remarks on =
http://vif.sourceforge.net/InstallAndRun.html). The path to the Tomcat's =
endorsed directory is displayed on the smoke test page too.

Concerning the other error you got:=20
You may be correct and the servlet.jar provided by the war file is =
outdated.
In my development environment I use the jars coming with Tomcat. Maybe =
it's a good idea to drop the servlet.jar from the application as the =
come in correct version with the servlet container anyway.

PS: I send a copy of this mail to the project's mailing list to document =
the issue and how to solve it.

Regards,
Benno

-----Original Message-----
From: Harry Glasgow [mailto:har...@gm...]
Sent: Montag, 19. Juni 2006 14:21
To: Luthiger Stoll Benno
Subject: Re: Java developers with XSLT knowledge.


Hi Benno,

I have had a look around the project's home page and have begun reading =
some of the documentation. The concept is very interesting and it would =
be great to help progress the application.

I have run the war in Tomcat and, using the installation instructions, I =
was able to get as far as the createSU request type, but then got an =
error. The error log says:

at org.hip.kernel.bom.impl.DomainObjectHomeImpl.getDBAdapter =
DomainObjectHomeImpl.java:421)[...]
Caused by: java.lang.NullPointerException
 at =
org.hip.kernel.bom.impl.DBAdapterSelector.isDBType(DBAdapterSelector.java=
:89)
 at =
org.hip.kernel.bom.impl.DBAdapterSelector.initialize(DBAdapterSelector.ja=
va:77)
 at =
org.hip.kernel.bom.impl.DBAdapterSelector.<init>(DBAdapterSelector.java:6=
3)
 at =
org.hip.kernel.bom.impl.DBAdapterSelector.<clinit>(DBAdapterSelector.java=
:48)
 ... 42 more
=20
I will try to work out what is in error soon.

Also I have done an anonymous download of the source and get a compile =
error in AbstractRequestHandler at line 151 because getRequestURL() is =
unknown for HttpServletRequest. I am using the jars from the war file. =
Is the servlet.jar the correct version?

When I am able to run the site successfully, it will be easier to =
investigate the tasks and perhaps be able to resolve some. I am more =
interested with the client / web side of applications but I am adaptable =
if required.

Regards,
Harry Glasgow

[Vif-devel] VIF Release 0.8.2 available

[Luthiger S. B. <ben...@id...>]

Hello

I've released version 0.8.2 of the VIF application today.
This release contains the following improvements:

Changes to Release 0.8.2
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

New features:
- Implemented feature to suspend participation in the discussion groups =
the participant is registered during a specified time span.
- Added possibility to store Lucene search indexes in database (created =
new table tblLuceneIndex).

Bugs fixed:
- Corrected wrong path to menu in change password and save personal data =
task.
- Fixed typo in permission table that prevented management of =
subscriptions.

Framework 0.9.7.4:
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

- Added Java2 connection pooling and JNDI resource access.
- Added storing and retrieving of binary data to persistence layer.
- Improved PreparedUpdateStatement making it possible to update a whole =
set of entries.

Regards,
Benno Luthiger

_______________________________________________________________________

Benno Luthiger
WEP J 14
ETH Zurich
8092 Zurich, Switzerland
_______________________________________________________________________

RE: Re[2]: [Vif-devel] suspend participation

[Luthiger S. B. <ben...@id...>]

Dear Jacek

Here my suggestions for the question you asked:

> LSB> - Language and date format should be passed to the page=20
> and calendar widget displayed.
>=20
> What do you mean by that? Should the date format be based on the
> default locale settings or maybe stored somewhere in the application
> configuration data? Do you set locale (either to en or de)=20
> when user chooses his language version?
> I experimented with locale settings and I couldn't manage to
> parse date to the timestamp object basing on the locale settings.
> Maybe you have some experience with that?
There's only the chosen language string stored, in the context (after =
the user has selected the language on the login page). You get the =
selected language through 'getContext().getLanguage()'. This will return =
the usual language string, at the moment 'en' or 'de'.

The locale is not stored anywhere, but you can easily create one:
---
new Locale(getContext().getLanguage(),"")
---

I think, the easiest way to let the xsl know which language to display =
the calendar widget and which date format to use is to add two new tags =
to the StringBuffer 'lInsertedXML' in  =
org.hip.vif.forum.servlets.impl.SuspendTaskView. (BTW do you need the =
"<Registrations>" there?) You then can evaluate this information in =
forum/shared/suspend/bodyList.xsl.

> I use Opera 8 and had also patch the calendar for this browser because
> it was recognized as IE :) Looks like the widget isn't perfect. :) I
> also had some problems with css's because DOM and styles are=20
> very poorly implemented in the widget and it was using styles from the =
VIF app.
Is there a project mailing list for this calendar widget where one could =
report this bug?

Regards,
Benno


> -----Original Message-----
> From: vif...@li...
> [mailto:vif...@li...]On Behalf Of Jacek
> Obarymski
> Sent: Sonntag, 5. M=E4rz 2006 23:41
> To: vif...@li...
> Subject: Re[2]: [Vif-devel] suspend participation
>=20
>=20
> Dear Benno,
>=20
> LSB> The calendar widget looks cool and works fine, thanks a lot.
> LSB> Storing of the data entered works fine too.
>=20
> LSB> However, in the code to store the suspend period I saw that
> LSB> you iterate through the query result of the groups the user is
> LSB> participating, retrieve the entry in tblParticipant and
> LSB> eventually store the suspend period. This needs two calls to the
> LSB> database for every group the user is participating.
> LSB> That should be reduced to one single but clever update
> LSB> command. Unfortunately, the framework doesn't offer this feature
> LSB> yet :-( This is a serious shortage of the framework and I'll fix
> LSB> that immediately.
>=20
> Yes I've noticed that too and I don't like the solution I
> implemented either  :)) I even thought about improving the framework
> on my own but in the end I thouht that maybe you had your own reasons
> creating the framework this way.
> Anyway I agree with your suggestions.
>=20
>=20
> LSB> Some more suggestions:
> LSB> - Information displayed in the list of discussion groups
> LSB> the participant is registered: At this point, only the group's
> LSB> title and description are relevant. Group size and state can be
> LSB> eliminated, thus giving the description column more space (in
> LSB> case of longer descriptions).
> LSB> - Place of button "Suspend" should be above the list
> LSB> (beyond the form) for that users don't have to scroll in case of
> LSB> long lists.
> LSB> - If a user successfully saves his input, the input fields
> LSB> should be filled when the form is redisplayed.=20
> LSB> - If a user clicks the "Suspend" button without entering
> LSB> (valid) data in both fields, a warning should be displayed
> LSB> (instead of the error message "An error occurred in the
> LSB> application. Please contact the administrator.").
>=20
> OK, this sounds reasonable.
>=20
> LSB> - I noticed that if I enter a date like 03-20-2006 (instead
> LSB> of 20-03-2006), the date is transformed to some date in the next
> LSB> year. However, a feedback like "The date you entered is not a
> LSB> valid date" is better than silently transforming the input in a
> LSB> valid, but not intended date. Is this possible?
>=20
> Probably yes. :)
>=20
> LSB> - Language and date format should be passed to the page=20
> and calendar widget displayed.
>=20
> What do you mean by that? Should the date format be based on the
> default locale settings or maybe stored somewhere in the application
> configuration data? Do you set locale (either to en or de)=20
> when user chooses his language version?
> I experimented with locale settings and I couldn't manage to
> parse date to the timestamp object basing on the locale settings.
> Maybe you have some experience with that?
>=20
> LSB> On thing that troubled me at the beginning was that I had
> LSB> to patch the popcalendar.js: In the last line of this file I had
> LSB> to write "init();" instead of "window.onload =3D init;". Can you
> LSB> explain that? I use Firefox 1.5.0.1, which browser do you use?
>=20
> I use Opera 8 and had also patch the calendar for this browser because
> it was recognized as IE :) Looks like the widget isn't perfect. :) I
> also had some problems with css's because DOM and styles are=20
> very poorly
> implemented in the widget and it was using styles from the VIF app.
>=20
> LSB> All in all I'm very pleased with the work you've done so far.
>=20
> Thanks a lot. :))
>=20
> --=20
> Regards
>  Jacek Obarymski
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking=20
> scripting language
> that extends applications into web and mobile media. Attend=20
> the live webcast
> and join the prime developer group breaking into this new=20
> coding territory!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&
dat=3D121642
_______________________________________________
Vif-devel mailing list
Vif...@li...
https://lists.sourceforge.net/lists/listinfo/vif-devel

[Vif-devel] VIF Framework changes checked in

[Luthiger S. B. <ben...@id...>]

Dear Jacek

I've checked in the changes for the PreparedUpdateStatement, making it =
possible now to update a whole set of entries. You can update VIF =
Framework (and VIF Framework Test) from the main trunk.

Regards,
Benno

Re[2]: [Vif-devel] suspend participation

[Jacek O. <jac...@po...>]

Dear Benno,

LSB> The calendar widget looks cool and works fine, thanks a lot.
LSB> Storing of the data entered works fine too.

LSB> However, in the code to store the suspend period I saw that
LSB> you iterate through the query result of the groups the user is
LSB> participating, retrieve the entry in tblParticipant and
LSB> eventually store the suspend period. This needs two calls to the
LSB> database for every group the user is participating.
LSB> That should be reduced to one single but clever update
LSB> command. Unfortunately, the framework doesn't offer this feature
LSB> yet :-( This is a serious shortage of the framework and I'll fix
LSB> that immediately.

Yes I've noticed that too and I don't like the solution I
implemented either  :)) I even thought about improving the framework
on my own but in the end I thouht that maybe you had your own reasons
creating the framework this way.
Anyway I agree with your suggestions.


LSB> Some more suggestions:
LSB> - Information displayed in the list of discussion groups
LSB> the participant is registered: At this point, only the group's
LSB> title and description are relevant. Group size and state can be
LSB> eliminated, thus giving the description column more space (in
LSB> case of longer descriptions).
LSB> - Place of button "Suspend" should be above the list
LSB> (beyond the form) for that users don't have to scroll in case of
LSB> long lists.
LSB> - If a user successfully saves his input, the input fields
LSB> should be filled when the form is redisplayed. 
LSB> - If a user clicks the "Suspend" button without entering
LSB> (valid) data in both fields, a warning should be displayed
LSB> (instead of the error message "An error occurred in the
LSB> application. Please contact the administrator.").

OK, this sounds reasonable.

LSB> - I noticed that if I enter a date like 03-20-2006 (instead
LSB> of 20-03-2006), the date is transformed to some date in the next
LSB> year. However, a feedback like "The date you entered is not a
LSB> valid date" is better than silently transforming the input in a
LSB> valid, but not intended date. Is this possible?

Probably yes. :)

LSB> - Language and date format should be passed to the page and calendar widget displayed.

What do you mean by that? Should the date format be based on the
default locale settings or maybe stored somewhere in the application
configuration data? Do you set locale (either to en or de) when user chooses his language version?
I experimented with locale settings and I couldn't manage to
parse date to the timestamp object basing on the locale settings.
Maybe you have some experience with that?

LSB> On thing that troubled me at the beginning was that I had
LSB> to patch the popcalendar.js: In the last line of this file I had
LSB> to write "init();" instead of "window.onload = init;". Can you
LSB> explain that? I use Firefox 1.5.0.1, which browser do you use?

I use Opera 8 and had also patch the calendar for this browser because
it was recognized as IE :) Looks like the widget isn't perfect. :) I
also had some problems with css's because DOM and styles are very poorly
implemented in the widget and it was using styles from the VIF app.

LSB> All in all I'm very pleased with the work you've done so far.

Thanks a lot. :))

-- 
Regards
 Jacek Obarymski

RE: [Vif-devel] suspend participation

[Luthiger S. B. <ben...@id...>]

Dear Jacek

The calendar widget looks cool and works fine, thanks a lot.
Storing of the data entered works fine too.

However, in the code to store the suspend period I saw that you iterate =
through the query result of the groups the user is participating, =
retrieve the entry in tblParticipant and eventually store the suspend =
period. This needs two calls to the database for every group the user is =
participating.
That should be reduced to one single but clever update command. =
Unfortunately, the framework doesn't offer this feature yet :-( This is =
a serious shortage of the framework and I'll fix that immediately.
After having checked in the improved update functionality (I'll do this =
next Monday) you should be able to implement in =
org.hip.vif.bom.impl.ParticipantHomeImpl a method like:
---
	public void suspendParticipation(Long inActorID, Timestamp inFrom, =
Timestamp inTo)=20
throws BOMChangeValueException {
		try {
			KeyObject lChange =3D new KeyObjectImpl();
			lChange.setValue(ParticipantHome.KEY_SUSPEND_FROM, inFrom);
			lChange.setValue(ParticipantHome.KEY_SUSPEND_TO, inTo);
		=09
			KeyObject lWhere =3D new KeyObjectImpl();
			lWhere.setValue(ParticipantHome.KEY_MEMBER_ID, inActorID);

			PreparedUpdateStatement lStatement =3D new =
PreparedUpdateStatement(this, lChange, lWhere);
			lStatement.executeUpdate();
			lStatement.commit();
		}=20
		catch (VException exc) {
			throw new BOMChangeValueException(exc.getMessage());
		}=20
		catch (SQLException exc) {
			throw new BOMChangeValueException(exc.getMessage());
		}
	}
---
In org.hip.vif.forum.tasks.impl.SuspendSaveTask all you'll need to do is =
one single command to store the suspend period:
---
getParticipantHome().suspendParticipation(lActorID, new =
Timestamp(sdf.parse(lSuspendFrom).getTime()),new =
Timestamp(sdf.parse(lSuspendTo).getTime()));
---

Some more suggestions:
- Information displayed in the list of discussion groups the participant =
is registered: At this point, only the group's title and description are =
relevant. Group size and state can be eliminated, thus giving the =
description column more space (in case of longer descriptions).
- Place of button "Suspend" should be above the list (beyond the form) =
for that users don't have to scroll in case of long lists.
- If a user successfully saves his input, the input fields should be =
filled when the form is redisplayed.=20
- If a user clicks the "Suspend" button without entering (valid) data in =
both fields, a warning should be displayed (instead of the error message =
"An error occurred in the application. Please contact the =
administrator.").
- I noticed that if I enter a date like 03-20-2006 (instead of =
20-03-2006), the date is transformed to some date in the next year. =
However, a feedback like "The date you entered is not a valid date" is =
better than silently transforming the input in a valid, but not intended =
date. Is this possible?
- Language and date format should be passed to the page and calendar =
widget displayed.

So, there's still something to do ;-)

On thing that troubled me at the beginning was that I had to patch the =
popcalendar.js: In the last line of this file I had to write "init();" =
instead of "window.onload =3D init;". Can you explain that? I use =
Firefox 1.5.0.1, which browser do you use?

All in all I'm very pleased with the work you've done so far.

Greetings,
Benno


> -----Original Message-----
> From: vif...@li...
> [mailto:vif...@li...]On Behalf Of Jacek
> Obarymski
> Sent: Mittwoch, 1. M=E4rz 2006 00:33
> To: vif...@li...
> Subject: [Vif-devel] suspend participation
>=20
>=20
> Dear Beno
>=20
> I've committed code concerning the suspend participation task to my
> brunch of the repository. German language version hast to be added
> yet.
>=20
>=20
> --=20
> Regards
>  Jacek                          mailto:jac...@po...
>=20
>=20

RE: [Vif-devel] suspend participation

[Luthiger S. B. <ben...@id...>]

Dear Jacek

Great, and thanks for the notice.
I've checked out the branch and will look at it the next days.

I got the impression that you grew familiar with the project and the =
code very fast. Therefore, if you enjoy this work, you could look at the =
feature list (see =
http://sourceforge.net/tracker/?group_id=3D29728&atid=3D397061) to find =
a task you could turn to next.

Regards,
Benno


> -----Original Message-----
> From: vif...@li...
> [mailto:vif...@li...]On Behalf Of Jacek
> Obarymski
> Sent: Mittwoch, 1. M=E4rz 2006 00:33
> To: vif...@li...
> Subject: [Vif-devel] suspend participation
>=20
>=20
> Dear Beno
>=20
> I've committed code concerning the suspend participation task to my
> brunch of the repository. German language version hast to be added
> yet.
>=20
>=20
> --=20
> Regards
>  Jacek                          mailto:jac...@po...
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking=20
> scripting language
> that extends applications into web and mobile media. Attend=20
> the live webcast
> and join the prime developer group breaking into this new=20
> coding territory!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&
dat=3D121642
_______________________________________________
Vif-devel mailing list
Vif...@li...
https://lists.sourceforge.net/lists/listinfo/vif-devel

[Vif-devel] suspend participation

[Jacek O. <jac...@po...>]

Dear Beno

I've committed code concerning the suspend participation task to my
brunch of the repository. German language version hast to be added
yet.


-- 
Regards
 Jacek                          mailto:jac...@po...

[Vif-devel] automatic tests

[Jacek O. <jac...@po...>]

Hello Beno,

I'm trying to run automatic JUnit tests and I get some database errors
like:

junit.framework.AssertionFailedError: Base table or view not found,  message from server: "Table 'viftest.tblsubscription' doesn't exist"

and:


java.lang.Error: SQL error while getting connection: java.sql.SQLException: Data source rejected establishment of connection,  message from server: "Too many connections"


I've created the viftest database from the scripts you provided in
CVS. Could you send me some more current version of the scripts?

Why do tests open so many connections? Is there anything I can do
about it i.e. incerasing connection limit or maybe there is a matter
of tests configuration.

-- 
Regards
 Jacek                          mailto:jac...@po...

[Vif-devel] List of future tasks: add 2

[Luthiger S. B. <ben...@id...>]

Hello

Here's another task for the list of future tasks (see =
https://sourceforge.net/tracker/?group_id=3D29728&atid=3D397061):

---
15.) Subject: Mail this question
Forum members should have the possibility to send a question to other =
forum members, e.g. to invite them to comment on the question sent.
The member who sends the question has to fill a mail subject and body =
field and select the participants or members he wants the question sent =
to. (minor challenge)

---

Regards,
Benno

[Vif-devel] RE: inMenuName

[Luthiger S. B. <ben...@id...>]

Dear Sridhanya

I'm a little bit confused:
In the last mail you say that the parameter inMenuFile has the value =
'd:\java\jakarta-tomcat-5.1.30vifapp\admin\en\administration\menu.xmnu' =
whereas in your mail dated from 17/02/2006 you say that the value for =
inMenuFile is =
'd:\java\jakarta-tomcat-5.0.0\webapps\vifapp\admin\en\member\menu.xmnu'.
Can you rectify what you've observed?

Regards,
Benno

-----Original Message-----
From: sridhanya [mailto:sri...@gm...]
Sent: Sonntag, 19. Februar 2006 06:10
To: Luthiger Stoll Benno; vif...@li...
Subject: inMenuName


Hi Benno,
   When i walked through the code,I found the following
   1.String inMenuFile was having the value as
      =
d:\java\jakarta-tomcat-5.1.30vifapp\admin\en\administration\menu.xmnu
  2.Cmenu hashtable was having key  as
  =
D:\java\jakarta-tomcat-5.0.0\webapps\vifapp\admin\en\administration\menu.=
xmnu
Both of them are different in case.
So i added a toLowwercase() to the string [Key of cmenu and inMenuName].
Now i can see the menu's in Application.
Almost all the link are working.

Only the Mainmenu link is again complaining same error.
Which java file i have to look for this.
Or suggest me a workaround for this.

I am also in inprocess of creating setup for JAMES.
Once these two are done i guess i will be comfortable with application.

thanks
sridhanya

[Vif-devel] RE: Regd application

[Luthiger S. B. <ben...@id...>]

Dear Sridhanya=20

> when i deploy the application an one more directory call VIFIndex is =
been created.
> But it seems to a empty folder called members.
> Is this an error in my application.
This is the folder for the lucene search index. It should be filled as =
soon as you create members. If you create content (i.e. create questions =
and completions), there's also a folder 'content' created. This folder =
contains the lucene index data to search for contributions.
I plan to move the lucene search index from the file system into a DB =
table.
You can recreate the search index in the administration part of the =
application. In the Administration menu, you'll find two links 'Refresh =
search index' and 'Refresh person index'.

> shall is start with the webmail task you assigned me.
Yes, don't hesitate ;-) Do you want CVS access to start your work?
I suggest that the you add the links where the administrators can start =
the action to send mails to the Administration menu in the =
administration part.

Regards,
Benno


-----Original Message-----
From: sridhanya [mailto:sri...@gm...]
Sent: Sonntag, 19. Februar 2006 14:36
To: Luthiger Stoll Benno; vif...@li...
Subject: Regd application


Hi Benno,
   James was quite fine.
   Iam able to navigate through almost all the parts of the application.
   when i deploy the application an one more directory call VIFIndex is =
been created.
   But it seems to a empty folder called members.
   Is this an error in my application.
   And now iam comfortable with application.
  shall is start with the webmail task you assigned me.
  And also iam in process of debugging the MainMenuView.java.
  Iam not getting any clue regarding it.
  Iam still getting the error "Premature END of File" For this link =
alone.
  Rest is working.
 =20
Thanks
sridhanya=20

[Vif-devel] Regd application

[sridhanya <sri...@gm...>]

Hi Benno,
   James was quite fine.
   Iam able to navigate through almost all the parts of the application.
   when i deploy the application an one more directory call VIFIndex is bee=
n
created.
   But it seems to a empty folder called members.
   Is this an error in my application.
   And now iam comfortable with application.
  shall is start with the webmail task you assigned me.
  And also iam in process of debugging the MainMenuView.java.
  Iam not getting any clue regarding it.
  Iam still getting the error "Premature END of File" For this link alone.
  Rest is working.

Thanks
sridhanya

[Vif-devel] inMenuName

[sridhanya <sri...@gm...>]

Hi Benno,
   When i walked through the code,I found the following
   1.String inMenuFile was having the value as
      d:\java\jakarta-tomcat-5.1.30vifapp\admin\en\administration\menu.xmnu
  2.Cmenu hashtable was having key  as
  D:\java\jakarta-
tomcat-5.0.0\webapps\vifapp\admin\en\administration\menu.xmnu
Both of them are different in case.
So i added a toLowwercase() to the string [Key of cmenu and inMenuName].
Now i can see the menu's in Application.
Almost all the link are working.

Only the Mainmenu link is again complaining same error.
Which java file i have to look for this.
Or suggest me a workaround for this.

I am also in inprocess of creating setup for JAMES.
Once these two are done i guess i will be comfortable with application.

thanks
sridhanya

[Vif-devel] RE: inMenuName value

[Luthiger S. B. <ben...@id...>]

Dear Sridhanya

> But Cmenu hashtable is not finding the relevant document object=20
> for this corresponding inMenuName.
This is an important observation. Can you check whether the key =
inMenuName is not fount in the Hashtable cMenus because this cMenus is =
empty or because the entries are stored in the Hashtable with a =
different key?

> What is the expected value of inManeuNAme?
The absolute path to the file is what is expected.

I'm quite confident that the key of the problem you encounter can be =
found in org.hip.vif.menu.MenuManager, i.e. how the entries are filled =
into cMenus.

Regards,
Benno


-----Original Message-----
From: sridhanya [mailto:sri...@gm...]
Sent: Freitag, 17. Februar 2006 12:02
To: Luthiger Stoll Benno; vif...@li...
Subject: inMenuName value


Hi Benno,
   As requested i added a system.out.println in MenuManger.java.
  The output was

This is the inMenuName =
=3Dd:\java\jakarta-tomcat-5.0.0\webapps\vifapp\admin\en\member\menu.xmnu

And the file exist in the stated directory.
But Cmenu hashtable is not finding the relevant document object for this =
corresponding inMenuName.

What is the expected value of inManeuNAme?
Relativepath
Absolute Path

Please guide me further

Thanks
sridhanya

[Vif-devel] inMenuName value

[sridhanya <sri...@gm...>]

Hi Benno,
   As requested i added a system.out.println in MenuManger.java.
  The output was

This is the inMenuName =3Dd:\java\jakarta-
tomcat-5.0.0\webapps\vifapp\admin\en\member\menu.xmnu

And the file exist in the stated directory.
But Cmenu hashtable is not finding the relevant document object for this
corresponding inMenuName.

What is the expected value of inManeuNAme?
Relativepath
Absolute Path

Please guide me further

Thanks
sridhanya

[Vif-devel] RE: My Prev Log File

[Luthiger S. B. <ben...@id...>]

Dear Sridhanya

Could you place a system.out.println in =
org.hip.vif.menu.MenuManager.getMenuXML()?
=3D=3D=3D
	public synchronized Document getMenuXML(String inMenuName) {
		System.out.println(inMenuName);
		return (Document)cMenus.get(inMenuName);
	}
=3D=3D=3D
... and then check whether the menu name provided as parameter really =
points to a file that exists in the file system?

I've the impression that the application doesn't show the menu because =
it looks for the files at a wrong place.

Regards,
Benno


-----Original Message-----
From: sridhanya [mailto:sri...@gm...]
Sent: Donnerstag, 16. Februar 2006 17:58
To: Luthiger Stoll Benno
Subject: My Prev Log File


Hi Benno=20
   I told once that i gave system.out,ptintln statement and my output =
was coming occassionally.
  These was the debug messages.
  Now iam not able to see the application

Note
 In String=3D
   xmlAsString varialbe belongs to XmlRepresentation.reveal();
I printed it before we create  documentBulderFactory instance=20

    document =3D =
DocumentBuilderFactory.newInstance().newDocumentBuilder().parse(new =
InputSource(lReader));
This was Null.

Debug messages
--------------------------
In string=3D=3D<?xml version=3D"1.0" =
encoding=3D"UTF-8"?><Root><body>startup</body><Para
meters></Parameters></Root>
In string=3D=3D<?xml version=3D"1.0" =
encoding=3D"UTF-8"?><Root><Parameters></Parameters>
</Root>
In string=3D=3D<?xml version=3D"1.0" encoding=3D"UTF-8"?><Root>
<Member>
    <propertySet>
        <Language>en
</Language>
        <UserID>suId
</UserID>
        <Fax>100
</Fax>
        <Tel>100
</Tel>
        <Firstname>sridhanya
</Firstname>
        <Name>SU
</Name>
        <Street>190,Sai street
</Street>
        <Password>7LP8ZHDj7yt/E
</Password>
        <ID>1</ID>
        <ZIP>100
</ZIP>
        <Sex>0</Sex>
        <City>Saipuram
</City>
        <Mail>sri...@gm...
</Mail>
        <Mutation>Feb 15, 2006</Mutation>
    </propertySet>
</Member> <Navigation  next=3D'FALSE' prev=3D'FALSE' /><PageNr>1 =
</PageNr><LastPageN
r>1</LastPageNr><requestType>showMemberList</requestType>
<TitleLbl>Member administration</TitleLbl>
<SubtitleLbl>Make a selection.</SubtitleLbl>
<linkForEdit>1</linkForEdit>
<groupID>-1</groupID>
<sortedColumn>1</sortedColumn>
<sortDir>1</sortDir>
</Root>
VIFMenuRequestHandler.doGet
VIFMenuRequestHandler.HTMLView
VIFMenuRequestHandler.groupparameters
MenuView.constr 1:
MenuView.createXML
MenuManager.singleton getInstance()
MenuManager.document
AbstractMenuTransformerProxy Construtor
MenuTransformerProxy.construt1
AbstractMenuTransfoermProxy.setStylesheet
AbstractMenuView.setStylesheetParameter
AbstractMenuTransfoermProxy.setStylesheet
AbstractMenuTransfoermProxy.setStylesheet
AbstractMenuTransfoermProxy.setStylesheet
AbstractMenuTransfoermProxy.setStylesheet
AbstractMenuTransfoermProxy.setStylesheet
AbstractMenuTransfomerProxy.renderToDom
In string=3D=3D
[Fatal Error] :-1:-1: Premature end of file.


_----------------End of Log file.

Please guide me.

Thanks
sridhanya

[Vif-devel] Document Object was Null.

[sridhanya <sri...@gm...>]

Hi Benno,
  I intimated you that when i added system.out.println statements i was
occassionally able to see the application.
  Now Iam not able to see the same.:-(
  Actually when i extracted the source code and configured in the eclipse i
got the following error.
   I have sent the screenshot of the same[error.jpg].
Then I changed the follwoing code to

inContext.setRequestURL(new StringBuffer(inRequest.getRequestURI()));

Now iam not able to see the Menu alone.
Rest of the application is visible.
To analyse further i added System.out.println statements.
Iam pasting the same i got in tomcat console.

----------------Debug Messages----------------
-----Debugging----
 All Arguments in MenuView Constructor
 VIFContext=3D/admin
VIF COntext =3D getrequest url/vifapp/admin
 inMenuFile=3Dd:\java\jakarta-
tomcat-5.0.0\webapps\vifapp\admin\en\member\menu.xmnu
inMenuId=3Dcreate
inGroupState=3D
inGroupType=3Dfalse
Now Calling PrepareTransfromation
------Inside createXML-----
MenuManager.getInstance()
MenuManager.getMenuXML
--->End of Log messages.{remaning where not printed because process
terminated due to error.}
Analysis
-----------

I found CMenus[Document object is null].
This i understood by trying to print lMenu.getBaseURI() which is document
object written by the getMEnuXML method.
Immediately Termination of process happend because lMenu was null.

I will also continue my debugging.
But iam astronished why previous 2 to 3 times i was able to see the
application.
Now to proceed i need to resolve it.
And i need your suggestions for the same.

Thanks
sridhanya