[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - error InitialContext - database error

[gomanza]

Hi guys,

I have the following inital Method to fill my database everytime I start jboss-4.0.5:


  | public void contextInitialized(ServletContextEvent arg0) {
  | 	logger.info("ServletContext initialized, initialize DB.");
  | 	InitialContext iCtx;
  | 	try {
  | 		iCtx = new InitialContext();
  | 		internetShop = (InternetShopLocal) iCtx
  | 				.lookup("InternetShop/InternetShop/local");
  | 	} catch (NamingException exc) {
  | 		throw new RuntimeException(exc);
  | 	}
  | 	List<EntityBean> mockEntities = new ArrayList<EntityBean>();
  | 	User user = getMockUser();
  | 	mockEntities.add(user);
  | 
  | 	mockEntities.add(....);
  | 	mockEntities.add(....);
  | 	mockEntities.add(....);
  | 	try {
  | 		internetShop.saveMockEntities(mockEntities);
  | 	} catch (Exception e) {
  | 		e.printStackTrace();
  | 	}
  | }

The Method getMockUser() returns a fille user Object


  | public static User getMockUser() {
  | 	User result = new User();
  | 	result.setAccountNumber("01234");
  | 	result.setAdmin(false);
  | 	result.setBankName("Western Union");
  | 	result.setBankNumber("43210");
  | 	result.setCity("Gossersweiler Stein");
  | 	result.setCompanyName("Feuchtraumbeseitigung");
  | 	result.setEmail("deep at dami.sch");
  | 	result.setHousenumber("12a");
  | 	result.setLogin("user");
  | 	result.setName("user");
  | 	result.setPassword("asswd");
  | 	result.setStreet("wersglaubt");
  | 	result.setSurname("step");
  | 	result.setZipcode("43012");
  | 	return result;
  | }

So I think my configurations are right cause the database structure is ok:

21:56:58,329 INFO  [TableMetadata] table found: PUBLIC.USER
21:56:58,329 INFO  [TableMetadata] columns: [password, banknumber, login, street, id, accountnumber, surname, bankname, companyname, housenumber, email, name, zipcode, admin, city]
21:56:58,329 INFO  [TableMetadata] foreign keys: []
21:56:58,329 INFO  [TableMetadata] indexes: [sys_pk_57, sys_idx_sys_ct_56_58]
21:56:58,344 INFO  [SchemaUpdate] schema update complete

And this is the message I get every time:
Why are the values null and ??? that's not possible. 
Anybody who has some ideas please let me know...

21:57:02,594 ERROR [STDERR] 18.07.2007 21:57:02 com.internetshop.InitializeDBCtxListener contextInitialized
INFO: ServletContext initialized, initialize DB.
21:57:03,204 INFO  [STDOUT] Hibernate: insert into User (id, name, password, admin, login, accountNumber, bankName, bankNumber, city, companyName, email, housenumber, street, surname, zipcode) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
21:57:03,250 WARN  [JDBCExceptionReporter] SQL Error: -104, SQLState: 23000
21:57:03,250 ERROR [JDBCExceptionReporter] Unique constraint violation: SYS_CT_56 in statement [insert into User (id, name, password, admin, login, accountNumber, bankName, bankNumber, city, companyName, email, housenumber, street, surname, zipcode) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]

thanks Stephan

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

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