1 ] In your user directory user/Library/Preferences/Witango5.5/ you should have a file called jdbc.ini for mysql, it should look like this
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd" >
<JDBCINI Version="0x00010000">
<DataSources>
<DataSource ID="widgets3">
<DSN>widgets3</DSN>
<DriverClass>com.mysql.jdbc.Driver</DriverClass>
<URL>jdbc:mysql:/localhost:3306/widgets</URL>
<Properties>
<Property ID="server">
<Name>server</Name>
<Value>127.0.0.1</Value>
</Property>
<Property ID="port">
<Name>port</Name>
<Value>3306</Value>
</Property>
</Properties>
</DataSource>
</DataSources>
</JDBCINI>where widgets3 is what I decided to call this DB in the editor, and "widgets" is the actual database name
3306 is the mysql default for port number and it is set up for local host
2] IF THIS SETUP WORKS IN YOUR EDITOR (reconfigured for your editor, of course), COPY IT AND PUT IT HERE AS WELL FOR THE SERVER TO USE (Note, restart your editor before you test, just to be on the safe side) It should show up in the JDBC section of the workspace, and, once you provide your user name and password, open the DB right up.
/Applications/Witango/Server/configuration/jdbc.ini
restart your server
So that's just two steps, unless you count the restarts.
On Tuesday, October 21, 2003, at 12:12 PM, Roland A.Dumas wrote:
I'm running OS X server 10.2.8, iODBC, mysql
In the main, it's fine EXCEPT I get random crashes of witango server.
The crash log points at iodbc as the culprit. I'm not technical and don't know if an accusation from a crash log is all the evidence needed, but I think I need to look at jdbc. I have a jdbc driver running, as that's what SQL Manager J uses to connect to the mysql server.
Question: Where are the simple English instructions for setting up jdbc data sources for OS X, on both the server and the dev studio ends.
I know there have been posts on attempts and successes, but have they settled down to 'step 1, 2, 3'?
_______________________________________________________________________ _
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
