Skip to content

Instantly share code, notes, and snippets.

@davsclaus

davsclaus/gist:c81cbefcd4fef4efee3042fd3e01e4b7

Created February 12, 2022 13:43
Show Gist options
  • Save davsclaus/c81cbefcd4fef4efee3042fd3e01e4b7 to your computer and use it in GitHub Desktop.
Save davsclaus/c81cbefcd4fef4efee3042fd3e01e4b7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
2022-02-12 14:40:57.498 INFO 38460 --- [ main] amel.main.MainAutowiredLifecycleStrategy : Autowired property: dataSource on component: sql as exactly one instance of type: javax.sql.DataSource (org.apache.commons.dbcp2.BasicDataSource) found in the registry
2022-02-12 14:40:57.683 INFO 38460 --- [ main] e.camel.impl.engine.AbstractCamelContext : Routes startup (total:1 started:1)
2022-02-12 14:40:57.683 INFO 38460 --- [ main] e.camel.impl.engine.AbstractCamelContext : Started route1 (sql://SELECT%20*%20FROM%20emp_data)
2022-02-12 14:40:57.683 INFO 38460 --- [ main] e.camel.impl.engine.AbstractCamelContext : Apache Camel 3.16.0-SNAPSHOT (CamelJBang) started in 434ms (build:80ms init:217ms start:137ms)
2022-02-12 14:40:57.684 INFO 38460 --- [ main] ache.camel.impl.debugger.BacklogDebugger : Enabling debugger
2022-02-12 14:40:58.915 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:40:59.436 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:40:59.956 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:41:00.475 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:41:00.991 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:41:01.514 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:41:02.035 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:41:02.555 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:41:03.076 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:41:03.597 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:41:04.118 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:41:04.636 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:41:05.157 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:41:05.678 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
2022-02-12 14:41:06.200 INFO 38460 --- [FROM%20emp_data] jdbc.yaml:10 : {"name":"jack","age":28,"designation":"london","salary":30000}
^C2022-02-12 14:41:06.399 INFO 38460 --- [ main] e.camel.impl.engine.AbstractCamelContext : Apache Camel 3.16.0-SNAPSHOT (CamelJBang) shutting down (timeout:5s)
2022-02-12 14:41:06.409 INFO 38460 --- [ main] e.camel.impl.engine.AbstractCamelContext : Routes stopped (total:1 stopped:1)
2022-02-12 14:41:06.410 INFO 38460 --- [ main] e.camel.impl.engine.AbstractCamelContext : Stopped route1 (sql://SELECT%20*%20FROM%20emp_data)
2022-02-12 14:41:06.411 INFO 38460 --- [ main] ache.camel.impl.debugger.BacklogDebugger : Disabling debugger
2022-02-12 14:41:06.412 INFO 38460 --- [ main] e.camel.impl.engine.AbstractCamelContext : Apache Camel 3.16.0-SNAPSHOT (CamelJBang) shutdown in 13ms (uptime:8s866ms)
@davsclaus
Copy link
Author

davsclaus commented Feb 12, 2022 •
edited 

~/workspace/deleteme ❯ cat jdbc.yaml                                                                                                                                         ✘ INT
- route:
    from:
      uri: "sql:SELECT * FROM emp_data"
      parameters:
        dataSource: "#bean:myDS"
      steps:
      - marshal:
          json:
            library: Jackson
      - log: "${body}"
- beans:
    - name: myDS
      type: "org.apache.commons.dbcp2.BasicDataSource"
      properties:
        username: postgres
        password: postgres
        url: jdbc:postgresql://localhost:5432/postgres
        driverClassName: org.postgresql.Driver

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment