Announcement Announcement Module
No announcement yet.
Spring roo connection to oracle Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Spring roo connection to oracle

    I am trying to use oracle as my database holder for data.

    I have used maven to add ojbdc14.jar oracles driver

    I get the following error on start up with comant tomcat:run

    Its complaingin about a missing right bracket
    I think its to do with bigint generated by default as identity (start with 1)

    Anyone connected to oracle just done a standard setup.

    Binding entity from annotated class: com.edfe.orchard.rackstackandpack.domain.Pack
    Bind entity com.edfe.orchard.rackstackandpack.domain.Pack on table pack
    Hibernate Validator not found: ignoring
    Initializing connection provider: org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider
    Using provided datasource
    RDBMS: Oracle, version: Oracle Database 10g Express Edition Release - Production
    JDBC driver: Oracle JDBC driver, version:
    Using dialect: org.hibernate.dialect.HSQLDialect
    Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
    No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
    Automatic flush during beforeCompletion(): disabled
    Automatic session close at end of transaction: disabled
    JDBC batch size: 15
    JDBC batch updates for versioned data: disabled
    Scrollable result sets: enabled
    JDBC3 getGeneratedKeys(): enabled
    Connection release mode: auto
    Default batch fetch size: 1
    Generate SQL with comments: disabled
    Order SQL updates by primary key: disabled
    Order SQL inserts for batching: disabled
    Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
    Using ASTQueryTranslatorFactory
    Query language substitutions: {}
    JPA-QL strict compliance: enabled
    Second-level cache: enabled
    Query cache: disabled
    Cache provider: org.hibernate.cache.NoCacheProvider
    Optimize cache for minimal puts: disabled
    Structured second-level cache entries: disabled
    Statistics: disabled
    Deleted entity synthetic identifier rollback: disabled
    Default entity-mode: pojo
    Named query checking : enabled
    building session factory
    Not binding factory to JNDI, no JNDI name configured
    Running hbm2ddl schema export
    exporting generated schema to database
    Unsuccessful: create table pack (id bigint generated by default as identity (start with 1), account_reference varchar(255), version integer,
     call_reason_code integer, customer_address varchar(255), customer_name varchar(255), customer_postcode varchar(255), customer_telephone var
    char(255), customer_types integer, detailed_note varchar(255), earliest_date timestamp, primary key (id))
    ORA-00907: missing right parenthesis

  • #2
    note this issue doesnt happen when using the inbuilt database persistent hibernate one.


    • #3
      I created a new project and this wasnt an issue....

      Successfull connected to oracle.