aspose file tools*
The moose likes JBoss/WildFly and the fly likes Entity Bean Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Entity Bean Error" Watch "Entity Bean Error" New topic
Author

Entity Bean Error

Sanjib Pal
Greenhorn

Joined: Feb 08, 2010
Posts: 27
Hi!
I have a problem with a Entity bean. I have developed the entity bean in ejb2 and MyEclipse. I have created a table named qa_user, with two fields id(text) and name(text) in PostgreSQL. I have kept the driver jar file in the JBoss server lib directory and generated the home and component interfaces by using XDoclet. The problem is when I deploy the project certain exceptionx are occured, that's why not properly deployed. Here is my server condole output. I have attached my project here.

Please help me.

15:51:51,546 INFO [ServerImpl] Starting JBoss (Microcontainer)...
15:51:51,546 INFO [ServerImpl] Release ID: JBoss [The Oracle] 5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)
15:51:51,546 INFO [ServerImpl] Bootstrap URL: null
15:51:51,546 INFO [ServerImpl] Home Dir: D:\Servers\JBoss\jboss-5.1.0.GA
15:51:51,546 INFO [ServerImpl] Home URL: file:/D:/Servers/JBoss/jboss-5.1.0.GA/
15:51:51,546 INFO [ServerImpl] Library URL: file:/D:/Servers/JBoss/jboss-5.1.0.GA/lib/
15:51:51,546 INFO [ServerImpl] Patch URL: null
15:51:51,546 INFO [ServerImpl] Common Base URL: file:/D:/Servers/JBoss/jboss-5.1.0.GA/common/
15:51:51,546 INFO [ServerImpl] Common Library URL: file:/D:/Servers/JBoss/jboss-5.1.0.GA/common/lib/
15:51:51,546 INFO [ServerImpl] Server Name: default
15:51:51,546 INFO [ServerImpl] Server Base Dir: D:\Servers\JBoss\jboss-5.1.0.GA\server
15:51:51,546 INFO [ServerImpl] Server Base URL: file:/D:/Servers/JBoss/jboss-5.1.0.GA/server/
15:51:51,546 INFO [ServerImpl] Server Config URL: file:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/conf/
15:51:51,546 INFO [ServerImpl] Server Home Dir: D:\Servers\JBoss\jboss-5.1.0.GA\server\default
15:51:51,546 INFO [ServerImpl] Server Home URL: file:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/
15:51:51,546 INFO [ServerImpl] Server Data Dir: D:\Servers\JBoss\jboss-5.1.0.GA\server\default\data
15:51:51,546 INFO [ServerImpl] Server Library URL: file:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/lib/
15:51:51,546 INFO [ServerImpl] Server Log Dir: D:\Servers\JBoss\jboss-5.1.0.GA\server\default\log
15:51:51,546 INFO [ServerImpl] Server Native Dir: D:\Servers\JBoss\jboss-5.1.0.GA\server\default\tmp\native
15:51:51,546 INFO [ServerImpl] Server Temp Dir: D:\Servers\JBoss\jboss-5.1.0.GA\server\default\tmp
15:51:51,546 INFO [ServerImpl] Server Temp Deploy Dir: D:\Servers\JBoss\jboss-5.1.0.GA\server\default\tmp\deploy
15:51:53,109 INFO [ServerImpl] Starting Microcontainer, bootstrapURL=file:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/conf/bootstrap.xml
15:51:54,390 INFO [VFSCacheFactory] Initializing VFSCache [org.jboss.virtual.plugins.cache.CombinedVFSCache]
15:51:54,390 INFO [VFSCacheFactory] Using VFSCache [CombinedVFSCache[real-cache: null]]
15:51:54,937 INFO [CopyMechanism] VFS temp dir: D:\Servers\JBoss\jboss-5.1.0.GA\server\default\tmp
15:51:54,984 INFO [ZipEntryContext] VFS force nested jars copy-mode is enabled.
15:51:57,218 INFO [ServerInfo] Java version: 1.5.0_11,Sun Microsystems Inc.
15:51:57,218 INFO [ServerInfo] Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_11-b03)
15:51:57,218 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM 1.5.0_11-b03,Sun Microsystems Inc.
15:51:57,218 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
15:51:57,218 INFO [ServerInfo] VM arguments: -Djboss.home=D:\Servers\JBoss\jboss-5.1.0.GA -Djava.library.path=D:\Eclipse\bin -Djava.endorsed.dirs=D:\Servers\JBoss\jboss-5.1.0.GA\lib\endorsed -Xms128m -Xmx512m -XX:MaxPermSize=256m -agentlib:jdwp=transport=dt_socket,suspend=y,address=localhost:2528
15:51:57,281 INFO [JMXKernel] Legacy JMX core initialized
15:52:02,109 INFO [ProfileServiceBootstrap] Loading profile: ProfileKey@f2ff9b[domain=default, server=default, name=default]
15:52:06,203 INFO [WebService] Using RMI server codebase: http://127.0.0.1:8083/
15:52:21,890 INFO [NativeServerConfig] JBoss Web Services - Stack Native Core
15:52:21,890 INFO [NativeServerConfig] 3.1.2.GA
15:52:24,468 INFO [AttributeCallbackItem] Owner callback not implemented.
15:52:28,406 INFO [LogNotificationListener] Adding notification listener for logging mbean "jboss.system:service=Logging,type=Log4jService" to server org.jboss.mx.server.MBeanServerImpl@c9f93f[ defaultDomain='jboss' ]
15:52:55,453 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@24762105{vfsfile:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/TestEjb.jar/}
15:52:55,453 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@24762105{vfsfile:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/TestEjb.jar/}
15:52:55,453 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@24762105{vfsfile:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/TestEjb.jar/}
15:52:55,453 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@22554070{vfsfile:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/profileservice-secured.jar/}
15:52:55,453 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@22554070{vfsfile:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/profileservice-secured.jar/}
15:52:55,453 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@22554070{vfsfile:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/profileservice-secured.jar/}
15:52:55,453 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@22554070{vfsfile:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/profileservice-secured.jar/}
15:53:01,046 INFO [JMXConnectorServerService] JMX Connector server: service:jmx:rmi://127.0.0.1/jndi/rmi://127.0.0.1:1090/jmxconnector
15:53:01,687 INFO [MailService] Mail Service bound to java:/Mail
15:53:09,656 WARN [JBossASSecurityMetadataStore] WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messages from one node to another has not had its password changed from the installation default. Please see the JBoss Messaging user guide for instructions on how to do this.
15:53:09,703 WARN [AnnotationCreator] No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent
15:53:10,093 WARN [AnnotationCreator] No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent
15:53:10,406 INFO [TransactionManagerService] JBossTS Transaction Service (JTA version - tag:JBOSSTS_4_6_1_GA) - JBoss Inc.
15:53:10,406 INFO [TransactionManagerService] Setting up property manager MBean and JMX layer
15:53:11,312 INFO [TransactionManagerService] Initializing recovery manager
15:53:11,796 INFO [TransactionManagerService] Recovery manager configured
15:53:11,796 INFO [TransactionManagerService] Binding TransactionManager JNDI Reference
15:53:11,921 INFO [TransactionManagerService] Starting transaction recovery manager
15:53:14,265 INFO [AprLifecycleListener] The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\Eclipse\bin
15:53:14,562 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-127.0.0.1-8080
15:53:14,578 INFO [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-127.0.0.1-8009
15:53:14,671 INFO [StandardService] Starting service jboss.web
15:53:14,671 INFO [StandardEngine] Starting Servlet Engine: JBoss Web/2.1.3.GA
15:53:14,796 INFO [Catalina] Server startup in 226 ms
15:53:14,859 INFO [TomcatDeployment] deploy, ctxPath=/web-console
15:53:17,296 INFO [TomcatDeployment] deploy, ctxPath=/invoker
15:53:17,500 INFO [TomcatDeployment] deploy, ctxPath=/jbossws
15:53:17,859 INFO [RARDeployment] Required license terms exist, view vfszip:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/jboss-local-jdbc.rar/META-INF/ra.xml
15:53:17,937 INFO [RARDeployment] Required license terms exist, view vfszip:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/jboss-xa-jdbc.rar/META-INF/ra.xml
15:53:18,031 INFO [RARDeployment] Required license terms exist, view vfszip:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/jms-ra.rar/META-INF/ra.xml
15:53:18,140 INFO [RARDeployment] Required license terms exist, view vfszip:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/mail-ra.rar/META-INF/ra.xml
15:53:18,265 INFO [RARDeployment] Required license terms exist, view vfszip:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/quartz-ra.rar/META-INF/ra.xml
15:53:18,656 INFO [SimpleThreadPool] Job execution threads will use class loader of thread: main
15:53:18,781 INFO [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
15:53:18,796 INFO [RAMJobStore] RAMJobStore initialized.
15:53:18,796 INFO [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
15:53:18,796 INFO [StdSchedulerFactory] Quartz scheduler version: 1.5.2
15:53:18,796 INFO [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
15:53:21,546 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
15:53:22,937 INFO [ServerPeer] JBoss Messaging 1.4.3.GA server [0] started
15:53:23,265 INFO [ConnectionFactoryJNDIMapper] supportsFailover attribute is true on connection factory: jboss.messaging.connectionfactory:service=ClusteredConnectionFactory but post office is non clustered. So connection factory will *not* support failover
15:53:23,265 INFO [ConnectionFactoryJNDIMapper] supportsLoadBalancing attribute is true on connection factory: jboss.messaging.connectionfactory:service=ClusteredConnectionFactory but post office is non clustered. So connection factory will *not* support load balancing
15:53:23,515 INFO [ConnectionFactory] Connector bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
15:53:23,515 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@14c4cc7 started
15:53:23,562 INFO [QueueService] Queue[/queue/ExpiryQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000
15:53:23,578 INFO [QueueService] Queue[/queue/DLQ] started, fullSize=200000, pageSize=2000, downCacheSize=2000
15:53:23,578 INFO [ConnectionFactory] Connector bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
15:53:23,578 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@159836e started
15:53:23,578 INFO [ConnectionFactory] Connector bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
15:53:23,578 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@2dd6ca started
15:53:24,015 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
15:53:24,203 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=PostgresDS' to JNDI name 'java:PostgresDS'
15:53:24,453 INFO [EjbDeployer] installing bean: ejb/#SampleEntity,uid24635626
15:53:24,453 INFO [EjbDeployer] with dependencies:
15:53:24,453 INFO [EjbDeployer] and supplies:
15:53:24,453 INFO [EjbDeployer] jndi:ejb/SampleEntity
15:53:24,453 INFO [EjbDeployer] jndi:SampleEntityLocal
15:53:24,750 INFO [EjbModule] Deploying SampleEntity
15:53:25,015 WARN [EjbModule] EJB configured to bypass security. Please verify if this is intended. Bean=SampleEntity Deployment=vfsfile:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/TestEjb.jar/
15:53:28,328 ERROR [AbstractKernelController] Error installing to Start: name=jboss.j2ee:module="TestEjb.jar",service=EjbModule state=Create mode=Manual requiredState=Installed
org.jboss.deployment.DeploymentException: Error while creating table QA_USER
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:580)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:213)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:499)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)
at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:172)
at org.jboss.ejb.EjbModule.startService(EjbModule.java:495)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322)
at sun.reflect.GeneratedMethodAccessor80.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
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:668)
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189)
at $Proxy38.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
at org.jboss.system.ServiceController.start(ServiceController.java:460)
at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)
at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)
at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:361)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(AbstractProfileService.java:306)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:271)
at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
at org.jboss.Main.boot(Main.java:221)
at org.jboss.Main$1.run(Main.java:556)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Wrong data type: TEXT in statement [CREATE TABLE QA_USER (id TEXT]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:249)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:567)
... 68 more

