We had tried a bunch of different things in getting JDBC to work. I think we even exhanged a few eMails at that time, Dale, as Phil mentioned you had jdbc working on some systems. The following two steps seemed integral to getting it working for us.
1. It was necessary for us to add "ojdbc14.jar" (from the InstantClient) to the CLASSPATH. 2. Also, as I noted, some version of the JRE we tried did NOT work. Have you tried pointing to jre-1_5_0_11 instead of your SDK? As for your question, "We have been using the thin client (classes12.jar) - any reason to prefer the instant client instead?" - We're connecting to Oracle 10g and found the InstantClient drivers, particularly the ojdbc14.jar necessary to get jdbc to work. Is your JVM starting? You should see this line in your witangoevents.log. START INFO Java Virtual Machine: Enabled Feel free to contact me off-list (by eMail or phone) if I can be of further assistance. - Matt ________________________________________________________ Matt Muro [EMAIL PROTECTED] Harvard University phone: 617.998.8522 Division of Continuing Education fax: 617.495.9176 [email protected] writes: >We tried all of these, including downloading the instant client, but >no joy. I'm convinced it's something wrong with our Java installation >in Windows. Sure wish java came already pre-installed.... > >On Mar 27, 2007, at 12:19 PM, Dale Graham wrote: > >> Thanks... comments/questions below... >> On Mar 27, 2007, at 12:59 PM, Matt Muro wrote: >> >>> We also had some difficulty in getting JDBC to work on our Witango >>> app >>> servers. Here are some steps that got it working, with sticking >>> points >>> bolded. >>> >>> >>> 1. Setup Oracle's Instant Client (this has the ojdbc14.jar that >>> must be >>> added to the CLASSPATH) >>> The basic instant client rather than the lite version. We used: >>> instantclient-basic-win32-10.2.0.2-20060508.zip >> >> We have been using the thin client (classes12.jar) - any reason to >> prefer the instant client instead? >>> >>> 2. Modify CLASSPATH (add to front of path) >>> >>> CLASSPATH=C:\instantclient_10_2\ojdbc14.jar;C:\instantclient_10_2 >> >> This is different - we had the java sdk first... >>> >>> 3. Modify PATH (add to front of path) >>> PATH= C:\instantclient_10_2 >> >> we did not have this at all, just the java sdk! Hmmmm. >>> >>> 4. Install a Java JRE Not all JREs Virtual Machines (jvm.dll) >>> work for >>> some reason. >>> 1.5_10 and _11 do work. We used: jre-1_5_0_11-windows-i586-p.exe >> >> Will check this. >>> >>> 5. Modify witango.ini (don't forget this step) >>> JAVAVIRTUALMACHINE=C:\\Program >>> Files\\Java\\jre1.5.0_11\\bin\\client\\jvm.dll >> >> That we did, though we pointed at the SDK we had installed. Will >> investigate use of the jre instead >>> >>> 6. Copy jdbc.ini to Witangos Configuration directory >>> (find example of jdbc.ini below) >> >> That was OK. >>> >>> 6. Reboot so jdbc.ini changes are reread by app server. >>> >>> 7. Verify JVM starts and JDBC is enabled by checking >>> witangoevents.log >>> file: >>> START INFO Java Virtual Machine: Attempting >>> to load >>> C:\Program Files\Java\jre1.5.0_11\bin\client\jvm.dll >>> START INFO Java Virtual Machine: Enabled >>> START INFO JDBC Interface: Enabled >> >> Excellent suggestion, trotting over there right now to see what's up >> >> Thanks so VERY much for your time and effort and the very detailed >> approach. This was just the sort of thing I was looking for. >>> >>> >>> >>> [email protected] writes: >>>> We set up a new Windows Dev Studio and WitangoServer for a new staff >>>> member. However, we can't seem to get JDBC working properly. That >>>> is, the >>>> Dev Studio connects just fine, but we get the error shown below >>>> if we >>>> attempt to use the WitangoServer. >>>> >>>> Windows XP, WitangoServer 5.5.0.20, Oracle 10g >>>> >>>> We've installed the Java SDK (1.4.3 ) >>>> >>>> The jdbc drivers are located in the dev studio/library directory >>>> >>>> The classpath and path environment variables have been edited and >>>> are >>>> pointing (apparently) correctly. E.g., navigated to the file(s) or >>>> folders in question, copied path, pasted, etc. >>>> >>>> The Witango.ini file for the server is pointing to the correct >>>> spot (that >>>> works on the other Windows we have set up, BTW) >>>> >>>> The JDBC.ini file is the same as that working on other Windows >>>> computers. >>>> >>>> We've restarted the computer and checked again, still have the same >>>> problem. >>>> >>>> Note that we CAN connect using Oracle OCI, just not with JDBC >>>> >>>> >>>> >>>> >>>> What else have we forgotten to do? The "not enough memory" is very >>>> puzzling... >>>> >>>> ******************************************************************** >>>> >>>> An error occurred while processing your request: >>>> >>>> File: welcome.taf >>>> Position: Get_Sales_items >>>> Class: Internal >>>> Main Error Number: -1 >>>> >>>> There was not enough memory to complete the requested operation. >>>> >>>> >>>> File: welcome.taf >>>> Position: Get_Sales_items >>>> Class: Internal >>>> Main Error Number: -4 >>>> >>>> Unable to connect to the specified data source. >>>> Verify that data source is properly configured and that database >>>> server >>>> is online. >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> [Application File] >>>> [7] >>>> START /welcome.taf Witango_Server_5.5 Submit=Submit Visitor=customer >>>> Total Length of Postargs: 30 >>>> >>>> >>>> >>>> >>>> >>>> >>>> [If Action] >>>> [7] >>>> If ('<@ARG NAME=visitor>'='customer') >>>> >>>> >>>> >>>> >>>> >>>> >>>> [Results Action] >>>> [8] >>>> Customer_Page >>>> >>>> >>>> >>>> >>>> >>>> >>>> [Search Action] >>>> [8] >>>> Get_Sales_items : databaseInQuestion >>>> >>>> >>>> >>>> >>>> >>>> >>>> [Datasource] >>>> [8] >>>> No existing connection to the data source found, creating a new >>>> connection. DSN: jdbc.databaseInQuestion; User: xxxxxxx; >>>> >>>> >>>> >>>> >>>> >>>> >>>> [Error] >>>> [20] >>>> -1 There was not enough memory to complete the requested operation. >>>> >>>> >>>> >>>> >>>> >>>> >>>> [Datasource] >>>> [20] >>>> Unable to open a connection to jdbc.databaseInQuestion due to an >>>> unknown >>>> error during connection >>>> >>>> >>>> >>>> >>>> >>>> >>>> [Datasource] >>>> [20] >>>> Total Connection in Datasource Pool: 0; Max connections for the >>>> host: 0; >>>> Current connections in use for the host: 0 >>>> >>>> >>>> >>>> >>>> >>>> >>>> [Error] >>>> [21] >>>> -4 Unable to connect to the specified data source. Verify that data >>>> source is properly configured and that database server is online. >>>> >>>> >>>> >>>> >>>> >>>> >>>> [request$ Vars] >>>> [22] >>>> variableTimeout=30; >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> ____________________________________________________________________ >>>> ____ >>>> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >>>> >>>> >>> >>> >>> >>> >>> ________________________________________________________ >>> Matt Muro [EMAIL PROTECTED] >>> Harvard University phone: 617.998.8522 >>> Division of Continuing Education fax: 617.495.9176 >>> _____________________________________________________________________ >>> ___ >>> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >>> >> ______________________________________________________________________ >> __ >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >> >________________________________________________________________________ >TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
