From: msell <nu...@jb...> - 2005-08-01 02:36:40
|
Just trying to work through the problem - getting the same error as the original poster. However... It seems as if the first article and the first author *IS* being recorded to the Hypersonic database (I'm using the JBoss 4.0.3RC1 distro): create table ARTICLES (articleId integer generated by default as identity (start with 1), title varchar(255), body varchar(255), authorId integer, primary key (articleId)) create table AUTHORS (authorId integer generated by default as identity (start with 1), name varchar(255), primary key (authorId)) alter table ARTICLES add constraint FKE566C23D843A2A25 foreign key (authorId) references AUTHORS SET AUTOCOMMIT FALSE INSERT INTO AUTHORS VALUES(1,'Marshall Culpepper') INSERT INTO ARTICLES VALUES(1,'marshall''s 1st article','this is an article',1) COMMIT Gonna keep pluggin away - but this might help somebody much more experienced than I am at this. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3887616#3887616 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3887616 |