David Leuschner wrote:
>
> Hi,
>
> i added some cmp-fields in my bean and redeployed it. now i'm getting lots
> of exceptions because on redeployment jboss 1 doesn't recreate the table and
> so columns in the table are missing. is there an easy way (without having to
> connect to the database and deleting the table) to let jboss recreate the
> table on redeploy?
No you would have to connect to the database manually and remove the
tables.
Also we are commiting some bug fixes.
You might want to try jBoss 2.0 as well.
regards
marc
>
> thanks in advance
>
> --david leuschner
>
> example:
> [sql] executing statement SELECT COUNT(*) AS Total FROM LieferantBean WHERE
> LieferantID = ?
> Result is 1
> 1
> Table Name is LieferantBean
> [sql] executing statement SELECT Name, Passwort, Kuerzel, Homepage,
> KundenNr, PIN, LieferantID FROM LieferantBean WHERE Liefera
> ntID = ?
> [Exception]
> java.sql.SQLException: Column not found: PASSWORT in statement [ SELECT
> Name, Passwort, Kuerzel, Homepage, KundenNr, PIN, Liefera
> ntID FROM LieferantBean WHERE LieferantID = 1 ]
> at org.hsql.Trace.getError(Trace.java:124)
> at org.hsql.jdbcResultSet.<init>(jdbcResultSet.java:1790)
> at
> org.hsql.jdbcConnection.executeStandalone(jdbcConnection.java:686)
> at org.hsql.jdbcConnection.execute(jdbcConnection.java:541)
> at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499)
> at org.hsql.jdbcStatement.executeQuery(jdbcStatement.java:37)
> at
> org.hsql.jdbcPreparedStatement.executeQuery(jdbcPreparedStatement.java:99)
> at
> org.jaws.PersistentStorageJDBC.load(PersistentStorageJDBC.java:239)
> at
> org.ejboss.ejb.EnterpriseBeanWrapper.interposeOnLoad(EnterpriseBeanWrapper.j
> ava:1161)
> at
> org.ejboss.ejb.EnterpriseBeanWrapper.interposeOnTransaction(EnterpriseBeanWr
> apper.java:915)
> at
> org.ejboss.ejb.EnterpriseBeanWrapper.invoke(EnterpriseBeanWrapper.java:440)
> at
> org.ejboss.container.Container.interposeOnObjectRemove(Container.java:1171)
> at org.ejboss.container.Container.invoke(Container.java:769)
> at
> org.ejboss.invocation.RemoteInvocationHandlerLocalImpl.invoke(RemoteInvocati
> onHandlerLocalImpl.java:63)
> at
> org.ejboss.container.ProxyContainer.invoke(ProxyContainer.java:192)
> at
> org.ejboss.container.ProxyContainerForObject.invoke(ProxyContainerForObject.
> java:282)
> at $Proxy2.remove(Unknown Source)
> at
> org.ejboss.container.Container.interposeOnHomeRemoveByPK(Container.java:975)
> at org.ejboss.container.Container.invoke(Container.java:738)
> at
> org.ejboss.invocation.RemoteInvocationHandlerImpl.invoke(RemoteInvocationHan
> dlerImpl.java:103)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
> at sun.rmi.transport.Transport$1.run(Transport.java:142)
> at java.security.AccessController.doPrivileged(Native Method)
> at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
> at
> sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
> at
> sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:6
> 43)
> at java.lang.Thread.run(Thread.java:484)
> [wrapper] in terminate Transaction
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
