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
