Well, maybe it's not the trailing semicolon that is the problem. However, I still cannot get the import.sql to work correctly. According to hibernate, the export was successful. Unfortunately, according to my DB, nothing was ever done:
MySQL 5.0.18 JBoss-4.0.3SP1 | 2006-04-20 09:26:19,940 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] Executing import script: /import.sql | 2006-04-20 09:26:19,940 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] INSERT INTO user (id,username,dn,fname,lname,dispName,email,info_id) VALUES (1,'[EMAIL PROTECTED]','CN=APaxson,cn=people,dc=mycompany,dc=com',NULL,NULL,'Aaron Paxson',NULL,NULL) | 2006-04-20 09:26:19,940 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] INSERT INTO user (id,username,dn,fname,lname,dispName,email,info_id) VALUES (2,'[EMAIL PROTECTED]','CN=Amy Alig,cn=people,dc=mycompany,dc=com',NULL,NULL,'Amy Alig',NULL,NULL) | 2006-04-20 09:26:19,940 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] INSERT INTO user (id,username,dn,fname,lname,dispName,email,info_id) VALUES (3,'[EMAIL PROTECTED]','CN=Benno Duenkelsbuehler,cn=people,dc=mycompany,dc=com',NULL,NULL,'Benno Duenkelsbuehler',NULL,NULL) | 2006-04-20 09:26:19,940 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] INSERT INTO request (id,created,completed,owner_id,requestor_id) VALUES (1,'2006-04-18 13:23:24',NULL,1,2) | 2006-04-20 09:26:19,940 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] INSERT INTO request (id,created,completed,owner_id,requestor_id) VALUES (2,'2006-04-18 13:24:02',NULL,1,3) | 2006-04-20 09:26:19,940 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] INSERT INTO ticket (id,status,resolution,problem,tech_id) VALUES (1,'Active',NULL,'Please degragment the BzQ SQL Server again. Things are running quite sluggish.',1) | 2006-04-20 09:26:19,940 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] INSERT INTO ticket (id,status,resolution,problem,tech_id) VALUES (2,'Active',NULL,'My blackberry is not working anymore.',1) | 2006-04-20 09:26:19,940 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] INSERT INTO note (id,comment,action,created,owner_id,request_id) VALUES (1,'Initial creation','Request Created','2006-04-18 13:23:24',1,1) | 2006-04-20 09:26:19,940 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] INSERT INTO note (id,comment,action,created,owner_id,request_id) VALUES (2,'Initial creation','Request Created','2006-04-18 13:24:03',1,2) | 2006-04-20 09:26:19,940 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] schema export complete | This is really strange, and frustrating. Can anyone shed some light? The schema tables get built correctly, and the Entity Beans get mapped correctly. But, for some reason, my import.sql doesn't work. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3938427#3938427 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3938427 ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
