mORMot Open Source

yoanq

Member

Registered: 2013-01-03

Posts: 24

Problem with External DataBase using Oracle

Hi, ab

We use Interface base service using external database Oracle. Previous use Oracle version 11.2.0.1 64 bits using client Oracle 11.2.0.1 32 bits. It's all ok. Now we have install Oracle 11.2.0.3 64 bits with the same client and the system it's not running.

Unit SynSQLite3 method TSQLDataBase.DBOpen line result := sqlite3.open(pointer(utf8),fDB); Return code 14.

This is the log generated

20140530 12544412  !  +    00082095 SynSQLite3.TSQLDatabase.DBOpen (3438)
20140530 12564731  ! ERROR     TSQLDatabase(0260FB10) open("data\Server.db3") failed stack trace API 0008215C SynSQLite3.TSQLDatabase.DBOpen (3452) 000815E4 SynSQLite3.TSQLDatabase.Create (3008) 000845FB mORMotSQLite3.TSQLRestServerDB.Create (729) 002284D9 WebServerApi.TWebServerServiceApi.DoStart (250) 00228F8B WebServerApi.CheckParameters (435)
20140530 12564731  !  -    99.300.141
20140530 12564902  ! EXC   ESQLite3Exception ("Invalid SQlite3 database handle (14)") at 000815FF SynSQLite3.TSQLDatabase.Create (3011)  stack trace API 00046EB0 SynCommons.SynRtlUnwind (38196) 00003F3C System.@HandleAnyException 000815FF SynSQLite3.TSQLDatabase.Create (3011) 000845FB mORMotSQLite3.TSQLRestServerDB.Create (729) 002284D9 WebServerApi.TWebServerServiceApi.DoStart (250) 00228F8B WebServerApi.CheckParameters (435)
20140530 12564902  ! EXC   ESQLite3Exception ("Invalid SQlite3 database handle (14)") at 000815FF SynSQLite3.TSQLDatabase.Create (3011)  stack trace API 00046EB0 SynCommons.SynRtlUnwind (38196) 00003F3C System.@HandleAnyException 000815FF SynSQLite3.TSQLDatabase.Create (3011) 000845FB mORMotSQLite3.TSQLRestServerDB.Create (729) 002284D9 WebServerApi.TWebServerServiceApi.DoStart (250) 00228F8B WebServerApi.CheckParameters (435)
20140530 12564902  ! info  TSQLRestServerDB(02555DB0) null
20140530 12564902  ! EXC   ESQLite3Exception ("Invalid SQlite3 database handle (14)") at 000815FF SynSQLite3.TSQLDatabase.Create (3011)  stack trace API 00046EB0 SynCommons.SynRtlUnwind (38196) 000043A2 System.@ExceptionHandler 000815FF SynSQLite3.TSQLDatabase.Create (3011) 000845FB mORMotSQLite3.TSQLRestServerDB.Create (729) 002284D9 WebServerApi.TWebServerServiceApi.DoStart (250) 00228F8B WebServerApi.CheckParameters (435)

yoanq

Member

Registered: 2013-01-03

Posts: 24

Re: Problem with External DataBase using Oracle

Don't worry. It's our mistake.

Mormot is a great framework.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Problem with External DataBase using Oracle