You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@camel.apache.org by pp...@apache.org on 2020/09/07 19:17:51 UTC

[camel-quarkus] 03/05: MyBatis JVM support

This is an automated email from the ASF dual-hosted git repository.

ppalaga pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/camel-quarkus.git

commit 1e405cb2a6cbe0b50ec6a298347113e7eedce52c
Author: Peter Palaga <pp...@redhat.com>
AuthorDate: Mon Sep 7 18:05:00 2020 +0200

    MyBatis JVM support
---
 catalog/pom.xml                                    |  13 ++
 docs/modules/ROOT/nav.adoc                         |   1 +
 docs/modules/ROOT/pages/reference/components.adoc  |   6 +
 .../ROOT/pages/reference/extensions/mybatis.adoc   |  30 +++++
 docs/modules/ROOT/pages/reference/index.adoc       |   3 +
 extensions-jvm/mybatis/deployment/pom.xml          |  63 ++++++++++
 .../mybatis/deployment/MybatisProcessor.java       |  46 +++++++
 extensions-jvm/mybatis/integration-test/pom.xml    | 104 ++++++++++++++++
 .../component/mybatis/it/MybatisResource.java      |  64 ++++++++++
 .../component/mybatis/it/bean/AccountService.java  |  41 ++++++
 .../component/mybatis/it/entity/Account.java       |  61 +++++++++
 .../src/main/resources/SqlMapConfig.xml            |  55 ++++++++
 .../component/mybatis/it/entity/Account.xml        | 138 +++++++++++++++++++++
 .../quarkus/component/mybatis/it/MybatisTest.java  |  42 +++++++
 extensions-jvm/mybatis/pom.xml                     |  40 ++++++
 extensions-jvm/mybatis/runtime/pom.xml             |  94 ++++++++++++++
 .../main/resources/META-INF/quarkus-extension.yaml |  32 +++++
 extensions-jvm/pom.xml                             |   1 +
 poms/bom/pom.xml                                   |  15 +++
 19 files changed, 849 insertions(+)

diff --git a/catalog/pom.xml b/catalog/pom.xml
index 4ab86bb..1139f9a 100644
--- a/catalog/pom.xml
+++ b/catalog/pom.xml
@@ -2181,6 +2181,19 @@
         </dependency>
         <dependency>
             <groupId>org.apache.camel.quarkus</groupId>
+            <artifactId>camel-quarkus-mybatis</artifactId>
+            <version>${project.version}</version>
+            <type>pom</type>
+            <scope>test</scope>
+            <exclusions>
+                <exclusion>
+                    <groupId>*</groupId>
+                    <artifactId>*</artifactId>
+                </exclusion>
+            </exclusions>
+        </dependency>
+        <dependency>
+            <groupId>org.apache.camel.quarkus</groupId>
             <artifactId>camel-quarkus-nagios</artifactId>
             <version>${project.version}</version>
             <type>pom</type>
diff --git a/docs/modules/ROOT/nav.adoc b/docs/modules/ROOT/nav.adoc
index 0f491d5..bff048e 100644
--- a/docs/modules/ROOT/nav.adoc
+++ b/docs/modules/ROOT/nav.adoc
@@ -178,6 +178,7 @@
 *** xref:reference/extensions/mongodb.adoc[MongoDB]
 *** xref:reference/extensions/mongodb-gridfs.adoc[MongoDB GridFS]
 *** xref:reference/extensions/mustache.adoc[Mustache]
+*** xref:reference/extensions/mybatis.adoc[MyBatis]
 *** xref:reference/extensions/nagios.adoc[Nagios]
 *** xref:reference/extensions/nats.adoc[Nats]
 *** xref:reference/extensions/netty.adoc[Netty]
diff --git a/docs/modules/ROOT/pages/reference/components.adoc b/docs/modules/ROOT/pages/reference/components.adoc
index b7df960..daf9463 100644
--- a/docs/modules/ROOT/pages/reference/components.adoc
+++ b/docs/modules/ROOT/pages/reference/components.adoc
@@ -565,6 +565,12 @@ Stable | 1.0.0 | Interact with MongoDB GridFS.
 | xref:reference/extensions/mustache.adoc[Mustache] | [.camel-element-artifact]##camel-quarkus-mustache## | [.camel-element-Native]##Native## +
 Stable | 1.0.0 | Transform messages using a Mustache template.
 
+| xref:reference/extensions/mybatis.adoc[MyBatis] | [.camel-element-artifact]##camel-quarkus-mybatis## | [.camel-element-JVM]##JVM## +
+Preview | 1.1.0 | Performs a query, poll, insert, update or delete in a relational database using MyBatis.
+
+| xref:reference/extensions/mybatis.adoc[MyBatis Bean] | [.camel-element-artifact]##camel-quarkus-mybatis## | [.camel-element-JVM]##JVM## +
+Preview | 1.1.0 | Perform queries, inserts, updates or deletes in a relational database using MyBatis.
+
 | xref:reference/extensions/nagios.adoc[Nagios] | [.camel-element-artifact]##camel-quarkus-nagios## | [.camel-element-JVM]##JVM## +
 Preview | 1.1.0 | Send passive checks to Nagios using JSendNSCA.
 
