openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Web developer <webautomat...@gmail.com>
Subject Fwd: Test run
Date Thu, 27 May 2010 12:27:44 GMT
---------- Пересланное сообщение ----------
От кого: Web developer <webautomator2@gmail.com>
Дата: 27 мая 2010 г. 15:27
Тема: Re: Test run
Кому: Rick Curtis <curtisr7@gmail.com>



>Since there are multiple persistence units defined in the p.xml file that
you specified, we incorrectly try to create the >OPENJPA_SEQUENCE_TABLE
multiple times. Not that big of a deal.
Here is my updated persistence.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!--
 Licensed to the Apache Software Foundation (ASF) under one
 or more contributor license agreements.  See the NOTICE file
 distributed with this work for additional information
 regarding copyright ownership.  The ASF licenses this file
 to you under the Apache License, Version 2.0 (the
 "License"); you may not use this file except in compliance
 with the License.  You may obtain a copy of the License at

 http://www.apache.org/licenses/LICENSE-2.0

 Unless required by applicable law or agreed to in writing,
 software distributed under the License is distributed on an
 "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 KIND, either express or implied.  See the License for the
 specific language governing permissions and limitations
 under the License.
-->
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    version="1.0">
    <persistence-unit name="embeddables" transaction-type="RESOURCE_LOCAL">

<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
        <class>Address</class>
        <class>ContactInfo</class>
        <class>Phone</class>
        <class>User</class>
    </persistence-unit>
</persistence>

310  embeddables  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class
"org.apache.openjpa.jdbc.sql.H2Dictionary".
385  embeddables  INFO   [main] openjpa.Runtime - Creating sequence table.
1814  embeddables  TRACE  [main] openjpa.jdbc.SQL - <t 644193719, conn
1498770706> executing stmnt 1260137319 CREATE TABLE OPENJPA_SEQUENCE_TABLE
(ID TINYINT NOT NULL, SEQUENCE_VALUE BIGINT, PRIMARY KEY (ID))
1826  embeddables  TRACE  [main] openjpa.jdbc.SQL - <t 644193719, conn
1498770706> [12 ms] spent

163  embeddables  INFO   [main] openjpa.Runtime - Starting OpenJPA
2.0.0-beta3
346  embeddables  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class
"org.apache.openjpa.jdbc.sql.H2Dictionary".

Exception in thread "main" <openjpa-2.0.0-beta3-r422266:926797 fatal store
error> org.apache.openjpa.persistence.RollbackException: The transaction has
been rolled back.  See the nested exceptions for details on the errors that
occurred.
    at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:573)
    at Main.init(Main.java:55)
    at Main.main(Main.java:10)
Caused by: <openjpa-2.0.0-beta3-r422266:926797 fatal general error>
org.apache.openjpa.persistence.PersistenceException: The transaction has
been rolled back.  See the nested exceptions for details on the errors that
occurred.
    at
org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2279)
    at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2122)
    at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2020)
    at
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1938)
    at
org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
    at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1462)
    at
org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:924)
    at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:556)
    ... 2 more
Caused by: <openjpa-2.0.0-beta3-r422266:926797 fatal general error>
org.apache.openjpa.persistence.PersistenceException: Таблица "USER0" не
найдена
Table "USER0" not found; SQL statement:
INSERT INTO User0 (id, user, user_name, city, state, street, zip, number,
type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [42102-132] {INSERT INTO User0 (id,
user, user_name, city, state, street, zip, number, type) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?)} [code=42102, state=42S02]
    at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4827)
    at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4787)
    at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
    at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:110)
    at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:62)
    at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:89)
    at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
    at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
    at
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
    at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103)
    at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76)
    at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:743)
    at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
    ... 9 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Таблица
"USER0" не найдена
Table "USER0" not found; SQL statement:
INSERT INTO User0 (id, user, user_name, city, state, street, zip, number,
type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [42102-132] {INSERT INTO User0 (id,
user, user_name, city, state, street, zip, number, type) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?)} [code=42102, state=42S02]
    at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:257)
    at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:237)
    at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:70)
    at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:289)
    at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:186)
    at
org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:155)
    at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:186)
    at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1639)
    at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:175)
    at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStatementManagerImpl.java:289)
    at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:112)
    at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:81)
    at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:99)
    at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:87)
    ... 16 more

Do not see changes with a single persistence unit in configuration. John


>The main method that you are calling isn't a main line path that most (if
>any) people go down.
>
> Do you have the property -Dopenjpa.jdbc.SynchronizeMappings=buildSchema
[2] specified anywhere? That property will automatically create the
necessary tables at runtime.
>
> If you're still having problems, I'd suggest putting together a coherent
question and posting it back to the users mailing list.
>
> Thanks,
> Rick
>
> [1] http://openjpa.apache.org/samples.html
> [2]
http://openjpa.apache.org/builds/2.0.0/apache-openjpa-2.0.0/docs/manual/manual.html#ref_guide_mapping_synch
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message