problem in customizing database (in MS SQL Server 2005)

[Minal Singh]

Hi,
I am using jboss portal 2.6.4 and MS SQL server 2005.
In my application, I need to add a column to an existing table in database.
I have created jbosscmp-jdbc.xml (from standardjbosscmp-jdbc.xml) and have put it in META-INF folder. But I am getting "error in opening zip file"


2008-07-16 12:38:29,027 WARN [org.jboss.deployment.JARDeployer] Failed to add deployable jar: file:/C:/jboss-portal-2.6.4/server/default/tmp/deploy/tmp11051jbosscmp-jdbc
java.util.zip.ZipException: error in opening zip file
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.<init>(ZipFile.java:203)
at java.util.jar.JarFile.<init>(JarFile.java:132)
at java.util.jar.JarFile.<init>(JarFile.java:70)
at org.jboss.deployment.SubDeployerSupport.processNestedDeployments(SubDeployerSupport.java:377)
at org.jboss.deployment.SubDeployerSupport.init(SubDeployerSupport.java:284)
at org.jboss.deployment.MainDeployer.init(MainDeployer.java:872)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:809)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy9.deploy(Unknown Source) ......
..................

Also I have made changes in domain.hbm.xml (placed in WEB-INF of my application)

Could you please tell which all files I need to change in order to add a column to existing table.

[Amit Ghorpade]

Hi jboss.techie welcome to Javaranch,
before replying to your question, I would like you to know that your name does not follow the Javaranch Naming Policy. Please change it here.

Thanks
[ July 16, 2008: Message edited by: Amit Ghorpade ]