On 2/23/05 3:20 PM, "Wayne Irvine" <[EMAIL PROTECTED]> wrote: > Roland Dumas at [EMAIL PROTECTED] wrote: > >> I love it. I put the path in the witango.ini file and have the jdbc >> datasources working now. I have to trace back and figure out the steps to do >> on production server now. > > You do know that if you were to do a step by step write up (leaving out the > hair pulling and back tracking) many of us (ok, so me) would be greatly > indebted to you. ;) > > Wayne Irvine > The procedure is a variant (update) of http://www.apocm.de/witango/mySQLJDBC.html For your server: 1. Get mysql adaptor at http://dev.mysql.com/downloads/connector/j/3.1.html (the current production version) 2. when you download and open the file, you will see a ".jar" file ( mysql-connector-java-3.1.7-bin.jar) 3. Place the file in /Library/Java/Extensions/ Make sure the owner is 'system' 4. in witango.ini file: JAVASCRIPTSWITCH=on JAVASWITCH=on JAVAVIRTUALMACHINE=/System/Library/Frameworks/JavaVM.framework/JavaVM 5. In jdbc.ini file, create a stanza for your DSN. Do by analogy with the sample already there. Example: <DataSource ID="--yourDSNname--"> <DSN>--yourDSNname--</DSN> <DriverClass>com.mysql.jdbc.Driver</DriverClass> <URL>jdbc:mysql://127.0.0.1:3306/--databaseName--</URL> <Properties /> </DataSource> 6. Restart your witango server. For your dev studio (5.5) 1. Place the .jar file in /Library/Java/Extensions/ 2. in your /applications/witango/Dev Studio 5.5/install/jdbc.ini , add your DSN stanza, just like you did on the server. Change the <URL> to be the ip address of your server, not 127.0.0.1. Also do this in the ~/library/preferences/witango5.5/jdbc.ini (the first one of these is likely superfluous) You're supposed to be able to do this by defining a new datasource in the dev studio, but mine crashed every time I tried. 3. Open dev studio. You should see your new jdbc data source. Open it and offer up username and password. You'll be asked to select tables. Do so, save, watch the dev studio crash. Restart. It should work - maybe after another crash or two. You can see your setup with the datasources:modify option, but creating them in the dev studio seems futile. **Do make sure that mysql is setup to allow you to connect form your development studio location. If you're switching from odbc, it's likely all set up. *** If your startup indicates the JVM didn't load, use the update panel to bring java up to date, then try again. **** I may have left something out on the dev studio. I did some banging around. ----------------------------------------- Roland Dumas Roberts Information Services 310 W. Bellevue Avenue San Mateo CA 94402 650-347-1373 415-412-9300 (cell) [EMAIL PROTECTED] SMS: http://new.servqual.com/html/sms.tml ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
