What I mean is that Jahia only works with INT, not NUMERIC as a base type.
I recommend you look into the Hypersonic script, which is closest to what Jahia needs in terms of types. The Oracle script is not a good starting point because Oracle has a different way of handling types than most databases.
Regards,
Serge Huber.
At 15:04 14.06.2004, you wrote:
No,
Because of the limitation of implicit conversion in sybase...
Just have a look to this attached document.
Ghislain...
- 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)
- - -- --- -----=[ serge.huber at jahia dot com ]=---- --- -- -
- Jahia : A collaborative source CMS and Portal Server
- www.jahia.org Community and product web site
- www.jahia.com Commercial services company
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
