78 Commits

Author SHA1 Message Date
Aleksandar Fabijanic
9530a77347
Insert NULL using BULK #4001 (#4755)
* fix(ODBC): Insert NULL using BULK #4001
resolve bound types and sizes at compile time

* fix: remove string suffix for static_assert

* Insert NULL using BULK #4001

* fix: typo

* fix(SQLite): missing functions; consolidate extract calls

* chore(SQLite): remove unnecessary typedef

* fix(SQLite): remove duplicate functions

* fix(SQLite): compile errors and warnings

* fix(SQLite): extract implementation signatures

* fix(SQLite): long64 platforms compile errors

* fix(SQLite): long64 platforms compile errors, part ii

* fix(ODBC): windows build

* fix(ODBC): MSSQL big string on windows

* fix(Data): psql and mysql compile errors

* fix(PostgreSQL): add missing functions

* fix(ODBC): revert column size discovery (breaks Oracle)

* fix(PostgreSQL): Nullable extraction #4001

* fix(MySQL): Nullable extraction #4001

* chore(Data): code tidy up

* fix(ODBC): add missing changes
2024-11-11 18:23:21 +01:00
Aleksandar Fabijanic
36c808230c
fix(ODBC): Poco:Data::ODBC - MSSQL (n)varchar(max) length issue #4324 (#4738)
* fix(ODBC): Poco:Data::ODBC - MSSQL (n)varchar(max) length issue #4324

* chore(ODBC): remove unused vars; fix SQL Server SDK include path #4324

* fix(ODBC): trim UTF16 string #4324

* chore(ODBC): add compile time big string diagnostics #4324

* chore(ODBC): add SQLServer big string vector test case #4324

* fix(ODBC): detect SQLServer header #4324

* chore: add listing msodbdcsql18 folder #4324

* ci: change odbc drivers installation order #4324

* chore(CMake): Add option ENABLE_DATA_SQL_SERVER_BIG_STRINGS, auto-detection of msodbcsql.h on Linux and macOS

* fix(ODBC): detect backend at runtime for string size; add Session::dbmsName() #4324

* fix(ODBC): wrong char to string conversion #4324

---------

