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

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