Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » Net4j Oracle DB Adaptor(Cannot locate a Net4j Oracle DB Adaptor)
Net4j Oracle DB Adaptor [message #967582] Thu, 01 November 2012 17:49 Go to next message
Andrew Whelan is currently offline Andrew Whelan
Messages: 69
Registered: October 2012
Location: Syracuse NY
Member
Hello,

I've recently started doing lots of research on the CDO tooling and I am looking for a Net4j Oracle DB Adaptor. I was able to get some things working with MySQL following the instructions in the tutorial on the rcp-vision site.

But I don't think CDO will make a love match with my project unless I can get it to work with Oracle. The support plugins that were downloaded with the Net4j Sinalling Platform SDK seemed to have just about all of the other db plugins I've seen mentioned in documentation.

I also see that there are plenty of questions about the Oracle DB Adapter on the forums. I just can't seem to find a place to download or obtain it.
I can't seem to find it in the CDO/Net4J plus download either.

Does anyone know where I might actually find it? Smile
Thanks
-Andrew
Re: Net4j Oracle DB Adaptor [message #967885 is a reply to message #967582] Thu, 01 November 2012 23:42 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5484
Registered: July 2009
Senior Member
Am 01.11.2012 22:49, schrieb Andrew Whelan:
> Hello,
>
> I've recently started doing lots of research on the CDO tooling and I am looking for a Net4j Oracle DB Adaptor. I was
> able to get some things working with MySQL following the instructions in the tutorial on the rcp-vision site.
>
> But I don't think CDO will make a love match with my project unless I can get it to work with Oracle.
Lucky you. It's just five days ago that I was finally able to resolve this bug:

270428: [DB] Provide Oracle RDBMS integration
https://bugs.eclipse.org/bugs/show_bug.cgi?id=270428

Thanks to the hints of some Oracle guys at the EclipseCon, who pointed me to a public p2 repo with an OSGi'ified JDBC
driver for Oracle.

> The support plugins that were downloaded with the Net4j Sinalling Platform SDK seemed to have just about all of the
> other db plugins I've seen mentioned in documentation.
>
> I also see that there are plenty of questions about the Oracle DB Adapter on the forums. I just can't seem to find a
> place to download or obtain it.
> I can't seem to find it in the CDO/Net4J plus download either.
>
> Does anyone know where I might actually find it? :)
The org.eclipse.net4j.db.oracle bundle is now available in our integration repos at
http://www.eclipse.org/cdo/downloads/#integration . Before you point p2 to any of these (composite) repos you should
import the bookmarks.xml of a recent drop. They contain the location of the driver repository at orcale.com that we're
using to build our integration.

Please not that there are some pending bugzillas:
https://bugs.eclipse.org/bugs/buglist.cgi?list_id=3411236&short_desc=oracle&classification=Modeling&query_format=advanced&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&short_desc_type=allwordssubstr&component=cdo.core&component=cdo.dawn&component=cdo.db&component=cdo.docs&component=cdo.hibernate&component=cdo.legacy&component=cdo.net4j&component=cdo.net4j.db&component=cdo.net4j.ui&component=cdo.objy&component=cdo.releng&component=cdo.ui&product=EMF

I'm going to have a look at them now...

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: Net4j Oracle DB Adaptor [message #972572 is a reply to message #967885] Mon, 05 November 2012 13:35 Go to previous messageGo to next message
Andrew Whelan is currently offline Andrew Whelan
Messages: 69
Registered: October 2012
Location: Syracuse NY
Member
Hi Eike,

I was able to locate and install the Net4j Oracle DB Adaptor ok from the integration site. However I'm having trouble
starting up a CDO Server with it. I have an Eclipse Application Runtime Configuration for the CDO Server
that I run from the IDE. It works fine for the commented out MySQL configuration below, but I am getting an
"Invalid Oracle URL specified: OracleDataSource.makeURL" exception when I try to use the Oracle configuration.
Note that I have a small Java main application which connects to the Oracle XE database referred to
just fine, using oracle.jdbc.pool.OracleDataSource and the user and password below. Do you have any ideas?

<!--
<dbAdapter name="mysql"/>
<dataSource class="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"
url="jdbc:mysql://localhost:3306/repo1"
user="root"
password="password"/>
/>
-->


<dbAdapter name="oracle"/>
<dataSource class="oracle.jdbc.pool.OracleDataSource"
url="jdbc:oracle:thin:@localhost:1521:xe"
user="username"
password="password"
/>

The full exception stack trace is below:

[INFO] CDO server starting
!SESSION 2012-11-05 13:20:58.680 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_37
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Framework arguments: -product org.eclipse.emf.cdo.server.product.tcp_h2
Command-line arguments: -product org.eclipse.emf.cdo.server.product.tcp_h2 -data C:\Users\awhelan\Shepherd\workspace_rose/../runtime-EclipseApplication -dev file:C:/Users/awhelan/Shepherd/workspace_rose/.metadata/.plugins/org.eclipse.pde.core/CDO_Server/dev.properties -os win32 -ws win32 -arch x86 -consoleLog

!ENTRY org.eclipse.emf.cdo.server 1 0 2012-11-05 13:20:59.874
!MESSAGE CDO server starting
[ERROR] java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
org.eclipse.net4j.db.DBException: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at org.eclipse.net4j.internal.db.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:46)
at org.eclipse.emf.cdo.server.internal.db.DBStore.getConnection(DBStore.java:183)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:520)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1846)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:208)
at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:111)
at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:1353)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:195)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:165)
at org.eclipse.net4j.internal.db.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:42)
... 16 more

