Comments (6)
I'm not sure I understand the issue. Is the problem that the UUID converter doesn't work across databases?
from sql2o.
every time you pass UUID to PreparedStatement you need uuid2bytesArray translation
every time you read UUID from ResultSet you need bytesArray2uuid translation
the problem: for the same UUID MSSQL and Oracle has different byte order in bytesArray.
from sql2o.
Ahh gotcha. This sounds like a great candidate for Quirks
.
from sql2o.
the probjem is not Oracle vs MSSQL
the problem is Database with native UUID column type vs Database where UUID is stored just as byteArray
from sql2o.
Any progress on this? I have a postgres db with a UUID and no idea how to use it with sql2o. I get a NPE on addParameter("uuid", UUID.randomUUID())
and addParameter("uuid", UUID.randomUUID().toString())
from sql2o.
After the introduction of bidirectional converters, a UUID converter will convert both parameters and results. So the specifics of this issue has been fixed for some time now. The UUID datatype works out of the box for Postgres, without any specific converter. @ftomassetti I think you have a different error? Check out this postgres test.
Instead of keeping this issue open, I have created new issues to add UUID converters for Oracle, MsSql and DB2.
#195 #196 #197
from sql2o.
Related Issues (20)
- When in jar file I receive No suitable driver for error HOT 1
- Publish version 1.6.0 of oracle extensions
- sql2o can't rolback ? HOT 3
- can i change the Type of return value of executeAndFetch()
- State of the Project
- NPE when return query object is of type Map HOT 1
- How to correctly insert with array type (ex bigint[]) columns?
- Library uses now-private reflection mechanism HOT 2
- Can't add ON DELETE CASCADE to forein key when creating table, using PostgreSQL. HOT 1
- Updated MySQL 8.0.26 connector breaks historically working code HOT 2
- Next release HOT 2
- MethodSetter setProperty failing with generic IllegalArgumentException
- Failed test testAllTypes(org.sql2o.reflect.ReflectionFieldSetterFactoryTest) only in Maven HOT 2
- Collection of enums is not properly mapped to query params HOT 1
- SQL2o 1.6.0 Compatabile with JDK 17/ OpenJDK 17 ? HOT 1
- SQL with ? for parameters HOT 4
- Retrieving List<Long> from query HOT 2
- Query.withParams upgrade HOT 2
- Javadoc has an issue with the CDN HOT 1
- In v1.7.0, kotlin data class is no longer recognized as pojo HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sql2o.