Home | Gallery | Forum | Services | Webmail | Archive | Links | Contact Us | About Us
OS2 World.Com Forum
OS2 World.Com Online Discussion Forum.
Index / OS/2 - General / Applications
author message
Looking for >useful< database
Post a new topic Reply to this Topic Printable Version of this Topic Forward this Topic to your Friend Topic Commands (for administrator or moderators only)
El Vato
Normal member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.metztli-it.com
posts: 113
since: 04 Oct, 2006
21. Re:Looking for >useful< database
Reply to this topic with quote Modify your message
last updated at 19 Dec, 2006 00:47 (1 times)

Jan-Erik (17 Dec, 2006 17:04):

Thank you for the suggestion, but as with the rest of them... no GUI admin tool a very large NoNo when I need to configure/modify/administrate it myself.



Well, there is actually a GUI front end in beta testing (that I know of), although it is not supported under OS/2 due to the fact that it is SWT based, please see: <
http://www-128.ibm.com/developerworks/db2/downloads/csworkbench/#Download >
Notwithstanding, due to the flexibility that CloudScape/Derby provides, I will suggest a couple of options. Quite possibly, even if you do not find either of them appealing, those might provide you with some insight.

You might run the SWT WorkBench front end on Linux (I will never consider WinXX for anything other than trivial stuff but you may have a different take). In this particular example, I executed the networks server on OS/2 but ran the beta SWT on Linux from within Linux:
http://www.chingonazo.com/csLinuxWorkBenchDBs.JPG

And in this other case, again the same scenario but I used the OpenSuSE VNC server application to make a connection wholly from within OS/2 using Seamonkey browser; by medium of the http protocol and through an open port on the Linux firewall this Jvm app presented:
http://www.chingonazo.com/csLinuxWorkBenchVNC.JPG

On the other hand, CloudScape/Derby were designed to be "administrator-free" which means that an user (like a developer, for example) does not have to worry much about managing the database.

Have you explored the embedded bin directory?

Probably if you were to become acquainted overall with CloudScape/Derby features by using the extensive examples and/or information at IBM and Apache.org, you would more conveniently customize the RDBM to your needs --yes, even if text based.

Moreover, for a comprehensive source, you might want to buy the manual referenced in my previous post.


Jan-Erik (17 Dec, 2006 17:04):
It may be very handy if it can be handled automatically with a rexx .cmd-file from the app-to-be later on though.

I'll try out the older DBVisualizer 4.0.4 to see if it can make up for that, otherwise I have to ask you for some more suggestions.

Mvh / MfG / Wkr
//Jan-Erik


If by now I have not confused you enough , let me know if I may obfuscate the issue some more...

Date: 19 Dec, 2006 on 00:20
Jan-Erik
Normal member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.xn--lrka-loa.com
posts: 27
since: 15 May, 2003
22. Re:Looking for >useful< database
Reply to this topic with quote Modify your message
The installer fro DBVisualizer 4.0.4 and the earlier version doesn't work properly and just halt suring installation.

So I'm back at square one.

Someone got another suggestion?!

Mvh / MfG / Wkr
//Jan-Erik

Date: 20 Dec, 2006 on 13:22
El Vato
Normal member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.metztli-it.com
posts: 113
since: 04 Oct, 2006
23. Re:Looking for >useful< database
Reply to this topic with quote Modify your message
last updated at 22 Dec, 2006 12:56 (4 times)

Jan-Erik (20 Dec, 2006 13:22):
The installer fro DBVisualizer 4.0.4 and the earlier version doesn't work properly and just halt suring installation.

So I'm back at square one.

Someone got another suggestion?!


Humm, assuming that you have installed the CloudScape/Derby application and have successfully tried some of the sample ksh scripts, here is an GUI for an admin that I had not remembered about.

Place the two *.jar files included in the compressed file in your CLASSPATH for CloudScape/Derby (perhaps at the end of your current CLASSPATH). And place the file myCloudView.cmd in your OS/2 PATH environment --say, /os2/-- so that you will be able to execute from anywhere in your file structure.

After you do so, you may start the GUI admin for IBM CloudScape and/or Apache Derby as follows:

myCloudView.cmd

You should see the following:

http://www.chingonazo.com/CloudView.JPG

Define Connection:
http://www.chingonazo.com/CloudView1.JPG

