Failed to run Alfresco SDK sample -SDK FirstFoundationClient

[chi]

Hi Guys

I downloaded the Alfresco SDK and followed the instructions from the wiki site http://wiki.alfresco.com/wiki/Alfresco_SDK

Following the "Running your first Alfresco Client" from the wiki site above

It gave me the following errors

I am using elipse 3.1,mysql database
I got no syntax errors but I got some runtime errors below
I already copied and pasted my properties below after the errors

Thanks for the help

01:43:38,955 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table access_control_list add index FK18486D3B7F2C8017 (node_id), add constraint FK18486D3B7F2C8017 foreign key (node_id) references node (id)
01:43:38,975 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)
01:43:39,076 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table child_assoc add index FKC6EFFF3274173FF4 (child_node_id), add constraint FKC6EFFF3274173FF4 foreign key (child_node_id) references node (id)
01:43:39,076 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)
01:43:39,186 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table child_assoc add index FKC6EFFF328E50E582 (parent_node_id), add constraint FKC6EFFF328E50E582 foreign key (parent_node_id) references node (id)
01:43:39,186 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)
01:43:39,286 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_aspects add index FK2B91A9DE7F2C8017 (node_id), add constraint FK2B91A9DE7F2C8017 foreign key (node_id) references node (id)
01:43:39,286 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)
01:43:39,386 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_assoc add index FK5BAEF398B69C43F3 (source_node_id), add constraint FK5BAEF398B69C43F3 foreign key (source_node_id) references node (id)
01:43:39,386 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)
01:43:39,516 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_assoc add index FK5BAEF398A8FC7769 (target_node_id), add constraint FK5BAEF398A8FC7769 foreign key (target_node_id) references node (id)
01:43:39,516 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)
01:43:39,656 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_properties add index FKC962BF907F2C8017 (node_id), add constraint FKC962BF907F2C8017 foreign key (node_id) references node (id)
01:43:39,656 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)
01:43:39,747 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table node_status add index FK38ECB8CF7F2C8017 (node_id), add constraint FK38ECB8CF7F2C8017 foreign key (node_id) references node (id)
01:43:39,747 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)
01:43:39,867 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table store add index FK68AF8E122DBA5BA (root_node_id), add constraint FK68AF8E122DBA5BA foreign key (root_node_id) references node (id)
01:43:39,867 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql-e48_fa.frm' (errno: 150)
01:43:44,083 ERROR [transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to execute command: imconvert "C:\DOCUME~1\Chi\LOCALS~1\Temp\Alfresco\ImageMagickContentTransformer_init_source_37943.gif"  "C:\DOCUME~1\Chi\LOCALS~1\Temp\Alfresco\ImageMagickContentTransformer_init_target_37944.png"
Jun 16, 2006 1:43:44 AM net.sf.joott.uno.UnoConnection connect
INFO: connecting using "socket,host=localhost,port=8100,tcpNoDelay=1"…
Jun 16, 2006 1:43:45 AM net.sf.joott.uno.UnoConnection connect
SEVERE: connection failed: com.sun.star.connection.NoConnectException: java.net.ConnectException: Connection refused: connect
Jun 16, 2006 1:43:46 AM net.sf.joott.uno.UnoConnection connect
INFO: connecting using "socket,host=localhost,port=8100,tcpNoDelay=1"…
Jun 16, 2006 1:43:47 AM net.sf.joott.uno.UnoConnection connect
SEVERE: connection failed: com.sun.star.connection.NoConnectException: java.net.ConnectException: Connection refused: connect
01:43:47,808 ERROR [hibernate.util.JDBCExceptionReporter] Cannot add or update a child row: a foreign key constraint fails


—————————————————–
.properties file

#
# Sample custom content and index data location
#

dir.root=./alf_data


db.username=alfresco
db.password=alfresco

#
# MySQL connection (This is default and requires mysql-connector-java-3.1.12-bin.jar, which ships with the Alfresco server)
#
db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco

#
# Oracle connection (requires ojdbc14_g.jar or equivalent jar in shared libraries location)
#
#db.driver=oracle.jdbc.OracleDriver
#db.url=jdbcracle:thin:@localhost:1521:alfresco

#
# Sybase connection (requires jconn2d.jar or equivalent jar in shared libraries location)
#
#db.driver=com.sybase.jdbc2.jdbc.SybDriver
#db.url=jdbc:sybase:Tds:localhost:2638/alfresco

[davidc]

The messages imply an exising Alfresco database schema already exists and that the auto-schema migration has failed; this will be the case, if the existing schema was created with a pre-v1.3 release.

Can you try on a clean database, or (if you were using 1.2), upgrade the database to 1.3 using http://wiki.alfresco.com/wiki/Upgrading_to_1.3.0.