Ask a Question related to Coldfusion Database Access, Design and Development.
-
Zippog #1
Re: CFMX and Oracle 10G JDBC no longer retrievestimestamp with date
I am using ColdFusion 7 are you using 6.1?
Zippog Guest
-
CFMX and Oracle 10G JDBC no longer retrieves timestampwith date
I'm running CFMX with Oracle 10g client loaded My data source is Other; JDBC URL: jdbc: oracle: oci:@TMS; Driver Class: oracle.jdbc.OracleDriver... -
Are cfmx 7 admin changes logged anywhere now thatcfadmin.log is no longer available?
Migrating Applications from ColdFusion 5 pg 20 clearly states that cfadmin.log is no longer available. Are cfmx 7 admin changes logged anywhere... -
Informix 10 & CFMX 6.1 & JDBC
I'm getting following error on <cfapplication> tag in Application.cfm: Reason of failure "java.sql.SQLException: Exception generated during... -
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01000:maximum open cursors exceeded
Here is the technote from Macromedia regarding this issue: http://www.macromedia.com/go/tn_17660 Hope this helps! -
JDBC driver problem w/ CFMX 7
I have copied the .jar file to the web-inf/lib directory, and added the class path as:... -
E43509TS #2 Re: CFMX and Oracle 10G JDBC no longer retrievestimestamp with date
I'm on MX 7
E43509TS Guest
-
Zippog #3 Re: CFMX and Oracle 10G JDBC no longer retrievestimestamp with date
Here are my JVM details and at the bottom the JVM settings. Do these differ
from yours?
JVM Details
Java Version 1.4.2_05
Java Vendor Sun Microsystems Inc.
Java Vendor URL [url]http://java.sun.com/[/url]
Java Home C:\CFusionMX7\runtime\jre
Java File Encoding Cp1252
Java Default Locale en_US
File Separator \
Path Separator ;
Line Separator Chr(13)
User Name SYSTEM
User Dir C:\CFusionMX7\runtime\bin
Java VM Specification Version 1.0
Java VM Specification Vendor Sun Microsystems Inc.
Java VM Specification Name Java Virtual Machine Specification
Java VM Version 1.4.2_05-b04
Java VM Vendor Sun Microsystems Inc.
Java VM Name Java HotSpot(TM) Server VM
Java Specification Version 1.4
Java Specification Vendor Sun Microsystems Inc.
Java Specification Name Java Platform API Specification
Java Class Version 48.0
CF Server Java Class Path
;C:/CFusionMX7/runtime/../lib/ant-launcher.jar;
C:/CFusionMX7/runtime/../lib/ant.jar; C:/CFusionMX7/runtime/../lib/axis.jar;
C:/CFusionMX7/runtime/../lib/bcel.jar; C:/CFusionMX7/runtime/../lib/cdo.jar;
C:/CFusionMX7/runtime/../lib/cdohost.jar;
C:/CFusionMX7/runtime/../lib/cf4was.jar;
C:/CFusionMX7/runtime/../lib/cf4was_ae.jar;
C:/CFusionMX7/runtime/../lib/cfmx-ssl.jar;
C:/CFusionMX7/runtime/../lib/cfusion.jar;
C:/CFusionMX7/runtime/../lib/commons-beanutils-1.5.jar;
C:/CFusionMX7/runtime/../lib/commons-collections-2.1.jar;
C:/CFusionMX7/runtime/../lib/commons-digester-1.3.jar;
C:/CFusionMX7/runtime/../lib/commons-discovery-0.2.jar;
C:/CFusionMX7/runtime/../lib/commons-logging-1.0.2.jar;
C:/CFusionMX7/runtime/../lib/commons-logging-api-1.0.2.jar;
C:/CFusionMX7/runtime/../lib/commons-net-1.2.2.jar;
C:/CFusionMX7/runtime/../lib/crystal.jar;
C:/CFusionMX7/runtime/../lib/flashgateway.jar;
C:/CFusionMX7/runtime/../lib/httpclient.jar;
C:/CFusionMX7/runtime/../lib/ib61patch.jar;
C:/CFusionMX7/runtime/../lib/ib6addonpatch.jar;
C:/CFusionMX7/runtime/../lib/ib6core.jar;
C:/CFusionMX7/runtime/../lib/ib6swing.jar;
C:/CFusionMX7/runtime/../lib/ib6util.jar; C:/CFusionMX7/runtime/../lib/im.jar;
C:/CFusionMX7/runtime/../lib/iText.jar;
C:/CFusionMX7/runtime/../lib/iTextAsian.jar;
C:/CFusionMX7/runtime/../lib/izmado.jar;
C:/CFusionMX7/runtime/../lib/jakarta-oro-2.0.6.jar;
C:/CFusionMX7/runtime/../lib/java2wsdl.jar;
C:/CFusionMX7/runtime/../lib/jaxrpc.jar;
C:/CFusionMX7/runtime/../lib/jdom.jar; C:/CFusionMX7/runtime/../lib/jeb.jar;
C:/CFusionMX7/runtime/../lib/jintegra.jar;
C:/CFusionMX7/runtime/../lib/ldap.jar;
C:/CFusionMX7/runtime/../lib/ldapbp.jar;
C:/CFusionMX7/runtime/../lib/log4j.jar;
C:/CFusionMX7/runtime/../lib/macromedia_drivers.jar;
C:/CFusionMX7/runtime/../lib/mail.jar;
C:/CFusionMX7/runtime/../lib/msapps.jar;
C:/CFusionMX7/runtime/../lib/pbclient42RE.jar;
C:/CFusionMX7/runtime/../lib/pbembedded42RE.jar;
C:/CFusionMX7/runtime/../lib/pbserver42RE.jar;
C:/CFusionMX7/runtime/../lib/pbtools42RE.jar;
C:/CFusionMX7/runtime/../lib/poi-2.5.1-final-20040804.jar;
C:/CFusionMX7/runtime/../lib/poi-contrib-2.5.1-final-20040804.jar;
C:/CFusionMX7/runtime/../lib/ri_generic.jar;
C:/CFusionMX7/runtime/../lib/saaj.jar; C:/CFusionMX7/runtime/../lib/smack.jar;
C:/CFusionMX7/runtime/../lib/smpp.jar;
C:/CFusionMX7/runtime/../lib/STComm.jar;
C:/CFusionMX7/runtime/../lib/tools.jar;
C:/CFusionMX7/runtime/../lib/tt-bytecode.jar;
C:/CFusionMX7/runtime/../lib/vadmin.jar;
C:/CFusionMX7/runtime/../lib/verity.jar;
C:/CFusionMX7/runtime/../lib/vparametric.jar;
C:/CFusionMX7/runtime/../lib/vsearch.jar;
C:/CFusionMX7/runtime/../lib/wc50.jar;
C:/CFusionMX7/runtime/../lib/webchartsJava2D.jar;
C:/CFusionMX7/runtime/../lib/wsdl2java.jar;
C:/CFusionMX7/runtime/../lib/wsdl4j-1.5.1.jar;
C:/CFusionMX7/runtime/../lib/xalan.jar;
C:/CFusionMX7/runtime/../lib/xercesImpl.jar;
C:/CFusionMX7/runtime/../lib/xml-apis.jar; C:/CFusionMX7/runtime/../lib/;
C:/CFusionMX7/runtime/../gateway/lib/examples.jar;
C:/CFusionMX7/runtime/../gateway/lib/;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-awt-util.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-css.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-ext.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-transcoder.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-util.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/commons-discovery.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/commons-logging.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/concurrent.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/flex.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/jakarta-oro-2.0.7.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/jcert.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/jnet.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/jsse.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/oscache.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/;
c:/OracleJDBC/ojdbc14.jar;
Java Class Path
C:\CFusionMX7\runtime\servers\lib;
C:\CFusionMX7\runtime\servers\lib\jrun-patch.jar;
C:\CFusionMX7\runtime\..\lib\macromedia_drivers.ja r;
C:\CFusionMX7\runtime\lib\cfmx_mbean.jar;
C:\CFusionMX7\runtime\lib;
C:\CFusionMX7\runtime\lib\cfmx_mbean.jar;
C:\CFusionMX7\runtime\lib\instutil.jar;
C:\CFusionMX7\runtime\lib\java2wsdl.jar;
C:\CFusionMX7\runtime\lib\jrun-ant-tasks.jar;
C:\CFusionMX7\runtime\lib\jrun-xdoclet.jar;
C:\CFusionMX7\runtime\lib\jrun.jar;
C:\CFusionMX7\runtime\lib\jspc.jar;
C:\CFusionMX7\runtime\lib\migrate.jar;
C:\CFusionMX7\runtime\lib\oem-xdoclet.jar;
C:\CFusionMX7\runtime\lib\sniffer.jar;
C:\CFusionMX7\runtime\lib\webservices.jar;
C:\CFusionMX7\runtime\lib\wsconfig.jar;
C:\CFusionMX7\runtime\lib\wsdl2java.jar;
C:\CFusionMX7\runtime\lib\xmlscript.jar;
C:\CFusionMX7\runtime\lib\jrun.jar
Java Ext Dirs
C:\CFusionMX7\runtime\jre\lib\ext
Java and JVM
Java virtual machine path C:/CFusionMX7/runtime/jre
Initial memory size MB
Maximum memory size 512 MB
Class path
-Dcoldfusion.classPath={application.home}/../../classes,{application.home}/../l
ib/updates,{application.home}/../lib/,{application.home}/../gateway/lib/,{applic
ation.home}/../wwwroot/WEB-INF/cfform/jars,c:/OracleJDBC/ojdbc14.jar
JVM arguments -server -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m
-Dcoldfusion.rootDir={application.home}/../
-Dcoldfusion.libPath={application.home}/../lib -Doracle.jdbc.V8Compatibile=true
Zippog Guest
-
E43509TS #4 Re: CFMX and Oracle 10G JDBC no longer retrievestimestamp with date
I know this has to be frustrating but my first cursory look at my settings
versus yours, nothing jumped out.
Version Information
Server Details
Server Product ColdFusion MX
Version 7,0,0,91690
Edition Standard
Operating System Windows XP
OS Version 5.1
JVM Details
Java Version 1.4.2_05
Java Vendor Sun Microsystems Inc.
Java Vendor URL [url]http://java.sun.com/[/url]
Java Home C:\CFusionMX7\runtime\jre
Java File Encoding Cp1252
Java Default Locale en_US
File Separator \
Path Separator ;
Line Separator Chr(13)
User Name SYSTEM
User Home C:\Documents and Settings\LocalService
User Dir C:\CFusionMX7\runtime\bin
Java VM Specification Version 1.0
Java VM Specification Vendor Sun Microsystems Inc.
Java VM Specification Name Java Virtual Machine Specification
Java VM Version 1.4.2_05-b04
Java VM Vendor Sun Microsystems Inc.
Java VM Name Java HotSpot(TM) Server VM
Java Specification Version 1.4
Java Specification Vendor Sun Microsystems Inc.
Java Specification Name Java Platform API Specification
Java Class Version 48.0
CF Server Java Class Path
;C:/CFusionMX7/runtime/../lib/ant-launcher.jar;
C:/CFusionMX7/runtime/../lib/ant.jar; C:/CFusionMX7/runtime/../lib/axis.jar;
C:/CFusionMX7/runtime/../lib/bcel.jar; C:/CFusionMX7/runtime/../lib/cdo.jar;
C:/CFusionMX7/runtime/../lib/cdohost.jar;
C:/CFusionMX7/runtime/../lib/cf4was.jar;
C:/CFusionMX7/runtime/../lib/cf4was_ae.jar;
C:/CFusionMX7/runtime/../lib/cfmx-ssl.jar;
C:/CFusionMX7/runtime/../lib/cfusion.jar;
C:/CFusionMX7/runtime/../lib/commons-beanutils-1.5.jar;
C:/CFusionMX7/runtime/../lib/commons-collections-2.1.jar;
C:/CFusionMX7/runtime/../lib/commons-digester-1.3.jar;
C:/CFusionMX7/runtime/../lib/commons-discovery.jar;
C:/CFusionMX7/runtime/../lib/commons-logging-1.0.2.jar;
C:/CFusionMX7/runtime/../lib/commons-logging-api-1.0.2.jar;
C:/CFusionMX7/runtime/../lib/commons-net-1.2.2.jar;
C:/CFusionMX7/runtime/../lib/crystal.jar;
C:/CFusionMX7/runtime/../lib/flashgateway.jar;
C:/CFusionMX7/runtime/../lib/httpclient.jar;
C:/CFusionMX7/runtime/../lib/ib6addonpatch.jar;
C:/CFusionMX7/runtime/../lib/ib6core.jar;
C:/CFusionMX7/runtime/../lib/ib6swing.jar;
C:/CFusionMX7/runtime/../lib/ib6util.jar; C:/CFusionMX7/runtime/../lib/im.jar;
C:/CFusionMX7/runtime/../lib/iText.jar;
C:/CFusionMX7/runtime/../lib/iTextAsian.jar;
C:/CFusionMX7/runtime/../lib/izmado.jar;
C:/CFusionMX7/runtime/../lib/jakarta-oro-2.0.6.jar;
C:/CFusionMX7/runtime/../lib/java2wsdl.jar;
C:/CFusionMX7/runtime/../lib/jaxrpc.jar;
C:/CFusionMX7/runtime/../lib/jdom.jar; C:/CFusionMX7/runtime/../lib/jeb.jar;
C:/CFusionMX7/runtime/../lib/jintegra.jar;
C:/CFusionMX7/runtime/../lib/ldap.jar;
C:/CFusionMX7/runtime/../lib/ldapbp.jar;
C:/CFusionMX7/runtime/../lib/log4j.jar;
C:/CFusionMX7/runtime/../lib/macromedia_drivers.jar;
C:/CFusionMX7/runtime/../lib/mail.jar;
C:/CFusionMX7/runtime/../lib/msapps.jar;
C:/CFusionMX7/runtime/../lib/pbclient42RE.jar;
C:/CFusionMX7/runtime/../lib/pbembedded42RE.jar;
C:/CFusionMX7/runtime/../lib/pbserver42RE.jar;
C:/CFusionMX7/runtime/../lib/pbtools42RE.jar;
C:/CFusionMX7/runtime/../lib/poi-2.5.1-final-20040804.jar;
C:/CFusionMX7/runtime/../lib/poi-contrib-2.5.1-final-20040804.jar;
C:/CFusionMX7/runtime/../lib/ri_generic.jar;
C:/CFusionMX7/runtime/../lib/saaj.jar; C:/CFusionMX7/runtime/../lib/smack.jar;
C:/CFusionMX7/runtime/../lib/smpp.jar;
C:/CFusionMX7/runtime/../lib/STComm.jar;
C:/CFusionMX7/runtime/../lib/tools.jar;
C:/CFusionMX7/runtime/../lib/tt-bytecode.jar;
C:/CFusionMX7/runtime/../lib/vadmin.jar;
C:/CFusionMX7/runtime/../lib/verity.jar;
C:/CFusionMX7/runtime/../lib/vparametric.jar;
C:/CFusionMX7/runtime/../lib/vsearch.jar;
C:/CFusionMX7/runtime/../lib/wc50.jar;
C:/CFusionMX7/runtime/../lib/webchartsJava2D.jar;
C:/CFusionMX7/runtime/../lib/wsdl2java.jar;
C:/CFusionMX7/runtime/../lib/wsdl4j.jar;
C:/CFusionMX7/runtime/../lib/xalan.jar;
C:/CFusionMX7/runtime/../lib/xercesImpl.jar;
C:/CFusionMX7/runtime/../lib/xml-apis.jar; C:/CFusionMX7/runtime/../lib/;
C:/CFusionMX7/runtime/../gateway/lib/examples.jar;
C:/CFusionMX7/runtime/../gateway/lib/;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-awt-util.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-css.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-ext.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-transcoder.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/batik-util.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/commons-discovery.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/commons-logging.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/concurrent.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/flex.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/jakarta-oro-2.0.7.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/jcert.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/jnet.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/jsse.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/oscache.jar;
C:/CFusionMX7/runtime/../wwwroot/WEB-INF/cfform/jars/;
C:/junk/OracleJDBC/ojdbc14.jar;
Java Class Path
C:\CFusionMX7\runtime\servers\lib;
C:\CFusionMX7\runtime\servers\lib\jrun-patch.jar;
C:\CFusionMX7\runtime\..\lib\macromedia_drivers.ja r;
C:\CFusionMX7\runtime\lib\cfmx_mbean.jar;
C:\CFusionMX7\runtime\lib;
C:\CFusionMX7\runtime\lib\cfmx_mbean.jar;
C:\CFusionMX7\runtime\lib\instutil.jar;
C:\CFusionMX7\runtime\lib\java2wsdl.jar;
C:\CFusionMX7\runtime\lib\jrun-ant-tasks.jar;
C:\CFusionMX7\runtime\lib\jrun-xdoclet.jar;
C:\CFusionMX7\runtime\lib\jrun.jar;
C:\CFusionMX7\runtime\lib\jspc.jar;
C:\CFusionMX7\runtime\lib\migrate.jar;
C:\CFusionMX7\runtime\lib\oem-xdoclet.jar;
C:\CFusionMX7\runtime\lib\sniffer.jar;
C:\CFusionMX7\runtime\lib\webservices.jar;
C:\CFusionMX7\runtime\lib\wsconfig.jar;
C:\CFusionMX7\runtime\lib\wsdl2java.jar;
C:\CFusionMX7\runtime\lib\xmlscript.jar;
C:\CFusionMX7\runtime\lib\jrun.jar
Java Ext Dirs
C:\CFusionMX7\runtime\jre\lib\ext
Java and JVM
Java virtual machine path C:/CFusionMX7/runtime/jre
Initial memory size MB
Maximum memory size 512 MB
Class path
-Dcoldfusion.classPath={application.home}/../../classes,{application.home}/../li
b/updates,{application.home}/../lib/,{application.home}/../gateway/lib/,{applica
tion.home}/../wwwroot/WEB-INF/cfform/jars,C:\junk\OracleJDBC\ojdbc14.jar
JVM arguments -server -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m
-Dcoldfusion.rootDir={application.home}/../
-Dcoldfusion.libPath={application.home}/../lib -Doracle.jdbc.V8Compatible=true
E43509TS Guest
-
Zippog #5 Re: CFMX and Oracle 10G JDBC no longer retrievestimestamp with date
V8Compatible was spelled wrong. I have fixed it and now it works. Thanks for you help.
Larry
Zippog Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
