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 <shikhaagara...@gmail.com> 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