diff --git a/docs/modules/ROOT/pages/reference/extensions/mybatis.adoc b/docs/modules/ROOT/pages/reference/extensions/mybatis.adoc
new file mode 100644
index 0000000..006042b
--- /dev/null
+++ b/docs/modules/ROOT/pages/reference/extensions/mybatis.adoc
@@ -0,0 +1,30 @@
+// Do not edit directly!
+// This file was generated by camel-quarkus-maven-plugin:update-extension-doc-page
+
+[[mybatis]]
+= MyBatis
+:page-aliases: extensions/mybatis.adoc
+
+[.badges]
+[.badge-key]##Since Camel Quarkus##[.badge-version]##1.1.0## [.badge-key]##JVM##[.badge-supported]##supported## [.badge-key]##Native##[.badge-unsupported]##unsupported##
+
+Performs a query, poll, insert, update or delete in a relational database using MyBatis.
+
+== What's inside
+
+* https://camel.apache.org/components/latest/mybatis-component.html[MyBatis component], URI syntax: `mybatis:statement`
+* https://camel.apache.org/components/latest/mybatis-bean-component.html[MyBatis Bean component], URI syntax: `mybatis-bean:beanName:methodName`
+
+Please refer to the above links for usage and configuration details.
+
+== Maven coordinates
+
+[source,xml]
+----
+<dependency>
+    <groupId>org.apache.camel.quarkus</groupId>
+    <artifactId>camel-quarkus-mybatis</artifactId>
+</dependency>
+----
+
+Check the xref:user-guide/index.adoc[User guide] for more information about writing Camel Quarkus applications.
diff --git a/docs/modules/ROOT/pages/reference/index.adoc b/docs/modules/ROOT/pages/reference/index.adoc
index b193cf2..680e641 100644
--- a/docs/modules/ROOT/pages/reference/index.adoc
+++ b/docs/modules/ROOT/pages/reference/index.adoc
@@ -512,6 +512,9 @@ Stable | 1.0.0 | Interact with MongoDB GridFS.
 |  xref:reference/extensions/mustache.adoc[Mustache]  | camel-quarkus-mustache | [.camel-element-Native]##Native## +
 Stable | 1.0.0 | Transform messages using a Mustache template.
 
+|  xref:reference/extensions/mybatis.adoc[MyBatis]  | camel-quarkus-mybatis | [.camel-element-JVM]##JVM## +
+Preview | 1.1.0 | Performs a query, poll, insert, update or delete in a relational database using MyBatis.
+
 |  xref:reference/extensions/nagios.adoc[Nagios]  | camel-quarkus-nagios | [.camel-element-JVM]##JVM## +
 Preview | 1.1.0 | Send passive checks to Nagios using JSendNSCA.
 
