Re: Use J2EE datasource to insert Clob on MX6,7

2008-11-10 Thread anguss
http://www.adobe.com/support/coldfusion/releasenotes/mx/mx61_known_problems.html#database 52292 You cannot use CLOB or BLOB data with the Oracle Thin Client driver on ColdFusion MX. Use the Oracle JDBC driver that ships with ColdFusion MX Enterprise instead. I have tried to use Oracle 10g driver

Re: Use J2EE datasource to insert Clob on MX6,7

2008-11-09 Thread anguss
Is there a reason you're not using the DataDirect Oracle drivers that came with CF? In our environment, weblogic's connection pooling manager is better than CF.^^ I'm assuming Enterprise because of this: J2EE server:Weblogic8.1u6 The only way to get CF running on that is via the

Re: Use J2EE datasource to insert Clob on MX6,7

2008-11-03 Thread Matthew Williams
My guess would be it's a Standard, vs an Enterprise install. Those native Oracle drivers are just not up to par with the DataDirect ones. Matthew Williams Geodesic GraFX ~| Adobe® ColdFusion® 8 software 8 is the most

Re: Use J2EE datasource to insert Clob on MX6,7

2008-11-03 Thread James Holmes
I'm assuming Enterprise because of this: J2EE server:Weblogic8.1u6 The only way to get CF running on that is via the Enterprise WAR/EAR deployment. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/11/3 Matthew Williams [EMAIL PROTECTED]: My guess would be

Re: Use J2EE datasource to insert Clob on MX6,7

2008-11-03 Thread Matthew Williams
That begs the question then of why is the OP using the data source capability into WebLogic over the datasource that you can define in ColdFusion? Matthew Williams Geodesic GraFX ~| Adobe® ColdFusion® 8 software 8 is the

Re: Use J2EE datasource to insert Clob on MX6,7

2008-11-03 Thread Tom Chiverton
On Monday 03 Nov 2008, Matthew Williams wrote: That begs the question then of why is the OP using the data source capability into WebLogic over the datasource that you can define in ColdFusion? We used data sources defined in WebLogic because they could then be managed by the same stuff that

Use J2EE datasource to insert Clob on MX6,7

2008-10-31 Thread anguss
Dear all: We are testing to use CF's J2EE Datasource to insert Clob to Oracle 9i database. I have checked CF's datasource config,and enable long text retrieval support in data source config. But return to spread an IO Execption: End of TNS data channel Environment config as follows CF

Re: Use J2EE datasource to insert Clob on MX6,7

2008-10-31 Thread anguss
Dear Tom: Tks for ur reply.I will check oracle log later. I had tried to use mx8(8,0,1,195765) with oracle 9i and 10g driver ,and CF throws the same execption as follow Error casting an object of type weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection to an incompatible type.

Re: Use J2EE datasource to insert Clob on MX6,7

2008-10-31 Thread Tom Chiverton
On Friday 31 Oct 2008, anguss wrote: But return to spread an IO Execption: End of TNS data channel Have you checked the Oracle logs ? -- Tom Chiverton Helping to collaboratively customize advanced frictionless best-of-breed exceptional channels

Re: Use J2EE datasource to insert Clob on MX6,7

2008-10-31 Thread James Holmes
Is there a reason you're not using the DataDirect Oracle drivers that came with CF? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/10/31 anguss [EMAIL PROTECTED]: Dear Tom: Tks for ur reply.I will check oracle log later. I had tried to use