!ENTRY org.eclipse.net4j.util 4 0 2012-11-05 13:21:00.129
!MESSAGE java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
!STACK 0
org.eclipse.net4j.db.DBException: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at org.eclipse.net4j.internal.db.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:46)
at org.eclipse.emf.cdo.server.internal.db.DBStore.getConnection(DBStore.java:183)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:520)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1846)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:208)
at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:111)
at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:1353)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:195)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:165)
at org.eclipse.net4j.internal.db.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:42)
... 16 more

!ENTRY org.eclipse.equinox.app 4 0 2012-11-05 13:21:00.136
!MESSAGE java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
!STACK 0
org.eclipse.net4j.db.DBException: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at org.eclipse.net4j.internal.db.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:46)
at org.eclipse.emf.cdo.server.internal.db.DBStore.getConnection(DBStore.java:183)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:520)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1846)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:208)
at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:111)
at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:1353)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:195)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:165)
at org.eclipse.net4j.internal.db.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:42)
... 16 more

Re: Net4j Oracle DB Adaptor [message #972593 is a reply to message #972572] Mon, 05 November 2012 13:57 Go to previous messageGo to next message
Erdal Karaca is currently offline Erdal Karaca
Messages: 729
Registered: July 2009
Senior Member
Try this:

      <dbAdapter name="oracle"/>
      <dataSource class="oracle.jdbc.pool.OracleDataSource"
        uRL="jdbc:oracle:thin:@localhost:1521:xe"
        user="username"
        password="password"
        />


Note the difference of how to name the parameter: 'uRL' instead of 'url'.
See comment 43 of the following bug for more details:

https://bugs.eclipse.org/bugs/show_bug.cgi?id=270428#c43


Andrew Whelan wrote on Mon, 05 November 2012 13:35
Hi Eike,

I was able to locate and install the Net4j Oracle DB Adaptor ok from the integration site. However I'm having trouble
starting up a CDO Server with it. I have an Eclipse Application Runtime Configuration for the CDO Server
that I run from the IDE. It works fine for the commented out MySQL configuration below, but I am getting an
"Invalid Oracle URL specified: OracleDataSource.makeURL" exception when I try to use the Oracle configuration.
Note that I have a small Java main application which connects to the Oracle XE database referred to
just fine, using oracle.jdbc.pool.OracleDataSource and the user and password below. Do you have any ideas?

<!--
<dbAdapter name="mysql"/>
<dataSource class="com.mysql.jdbc.jdbc2.optional.MysqlDataSource"
url="jdbc:mysql://localhost:3306/repo1"
user="root"
password="password"/>
/>
-->


<dbAdapter name="oracle"/>
<dataSource class="oracle.jdbc.pool.OracleDataSource"
url="jdbc:oracle:thin:@localhost:1521:xe"
user="username"
password="password"
/>

The full exception stack trace is below:

[INFO] CDO server starting
!SESSION 2012-11-05 13:20:58.680 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.6.0_37
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Framework arguments: -product org.eclipse.emf.cdo.server.product.tcp_h2
Command-line arguments: -product org.eclipse.emf.cdo.server.product.tcp_h2 -data C:\Users\awhelan\Shepherd\workspace_rose/../runtime-EclipseApplication -dev file:C:/Users/awhelan/Shepherd/workspace_rose/.metadata/.plugins/org.eclipse.pde.core/CDO_Server/dev.properties -os win32 -ws win32 -arch x86 -consoleLog

!ENTRY org.eclipse.emf.cdo.server 1 0 2012-11-05 13:20:59.874
!MESSAGE CDO server starting
[ERROR] java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
org.eclipse.net4j.db.DBException: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at org.eclipse.net4j.internal.db.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:46)
at org.eclipse.emf.cdo.server.internal.db.DBStore.getConnection(DBStore.java:183)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:520)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1846)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:208)
at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:111)
at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:1353)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:195)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:165)
at org.eclipse.net4j.internal.db.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:42)
... 16 more