Properties (yes, it is executing under OS/2):
http://www.chingonazo.com/CloudView2.JPG

Please, note although I am making available those files with the intention of helping you solve your problem, those are provided to you "as is" --that is, they worked for me when I tested them but you download them at your own risk.

Best of luck ;

P.S. Please make sure to add the db2jcc.jar file to your CLASSPATH environment variable, otherwise only your embedded db driver will load.

You can test that it is loading by pressing the appropriate button for the purpose (note the default localhost and port 1527):
http://www.chingonazo.com/CloudView3.JPG

To create (or import) your db simply select from the menu label "file":
http://www.chingonazo.com/CloudView4.JPG

Now you are in full control of CloudScape/Derby with your GUI admin front end.

Date: 20 Dec, 2006 on 15:19
El Vato
Normal member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.metztli-it.com
posts: 113
since: 04 Oct, 2006
24. Re:Looking for >useful< database
Reply to this topic with quote Modify your message
last updated at 28 Dec, 2006 04:44 (5 times)

Jan-Erik (20 Dec, 2006 13:22):
The installer fro DBVisualizer 4.0.4 and the earlier version doesn't work properly and just halt suring installation.

...it is because you are using the WinXX installer --a NoNo if an OS/2er can avoid it. As an example, I was playing a little with the 4.3.6 version DbVisualizer. I downloaded first the generic Unix *gz version and subsequently the WinXX *zip one.

If possible download the dbvis_unix_4_3_6.tar.gz or dbvis_unix_5_0.tar.gz since OS/2ers can use the EMX runtime with the tar and gzip utilities to extract like:

tar -xvpzPf dbvis_unix_4_3_6..tar.gz

Notwithstanding, if you download the WinXX version, I believe the following will also apply. I tried the WinXX file BUT after I had worked with the generic Unix version.

I referenced the long command for Unix/Linux masochists (see the section: 3.2 How do I launch DbVisualizer manually? at < http://www.dbvis.com/products/dbvis/faq.html >)

But I placed all those statements in a file ( myDbVisualizer.cmd ) that I subsequently placed under my OS2 directory --to be accessible from anywhere in my directory structure, see(modified to eliminate the break after the last SET statement in the html presentation):

http://www.chingonazo.com/myDbVisualizer.cmd.html

(In other words, the assignment(s) by the keyword SET is(are) to be ALL in a single line with no newline breaks)

Now simply entering at a command prompt:

myDbVisualizer.cmd

this Java JVM pops up:
http://www.chingonazo.com/dbVis-4_3_6.JPG

The CMD file can be modified to work with the Version of DbVisualizer 5.0. by modifying the DBVIS_HOME environment variable to point to the pertinent directory and adding to the CLASSPATH the extra JAR file: $DBVIS_HOME/lib/dbvisext.jar
that exists only in the version 5.0.

One issue that I noticed is that moving/resizing of DbVisualizer is constrained (at least in my system).

The way around that issue is to manipulate directly the configuration file dbvis.xml file located in the directory pointed by the HOME environment variable see the comments in the file http://www.chingonazo.com/myDbVisualizer.cmd.html
consequently, make sure to set that important variable (WinXX relieves the user from these tasks but we do it the Penguin's way).

Hence you will find a line in your dbvis.xml file of the form: <MainFrameGeometry>1|200|750|600|170|200</MainFrameGeometry>

where the two inner numbers represent the size of the rectangular Java application (I modified the first three numbers separated by bars, above)

In my case I specified the number 1 that makes the app rectangle be close to the edge of my left screen area;

the number 200 makes the app rectangle decrease its height position relative to the screen area, see:
http://www.chingonazo.com/dbVisBottom-4_3_6.JPG

(compare to the value in the first JPG above).

To finalize, if the CloudScape/Derby admin GUI does not fulfill your needs, try experimenting again with DbVisualizer as recommende by Terry: COOL APP, apparently?

Cheers!

Date: 20 Dec, 2006 on 22:12
Jan-Erik
Normal member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.xn--lrka-loa.com
posts: 27
since: 15 May, 2003
25. Re:Looking for >useful< database
Reply to this topic with quote Modify your message


Humm, assuming that you have installed the CloudScape/Derby application and have successfully tried some of the sample ksh scripts, here is an GUI for an admin that I had not remembered about.


on a) Yes, derby server seems to work, and the client command-line "ij"-thingie too.
on b) no "ksh"
on c) was a part of CloudScape/Derby 5?!, you forgot anyhow to include something... so I have nothing to try out.


