openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From thiago ananias <thiagoanan...@hotmail.com>
Subject Re: Problems with configuring OpenJPA "Slices"
Date Fri, 03 Oct 2008 10:03:49 GMT


I'm a JERK!! I don't beleive...let me explain:

 was making other tests for another thing that i have to do, and i installed
two MySql instances, and i was using the wrong instance :blush:

People!! 

Finally works!
	
thank you very, very, very much =)

Regards,
Thiago Ananias



Michael Dick wrote:
> 
> I've never really used MySQL Administrator so I'm not sure what to
> suggest.
> Could you try creating the table manually (MySQL Administrator should
> produce a script) and see if your testcase works?
> 
> -mike
> 
> On Thu, Oct 2, 2008 at 3:09 PM, thiago ananias
> <thiagoananias@hotmail.com>wrote:
> 
>>
>>
>> Man...that's crazy, in the command line i executed the commands...and the
>> message for both
>>
>> table 'cadastro.message' doesn't exist!!
>>
>> But in MySql Administrator the table exist!!
>>
>> it's crazy!!
>>
>> Thanks!
>>
>>
>>
>> Michael Dick wrote:
>> >
>> > Hi Thiago,
>> >
>> > Did you create the tables manually or were they created by the
>> > SynchronizeMappings property?
>> >
>> > If you connect to mysql via the command line ($ mysql -u root -p ) try
>> > running these statements :
>> > connect cadastro;
>> > show create table Message;
>> >
>> > show create table cadastro.Message;
>> >
>> > If Kevin's theory is right you should see valid SQL for the first show
>> > create table statement, and an error message (something like Table
>> > 'cadastro.Message' doesn't exist) for the second one.
>> >
>> > If that's the case then it looks like the schema name was omitted
>> > somewhere.
>> >
>> >
>> > If both tables exist then we're probably looking at a connection issue
>> > (the
>> > MySQL driver shouldn't be throwing the exception).
>> >
>> > If cadastro.Message exists, and Message doesn't then we have a third
>> > scenario..
>> >
>> > Hope this helps,
>> > -mike
>> >
>> > On Thu, Oct 2, 2008 at 9:21 AM, thiago ananias
>> > <thiagoananias@hotmail.com>wrote:
>> >
>> >>
>> >>
>> >> 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
>> >> > <thiagoananias@hotmail.com>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.
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://n2.nabble.com/Problems-with-configuring-OpenJPA-%22Slices%22-tp759642p1135042.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-tp759642p1141665.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.


Mime
View raw message