0 Replies Latest reply on Sep 20, 2012 11:24 AM by Sandro Villarroel

    Please I run an aplication with mysql but now I need run this in sql2008

    Sandro Villarroel Newbie

      Please I run an aplication with mysql but now I need run this in sql2008

       

      The aplication is made with seam 2.1.1.ga I use seamgen

       

      Really y need select in which database the user want run the aplication, but I don´t have idea what I do this,

       

      For example I have and Entity for mysql

       

      @Entity

      @Table(name = "permiso")

      public class Permiso implements Serializable{...}

       

      And I have the same Entity for Sql2008

       

      @Entity

      @Table(name = "permiso", schema="dbo", catalog="base")

      public class Permiso implements Serializable{...}

       

      Then I don´t now How use only one Entity

       

      And I have another problem whith entityQuery because y use field of type datetime when I have to make a select i have this

       

      for mysql

       

      private static final String[] RESTRICTIONS = {

           "date(asistencia.fechaHoraHorario) = #{asistenciaList.fechaAsistencia}",

      }

       

      And I have the same for Sql2008

       

      private static final String[] RESTRICTIONS = {

           "convert(date,asistencia.fechaHoraHorario) = #{asistenciaList.fechaAsistencia}",

      }

       

      Now I have two project each one whith changes but I want have only one project.

       

      Please, some have any idea. WHAT I DO THIS

       

      Thanks friends