..it is because you are using the WinXX installer --a NoNo if an OS/2er can avoid it.

Nope, I used the Generic Java installer, how can they create platform specific installers when they're using a platform neutral java solution?!!!


I referenced the long command for Unix/Linux masochists (see the section: 3.2 How do I launch DbVisualizer manually? at < http://www.dbvis.com/products/dbvis/faq.html >)

Yes, Thank you. I modified it to be more suitable for OS/2-eCS by making it rexx aware and resolv paths by itself.

I had problems that it complained that it wasn't installed in the default directory and therefore couldn't load something dynamically when it was supposed to connect to the Derby server...
but I managed to silence it with additional parameters compared to the ones suggested.

The problem I've got now is that it (dbvis) just doesn't like the syntax itself produce to connect to the server.

Date: 12 Jan, 2007 on 20:24 Attachment: JDBCERR001.JPG
El Vato
Normal member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.metztli-it.com
posts: 113
since: 04 Oct, 2006
26. Re:Looking for >useful< database
Reply to this topic with quote Modify your message
last updated at 13 Jan, 2007 07:30 (1 times)

Jan-Erik (12 Jan, 2007 20:24):


Humm, assuming that you have installed the CloudScape/Derby application and have successfully tried some of the sample ksh scripts, here is an GUI for an admin that I had not remembered about.


on a) Yes, derby server seems to work, and the client command-line "ij"-thingie too.
on b) no "ksh"


Please, explain. The post where I suggested how to set it up used the scripts for the public domain Korn Shell (ksh). How are you starting the network server and the ij client, then


Jan-Erik (12 Jan, 2007 20:24):
on c) was a part of CloudScape/Derby 5?!, you forgot anyhow to include something... so I have nothing to try out.


You mean CloudScape/Derby 10.1? That is the version that up to now we have had under discussion. Quite possible you are confusing the database version with that of DBVisualizer.

(appropos what version of DBVisualizer are you using???)

Notwitstanding, and assuming that you are sincere in your question/request and not simply heeding the advice of third parties with other motives, I have sent you another (yes, this is the second one) email
with instructions. Please reread with care the prior and pertinent post afterwards.


Jan-Erik (12 Jan, 2007 20:24):

..it is because you are using the WinXX installer --a NoNo if an OS/2er can avoid it.

Nope, I used the Generic Java installer, how can they create platform specific installers when they're using a platform neutral java solution?!!!


Because WinXX users enjoy chasing icons with with their mice/pointer/etc. Many software business organizations offer executables to relieve the WinXX user from learning to type a simple command with arguments at the prompt line. And there the argument that MS simply has stiffled innovation by removing the creative thinking ability of their users .

Consequently, the zipped version of DBVisualizer provides executables that, among other things, set the CLASSPATH and HOME environment variable for the user (and refuse to work even with the Odin under OS/2).


Jan-Erik (12 Jan, 2007 20:24):

