RC1.2 and Sybase - null values

[fraser_crichton]

Hi,

I got Alfresco 1.1.2 to work against Sybase, however I'm now trying to get Alfresco 1.2 RC to work and I get this -

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'patchExecuter' defined in file [C:\work\Sandbox\jboss-4.0.3SP1\server\default\tmp\deploy\tmp65583alfresco-content-management-system-1.2-exp.war\WEB-INF\classes\alfresco\patch\patch-services-context.xml]: Initialization of bean failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batch update; uncategorized SQLException for SQL [insert into applied_patch (description, fixes_from_schema, fixes_to_schema, applied_to_schema, target_schema, applied_on_date, applied_to_server, was_executed, succeeded, report, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [JZ0BE]; error code [0]; JZ0BE: BatchUpdateException: Error occurred while executing batch statement: The column description in table applied_patch does not allow null values.
; nested exception is com.sybase.jdbc2.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException: Error occurred while executing batch statement: The column description in table applied_patch does not allow null values.

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batch update; uncategorized SQLException for SQL [insert into applied_patch (description, fixes_from_schema, fixes_to_schema, applied_to_schema, target_schema, applied_on_date, applied_to_server, was_executed, succeeded, report, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [JZ0BE]; error code [0]; JZ0BE: BatchUpdateException: Error occurred while executing batch statement: The column description in table applied_patch does not allow null values.
; nested exception is com.sybase.jdbc2.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException: Error occurred while executing batch statement: The column description in table applied_patch does not allow null values.

As far as I can tell I've configured all the appropriate files.

Any ideas?

Cheers,

Fraser

[kevinr]

I have raised a bug for this issue:

http://www.alfresco.org/jira/browse/AR-440

Thanks,

Kevin

[derek]

Hi,

What is the locale of your server?

My guess is that the issue is related to the description string not coming out correctly from the I18N code.

Regards

[fraser_crichton]

Got it to work - but only after blowing away the database 

Now (ofcourse) I have another problem which I think may be to do with having blown the database away or the jar versions as I'm trying to install the .war on JBoss 4.0.3SP1.

I get this exception -

2006-02-21 17:19:38,816 DEBUG [net.sf.ehcache.store.MemoryStore] nullPermissionCacheCache: Cannot remove entry as key workspace://SpacesStore/fffce08e-a265-11da-84e0-07b53f7cc7fa was not found
2006-02-21 17:19:39,046 ERROR [org.apache.commons.modeler.BaseModelMBean] Exception invoking method addChild
java.lang.VerifyError: Cannot inherit from final class
   at java.lang.ClassLoader.defineClass1(Native Method)
   at java.lang.ClassLoader.defineClass(ClassLoader.java:620)
   at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)
   at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1629)
   at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:850)
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1299)

[derek]

Hi,

Did you blow away the Lucene indexes as well?  The database, content store and indexes have to be in synch.  If you trash the database, then you have to trash at least the Lucene indexes.

I am in the process of testing the Sybase upgrade path.  Hopefully we'll be able to pinpoint the upgrade issue and fix it for V1.2.

It looks as if your server has DEBUG enabled.  Switch this off (at the root category).  There is at least oneSpring-Hibernate interoperability bug that occurs when DEBUG is on.  If you are selectively debugging, then ignore this…

Kevin will have some more advice on the final class issue.  Which RC release are you running?

Regards

[kevinr]

Hello,

Have you deployed the WAR onto a plain Jboss installation? Just wondering as the VerifyError you mention normally means you have a MyFaces JAR file conflict. We need a patched version of MyFaces JAR files to run with Alfresco - this means any existing JARs currently need to be overwritten with the ones bundled in the Alfresco WAR, like in this article:
http://www.alfresco.org/forums/viewtopic.php?t=739

If you find the following JARs:

myfaces-api.jar
myfaces-impl.jar

from this dir:

jboss\server\default\deploy\jbossweb-tomcat55.sar\jsf-libs

and replace them with the ones from the alfresco war file in 3rd-party\lib then it should work…

Thanks,

Kevin

[fraser_crichton]

Now we're getting somewhere.

Replaced the jars and I can get onto the login page (it fails after that but I'm guessing that's a similar issue and I'll post if it turns out I can't find out what's going on).

One question I do have is how do I get these jars onto the server? As part of my build process I'm adding them directly to the alfresco  .war file and that seems to work, somaone suggested however that I also need to configure the classloader directly using the jboss-web.xml file, is that strictly neccessary? Or am I doing this all wrong??

Thanks again for all your help.

Fraser

[fraser_crichton]

My login problems were due to this -

portlet-api-lib.jar

Not being present.

Stuck it in and everything appears to work.

Now I'm off to try and get the JCR API working.