I meet a problem about ibatis' dynamic sql mapping. My db query is implemented by store procedure, and this procedure will go to sub procedure A or B depends on some condition. Now here comes the problem, sub procedure A will return column "price_category" and it will be mapped to property "priceCategory" by ibatis' resultMap, however sub procedure B will not return column "price_category" and ibatis will throw exception since mapping can not be done. So my thinking is to resolve this by dynamic mapping, which means ibatis will set "priceCategory" to null in resultMap if sql doesn't return column "price_category". Could this be implemented by some config tricks in ibatis? I think ibatis should have been able to do this however I didn't find related information in other places. Could you give me some points on this? Thanks guys.
1
There are 1 best solutions below
Related Questions in JAVA
- I need the BIRT.war that is compatible with Java 17 and Tomcat 10
- Creating global Class holder
- No method found for class java.lang.String in Kafka
- Issue edit a jtable with a pictures
- getting error when trying to launch kotlin jar file that use supabase "java.lang.NoClassDefFoundError"
- Does the && (logical AND) operator have a higher precedence than || (logical OR) operator in Java?
- Mixed color rendering in a JTable
- HTTPS configuration in Spring Boot, server returning timeout
- How to use Layout to create textfields which dont increase in size?
- Function for making the code wait in javafx
- How to create beans of the same class for multiple template parameters in Spring
- How could you print a specific String from an array with the values of an array from a double array on the same line, using iteration to print all?
- org.telegram.telegrambots.meta.exceptions.TelegramApiException: Bot token and username can't be empty
- Accessing Secret Variables in Classic Pipelines through Java app in Azure DevOps
- Postgres && statement Error in Mybatis Mapper?
Related Questions in ORM
- SQL schema for a fill-in-the-blank exercise
- ERROR: column "country" is of type text[] but expression is of type record (SQLSTATE 42804)
- JPA Hibernate OneToOne Mapping
- query in objects with django orm with a containing sentence
- peewee: SQLite - peewee Create() is forcing integer in PrimaryKeyField if leading character is numeric (even if there is a non-numeric in the middle)
- PHP ORM DOCTRINE
- Error appending to array oOnConflictUpdaste using Drizzle ORM (Postgresql)
- Sequelize foreign key vs SQL how to implement it
- How do i work with a potentially nullable field in prisma ORM and MongoDB that references the id of another model?
- record doesn't exist error when creating a new record
- Several relationships in one model in Laravel
- SQLALCHEMY ORM - error when using variables both for column, value in WHERE
- How to exclude instances with empty querysets in prefetch_related?
- Optimize SqlAlchemy ORM DB models
- What are the best practices regarding SSR, Django and temprarly changed data?
Related Questions in IBATIS
- Why can't I correctly use ibatis
- Error initializing TransactionManager. Could not instantiate TransactionConfig
- java Myabtis exceptionjava Myabtis exceptionjava Myabtis exception
- SQL state [99999]; error code [17068] nested exception is java.sql.SQLException:
- How to truncate all tables using a SQL query
- CreateOracleArray of OracleConnection always create an array internally null
- ORA-06550: row 1, column 7: PLS-00306: ORA-06550: wrong number or types of arguments
- How to create performance listener for MyBatis statements
- Generatedkey in DB2
- MyBatis accessing method parameter in subquery
- iBatis query object with a nested list of objects
- how to insert query in mybatis with parameter list?
- How to make null must error if input is empty in mybatis?
- The attribute id is undefined for the annotation type Results using Mybatis
- Ibatis filling up Nested object in Java
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You could have procedure B return a dummy column with null values. For example: