openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick" <michael.d.d...@gmail.com>
Subject Re: Problems with configuring OpenJPA "Slices"
Date Thu, 02 Oct 2008 20:58:59 GMT
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.
>
>

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