Skip to main content
Participant
July 6, 2006
Question

Oracle thin client stop working

  • July 6, 2006
  • 4 replies
  • 696 views
I just applied hotfix 3 to my MX 7 standard deployment and all my thin client connections to Oracle database now stop working. When I tried to verify those data source in Administration, I received the error "java.sql.SQLException: No suitable driver available". All the connect work fine before the hoxfix.

My configuration is:
Windows 2000 Server
Coldfusion MX server version 7,0,0,91690
Java version 1.4.2_05
Java VM Specification Version 1.0
Java VM version 1.4.2_05-b04
Java Class Version 48.0

Please help.


This topic has been closed for replies.

4 replies

tranktAuthor
Participant
September 20, 2006
I took Ted Zimmerman's advice and my problem is now gone. Thanks Ted.
tranktAuthor
Participant
September 20, 2006
Thank you for your assistance but my thin client connect is still not working. I found the jvm.config file in directory c:\ColdFusionMX7\runtime\bin. The content of the file is as follow:
#
# VM configuration
#
# Where to find JVM, if {java.home}/jre exists then that JVM is used
# if not then it must be the path to the JRE itself
java.home=C:/CFusionMX7/runtime/jre
#
# If no java.home is specified a VM is located by looking in these places in this
# order:
#
# 1) bin directory for java.dll (windows) or lib/<ARCH>/libjava.so (unix)
# 2) ../jre
# 3) registry (windows only)
# 4) JAVA_HOME env var plus jre (ie $JAVA_HOME/jre)
#

# Arguments to VM
java.args=-server -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -Xmx512m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m -Dcoldfusion.rootDir={application.home}/../ -Dcoldfusion.libPath={application.home}/../lib -XX:+UseParallelGC -Dcoldfusion.classPath={application.home}/../../classes,{application.home}/../lib/updates,{application.home}/../lib/,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-INF/cfform/jars,d:\\oracle9i\\jdbc\\lib\\ojdbc14.jar;C:\\CFusionMX7\\lib\\pdflib.jar

#
# commas will be converted to platform specific separator and the result will be passed
# as -Djava.ext.dirs= to the VM
java.ext.dirs={jre.home}/lib/ext

#
# where to find shared libraries
java.library.path={application.home}/../lib,{application.home}/../jintegra/bin,{application.home}/../jintegra/bin/international
system.path.first=false

#
# set the current working directory - useful for Windows to control
# the default search path used when loading DLLs since it comes
# before system directory, windows directory and PATH
java.user.dir={application.home}/../../lib

# JVM classpath
java.class.path={application.home}/servers/lib,{application.home}/../lib/macromedia_drivers.jar,{application.home}/lib/cfmx_mbean.jar,{application.home}/lib

Are you talking about Coldfusion classpath or JVM classpath?
tranktAuthor
Participant
July 7, 2006
I verified that the path to the jar file for Oracle thin client is still in the text box for ColdFusion Class Path. This is what I have in the box:
d:\oracle9i\jdbc\lib\ojdbc14.jar,C:\CFusionMX7\lib\pdflib.jar
The pdflib is working fine.
I hope some to be able to resolve this issue soon.

Thank all


Participant
July 7, 2006
Check the jvm.config file. We had an issue where the classpath was getting put in the arguments area. Moving it to the appropriate area manually in the file worked fine after a CF restart. We will probably have to manually modify the jvm.config file from now on.
Participating Frequently
July 6, 2006
This is a SWAG, but I wonder if you lost your Class Path info in the ColdFusion MX Administrator's Java and JVM page after installing the hotfix? (see
Configuring the Oracle JDBC thin driver)

Phil