Has anyone had any success with connecting from the OS X Dev Studio to MySQL using JDBC and if so, can I pick their brain? I want to make sure that I have all of the required pieces in the right locations.
Please let me know.
Thanks,
Steve Smith
Oakbridge Information Solutions
Office: (519) 624-4388
GTA: (416) 606-3885
Fax: (519) 624-3353
Cell: (416) 606-3885
Email: [EMAIL PROTECTED]
Web: http://www.oakbridge.ca
On Monday, July 14, 2003, at 09:35 AM, Dale Graham wrote:
This "greying out" of the JDBC connectivity appears to be some sort of OS X Studio bug.
I found out that on my setup, if I mess with the jdbc.ini file in ~user/Library/Preferences/Witango it "kills" JDBC (no JDBC folder in workspace, JDBC greyed out in menu). DELETING this file fixes the problem. (E.g., restart the Studio). If that doesn't work, then you need to delete all references to the studio (including prefs and the "receipt") and reinstall. Then you definitely will be back in business.
In terms of Robert Garcia's comments, I use a DIFFERENT application to ensure that everything is working OK for JDBC; in my case I have been using SQL Grinder, which makes use of the JDBC drivers.
And having said all that, I have not yet been able to get JDBC working on OS X with Oracle with the Studio (though I connect just fine to Oracle via JDBC with SQL Grinder)
On Saturday, July 12, 2003, at 07:06 AM, Steve Smith wrote:
But that was the point that I was trying to make, I can't right click or select 'New JDBC' as the options for JDBC are grayed out. Right clicking (thank you With for making the OS X version of the Dev Studio accept two-button mice) for ODBC works fine although we know that it actually doesn't on OS X.
Also, I don't have a /Library/Preferences/Witango/ folder. I do have a /username(i.e. Steve)/Library/Preferences/Witango/ folder and it does have a JDBC.ini file. Is this the correct location? That file contains the following:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd" >
<JDBCINI Version="0x00010000">
<DataSources>
<DataSource ID="test">
<DSN>test</DSN>
<DriverClass>com.mysql.jdbc.Driver</DriverClass>
<URL>jdbc:mysql://127.0.0.1:3306/TestMySQL</URL>
<Properties>
<Property ID="server">
<Name>server</Name>
<Value />
</Property>
<Property ID="port">
<Name>port</Name>
<Value />
</Property>
</Properties>
</DataSource>
</DataSources>
</JDBCINI>
But I can't see this data source in the Dev Studio, there isn't anything in the root level of the data source tab of my Workspace pallet for JDBC, just FileMaker and ODBC. Any ideas why the JDBC is not available?
Please let me know.
Thanks,
Steve Smith
Oakbridge Information Solutions
Office: (519) 624-4388
GTA: (416) 606-3885
Fax: (519) 624-3353
Cell: (416) 606-3885
Email: 1A19,1A19,[EMAIL PROTECTED]
Web: 1A19,1A19,FFFEhttp://www.oakbridge.ca
On Friday, July 11, 2003, at 11:36 PM, Robert Garcia wrote:
There are two ways to create a JDBC datasource. You can edit the jdbc.ini file manually in your /library/preferences/witango/ folder. However, it is much easier to right click the JDBC folder and choose New JDBC. At this point, the values entered depend entirely on your JDBC driver (except for name). Each driver has a different value for the driver class, and each usually has a slightly different syntax for the url. You must read the documentation.
After you successfully enter the info, don't hit test, it doesn't seem to work right for me yet, just hit OK, and try to expand (load) the new JDBC source. If the tables load, it worked. If you now open the jdbc.ini file in your preferences folder, you will see that it has been edited for you.
With my driver, I include all info in the URL, except for the user and password.
Robert.
On Friday, July 11, 2003, at 05:58 PM, Steve Smith wrote:
I wanted to try playing around with JDBC data sources, but when I went to create a new data source in the Dev Studio, JDBC was grayed out. I downloaded and installed the new Dev Studio (5.0.9) but they are grayed out there too.
I also noticed that I have a folder inside of the Dev Studio folder called 'Install' which contains a JDBC.ini file and a file called Lucida Grandeenvironment.plist. Is this a proper configuration and if not, where do these files belong?
Please let me know.
Thanks,
Steve Smith
Oakbridge Information Solutions
Office: (519) 624-4388
GTA: (416) 606-3885
Fax: (519) 624-3353
Cell: (416) 606-3885
Email: 1A18,1A18,[EMAIL PROTECTED]
Web: 1A18,1A18,FFFDhttp://www.oakbridge.ca
--
Robert Garcia
President - BigHead Technology
CTO - eventpix.com
2781 N Carlmont Pl
Simi Valley, Ca 93065
ph: 805.522.8577 - cell: 805.501.1390
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
