掲示板

How can i create my own table

thumbnail
12年前 に Nitesh Sahay によって更新されました。

How can i create my own table

Junior Member 投稿: 58 参加年月日: 11/11/28 最新の投稿
I need to create my own table at the time of portlet deployemet for first time...
For exm.. i want to create table OrgPortlet(portletId varchar(50),userID varchar(20)) when a portlet or hook named MyOrg is deployed..
and then i want to insert value to this table when a portlet is deployed... so my ques.. is
How can i create my own table and insert value to that table at the time of portlet deployement ?....
thumbnail
12年前 に David H Nebinger によって更新されました。

RE: How can i create my own table

Liferay Legend 投稿: 14916 参加年月日: 06/09/02 最新の投稿
Use service builder. You can include scripts for creating the table and it should be processed when deployed.
thumbnail
12年前 に Nitesh Sahay によって更新されました。

RE: How can i create my own table

Junior Member 投稿: 58 参加年月日: 11/11/28 最新の投稿
Thanks for response, i have created a service builder but on going to build service it throws an exception...
Error creating bean with name liferaySessionFactory.....
thumbnail
12年前 に Hitoshi Ozawa によって更新されました。

RE: How can i create my own table

Liferay Legend 投稿: 7942 参加年月日: 10/03/24 最新の投稿
Thanks for response, i have created a service builder but on going to build service it throws an exception...
Error creating bean with name liferaySessionFactory.....


Probably because there's some error in your service.xml

To get some reasonable help, it would help to post your service.xml and error messages here.
thumbnail
12年前 に Nitesh Sahay によって更新されました。

RE: How can i create my own table

Junior Member 投稿: 58 参加年月日: 11/11/28 最新の投稿
Hi Hitoshi thanks for ur response....
error.... is as follows...
[java] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferaySessionFactory' defined in class path resource [META-INF/hibernate-spring.xml]: Cannot create inner bean 'com.liferay.portal.kernel.util.PortalClassLoaderUtil#63a6b16f' of type [com.liferay.portal.kernel.util.PortalClassLoaderUtil] while setting bean property 'sessionFactoryClassLoader'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.kernel.util.PortalClassLoaderUtil#63a6b16f' defined in class path resource [META-INF/hibernate-spring.xml]: Initialization of bean failed; nested exception is org.aspectj.weaver.reflect.ReflectionWorld$ReflectionWorldException: warning can't determine superclass of missing type org.apache.tools.ant.loader.AntClassLoader5
[java] [Xlint:cantFindType]
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:194)
[java] at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)
[java] at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)
[java] at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)
[java] at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)
[java] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
[java] at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:597)
[java] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[java] at org.apache.tools.ant.Task.perform(Task.java:348)
[java] at org.apache.tools.ant.Target.execute(Target.java:390)
[java] at org.apache.tools.ant.Target.performTasks(Target.java:411)
[java] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
[java] at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
[java] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[java] at org.eclipse.ant.internal.launching.remote.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
[java] at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
[java] at org.eclipse.ant.internal.launching.remote.InternalAntRunner.run(InternalAntRunner.java:424)
[java] at org.eclipse.ant.internal.launching.remote.InternalAntRunner.main(InternalAntRunner.java:138)
[java] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferaySessionFactory' defined in class path resource [META-INF/hibernate-spring.xml]: Cannot create inner bean 'com.liferay.portal.kernel.util.PortalClassLoaderUtil#63a6b16f' of type [com.liferay.portal.kernel.util.PortalClassLoaderUtil] while setting bean property 'sessionFactoryClassLoader'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.kernel.util.PortalClassLoaderUtil#63a6b16f' defined in class path resource [META-INF/hibernate-spring.xml]: Initialization of bean failed; nested exception is org.aspectj.weaver.reflect.ReflectionWorld$ReflectionWorldException: warning can't determine superclass of missing type org.apache.tools.ant.loader.AntClassLoader5
[java] [Xlint:cantFindType]
[java] at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:281)
[java] at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:120)
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
[java] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
[java] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
[java] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
[java] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
[java] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
[java] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
[java] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
[java] at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
[java] at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93)
[java] at com.liferay.portal.spring.context.ArrayApplicationContext.<init>(ArrayApplicationContext.java:31)
[java] at com.liferay.portal.spring.util.SpringUtil.loadContext(SpringUtil.java:54)
[java] at com.liferay.portal.util.InitUtil.initWithSpring(InitUtil.java:136)
[java] at com.liferay.portal.tools.servicebuilder.ServiceBuilder.main(ServiceBuilder.java:108)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:597)
thumbnail
12年前 に Jitendra Rajput によって更新されました。

