This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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
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: 2716
    
    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)
 
Similar Threads
Zip file exception
A storm of errors on JBoss 4.0.2
getting error while starting the jboss
Failed to add deployable jar java.util.zip.ZipException: error in opening zip file
java.util.zip.ZipException