[jboss-user] [EJB 3.0] - tables cannot be created automatically.WHY?

[caijc]

jboss4.2,postgresql7.2,jdk1.6: 
in persistence.xml,I used: 
<jta-data-source>java:/PostgresDS</jta-data-source> 
org.hibernate.ejb.HibernatePersistence 
create-drop 
org.hibernate.dialect.PostgreSQLDialect 

Here I set "hibernate.hbm2ddl.auto" to "create-drop",and in JMX-console I also see this DSN:PostgresDS; 
and in postgres-ds.xml,it also seems no errors: 
<local-tx-datasource> 
<jndi-name>PostgresDS</jndi-name> 
<connection-url>jdbc:postgresql://127.0.0.1:5432/my</connection-url> 
<driver-class>org.postgresql.Driver</driver-class> 
<user-name>postgresql</user-name> 
111111 
but when I access the entities from JSP,exceptions are thrown: 
java.sql.BatchUpdateException: insert into tbl_Authors (birthday, levels, name) values (2007-11-08 +00:00:00, 5, wawa) failed 
LOOK:neither '2007-11-08 +00:00:00' nor 'wawa' are quoted with quotation marks,I think this is wrong.But why? it's generated by hibernate itself,not me! 

What's more,I login the postgresql database,and there is no tables created automatically either.Why this happens?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4102768#4102768

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4102768