SQL error with alfresco 1.4 on ingres database

[advaittrivedi]

Hi,

I am trying to run alfresco 1.4 with ingres 2006 database on tomcat. I have setup driver and all other connection properties. I am getting this error:
—————————————————————————————
16:51:20,779 ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
   SQL:  create table alf_child_assoc ( id bigint not null, parent_node_id bigint with null, child_node_id bigint with null, type_qname varchar(255) not null, qname varchar(255) not null, child_node_name varchar(50) not null, child_node_name_crc bigint not null, is_primary tinyint with null, assoc_index integer with null, primary key (id), unique (parent_node_id, type_qname, child_node_name, child_node_name_crc) )
   Error: CREATE TABLE: A column in a UNIQUE constraint has been
defined as WITH NULL (on table 'alf_child_assoc').
All columns in a UNIQUE constraint MUST be created as NOT NULL.
—————————————————————————————
It is farily simple from above to find out that in create table script for alf_child_assoc has column in a UNIQUE constraint which is defined as WITH NULL. How can I change this? Alfresco creates a new sql file in temp directory of tomcat each time, with new name. So editing file will not solve problem.

———-
Thanks & Regards,
Advait

[derek]

Hi,

What I'm saying is that SQL state [40001]; error code [4708] means nothing to the system.

You database connection is established by the DBCP connection pool now.  Check the settings and possibly override the datasource bean.

I'm sorry, but we have put no effort into getting Ingres to work and we're not likely to do so.  Hopefully a fellow Ingres user will be able to help.  Also, DBCP is a widely used component and there's nothing special about what the way Alfresco uses it.  You might find the solution in other products' forums as well.

Regards

[advaittrivedi]

Hi Derek,

to get the description for SQL state [40001] i went through Ingres product documentation and found the description, it is: "Serialization failure".  And as far as [warn] message is concerned i am OK with it, since it is just a warning.

Further, I am trying to print values of query parameters in log, by adding following:

log4j.logger.org.hibernate.type=debug to log4j.properties of alfresco.

But it is not printing values of parameters. Hibernate documentation also suggest the same, any idea on how to print query parameter values will be helpful.