You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have the FB Server 2.5 with database in sql dialect 1.
When I try to select the field with type numeric(15, 2) by Jaybird-3.0.0-beta-1-JDK_1.8 i receive error:
Caused by: java.sql.SQLException: FBBigDecimal, unsupported field sqltype: 481
at org.firebirdsql.jdbc.field.FBBigDecimalField.<init>(FBBigDecimalField.java:54)
at org.firebirdsql.jdbc.field.FBField.createField(FBField.java:261)
at org.firebirdsql.jdbc.field.FBField.createField(FBField.java:244)
at org.firebirdsql.jdbc.AbstractResultSet.prepareVars(AbstractResultSet.java:253)
at org.firebirdsql.jdbc.AbstractResultSet.<init>(AbstractResultSet.java:130)
at org.firebirdsql.jdbc.FBResultSet.<init>(FBResultSet.java:46)
at org.firebirdsql.jdbc.FBStatement.getResultSet(FBStatement.java:885)
at org.firebirdsql.jdbc.FBStatement.getResultSet(FBStatement.java:865)
at org.firebirdsql.jdbc.FBStatement.executeQuery(FBStatement.java:229)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1716)
In dialect 1 NUMERIC(15,2) is actually a double field; in Jaybird 2.2 this would lead to FBDoubleField being used, but due to an improvement in datatype identification Jaybird 3 now uses FBBigDecimalField which then doesn't support the fact dialect 1 uses double. To fix this, Jaybird 3 will also use FBDoubleField for this.
Submitted by: John Kilin (johnkilin)
I have the FB Server 2.5 with database in sql dialect 1.
When I try to select the field with type numeric(15, 2) by Jaybird-3.0.0-beta-1-JDK_1.8 i receive error:
Caused by: java.sql.SQLException: FBBigDecimal, unsupported field sqltype: 481
at org.firebirdsql.jdbc.field.FBBigDecimalField.<init>(FBBigDecimalField.java:54)
at org.firebirdsql.jdbc.field.FBField.createField(FBField.java:261)
at org.firebirdsql.jdbc.field.FBField.createField(FBField.java:244)
at org.firebirdsql.jdbc.AbstractResultSet.prepareVars(AbstractResultSet.java:253)
at org.firebirdsql.jdbc.AbstractResultSet.<init>(AbstractResultSet.java:130)
at org.firebirdsql.jdbc.FBResultSet.<init>(FBResultSet.java:46)
at org.firebirdsql.jdbc.FBStatement.getResultSet(FBStatement.java:885)
at org.firebirdsql.jdbc.FBStatement.getResultSet(FBStatement.java:865)
at org.firebirdsql.jdbc.FBStatement.executeQuery(FBStatement.java:229)
at org.pentaho.di.core.database.Database.openQuery(Database.java:1716)
Commits: c9497c0 75f7b60
The text was updated successfully, but these errors were encountered: