You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Andre Berten (JIRA)" <ji...@apache.org> on 2005/12/22 19:41:30 UTC
[jira] Created: (DDLUTILS-60) JDBC Type BIGINT in Firebird
JDBC Type BIGINT in Firebird
-----------------------------
Key: DDLUTILS-60
URL: http://issues.apache.org/jira/browse/DDLUTILS-60
Project: DdlUtils
Type: Bug
Environment: SuSE Linux 10.0, Firebird 2.0 Beta1, JDK 1.5.0_06, JayBird 2.0.1,
Reporter: Andre Berten
Assigned to: Thomas Dudziak
The jdbc type BIGINT is converted to the database type DECIMAL(38,0). Firebird does support DECIMAL (and NUMERIC) with a maximum precision of 18. NUMERIC(18,0) or DECIMAL(18,0) should work fine as a conversion of BIGINT. The NUMERIC and DECIMAL types did not change since InterBase 6.0, so this should work for InterBase 6.0 too. Since Firebird 1.5 there is also the native BIGINT type.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DDLUTILS-60) JDBC Type BIGINT in Firebird
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-60?page=all ]
Thomas Dudziak updated DDLUTILS-60:
-----------------------------------
Component: Core - Firebird
Core - Interbase
> JDBC Type BIGINT in Firebird
> ----------------------------
>
> Key: DDLUTILS-60
> URL: http://issues.apache.org/jira/browse/DDLUTILS-60
> Project: DdlUtils
> Type: Bug
> Components: Core - Firebird, Core - Interbase
> Environment: SuSE Linux 10.0, Firebird 2.0 Beta1, JDK 1.5.0_06, JayBird 2.0.1,
> Reporter: Andre Berten
> Assignee: Thomas Dudziak
>
> The jdbc type BIGINT is converted to the database type DECIMAL(38,0). Firebird does support DECIMAL (and NUMERIC) with a maximum precision of 18. NUMERIC(18,0) or DECIMAL(18,0) should work fine as a conversion of BIGINT. The NUMERIC and DECIMAL types did not change since InterBase 6.0, so this should work for InterBase 6.0 too. Since Firebird 1.5 there is also the native BIGINT type.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Resolved: (DDLUTILS-60) JDBC Type BIGINT in Firebird
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DDLUTILS-60?page=all ]
Thomas Dudziak resolved DDLUTILS-60:
------------------------------------
Resolution: Fixed
The Firebird platform now uses the BIGINT native type as it is supposed to support Firebird 1.5 and newer. For Firebird 1.0, the InterBase platform can be used which uses NUMERIC(18,0)
> JDBC Type BIGINT in Firebird
> ----------------------------
>
> Key: DDLUTILS-60
> URL: http://issues.apache.org/jira/browse/DDLUTILS-60
> Project: DdlUtils
> Type: Bug
> Environment: SuSE Linux 10.0, Firebird 2.0 Beta1, JDK 1.5.0_06, JayBird 2.0.1,
> Reporter: Andre Berten
> Assignee: Thomas Dudziak
>
> The jdbc type BIGINT is converted to the database type DECIMAL(38,0). Firebird does support DECIMAL (and NUMERIC) with a maximum precision of 18. NUMERIC(18,0) or DECIMAL(18,0) should work fine as a conversion of BIGINT. The NUMERIC and DECIMAL types did not change since InterBase 6.0, so this should work for InterBase 6.0 too. Since Firebird 1.5 there is also the native BIGINT type.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira