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
2. Modify CLASSPATH (add to front of path)
CLASSPATH=C:\instantclient_10_2\ojdbc14.jar;C:\instantclient_10_2
3. Modify PATH (add to front of path)
PATH= C:\instantclient_10_2
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
5. Modify witango.ini (don't forget this step)
JAVAVIRTUALMACHINE=C:\\Program
Files\\Java\\jre1.5.0_11\\bin\\client\\jvm.dll
6. Copy jdbc.ini to Witangos Configuration directory
(find example of jdbc.ini below)
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
jdbc.ini from Witango app Server configuration directory
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE JDBCINI SYSTEM "jdbcini.dtd" >
<JDBCINI Version="0x00010000">
<DataSources>
<DataSource ID="ProdDatabase">
<DSN>ProdDatabase</DSN>
<DriverClass>oracle.jdbc.OracleDriver</DriverClass>
<URL>jdbc:oracle:thin:@blah.blah.blah.com:1521:prod</URL>
<Properties />
</DataSource>
<DataSource ID="TestDatabase">
<DSN>TestDatabase</DSN>
<DriverClass>oracle.jdbc.OracleDriver</DriverClass>
<URL>jdbc:oracle:thin:@blah.blah.blah.com:1521:test</URL>
<Properties />
</DataSource>
</DataSources>
</JDBCINI>
witango-talk@witango.com 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