RE: How can i create my own table

Liferay Master 投稿: 875 参加年月日: 11/01/07 最新の投稿
It would be great if you can post your service.xml
thumbnail
12年前 に Nitesh Sahay によって更新されました。

RE: How can i create my own table

Junior Member 投稿: 58 参加年月日: 11/11/28 最新の投稿
My service.xml as follows...

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE service-builder PUBLIC "-//Liferay//DTD Service Builder 6.0.0//EN" "http://www.liferay.com/dtd/liferay-service-builder_6_0_0.dtd">
<service-builder package-path="">
<author>nitesh</author>
<namespace>dd</namespace>

<entity name="Foo" local-service="true" remote-service="true">

<!-- PK fields -->

<column name="fooId" type="long" primary="true" />

<!-- Audit fields -->

<column name="companyId" type="long" />
<column name="userId" type="long" />
<column name="userName" type="String" />
<column name="createDate" type="Date" />
<column name="modifiedDate" type="Date" />


<!-- Order -->

<order by="asc">
<order-column name="userName" />
</order>

<!-- Finder methods -->

<finder name="Field2" return-type="Collection">
<finder-column name="userName" />
</finder>
</entity>
</service-builder>
thumbnail
12年前 に Jitendra Rajput によって更新されました。

RE: How can i create my own table

Liferay Master 投稿: 875 参加年月日: 11/01/07 最新の投稿
Have a look in this link .It may help you .

https://www.dnebinger.com/wiki/-/wiki/Portal+Development/Creating+the+Liferay+Service
thumbnail
12年前 に Nitesh Sahay によって更新されました。

RE: How can i create my own table

