aspose file tools*
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
Author

problem in customizing database (in MS SQL Server 2005)

Minal Singh
Greenhorn

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

Joined: Jun 06, 2007
Posts: 2718
    
    6

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 ]

SCJP, SCWCD.
|Asking Good Questions|
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem in customizing database (in MS SQL Server 2005)