Comments (5)
Different projects have different type standarts|convections (VARCHAR vs NVARCHAR, CLOB vs NCLOB).
This could be solved by extracting the logic that translates column name into property name to an interface using strategy pattern. ColumnNamingStrategy
or similar. The ColumnNamingStrategy would be a part an Sql2o instance.
Different projects have different type standarts|convections (VARCHAR vs NVARCHAR, CLOB vs NCLOB).
Could you explain this better? I don't see what it has to do with the java code if you use CHAR type or NCHAR type in the database?
from sql2o.
Could you explain this better? I don't see what it has to do with the java code if you use CHAR type or NCHAR type in the database?
example: clobs are NClobs, Strings are NStrings:
setParameter(PreparedStatement ps, int index, String value)->ps.setNString(index,value);
from sql2o.
i.e. for same DB in different projects you need to call setNString|getNString
for other projects you need setString|getString
from sql2o.
I just want to say Quirks is not just DB-related but concrete JDBC-driver + project related
from sql2o.
I will closed this issue.
We can provide some common quirks implementations, but if developers have special needs, they will have to create their own quirks implementation.
from sql2o.
Related Issues (20)
- Issue with ArrayParameters.updateQueryWithArrayParameters when query contains '?' character
- 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
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.