AW: Database configuration - DB2/400

"Vidakovic Aleksandar" <[email protected]> Thu, 1 Jul 2004 14:36:17 +0200
Newsgroups gmane.comp.java.keel.user
Message-ID <[email protected]>
Salut Maurizio,

the explanation is on the way... only have to adjust it a bit, because I build my project with maven and not with the standard keel build process.

Half of it is done... so I send you already what I have:

1. go to the keel-build directory and type "ant" and follow the instructions to create a new project(I'll reference this as "yourproject"). I guess you have already done this...

2. chose one of the sample settings from keel-build/example-projects (e. g. "default") and copy the files to your project directory (keel-build/yourproject)

3. edit the ant.properties file to fit your database environment. 

3.1. in the middle of the properties file you find a section which looks like this

[snip]

#which of the implementations of persistence will we use?
service.persist.base=true
service.persist.default=true
#service.persist.hibernate=true

[/snip]

Now you have to comment out the line "service.persist.default" and enable the line "service.persist.hibernate" which would look then like this:


[snip]

#which of the implementations of persistence will we use?
service.persist.base=true
#service.persist.default=true
service.persist.hibernate=true

[/snip]

NOTE: it is imperativ to select only one persistent service!

3.2. Go to end of the file and fill this properties:

[snip]

# below properties only needed if a database persistence mechanism is being used
#Database type (Choices: hsqldb, mysql, oracle, postgresql, sqlserver, informix)
#If these properties are set, the build system will include the proper
#configuration for the database components to connect to this database.
database.type=hsqldb
#Database server name or IP address (example: 127.0.0.1)
database.servername=
#Database server port (required for oracle, others may leave blank) (example: 1521)
database.dbport=
#Database name (example: keel)
database.dbname=keel
#Database User Login Name (example: scott)
database.username=sa
#Database User Login Password (example: tiger)
database.password=
#Database Name 2 (used for INFORMIXSERVER, others may leave blank)
database.servername2=

[/snip]

NOTE: do not worry about the database system right now. We'll come back to that later as you need a db2 configuration. The problem is that db2 is not 

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

break: from here on I have to look up some details... but maybe this helps already ;-) 

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

4. build your application by running "ant [EXPLAIN ...]

5. deploy your application [EXPLAIN ...]

6. run "createdb" model to initialize your [EXPLAIN ...]

7. create your own entities [EXPLAIN ...]

8. create a example model which uses the persistent service [EXPLAIN ...]




to be continued.... ;-)

Cheers,

Aleks

-----Ursprüngliche Nachricht-----
Von: Maurizio Brilli [mailto:[email protected]]
Gesendet: Donnerstag, 1. Juli 2004 12:19
An: user-6VIttnCrOeJXNEnpj1eHPNi2O/[email protected]
Betreff: Re: [Keel User] Database configuration - DB2/400


Aleks,

Thanks  for the overview, but I'm new to the environment, and I'm afraid 
this is not  enough to me...
I promise you that, if you help me get through the setup, I'll help you 
publish the information on the wiki. :o)

Now, as you already caught, I'm interested in the hibernate 
implementation, mostly because they say they already arranged a DB2400 
dialect, which is supposed to save me the mapping and testing job (and 
much more, hopefully...).

Second requirement: I'd like to implement the whole persistence 
(including authentication/authorization) in this database, so first I 
test the standard setup, then I start working on the custom application.

Look forward to hearing from you
Ciao
Maurizio
_______________________________________________
User mailing list
[email protected]
http://lists.keelframework.org/listinfo.cgi/user-keelframework.org