Co-authored-by: cunj123 <n.belusic@pta.hr>
Co-authored-by: Matej Kenda <matejken@gmail.com>
2024-10-19 21:43:00 +02:00
Aleksandar Fabijanic
88c4958032
Serializable Isolation level for SQLite Databases (#4693)
* fix #4536
I've add transaction isolation support for SQLite
Warning! SQLite transactions are [serializable by design](https://
www.sqlite.org/isolation.html) but my implementation retuns false in
function hasTransactionIsolation and throw an exception in
setTransactionIsolation

* disable shared cache in TearDown()

* chore(doc): reword documentation

* we should waitresult of select before rollback (#4718)

---------

Co-authored-by: Alexander B <ale.bychuk@gmail.com>
2024-10-10 10:41:02 +02:00
Matej Kenda
f24547cdcf enh(Poco): Mark deprecated functionality with C++ attributes and resolve internal usage of deprecated functions (#4551)
* enh(poco): Replace deprecated comments with C++ deprecated attribute.

* enh(Poco): Replace some deprecated functionality in Poco sources. (#4426)

* enh(Poco): Replace more deprecated functionality in Poco sources. (#4426)

* fix(CMake): Variable BUILD_SHARED_LIBS must be defined properly to create valid binaries.

* enh: Code improvements done while resolving deprecated functionality (#4426)

* Un-deprecate LocalDateTme (#4426)

* enh(Poco): Replace usage of deprecated functionality with other functions/classes (#4426)

* chore(SSL): temporarily un-deprecate SSL-related functionality (#4426)

* chore(SSL): temporarily un-deprecate old MongoDB protocol functionality (#4426)

* enh(Poco): Minor Hash improvements (#4426)

* enh(Foundation): Compile deprecated hash tests only when POCO_TEST_DEPRECATED is enabled (#4426)

* enh(Net): Compile deprecated Socket::select functionality only when POCO_TEST_DEPRECATED is enabled (#4426)

* enh(Bonjour): Replace deprecated Socket::select with PollSet (#4426)

* enh(Poco): Introduce POCO_DEPRECATED macro to have the ability to disable deprecation warnings in applications (#4426)

* test(ODBC): add few asserts to testStoredProcedureDynamicVar

* fix(ODBC): rename DynamicAny -> DynamicVar in tests

* fix(ODBC): make Dignostics static members inline to prevent explicit instantiation warnings on windows

---------

Co-authored-by: Alex Fabijanic <alex@pocoproject.org>
2024-07-29 08:37:35 +02:00
John Vandenberg
0e6e16645c
Remove trailing whitespace (#3668) 2022-07-07 04:18:20 -05:00
Alex Fabijanic
d93a1885a1 fix(SQLite): windows build (global var does not link) #3018 2022-05-29 23:36:07 -05:00
Alex Fabijanic
e25a8b3ec7 chore(SQLite): fix enum names case for #3018 2022-05-29 22:18:38 -05:00
Maksim Kita
5c29df0860
Added support for SQLite transaction types using Session property (#3018) 2022-05-29 22:06:48 -05:00
Günter Obiltschnig
7569ccf82b #3318: Data: Support Poco::UUID for data binding 2021-06-19 08:40:49 +02:00
Günter Obiltschnig
aa46e9b6e4 fixed type overloads 2020-01-09 18:02:29 +01:00
Günter Obiltschnig
03d1dd9822 fixes for macos/clang 2020-01-09 11:53:03 +01:00
Vojtěch Erben
8f2fef23e4 Rename methods
resetConnection() -> reset()
2018-11-20 10:09:40 +01:00
Vojtěch Erben
6e6ad28a1f Reset connection when a session is returned to the SessionPool 2018-11-14 15:50:17 +01:00
Aleksandar Fabijanic
8d95644bad
SQLite Notifier has no table information #1687 (#2540) 2018-11-13 07:23:37 -06:00
Alex Fabijanic
55e56b668d data fixes (getters constness, string any handling) 2018-05-07 15:23:19 +00:00
Alex Fabijanic
52cc7e669d Data/SQLite: Exception messages contain duplicate text #2012 2017-11-29 19:40:21 -06:00
Alex Fabijanic
94e9f2eec2 getConnectionTimeout of SQLite DB wrapper returns wrong value (in milliseconds, should be in seconds) #1729 2017-10-12 20:46:53 -05:00
Günter Obiltschnig
04e7e04d4d Remove \$Id`$ headers 2017-09-09 11:14:06 +02:00
Guenter Obiltschnig
6548da5678 fixed docs 2017-02-18 14:03:55 +01:00
Guenter Obiltschnig
b3a503c13e removed automatic Connector registration in ODBC and SQLite 2016-03-01 17:40:58 +01:00
Aleksandar Fabijanic
86b81bfcbd GH #499: Poco::Data::Statement::execute returns wrong value when zero results (ODBC) 2014-12-17 23:36:26 -06:00
Guenter Obiltschnig
c49a954a8d workaround for GH #578 2014-12-17 09:20:52 +01:00
Guenter Obiltschnig
85fd968a1e #538 prevent destructors from throwing exceptions 2014-09-19 10:13:03 +02:00
Günter Obiltschnig
e30ff7dd8c Merge pull request #517 from cristiantm/enh-sqlite-timeoutProperty
Adding timeout as property on SQLite
2014-09-17 19:44:46 +02:00
Christopher Baker
e469e4fc62 Fix static init exceptions for MinGW*. 2014-08-21 14:27:51 -05:00
Cristian Thiago Moecke
0ba87ea2c2 Adding property to SQLite SessionImpl as solution for issue #248 2014-08-04 17:05:57 -03:00
Roger Meier
b0581433a7 LICENSE: add info about SPDX-License-Identifier usage and use it
fix: remove executable flag and change back to 100644 (was 100755)

Signed-off-by: Roger Meier <r.meier@siemens.com>
2014-05-14 08:38:09 +02:00
Roger Meier
628a06f718 LICENSE: add info about SPDX-License-Identifier usage and use it
Signed-off-by: Roger Meier <roger@bufferoverflow.ch>
2014-05-04 21:02:42 +02:00
Alex Fabijanic
7ca90c7de1 - make SQLite FTS default on non-embedded windows
- add support for SQLite thread safety configuration on POSIX platforms
- add WEC2013 support to windows Powersjhell build script
2014-04-19 12:59:50 -05:00
Alex Fabijanic
0a54661bb0 - added optional SQLite Full Text Search support
- Powershell build fixes:
  1) Add platform for MSbuild
  2) fixed omit array handling
2014-04-18 21:32:30 -05:00
Guenter Obiltschnig
835845422c minor performance improvement, better workaround for clang issue with handle property 2014-04-18 21:27:46 +02:00
Pascal Bach
1e22982ad8 Fix missing ")" in SQLite Connector for windows 2014-03-27 11:29:50 +01:00
Günter Obiltschnig
b2ba1dfb74 -added Windows Embedded Compact 2013 support 2014-03-17 14:36:17 +01:00
Aleksandar Fabijanic
a50823c5a8 data housekeeping
- removed naked pointers from Data interfaces
- fixed GH #82: name conflict in Data::Keywords::bind
- fixed GH #157: MySQL: cannot bind to 'long' data type on
Windows/Visual C++
- fixed GH #158: MySQL: MYSQL_BIND 'is_unsigned' member is not set
2013-04-28 12:34:07 -05:00
aleks-f
6943505634 SQLite event notifier
Notifier is SQLite DB event (insert, update, delete, commit, rollback)
callback wrapper.
2013-02-20 16:35:42 -06:00
aleks-f
c1af36b973 delete from table optimization comment 2013-02-18 10:48:05 -06:00
Alex
6cae42a29c clang fixes 2013-02-17 16:11:09 -06:00
aleks-f
9ea546d981 more callbacks and transaction tests
- added callbacks for commit and rollback with tests
- added transaction tests
2013-02-17 15:12:07 -06:00
aleks-f
93c9e83e8d SQLite update event handling 2013-02-10 22:27:16 -06:00
aleks-f
4bcddad43e auto-init for db back-ends
Auto initialization for all DB back-ends and some tidy-up for network
windows auto initialization
2013-02-10 09:06:54 -06:00
aleks-f
d6042065ec Auto init for Net and SQLite (win)
Auto init for Net and SQLite (only tested on Windows)
2013-02-09 22:39:07 -06:00
aleks-f
76a7e2e716 GH56: Need a way to disable *_API macros with GCC
GH #56: Need a way to disable *_API macros with GCC
2013-01-13 10:31:21 -06:00
aleks-f
ba70e7f734 fixed and improved thread mode set/test
fixed and improved threading mode setting and testing/benchmarking
2012-12-23 15:27:32 -06:00
aleks-f
760fa4bbb0 see CHANGELOG
- upgraded SQLite to version 3.7.15.1 (2012-12-19)
- fixed SQLite affectedRows reporting and added tests
- added SQLite::Utility::isThreadSafe() function
- added SQLite::Utility::setThreadMode(int mode) function
- fixed GH #41: Buffer::resize crash
2012-12-23 02:36:01 -06:00
aleks-f
ef9cda6666 GH #26: Cannot compile on gcc
GH #26: Cannot compile on gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3 using
compiler flag pedantic
2012-12-12 23:02:20 -06:00
Alex
560908b715 SF #97 fix c++0x / clang++ bugs 2012-12-11 22:29:33 -06:00
aleks-f
eaa74307a6 see CHANGELOG
- added Poco::istring (case-insensitive string) and Poco::isubstr
(case-insensitive substring search)
- improved SQLite execute() return (affected rows) value
- added SQLite sys.dual (in-memory system table)
- applied SF Patch #120: The ExpireLRUCache does not compile with a
tuple as key on Visual Studio 2010
- fixed SF Bug #599: JSON::Array and JSON::Object size() member can
implicitly lose precision
- fixed SF Bug #602: iterating database table rows not correct if no
data in table
- fixed SF Bug #603: count() is missing in HashMap
- fixed GH #23: JSON::Object::stringify throw BadCastException
- fixed GH #16: NetworkInterface::firstAddress() should not throw on
unconfigured interfaces
- Android compile/build support (by Rangel Reale)
- TypeHandler::prepare() now takes const-reference
2012-12-04 23:33:44 -06:00
Aleksandar Fabijanic
883de9670a Windows/VS2011 build all configs 2012-09-23 06:28:42 +00:00
Aleksandar Fabijanic
f7bd6a8fec OSX compile g++/clang Data,ODBC,SQLite 2012-09-21 05:06:37 +00:00
Aleksandar Fabijanic
69be5d7e98 - VS 80 build & OS version detection
- SF #3564756: iOS trunk compile fix
2012-09-11 02:02:23 +00:00