Announcement Announcement Module
Collapse
No announcement yet.
Reverse Engineer MS SQL Server DATE field Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Reverse Engineer MS SQL Server DATE field

    I'm new to Spring framework & Spring Roo just been using for a month now.

    I am trying to reverse engineer a MS SQL Server Database and having troubles with a Date field.

    I first tried just using the default JTDS driver and it got reverse engineered as a STRING. I was expecting a java.util.Date - Is this correct? Not being a date means that he generated JSF screens don't get the Calendar assigned to input fields.

    So I found this: https://jira.springsource.org/browse/ROO-2950

    It suggested that you use the Microsoft JDBC driver instead of the JTDS one.

    I tried this and am getting the following error in the Roo Console: javax.net.ssl.SSLSocket not found by [75].

    ````````````````` ENVIRONMENT `````````````
    Spring Tool Suite 3.1.0
    Spring Roo 1.2.2
    ```````````````````````````````````````````


    ````````````` Spring Roo Commands executed ```````````
    persistence setup --provider HIBERNATE --database MSSQL
    osgi start --url file:///C:\MicrosoftJDBC\sqljdbc_4.0\enu\sqljdbc4.jar
    database reverse engineer --schema dbo --package ~.domain --testAutomatically --includeTables "[my names]"
    `````````````````````````````````````````````````` ```


    I have also tried pushing the AspectJ definition of the String date field to customise and change the field to a date. This then adjusted files via spring roo and if I look at the Create screen it now has the calendar. However the generated "List all" screen gets the following error:

    type Exception report

    message Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]; nested exception is java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

    description The server encountered an internal error that prevented it from fulfilling this request.

    exception

    javax.servlet.ServletException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]; nested exception is java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
    javax.faces.webapp.FacesServlet.service(FacesServl et.java:229)
    org.primefaces.webapp.filter.FileUploadFilter.doFi lter(FileUploadFilter.java:79)
    org.springframework.orm.jpa.support.OpenEntityMana gerInViewFilter.doFilterInternal(OpenEntityManager InViewFilter.java:147)
    org.springframework.web.filter.OncePerRequestFilte r.doFilter(OncePerRequestFilter.java:76)

    Obviously for this one I used the JTDS driver and subsequently ran the following Roo commands:
    • web jsf setup --implementation APACHE_MYFACES --theme BLUESKY
    • web jsf all --package ~.jsf
Working...
X