Author: jolee
Date: 2012-05-07 10:27:22 -0400 (Mon, 07 May 2012)
New Revision: 4060
Modified:
branches/7.4.x/connectors/translator-jdbc/src/main/java/org/teiid/translator/jdbc/JDBCBaseExecution.java
branches/7.4.x/engine/src/main/java/org/teiid/dqp/internal/datamgr/ConnectorWorkItem.java
branches/7.4.x/metadata/src/main/java/org/teiid/metadata/index/RecordFactory.java
Log:
TEIID-2020: Running Sybase procedure with jconnect driver in Teiid fails
Modified:
branches/7.4.x/connectors/translator-jdbc/src/main/java/org/teiid/translator/jdbc/JDBCBaseExecution.java
===================================================================
---
branches/7.4.x/connectors/translator-jdbc/src/main/java/org/teiid/translator/jdbc/JDBCBaseExecution.java 2012-05-07
14:27:07 UTC (rev 4059)
+++
branches/7.4.x/connectors/translator-jdbc/src/main/java/org/teiid/translator/jdbc/JDBCBaseExecution.java 2012-05-07
14:27:22 UTC (rev 4060)
@@ -38,6 +38,7 @@
import org.teiid.translator.TranslatorException;
import org.teiid.translator.Execution;
import org.teiid.translator.ExecutionContext;
+import org.teiid.translator.jdbc.sybase.SybaseExecutionFactory;
/**
@@ -135,7 +136,10 @@
}
protected void setSizeContraints(Statement statement) {
- try {
+ try {
+ if (statement instanceof CallableStatement && this.executionFactory
instanceof SybaseExecutionFactory) {
+ return;
+ }
statement.setFetchSize(fetchSize);
} catch (SQLException e) {
if (LogManager.isMessageToBeRecorded(LogConstants.CTX_CONNECTOR, MessageLevel.DETAIL))
{
Modified:
branches/7.4.x/engine/src/main/java/org/teiid/dqp/internal/datamgr/ConnectorWorkItem.java
===================================================================
---
branches/7.4.x/engine/src/main/java/org/teiid/dqp/internal/datamgr/ConnectorWorkItem.java 2012-05-07
14:27:07 UTC (rev 4059)
+++
branches/7.4.x/engine/src/main/java/org/teiid/dqp/internal/datamgr/ConnectorWorkItem.java 2012-05-07
14:27:22 UTC (rev 4060)
@@ -210,6 +210,9 @@
// Translate the command
Command command = this.requestMsg.getCommand();
this.expectedColumns = command.getProjectedSymbols().size();
+ if (command instanceof StoredProcedure) {
+ this.expectedColumns =
((StoredProcedure)command).getResultSetColumns().size();
+ }
LanguageBridgeFactory factory = new LanguageBridgeFactory(queryMetadata);
this.translatedCommand = factory.translate(command);
Modified:
branches/7.4.x/metadata/src/main/java/org/teiid/metadata/index/RecordFactory.java
===================================================================
---
branches/7.4.x/metadata/src/main/java/org/teiid/metadata/index/RecordFactory.java 2012-05-07
14:27:07 UTC (rev 4059)
+++
branches/7.4.x/metadata/src/main/java/org/teiid/metadata/index/RecordFactory.java 2012-05-07
14:27:22 UTC (rev 4060)
@@ -811,6 +811,8 @@
case MetadataConstants.PARAMETER_TYPES.RETURN_VALUE:
type = ProcedureParameter.Type.ReturnValue;
break;
+ default:
+ throw new IllegalArgumentException("Invalid parameter type, please ensure
all parameter types are valid in Designer.");
}
paramRd.setType(type);
Show replies by date