diff --git a/extensions-jvm/mybatis/deployment/pom.xml b/extensions-jvm/mybatis/deployment/pom.xml
new file mode 100644
index 0000000..c4567e6
--- /dev/null
+++ b/extensions-jvm/mybatis/deployment/pom.xml
@@ -0,0 +1,63 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+
+    Licensed to the Apache Software Foundation (ASF) under one or more
+    contributor license agreements.  See the NOTICE file distributed with
+    this work for additional information regarding copyright ownership.
+    The ASF licenses this file to You under the Apache License, Version 2.0
+    (the "License"); you may not use this file except in compliance with
+    the License.  You may obtain a copy of the License at
+
+         http://www.apache.org/licenses/LICENSE-2.0
+
+    Unless required by applicable law or agreed to in writing, software
+    distributed under the License is distributed on an "AS IS" BASIS,
+    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+    See the License for the specific language governing permissions and
+    limitations under the License.
+
+-->
+<project xmlns="http://maven.apache.org/POM/4.0.0"
+         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
+    <modelVersion>4.0.0</modelVersion>
+    <parent>
+        <groupId>org.apache.camel.quarkus</groupId>
+        <artifactId>camel-quarkus-mybatis-parent</artifactId>
+        <version>1.1.0-SNAPSHOT</version>
+        <relativePath>../pom.xml</relativePath>
+    </parent>
+
+    <artifactId>camel-quarkus-mybatis-deployment</artifactId>
+    <name>Camel Quarkus :: MyBatis :: Deployment</name>
+
+    <dependencies>
+        <dependency>
+            <groupId>org.apache.camel.quarkus</groupId>
+            <artifactId>camel-quarkus-core-deployment</artifactId>
+        </dependency>
+        <dependency>
+            <groupId>org.apache.camel.quarkus</groupId>
+            <artifactId>camel-quarkus-mybatis</artifactId>
+        </dependency>
+    </dependencies>
+
+    <build>
+        <plugins>
+            <plugin>
+                <groupId>org.apache.maven.plugins</groupId>
+                <artifactId>maven-compiler-plugin</artifactId>
+                <configuration>
+                    <annotationProcessorPaths>
+                        <path>
+                            <groupId>io.quarkus</groupId>
+                            <artifactId>quarkus-extension-processor</artifactId>
+                            <version>${quarkus.version}</version>
+                        </path>
+                    </annotationProcessorPaths>
+                </configuration>
+            </plugin>
+        </plugins>
+    </build>
+
+</project>
diff --git a/extensions-jvm/mybatis/deployment/src/main/java/org/apache/camel/quarkus/component/mybatis/deployment/MybatisProcessor.java b/extensions-jvm/mybatis/deployment/src/main/java/org/apache/camel/quarkus/component/mybatis/deployment/MybatisProcessor.java
new file mode 100644
index 0000000..9a9bbd6
--- /dev/null
+++ b/extensions-jvm/mybatis/deployment/src/main/java/org/apache/camel/quarkus/component/mybatis/deployment/MybatisProcessor.java
@@ -0,0 +1,46 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.apache.camel.quarkus.component.mybatis.deployment;
+
+import io.quarkus.deployment.annotations.BuildStep;
+import io.quarkus.deployment.annotations.ExecutionTime;
+import io.quarkus.deployment.annotations.Record;
+import io.quarkus.deployment.builditem.FeatureBuildItem;
+import io.quarkus.deployment.pkg.steps.NativeBuild;
+import org.apache.camel.quarkus.core.JvmOnlyRecorder;
+import org.jboss.logging.Logger;
+
+class MybatisProcessor {
+
+    private static final Logger LOG = Logger.getLogger(MybatisProcessor.class);
+    private static final String FEATURE = "camel-mybatis";
+
+    @BuildStep
+    FeatureBuildItem feature() {
+        return new FeatureBuildItem(FEATURE);
+    }
+
+    /**
+     * Remove this once this extension starts supporting the native mode.
+     */
+    @BuildStep(onlyIf = NativeBuild.class)
+    @Record(value = ExecutionTime.RUNTIME_INIT)
+    void warnJvmInNative(JvmOnlyRecorder recorder) {
+        JvmOnlyRecorder.warnJvmInNative(LOG, FEATURE); // warn at build time
+        recorder.warnJvmInNative(FEATURE); // warn at runtime
+    }
+}
diff --git a/extensions-jvm/mybatis/integration-test/pom.xml b/extensions-jvm/mybatis/integration-test/pom.xml
new file mode 100644
index 0000000..05c805a
--- /dev/null
+++ b/extensions-jvm/mybatis/integration-test/pom.xml
@@ -0,0 +1,104 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+
+    Licensed to the Apache Software Foundation (ASF) under one or more
+    contributor license agreements.  See the NOTICE file distributed with
+    this work for additional information regarding copyright ownership.
+    The ASF licenses this file to You under the Apache License, Version 2.0
+    (the "License"); you may not use this file except in compliance with
+    the License.  You may obtain a copy of the License at
+
+         http://www.apache.org/licenses/LICENSE-2.0
+
+    Unless required by applicable law or agreed to in writing, software
+    distributed under the License is distributed on an "AS IS" BASIS,
+    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+    See the License for the specific language governing permissions and
+    limitations under the License.
+
+-->
+<project xmlns="http://maven.apache.org/POM/4.0.0"
+         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
+    <modelVersion>4.0.0</modelVersion>
+    <parent>
+        <groupId>org.apache.camel.quarkus</groupId>
+        <artifactId>camel-quarkus-build-parent-it</artifactId>
+        <version>1.1.0-SNAPSHOT</version>
+        <relativePath>../../../poms/build-parent-it/pom.xml</relativePath>
+    </parent>
+
+    <artifactId>camel-quarkus-mybatis-integration-test</artifactId>
+    <name>Camel Quarkus :: MyBatis :: Integration Test</name>
+    <description>Integration tests for Camel Quarkus MyBatis extension</description>
+
+    <dependencyManagement>
+        <dependencies>
+            <dependency>
+                <groupId>org.apache.camel.quarkus</groupId>
+                <artifactId>camel-quarkus-bom-test</artifactId>
+                <version>${project.version}</version>
+                <type>pom</type>
+                <scope>import</scope>
+            </dependency>
+        </dependencies>
+    </dependencyManagement>
+
+    <dependencies>
+        <dependency>
+            <groupId>org.apache.camel.quarkus</groupId>
+            <artifactId>camel-quarkus-mybatis</artifactId>
+        </dependency>
+        <dependency>
+            <groupId>io.quarkus</groupId>
+            <artifactId>quarkus-resteasy</artifactId>
+        </dependency>
+        <dependency>
+            <groupId>io.quarkus</groupId>
+            <artifactId>quarkus-jdbc-h2</artifactId>
+        </dependency>
+
+        <!-- test dependencies -->
+        <dependency>
+            <groupId>io.quarkus</groupId>
+            <artifactId>quarkus-junit5</artifactId>
+            <scope>test</scope>
+        </dependency>
+        <dependency>
+            <groupId>io.rest-assured</groupId>
+            <artifactId>rest-assured</artifactId>
+            <scope>test</scope>
+        </dependency>
+
+        <!-- The following dependencies guarantee that this module is built after them. You can update them by running `mvn process-resources -Pformat -N` from the source tree root directory -->
+        <dependency>
+            <groupId>org.apache.camel.quarkus</groupId>
+            <artifactId>camel-quarkus-mybatis-deployment</artifactId>
+            <version>${project.version}</version>
+            <type>pom</type>
+            <scope>test</scope>
+            <exclusions>
+                <exclusion>
+                    <groupId>*</groupId>
+                    <artifactId>*</artifactId>
+                </exclusion>
+            </exclusions>
+        </dependency>
+    </dependencies>
+
+    <build>
+        <plugins>
+            <plugin>
+                <groupId>io.quarkus</groupId>
+                <artifactId>quarkus-maven-plugin</artifactId>
+                <executions>
+                    <execution>
+                        <goals>
+                            <goal>build</goal>
+                        </goals>
+                    </execution>
+                </executions>
+            </plugin>
+        </plugins>
+    </build>
+</project>
diff --git a/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/MybatisResource.java b/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/MybatisResource.java
new file mode 100644
index 0000000..0a22a20
--- /dev/null
+++ b/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/MybatisResource.java
@@ -0,0 +1,64 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.apache.camel.quarkus.component.mybatis.it;
+
+import javax.enterprise.context.ApplicationScoped;
+import javax.inject.Inject;
+import javax.ws.rs.GET;
+import javax.ws.rs.Path;
+import javax.ws.rs.Produces;
+import javax.ws.rs.core.MediaType;
+import javax.ws.rs.core.Response;
+
+import org.apache.camel.CamelContext;
+import org.jboss.logging.Logger;
+
+@Path("/mybatis")
+@ApplicationScoped
+public class MybatisResource {
+
+    private static final Logger LOG = Logger.getLogger(MybatisResource.class);
+
+    private static final String COMPONENT_MYBATIS = "mybatis";
+    private static final String COMPONENT_MYBATIS_BEAN = "mybatis-bean";
+    @Inject
+    CamelContext context;
+
+    @Path("/load/component/mybatis")
+    @GET
+    @Produces(MediaType.TEXT_PLAIN)
+    public Response loadComponentMybatis() throws Exception {
+        /* This is an autogenerated test */
+        if (context.getComponent(COMPONENT_MYBATIS) != null) {
+            return Response.ok().build();
+        }
+        LOG.warnf("Could not load [%s] from the Camel context", COMPONENT_MYBATIS);
+        return Response.status(500, COMPONENT_MYBATIS + " could not be loaded from the Camel context").build();
+    }
+
+    @Path("/load/component/mybatis-bean")
+    @GET
+    @Produces(MediaType.TEXT_PLAIN)
+    public Response loadComponentMybatisBean() throws Exception {
+        /* This is an autogenerated test */
+        if (context.getComponent(COMPONENT_MYBATIS_BEAN) != null) {
+            return Response.ok().build();
+        }
+        LOG.warnf("Could not load [%s] from the Camel context", COMPONENT_MYBATIS_BEAN);
+        return Response.status(500, COMPONENT_MYBATIS_BEAN + " could not be loaded from the Camel context").build();
+    }
+}
diff --git a/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/bean/AccountService.java b/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/bean/AccountService.java
new file mode 100644
index 0000000..1f5c905
--- /dev/null
+++ b/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/bean/AccountService.java
@@ -0,0 +1,41 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.apache.camel.quarkus.component.mybatis.it.bean;
+
+import java.util.List;
+
+import org.apache.camel.quarkus.component.mybatis.it.entity.Account;
+import org.apache.ibatis.annotations.Insert;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.ResultMap;
+import org.apache.ibatis.annotations.Select;
+
+public interface AccountService {
+
+    @Select("select ACC_ID as id, ACC_FIRST_NAME as firstName, ACC_LAST_NAME as lastName"
+            + ", ACC_EMAIL as emailAddress from ACCOUNT where ACC_ID = #{id}")
+    Account selectBeanAccountById(@Param("id") int no);
+
+    @Select("select * from ACCOUNT order by ACC_ID")
+    @ResultMap("Account.AccountResult")
+    List<Account> selectBeanAllAccounts();
+
+    @Insert("insert into ACCOUNT (ACC_ID,ACC_FIRST_NAME,ACC_LAST_NAME,ACC_EMAIL)"
+            + " values (#{id}, #{firstName}, #{lastName}, #{emailAddress})")
+    void insertBeanAccount(Account account);
+
+}
diff --git a/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/entity/Account.java b/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/entity/Account.java
new file mode 100644
index 0000000..f086fd3
--- /dev/null
+++ b/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/entity/Account.java
@@ -0,0 +1,61 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.apache.camel.quarkus.component.mybatis.it.entity;
+
+public class Account {
+    private int id;
+    private String firstName;
+    private String lastName;
+    private String emailAddress;
+
+    @Override
+    public String toString() {
+        return "Account[id: " + id + " name: " + firstName + " " + lastName + " email: " + emailAddress + "]";
+    }
+
+    public int getId() {
+        return id;
+    }
+
+    public void setId(int id) {
+        this.id = id;
+    }
+
+    public String getFirstName() {
+        return firstName;
+    }
+
+    public void setFirstName(String firstName) {
+        this.firstName = firstName;
+    }
+
+    public String getLastName() {
+        return lastName;
+    }
+
+    public void setLastName(String lastName) {
+        this.lastName = lastName;
+    }
+
+    public String getEmailAddress() {
+        return emailAddress;
+    }
+
+    public void setEmailAddress(String emailAddress) {
+        this.emailAddress = emailAddress;
+    }
+}
diff --git a/extensions-jvm/mybatis/integration-test/src/main/resources/SqlMapConfig.xml b/extensions-jvm/mybatis/integration-test/src/main/resources/SqlMapConfig.xml
new file mode 100644
index 0000000..3ea2992
--- /dev/null
+++ b/extensions-jvm/mybatis/integration-test/src/main/resources/SqlMapConfig.xml
@@ -0,0 +1,55 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+
+    Licensed to the Apache Software Foundation (ASF) under one or more
+    contributor license agreements.  See the NOTICE file distributed with
+    this work for additional information regarding copyright ownership.
+    The ASF licenses this file to You under the Apache License, Version 2.0
+    (the "License"); you may not use this file except in compliance with
+    the License.  You may obtain a copy of the License at
+
+         http://www.apache.org/licenses/LICENSE-2.0
+
+    Unless required by applicable law or agreed to in writing, software
+    distributed under the License is distributed on an "AS IS" BASIS,
+    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+    See the License for the specific language governing permissions and
+    limitations under the License.
+
+-->
+<!DOCTYPE configuration
+        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
+        "http://mybatis.org/dtd/mybatis-3-config.dtd">
+
+<configuration>
+
+    <settings>
+        <setting name="useGeneratedKeys" value="false"/>
+    </settings>
+
+    <!-- Use type aliases to avoid typing the full classname every time. -->
+    <typeAliases>
+        <typeAlias alias="Account" type="org.apache.camel.quarkus.component.mybatis.it.entity.Account"/>
+        <typeAlias alias="AccountService" type="org.apache.camel.quarkus.component.mybatis.it.bean.AccountService"/>
+    </typeAliases>
+
+    <!-- setup environment with JDBC data source -->
+    <environments default="development">
+        <environment id="development">
+            <transactionManager type="JDBC"/>
+            <dataSource type="POOLED">
+                <property name="driver" value="org.h2.Driver" />
+                <property name="url" value="jdbc:h2:database/h2db" />
+                <property name="username" value="root" />
+                <property name="password" value="" />
+            </dataSource>
+        </environment>
+    </environments>
+
+    <!-- mapping files -->
+    <mappers>
+        <mapper resource="org/apache/camel/quarkus/component/mybatis/it/entity/Account.xml"/>
+        <package name="org.apache.camel.quarkus.component.mybatis.it.bean"/>
+    </mappers>
+
+</configuration>
\ No newline at end of file
diff --git a/extensions-jvm/mybatis/integration-test/src/main/resources/org/apache/camel/quarkus/component/mybatis/it/entity/Account.xml b/extensions-jvm/mybatis/integration-test/src/main/resources/org/apache/camel/quarkus/component/mybatis/it/entity/Account.xml
new file mode 100644
index 0000000..207064d
--- /dev/null
+++ b/extensions-jvm/mybatis/integration-test/src/main/resources/org/apache/camel/quarkus/component/mybatis/it/entity/Account.xml
@@ -0,0 +1,138 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+
+    Licensed to the Apache Software Foundation (ASF) under one or more
+    contributor license agreements.  See the NOTICE file distributed with
+    this work for additional information regarding copyright ownership.
+    The ASF licenses this file to You under the Apache License, Version 2.0
+    (the "License"); you may not use this file except in compliance with
+    the License.  You may obtain a copy of the License at
+
+         http://www.apache.org/licenses/LICENSE-2.0
+
+    Unless required by applicable law or agreed to in writing, software
+    distributed under the License is distributed on an "AS IS" BASIS,
+    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+    See the License for the specific language governing permissions and
+    limitations under the License.
+
+-->
+<!DOCTYPE mapper
+        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
+        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+
+<mapper namespace="Account">
+
+    <!-- Result maps describe the mapping between the columns returned
+   from a query, and the class properties.  A result map isn't
+   necessary if the columns (or aliases) match to the properties
+   exactly. -->
+    <resultMap id="AccountResult" type="Account">
+        <result property="id" column="ACC_ID"/>
+        <result property="firstName" column="ACC_FIRST_NAME"/>
+        <result property="lastName" column="ACC_LAST_NAME"/>
+        <result property="emailAddress" column="ACC_EMAIL"/>
+    </resultMap>
+
+    <!-- Select with no parameters using the result map for Account class. -->
+    <select id="selectAllAccounts" resultMap="AccountResult">
+        select * from ACCOUNT order by ACC_ID
+    </select>
+
+    <!-- A simpler select example without the result map.  Note the
+aliases to match the properties of the target result class. -->
+    <select id="selectAccountById" parameterType="int" resultType="Account">
+        select
+        ACC_ID as id,
+        ACC_FIRST_NAME as firstName,
+        ACC_LAST_NAME as lastName,
+        ACC_EMAIL as emailAddress
+        from ACCOUNT
+        where ACC_ID = #{id}
+    </select>
+
+    <!-- Insert example, using the Account parameter class -->
+    <insert id="insertAccount" parameterType="Account">
+        insert into ACCOUNT (
+        ACC_ID,
+        ACC_FIRST_NAME,
+        ACC_LAST_NAME,
+        ACC_EMAIL
+        )
+        values (
+        #{id}, #{firstName}, #{lastName}, #{emailAddress}
+        )
+    </insert>
+
+    <!-- START SNIPPET: insertList -->
+    <!-- Batch Insert example, using the Account parameter class -->
+    <insert id="batchInsertAccount" parameterType="java.util.List">
+        insert into ACCOUNT (
+        ACC_ID,
+        ACC_FIRST_NAME,
+        ACC_LAST_NAME,
+        ACC_EMAIL
+        )
+        values (
+        <foreach item="Account" collection="list" open="" close="" separator="),(">
+            #{Account.id}, #{Account.firstName}, #{Account.lastName}, #{Account.emailAddress}
+        </foreach>
+        )
+    </insert>
+    <!-- END SNIPPET: insertList -->
+
+  <!-- Update example, using the Account parameter class -->
+    <update id="updateAccount" parameterType="Account">
+        update ACCOUNT set
+        ACC_FIRST_NAME = #{firstName},
+        ACC_LAST_NAME = #{lastName},
+        ACC_EMAIL = #{emailAddress}
+        where
+        ACC_ID = #{id}
+    </update>
+
+    <update id="batchUpdateAccount" parameterType="java.util.Map">
+        update ACCOUNT set
+        ACC_EMAIL = #{emailAddress}
+        where
+        ACC_ID in
+        <foreach item="Account" collection="list" open="(" close=")" separator=",">
+            #{Account.id}
+        </foreach>
+    </update>
+
+    <!-- Delete example, using an integer as the parameter class -->
+    <delete id="deleteAccountById" parameterType="int">
+        delete from ACCOUNT where ACC_ID = #{id}
+    </delete>
+
+    <delete id="batchDeleteAccountById" parameterType="java.util.List">
+        delete from ACCOUNT
+        where
+        ACC_ID in
+        <foreach item="AccountID" collection="list" open="(" close=")" separator=",">
+            #{AccountID}
+        </foreach>
+    </delete>
+
+    <!-- START SNIPPET: e1 -->
+    <select id="selectUnprocessedAccounts" resultMap="AccountResult">
+        select * from ACCOUNT where PROCESSED = false
+    </select>
+    <!-- END SNIPPET: e1 -->
+
+    <select id="selectProcessedAccounts" resultMap="AccountResult">
+        select * from ACCOUNT where PROCESSED = true
+    </select>
+
+    <!-- START SNIPPET: e2 -->
+    <update id="consumeAccount" parameterType="Account">
+        update ACCOUNT set PROCESSED = true where ACC_ID = #{id}
+    </update>
+    <!-- END SNIPPET: e2 -->
+
+    <select id="count" resultType="int">
+        select count(*) from ACCOUNT
+    </select>
+
+</mapper>
diff --git a/extensions-jvm/mybatis/integration-test/src/test/java/org/apache/camel/quarkus/component/mybatis/it/MybatisTest.java b/extensions-jvm/mybatis/integration-test/src/test/java/org/apache/camel/quarkus/component/mybatis/it/MybatisTest.java
new file mode 100644
index 0000000..6dda833
--- /dev/null
+++ b/extensions-jvm/mybatis/integration-test/src/test/java/org/apache/camel/quarkus/component/mybatis/it/MybatisTest.java
@@ -0,0 +1,42 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *      http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.apache.camel.quarkus.component.mybatis.it;
+
+import io.quarkus.test.junit.QuarkusTest;
+import io.restassured.RestAssured;
+import org.junit.jupiter.api.Test;
+
+@QuarkusTest
+class MybatisTest {
+
+    @Test
+    public void loadComponentMybatis() {
+        /* A simple autogenerated test */
+        RestAssured.get("/mybatis/load/component/mybatis")
+                .then()
+                .statusCode(200);
+    }
+
+    @Test
+    public void loadComponentMybatisBean() {
+        /* A simple autogenerated test */
+        RestAssured.get("/mybatis/load/component/mybatis-bean")
+                .then()
+                .statusCode(200);
+    }
+
+}
diff --git a/extensions-jvm/mybatis/pom.xml b/extensions-jvm/mybatis/pom.xml
new file mode 100644
index 0000000..3825318
--- /dev/null
+++ b/extensions-jvm/mybatis/pom.xml
@@ -0,0 +1,40 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+
+    Licensed to the Apache Software Foundation (ASF) under one or more
+    contributor license agreements.  See the NOTICE file distributed with
+    this work for additional information regarding copyright ownership.
+    The ASF licenses this file to You under the Apache License, Version 2.0
+    (the "License"); you may not use this file except in compliance with
+    the License.  You may obtain a copy of the License at
+
+         http://www.apache.org/licenses/LICENSE-2.0
+
+    Unless required by applicable law or agreed to in writing, software
+    distributed under the License is distributed on an "AS IS" BASIS,
+    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+    See the License for the specific language governing permissions and
+    limitations under the License.
+
+-->
+<project xmlns="http://maven.apache.org/POM/4.0.0"
+         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
+    <modelVersion>4.0.0</modelVersion>
+    <parent>
+        <groupId>org.apache.camel.quarkus</groupId>
+        <artifactId>camel-quarkus-build-parent</artifactId>
+        <version>1.1.0-SNAPSHOT</version>
+        <relativePath>../../poms/build-parent/pom.xml</relativePath>
+    </parent>
+
+    <artifactId>camel-quarkus-mybatis-parent</artifactId>
+    <name>Camel Quarkus :: MyBatis</name>
+    <packaging>pom</packaging>
+
+    <modules>
+        <module>deployment</module>
+        <module>runtime</module>
+        <module>integration-test</module>
+    </modules>
+</project>
diff --git a/extensions-jvm/mybatis/runtime/pom.xml b/extensions-jvm/mybatis/runtime/pom.xml
new file mode 100644
index 0000000..4d0a945
--- /dev/null
+++ b/extensions-jvm/mybatis/runtime/pom.xml
@@ -0,0 +1,94 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+
+    Licensed to the Apache Software Foundation (ASF) under one or more
+    contributor license agreements.  See the NOTICE file distributed with
+    this work for additional information regarding copyright ownership.
+    The ASF licenses this file to You under the Apache License, Version 2.0
+    (the "License"); you may not use this file except in compliance with
+    the License.  You may obtain a copy of the License at
+
+         http://www.apache.org/licenses/LICENSE-2.0
+
+    Unless required by applicable law or agreed to in writing, software
+    distributed under the License is distributed on an "AS IS" BASIS,
+    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+    See the License for the specific language governing permissions and
+    limitations under the License.
+
+-->
+<project xmlns="http://maven.apache.org/POM/4.0.0"
+         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
+    <modelVersion>4.0.0</modelVersion>
+    <parent>
+        <groupId>org.apache.camel.quarkus</groupId>
+        <artifactId>camel-quarkus-mybatis-parent</artifactId>
+        <version>1.1.0-SNAPSHOT</version>
+        <relativePath>../pom.xml</relativePath>
+    </parent>
+
+    <artifactId>camel-quarkus-mybatis</artifactId>
+    <name>Camel Quarkus :: MyBatis :: Runtime</name>
+    <description>Performs a query, poll, insert, update or delete in a relational database using MyBatis.</description>
+
+    <properties>
+        <firstVersion>1.1.0</firstVersion>
+    </properties>
+
+    <dependencyManagement>
+        <dependencies>
+            <dependency>
+                <groupId>org.apache.camel.quarkus</groupId>
+                <artifactId>camel-quarkus-bom</artifactId>
+                <version>${project.version}</version>
+                <type>pom</type>
+                <scope>import</scope>
+            </dependency>
+        </dependencies>
+    </dependencyManagement>
+
+    <dependencies>
+        <dependency>
+            <groupId>org.apache.camel.quarkus</groupId>
+            <artifactId>camel-quarkus-core</artifactId>
+        </dependency>
+        <dependency>
+            <groupId>org.apache.camel</groupId>
+            <artifactId>camel-mybatis</artifactId>
+        </dependency>
+    </dependencies>
+
+    <build>
+        <plugins>
+            <plugin>
+                <groupId>org.apache.camel.quarkus</groupId>
+                <artifactId>camel-quarkus-maven-plugin</artifactId>
+                <executions>
+                    <execution>
+                        <id>update-extension-doc-page</id>
+                        <goals><goal>update-extension-doc-page</goal></goals>
+                        <phase>process-classes</phase>
+                    </execution>
+                </executions>
+            </plugin>
+            <plugin>
+                <groupId>io.quarkus</groupId>
+                <artifactId>quarkus-bootstrap-maven-plugin</artifactId>
+            </plugin>
+            <plugin>
+                <groupId>org.apache.maven.plugins</groupId>
+                <artifactId>maven-compiler-plugin</artifactId>
+                <configuration>
+                    <annotationProcessorPaths>
+                        <path>
+                            <groupId>io.quarkus</groupId>
+                            <artifactId>quarkus-extension-processor</artifactId>
+                            <version>${quarkus.version}</version>
+                        </path>
+                    </annotationProcessorPaths>
+                </configuration>
+            </plugin>
+        </plugins>
+    </build>
+</project>
diff --git a/extensions-jvm/mybatis/runtime/src/main/resources/META-INF/quarkus-extension.yaml b/extensions-jvm/mybatis/runtime/src/main/resources/META-INF/quarkus-extension.yaml
new file mode 100644
index 0000000..bfefcd0
--- /dev/null
+++ b/extensions-jvm/mybatis/runtime/src/main/resources/META-INF/quarkus-extension.yaml
@@ -0,0 +1,32 @@
+#
+# Licensed to the Apache Software Foundation (ASF) under one or more
+# contributor license agreements.  See the NOTICE file distributed with
+# this work for additional information regarding copyright ownership.
+# The ASF licenses this file to You under the Apache License, Version 2.0
+# (the "License"); you may not use this file except in compliance with
+# the License.  You may obtain a copy of the License at
+#
+#      http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing, software
+# distributed under the License is distributed on an "AS IS" BASIS,
+# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+# See the License for the specific language governing permissions and
+# limitations under the License.
+#
+
+# This is a generated file. Do not edit directly!
+# To re-generate, run the following command from the top level directory:
+#
+#   mvn -N cq:update-quarkus-metadata
+#
+---
+name: "Camel MyBatis"
+description: "Performs a query, poll, insert, update or delete in a relational database using MyBatis"
+metadata:
+  unlisted: true
+  guide: "https://camel.apache.org/camel-quarkus/latest/reference/extensions/mybatis.html"
+  categories:
+  - "integration"
+  status:
+  - "preview"
diff --git a/extensions-jvm/pom.xml b/extensions-jvm/pom.xml
index 33bce27..58bcb9c 100644
--- a/extensions-jvm/pom.xml
+++ b/extensions-jvm/pom.xml
@@ -88,6 +88,7 @@
         <module>jbpm</module>
         <module>jooq</module>
         <module>jsch</module>
