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

Win a copy of Head First Android this week in the Android forum!
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: 2791

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|
wood burning stoves
subject: problem in customizing database (in MS SQL Server 2005)
It's not a secret anymore!