[Macromedia][Oracle JDBC Driver]No more data available to read.
Not sure if my last post took since I didn't see it in the list or my email, so sorry if this is redundant. I am getting the following error [Macromedia][Oracle JDBC Driver]No more data available to read. when ever I try to execute a stored procedure that returns a ref cursor. I am currently running CF7 and have updated to the data direct 3.5 drivers (required for support of ref cursors). I have tried restarting the CF server and other drivers, but have had no luck so far. Just curious if any of you have experienced this issue and how you resolved it? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: [Macromedia][Oracle JDBC Driver]No more data available to read.
Thanks for the speedy reply James. I have done as you suggested, but I still recieve the error. Afterwards, just to see if it would have an affect, disabled the maintain connections settings and it also had no affect. Not sure if it matters in this case, but I am using oracle 10gR2. Wes ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325208 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: [Macromedia][Oracle JDBC Driver]No more data available to read.
I wish our DBA gave me that level of access the server, but I will let him know what to check into. The servers we are on are most certainly dedicated (I am the administrator for the CF side). Also I am able to connect to the DB and execute queries using the Oracle JDBC driver with any problem. I would just the Oracle provided driver, but there are issues with that driver and using ref cursors in CF. Thanks again for the ideas! It's possible the DB is actually unavailable (either due to network congestion, Oracle problems or other issues) when the errors occur. It's also possible that you're using shared servers rather than dedicated servers and the shared servers are having an issue. Check memory on the Oracle server, check for dead Oracle sessions etc. With maintain connections off, it's less likely to be a problem at the CF end, since the most common cause of the error is CF attempting to use a pooled connection that's no longer available. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX 7 using zip files
The Situation: I am attempting to create an application that recieves information from cfhttp request containing a zip file as a java ByteArrayOutputStream object. This zip file is then written to the hard disk and unzipped. The problem is that the zip files are unreadable by the java.util.ZipFile library. Am I not writing the files correctly? I have tested these files with winZip and everything works fine there. Also I have used zip files created by winZip and application is able to unzip the files without any problem. The exact error I recieve when using one of these files is: Object Instantiation Exception. An exception occurred when instantiating a java object. The cause of this exception was that: . The error occurred in D:\ACM\CFC\mailbox.cfc: line 174 Called from D:\ACM\CONNTEST\index.cfm: line 8 Called from D:\ACM\CFC\mailbox.cfc: line 174 Called from D:\ACM\CONNTEST\index.cfm: line 8 172 : cfscript 173 : //open zip file 174 : zipFile.init(arguments.inFileName); 175 : 176 : //get file entries Stack Trace: java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedConstructorAccessor79.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at coldfusion.runtime.java.JavaProxy.CreateObject(JavaProxy.java:128) at coldfusion.runtime.java.JavaProxy.invoke(JavaProxy.java:56) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfmailbox2ecfc1528230210$funcUNZIP.runFunction(D:\ACM\CFC\mailbox.cfc:174) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634) at cfindex2ecfm1170876534.runPage(D:\ACM\CONNTEST\index.cfm:8) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115) at coldfusion.CfmServlet.service(CfmServlet.java:107) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.util.zip.ZipException: error in opening zip file at java.util.zip.ZipFile.open(Native Method) at java.util.zip.ZipFile.init(ZipFile.java:111) at java.util.zip.ZipFile.init(ZipFile.java:71) The Code: Writing the zip file code cfhttp url =#prop.Url# method=POST username =#prop.user# password =#prop.pass# proxyserver =#prop.proxyServer# proxyuser =#prop.proxyUser# proxypassword =#prop.proxyPass# cfhttpparam type=url name=function value=downloadfiles cfhttpparam type=url name=filelist value=#arguments.fileList# cfhttpparam type=cookie name=SESSIONID value=#prop.sessionID# cfhttpparam type=cookie name=JSESSIONID value=#prop.sessionID# /cfhttp cffile action=write nameconflict=overwrite
Re: Setting up CSV datasource in CF 8
Have you set up the CSV as an ODBC source in the OS? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313600 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFCs not being processed by IIS or CF
I used your code as a web service (changing the access to remote, I knew what you meant ;) When I say directory permissions, I really mean is anonymous access enabled (probably should have just stated so)? The real point is that the above code works correctly with that one modification so the issue is more likely to be with the server setup. If all of this is in working order can you post your exact error message. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313612 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Server on development box?
If you want to use their tools, yes. You also use squirrel as a query editor. It is a free java based editor that works with any db platform that has a jdbc driver. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313616 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfflush in CF 8
I am also having issues with the cfflush tag using IIS. Unfortunately the environment I am in is pretty locked down and I cannot even use firefox to determine if the problem is IE. My biggest problem is that this link no longer works. Does anyone know what this solution was? My solution for cfflush on CF8 with IIS: http://orangepips.instantspot.com/blog/index. cfm/2007/12/12/cfflush-Problem-and-Solution-on-CF8-with-IIS- ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfflush in CF 8
This link no longer works, does anyone know what this solution was supposed to be? My solution for cfflush on CF8 with IIS: http://orangepips.instantspot.com/blog/index. cfm/2007/12/12/cfflush-Problem-and-Solution-on-CF8-with-IIS- ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Webwasher, Excel files, and why I hate my life
Hello all, I am having a small problem. I am attempting to generate excel files using coldfusion and then force the user to the excel file. The client has webwasher content filtering on their network and I get the following error message from webwasher when attempting to view SOME of excel files: The transferred file http://192.168.4.122/sup_report/exceloutput/OPR_7_2007_0.769483807854.xls; has been blocked by Webwasher. The server returned a file of type application/vnd.ms-excel but the content of this file is of a different type. This is odd to me as the same CF function generates the excel file content. The code is nothing more than a loop over a query that outputs a HTML table and saves the content in a variable and then dumps the variable into a new created file with extension .xls and the files do open in excel no problem. Also, I have written some sample files in XML per MS Tech net articles on how to do so. These files also work in excel, but not through the browser. I am about to pull my hair out on this one as these folks have decided that adding this Intranet site to a list of sites for webwasher to bypass is simply not an option. Thanks in advance for all your help, Wes ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286350 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfgrid
I am having trouble with the cfgrid tag. My situation is such that on my developement server I am able to access the cfgrid applet everything works great when accessed through http://localhost/..., but when accessing from the machines IP address (http://255.255.255.255/...) from the server or anywhere else it does not load and I get the nasty box with the red X. I have concluded that since the browser is able to load applets from other sites and even able to load cfgrids from other sites, that it is not the browser. I am using coldfusion enterprise, JRun, and IIS. I would assume that the problem is IIS related, but am unsure what the IIS problem could be. Any suggestions from the all knowing gurus? ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Wildcard Certificate and CFHTTP over SSL
What version is your SSL. SSLv3 can produce similar results. I had a similar situation and had to create a java class and seperate keystore for SSLv3 certificates. CFHTTP does not support SSLv3 and should not work at all, but in my situation I was able to connect to a testing platform (same cert), but not the production systems. Wes ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CreateObject() with java
I have a totally newb problem. I have a written a java class to unzip files
(which works JRUN's jre), but I am trying to use it with coldfusion and am
unable to get coldfusion to even recognize that it is there. I have set up the
classpath in administrator and ensured several times that the path is correct.
The contents of the classpath field in CFAdmin is:
C:\CFusionMX7\runtime\jre\lib\YP_Unzip.class
I am sure I have to have something configured incorrectly.
here is my code (though I am not sure that this is the problem):
COLDFUSION:
cfset temp = createObject(java, YP_Unzip)
JAVA:
import java.io.*;
import java.util.zip.*;
class YP_UnZip {
public void Unzip (String Args[]){
int BUFFER = 2048;
int i;
BufferedOutputStream dest = null;
FileInputStream inputfile;
ZipInputStream zipfile;
if (Args.length != 0){
//loop over files to be unzipped
for(i=0; i Args.length; i++){
System.out.print(Unzipping : );
System.out.print(Args[i]);
System.out.println();
try{
inputfile = new FileInputStream(Args[i]);
zipfile = new ZipInputStream(new
BufferedInputStream(inputfile));
ZipEntry entry;
while ((entry = zipfile.getNextEntry()) != null){
System.out.println(Extracting : +entry);
int count;
byte data[] = new byte[BUFFER];
//write the back to disk
FileOutputStream outputfile = new
FileOutputStream(entry.getName());
dest = new BufferedOutputStream(outputfile, BUFFER);
while ((count = zipfile.read(data, 0, BUFFER)) != -1) {
dest.write(data, 0, count);
}
dest.flush();
dest.close();
}
}
catch(Exception e){
e.printStackTrace();
}//end try-catch block
} //end for loop
}//end if (Args.length != 0)
else{
//code for error handling goes here - error missing file
}
}//main
}
Any help would be greatly appreciated.
Thanks,
Wes
~|
Create Web Applications With ColdFusion MX7 Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275762
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Java classes in coldfusion
The final problem appeared to be an issue from CF MX, described in tech note: http://www.macromedia.com/support/coldfusion/ts/documents/ssl_classcastexception.htm ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Java classes in coldfusion
am beginning to hate java/coldfusion integration. This class is to create a
connection to a web server and return the result of that communication. It
works great in console. But when i goto use in CF I get:
Unable to find a constructor for class javaHTTPSconnection that accepts
parameters of type ( ).
Or when called with 3 strings (as the constructor below should allow):
Unable to find a constructor for class javaHTTPSconnection that accepts
parameters of type ( java.lang.String, java.lang.String, java.lang.String ).
The coldfusion code that generates this error is also below. If anyone can
point out what I am doing wrong here I would greatly appreciate it.
--CF Code
cfset connection =
CreateObject(java,javaHTTPSconnection).init(#Myquery.Processing_Server#,
#Myquery.Username#:#Myquery.Password#, #string_270#)
--JAVA CLASS
import java.net.URL;
import java.io.*;
import javax.net.ssl.HttpsURLConnection;
public class javaHTTPSconnection {
String httpsURL;
String UserPass;
String AuthHeaderEnc;
String Body;
javaHTTPSconnection(){
httpsURL = URL; //removed URL
UserPass = user:pass; // removed user + Pass
AuthHeaderEnc = basic + Base64.encodeBytes(UserPass.getBytes());
Body = Test;
}
javaHTTPSconnection(String a, String b, String c){
httpsURL = a;
UserPass = b;
AuthHeaderEnc = basic + Base64.encodeBytes(UserPass.getBytes());
Body = c;
}
void SetKeyStore(){
//Set Keystore for this class
System.setProperty(javax.net.ssl.keyStore,
C:\\jclasses\\jssecacerts);
System.setProperty(javax.net.ssl.keyStoreType, JKS);
System.setProperty(javax.net.ssl.keyStorePassword, changeit);
System.setProperty(javax.net.ssl.trustStore,
C:\\jclasses\\jssecacerts);
System.setProperty(javax.net.ssl.trustStoreType, JKS);
System.setProperty(javax.net.ssl.trustStorePassword,
changeit);
}
public String[] HTTPScon ()
throws Exception
{
String retvar[] = new String[5000];
int i = 0;
System.out.println(AuthHeaderEnc);
SetKeyStore();
URL myurl = new URL(httpsURL);
HttpsURLConnection con = (HttpsURLConnection)myurl.openConnection();
con.setRequestProperty(Authorization, AuthHeaderEnc);
con.setRequestProperty(charset, us-ascii);
con.setRequestProperty(Content-Length,
String.valueOf(AuthHeaderEnc.length()));
con.setRequestMethod(POST);
con.setDoOutput(true);
con.setDoInput(true);
OutputStream out = con.getOutputStream();
out.write(Body.getBytes());
System.out.println(con.toString()+\n\n);
InputStream ins = con.getInputStream();
InputStreamReader isr=new InputStreamReader(ins);
InputStreamReader isr2=new InputStreamReader(ins);
BufferedReader in =new BufferedReader(isr);
String inputLine;
in.mark(5000);
while ((inputLine = in.readLine()) != null){
retvar[i] = inputLine;
i++;
}
in.close();
return retvar;
} //end HTTPScon
}// end class
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269841
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
