Hi John
I understand where your coming from because I had been using ODBC on OS 9 for years. Then Apple change to OSX and my ODBC system fell apart. I finally when to OSX, upgraded to OpenBase & Witango 5. I, like you, read all the posts here and printed out a lot of them, but the whole thing just didn't make sense and statements like Jason's doesn't help at all. I know what ODBC is, but what is JDBC? I know it has something to do with JAVA, but that didn't mean any thing to me and all I wanted was someone to tell me where to put what to make Witango work again.
So John here is what I've learned. JDBC drivers do the same thing as ODBC driver. The difference is they're written to run on something called a Java Virtual Machine (JVM). OSX has this built into it's OS so you don't have to do anything there. My next step was to find JDBC drivers for OpenBase. OpenBase has them on their web site so I download them. Then came my next problem the files that came down end with .jar. I thought this was some kind of compressed file, but I have no idea how to uncompress it. I was to find out that a file with a .jar at the end is the way JAVA store files. All the drivers are inside that file someplace. The next thing was where to put that .jar file. After some reading I found that the easy place is in the Root/Library/Java/Extensions folder. Just drop it in the folder. Now setting up Witango to use it. The way I did it was to start with Witango Studio. I started Studio then I right clicked on the JDBC folder, in Workspace, and a menu came up. Click on New JDBC. A New JDBC Datasource box opens up. Now here you are going to need some information about your JDBC divers. The 2 thing I needed was right in my OpenBase manual for the Driver Class & URL boxes. In the name box I put the name of my db "Athletics", in the Drive Class box I put in just what my OpenBase manual say to: "JDBC Driver: com.openbase.jdbc.ObDriver", and in the URL box I put in "JDBC URL: jdbc:openbase://IP of my db/Athletics". I didn't put anything in the server & port boxes. I clicked on the testing button at the bottom left and open the test box. I had no username or password on this db so I just clicked on test. The message box said "connection established". I found that I could then see the db in the workspace JDBC folder. I found that New JDBC Datasource builds a file named "jdbc.ini" and stores it in ~/Lbrary/Preferences/Witango5.5. The ~ at the start of the file location stands for you home directory, I didn't know that.
Now to get the Witango server to work I just put a copy of the "jdbc.ini" file, I just made, into Root/Applications/Witango/Server/Configuration/jdbc.ini. Make sure that Others, in permissions, is set to Read Only. I started WebStar and the Witango plug-in started right up. When I then went to my web site it worked.
I know I'm long winded, but I hope this, and Witango support, well help get you started.
Tom
Jason Pamental wrote:
John,
Is there a reason you want to use ODBC rather than JDBC? That is extremely easy to set up, and drivers can be had for most DB engines pretty readily (and for free to boot). I don't have any speed comparisons, but I haven't heard a lot of complaints about it either.
Jason
On Apr 27, 2004, at 7:02 PM, John Newsom wrote:
Hi, I have looked extensively over the archive, and also tracked the
conversations about this topic (including the disagreements over what
works!), and also looked in the documentation, both the installation
guide for the 5.5 studio, (feb 2004 - where there is a brief paragraph)
and the server 5.x install (aug 2002). Is there anyplace with a clear,
functional, step by step guide for getting the studio and server working
on OS X. I realize that with each successive release of the OS, and the
moving target of Apple's support for iODBC, and the various industry
efforts, that keeping something like this up to date is difficult. But
I did have all the pieces working (using an old product from The Kompany
that was an implementation of unixODBC), but since Panther I more or
less just gave up, hoping that with the release of 5.5 studio there
would be a clear installation and troubeshooting guide. I don't relish
spending another 8-10 hours getting every thing working again by trial
and error.
I also wonder if there is anything in the works that implements something like the PHP - MySQL calls, or the FX PHP class that works with the Filemaker XML import/export API's.
Or should I just go blast Apple for not providing a solid database architecture on OSX? Windows is sooooo much easier in this area, and I am a MAC zealot from way back.
End of rant.
Sorry.
John Newsom
-----Original Message----- From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 11:52 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Java Bean Docs
I have installed the trial version of the new dev studio, but I still don't see any documentation for Beans. I know how to build them, and use them in my project, and deploy, that is not the issue. The issue is that I have read in old pervasive docs, that there are built in classes that help with a cleaner interface to and from the bean. Like passing a witango array to the bean, rather than passing some type of string, or xml to be parsed by the bean.
Is there any documentation anywhere for this? I thought this was going to be supplied with 5.5. I may be missing something, so if anyone knows, please inform me.
-- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 5910 Clark Rd Suite G Paradise, Ca 95969 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
_______________________________________________________________________ _
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
-- Tom Storey Research & Accountability Pinellas County Schools Largo, Fl (727) 588-6254 [EMAIL PROTECTED] -- The box said: "Requires Windows XP, or better." So I bought a Macintosh with OS X --
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
