Comments (3)
I'm not sure this needs to be built in to sql2o. I think people who want this could add a custom converter like this:
public class ArrayXmlConverter implements Converter<byte[]> {
public byte[] convert(Object val) throws ConverterException {
// get XML from Clob and return byte[]
}
public Object toDatabaseParam(byte[] val) {
// convert to XML string and return Clob
}
}
The current NamedParameterStatement
doesn't support setClob()
directly, but setObject
may work for a java.sql.Clob
, I'm not sure
from sql2o.
Yes, this can be done via extension
In my closed-source ORM I use ParamSetter
interface. ParamSetterFactory is provided by Quirks
since different Databases and JDBC drivers works different (Timestamp for DB2 is a good example)
from sql2o.
Yes once the quirks PR is merged, this will work fine:
public class MyQuirks extends NoQuirks {
@Override
public Map<Class, Converter> customConverters() {
Map<Class, Converter> converters = new HashMap<Class, Converter>();
converters.put(byte[].class, new ArrayXmlConverter());
// add other custom converters
return converters;
}
}
I think I'll close this issue because the quirks + two-way converter will solve it. Are you ok with that?
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.