+        <module>mybatis</module>
         <module>nagios</module>
         <module>nitrite</module>
         <module>nsq</module>
diff --git a/poms/bom/pom.xml b/poms/bom/pom.xml
index ea2708a..384c6bb 100644
--- a/poms/bom/pom.xml
+++ b/poms/bom/pom.xml
@@ -1219,6 +1219,11 @@
             </dependency>
             <dependency>
                 <groupId>org.apache.camel</groupId>
+                <artifactId>camel-mybatis</artifactId>
+                <version>${camel.version}</version>
+            </dependency>
+            <dependency>
+                <groupId>org.apache.camel</groupId>
                 <artifactId>camel-nagios</artifactId>
                 <version>${camel.version}</version>
             </dependency>
@@ -3406,6 +3411,16 @@
             </dependency>
             <dependency>
                 <groupId>org.apache.camel.quarkus</groupId>
+                <artifactId>camel-quarkus-mybatis</artifactId>
+                <version>${camel-quarkus.version}</version>
+            </dependency>
+            <dependency>
+                <groupId>org.apache.camel.quarkus</groupId>
+                <artifactId>camel-quarkus-mybatis-deployment</artifactId>
+                <version>${camel-quarkus.version}</version>
+            </dependency>
+            <dependency>
+                <groupId>org.apache.camel.quarkus</groupId>
                 <artifactId>camel-quarkus-nagios</artifactId>
                 <version>${camel-quarkus.version}</version>
             </dependency>