[
https://issues.apache.org/jira/browse/TRAFODION-1909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15401229#comment-15401229
]
liu ming commented on TRAFODION-1909:
-------------------------------------
test with JDBC T4 program and data type works fine, sample code:
Class.forName("org.trafodion.jdbc.t4.T4Driver");
Connection conn =
DriverManager.getConnection("jdbc:t4jdbc://10.10.10.8:23400/:", "usr", "pwd");
Statement stmt = conn.createStatement();
targetTable = "t1";
String line = "select * from " + targetTable;
rs = stmt.executeQuery(line);
ResultSetMetaData md = rs.getMetaData() ;
for( int i = 1; i <= md.getColumnCount(); i++ )
{
System.out.print( md.getColumnLabel(i) + " " ) ;
System.out.print( md.getColumnTypeName(i) + "
");
System.out.print( md.getPrecision(i) + " ");
System.out.print( md.isNullable(i) + " ");
System.out.print( md.getColumnClassName(i) + "
");
}
rs.close() ;
So probably already fixed issue.
> Output of showddl differs from output of jdbc client (t4)
> ---------------------------------------------------------
>
> Key: TRAFODION-1909
> URL: https://issues.apache.org/jira/browse/TRAFODION-1909
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-jdbc-t4
> Affects Versions: 1.3-incubating
> Reporter: Pierre Smits
> Assignee: liu ming
>
> as per thread on the dev ml. See http://markmail.org/message/tw73lpq3k3fkldvr
> This is returned in the application (Apache OFBiz)
> {code}
> Column [ESTIMATED_COST] of table [OFBIZ.WORK_EFFORT_GOOD_STANDARD] of
> entity [WorkEffortGoodStandard] is of type [BIGINT] in the database, but is
> defined as type [NUMERIC] in the entity definition.
> {code}
> This is returned with the showddl command;
> {code}>>showddl table OFBIZ.WORK_EFFORT_GOOD_STANDARD;
> CREATE TABLE TRAFODION.OFBIZ.WORK_EFFORT_GOOD_STANDARD
> (
> WORK_EFFORT_ID VARCHAR(20) CHARACTER SET ISO88591
> COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , PRODUCT_ID VARCHAR(20) CHARACTER SET ISO88591
> COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , WORK_EFFORT_GOOD_STD_TYPE_ID VARCHAR(20) CHARACTER SET ISO88591
> COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE SERIALIZED
> , FROM_DATE TIMESTAMP(6) NO DEFAULT NOT NULL NOT
> DROPPABLE NOT SERIALIZED
> , THRU_DATE TIMESTAMP(6) DEFAULT NULL NOT
> SERIALIZED
> , STATUS_ID VARCHAR(20) CHARACTER SET ISO88591
> COLLATE
> DEFAULT DEFAULT NULL SERIALIZED
> , ESTIMATED_QUANTITY DOUBLE PRECISION DEFAULT NULL NOT
> SERIALIZED
> , ESTIMATED_COST NUMERIC(18, 2) DEFAULT NULL
> SERIALIZED
> , LAST_UPDATED_STAMP TIMESTAMP(6) DEFAULT NULL NOT
> SERIALIZED
> , LAST_UPDATED_TX_STAMP TIMESTAMP(6) DEFAULT NULL NOT
> SERIALIZED
> , CREATED_STAMP TIMESTAMP(6) DEFAULT NULL NOT
> SERIALIZED
> , CREATED_TX_STAMP TIMESTAMP(6) DEFAULT NULL NOT
> SERIALIZED
> , PRIMARY KEY (WORK_EFFORT_ID ASC, PRODUCT_ID ASC,
> WORK_EFFORT_GOOD_STD_TYPE_ID ASC, FROM_DATE ASC)
> )
> ;
> CREATE INDEX WKEFF_GDSTD_PROD ON
> TRAFODION.OFBIZ.WORK_EFFORT_GOOD_STANDARD
> (
> PRODUCT_ID ASC
> )
> ;
> CREATE INDEX WKEFF_GDSTD_STTS ON
> TRAFODION.OFBIZ.WORK_EFFORT_GOOD_STANDARD
> (
> STATUS_ID ASC
> )
> ;
> CREATE INDEX WKEFF_GDSTD_TYPE ON
> TRAFODION.OFBIZ.WORK_EFFORT_GOOD_STANDARD
> (
> WORK_EFFORT_GOOD_STD_TYPE_ID ASC
> )
> ;
> CREATE INDEX WKEFF_GDSTD_WEFF ON
> TRAFODION.OFBIZ.WORK_EFFORT_GOOD_STANDARD
> (
> WORK_EFFORT_ID ASC
> )
> ;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
