Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT DBF
SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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.(PersistenceUnitLoader.java:120)
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.(PersistenceUnitLoader.java:120)
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.(PersistenceUnitLoader.java:120)
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

Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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.
Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
HXTT Support
2013-04-15 16:31:23.0
>@GeneratedValue(strategy = GenerationType.IDENTITY)
Try @GeneratedValue(strategy=GenerationType.AUTO)
Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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.
Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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.
Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
HXTT Support
2013-04-16 07:28:48.0
Please visit HXTT Glassfish Support Package, which is released according to your issue just now.
Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
Kit
2013-04-16 07:51:56.0
Should I still use GenerationType.AUTO or can I now use GenerationType.IDENTITY?
Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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.
Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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?
Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
Kit
2013-04-16 08:12:38.0
This is my persistence unit currently. Is this correct?


org.eclipse.persistence.jpa.PersistenceProvider
LocalWM
NONE






Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
HXTT Support
2013-04-16 08:15:13.0
Then try to set
eclipselink.platform.class.name : com.hxtt.support.toplink.DbfPlatform
Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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)
Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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.
Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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.
Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
Kit
2013-04-17 17:51:40.0
Thank you very much, I will work on this tomorrow.
Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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)
Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
HXTT Support
2013-04-18 17:34:14.0
> meis.zPRTTYPE
What's meis in your configuration. A directory, a catalog, or a schema?
Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
HXTT Support
2013-04-18 17:47:44.0
>@Table(name = "zSTPARM", catalog = "meis")
Please change it into
@Table(name = "zSTPARM")
Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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.
Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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))
Re:Re:Re:Re:Re:Re:Re:Re:SEQ_GEN_IDENTITY: platform DatabasePlatform does not support NativeSequence.
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.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap