View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006461 | SymmetricDS | Bug | public | 2024-05-30 09:14 | 2024-06-05 17:48 |
| Reporter | adisman | Assigned To | |||
| Priority | normal | ||||
| Status | acknowledged | Resolution | open | ||
| Product Version | 3.14.15 | ||||
| Summary | 0006461: Blob fields and Firebird 4 or 5 | ||||
| Description | Since Firebird version 4.0 UDF functions are depricated. If the UdfAccess = Restrict parameter is set in the firebird.conf configuration file, UDF functions can be used. However, registration of the SYM_HEX function from the sym_udf library fails when using Firebird 5 and the jaybird-4.0.10.java8.jar connector. I am attaching the error from the log below. Would it be possible to fix the error? Another possible solution would be to replace the UDF function with a newer type of UDR function for Firebird 4 and 5 | ||||
| Additional Information | +-----------------------------------------------------------------+ | Copyright (C) 2007-2024 JumpMind, Inc. | | | | Licensed under the GNU General Public License version 3. | | This software comes with ABSOLUTELY NO WARRANTY. | | See http://www.gnu.org/licenses/gpl.html | +-----------------------------------------------------------------+ 2024-05-30 10:16:54,372 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on 0.0.0.0:31415:HTTP/1.1 2024-05-30 10:16:54,488 INFO [startup] [SymmetricEngineHolder] [main] Current directory is D:\Development\Symmetric 2024-05-30 10:16:54,488 INFO [startup] [SymmetricEngineHolder] [main] Starting in single-server mode 2024-05-30 10:16:54,514 INFO [aktualizace_corp-001] [ClientSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database 2024-05-30 10:16:54,564 INFO [aktualizace_corp-001] [BasicDataSourceFactory] [symmetric-engine-startup-1] Setting database connection property encoding to WIN1250 2024-05-30 10:16:54,564 INFO [aktualizace_corp-001] [BasicDataSourceFactory] [symmetric-engine-startup-1] Setting required database connection property columnLabelForName=true 2024-05-30 10:16:54,862 INFO [aktualizace_corp-001] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'Firebird 5.0', version '5', protocol 'firebirdsql' 2024-05-30 10:16:54,870 INFO [aktualizace_corp-001] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform 2024-05-30 10:16:54,901 INFO [aktualizace_corp-001] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.firebird.Firebird21SymmetricDialect 2024-05-30 10:16:54,916 INFO [aktualizace_corp-001] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: tmp\aktualizace_corp-001 2024-05-30 10:16:54,925 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2024-05-30 10:16:55,108 INFO [aktualizace_corp-001] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered 2024-05-30 10:16:55,113 INFO [aktualizace_corp-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database 2024-05-30 10:16:55,127 INFO [aktualizace_corp-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Checking tables and objects 2024-05-30 10:16:55,135 INFO [aktualizace_corp-001] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] Installing SymmetricDS database object: declare external function sym_hex blob returns cstring(32660) free_it entry_point 'sym_hex' module_name 'sym_udf' 2024-05-30 10:16:55,136 ERROR [aktualizace_corp-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:3082010199] org.jumpmind.db.sql.SqlException: CREATE FUNCTION SYM_HEX failed; Dynamic SQL Error; SQL error code = -204; Data type unknown; Implementation limit exceeded; COLUMN [SQLState:42000, ISC error code:336397260] at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:308) at org.jumpmind.db.platform.firebird.FirebirdJdbcSqlTemplate.translate(FirebirdJdbcSqlTemplate.java:68) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:297) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:504) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:357) at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:231) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.install(AbstractSymmetricDialect.java:200) at org.jumpmind.symmetric.db.firebird.Firebird21SymmetricDialect.createRequiredDatabaseObjects(Firebird21SymmetricDialect.java:42) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:181) at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:460) at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:433) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:619) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:607) at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:259) at org.jumpmind.symmetric.web.SymmetricEngineStarter.run(SymmetricEngineStarter.java:42) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:840) Caused by: java.sql.SQLSyntaxErrorException: CREATE FUNCTION SYM_HEX failed; Dynamic SQL Error; SQL error code = -204; Data type unknown; Implementation limit exceeded; COLUMN [SQLState:42000, ISC error code:336397260] at org.firebirdsql.gds.ng.FbExceptionBuilder$Type$1.createSQLException(FbExceptionBuilder.java:534) at org.firebirdsql.gds.ng.FbExceptionBuilder.toFlatSQLException(FbExceptionBuilder.java:304) at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readStatusVector(AbstractWireOperations.java:140) at org.firebirdsql.gds.ng.wire.AbstractWireOperations.processOperation(AbstractWireOperations.java:204) at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readSingleResponse(AbstractWireOperations.java:171) at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readResponse(AbstractWireOperations.java:155) at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readGenericResponse(AbstractWireOperations.java:257) at org.firebirdsql.gds.ng.wire.AbstractFbWireDatabase.readGenericResponse(AbstractFbWireDatabase.java:201) at org.firebirdsql.gds.ng.wire.version11.V11Statement.prepare(V11Statement.java:89) at org.firebirdsql.jdbc.FBStatement.prepareFixedStatement(FBStatement.java:898) at org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement(AbstractPreparedStatement.java:779) at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:142) at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:48) at org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:791) at org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:704) at org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:696) at org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:296) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:696) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:696) at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:377) at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:357) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:502) ... 14 more Caused by: org.firebirdsql.jdbc.FBSQLExceptionInfo: CREATE FUNCTION SYM_HEX failed 2024-05-30 10:16:55,138 INFO [aktualizace_corp-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Stopping SymmetricDS externalId=001 version=3.14.15 database=Firebird 5.0 2024-05-30 10:16:55,139 INFO [aktualizace_corp-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] | ||||
| Tags | dialect: firebird | ||||