[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Does OSGI work?

Using the db instance you sent me:

/comics has an incompatible format with the current version of the
software.  The database was created by or upgraded by version 10.4.

-H


On Mon, Aug 18, 2008 at 2:05 PM, Tom Ware <tom.ware@xxxxxxxxxx> wrote:
> I am surprised Derby 10.4 does not work.
>
> Derby is actually pretty well set up for these kinds of demos.  Take a look
> at the URL in the persistence.xml:
>
> jdbc:derby://localhost:1527/comics;create=true
>
> The "create=true" part tells Derby to create the database if it doesn't
> exist. That should also make it so your user and password are there.
>
> -Tom
>
> Hugo Garcia wrote:
>>
>> looked at the derby logs... have to start from scratch since i
>> initially was using Derby 10.4.x and Tom's version is 10.3.
>>
>> If it works... I then wonder if it can't work with a new instance of
>> Deby since the persistence.xml defines a user and  password that have
>> not been set in a new install???? [open naive question]
>>
>> -H
>>
>> On Mon, Aug 18, 2008 at 12:45 PM, Shaun Smith <shaun.smith@xxxxxxxxxx>
>> wrote:
>>>
>>> Be careful about the "no suitable drivers" message.    EclipseLink is
>>> issuing the message after failing to locate the driver but then tries
>>> using
>>> another mechanism and finds it.  You'll note that after you get the
>>> message
>>> you see EclipseLink login and issue SQL.  The error you're getting is a
>>> result of a missing PUBLISHER table, not a connection problem.
>>>
>>> This "no suitable driver" message is being shown at way too high a level.
>>> It should be debug only.  I thought there was a bug filed for this.  I'll
>>> check and if not I'll file one.
>>>
>>>       Shaun
>>>
>>> [EL Fine]: Connection(12793391)--SELECT ID, NAME FROM PUBLISHER ORDER
>>> BY NAME ASC
>>> [EL Fine]: VALUES(1)
>>> [EL Warning]: Exception [EclipseLink-4002] (Eclipse Persistence
>>> Services - 1.0 (Build 1.0 - 20080707)):
>>> org.eclipse.persistence.exceptions.DatabaseException
>>> Internal Exception: java.sql.SQLSyntaxErrorException: Table/View
>>> 'PUBLISHER' does not exist.
>>>
>>>
>>> Hugo Garcia wrote:
>>>
>>> Results
>>>
>>> If you run it with Derbry 10.4.x then you just get the osgi prompt.
>>>
>>> If you run it with Derby 10.3 then you just get the same error of
>>> driver not found.
>>>
>>> With your db... it still does the same.
>>>
>>> Maybe you could do the same from scratch as I have and we can figure
>>> out what is different?
>>>
>>> -H
>>>
>>> On Mon, Aug 18, 2008 at 9:54 AM, Tom Ware <tom.ware@xxxxxxxxxx> wrote:
>>>
>>>
>>> What are the results of running the setup project?
>>>
>>> -Tom
>>>
>>> Hugo Garcia wrote:
>>>
>>>
>>> Yeah... the setup project doesnt generate the promised SQL statements...
>>>
>>> don't konw why yet
>>>
>>> -H
>>>
>>> On Mon, Aug 18, 2008 at 7:47 AM, Tim Hollosy <hollosyt@xxxxxxxxx> wrote:
>>>
>>>
>>> You just need to set up the derby DB first, the database does not
>>> exist yet. I believe it says how to do it on the wiki page, but it's
>>> so odd I just use a copy of derby I have with the DB generated
>>> already, I don't remember how I did it initially.
>>>
>>> ./tch
>>>
>>>
>>>
>>> On Mon, Aug 18, 2008 at 9:36 AM, Hugo Garcia <hgarcia@xxxxxxxxxxxx>
>>> wrote:
>>>
>>>
>>> On Mon, Aug 11, 2008 at 1:47 PM, Tom Ware <tom.ware@xxxxxxxxxx> wrote:
>>>
>>>
>>> Hi Hugo,
>>>
>>>  Lets see if we can get the examples working for you.
>>>
>>>  Your 1st step should work.  After that, there are a few things we
>>> should do
>>> differently.
>>>
>>> 2. The osgi branch in our SVN is a proof of concept branch and is
>>> therefore
>>> deprecated.  We will update our Wiki to be more accurate.  Instead, get
>>> the
>>> examples from the "examples" folder in either our trunk, or
>>> branches/1.0/trunk.  The example projects you want are:
>>>
>>> org.eclipse.persistence.derby
>>> org.eclipse.persistence.example.jpa.comics.model.annotated
>>> org.eclipse.persistence.example.jpa.comics.setup
>>> org.eclipse.persistence.example.jpa.rcp.comics
>>>
>>> 3. You are correct to install apache derby, but the
>>> org.apache.derby.core
>>> bundle is not JPA friendly (it is not well setup for a
>>> client-connection to
>>> Derby through OSGi).  The org.eclipse.persistence.derby project you
>>> imported
>>> in the step above can be used to provide Derby access.  See the readme
>>> file
>>> in that project to understand how to configure it.
>>>
>>> When you have it configured, you will have to run the
>>> startNetworkServer
>>> script in your derby installation
>>>
>>> 4. You should only have one compile error.  It is explained in the
>>> readme
>>> mentioned above and you should not have to worry about it.
>>>
>>> 5. Run the ComicsExampleDBSetup launch configuration (from the
>>> org.eclipse.persistence.example.jpa.comics.setup project)
>>>
>>> This is a simple OSGi application that sets up your database.
>>>
>>> 6. Run the ComicsRCP launch configuration (from the
>>> org.eclipse.persistence.example.jpa.rcp.comics project)  You will get a
>>> warning about the derby jar.  Click on the button to ignore the
>>> warning.
>>>
>>> You should get a simple RCP app.
>>>
>>> Let me know how this goes for you and we will ensure the wiki gets
>>> updated.
>>>
>>> -Tom
>>>
>>>
>>>
>>>
>>> Running the 1.0 branch
>>>
>>> Step 2 should include the url to svn in tr (you mentioned it in
>>> another email in this list) and not the old technology svn.
>>> The wikipage http://wiki.eclipse.org/SVN_Howto has to be updated.
>>> I know the Equinox group is migrating the source to tr...
>>>
>>> Could the DERBY_HOME be obviated by implementing Eclipse-RegisterBuddy
>>> but then... I guess this would not be OSGi??? Is there and equivalent
>>> to Eclipse-RegisterBuddy in OSGi??
>>>
>>> The run configuration for the RCP has to be reset with the required
>>> plugins since I am testing on Linux.
>>>
>>> I got this error both in Windows and Linux:
>>>
>>>
>>> [EL Config]: The alias name for the entity class [class
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title] is
>>> being defaulted to: Title.
>>> [EL Config]: The table name for entity [class
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title] is
>>> being defaulted to: TITLE.
>>> [EL Config]: The column name for element [private int
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title.id]
>>> is being defaulted to: ID.
>>> [EL Config]: The column name for element [private java.lang.String
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title.name]
>>> is being defaulted to: NAME.
>>> [EL Config]: The column name for element [private java.lang.String
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title.format]
>>> is being defaulted to: FORMAT.
>>> [EL Config]: The alias name for the entity class [class
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue] is
>>> being defaulted to: Issue.
>>> [EL Config]: The table name for entity [class
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue] is
>>> being defaulted to: ISSUE.
>>> [EL Config]: The column name for element [private int
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue.id]
>>> is being defaulted to: ID.
>>> [EL Config]: The column name for element [private java.lang.String
>>>
>>>
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue.comments]
>>> is being defaulted to: COMMENTS.
>>> [EL Config]: The column name for element [private java.lang.String
>>>
>>>
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue.condition]
>>> is being defaulted to: CONDITION.
>>> [EL Config]: The column name for element [private int
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue.copies]
>>> is being defaulted to: COPIES.
>>> [EL Config]: The column name for element [private int
>>>
>>>
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue.issueNum]
>>> is being defaulted to: ISSUENUM.
>>> [EL Config]: The column name for element [private double
>>>
>>>
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue.pricePaid]
>>> is being defaulted to: PRICEPAID.
>>> [EL Config]: The column name for element [private java.math.BigDecimal
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue.value]
>>> is being defaulted to: VALUE.
>>> [EL Config]: The alias name for the entity class [class
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Publisher]
>>> is being defaulted to: Publisher.
>>> [EL Config]: The table name for entity [class
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Publisher]
>>> is being defaulted to: PUBLISHER.
>>> [EL Config]: The column name for element [private int
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Publisher.id]
>>> is being defaulted to: ID.
>>> [EL Config]: The column name for element [private java.lang.String
>>>
>>>
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Publisher.name]
>>> is being defaulted to: NAME.
>>> [EL Config]: The target entity (reference) class for the one to many
>>> mapping element [private java.util.List
>>>
>>>
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Publisher.titles]
>>> is being defaulted to: class
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title.
>>> [EL Config]: The target entity (reference) class for the many to one
>>> mapping element [private
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Publisher
>>>
>>>
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title.publisher]
>>> is being defaulted to: class
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Publisher.
>>> [EL Config]: The primary key column name for the mapping element
>>> [private
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Publisher
>>>
>>>
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title.publisher]
>>> is being defaulted to: ID.
>>> [EL Config]: The foreign key column name for the mapping element
>>> [private
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Publisher
>>>
>>>
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title.publisher]
>>> is being defaulted to: PUBLISHER_ID.
>>> [EL Config]: The target entity (reference) class for the many to one
>>> mapping element [private
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue.title]
>>> is being defaulted to: class
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title.
>>> [EL Config]: The primary key column name for the mapping element
>>> [private
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue.title]
>>> is being defaulted to: ID.
>>> [EL Config]: The foreign key column name for the mapping element
>>> [private
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue.title]
>>> is being defaulted to: TITLE_ID.
>>> [EL Config]: The target entity (reference) class for the one to many
>>> mapping element [private java.util.List
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Title.issues]
>>> is being defaulted to: class
>>> org.eclipse.persistence.example.jpa.comics.model.annotated.Issue.
>>> [EL Info]: EclipseLink, version: Eclipse Persistence Services - 1.0
>>> (Build 1.0 - 20080707)
>>> [EL Config]: Connection(17796836)--connecting(DatabaseLogin(
>>>      platform=>DerbyPlatform
>>>      user name=> "app"
>>>      datasource URL=> "jdbc:derby://localhost:1527/comics;create=true"
>>> ))
>>> [EL Warning]: java.sql.SQLException: No suitable driver found for
>>> jdbc:derby://localhost:1527/comics;create=true
>>> [EL Config]: Connection(12793391)--Connected:
>>> jdbc:derby://localhost:1527/comics;create=true
>>>      User: app
>>>      Database: Apache Derby  Version: 10.4.1.3 - (648739)
>>>      Driver: Apache Derby Network Client JDBC Driver  Version: 10.4.1.3
>>> - (648739)
>>> [EL Config]: Connection(1726320)--connecting(DatabaseLogin(
>>>      platform=>DerbyPlatform
>>>      user name=> "app"
>>>      datasource URL=> "jdbc:derby://localhost:1527/comics;create=true"
>>> ))
>>> [EL Warning]: java.sql.SQLException: No suitable driver found for
>>> jdbc:derby://localhost:1527/comics;create=true
>>> [EL Config]: Connection(23235469)--Connected:
>>> jdbc:derby://localhost:1527/comics;create=true
>>>      User: app
>>>      Database: Apache Derby  Version: 10.4.1.3 - (648739)
>>>      Driver: Apache Derby Network Client JDBC Driver  Version: 10.4.1.3
>>> - (648739)
>>> [EL Info]: bundleresource://28/-comics login successful
>>> org.eclipse.persistence.internal.jpa.EJBQueryImpl@6dd8e1
>>> [EL Fine]: Connection(12793391)--SELECT ID, NAME FROM PUBLISHER ORDER
>>> BY NAME ASC
>>> [EL Fine]: VALUES(1)
>>> [EL Warning]: Exception [EclipseLink-4002] (Eclipse Persistence
>>> Services - 1.0 (Build 1.0 - 20080707)):
>>> org.eclipse.persistence.exceptions.DatabaseException
>>> Internal Exception: java.sql.SQLSyntaxErrorException: Table/View
>>> 'PUBLISHER' does not exist.
>>> Error Code: -1
>>> Call: SELECT ID, NAME FROM PUBLISHER ORDER BY NAME ASC
>>> Query:
>>>
>>> ReadAllQuery(org.eclipse.persistence.example.jpa.comics.model.annotated.Publisher)
>>> Local Exception Stack:
>>> Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0
>>> (Build 1.0 - 20080707)):
>>> org.eclipse.persistence.exceptions.DatabaseException
>>> Internal Exception: java.sql.SQLSyntaxErrorException: Table/View
>>> 'PUBLISHER' does not exist.
>>> Error Code: -1
>>> Call: SELECT ID, NAME FROM PUBLISHER ORDER BY NAME ASC
>>> Query:
>>>
>>> ReadAllQuery(org.eclipse.persistence.example.jpa.comics.model.annotated.Publisher)
>>>      at
>>>
>>> org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:322)
>>>      at
>>>
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:646)
>>>      at
>>>
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:500)
>>>      at
>>>
>>> org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:522)
>>>      at
>>>
>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204)
>>>      at
>>>
>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:190)
>>>      at
>>>
>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:261)
>>>      at
>>>
>>> org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:594)
>>>      at
>>>
>>> org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2505)
>>>      at
>>>
>>> org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2463)
>>>      at
>>>
>>> org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:478)
>>>      at
>>>
>>> org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:883)
>>>      at
>>>
>>> org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:666)
>>>      at
>>>
>>> org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:844)
>>>      at
>>>
>>> org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:456)
>>>      at
>>>
>>> org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:906)
>>>      at
>>>
>>> org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2588)
>>>      at
>>>
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1178)
>>>      at
>>>
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1162)
>>>      at
>>>
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1136)
>>>      at
>>>
>>> org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1118)
>>>      at
>>>
>>> org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:399)
>>>      at
>>>
>>> org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:517)
>>>      at
>>>
>>> org.eclipse.persistence.example.jpa.rcp.comics.Model.getPublishers(Model.java:66)
>>>      at
>>>
>>> org.eclipse.persistence.example.jpa.rcp.comics.ModelAdapter.getChildren(ModelAdapter.java:23)
>>>      at
>>>
>>> org.eclipse.persistence.example.jpa.rcp.comics.AbstractAdapter.fetchDeferredChildren(AbstractAdapter.java:30)
>>>      at
>>>
>>> org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:234)
>>>      at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
>>> Caused by: java.sql.SQLSyntaxErrorException: Table/View 'PUBLISHER'
>>> does not exist.
>>>      at
>>> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
>>> Source)
>>>      at org.apache.derby.client.am.SqlException.getSQLException(Unknown
>>> Source)
>>>      at org.apache.derby.client.am.Connection.prepareStatement(Unknown
>>> Source)
>>>      at
>>>
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1340)
>>>      at
>>>
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:648)
>>>      at
>>>
>>> org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:550)
>>>      ... 26 more
>>> Caused by: org.apache.derby.client.am.SqlException: Table/View
>>> 'PUBLISHER' does not exist.
>>>      at org.apache.derby.client.am.Statement.completeSqlca(Unknown
>>> Source)
>>>      at
>>> org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown
>>> Source)
>>>      at
>>> org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown
>>> Source)
>>>      at
>>>
>>> org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
>>> Source)
>>>      at
>>>
>>> org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown
>>> Source)
>>>      at
>>>
>>> org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown
>>> Source)
>>>      at
>>> org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown
>>> Source)
>>>      at
>>>
>>> org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown
>>> Source)
>>>      at
>>>
>>> org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
>>> Source)
>>>      at org.apache.derby.client.am.PreparedStatement.prepare(Unknown
>>> Source)
>>>      at org.apache.derby.client.am.Connection.prepareStatementX(Unknown
>>> Source)
>>>      ... 30 more
>>> _______________________________________________
>>> eclipselink-users mailing list
>>> eclipselink-users@xxxxxxxxxxx
>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>
>>>
>>>
>>> _______________________________________________
>>> eclipselink-users mailing list
>>> eclipselink-users@xxxxxxxxxxx
>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>
>>>
>>>
>>> _______________________________________________
>>> eclipselink-users mailing list
>>> eclipselink-users@xxxxxxxxxxx
>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>
>>>
>>> _______________________________________________
>>> eclipselink-users mailing list
>>> eclipselink-users@xxxxxxxxxxx
>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>
>>>
>>>
>>> _______________________________________________
>>> eclipselink-users mailing list
>>> eclipselink-users@xxxxxxxxxxx
>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>
>>>
>>> --
>>>
>>>
>>>
>>> Shaun Smith | Principal Product Manager, TopLink | +1.905.502.3094
>>> Oracle Fusion Middleware
>>> 110 Matheson Boulevard West, Suite 100
>>> Mississauga, Ontario, Canada L5R 3P4
>>>
>>> _______________________________________________
>>> eclipselink-users mailing list
>>> eclipselink-users@xxxxxxxxxxx
>>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>>>
>>>
>> _______________________________________________
>> eclipselink-users mailing list
>> eclipselink-users@xxxxxxxxxxx
>> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>