| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Wierd problem with MTS & Oracle Java connectivity
Yeah that was my thought too. Actually, though, I've worked in mixed environments using both Multithreaded Server and Dedicated servers for the same instances. This is particularly useful for accomodating the heavy demands of Oracle Designer and Oracle Enterprise Manager, which are dreadful through an MTS connection. As long as the listener is up and properly configured, a dedicated connection should always be available.
The JDBC application naturally doesnt use normal SQLNET.ORA, TNSNAMES.ORA, PROTOCOL.ORA stuff- instead it's got a homegrown configuration file with the 1521 etc coded in a text string. What I will have to do tomorrow morning is grab one of the developers and see if we can't try jamming in (SERVER=SHARED) somewhere, but I have my doubts. Turning on MTS shouldn't completely break things; I can see the app somehow bypassing MTS and grabbing a dedicated server, but not completely choking.
We sent off all the usual stuff to Oracle Support tonight (traces, logs, .ora files, etc) but I am not holding my breath; my past experience has been that SQL*NET problems are the most miserable things to try to get fixed outside of RDBMS memory leaks.
If/when we do get an answer that works I will be sure to post it here. Thanks.
 |
 |