vif-devel Mailing List for VIF

Dear Rashi

If MySQL shows up in the taskbar, thats a good sign.
Try to start mysql.exe from the command prompt in the \bin directory of your
MySQL-Installation (e.g. c:\programs\mysql\bin). mysql.exe is a simple
database client for your MySQL-DB. After starting, you see the mysql prompt.
Enter 'use mysql' to connect to the default (i.e. infrastructur) DB.
You can enter there SQL commands like
select * from db;
select * from host;
select * from user;
and so on.
For more information you can consult '4.13.4 Running MySQL on Windows' in
\MySQL\Docs\manual.html.

If you can start mysql.exe and if you connect to the mysql database (via
'use mysql') you should be able to create the vif database. You can do this
by starting InstallDb.bat at the command prompt of the \scripts\MySql
directory of your VIF installation. This script creates the vif database and
the tables and indexes needed for the application so far.

Hope this information is helpful.

Regards,
Benno




> -----Original Message-----
> From: ss ss [mailto:tru...@ya...]
> Sent: Montag, 28. April 2003 17:39
> To: ben...@id...
> Subject: Re: Project VIF: MySQL on Windows ME
>
>
> Thanks Benno. I guess I am able to start the server
> although I dont see any signs of starting in the  DOS
> but it shows in the taskbar. My question is how to
> connect to the server. The documentation says that I
> need to use TCp/IP, but how?  If you have any idea,
> let me know. I guess I may have to look more into the
> documentation.
>
> Thanks.
>

Dear Swati/Rashi

I've installed MySQL on Windows2000, Window XP and Linux without problems.
According to the download page Windows 95/98 are supported and, therefore, I
conclude Windows Me should be supported too. Until now I worked with Version
3.23.

After you've installed the program in a directory, e.g. c:\programs\MySQL,
the setup program will install the application's documentation under
c:\programs\MySQL\Docs. The documentation is quit extensive. I found all the
information I needed.

Please tell me if you encounter problems with your MySLQ installation on
Windows Me.

Recently I fount a very good DB client which supports (among other things)
MySQL. Its name is Aquad Data Studio and you can download it under
http://www.aquafold.com/ .

Regards,
Benno


> -----Original Message-----
> From: ss ss [mailto:tru...@ya...]
> Sent: Samstag, 26. April 2003 19:37
> To: ben...@id...
> Subject: RE: Java developers with XSLT knowledge: Project VIF
>
>
> Hello Benno,
>
> How are you? I am trying to install MySql on my
> machine(Windows Me), Can you tell me whether it is
> supported on this OS. Also any documentation regarding
> this may be helpful.
>
> Thanks,
> Swati.
>
>

The tblPerson table is used to store biographic information, which could be
referenced in the discussion forum. The tblText table is used to store
bibliographic information that could be referenced. The application also
stores the author and reviewer responsible for the entries in tblPerson and
tblText. See the VIF datamodel for further information about table
specifications and the relations of these tables within the whole datamodel.

I'll describe here the needed steps for tblPerson. The case for tblText is
analogous.

a) Database: You have to create the table tblPerson according to the
specification in the datamodel. A script table_tblPerson has to be created
and the installation scripts CreateTables.bat and CreateTables.sh have to be
adjusted. The scripts table_tblPersonAuthorReviewer.sql and
table_tblTextAuthorReviewer.sql exists yet.

b) Model: Because the domain object PersonAuthorReviewer and its home exist
already, only the domain object for tblPerson has to be created. To do that,
you have to create the interfaces Person and PersonHome for the domain
object and its home. After creating the interfaces, the implementations
PersonImpl and PersonHomeImpl have to be created. The implementations of
existing domain objects can be taken as sample.

c) Controller: Create the tasks PersonListTask, PersonShowTask,
PersonNewTask, PersonEditTask and PersonSaveTask in the package
org.hip.vif.admin.tasks.impl. The first task lists all existing entries in
tblPerson, the second task shows a specified entry, the third task creates a
new entry, the fourth task is needed to edit an entry and the last task
saves changed data to the table.
Note: The newly created tasks have to be registered to TaskManagerImpl. You
can take the existing implementations of AdminQuestionListTask,
AdminQuestionShowTask etc. in the package org.hip.vif.admin.tasks.impl as
sample.

d) View: Create the views (Java classes and XSLT). The Java views prepare
the produced XML for that they can be transformed by the appropriate XSLT
files. Take existing views and stylesheets as sample.

Regards,
Benno

Hello

I've released Release 0.3.3 of the application VIF.

In this release the following changes are implemented:
- Added StructuredText package to framework.
- Added StructuredText formatting functionality to editing of questions.
- Refactoring: Deleted all unused imports.

Regards,
Benno