Quantcast

Camel tables created into db

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Camel tables created into db

sagarwal1
Hi, I want to run Camel built application as stanalone. I am using maven to create jar and execute route.
When I run MainApp.java main method from eclipse or run using camel run then code runs as expected. But when I run using java -jar <classname> then 3 tables CAMEL_MESSAGEPROCESSED, CAMEL_MESSAGETRACED,hibernate_sequence are created into db. I do not want these tables created. Can you please help me what I am doing wrong.

Camel, camel-jpa version 2.19.1
hibernate-entitymanager version 5.2.7.Final

Camel-context.xml
<beans xmlns="http://www.springframework.org/schema/beans" 
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:prop="http://camel.apache.org/schema/placeholder"
        xmlns:camel="http://camel.apache.org/schema/spring"
        xsi:schemaLocation="http://www.springframework.org/schema/beans classpath:org/springframework/beans/factory/xml/spring-beans-4.3.xsd
     http://camel.apache.org/schema/spring http://camel.apache.org/schema/spring/camel-spring.xsd">



        <bean id="properties"
                class="org.apache.camel.component.properties.PropertiesComponent">
                <property name="location" value="classpath:db.properties" />
        </bean>

        <bean id="bridgePropertyPlaceholder"
                class="org.apache.camel.spring.spi.BridgePropertyPlaceholderConfigurer">
                <property name="location" value="classpath:db.properties" />
        </bean>


        <camelContext id="camel5" xmlns="http://camel.apache.org/schema/spring">
                <routeBuilder ref="myBuilder" />
        </camelContext>


        <bean id="myBuilder"
                class="com.aexp.gsnt.insight.updateCentralData.InsightRouterBuilder" />

       
        <bean id="jpa" class="org.apache.camel.component.jpa.JpaComponent">
                <property name="entityManagerFactory" ref="entityManagerFactory" />
                <property name="transactionManager" ref="jpaTxManager" />
        </bean>
        <bean id="jpaTxManager" class="org.springframework.orm.jpa.JpaTransactionManager">
                <property name="entityManagerFactory" ref="entityManagerFactory" />
        </bean>
        <bean id="entityManagerFactory"
                class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
                <property name="persistenceUnitName" value="persistenceUnit" />
                <property name="dataSource" ref="dataSource" />
                <property name="jpaVendorAdapter">
                        <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
                                <property name="databasePlatform" value="org.hibernate.dialect.SQLServerDialect" />
                                <property name="showSql" value="${showSQL}" />
                                <property name="generateDdl" value="${generateDdl}" />
                        </bean>
                </property>
                <property name="jpaProperties">
                        <props>
                                <prop key="hibernate.format_sql">${formatSQL}</prop>
                        </props>
                </property>
        </bean>

        <bean id="dataSource"
                class="org.springframework.jdbc.datasource.DriverManagerDataSource">
                <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
                <property name="url" value="${jdbc.url}" />
                <property name="username" value="${username}" />
                <property name="password" value="${password}" />
        </bean>

</beans>

Persistence.xml
<?xml version="1.0" encoding="UTF-8" ?>
<persistence xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
        version="2.0" xmlns="http://java.sun.com/xml/ns/persistence">
        <persistence-unit name="persistenceUnit"
                transaction-type="RESOURCE_LOCAL">
        </persistence-unit>
</persistence>

MainApp.java

import org.springframework.context.support.ClassPathXmlApplicationContext;
public class MainApp {

        private static ClassPathXmlApplicationContext classPathXmlApplicationContext;

        /* Invoked from Jar */
        public static void main(String args[]) throws Exception {
                System.out.println("Started Central Data Extractor");
                System.setProperty("jsse.enableSNIExtension", "false");
               
                classPathXmlApplicationContext = new ClassPathXmlApplicationContext("classpath:/META-INF/spring/camel-context.xml");
                classPathXmlApplicationContext.start();
        }

}



Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Camel tables created into db

Claus Ibsen-2
Hi

Please use the user forum / @user mailing list for such kind of question.
Also search the internet how to turn off table creation in hibernate /
JPA as its there you should look and not Apache Camel.

On Mon, Feb 13, 2017 at 9:50 PM, sagarwal1 <[hidden email]> wrote:

> Hi, I want to run Camel built application as stanalone. I am using maven to
> create jar and execute route.
> When I run MainApp.java main method from eclipse or run using camel run then
> code runs as expected. But when I run using java -jar <classname> then 3
> tables CAMEL_MESSAGEPROCESSED, CAMEL_MESSAGETRACED,hibernate_sequence are
> created into db. I do not want these tables created. Can you please help me
> what I am doing wrong.
>
> Camel, camel-jpa version 2.19.1
> hibernate-entitymanager version 5.2.7.Final
>
> Camel-context.xml
> <beans xmlns="http://www.springframework.org/schema/beans"
>         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:prop="http://camel.apache.org/schema/placeholder"
>         xmlns:camel="http://camel.apache.org/schema/spring"
>         xsi:schemaLocation="http://www.springframework.org/schema/beans
> classpath:org/springframework/beans/factory/xml/spring-beans-4.3.xsd
>      http://camel.apache.org/schema/spring
> http://camel.apache.org/schema/spring/camel-spring.xsd">
>
>
>
>         <bean id="properties"
>                 class="org.apache.camel.component.properties.PropertiesComponent">
>                 <property name="location" value="classpath:db.properties" />
>         </bean>
>
>         <bean id="bridgePropertyPlaceholder"
>                 class="org.apache.camel.spring.spi.BridgePropertyPlaceholderConfigurer">
>                 <property name="location" value="classpath:db.properties" />
>         </bean>
>
>
>         <camelContext id="camel5" xmlns="http://camel.apache.org/schema/spring">
>                 <routeBuilder ref="myBuilder" />
>         </camelContext>
>
>
>         <bean id="myBuilder"
>                 class="com.aexp.gsnt.insight.updateCentralData.InsightRouterBuilder" />
>
>
>         <bean id="jpa" class="org.apache.camel.component.jpa.JpaComponent">
>                 <property name="entityManagerFactory" ref="entityManagerFactory" />
>                 <property name="transactionManager" ref="jpaTxManager" />
>         </bean>
>         <bean id="jpaTxManager"
> class="org.springframework.orm.jpa.JpaTransactionManager">
>                 <property name="entityManagerFactory" ref="entityManagerFactory" />
>         </bean>
>         <bean id="entityManagerFactory"
>
> class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
>                 <property name="persistenceUnitName" value="persistenceUnit" />
>                 <property name="dataSource" ref="dataSource" />
>                 <property name="jpaVendorAdapter">
>                         <bean
> class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
>                                 <property name="databasePlatform"
> value="org.hibernate.dialect.SQLServerDialect" />
>                                 <property name="showSql" value="${showSQL}" />
>                                 <property name="generateDdl" value="${generateDdl}" />
>                         </bean>
>                 </property>
>                 <property name="jpaProperties">
>                         <props>
>                                 <prop key="hibernate.format_sql">${formatSQL}</prop>
>                         </props>
>                 </property>
>         </bean>
>
>         <bean id="dataSource"
>                 class="org.springframework.jdbc.datasource.DriverManagerDataSource">
>                 <property name="driverClassName"
> value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
>                 <property name="url" value="${jdbc.url}" />
>                 <property name="username" value="${username}" />
>                 <property name="password" value="${password}" />
>         </bean>
>
> </beans>
>
> Persistence.xml
> <?xml version="1.0" encoding="UTF-8" ?>
> <persistence xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>         xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
> http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
>         version="2.0" xmlns="http://java.sun.com/xml/ns/persistence">
>         <persistence-unit name="persistenceUnit"
>                 transaction-type="RESOURCE_LOCAL">
>         </persistence-unit>
> </persistence>
>
> MainApp.java
>
> import org.springframework.context.support.ClassPathXmlApplicationContext;
> public class MainApp {
>
>         private static ClassPathXmlApplicationContext
> classPathXmlApplicationContext;
>
>         /* Invoked from Jar */
>         public static void main(String args[]) throws Exception {
>                 System.out.println("Started Central Data Extractor");
>                 System.setProperty("jsse.enableSNIExtension", "false");
>
>                 classPathXmlApplicationContext = new
> ClassPathXmlApplicationContext("classpath:/META-INF/spring/camel-context.xml");
>                 classPathXmlApplicationContext.start();
>         }
>
> }
>
>
>
>
>
>
>
> --
> View this message in context: http://camel.465427.n5.nabble.com/Camel-tables-created-into-db-tp5793841.html
> Sent from the Camel Development mailing list archive at Nabble.com.



--
Claus Ibsen
-----------------
http://davsclaus.com @davsclaus
Camel in Action 2: https://www.manning.com/ibsen2
Loading...