wood burning stoves 2.0
The moose likes Portals and Portlets and the fly likes problem in customizing database (in MS SQL Server 2005) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Portals and Portlets
Bookmark "problem in customizing database (in MS SQL Server 2005)" Watch "problem in customizing database (in MS SQL Server 2005)" New topic

problem in customizing database (in MS SQL Server 2005)

Minal Singh

Joined: Jul 16, 2008
Posts: 2
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

Joined: Jun 06, 2007
Posts: 2801

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.

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

|Asking Good Questions|
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: problem in customizing database (in MS SQL Server 2005)
It's not a secret anymore!