[jboss-user] [Installation, Configuration & Deployment] - Startup Deleting Data
tinnes
do-not-reply at jboss.com
Thu Aug 3 10:58:48 EDT 2006
Database - MySQL 5.0
JBOSS - 4.03SP1
I have a problem where the startup of JBoss is removing all the data in my tables. I am playing with JSF and have created two tables country and state. The data exists after it is added and even after a re-boot of the machine. Once JBOSS is started all the data is deleted. I think the entire table is being re-created. I am using hibernate as well and at present I am not using EJB's.
This started after the machine failed and I had to replace the drive and the OS. I was able to recover the complete JBOSS Configuration and only to r-install mysql.
Obviously something is different, but I don't know what. Is there a way to tell JBOSS not to alter or create the table structures?
I don't see anything in the logs that indicates JBOSS is dropping or altering the tables but clearly something is. I am attaching the relevant sections of the logs.
10:35:14,640 INFO [Configuration] Searching for mapping documents in jar: CRM.har
10:35:14,640 INFO [Configuration] Found mapping document in jar: com/alltiers/crm/server/datatransfer/TCountry.hbm.xml
10:35:14,765 INFO [HbmBinder] Mapping class: com.alltiers.crm.server.datatransfer.TCountry -> t_country
10:35:14,812 INFO [Configuration] Found mapping document in jar: com/alltiers/crm/server/datatransfer/TState.hbm.xml
10:35:14,828 INFO [HbmBinder] Mapping class: com.alltiers.crm.server.datatransfer.TState -> t_state
10:35:14,953 INFO [Configuration] processing extends queue
10:35:14,953 INFO [Configuration] processing collection mappings
10:35:14,953 INFO [HbmBinder] Mapping collection: com.alltiers.crm.server.datatransfer.TCountry.TStates -> t_state
10:35:14,953 INFO [Configuration] processing association property references
10:35:14,953 INFO [Configuration] processing foreign key constraints
10:35:14,968 INFO [NamingHelper] JNDI InitialContext properties:{}
10:35:14,968 INFO [DatasourceConnectionProvider] Using datasource: java:/CRMDS
10:35:15,312 INFO [SettingsFactory] RDBMS: MySQL, version: 5.0.22-community-nt
10:35:15,312 INFO [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ )
10:35:15,343 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
10:35:15,359 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.transaction.JTATransactionFactory
10:35:15,359 INFO [NamingHelper] JNDI InitialContext properties:{}
10:35:15,359 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
10:35:15,359 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
10:35:15,359 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
10:35:15,359 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
10:35:15,359 INFO [SettingsFactory] Automatic flush during beforeCompletion(): enabled
10:35:15,359 INFO [SettingsFactory] Automatic session close at end of transaction: enabled
10:35:15,359 INFO [SettingsFactory] JDBC batch size: 15
10:35:15,359 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
10:35:15,359 INFO [SettingsFactory] Scrollable result sets: enabled
10:35:15,359 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): enabled
10:35:15,359 INFO [SettingsFactory] Connection release mode: after_statement
10:35:15,359 INFO [SettingsFactory] Maximum outer join fetch depth: 2
10:35:15,359 INFO [SettingsFactory] Default batch fetch size: 1
10:35:15,359 INFO [SettingsFactory] Generate SQL with comments: disabled
10:35:15,359 INFO [SettingsFactory] Order SQL updates by primary key: disabled
10:35:15,359 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
10:35:15,359 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
10:35:15,359 INFO [SettingsFactory] Query language substitutions: {}
10:35:15,359 INFO [SettingsFactory] Second-level cache: enabled
10:35:15,359 INFO [SettingsFactory] Query cache: disabled
10:35:15,359 INFO [SettingsFactory] Cache provider: org.hibernate.cache.HashtableCacheProvider
10:35:15,359 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
10:35:15,359 INFO [SettingsFactory] Structured second-level cache entries: disabled
10:35:15,375 INFO [SettingsFactory] Echoing all SQL to stdout
10:35:15,375 INFO [SettingsFactory] Statistics: disabled
10:35:15,375 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
10:35:15,375 INFO [SettingsFactory] Default entity-mode: POJO
10:35:15,546 INFO [SessionFactoryImpl] building session factory
10:35:16,078 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
10:35:16,093 INFO [Configuration] processing extends queue
10:35:16,093 INFO [Configuration] processing collection mappings
10:35:16,093 INFO [Configuration] processing association property references
10:35:16,093 INFO [Configuration] processing foreign key constraints
10:35:16,093 INFO [Configuration] processing extends queue
10:35:16,093 INFO [Configuration] processing collection mappings
10:35:16,093 INFO [Configuration] processing association property references
10:35:16,093 INFO [Configuration] processing foreign key constraints
10:35:16,093 INFO [SchemaExport] Running hbm2ddl schema export
10:35:16,093 INFO [SchemaExport] exporting generated schema to database
10:35:16,312 INFO [SchemaExport] schema export complete
10:35:16,312 INFO [Configuration] processing extends queue
10:35:16,312 INFO [Configuration] processing collection mappings
10:35:16,312 INFO [Configuration] processing association property references
10:35:16,312 INFO [Configuration] processing foreign key constraints
10:35:16,312 INFO [Configuration] processing extends queue
10:35:16,312 INFO [Configuration] processing collection mappings
10:35:16,328 INFO [Configuration] processing association property references
10:35:16,328 INFO [Configuration] processing foreign key constraints
10:35:16,328 INFO [NamingHelper] JNDI InitialContext properties:{}
10:35:16,328 INFO [SessionFactoryImpl] Checking 0 named queries
10:35:16,328 INFO [Hibernate] SessionFactory successfully built and bound into JNDI [java:/hibernate/HibernateSessionFactory]
10:35:17,875 INFO [TomcatDeployer] deploy, ctxPath=/CountryState, warUrl=.../tmp/deploy/tmp25286CountryState-exp.war/
10:35:18,390 INFO [FacesConfigurator] Reading standard config org/apache/myfaces/resource/standard-faces-config.xml
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3962879#3962879
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3962879
More information about the jboss-user
mailing list