From: Digest To: "OS/2GenAu Digest" Date: Tue, 2 Dec 2008 00:01:20 AET-10EDT,10,1,0,7200,4,1,0,7200,3600 Subject: [os2genau_digest] No. 1750 Reply-To: X-List-Unsubscribe: www.os2site.com/list/ ************************************************** Monday 01 December 2008 Number 1750 ************************************************** Subjects for today 1 Re: Accessing Access(Jet) Databases : Nicholas Lysaght" 2 Re: Java programming : Simon Coulter 3 Re: Accessing Access(Jet) Databases : John Angelico" 4 Re: Java programming : Voytek Eymont" 5 Re: Java programming : Voytek Eymont" 6 Re: Java programming : Dennis Nolan 7 Re: Accessing Access(Jet) Databases : Ed Durrant 8 Re: Accessing Access(Jet) Databases : Ed Durrant 9 Re: Java programming : Dennis Nolan 10 Re: Accessing Access(Jet) Databases : John Angelico" 11 Re: Accessing Access(Jet) Databases : John Angelico" **= Email 1 ==========================** Date: Sun, 30 Nov 2008 23:43:01 +0900 From: "Nicholas Lysaght" Subject: Re: Accessing Access(Jet) Databases Hi John. Hope I'm not sticking my neck out here, but... 2008/11/30 John Angelico > Hi all. > > I have been given a CD of potentially useful stuff, but inevitably it > seems, it's a Win-only thing. Now there's a challenge :-) > > > I nearly gave up on the spot, but noticed a reference to mdb (ie. Microsoft > Database = Access) files. > > The stuff I want is in the .mdb files. The (not pretty, not ugly maybe > pretty ugly) stuff like VB scripts and ocx button controls I can do > without. If you know someone who runs MS Access that can successfully load your *.mdb files, then Export your selection(s) as either plain text or comma delimited files. I thinkl MS Access will let you do that. Transfer those files onto eCs, and DBExpert, or most database programs will import that data to a table of a database that you create. > > If I could run an install on a Win box, I wonder if I could zip up the > unpacked collection, and move it over to eCS? But that would only be > worthwhile IF I had a way of reading mdb files. > > I have OOo 2.4 but the Base component locks up my desktop. I have tried to > find stuff in the Help to explain if it can read MS-Access files natively, > but it certainly isn't explained in words of one syllable, so I am still > not sure. Hope that helps. Regards NICK > > > > > > Best regards > John Angelico > OS/2 SIG > os2 at melbpc dot org dot au or > talldad at kepl dot com dot au > ___________________ > > > [attachments have been removed] ---------------------------------------------------------------------------------- **= Email 2 ==========================** Date: Mon, 1 Dec 2008 07:30:37 +1100 From: Simon Coulter Subject: Re: Java programming On 30/11/2008, at 10:53 PM, Peter Moylan wrote: > Now, Java is supposed to be a modern programming language. For that > reason, I refuse to believe that it uses environment variables. > Whoever ported it to OS/2 has screwed up. Nope, that's how Java works on all platforms. Almost every new developer screws up the CLASSPATH so they get a successful compile but it fails to run--then they wonder why. Of course this only happens on trivial programs--anything serious will need access to othe class libraries and if these are not in the classpath then the compile will fail too. Somehow that easier to understand than compile OK but run fails. Seems odd to me since most Java programmers are C programmers and it's quite possible to have a successful C compile fail to run. Yes, that means the CLASSPATH can/will contain directories or jar/zip files that belong to unrelated applications. Yes, it's stupid but that's how it works. Think it's bad design? Take it up with SUN. You can override the CLASSPATH environment variable by specifying the - classpath switch on the java command. This can give the level of isolation you desire. You have to keep track of which version of Java you are developing for (or which is required by your applications) and ensure your environment is set up correctly. Sorry I cannot give you specific answers to your other questions. I no longer use OS/2 as my desktop and have moved to MacOS X (although Warp Server is still providing my mail server and a few other things). I still have an interest in OS/2 and when I have more free- time I want to investigate eCS hence my lurking on this list. I did boot my old ThinkPad with Warp 4 and Java 1.1.8 and Java 1.3 installed. I note that LIBPATH, PATH, DPATH and various other config.sys directives are set correctly by the 1.3 installer. It's been years since I did anything with Java on OS/2 but this system currently indicates that Java 1.3 is used for development but Java 1.1 is used as the default run-time. I presume that's the default set up and that I would override to Java 1.3 when running 1.3 code. CLASSPATH, SWING_HOME, and JAVA_HOME are not touched by the installer which is as I would expect because those are "user" settings that will affect how an application runs. Changing them could break existing applications. Regards, Simon Coulter. -------------------------------------------------------------------- FlyByNight Software OS/400, i5/OS Technical Specialists http://www.flybynight dot com dot au/ Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\ Fax: +61 2 6657 8251 \ / X ASCII Ribbon campaign against HTML E-Mail / \ -------------------------------------------------------------------- ---------------------------------------------------------------------------------- **= Email 3 ==========================** Date: Mon, 01 Dec 2008 07:47:26 +1000 (AEST) From: "John Angelico" Subject: Re: Accessing Access(Jet) Databases On Sun, 30 Nov 2008 23:43:01 +0900, Nicholas Lysaght wrote: Hi Nick I must be a restless old curmudgeon - challenge is right. I want to unlock stuff from the clutches of Windows... :-) > >> The stuff I want is in the .mdb files. The (not pretty, not ugly maybe >> pretty ugly) stuff like VB scripts and ocx button controls I can do >> without. > > >If you know someone who runs MS Access that can successfully load your *.mdb >files, then Export your selection(s) as either plain text or comma delimited >files. I thinkl MS Access will let you do that. Transfer those files onto >eCs, and DBExpert, or most database programs will import that data to a >table of a database that you create. The data is a "Searchable Bible in Contemporary English Version" consisting of a mix of text blocks and graphics files, so some of that challenge will be exploring the structure. Yes, dBExpert and/or DB2 are available here. I will try on the work WinXP box and see what I can bring home. Thanks for the tip! Best regards John Angelico OS/2 SIG os2 at melbpc dot org dot au or talldad at kepl dot com dot au ___________________ ---------------------------------------------------------------------------------- **= Email 4 ==========================** Date: Mon, 1 Dec 2008 08:02:56 +1100 (EST) From: "Voytek Eymont" Subject: Re: Java programming > On 30/11/2008, at 10:53 PM, Peter Moylan wrote: s > how it works. Think it's bad design? Take it up with SUN. You can override > the CLASSPATH environment variable by specifying the - classpath switch on > the java command. This can give the level of isolation you desire. fwiw, I generally used CMDs to start up java-based stuff like: 0[roman][F:\jstreet]type js.cmd rem set classpath=f:\jstreet\innoval.jar;f:\jstreet\HotJavaBean.jar jre -cp f:\jstreet\innoval.jar;f:\jstreet\HotJavaBean.jar innoval.mailer.jstreet 0[roman][F:\jstreet]type run.cmd set classpath=f:\jstreet\innoval.jar;f:\jstreet\HotJavaBean.jar java.exe innoval.mailer.jstreet 0[roman][F:\polarbar]type run.cmd jre -cp pbm125a.zip;HotJavaBean.jar org.polarbar.mailer 0[roman][F:\polarbar] -- Voytek ---------------------------------------------------------------------------------- **= Email 5 ==========================** Date: Mon, 1 Dec 2008 08:07:40 +1100 (EST) From: "Voytek Eymont" Subject: Re: Java programming > > On 30/11/2008, at 10:53 PM, Peter Moylan wrote: on the subject and Java and OS/2: I just came across and app that is being developed in Java; it's being done as cross-platform, meaning, windoze, mac, linux what's the likelyhood that it will function under OS/2's Java ? - none - not likely - perhaps - who cares - all of the above - none of the above hmmmmm, my jre is gone... 0[roman][F:\polarbar]jre SYS1041: The name jre is not recognized as an internal or external command, operable program or batch file. 0[roman][F:\polarbar]java -fullversion java full version "J2RE 1.3.1 IBM build co131-20040517a" -- Voytek ---------------------------------------------------------------------------------- **= Email 6 ==========================** Date: Mon, 01 Dec 2008 08:08:11 +1100 From: Dennis Nolan Subject: Re: Java programming Peter It's a long time ago, but I seem to recall a need to have the class library included in the "*classpath*" statement in the config.sys. If I recall correctly just issuing a *classpath* command at the command prompt will display the contents of the *classpath* variable. Sometimes undisplayable characters in the confiig.sys statement cut off parts of the command. But then again you have probably already been aware of this. Regards Dennis. Peter Moylan wrote: > Has anyone ever written a Java program under OS/2? I've just tried a > simple "Hello World" program and it failed. The exact sequence of > commands was > > javac HelloWorld.java > java HelloWorld.class > > and the error message was > > java.lang.NoClassDefFoundError: HelloWorld/class > > I suspect some sort of environment variable problem. Looking at my > CONFIG.SYS, it looks as if the "javac" command has run the version > 1.3.1 compiler, but some other environment variables are probably > pointing me to the version 1.1 directory. The CONFIG.SYS does not seem > to contain any reference at all to the latest installed version, > namely version 1.4.2. > > This suggests to me that > (a) the installer is mixing up the versions; and > (b) old versions are not being deleted when newer versions > are installed; and > (c) the bugs have never been found because nobody has ever > used Java for OS/2. > > If anyone can point me to a counterexample to (c), I'd be grateful. > ---------------------------------------------------------------------------------- **= Email 7 ==========================** Date: Mon, 01 Dec 2008 09:01:08 +1100 From: Ed Durrant Subject: Re: Accessing Access(Jet) Databases One thought, What formats does the database in Open Office read ? I don't exepect it will read md, so its likely you'll need to convert to another format. There are websites that will convert MS format files into other formats, so that might avoid you having to find someone running windoze. In fact the website might even convert direct to the format that you need for an application you have. I can't remember the URL - probably time to "google" I guess ! Cheers/2 Ed. John Angelico wrote: > On Sun, 30 Nov 2008 23:43:01 +0900, Nicholas Lysaght wrote: > > Hi Nick > > I must be a restless old curmudgeon - challenge is right. I want to unlock > stuff from the clutches of Windows... :-) > > >>> The stuff I want is in the .mdb files. The (not pretty, not ugly maybe >>> pretty ugly) stuff like VB scripts and ocx button controls I can do >>> without. >>> >> If you know someone who runs MS Access that can successfully load your *.mdb >> files, then Export your selection(s) as either plain text or comma delimited >> files. I thinkl MS Access will let you do that. Transfer those files onto >> eCs, and DBExpert, or most database programs will import that data to a >> table of a database that you create. >> > > The data is a "Searchable Bible in Contemporary English Version" consisting > of a mix of text blocks and graphics files, so some of that challenge will > be exploring the structure. > > Yes, dBExpert and/or DB2 are available here. > > I will try on the work WinXP box and see what I can bring home. > > Thanks for the tip! > > > Best regards > John Angelico > OS/2 SIG > os2 at melbpc dot org dot au or > talldad at kepl dot com dot au > ___________________ > > > ---------------------------------------------------------------------------------- **= Email 8 ==========================** Date: Mon, 01 Dec 2008 09:08:46 +1100 From: Ed Durrant Subject: Re: Accessing Access(Jet) Databases Ed Durrant wrote: > One thought, What formats does the database in Open Office read ? I > don't exepect it will read md, so its likely you'll need to convert to > another format. > > There are websites that will convert MS format files into other > formats, so that might avoid you having to find someone running windoze. > > In fact the website might even convert direct to the format that you > need for an application you have. > > I can't remember the URL - probably time to "google" I guess ! > > Cheers/2 > > Ed. > > > John Angelico wrote: >> On Sun, 30 Nov 2008 23:43:01 +0900, Nicholas Lysaght wrote: >> >> Hi Nick >> >> I must be a restless old curmudgeon - challenge is right. I want to >> unlock >> stuff from the clutches of Windows... :-) >> >> >>>> The stuff I want is in the .mdb files. The (not pretty, not ugly maybe >>>> pretty ugly) stuff like VB scripts and ocx button controls I can do >>>> without. >>>> >>> If you know someone who runs MS Access that can successfully load >>> your *.mdb >>> files, then Export your selection(s) as either plain text or comma >>> delimited >>> files. I thinkl MS Access will let you do that. Transfer those files >>> onto >>> eCs, and DBExpert, or most database programs will import that data to a >>> table of a database that you create. >>> >> >> The data is a "Searchable Bible in Contemporary English Version" >> consisting >> of a mix of text blocks and graphics files, so some of that challenge >> will >> be exploring the structure. >> >> Yes, dBExpert and/or DB2 are available here. >> >> I will try on the work WinXP box and see what I can bring home. >> >> Thanks for the tip! >> >> >> Best regards >> John Angelico >> OS/2 SIG >> os2 at melbpc dot org dot au or talldad at kepl dot com dot au >> ___________________ > >> >> > >> >> > > > > This looks interesting: http://searchenterpriselinux.techtarget dot com/tip/0,289483,sid39_gci1236205,00.html Accessing access databases from Open Office Base - but I don't think Base is in the free versions of OO is it ? Here's a chargable web site to perform file conversions - I believe there is a free one somewhere but my have some limitations: http://www.file-convert dot com/online.htm?o=gooAd Cheers/2 Ed. ---------------------------------------------------------------------------------- **= Email 9 ==========================** Date: Mon, 01 Dec 2008 12:54:21 +1100 From: Dennis Nolan Subject: Re: Java programming Peter, Java also makes use of include commands for project files. And though I only glanced at the results a google search for os/2 java include returned the follownig results which might be worth reading. http://www.os2world dot com/java/ http://www.3cat dot com/java_os2/javaos2.html http://www.doofus dot org/Java/ Regards Dennis. Peter Moylan wrote: > Peter Moylan wrote: >> That still leaves a puzzle. My CLASSPATH is now >> >> SET >> CLASSPATH=.;C:\JAVA11\LIB\SecMa.jar;C:\java11\Swing\swingall.jar;C:\java11\lib\classes.zip;.\.;C:\OS2\JAVAAPPS\LVMGUI.ZIP;C:\TCPIP\java; >> > Aha! I've just noticed something that perfectly illustrates what I > mentioned in another message. This CLASSPATH includes the LVMGUI > directory. In other words, EVERY Java application gets to search a > directory that belongs to one project. A directory that should have > been private to LVMGUI project. There is nothing global about that > directory. It should have been omitted from the global CLASSPATH. > > I have argued elsewhere that environment variables are a symptom of > obsolescent operating systems. Why? Because they promote > PROJECT-SPECIFIC data to the status of GLOBAL variables. That's bad > for two reasons. First, because once you've installed a few > applications your PATH blows out to an unreasonable size. (That's very > obvious in older versions of Windows. In newer versions you instead > put program-specific data into a global registry, which is just as > bad; but that's another subject.) Second, because information that is > supposed to be private is instead made public. That's not merely a > confidentiality violation; it's much worse. It means that EVERY > application has to worry about conflicts with every other application. > Not just the presently installed applications, but every conceivable > future application. > > Now, Java is supposed to be a modern programming language. For that > reason, I refuse to believe that it uses environment variables. > Whoever ported it to OS/2 has screwed up. > ---------------------------------------------------------------------------------- **= Email 10 ==========================** Date: Mon, 01 Dec 2008 22:41:50 +1000 (AEST) From: "John Angelico" Subject: Re: Accessing Access(Jet) Databases On Mon, 01 Dec 2008 09:08:46 +1100, Ed Durrant wrote: Hi Ed. >This looks interesting: > >http://searchenterpriselinux.techtarget dot com/tip/0,289483,sid39_gci1236205,00.html Very interesting. Looks like the way to go. All I have to do is pick up the mdb files and drop them into my OS/2 box. >Accessing access databases from Open Office Base - but I don't think >Base is in the free versions of OO is it ? It seems to be here on my system, and I just renewed my 12 months support at Mensys to get the 2.4 version. Best regards John Angelico OS/2 SIG os2 at melbpc dot org dot au or talldad at kepl dot com dot au ___________________ ---------------------------------------------------------------------------------- **= Email 11 ==========================** Date: Mon, 01 Dec 2008 22:37:57 +1000 (AEST) From: "John Angelico" Subject: Re: Accessing Access(Jet) Databases On Mon, 01 Dec 2008 09:01:08 +1100, Ed Durrant wrote: Hi Ed. >One thought, What formats does the database in Open Office read ? I >don't exepect it will read md, so its likely you'll need to convert to >another format. I was trying with OOo2.4 to check just that, but opening up Base on my system just locked up the WPS (consistently). > > There are websites that will convert MS format files into other >formats, so that might avoid you having to find someone running windoze. Yes, my first option will be to take it to work and chuck it onto the WinXP, then read it into OOo 3 for Win, then save/export the data I want (a lot of it!). Then I can feed it into anything available on OS/2 - preferably DB2 already running. Then I can use dBExpert or Rexx to view it. >In fact the website might even convert direct to the format that you >need for an application you have. >I can't remember the URL - probably time to "google" I guess ! That would be my next option, but the size may be an issue. The free ones often limit you to a meg or two. Best regards John Angelico OS/2 SIG os2 at melbpc dot org dot au or talldad at kepl dot com dot au ___________________ ----------------------------------------------------------------------------------