Hi everyone,
I wonder if you can help me with an issue. A co-worker of mine is
attempting to move an application over to OpenBD and he is having
issues connecting Sybase. I have no real experience with Sybase, just
Oracle and we cannot get the connection to work. Does anyone have a
sample of the xml needed to connect to Sybase and also what driver
should we use.
Thanks,
Mario
Here is the error we are getting:
Type Internal
Tag Context CFINVOKE: Line=14; Column=1
|
+-- CFFUNCTION: Line=5; Column=2
|
+-- CFQUERY: Line=6; Column=7
Source 3 :
4 : <!--- Region List --->
5 : <cffunction name="RegionList" access="public" returntype="query"
hint="List of regions">
6 : <CFQUERY NAME="regions" DATASOURCE="ctx">
7 : select ctx_rgn_id_c , ctx_rgn_n
^ Snippet from underlying CFML source
Stack Trace com.sybase.jdbc2.utils.UnimplementedOperationException:
The method com.sybase.jdbc2.tds.RowFormatToken.getCatalogName has not
been completed and should not be called.
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseRuntimeException(ErrorMessage.java:
954)
at com.sybase.jdbc2.utils.Debug.notImplemented(Debug.java:387)
at
com.sybase.jdbc2.tds.RowFormatToken.getCatalogName(RowFormatToken.java:
655)
at com.naryx.tagfusion.cfm.engine.cfQueryResultSetMetaData.(Unknown
Source)
at com.naryx.tagfusion.cfm.engine.cfQueryResultData.populate(Unknown
Source)
at
com.naryx.tagfusion.cfm.sql.cfSQLQueryData.executeAsStatement(Unknown
Source)
at com.naryx.tagfusion.cfm.sql.cfSQLQueryData.execute(Unknown Source)
at com.naryx.tagfusion.cfm.sql.cfSQLQueryData.runQuery(Unknown
Source)
at com.naryx.tagfusion.cfm.sql.cfQUERY.executeStatement(Unknown
Source)
at com.naryx.tagfusion.cfm.sql.cfQueryImplSQL.render(Unknown Source)
at com.naryx.tagfusion.cfm.sql.cfQUERY.render(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.renderToString(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfFUNCTION.realRun(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfFUNCTION.run(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfFUNCTION.run(Unknown Source)
at com.naryx.tagfusion.cfm.script.userDefinedFunction.execute(Unknown
Source)
at
com.naryx.tagfusion.cfm.engine.cfComponentData.invokeComponentFunction(Unknown
Source)
at
com.naryx.tagfusion.cfm.engine.cfComponentData.invokeComponentFunction(Unknown
Source)
at
com.naryx.tagfusion.cfm.tag.cfINVOKECommon.invokeComponentMethod(Unknown
Source)
at com.naryx.tagfusion.cfm.tag.cfINVOKECommon.renderComponent(Unknown
Source)
at com.naryx.tagfusion.cfm.tag.cfINVOKECommon.render(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source)
at com.naryx.tagfusion.cfm.file.cfFile.render(Unknown Source)
at com.naryx.tagfusion.cfm.engine.cfSession.onRequest(Unknown Source)
at com.naryx.tagfusion.cfm.engine.cfEngine.service(Unknown Source)
at com.naryx.tagfusion.cfm.cfServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:908)
at
org.apache.catalina.core.StandardWrapperValve.invokeServletService(StandardWrapperValve.java:
771)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
322)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
509)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
218)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
509)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
209)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
509)
at
com.iplanet.ias.web.connector.nsapi.NSAPIProcessor.process(NSAPIProcessor.java:
157)
at com.iplanet.ias.web.WebContainer.service(WebContainer.java:579)
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
online manual: http://www.openbluedragon.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en