Kit | 2013-04-15 11:52:41.0 | |
| I need to be able to use GenerationType = IDENTITY for a few of my entity classes that are connected to the FoxPro database via the HXTT DBF driver.
I do know that I need to update our license which I will do very soon. If you need me to do that before you are able to answer my question, that is fine. Or if a more up-to-date version of the driver will solve my problem, then I will take care of that. Thanks. Here is an example piece of one of my entity classes: @Entity @Table(name = "zSTPARM", catalog = "meis") public class StationParameter implements Serializable { private static final long serialVersionUID = 1L; @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "ID", nullable = false) private Integer id; Here is the stacktrace that is produced on the glassfish server when I go to deploy: INFO: com.turbocor.meis.factoryservices.db.meis.PartType actually got transformed INFO: com.turbocor.meis.factoryservices.db.wm.MODET actually got transformed INFO: com.turbocor.meis.factoryservices.db.wm.INV actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.PartSerialNumber actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.PartEventType actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.StationParameter actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.Station actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.PartEventData actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.PartEvent actually got transformed INFO: com.turbocor.meis.factoryservices.db.wm.BOM actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.PartData actually got transformed INFO: EclipseLink, version: Eclipse Persistence Services - 2.3.2.v20111125-r10461 INFO: Not able to detect platform for vendor name [HXTT DBF5]. Defaulting to [org.eclipse.persistence.platform.database.DatabasePlatform]. The database dialect used may not match with the database you are using. Please explicitly provide a platform using property eclipselink.platform.class.name. SEVERE: Local Exception Stack: Exception [EclipseLink-7144] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.ValidationException Exception Description: SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence. at org.eclipse.persistence.exceptions.ValidationException.platformDoesNotSupportSequence(ValidationException.java:2018) at org.eclipse.persistence.sequencing.NativeSequence.onConnect(NativeSequence.java:143) at org.eclipse.persistence.sequencing.Sequence.onConnect(Sequence.java:270) at org.eclipse.persistence.internal.sequencing.SequencingManager.onConnectSequences(SequencingManager.java:927) at org.eclipse.persistence.internal.sequencing.SequencingManager.onConnectInternal(SequencingManager.java:747) at org.eclipse.persistence.internal.sequencing.SequencingManager.onConnect(SequencingManager.java:700) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeSequencing(DatabaseSessionImpl.java:151) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:480) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:476) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:435) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:676) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:621) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:272) at org.glassfish.persistence.jpa.PersistenceUnitLoader.loadPU(PersistenceUnitLoader.java:211) at org.glassfish.persistence.jpa.PersistenceUnitLoader. at org.glassfish.persistence.jpa.JPADeployer$1.visitPUD(JPADeployer.java:224) at org.glassfish.persistence.jpa.JPADeployer$PersistenceUnitDescriptorIterator.iteratePUDs(JPADeployer.java:495) at org.glassfish.persistence.jpa.JPADeployer.createEMFs(JPADeployer.java:233) at org.glassfish.persistence.jpa.JPADeployer.prepare(JPADeployer.java:168) at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:871) at org.glassfish.javaee.full.deployment.EarDeployer.prepareBundle(EarDeployer.java:290) at org.glassfish.javaee.full.deployment.EarDeployer.access$200(EarDeployer.java:86) at org.glassfish.javaee.full.deployment.EarDeployer$1.doBundle(EarDeployer.java:141) at org.glassfish.javaee.full.deployment.EarDeployer$1.doBundle(EarDeployer.java:138) at org.glassfish.javaee.full.deployment.EarDeployer.doOnBundles(EarDeployer.java:215) at org.glassfish.javaee.full.deployment.EarDeployer.doOnAllTypedBundles(EarDeployer.java:224) at org.glassfish.javaee.full.deployment.EarDeployer.doOnAllBundles(EarDeployer.java:250) at org.glassfish.javaee.full.deployment.EarDeployer.prepare(EarDeployer.java:138) at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:871) at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:410) at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:240) at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:389) at com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:348) at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:363) at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1085) at com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:95) at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1291) at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1259) at com.sun.enterprise.v3.admin.AdminAdapter.doCommand(AdminAdapter.java:461) at com.sun.enterprise.v3.admin.AdminAdapter.service(AdminAdapter.java:212) at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179) at com.sun.enterprise.v3.server.HK2Dispatcher.dispath(HK2Dispatcher.java:117) at com.sun.enterprise.v3.services.impl.ContainerMapper$Hk2DispatcherCallable.call(ContainerMapper.java:354) at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195) at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860) at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757) at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056) at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229) at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137) at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104) at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90) at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79) at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54) at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59) at com.sun.grizzly.ContextTask.run(ContextTask.java:71) at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532) at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513) at java.lang.Thread.run(Thread.java:722) WARNING: Multiple [2] JMX MBeanServer instances exist, we will use the server at index [0] : [com.sun.enterprise.v3.admin.DynamicInterceptor@156f8b9]. WARNING: JMX MBeanServer in use: [com.sun.enterprise.v3.admin.DynamicInterceptor@156f8b9] from index [0] WARNING: JMX MBeanServer in use: [com.sun.jmx.mbeanserver.JmxMBeanServer@bf4c88] from index [1] WARNING: Problem while unregistering MBean: javax.management.InstanceNotFoundException: TopLink:Name=Development-file_/C_/Users/kkennedy/Documents/NetBeansProjects/FactoryServices/dist/gfdeploy/FactoryServices/FactoryServices-ejb_jar/_Local-FoxPro-ejbPU,Type=Configuration WARNING: Problem while unregistering MBean: javax.management.InstanceNotFoundException: TopLink:Name=Session(file_/C_/Users/kkennedy/Documents/NetBeansProjects/FactoryServices/dist/gfdeploy/FactoryServices/FactoryServices-ejb_jar/_Local-FoxPro-ejbPU) INFO: file:/C:/Users/kkennedy/Documents/NetBeansProjects/FactoryServices/dist/gfdeploy/FactoryServices/FactoryServices-ejb_jar/_Local-FoxPro-ejbPU logout successful SEVERE: Exception while invoking class org.glassfish.persistence.jpa.JPADeployer prepare method SEVERE: Exception while invoking class org.glassfish.javaee.full.deployment.EarDeployer prepare method SEVERE: Exception while preparing the app SEVERE: Exception [EclipseLink-7144] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.ValidationException Exception Description: SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence. org.glassfish.deployment.common.DeploymentException: Exception [EclipseLink-7144] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.ValidationException Exception Description: SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence. at org.glassfish.javaee.full.deployment.EarDeployer.prepare(EarDeployer.java:166) at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:871) at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:410) at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:240) at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:389) at com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:348) at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:363) at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1085) at com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:95) at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1291) at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1259) at com.sun.enterprise.v3.admin.AdminAdapter.doCommand(AdminAdapter.java:461) at com.sun.enterprise.v3.admin.AdminAdapter.service(AdminAdapter.java:212) at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179) at com.sun.enterprise.v3.server.HK2Dispatcher.dispath(HK2Dispatcher.java:117) at com.sun.enterprise.v3.services.impl.ContainerMapper$Hk2DispatcherCallable.call(ContainerMapper.java:354) at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195) at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860) at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757) at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056) at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229) at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137) at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104) at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90) at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79) at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54) at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59) at com.sun.grizzly.ContextTask.run(ContextTask.java:71) at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532) at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513) at java.lang.Thread.run(Thread.java:722) Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-7144] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.ValidationException Exception Description: SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence. at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:517) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:272) at org.glassfish.persistence.jpa.PersistenceUnitLoader.loadPU(PersistenceUnitLoader.java:211) at org.glassfish.persistence.jpa.PersistenceUnitLoader. at org.glassfish.persistence.jpa.JPADeployer$1.visitPUD(JPADeployer.java:224) at org.glassfish.persistence.jpa.JPADeployer$PersistenceUnitDescriptorIterator.iteratePUDs(JPADeployer.java:495) at org.glassfish.persistence.jpa.JPADeployer.createEMFs(JPADeployer.java:233) at org.glassfish.persistence.jpa.JPADeployer.prepare(JPADeployer.java:168) at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:871) at org.glassfish.javaee.full.deployment.EarDeployer.prepareBundle(EarDeployer.java:290) at org.glassfish.javaee.full.deployment.EarDeployer.access$200(EarDeployer.java:86) at org.glassfish.javaee.full.deployment.EarDeployer$1.doBundle(EarDeployer.java:141) at org.glassfish.javaee.full.deployment.EarDeployer$1.doBundle(EarDeployer.java:138) at org.glassfish.javaee.full.deployment.EarDeployer.doOnBundles(EarDeployer.java:215) at org.glassfish.javaee.full.deployment.EarDeployer.doOnAllTypedBundles(EarDeployer.java:224) at org.glassfish.javaee.full.deployment.EarDeployer.doOnAllBundles(EarDeployer.java:250) at org.glassfish.javaee.full.deployment.EarDeployer.prepare(EarDeployer.java:138) ... 30 more Caused by: Exception [EclipseLink-7144] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.ValidationException Exception Description: SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence. at org.eclipse.persistence.exceptions.ValidationException.platformDoesNotSupportSequence(ValidationException.java:2018) at org.eclipse.persistence.sequencing.NativeSequence.onConnect(NativeSequence.java:143) at org.eclipse.persistence.sequencing.Sequence.onConnect(Sequence.java:270) at org.eclipse.persistence.internal.sequencing.SequencingManager.onConnectSequences(SequencingManager.java:927) at org.eclipse.persistence.internal.sequencing.SequencingManager.onConnectInternal(SequencingManager.java:747) at org.eclipse.persistence.internal.sequencing.SequencingManager.onConnect(SequencingManager.java:700) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeSequencing(DatabaseSessionImpl.java:151) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:480) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:476) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:435) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:676) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:621) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488) ... 49 more SEVERE: Exception while preparing the app : Exception [EclipseLink-7144] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.ValidationException Exception Description: SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence. javax.persistence.PersistenceException: Exception [EclipseLink-7144] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.ValidationException Exception Description: SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence. at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:517) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:272) at org.glassfish.persistence.jpa.PersistenceUnitLoader.loadPU(PersistenceUnitLoader.java:211) at org.glassfish.persistence.jpa.PersistenceUnitLoader. at org.glassfish.persistence.jpa.JPADeployer$1.visitPUD(JPADeployer.java:224) at org.glassfish.persistence.jpa.JPADeployer$PersistenceUnitDescriptorIterator.iteratePUDs(JPADeployer.java:495) at org.glassfish.persistence.jpa.JPADeployer.createEMFs(JPADeployer.java:233) at org.glassfish.persistence.jpa.JPADeployer.prepare(JPADeployer.java:168) at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:871) at org.glassfish.javaee.full.deployment.EarDeployer.prepareBundle(EarDeployer.java:290) at org.glassfish.javaee.full.deployment.EarDeployer.access$200(EarDeployer.java:86) at org.glassfish.javaee.full.deployment.EarDeployer$1.doBundle(EarDeployer.java:141) at org.glassfish.javaee.full.deployment.EarDeployer$1.doBundle(EarDeployer.java:138) at org.glassfish.javaee.full.deployment.EarDeployer.doOnBundles(EarDeployer.java:215) at org.glassfish.javaee.full.deployment.EarDeployer.doOnAllTypedBundles(EarDeployer.java:224) at org.glassfish.javaee.full.deployment.EarDeployer.doOnAllBundles(EarDeployer.java:250) at org.glassfish.javaee.full.deployment.EarDeployer.prepare(EarDeployer.java:138) at com.sun.enterprise.v3.server.ApplicationLifecycle.prepareModule(ApplicationLifecycle.java:871) at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:410) at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:240) at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:389) at com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:348) at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:363) at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1085) at com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:95) at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1291) at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1259) at com.sun.enterprise.v3.admin.AdminAdapter.doCommand(AdminAdapter.java:461) at com.sun.enterprise.v3.admin.AdminAdapter.service(AdminAdapter.java:212) at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179) at com.sun.enterprise.v3.server.HK2Dispatcher.dispath(HK2Dispatcher.java:117) at com.sun.enterprise.v3.services.impl.ContainerMapper$Hk2DispatcherCallable.call(ContainerMapper.java:354) at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195) at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860) at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757) at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056) at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229) at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137) at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104) at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90) at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79) at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54) at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59) at com.sun.grizzly.ContextTask.run(ContextTask.java:71) at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532) at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513) at java.lang.Thread.run(Thread.java:722) Caused by: Exception [EclipseLink-7144] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.ValidationException Exception Description: SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence. at org.eclipse.persistence.exceptions.ValidationException.platformDoesNotSupportSequence(ValidationException.java:2018) at org.eclipse.persistence.sequencing.NativeSequence.onConnect(NativeSequence.java:143) at org.eclipse.persistence.sequencing.Sequence.onConnect(Sequence.java:270) at org.eclipse.persistence.internal.sequencing.SequencingManager.onConnectSequences(SequencingManager.java:927) at org.eclipse.persistence.internal.sequencing.SequencingManager.onConnectInternal(SequencingManager.java:747) at org.eclipse.persistence.internal.sequencing.SequencingManager.onConnect(SequencingManager.java:700) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeSequencing(DatabaseSessionImpl.java:151) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:480) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:476) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:435) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postConnectDatasource(DatabaseSessionImpl.java:676) at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:621) at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206) at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488) ... 49 more | ||
Kit | 2013-04-15 12:17:44.0 | |
| Correction:
We have renewed our license. I am using version 5.1.096. I still get the above stated problem. | ||
HXTT Support | 2013-04-15 16:31:23.0 | |
| >@GeneratedValue(strategy = GenerationType.IDENTITY)
Try @GeneratedValue(strategy=GenerationType.AUTO) | ||
Kit | 2013-04-15 19:09:53.0 | |
| I actually had tried that and it gave me a different error. But I need GenerationType of Identity. Will send the error with Auto tomorrow. | ||
Kit | 2013-04-16 05:31:22.0 | |
| See below for the Stacktrace using GenerationType = Auto.
Launching GlassFish on Felix platform INFO: Running GlassFish Version: GlassFish Server Open Source Edition 3.1.2.2 (build 5) INFO: Registered org.glassfish.ha.store.adapter.cache.ShoalBackingStoreProxy for persistence-type = replicated in BackingStoreFactoryRegistry INFO: Grizzly Framework 1.9.50 started in: 75ms - bound to [0.0.0.0:8181] INFO: Grizzly Framework 1.9.50 started in: 51ms - bound to [0.0.0.0:3700] INFO: Grizzly Framework 1.9.50 started in: 95ms - bound to [0.0.0.0:8080] INFO: Grizzly Framework 1.9.50 started in: 41ms - bound to [0.0.0.0:7676] INFO: Grizzly Framework 1.9.50 started in: 62ms - bound to [0.0.0.0:4848] INFO: The Admin Console is already installed, but not yet loaded. INFO: GlassFish Server Open Source Edition 3.1.2.2 (5) startup time : Felix (28,785ms), startup services(952ms), total(29,737ms) INFO: HV000001: Hibernate Validator 4.3.0.Final INFO: Grizzly Framework 1.9.50 started in: 6ms - bound to [0.0.0.0:8080] INFO: Created EjbThreadPoolExecutor with thread-core-pool-size 16 thread-max-pool-size 32 thread-keep-alive-seconds 60 thread-queue-capacity 2147483647 allow-core-thread-timeout false INFO: Grizzly Framework 1.9.50 started in: 7ms - bound to [0.0.0.0:8181] INFO: Initiating Jersey application, version 'Jersey: 1.11.1 03/31/2012 06:49 PM' INFO: REST00001: Listening to REST requests at context: /management/domain INFO: The Admin Console is already installed, but not yet loaded. INFO: The Admin Console is starting. Please wait. INFO: WEB0169: Created HTTP listener [http-listener-1] on host/port [0.0.0.0:8080] INFO: WEB0169: Created HTTP listener [http-listener-2] on host/port [0.0.0.0:8181] INFO: WEB0169: Created HTTP listener [admin-listener] on host/port [0.0.0.0:4848] INFO: WEB0171: Created virtual server [server] INFO: WEB0171: Created virtual server [__asadmin] INFO: WEB0172: Virtual server [server] loaded default web module [] INFO: SEC1002: Security Manager is OFF. INFO: SEC1010: Entering Security Startup Service INFO: SEC1143: Loading policy provider com.sun.enterprise.security.provider.PolicyWrapper. INFO: SEC1115: Realm [admin-realm] of classtype [com.sun.enterprise.security.auth.realm.file.FileRealm] successfully created. INFO: SEC1115: Realm [file] of classtype [com.sun.enterprise.security.auth.realm.file.FileRealm] successfully created. INFO: SEC1115: Realm [certificate] of classtype [com.sun.enterprise.security.auth.realm.certificate.CertificateRealm] successfully created. INFO: SEC1011: Security Service(s) Started Successfully INFO: WS10010: Web service endpoint deployment events listener registered successfully. INFO: WS10001: Loading WS-TX Services. Please wait. INFO: WS00018: Webservice Endpoint deployed INFO: Initializing Mojarra 2.1.6 (SNAPSHOT 20111206) for context '' INFO: WEB0671: Loading application [wstx-services] at [/__wstx-services] INFO: WS10002: WS-TX Services successfully started. INFO: WEB0671: Loading application [__admingui] at [/] INFO: CORE10010: Loading application __admingui done in 12,900 ms INFO: The Admin Console application is loaded. INFO: com.turbocor.meis.factoryservices.db.meis.PartType actually got transformed INFO: com.turbocor.meis.factoryservices.db.wm.MODET actually got transformed INFO: com.turbocor.meis.factoryservices.db.wm.INV actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.PartSerialNumber actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.PartEventType actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.StationParameter actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.Station actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.PartEventData actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.PartEvent actually got transformed INFO: com.turbocor.meis.factoryservices.db.wm.BOM actually got transformed INFO: com.turbocor.meis.factoryservices.db.meis.PartData actually got transformed INFO: EclipseLink, version: Eclipse Persistence Services - 2.3.2.v20111125-r10461 INFO: Not able to detect platform for vendor name [HXTT DBF5]. Defaulting to [org.eclipse.persistence.platform.database.DatabasePlatform]. The database dialect used may not match with the database you are using. Please explicitly provide a platform using property eclipselink.platform.class.name. INFO: file:/C:/Users/kkennedy/Documents/NetBeansProjects/FactoryServices/dist/gfdeploy/FactoryServices/FactoryServices-ejb_jar/_Local-FoxPro-ejbPU login successful WARNING: Multiple [2] JMX MBeanServer instances exist, we will use the server at index [0] : [com.sun.enterprise.v3.admin.DynamicInterceptor@86411]. WARNING: JMX MBeanServer in use: [com.sun.enterprise.v3.admin.DynamicInterceptor@86411] from index [0] WARNING: JMX MBeanServer in use: [com.sun.jmx.mbeanserver.JmxMBeanServer@18abc82] from index [1] WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zPRTTYPE (PARTTYPE VARCHAR(50) NOT NULL, PARTDESC VARCHAR(254) NOT NULL, PRNTONMO NUMBER(1) NOT NULL, SNPREFIX VARCHAR(10) NOT NULL, PRIMARY KEY (PARTTYPE))": java.sql.SQLException: java.io.FileNotFoundException: C:\TestDBF\meis\zPRTTYPE.dbf (The system cannot find the path specified) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE MODET (MONO VARCHAR(8) NOT NULL, LINEITEM VARCHAR(4) NOT NULL, DUEDATE DATE NOT NULL, PN VARCHAR(20) NOT NULL, PRIMARY KEY (MONO, LINEITEM))": java.sql.SQLException: Failed to create table C:\TestDBF\MODET.dbf because it exists. WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zPARTSN (PARTSN VARCHAR(50) NOT NULL, DATEGEN TIMESTAMP NOT NULL, PARTSEQ NUMBER(10) NOT NULL, PARENTREF VARCHAR(50), PNREF VARCHAR(20) NOT NULL, PRIMARY KEY (PARTSN))": java.sql.SQLException: java.io.FileNotFoundException: C:\TestDBF\meis\zPARTSN.dbf (The system cannot find the path specified) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.INV (PN VARCHAR(20) NOT NULL, DESCRIPTION VARCHAR(75), VALIDBOM NUMBER(1) NOT NULL, PARTTYPE VARCHAR(50), PRIMARY KEY (PN))": java.sql.SQLException: java.io.FileNotFoundException: C:\TestDBF\meis\INV.dbf (The system cannot find the path specified) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zPRTETYP (EVENTTYPE VARCHAR(50) NOT NULL, EVENTDESC VARCHAR(254) NOT NULL, PRIMARY KEY (EVENTTYPE))": java.sql.SQLException: java.io.FileNotFoundException: C:\TestDBF\meis\zPRTETYP.dbf (The system cannot find the path specified) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zSTPARM (ID NUMBER(10) NOT NULL, PROPDESC VARCHAR(254), PROPNAME VARCHAR(100) NOT NULL, PROPVALUE VARCHAR(254) NOT NULL, STATNAME VARCHAR(50) NOT NULL, PRIMARY KEY (ID))": java.sql.SQLException: java.io.FileNotFoundException: C:\TestDBF\meis\zSTPARM.dbf (The system cannot find the path specified) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zPTEDATA (ID NUMBER(10) NOT NULL, FIELDNAME VARCHAR(50) NOT NULL, FILEPATH VARCHAR(254), DATAVALUE VARCHAR(254), PEVENTREF NUMBER(10) NOT NULL, PRIMARY KEY (ID))": java.sql.SQLException: java.io.FileNotFoundException: C:\TestDBF\meis\zPTEDATA.dbf (The system cannot find the path specified) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.BOM (EFFIN DATE NOT NULL, EFFOUT DATE NOT NULL, PARENT VARCHAR(20) NOT NULL, PN VARCHAR(20) NOT NULL, ZSTATION VARCHAR(50), PRIMARY KEY (EFFIN, EFFOUT, PARENT, PN))": java.sql.SQLException: java.io.FileNotFoundException: C:\TestDBF\meis\BOM.dbf (The system cannot find the path specified) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zSTATION (STATNAME VARCHAR(50) NOT NULL, STATDESC VARCHAR(254) NOT NULL, PRIMARY KEY (STATNAME))": java.sql.SQLException: java.io.FileNotFoundException: C:\TestDBF\meis\zSTATION.dbf (The system cannot find the path specified) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zPRTEVT (ID NUMBER(10) NOT NULL, EVENTDATE TIMESTAMP NOT NULL, NOTES VARCHAR(254), EVENTTYPE VARCHAR(50) NOT NULL, PARTSN VARCHAR(50) NOT NULL, STATNAME VARCHAR(50) NOT NULL, PRIMARY KEY (ID))": java.sql.SQLException: java.io.FileNotFoundException: C:\TestDBF\meis\zPRTEVT.dbf (The system cannot find the path specified) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zPRTDATA (ID NUMBER(10) NOT NULL, FIELDNAME VARCHAR(50) NOT NULL, FILEPATH VARCHAR(254), DATAVALUE VARCHAR(254), PNREF VARCHAR(20) NOT NULL, PRIMARY KEY (ID))": java.sql.SQLException: java.io.FileNotFoundException: C:\TestDBF\meis\zPRTDATA.dbf (The system cannot find the path specified) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE MODET ADD CONSTRAINT FK_MODET_PN FOREIGN KEY (PN) REFERENCES meis.INV (PN)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE meis.zPARTSN ADD CONSTRAINT FK_zPARTSN_PARENTREF FOREIGN KEY (PARENTREF) REFERENCES meis.zPARTSN (PARTSN)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE meis.zPARTSN ADD CONSTRAINT FK_zPARTSN_PNREF FOREIGN KEY (PNREF) REFERENCES meis.INV (PN)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE meis.INV ADD CONSTRAINT FK_INV_PARTTYPE FOREIGN KEY (PARTTYPE) REFERENCES meis.zPRTTYPE (PARTTYPE)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE meis.zSTPARM ADD CONSTRAINT FK_zSTPARM_STATNAME FOREIGN KEY (STATNAME) REFERENCES meis.zSTATION (STATNAME)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE meis.zPTEDATA ADD CONSTRAINT FK_zPTEDATA_PEVENTREF FOREIGN KEY (PEVENTREF) REFERENCES meis.zPRTEVT (ID)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE meis.BOM ADD CONSTRAINT FK_BOM_ZSTATION FOREIGN KEY (ZSTATION) REFERENCES meis.zSTATION (STATNAME)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE meis.BOM ADD CONSTRAINT FK_BOM_PARENT FOREIGN KEY (PARENT) REFERENCES meis.INV (PN)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE meis.BOM ADD CONSTRAINT FK_BOM_PN FOREIGN KEY (PN) REFERENCES meis.INV (PN)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE meis.zPRTEVT ADD CONSTRAINT FK_zPRTEVT_PARTSN FOREIGN KEY (PARTSN) REFERENCES meis.zPARTSN (PARTSN)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE meis.zPRTEVT ADD CONSTRAINT FK_zPRTEVT_EVENTTYPE FOREIGN KEY (EVENTTYPE) REFERENCES meis.zPRTETYP (EVENTTYPE)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE meis.zPRTEVT ADD CONSTRAINT FK_zPRTEVT_STATNAME FOREIGN KEY (STATNAME) REFERENCES meis.zSTATION (STATNAME)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "ALTER TABLE meis.zPRTDATA ADD CONSTRAINT FK_zPRTDATA_PNREF FOREIGN KEY (PNREF) REFERENCES meis.INV (PN)": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT NUMBER(19), PRIMARY KEY (SEQ_NAME))": java.sql.SQLException: Failed to create table C:\TestDBF\SEQUENCE.dbf because it exists. WARNING: PER01000: Got SQLException executing statement "INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN', 0)": java.sql.SQLException: Overflow Error: Can't set SEQ_COUNT with 0! WARNING: Container org.glassfish.webservices.JAXWSContainer@7869e6 doesn't support class com.sun.xml.ws.api.server.Module WARNING: Container org.glassfish.webservices.JAXWSContainer@151b626 doesn't support class com.sun.xml.ws.api.server.Module INFO: WS00019: EJB Endpoint deployed FactoryServices listening at address at http://kkennedy-lt:8080/MEISGeneralService/MEISGeneral INFO: WS00019: EJB Endpoint deployed FactoryServices listening at address at http://kkennedy-lt:8080/MEISSerializationService/MEISSerialization INFO: FactoryServices was successfully deployed in 15,411 milliseconds. | ||
HXTT Support | 2013-04-16 07:28:48.0 | |
| Please visit HXTT Glassfish Support Package, which is released according to your issue just now. | ||
Kit | 2013-04-16 07:51:56.0 | |
| Should I still use GenerationType.AUTO or can I now use GenerationType.IDENTITY? | ||
HXTT Support | 2013-04-16 08:01:05.0 | |
| >Should I still use GenerationType.AUTO or can I now use GenerationType.IDENTITY?
You can try both of them. That package is provided with source code, but without test. If you met issue, please let us know. | ||
Kit | 2013-04-16 08:10:48.0 | |
| I am still having the same issues. No change. I have found this one line that I don't know what to do about:
INFO: Not able to detect platform for vendor name [HXTT DBF5]. Defaulting to [org.eclipse.persistence.platform.database.DatabasePlatform]. The database dialect used may not match with the database you are using. Please explicitly provide a platform using property eclipselink.platform.class.name. Where should this property be set? In the persistence.xml? What should the value for this property be? | ||
Kit | 2013-04-16 08:12:38.0 | |
| This is my persistence unit currently. Is this correct?
| ||
HXTT Support | 2013-04-16 08:15:13.0 | |
| Then try to set
eclipselink.platform.class.name : com.hxtt.support.toplink.DbfPlatform | ||
Kit | 2013-04-16 08:23:20.0 | |
| It looks like I need to add Toplink, but I would prefer using EclipseLink. I believe EclipseLink is better supported currently. Can you provide the same connection with EclipseLink instead?
SEVERE: Exception while preparing the app SEVERE: oracle/toplink/essentials/platform/database/DatabasePlatform java.lang.NoClassDefFoundError: oracle/toplink/essentials/platform/database/DatabasePlatform at java.lang.ClassLoader.defineClass1(Native Method) | ||
HXTT Support | 2013-04-16 08:27:04.0 | |
| I guess that It can be supported by simple modify the package name. Tomorrow we will download Eclipse link to check it. | ||
HXTT Support | 2013-04-17 15:54:36.0 | |
| Supported. Please visit HXTT Glassfish Support Package. BTW, you should download the latest HXTT DBF, which has complemented a LAST_INSERT_ID() function for IDENTITY. | ||
Kit | 2013-04-17 17:51:40.0 | |
| Thank you very much, I will work on this tomorrow. | ||
Kit | 2013-04-18 08:13:38.0 | |
| Downloaded both the latest DBF Driver and the Support Package.
This is my latest problem: WARNING: Multiple [2] JMX MBeanServer instances exist, we will use the server at index [0] : [com.sun.enterprise.v3.admin.DynamicInterceptor@154d2ff]. WARNING: JMX MBeanServer in use: [com.sun.enterprise.v3.admin.DynamicInterceptor@154d2ff] from index [0] WARNING: JMX MBeanServer in use: [com.sun.jmx.mbeanserver.JmxMBeanServer@1ff6a34] from index [1] WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zPRTTYPE (PARTTYPE VARCHAR(50), PARTDESC VARCHAR(254), PRNTONMO BIT, SNPREFIX VARCHAR(10), CONSTRAINT meis.zPRTTYPE_PK PRIMARY KEY (PARTTYPE))": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zPARTSN (PARTSN VARCHAR(50), DATEGEN TIMESTAMP, PARTSEQ INTEGER, PARENTREF VARCHAR(50), PNREF VARCHAR(20), CONSTRAINT meis.zPARTSN_PK PRIMARY KEY (PARTSN))": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.INV (PN VARCHAR(20), DESCRIPTION VARCHAR(75), VALIDBOM BIT, PARTTYPE VARCHAR(50), CONSTRAINT meis.INV_PK PRIMARY KEY (PN))": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zPRTETYP (EVENTTYPE VARCHAR(50), EVENTDESC VARCHAR(254), CONSTRAINT meis.zPRTETYP_PK PRIMARY KEY (EVENTTYPE))": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zSTPARM (ID INTEGER AUTO_INCREMENT, PROPDESC VARCHAR(254), PROPNAME VARCHAR(100), PROPVALUE VARCHAR(254), STATNAME VARCHAR(50), CONSTRAINT meis.zSTPARM_PK PRIMARY KEY (ID))": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zPTEDATA (ID INTEGER AUTO_INCREMENT, FIELDNAME VARCHAR(50), FILEPATH VARCHAR(254), DATAVALUE VARCHAR(254), PEVENTREF INTEGER, CONSTRAINT meis.zPTEDATA_PK PRIMARY KEY (ID))": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.BOM (EFFIN DATE, EFFOUT DATE, PARENT VARCHAR(20), PN VARCHAR(20), ZSTATION VARCHAR(50), CONSTRAINT meis.BOM_PK PRIMARY KEY (EFFIN, EFFOUT, PARENT, PN))": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zSTATION (STATNAME VARCHAR(50), STATDESC VARCHAR(254), CONSTRAINT meis.zSTATION_PK PRIMARY KEY (STATNAME))": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zPRTEVT (ID INTEGER AUTO_INCREMENT, EVENTDATE TIMESTAMP, NOTES VARCHAR(254), EVENTTYPE VARCHAR(50), PARTSN VARCHAR(50), STATNAME VARCHAR(50), CONSTRAINT meis.zPRTEVT_PK PRIMARY KEY (ID))": java.sql.SQLException: Syntax error: Stopped parse at .(id21) WARNING: PER01000: Got SQLException executing statement "CREATE TABLE meis.zPRTDATA (ID INTEGER AUTO_INCREMENT, FIELDNAME VARCHAR(50), FILEPATH VARCHAR(254), DATAVALUE VARCHAR(254), PNREF VARCHAR(20), CONSTRAINT meis.zPRTDATA_PK PRIMARY KEY (ID))": java.sql.SQLException: Syntax error: Stopped parse at .(id21) | ||
HXTT Support | 2013-04-18 17:34:14.0 | |
| > meis.zPRTTYPE
What's meis in your configuration. A directory, a catalog, or a schema? | ||
HXTT Support | 2013-04-18 17:47:44.0 | |
| >@Table(name = "zSTPARM", catalog = "meis")
Please change it into @Table(name = "zSTPARM") | ||
HXTT Support | 2013-04-18 17:56:14.0 | |
| Because
1. CONSTRAINT meis.zPRTDATA_PK PRIMARY KEY (ID) is not allowed, and expect to meet CONSTRAINT meis.zPRTDATA_PK PRIMARY KEY (ID) 2. CREATE TABLE meis.zPRTDATA is allowed, but meis should be an existent directory, and HXTT DBF won't create subdirectory automatically, since it provided CREATE CATALOG [IF NOT EXISTS] catalogName syntax. | ||
HXTT Support | 2013-04-18 18:19:20.0 | |
| I have changed the dialect so to avoid CONSTRAINT meis.zPRTDATA_PK . Please download the latest package from EclipseLink Support package
If you have a meis directory, and used @Table(name = "zSTPARM", catalog = "meis") It should produce CREATE TABLE meis.zPRTDATA (ID INTEGER AUTO_INCREMENT, FIELDNAME VARCHAR(50), FILEPATH VARCHAR(254), DATAVALUE VARCHAR(254), PNREF VARCHAR(20), PRIMARY KEY (ID)) | ||
Kit | 2013-04-19 06:40:05.0 | |
| GOOD NEWS! Looks like it's working well.
Thanks. I will keep you informed of any more issues I encounter. | ||