[jboss-user] [JBoss Seam] - hbm2ddl and multiple datasources

[dennisrjohn]

I have an app that uses a mysql database for all of it's data, and when one particular event happens, needs to update a table in a MS Sql Server database. I'm using the following persistence.xml file:

[code[
   <persistence-unit name="customerservice" transaction-type="JTA">
      org.hibernate.ejb.HibernatePersistence
      <jta-data-source>java:/customerserviceDatasource</jta-data-source>
      
         
         
         
         
         
      
   </persistence-unit>
   
   <persistence-unit name="stoneedge" transaction-type="JTA">
      org.hibernate.ejb.HibernatePersistence
      <jta-data-source>java:/stoneedgeDatasource</jta-data-source>
      
         
         
         
         
         
      
   </persistence-unit>

Since the Mysql database is my app's database, I want to create-drop the tables, but the other app isn't mine, therefore, I want to validate only.

I have entity classes defined like follows:


  | @Entity
  | @PersistenceUnit(unitName="customerservice")
  | @DiscriminatorValue("5")
  | public class TransferInteraction extends CustomerInteraction implements
  | 		Serializable {
  | 
  | 	private String transferDestination;
  | 
  | 	@Length(max = 50)
  | 	public String getTransferDestination()
  | 	{
  | 		return transferDestination;
  | 	}
  | 
  | 	public void setTransferDestination(String transferDestination)
  | 	{
  | 		this.transferDestination = transferDestination;
  | 	}
  | 
  | 	@Override
  | 	public String toString()
  | 	{
  | 		return "Transfer";
  | 	}
  | 
  | }
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4113587#4113587

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4113587