[Macromedia][SQLServer JDBC Driver]Data type not supported: Unknown: 0x00

[adv]

I'm getting the exception mentioned in the subject header when trying
to read from one of our db tables.

I'm running Mach-ii 1.8 with Coldfusion 9 and MS SQL Server 2005.

The select query includes text column types which seem to be the cause
of the exception, if I exclude these columns the query works however
as soon as I include them I receive the exception. I've also received
Object Has been Closed exceptions.

I've tested on Coldfusion 8 with Mach-ii 1.1 which works.

Any ideas?
cheers

exception details:

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer
JDBC Driver]Data type not supported: Unknown: 0x00 at
macromedia.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown
Source) at
macromedia.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown
Source) at
macromedia.jdbc.sqlserverbase.BaseExceptions.createException(Unknown
Source) at
macromedia.jdbc.sqlserverbase.BaseExceptions.getException(Unknown
Source) at
macromedia.jdbc.sqlserver.tds.TDSRequest.processColMetaData(Unknown
Source) at
macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source) at
macromedia.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
Source) at
macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at
macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown
Source) at
macromedia.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown
Source) at
macromedia.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown
Source) at
macromedia.jdbc.sqlserverbase.BasePreparedStatement.postImplExecute(Unknown
Source) at
macromedia.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown
Source) at
macromedia.jdbc.sqlserverbase.BaseStatement.executeInternal(Unknown
Source) at
macromedia.jdbc.sqlserverbase.BasePreparedStatement.execute(Unknown
Source) at
macromedia.jdbc.sqlserverbase.BasePreparedStatementPoolable.execute(Unknown
Source) at
coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:
91) at coldfusion.sql.Executive.executeQuery(Executive.java:1245) at
coldfusion.sql.Executive.executeQuery(Executive.java:1008) at
coldfusion.sql.Executive.executeQuery(Executive.java:939) at
coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at
coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at
coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at
cfrequestService2ecfc301129319$funcGETREQUESTSEARCH.runFunction(C:
\CallingCFCHERE.cfc:47) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at
coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:
405) at coldfusion.runtime.UDFMethod
$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2360) at
cfSystemManager2ecfc2027878680$funcGETREQUESTSEARCH.runFunction(C:
\CallingCFCHERE.cfc:49) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at
coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:
405) at coldfusion.runtime.UDFMethod
$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:517) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:495) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:354) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301) at
coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:382) at
cfCFCInvoker_EventArgs2ecfc1114324319$funcINVOKELISTENER.runFunction(C:
\MachII\framework\invokers\CFCInvoker_EventArgs.cfc:86) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:
405) at coldfusion.runtime.UDFMethod
$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2360) at
cfNotifyCommand2ecfc1949753399$funcEXECUTE.runFunction(C:\MachII
\framework\commands\NotifyCommand.cfc:88) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:
405) at coldfusion.runtime.UDFMethod
$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2360) at
cfEventHandler2ecfc1662146581$funcHANDLEEVENT.runFunction(C:\\MachII
\framework\EventHandler.cfc:81) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:
405) at coldfusion.runtime.UDFMethod
$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2360) at
cfRequestHandler2ecfc541130935$funcHANDLEEVENT.runFunction(C:\MachII
\framework\RequestHandler.cfc:380) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:
405) at coldfusion.runtime.UDFMethod
$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at
coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2582) at
cfRequestHandler2ecfc541130935$funcHANDLENEXTEVENT.runFunction(C:
\MachII\framework\RequestHandler.cfc:326) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:
405) at coldfusion.runtime.UDFMethod
$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at
coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2582) at
cfRequestHandler2ecfc541130935$funcPROCESSEVENTS.runFunction(C:\MachII
\framework\RequestHandler.cfc:270) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:
405) at coldfusion.runtime.UDFMethod
$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at
coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2582) at
cfRequestHandler2ecfc541130935$funcHANDLEREQUEST.runFunction(C:\MachII
\framework\RequestHandler.cfc:200) at
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:
405) at coldfusion.runtime.UDFMethod
$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:
55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2360) at
cfmach2dii2ecfm32215707.runPage(C:\inetpub\wwwroot\mach-ii.cfm:123) at
coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at
coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at
cfindex2ecfm453663300.runPage(C:\inetpub\wwwroot\index.cfm:10) at
coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at
coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:363)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at
coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:
74) at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:
28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at
coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:
126) at coldfusion.CfmServlet.service(CfmServlet.java:200) at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:
89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:
42) at
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at
jrun.servlet.FilterChain.service(FilterChain.java:101) at
jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:
286) at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:
543) at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:
203) at jrunx.scheduler.ThreadPool
$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at
jrunx.scheduler.ThreadPool
$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at
jrunx.scheduler.ThreadPool
$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at
jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

[Matthew Woodward]

On Wed, Aug 11, 2010 at 8:03 PM, adv <robm...@gmail.com> wrote:

I'm getting the exception mentioned in the subject header when trying
to read from one of our db tables.

I suspect you don't have things set in the CF administrator for that datasource to allow the return of CLOBs and BLOBs.

Change that setting and see what happens.

--
Matthew Woodward
ma...@mattwoodward.com
http://blog.mattwoodward.com
identi.ca / Twitter: @mpwoodward

Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html

[adv]

Yeah I tried that, ticked both boxes, cycled CF and tried again.

On Aug 12, 2:17 pm, Matthew Woodward <m...@mattwoodward.com> wrote:

> On Wed, Aug 11, 2010 at 8:03 PM, adv <robme...@gmail.com> wrote:
>
> > I'm getting the exception mentioned in the subject header when trying
> > to read from one of our db tables.
>
> I suspect you don't have things set in the CF administrator for that
> datasource to allow the return of CLOBs and BLOBs.
>
> Change that setting and see what happens.
>
> --
> Matthew Woodward

> m...@mattwoodward.comhttp://blog.mattwoodward.com

[Matthew Woodward]

On Wed, Aug 11, 2010 at 10:41 PM, adv <robm...@gmail.com> wrote:

Yeah I tried that, ticked both boxes, cycled CF and tried again.

And ... ? It's still not working? Exact same error whether or not the boxes are checked?

From what you're saying this seems to be on the database/driver side of things and doesn't really have anything to do with Mach-II from what I can tell. Doesn't mean I won't try to help, just making sure we don't get sidetracked worrying about Mach-II versions, etc. because Mach-II wouldn't have anything to do with a query erroring out like this.

Can you try creating a simple CFML page that runs that same query outside the context of Mach-II so we can focus in on the query itself? And are you *positive* it's the text fields causing the errors?

Does it break when you *run* the query or when you're outputting the query? Are you doing any formatting, etc. on specific query columns that might be throwing things off?

Is there any chance the error is related to specific data being returned by the query? In other words, if you limited the query to a specific record using an ID in the WHERE clause, does it still break, or is there perhaps some data in some particular row that's throwing things off?

Have you tried a different JDBC driver to see if you get the same results?

I see you mention CF 9--is this a regular query or are you using ORM? Can you post your query code?

--
Matthew Woodward
ma...@mattwoodward.com