i don't know what's happened but the table exists...
Kevin Sutter wrote:
>
> Thiago,
> Just from looking at the information you posted, I'm guessing that the
> wrong
> schema name is being used somewhere. According to the message you posted,
>
> Exception in thread "main" <openjpa-1.2.0-rexported nonfatal general
> error>
> org.apache.openjpa.persistence.PersistenceException: Table
> *'cadastro.message'* doesn't exist {prepstmnt 18481629 SELECT t0.id,
> t0.created, t0.message FROM Message t0} [code=1146, state=42S02]
>
> The missing table is "cadastro.message". You indicate that the "message"
> table exists in both databases. But, does the fully-qualified table name
> (cadastro.message) exist in mySQL? From the information posted, I don't
> see
> where you are explicitly setting a schema name. I'm not an expert with
> mySQL's default schema name conventions.
>
> Anyway, that's the first place I would look.
>
> Good luck,
> Kevin
>
>
> On Thu, Oct 2, 2008 at 6:41 AM, thiago ananias
> <[EMAIL PROTECTED]>wrote:
>
>>
>>
>>
>> Pinaki Poddar wrote:
>> >
>> > Hi,
>> > Thanks for finding this bug.
>> >
>> > The correction will appear in next nightly build of OpenJPA [1].
>> >
>> > Those of you using Slice, if you can give us little bit of
>> background
>> > of your project, that will be very helpful for us to decide on its
>> future
>> > course.
>> >
>> > Pinaki
>> >
>>
>> Hi again people, thanks for the reply "ahsoni"!!!
>>
>> I'm with other problem now...this error appears for me:
>>
>> But the table "message" exists in both databases...
>>
>> Exception in thread "main" <openjpa-1.2.0-rexported nonfatal general
>> error>
>> org.apache.openjpa.persistence.PersistenceException: Table
>> 'cadastro.message' doesn't exist {prepstmnt 18481629 SELECT t0.id,
>> t0.created, t0.message FROM Message t0} [code=1146, state=42S02]
>> at
>> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4238)
>> at
>>
>> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4203)
>> at
>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
>> at
>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
>> at
>> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
>> at
>>
>> org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
>> at
>>
>> org.apache.openjpa.lib.rop.MergedResultObjectProvider.handleCheckedException(MergedResultObjectProvider.java:148)
>> at
>> org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
>> at
>> org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1228)
>> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990)
>> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:805)
>> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:775)
>> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:771)
>> at
>> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:517)
>> at
>> org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:254)
>> at
>> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:293)
>> at br.unicsul.teste.Main.main(Main.java:49)
>>
>>
>> And my persistence.xml
>> <persistence xmlns="http://java.sun.com/xml/ns/persistence";
>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; version="1.0">
>>
>> <persistence-unit name="PersistenceUnit"
>> transaction-type="RESOURCE_LOCAL">
>>
>>
>> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>> <class>br.unicsul.teste.Message</class>
>>
>> <properties>
>>
>> <!-- HABILITA O GERENCIAMENTO DE BDs -->
>> <property name="openjpa.BrokerFactory" value="slice"/>
>> <property name="openjpa.slice.Names"
>> value="SQLSERVER,MYSQL"/>
>> <property name="openjpa.slice.Master" value="SQLSERVER"/>
>>
>> <property name="openjpa.ConnectionURL"
>>
>> value="jdbc:sqlserver://TANANIAS-D\SQLEXPRESS;database=cadastro;user=sa;password=testando123"/>
>> <property name="openjpa.ConnectionDriverName"
>> value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
>>
>>
>> <property name="openjpa.slice.SQLSERVER.ConnectionURL"
>>
>> value="jdbc:sqlserver://TANANIAS-D\SQLEXPRESS;database=cadastro;user=sa;password=testando123"/>
>> <property name="openjpa.slice.SQLSERVER.ConnectionDriverName"
>> value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
>>
>> <property name="openjpa.slice.MYSQL.ConnectionURL"
>> value="jdbc:mysql://localhost:3306/cadastro"/>
>> <property name="openjpa.slice.MYSQL.ConnectionDriverName"
>> value="com.mysql.jdbc.Driver"/>
>> <property name="openjpa.slice.MYSQL.ConnectionUserName"
>> value="root"/>
>> <property name="openjpa.slice.MYSQL.ConnectionPassword"
>> value="sa"/>
>>
>> <property name="openjpa.Log" value="DefaultLevel=WARN,
>> Enhance=TRACE"/>
>> <property name="openjpa.slice.DistributionPolicy"
>> value="br.unicsul.teste.DistributionRules"/>
>>
>> <!--
>> <property name="openjpa.slice.Two.jdbc.SynchronizeMappings"
>> value="buildSchema(SchemaAction='drop,add')"/>
>> <property name="openjpa.slice.Two.Log"
>> value="DefaultLevel=WARN,
>> Tool=INFO"/>
>> <property name="openjpa.slice.Two.ConnectionFactoryProperties"
>> value="PrettyPrint=true, PrettyPrintLineLength=80"/>
>> -->
>>
>> </properties>
>>
>> </persistence-unit>
>>
>> </persistence>
>>
>>
>>
>> i don't know what's wrong because in the SQLSERVER(master slice) the
>> message
>> is commited with sucess but in MYSQL occurs this error!
>>
>> Thanks for the help!
>>
>> bye
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> View this message in context:
>> http://n2.nabble.com/Problems-with-configuring-OpenJPA-%22Slices%22-tp759642p1133677.html
>> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>>
>>
>
>
--
View this message in context:
http://n2.nabble.com/Problems-with-configuring-OpenJPA-%22Slices%22-tp759642p1134001.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
