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 JRE’s 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 Witango’s 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
