Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-1024

Weird datatype error under Sybase

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 1.0.1
    • 1.0
    • None

      com.sybase.jdbc2.jdbc.SybSQLException: Domain error during implicit conversion of BINARY value '’' to a DATETIME field.

      at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao$4.doInHibernate(HibernateObjectDao.java:310)
      at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:149)
      at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:473)
      at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:291)
      at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:276)
      at com.atlassian.confluence.core.persistence.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:261)
      at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernateBlogPostDao.getFirstPostAfter(HibernateBlogPostDao.java:99)
      at com.atlassian.confluence.pages.DefaultPageManager.findNextBlogPost(DefaultPageManager.java:106)

      The only visible symptom of this I can see is that you have to manually refresh a blog-post page after you've added or edited an entry, so that the button-bar will appear.

            [CONFSERVER-1024] Weird datatype error under Sybase

            Charles Miller (Inactive) added a comment -

            Regardless, switching query from java.util.Date to java.sql.Date fixed the problem.

            Charles Miller (Inactive) added a comment - Regardless, switching query from java.util.Date to java.sql.Date fixed the problem.

            Charles Miller (Inactive) added a comment -

            Memo to self: check this still happens when you take p6spy out of the loop.

            Charles Miller (Inactive) added a comment - Memo to self: check this still happens when you take p6spy out of the loop.

              Unassigned Unassigned
              cmiller@atlassian.com Charles Miller (Inactive)
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: