[ 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)