Maybe you should try mapping NUMBER to INT or something equivalent in Sybase.
Regards,
Serge...
At 14:49 11.06.2004, you wrote:
Hi,
I've use the oracle script. I've use this data type mapping to change the script like the DSS site describe it:
- NUMBER --> NUMERIC
- VARCHAR2 --> VARCHAR
- DATE --> DATETIME
This mapping is describe at this URL : http://www.indiana.edu/~dss/Services/DataWarehouse/Oracle/Sybase/conversion.html
Ghislain
- Hi,
- I don't think Jahia do this implicit conversion, so it seems like the script used to create the db schema is not correct. What script did you use and what modifications did you make on it ?
- A good think would be to enable the debug mode in the log4j.xml, so that you have a more descriptive error and most probably the SQL request which produces this error message.
- Michel
- Hi !
- I'm using Jahia 4.0.4 with a Sybase SGBD. All work fine instead of the document versions manager
- I've got a problem whith the version manager. I want to use it (for example invalidate last modifications) and the jahia administration JSP whitch do that is based on implicit conversion betwen CHAR and NUMERIC types.
- The Sybase DB don't accept this conversions. I've got this error :
- [ServletException in:/views/engines/versioning/pages/sitemap.jsp] Cannot load page data from the database, Error in getStagingPageFieldIDs : La conversion implicite du type de donn�e 'CHAR' en 'NUMERIC' n'est pas autoris�e. Employez la fonction CONVERT pour ex�cuter cette interrogation., root cause:La conversion implicite du type de donn�e 'CHAR' en 'NUMERIC' n'est pas autoris�e. Employez la fonction CONVERT pour ex�cuter cette interrogation.'
- Has anybody any idea ?
- Thanks
- Ghislain
- Acc�dez au courrier �lectronique de La Poste : www.laposte.net ;
- 3615 LAPOSTENET (0,34�/mn) ; t�l : 08 92 68 13 50 (0,34�/mn)
Acc�dez au courrier �lectronique de La Poste : www.laposte.net ;
3615 LAPOSTENET (0,34�/mn) ; t�l : 08 92 68 13 50 (0,34�/mn)
Jahia : A collaborative source CMS and Portal Server
www.jahia.org Community and product web site
www.jahia.com Commercial services company
