commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 13370] - [sql] DDL for INTEGER data type incorrect
Date Mon, 07 Oct 2002 20:30:47 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=13370>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=13370

[sql] DDL for INTEGER data type incorrect





------- Additional Comments From Joe@Germuska.com  2002-10-07 20:30 -------
I found another similar problem, and so have written a patch for OracleBuilder which 
addresses my two issues.  There may be other SQL datatypes which need special 
handling, but filling those in should be easy.

I found this in the Oracle 8.1.7 documentation:
"Do not define columns with these SQL/DS and DB2 datatypes, because they have no 
corresponding Oracle datatype: 

*	GRAPHIC 
*	LONG VARGRAPHIC 
*	VARGRAPHIC 
*	TIME 
*	TIMESTAMP 
"

Since I had a column defined as TIMESTAMP, I needed OracleBuilder to translate that to 
DATE for me.  So while I was at it, I also added handling for INTEGER so that the length 
is not included.

--
To unsubscribe, e-mail:   <mailto:commons-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:commons-dev-help@jakarta.apache.org>


Mime
View raw message