!ENTRY org.eclipse.net4j.util 4 0 2012-11-05 13:21:00.129
!MESSAGE java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
!STACK 0
org.eclipse.net4j.db.DBException: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at org.eclipse.net4j.internal.db.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:46)
at org.eclipse.emf.cdo.server.internal.db.DBStore.getConnection(DBStore.java:183)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:520)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1846)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:208)
at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:111)
at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:1353)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:195)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:165)
at org.eclipse.net4j.internal.db.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:42)
... 16 more

!ENTRY org.eclipse.equinox.app 4 0 2012-11-05 13:21:00.136
!MESSAGE java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
!STACK 0
org.eclipse.net4j.db.DBException: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at org.eclipse.net4j.internal.db.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:46)
at org.eclipse.emf.cdo.server.internal.db.DBStore.getConnection(DBStore.java:183)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:520)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1846)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:208)
at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:111)
at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:1353)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:195)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:165)
at org.eclipse.net4j.internal.db.DataSourceConnectionProvider.getConnection(DataSourceConnectionProvider.java:42)
... 16 more


Re: Net4j Oracle DB Adaptor [message #973597 is a reply to message #972593] Tue, 06 November 2012 08:12 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5484
Registered: July 2009
Senior Member
Am 05.11.2012 19:58, schrieb Erdal Karaca:
> <dbAdapter name="oracle"/>
> <dataSource class="oracle.jdbc.pool.OracleDataSource"
> uRL="jdbc:oracle:thin:@localhost:1521:xe"
> user="username"
> password="password"
> />

I added that to the default cdo-server.xml. Thanks ;-)

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: Net4j Oracle DB Adaptor [message #973998 is a reply to message #973597] Tue, 06 November 2012 14:44 Go to previous messageGo to next message
Andrew Whelan is currently offline Andrew Whelan
Messages: 69
Registered: October 2012
Location: Syracuse NY
Member
Yes that works.

However now I am getting the "Problem with table cdo_lobs: SELECT id, size, bdata, cdata FROM cdo_lobs" exception that I've seen reported by other users. However the "caused by" exception. In this case the "Caused by" exception is java.sql.SQLException: ORA-00936: missing expression.

I believe the reason this is getting flagged is because "size" is an oracle keyword. Its important to note that I don't see any tables getting created. The user "repo1" has the correct permissions. I can create, drop, and select tables using SQLPLUS and also in a little java application that I am running from the same Eclipse IDE.

Does anyone have any ideas?

Following is the complete stack trace:

!ENTRY org.eclipse.net4j.util 4 0 2012-11-06 14:39:23.342
!MESSAGE Problem with table cdo_lobs: SELECT id, size, bdata, cdata FROM cdo_lobs
!STACK 0
org.eclipse.net4j.db.DBException: Problem with table cdo_lobs: SELECT id, size, bdata, cdata FROM cdo_lobs
at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:447)
at org.eclipse.net4j.spi.db.DBAdapter.createTable(DBAdapter.java:146)
at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.java:111)
at org.eclipse.net4j.spi.db.DBSchema.create(DBSchema.java:118)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:531)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1846)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:208)
at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:111)
at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-00936: missing expression

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)
at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:428)
... 18 more
org.eclipse.net4j.db.DBException: Problem with table cdo_lobs: SELECT id, size, bdata, cdata FROM cdo_lobs
at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:447)
at org.eclipse.net4j.spi.db.DBAdapter.createTable(DBAdapter.java:146)
at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.java:111)
at org.eclipse.net4j.spi.db.DBSchema.create(DBSchema.java:118)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:531)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1846)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:208)
at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:111)
at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-00936: missing expression

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)
at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:428)
... 18 more