Junior Member 投稿: 58 参加年月日: 11/11/28 最新の投稿
I followed that link.....but when i build ...console shows BUILD SUCCESSFULLY but with some error...also no other files are created automatically only sql and services directory has been created....
The console is looks like that....
[java] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferaySessionFactory' defined in class path resource [META-INF/hibernate-spring.xml]: Cannot create inner bean 'com.liferay.portal.kernel.util.PortalClassLoaderUtil#355c6c8d' of type [com.liferay.portal.kernel.util.PortalClassLoaderUtil] while setting bean property 'sessionFactoryClassLoader'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.kernel.util.PortalClassLoaderUtil#355c6c8d' defined in class path resource [META-INF/hibernate-spring.xml]: Initialization of bean failed; nested exception is org.aspectj.weaver.reflect.ReflectionWorld$ReflectionWorldException: warning can't determine superclass of missing type org.apache.tools.ant.loader.AntClassLoader5
[java] [Xlint:cantFindType]
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:194)
[java] at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)
[java] at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)
[java] at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)
[java] at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)
[java] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
[java] at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:597)
[java] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[java] at org.apache.tools.ant.Task.perform(Task.java:348)
[java] at org.apache.tools.ant.Target.execute(Target.java:390)
[java] at org.apache.tools.ant.Target.performTasks(Target.java:411)
[java] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
[java] at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
[java] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[java] at org.eclipse.ant.internal.launching.remote.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
[java] at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
[java] at org.eclipse.ant.internal.launching.remote.InternalAntRunner.run(InternalAntRunner.java:424)
[java] at org.eclipse.ant.internal.launching.remote.InternalAntRunner.main(InternalAntRunner.java:138)
[java] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liferaySessionFactory' defined in class path resource [META-INF/hibernate-spring.xml]: Cannot create inner bean 'com.liferay.portal.kernel.util.PortalClassLoaderUtil#355c6c8d' of type [com.liferay.portal.kernel.util.PortalClassLoaderUtil] while setting bean property 'sessionFactoryClassLoader'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.kernel.util.PortalClassLoaderUtil#355c6c8d' defined in class path resource [META-INF/hibernate-spring.xml]: Initialization of bean failed; nested exception is org.aspectj.weaver.reflect.ReflectionWorld$ReflectionWorldException: warning can't determine superclass of missing type org.apache.tools.ant.loader.AntClassLoader5
[java] [Xlint:cantFindType]
[java] at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:281)
[java] at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:120)
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
[java] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
[java] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
[java] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
[java] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
[java] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
[java] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
[java] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
[java] at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
[java] at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93)
[java] at com.liferay.portal.spring.context.ArrayApplicationContext.<init>(ArrayApplicationContext.java:31)
[java] at com.liferay.portal.spring.util.SpringUtil.loadContext(SpringUtil.java:54)
[java] at com.liferay.portal.util.InitUtil.initWithSpring(InitUtil.java:136)
[java] at com.liferay.portal.tools.servicebuilder.ServiceBuilder.main(ServiceBuilder.java:108)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at java.lang.reflect.Method.invoke(Method.java:597)
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)
[java] at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)
[java] ... 19 more
[java] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.liferay.portal.kernel.util.PortalClassLoaderUtil#355c6c8d' defined in class path resource [META-INF/hibernate-spring.xml]: Initialization of bean failed; nested exception is org.aspectj.weaver.reflect.ReflectionWorld$ReflectionWorldException: warning can't determine superclass of missing type org.apache.tools.ant.loader.AntClassLoader5
[java] [Xlint:cantFindType]
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:527)
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
[java] at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:270)
[java] ... 43 more
[java] Caused by: org.aspectj.weaver.reflect.ReflectionWorld$ReflectionWorldException: warning can't determine superclass of missing type org.apache.tools.ant.loader.AntClassLoader5
[java] [Xlint:cantFindType]
[java] at org.aspectj.weaver.reflect.ReflectionWorld$ExceptionBasedMessageHandler.handleMessage(ReflectionWorld.java:129)
[java] at org.aspectj.weaver.Lint$Kind.signal(Lint.java:316)
[java] at org.aspectj.weaver.MissingResolvedTypeWithKnownSignature.raiseCantFindType(MissingResolvedTypeWithKnownSignature.java:232)
[java] at org.aspectj.weaver.MissingResolvedTypeWithKnownSignature.getSuperclass(MissingResolvedTypeWithKnownSignature.java:98)
[java] at org.aspectj.weaver.patterns.KindedPointcut.fastMatch(KindedPointcut.java:144)
[java] at org.aspectj.weaver.patterns.OrPointcut.fastMatch(OrPointcut.java:47)
[java] at org.aspectj.weaver.internal.tools.PointcutExpressionImpl.couldMatchJoinPointsInType(PointcutExpressionImpl.java:82)
[java] at org.springframework.aop.aspectj.AspectJExpressionPointcut.matches(AspectJExpressionPointcut.java:238)
[java] at org.springframework.aop.support.AopUtils.canApply(AopUtils.java:200)
[java] at org.springframework.aop.support.AopUtils.canApply(AopUtils.java:254)
[java] at org.springframework.aop.support.AopUtils.findAdvisorsThatCanApply(AopUtils.java:286)
[java] at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findAdvisorsThatCanApply(AbstractAdvisorAutoProxyCreator.java:117)
[java] at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findEligibleAdvisors(AbstractAdvisorAutoProxyCreator.java:87)
[java] at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.getAdvicesAndAdvisorsForBean(AbstractAdvisorAutoProxyCreator.java:68)
[java] at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.wrapIfNecessary(AbstractAutoProxyCreator.java:359)
[java] at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessAfterInitialization(AbstractAutoProxyCreator.java:322)
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:407)
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1426)
[java] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
[java] ... 45 more
[java] Java Result: -1
[echo] ${service.test.output}
[mkdir] Created dir: /home/nitesh/Desktop/appstest7cogs/liferay-plugins-sdk-6.1.0/hooks/demo-hook/docroot/WEB-INF/service-classes
compile-java:
[zip] Warning: skipping zip archive /home/nitesh/Desktop/appstest7cogs/liferay-plugins-sdk-6.1.0/hooks/demo-hook/docroot/WEB-INF/lib/demo-hook-service.jar because no files were included.
[delete] Deleting directory /home/nitesh/Desktop/appstest7cogs/liferay-plugins-sdk-6.1.0/hooks/demo-hook/docroot/WEB-INF/service-classes
BUILD SUCCESSFUL
Total time: 46 seconds