I referenced the long command for Unix/Linux masochists (see the section: 3.2 How do I launch DbVisualizer manually? at < http://www.dbvis.com/products/dbvis/faq.html >)

Yes, Thank you. I modified it to be more suitable for OS/2-eCS by making it rexx aware and resolv paths by itself.

I had problems that it complained that it wasn't installed in the default directory and therefore couldn't load something dynamically when it was supposed to connect to the Derby server...
but I managed to silence it with additional parameters compared to the ones suggested.

The problem I've got now is that it (dbvis) just doesn't like the syntax itself produce to connect to the server.


If you followed the instructions in the DBVisualizer pertinent post, you might make sure about the existence of a HOME environment directory. What is the exact name of the DBVisualizer that you downloaded?

Note that HOME environment is an important variable and will cause problems if not set as suggested in the pertinent post --please reread carefully. The WinXX version executable relieves the user from all those details BUT nonetheless sets a HOME environment variable.

Another thing, using the Unix/Linux equivalent of the DBVisualizer (or as a matter of fact, most any other Unix/Linux program that we use under OS/2) presuposes the existence of the EMX runtime environment --at least for the OS/2 session from where we start the DBVisualizer front end-- because internally those programs may be using front slashes "/" rather than OS/2's default "\".

Appropos, did you start your CloudScape/Derby network server BEFORE attempting to connect and create/manipulate/import/etc. data with the DBVisualizer front end
That is a commonly overlooked issue.

Perhaps Terry, having browsed through some of the DbVisualizer posts at that site, might have observed a related issue by some users of the front end.

Best regards !

Date: 13 Jan, 2007 on 07:25
Jan-Erik
Normal member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.xn--lrka-loa.com
posts: 27
since: 15 May, 2003
27. Re:Looking for >useful< database
Reply to this topic with quote Modify your message
last updated at 14 Jan, 2007 00:31 (3 times)


Please, explain. The post where I suggested how to set it up used the scripts for the public domain Korn Shell (ksh). How are you starting the network server and the ij client, then

Please see the attached image of the "server"...

Then nothing... as there's just the command line


You mean CloudScape/Derby 10.1? That is the version that up to now we have had under discussion. Quite possible you are confusing the database version with that of DBVisualizer.

(appropos what version of DBVisualizer are you using???)

Notwitstanding, and assuming that you are sincere in your question/request and not simply heeding the advice of third parties with other motives, I have sent you another (yes, this is the second one) email
with instructions. Please reread with care the prior and pertinent post afterwards.


DBVisulizer 4.3.6 (dbvis_unix_4_3_6.tar.GZ) that I unpacked with Archiver

I went back and looked for info where to get something GUI admin like CloudView and saw that it was included in CloudScape/Derby 5 but left out of the package 10.x
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0408anderson2/#table1

Ohh, ok you sent me a mail before, must have been filtered, I'll look to see if I can recover it....gone, could you please resend it.


f you followed the instructions in the DBVisualizer pertinent post, you might make sure about the existence of a HOME environment directory. What is the exact name of the DBVisualizer that you downloaded?

Note that HOME environment is an important variable and will cause problems if not set as suggested in the pertinent post --please reread carefully. The WinXX version executable relieves the user from all those details BUT nonetheless sets a HOME environment variable.

Another thing, using the Unix/Linux equivalent of the DBVisualizer (or as a matter of fact, most any other Unix/Linux program that we use under OS/2) presuposes the existence of the EMX runtime environment --at least for the OS/2 session from where we start the DBVisualizer front end-- because internally those programs may be using front slashes "/" rather than OS/2's default "\".



Yes, I've read all your posts I could find regarding this topic, downloaded the images and files and reread the posts to verify correctness and they are, and therefore work (up to a certain point).

A very good thing with eCS is that it set the Home and Programs folder during install of the system, where dbvis created its settings just as you mentioned

I use this code to run DatabaseVisualizer
===DBVIS.CMD===
/* Start DBVis */
parse source . . this
this = filespec( 'D', this )||strip( filespec( 'P', this ),'T', '\' )
'@SET DBVIS_HOME='||this
'@SET CLASSPATH=%DBVIS_HOME%\resources;%DBVIS_HOME%\lib\alloy.jar;%DBVIS_HOME%\lib\commons-lang.jar;%DBVIS_HOME%\lib\crimson.jar;'
'@SET CLASSPATH=%CLASSPATH%;%DBVIS_HOME%\lib\dbvis.jar;%DBVIS_HOME%\lib\forms.jar;%DBVIS_HOME%\lib\ideit-util.jar;%DBVIS_HOME%\lib\jcchart.jar;'
'@SET CLASSPATH=%CLASSPATH%;%DBVIS_HOME%\lib\jdom.jar;%DBVIS_HOME%\lib\log4j.jar;%DBVIS_HOME%\lib\nb-editor.jar;%DBVIS_HOME%\lib\ognl.jar;'
'@SET CLASSPATH=%CLASSPATH%;%DBVIS_HOME%\lib\openide-util.jar;%DBVIS_HOME%\lib\poi.jar;%DBVIS_HOME%\lib\yFiles.jar;%DBVIS_HOME%/lib/jdom-b9.jar;'
'@echo Starting DB Visualizer, Please wait...Here we go, Metztli !!!'
'@K:\NetWork\java141\bin\java -Xmx256m -Ddbvis.wrapperdir='||translate(this, '/', '\')||'/wrapper/classes -Ddbvis.prefsdir=C:/Home/Default com.onseven.dbvis.DbVisualizer'
===============


Appropos, did you start your CloudScape/Derby network server BEFORE attempting to connect and create/manipulate/import/etc. data with the DBVisualizer front end
That is a commonly overlooked issue.

I ensured that it was started far it in advance before I tried DBVisualizer 4.3.6
The param -Ddbvis.wrapperdir fixed the problem to dynamically load and keep the imported Derby class (db2jcc.jar) in memory during connection operation.

Something is wrong though anyway and I can't figure it out.


======

I was so saddened by the problem that I bought a new harddrive, installed it and downloaded and installed AMPOS2/AMPECS on this computer, I managed to configure it and began add the tables in PHPMyAdmin. I don't know what I have to do to link the tables together, but now I guess I will manage table relations myself in rexx code to get past all this. :-/

Thank you for all your help...

mvh / Wkr / MfG
//Jan-Erik
Running eCS 2.0 Beta 3

Date: 14 Jan, 2007 on 00:09 Attachment: Derby.gif
El Vato
Premium member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.metztli-it.com
posts: 113
since: 04 Oct, 2006
28. Re:Looking for >useful< database
Reply to this topic with quote Modify your message

Jan-Erik (14 Jan, 2007 00:31):


Please, explain. The post where I suggested how to set it up used the scripts for the public domain Korn Shell (ksh). How are you starting the network server and the ij client, then

Ohh, ok you sent me a mail before, must have been filtered, I'll look to see if I can recover it....gone, could you please resend it.


...mail has been sent again (third time just now) --you must have a really bad misconigured email filtering system.


Jan-Erik (14 Jan, 2007 00:31):

f you followed the instructions in the DBVisualizer pertinent post, you might make sure about the existence of a HOME environment directory. What is the exact name of the DBVisualizer that you downloaded?

Note that HOME environment is an important variable and will cause problems if not set as suggested in the pertinent post --please reread carefully. The WinXX version executable relieves the user from all those details BUT nonetheless sets a HOME environment variable.

Another thing, using the Unix/Linux equivalent of the DBVisualizer (or as a matter of fact, most any other Unix/Linux program that we use under OS/2) presuposes the existence of the EMX runtime environment --at least for the OS/2 session from where we start the DBVisualizer front end-- because internally those programs may be using front slashes "/" rather than OS/2's default "\".



Yes, I've read all your posts I could find regarding this topic, downloaded the images and files and reread the posts to verify correctness and they are, and therefore work (up to a certain point).

A very good thing with eCS is that it set the Home and Programs folder during install of the system, where dbvis created its settings just as you mentioned

I use this code to run DatabaseVisualizer
===DBVIS.CMD===
/* Start DBVis */
parse source . . this
this = filespec( 'D', this )||strip( filespec( 'P', this ),'T', '\' )
'@SET DBVIS_HOME='||this
'@SET CLASSPATH=%DBVIS_HOME%\resources;%DBVIS_HOME%\lib\alloy.jar;%DBVIS_HOME%\lib\commons-lang.jar;%DBVIS_HOME%\lib\crimson.jar;'
'@SET CLASSPATH=%CLASSPATH%;%DBVIS_HOME%\lib\dbvis.jar;%DBVIS_HOME%\lib\forms.jar;%DBVIS_HOME%\lib\ideit-util.jar;%DBVIS_HOME%\lib\jcchart.jar;'
'@SET CLASSPATH=%CLASSPATH%;%DBVIS_HOME%\lib\jdom.jar;%DBVIS_HOME%\lib\log4j.jar;%DBVIS_HOME%\lib\nb-editor.jar;%DBVIS_HOME%\lib\ognl.jar;'
'@SET CLASSPATH=%CLASSPATH%;%DBVIS_HOME%\lib\openide-util.jar;%DBVIS_HOME%\lib\poi.jar;%DBVIS_HOME%\lib\yFiles.jar;%DBVIS_HOME%/lib/jdom-b9.jar;'
'@echo Starting DB Visualizer, Please wait...Here we go, Metztli !!!'
'@K:\NetWork\java141\bin\java -Xmx256m -Ddbvis.wrapperdir='||translate(this, '/', '\')||'/wrapper/classes -Ddbvis.prefsdir=C:/Home/Default com.onseven.dbvis.DbVisualizer'
===============


I am not versed in REXX. I do most of my work from the Linux shell scripts to roughly equivalents under the OS/2 CMD. Most of the issues arising out of Java programs are due to a CLASSPATH misconfiguration.

If those REXX scripts that you concocted miss one slight detail ( a colon ':' or a space instead of a semicolon ";") --you are the slave of Java for an undetermined length of time.


Jan-Erik (14 Jan, 2007 00:31):

Appropos, did you start your CloudScape/Derby network server BEFORE attempting to connect and create/manipulate/import/etc. data with the DBVisualizer front end
That is a commonly overlooked issue.

I ensured that it was started far it in advance before I tried DBVisualizer 4.3.6
The param -Ddbvis.wrapperdir fixed the problem to dynamically load and keep the imported Derby class (db2jcc.jar) in memory during connection operation.

Something is wrong though anyway and I can't figure it out.


======

I was so saddened by the problem that I bought a new harddrive, installed it and downloaded and installed AMPOS2/AMPECS on this computer, I managed to configure it and began add the tables in PHPMyAdmin. I don't know what I have to do to link the tables together, but now I guess I will manage table relations myself in rexx code to get past all this. :-/

Thank you for all your help...


Hope your filter will allow this third email pass through...

Cheers !

Date: 14 Jan, 2007 on 01:18
magog
Normal member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.jmdb.de/
posts: 37
since: 23 Jun, 2002
29. Re:Looking for >useful< database
Reply to this topic with quote Modify your message
If you are looking for a frontend you can also use Squirrel SQL (Java) for most databases:
http://sourceforge.net/projects/squirrel-sql/

I'm not sure if the latest release from end of last month does still work with Java 1.4.

---
Regards,
Juergen Ulbts (Germany)

*** Java Movie Database - http://www.jmdb.de/ ***
*** New version available (2006-11-17) ***
*** Website has been updated ***

Date: 16 Jan, 2007 on 01:51
Jan-Erik
Normal member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.xn--lrka-loa.com
posts: 27
since: 15 May, 2003
30. Re:Looking for >useful< database
Reply to this topic with quote Modify your message
CloudView
I've now tried CloudView with the following observations.

1. I had to include the license file for db2jcc.jar as well in the classpath statement to be able actually connect to the derby server.

2. The Derby server responded and accepted the connection attempt with:
Connection number: 1.
Connection number: 2.
Connection number: 3.
etc.

3. CloudView can't display tables in the sample or tourdb databases.

4. CloudView seem to produce code that doesn't work with version 10.x of Derby:
Database access resulted in SQL exception:
SQLState , Error code -1, Message:
DB2 SQL error: SQLCODE: -1, SQLSTATE: 42X01, SQLERRMC: PROPERTIES42X01
and it's therefore not possible to create tables either.

5. Properties code can't be edited by hand in SQL view as it seem to me.

Thank you for all your suggestions and tips... I'm trying them out when time permit.

=====
Squirrel SQL
squirrel-sql-2.4-install.JAR only work with java 1.5
=====
MySQL
MySQL tools can be made to run under eCS if you copy the right .dlls (why do they require/load opengl32?!!!) but doesn't connect or do anything useful at the moment.
=====
JDBStudio
Ehh, have to get back to you on that one
=====
Fredys
Admin.jar doesn't seem to like Java 1.4.1, may work with java 1.4.2?
=====
iSQL-Viewer
Ehh, how can one enable drivers and connect it to something?
=====


I'll try some more to see if the MySQL path is possible...

mvh / Wkr / MfG
//Jan-Erik

Date: 16 Jan, 2007 on 22:39
El Vato
Premium member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.metztli-it.com
posts: 113
since: 04 Oct, 2006
31. Re:Looking for >useful< database
Reply to this topic with quote Modify your message
last updated at 17 Jan, 2007 16:01 (2 times)

Jan-Erik (12 Jan, 2007 20:24):


Humm, assuming that you have installed the CloudScape/Derby application and have successfully tried some of the sample ksh scripts, here is an GUI for an admin that I had not remembered about.


on a) Yes, derby server seems to work, and the client command-line "ij"-thingie too.
on b) no "ksh"
on c) was a part of CloudScape/Derby 5?!, you forgot anyhow to include something... so I have nothing to try out.


..it is because you are using the WinXX installer --a NoNo if an OS/2er can avoid it.

Nope, I used the Generic Java installer, how can they create platform specific installers when they're using a platform neutral java solution?!!!


I referenced the long command for Unix/Linux masochists (see the section: 3.2 How do I launch DbVisualizer manually? at < http://www.dbvis.com/products/dbvis/faq.html >)

Yes, Thank you. I modified it to be more suitable for OS/2-eCS by making it rexx aware and resolv paths by itself.

I had problems that it complained that it wasn't installed in the default directory and therefore couldn't load something dynamically when it was supposed to connect to the Derby server...


That problem can be resolved by editing the fle myDbVisualizer.cmd
Please note the changes in the newly edited file. The last line contains modifications to make the DBVIS_HOME resolve to the OS/2 and NOT the Unix environment.


Jan-Erik (12 Jan, 2007 20:24):
but I managed to silence it with additional parameters compared to the ones suggested.

You do not have to add any additional parameters to the file referenced above. Consequently, BEFORE you get fancy with your REXX stuff, please try the file referenced above first.

Here is the OS/2 script that I used to start the network server:
myStartCloudNetwork.cmd

And here is the OS/2 script to start the IJ tool:
myStartIJ.cmd


Jan-Erik (12 Jan, 2007 20:24):
The problem I've got now is that it (dbvis) just doesn't like the syntax itself produce to connect to the server.

You are experiencing that problem because the developers of DbVisualizer probably made a mistake in the way that their product attempts to connect to the IBM CloudScape/Apache Derby database ...really! Their default connect expression on DbVisualizer 4.3.6 and 5.0 field is wrong!

Assuming that you have your CloudScape/Derby network server on localhost port 1599 and you want to connect to a non existing database, the default connection on DbVisualizer (4.3.6 and 5.0) is:

jdbc:derby:net://localhost:1599localhost

THAT IS WRONG and CloudScape/Derby will complain about the syntax in BOTH versions of DbVisualizer. CloudScape/Derby network server will not accept the connection due to the unecessary expressions: net: and the localhost following the port number.

On the other hand, if you modify the connect expression to:

jdbc:derby://localhost:1599

then you will connect briefly but you will be bounced back because there is no existing database to connect to. Here is where you use the "ij thingie" --as you called it-- to make an initial database called OS2WORLD (observe the lower left screen area):

connect 'OS2WORLD;create=true';

proceed to connect (as I did in the illustration above) with to the database in your DbVisualizer as:

jdbc:derby://localhost:1599/OS2WORLD

and you are connected!

Hence earlier, with the IJ tool I also created another exmaple database named MARIA which I subsequently connected to with DbVisualizer 4.3.6.

Consequently, your named databases will be created in the root directory of localhost in these examples (see the upper screen window) and will maintain a lock so as not to be rewritten if another attempt at creation is made. Note however that you can connect multiple times to a database since the Derby network server will manage the connecions appropriately.

The references on CloudScape/Derby will reveal more on the subject. As an example, the link below shows the appropriat way to connect to the CloudScape/Derby network server:

http://db.apache.org/derby/docs/10.1/getstart/rgsquck30197.html

One interesting feature of the IBM CloudScape/Apache Derby RDBMs is that the storage created by those is architecture agnostic. As long a you move the complete hierarchy, the databases can be moved, for instance, from Little-endian to Big-endian architectures with no issues. Needless to say, the moving of databases among OS/2, WinXX, Macs, and Linux will be no issue at all.

Hope your problems will be over with this information !

P.S. Assuming (another) OS/2 CloudScape/Derby Network server script with ONLY the DERBY_INSTALL and CLASSPATH OS/2 environment set --that is, with nothing else specified, you can gracefully shutdown your nerwork server running in localhost port 1599 with the command:
javaorg.apache.derby.drda.NetworkServerControlshutdown-hlocalhost -p1599

As referenced in the verbose output of:
java org.apache.derby.drda.NetworkServerControl

Doing so will void connection failures that sometimes occur when the CloudScape/Derby network server process is abruptly killed.

Date: 17 Jan, 2007 on 14:36
Jan-Erik
Normal member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.xn--lrka-loa.com
posts: 27
since: 15 May, 2003
32. Re:Looking for >useful< database
Reply to this topic with quote Modify your message
Thank you El Vato!!!

It all works up to the point you've described it, now I can do it with both Derby and MySQL.

But it's very unclear that one shouldn't use the jdbc drivers as described earlier (db2cc.jar), one has to use the "client" jar-file that is obviously not the same thing.

I can now get to the point that you describe, but there's no way to add schemas nor tables, not even to see that the default ones contain anything... can you please suggest something?

Can't edit the MySQL tables, nor link them togheter in DBVis as there's no function for that (e.g. right-click on table or tree view), but it does connect nicely and show the ones I created with PHPAdmin the other day.

mvh / Wkr / MfG
//Jan-Erik
Software tester of ERP System for manufacturing companies.


Q: Why can't developers create intuitive software so we can get on with our work?
A: It would be to easy to use and so many more would try it, that's why.

Date: 17 Jan, 2007 on 22:14
El Vato
Premium member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.metztli-it.com
posts: 113
since: 04 Oct, 2006
33. Re:Looking for >useful< database
Reply to this topic with quote Modify your message

Jan-Erik (17 Jan, 2007 22:14):
Thank you El Vato!!!

It all works up to the point you've described it, now I can do it with both Derby and MySQL.

But it's very unclear that one shouldn't use the jdbc drivers as described earlier (db2cc.jar), one has to use the "client" jar-file that is obviously not the same thing.


db2jcc.jar and db2jcc_license_c.jar are IBM's Universal Database driver licensed to be used on both IBM CloudScape and Apache Derby RDBMs.

Notwithstanding, derbyclient.jar is the open source implementation of the previous proprietary driver that also supports the Distributed Relational Database Architecture (DRDA) standard for client/server comm.

You might connect to Cloudscape/Derby databases even if either of the proprietary or the open source driver were removed from the path. If you were to remove the open source driver ( derbyclient.jar ), for instance, and used the proprietary set, then to connect to a SAMPLE named database on port 1599 of localhost, you would type:

jdbc:derby:net://localhost:1599/SAMPLE

Compare that to the previous post where we were making the connection to CloudScape/Derby without the net: because we were using the open source driver: derbyclient.jar


Jan-Erik (17 Jan, 2007 22:14):
I can now get to the point that you describe, but there's no way to add schemas nor tables, not even to see that the default ones contain anything... can you please suggest something?

Can't edit the MySQL tables, nor link them togheter in DBVis as there's no function for that (e.g. right-click on table or tree view), but it does connect nicely and show the ones I created with PHPAdmin the other day.


Whereas CloudScape, donated to the Apache Foundation by IBM and known in the open source world as Derby are released with no strings attached --as long as the respective licenses are observed-- DbVisualizer is not.

...you need to aquire a (personal) license if you want to manipulate your storage units. See < http://www.minq.se/products/dbvis/info.html >

I would review Java version requirements at the bottom and ask if the license will cover from 4.3.6 and upper DbVisualizer versions.


Jan-Erik (17 Jan, 2007 22:14):
mvh / Wkr / MfG
//Jan-Erik
Software tester of ERP System for manufacturing companies.

Q: Why can't developers create intuitive software so we can get on with our work?
A: It would be to easy to use and so many more would try it, that's why.


Best regards !!!

Date: 18 Jan, 2007 on 18:44
Jan-Erik
Normal member
in user

View this member's profileSearch all posts from this memberSend an email to this memberhttp://www.xn--lrka-loa.com
posts: 27
since: 15 May, 2003
34. Re:Looking for >useful< database
Reply to this topic with quote Modify your message
OK, are there any other tools out there that does the job?


mvh / MfG / Wkr
//Jan-Erik

Date: 18 Jan, 2007 on 20:43
Looking for >useful< database
Post a new topic Reply to this Topic Printable Version of this Topic Forward this Topic to your Friend Topic Commands (for administrator or moderators only)
All times are CET+1. < Prev. | P. 1 2 | Next >
Go to:
 

Powered by UltraBoard 2000 Standard Edition,
Copyright © UltraScripts.com, Inc. 1999-2000.
Home | Gallery | Forums | Services | Webmail | Archive | Links | Contact Us | About Us
OS2 World.Com 2000-2004