!ENTRY org.eclipse.equinox.app 4 0 2012-11-06 14:39:23.343
!MESSAGE Problem with table cdo_lobs: SELECT id, size, bdata, cdata FROM cdo_lobs
!STACK 0
org.eclipse.net4j.db.DBException: Problem with table cdo_lobs: SELECT id, size, bdata, cdata FROM cdo_lobs
at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:447)
at org.eclipse.net4j.spi.db.DBAdapter.createTable(DBAdapter.java:146)
at org.eclipse.net4j.spi.db.DBAdapter.createTables(DBAdapter.java:111)
at org.eclipse.net4j.spi.db.DBSchema.create(DBSchema.java:118)
at org.eclipse.emf.cdo.server.internal.db.DBStore.doActivate(DBStore.java:531)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.internal.server.Repository.doActivate(Repository.java:1846)
at org.eclipse.net4j.util.lifecycle.Lifecycle.activate(Lifecycle.java:76)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:114)
at org.eclipse.net4j.util.lifecycle.LifecycleUtil.activate(LifecycleUtil.java:104)
at org.eclipse.emf.cdo.server.CDOServerUtil.addRepository(CDOServerUtil.java:208)
at org.eclipse.emf.cdo.spi.server.RepositoryConfigurator.configure(RepositoryConfigurator.java:111)
at org.eclipse.emf.cdo.internal.server.bundle.CDOServerApplication.doStart(CDOServerApplication.java:61)
at org.eclipse.net4j.util.om.OSGiApplication.start(OSGiApplication.java:63)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.equinox.internal.app.AnyThreadAppLauncher.run(AnyThreadAppLauncher.java:26)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-00936: missing expression

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)
at org.eclipse.net4j.spi.db.DBAdapter.validateTable(DBAdapter.java:428)
... 18 more
Re: Net4j Oracle DB Adaptor [message #974090 is a reply to message #973998] Tue, 06 November 2012 16:22 Go to previous messageGo to next message
Erdal Karaca is currently offline Erdal Karaca
Messages: 729
Registered: July 2009
Senior Member
AFAIK, that should be fixed with the latest build.
What version are you using?
Re: Net4j Oracle DB Adaptor [message #975009 is a reply to message #974090] Wed, 07 November 2012 09:21 Go to previous messageGo to next message
Andrew Whelan is currently offline Andrew Whelan
Messages: 69
Registered: October 2012
Location: Syracuse NY
Member
I pulled the Oracle Adaptor off of http://download.eclipse.org/modeling/emf/cdo/drops/I20121102-0646/

Is this what you are referring to? This was under the integration build.
Re: Net4j Oracle DB Adaptor [message #975024 is a reply to message #975009] Wed, 07 November 2012 09:33 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5484
Registered: July 2009
Senior Member
Am 07.11.2012 15:21, schrieb Andrew Whelan:
> I pulled the Oracle Adaptor off of http://download.eclipse.org/modeling/emf/cdo/drops/I20121102-0646/
>
> Is this what you are referring to? This was under the integration build.
Yes, that should do.

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: Net4j Oracle DB Adaptor [message #975025 is a reply to message #975009] Wed, 07 November 2012 09:37 Go to previous messageGo to next message
Erdal Karaca is currently offline Erdal Karaca
Messages: 729
Registered: July 2009
Senior Member
You are using a very old build Smile

The size issue was fixed 2 days ago:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=344232

Re: Net4j Oracle DB Adaptor [message #975050 is a reply to message #975024] Wed, 07 November 2012 09:55 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5484
Registered: July 2009
Senior Member
Am 07.11.2012 15:33, schrieb Eike Stepper:
> Am 07.11.2012 15:21, schrieb Andrew Whelan:
>> I pulled the Oracle Adaptor off of http://download.eclipse.org/modeling/emf/cdo/drops/I20121102-0646/
>>
>> Is this what you are referring to? This was under the integration build.
> Yes, that should do.
Gosh, I didn't actually look at the drop date you mentioned. Erdal is right, please use the newest I-build to get the
"size" column fix.

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: Net4j Oracle DB Adaptor [message #978214 is a reply to message #975050] Fri, 09 November 2012 18:03 Go to previous messageGo to next message
Andrew Whelan is currently offline Andrew Whelan
Messages: 69
Registered: October 2012
Location: Syracuse NY
Member
I'm still having the same problem. I grabbed the integration build from 11-09: http://download.eclipse.org/modeling/emf/cdo/drops/I20121109-0410/index.html

(1.0.0v20121109-0412)

Do I need to update more than just the Net4j DM Framework Oracle Adaptor?
Re: Net4j Oracle DB Adaptor [message #978441 is a reply to message #978214] Fri, 09 November 2012 22:34 Go to previous message
Eike Stepper is currently offline Eike Stepper
Messages: 5484
Registered: July 2009
Senior Member
Am 10.11.2012 00:03, schrieb Andrew Whelan:
> I'm still having the same problem. I grabbed the integration build from 11-09:
> http://download.eclipse.org/modeling/emf/cdo/drops/I20121109-0410/index.html
>
> (1.0.0v20121109-0412)
>
> Do I need to update more than just the Net4j DM Framework Oracle Adaptor?
Especially in an integration stream it's strongly recommended to always update the entire installation via p2 because
that's the only way to reliably end up with a consistent state.

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Previous Topic:creating psm
Next Topic:[Xcore] Problem with an .xcore model refering to a class defined in a .ecore model
Goto Forum:
  


Current Time: Mon Jul 28 22:41:51 EDT 2014

Powered by FUDForum. Page generated in 0.08644 seconds