15:53:28,343 INFO [ProxyFactory] Unbind EJB Home 'SampleEntity' from jndi 'ejb/SampleEntity'
15:53:28,343 INFO [EjbModule] Undeployed SampleEntity
15:53:28,359 ERROR [AbstractKernelController] Error installing to Real: name=vfsfile:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/TestEjb.jar/ state=PreReal mode=Manual requiredState=Real
org.jboss.deployment.DeploymentException: Error while creating table QA_USER
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:580)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:213)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:499)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)
at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:172)
at org.jboss.ejb.EjbModule.startService(EjbModule.java:495)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322)
at sun.reflect.GeneratedMethodAccessor80.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
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:668)
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189)
at $Proxy38.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
at org.jboss.system.ServiceController.start(ServiceController.java:460)
at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)
at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)
at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:361)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(AbstractProfileService.java:306)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:271)
at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
at org.jboss.Main.boot(Main.java:221)
at org.jboss.Main$1.run(Main.java:556)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Wrong data type: TEXT in statement [CREATE TABLE QA_USER (id TEXT]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:249)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:567)
... 68 more

15:53:31,328 INFO [JBossASKernel] Created KernelDeployment for: profileservice-secured.jar
15:53:31,343 INFO [JBossASKernel] installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3
15:53:31,343 INFO [JBossASKernel] with dependencies:
15:53:31,343 INFO [JBossASKernel] and demands:
15:53:31,343 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
15:53:31,343 INFO [JBossASKernel] and supplies:
15:53:31,343 INFO [JBossASKernel] jndi:SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView
15:53:31,343 INFO [JBossASKernel] jndi:SecureManagementView/remote
15:53:31,343 INFO [JBossASKernel] Class:org.jboss.deployers.spi.management.ManagementView
15:53:31,343 INFO [JBossASKernel] Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3) to KernelDeployment of: profileservice-secured.jar
15:53:31,343 INFO [JBossASKernel] installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3
15:53:31,343 INFO [JBossASKernel] with dependencies:
15:53:31,343 INFO [JBossASKernel] and demands:
15:53:31,343 INFO [JBossASKernel] jndi:SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView
15:53:31,343 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
15:53:31,343 INFO [JBossASKernel] and supplies:
15:53:31,343 INFO [JBossASKernel] jndi:SecureProfileService/remote
15:53:31,343 INFO [JBossASKernel] jndi:SecureProfileService/remote-org.jboss.profileservice.spi.ProfileService
15:53:31,343 INFO [JBossASKernel] Class:org.jboss.profileservice.spi.ProfileService
15:53:31,343 INFO [JBossASKernel] Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3) to KernelDeployment of: profileservice-secured.jar
15:53:31,359 INFO [JBossASKernel] installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3
15:53:31,359 INFO [JBossASKernel] with dependencies:
15:53:31,359 INFO [JBossASKernel] and demands:
15:53:31,359 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
15:53:31,359 INFO [JBossASKernel] and supplies:
15:53:31,359 INFO [JBossASKernel] jndi:SecureDeploymentManager/remote-org.jboss.deployers.spi.management.deploy.DeploymentManager
15:53:31,359 INFO [JBossASKernel] jndi:SecureDeploymentManager/remote
15:53:31,359 INFO [JBossASKernel] Class:org.jboss.deployers.spi.management.deploy.DeploymentManager
15:53:31,359 INFO [JBossASKernel] Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3) to KernelDeployment of: profileservice-secured.jar
15:53:31,390 INFO [EJB3EndpointDeployer] Deploy AbstractBeanMetaData@72d8c{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties=[container] constructor=null autowireCandidate=true}
15:53:31,390 INFO [EJB3EndpointDeployer] Deploy AbstractBeanMetaData@16d471b{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties=[container] constructor=null autowireCandidate=true}
15:53:31,390 INFO [EJB3EndpointDeployer] Deploy AbstractBeanMetaData@1e578b5{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties=[container] constructor=null autowireCandidate=true}
15:53:31,703 INFO [SessionSpecContainer] Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3
15:53:31,781 INFO [EJBContainer] STARTED EJB: org.jboss.profileservice.ejb.SecureManagementView ejbName: SecureManagementView
15:53:32,000 INFO [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:

SecureManagementView/remote - EJB3.x Default Remote Business Interface
SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView - EJB3.x Remote Business Interface

15:53:32,171 INFO [SessionSpecContainer] Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3
15:53:32,171 INFO [EJBContainer] STARTED EJB: org.jboss.profileservice.ejb.SecureProfileServiceBean ejbName: SecureProfileService
15:53:32,218 INFO [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:

SecureProfileService/remote - EJB3.x Default Remote Business Interface
SecureProfileService/remote-org.jboss.profileservice.spi.ProfileService - EJB3.x Remote Business Interface

15:53:32,359 INFO [SessionSpecContainer] Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3
15:53:32,359 INFO [EJBContainer] STARTED EJB: org.jboss.profileservice.ejb.SecureDeploymentManager ejbName: SecureDeploymentManager
15:53:32,437 INFO [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:

SecureDeploymentManager/remote - EJB3.x Default Remote Business Interface
SecureDeploymentManager/remote-org.jboss.deployers.spi.management.deploy.DeploymentManager - EJB3.x Remote Business Interface

15:53:32,921 INFO [TomcatDeployment] deploy, ctxPath=/admin-console
15:53:33,140 INFO [config] Initializing Mojarra (1.2_12-b01-FCS) for context '/admin-console'
15:53:42,765 INFO [TomcatDeployment] deploy, ctxPath=/
15:53:42,968 INFO [TomcatDeployment] deploy, ctxPath=/jmx-console
15:53:43,156 ERROR [ProfileServiceBootstrap] Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

DEPLOYMENTS IN ERROR:
Deployment "vfsfile:/D:/Servers/JBoss/jboss-5.1.0.GA/server/default/deploy/TestEjb.jar/" is in error due to the following reason(s): java.sql.SQLException: Wrong data type: TEXT in statement [CREATE TABLE QA_USER (id TEXT]


15:53:43,171 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
15:53:43,250 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
15:53:43,296 INFO [ServerImpl] JBoss (Microcontainer) [5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)] Started in 1m:51s:734ms

SCJP 5.0
Try unless you get the ultimate success.
Rohithaksha Kalluraya
Greenhorn

Joined: Jan 12, 2010
Posts: 10
It looks like your database does not support
TEXT
data type. You probably should try changing it to
VARCHAR
.
Sanjib Pal
Greenhorn

Joined: Feb 08, 2010
Posts: 27
Rohithaksha Kalluraya wrote:It looks like your database does not support
TEXT
data type. You probably should try changing it to
VARCHAR
.



Thank you. It has solved accordingly.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Entity Bean Error