Comments (1)
I am having a similar issue but it's a little bit different. If I have one class that hasMany of another, using discriminator multi-tenancy, and I do an 'in' query like (can be a criteria or where query)
SomeObject.where {
childObjects in childObject
}
I get a sql error exception, the sql is not properly filling in the in query value causing this exception:
java.sql.SQLException: No value specified for parameter 4
The sql looks like this:
select
some cols
from
some_object this_
where
? = this_.tenant_id
and this_.date_created=?
and this_.id in (
?
) limit ?
values:
TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [sometenant]
TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [TIMESTAMP] - [null]
ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - No value specified for parameter 4
Actually, it's not even making the right query, it should be joining the child table instead it appears to be doing an 'in' query on the parent tables ID. This is problem related but a little different, so I can raise a separate issue with a different example of code.
from gorm-hibernate5.
Related Issues (20)
- NullPointerException at org.grails.orm.hibernate.cfg.GrailsDomainBinder.bindSubClass(GrailsDomainBinder.java:1508) HOT 2
- Slow application startup time due to increased datasource configuration time HOT 2
- GORM multitenancy - no transaction is in progress HOT 1
- Multi tenancy with multiple datasources is not working
- Setup DataSource early to take advantage of AutoConfiguration
- Trivial: typos in GormEntity.groovy
- Domain Merge does not flush dirty fields to datastore HOT 2
- Make 'org.grails.orm.hibernate.GrailsSessionContext.allowCreate' configurable HOT 2
- When validating domain object, default dataSource sessionFactory is used instead of defined one. HOT 3
- Domain subclass does not inherit caching from parent HOT 1
- No Session found for current thread in spring boot test HOT 2
- Second level cache (still?) not working for inherited domains HOT 11
- Using size() for collection associations in where-queries or detached criteria leads to exception
- Domain class mapping with `fetch: 'join'` on OneToOne association results in n+1 queries HOT 2
- how to support springboot 3.x ? HOT 3
- Release 8.0.0 depends on grailsVersion 6.0.0-SNAPSHOT HOT 1
- Multitenant - Discriminator - @CurrentTenant not honored if session created by SessionFactory.currentSession HOT 4
- application.groovy in standalone mode is not read HOT 9
- Section 5.4.2 strange index operator <<0>>
- Spring @Transactional not applied for GORM methods in java 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 gorm-hibernate5.