Eclipse Community Forums: ServerTools (WTP) » casting error while connecting to oracle database

Help

Home

Home » Language IDEs » ServerTools (WTP) » casting error while connecting to oracle database

Show: Today's Messages :: Show Polls :: Message Navigator

casting error while connecting to oracle database [message #219268]

Wed, 13 August 2008 19:53

Lata Lokhande

Messages: 11
Registered: July 2009

Junior Member

I am trying to connect to the oracle 9i database. I am using
oracle.jdbc.xa.client.OracleXADataSource class and classes12-9i.jar file.
for test connection, getting error "cannot be cast to java.sql.Driver"
When I am creating new connection from Data Source Explorer, I selected
"SQL-Model-JDBC Connection" option from the New Connection Profile Wizard.
(I am not sure what to select here.)
I am using
WTP 2.0
WebLogic server 8.1
Oracle 9i.

Any help is appreciated.
Thanks,
Lata

Below is the error

java.lang.ClassCastException: oracle.jdbc.xa.client.OracleXADataSource
cannot be cast to java.sql.Driver
at
org.eclipse.datatools.connectivity.db.generic.JDBCConnection .createConnection(JDBCConnection.java:86)
at
org.eclipse.datatools.connectivity.DriverConnectionBase.inte rnalCreateConnection(DriverConnectionBase.java:104)
at
org.eclipse.datatools.connectivity.DriverConnectionBase.open (DriverConnectionBase.java:53)
at
org.eclipse.datatools.connectivity.db.generic.JDBCConnection Factory.createConnection(JDBCConnectionFactory.java:52)
at
org.eclipse.datatools.connectivity.internal.ConnectionFactor yProvider.createConnection(ConnectionFactoryProvider.java:77 )
at
org.eclipse.datatools.connectivity.internal.ConnectionProfil e.createConnection(ConnectionProfile.java:354)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.ja va:57)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Report message to a moderator

Re: casting error while connecting to oracle database [message #220364 is a reply to message #219268]

Mon, 08 September 2008 08:17

Kaloyan Raev

Messages: 201
Registered: July 2009
Location: Sofia, Bulgaria

Senior Member

This looks to be a problem in the Data Tools Platform (DTP) project. WTP
uses DTP for database connectivity.
You should report your problem in DTP's newsgroups:
http://www.eclipse.org/newsportal/thread.php?group=eclipse.d tp

Greetings,
Kaloyan

"Lata" <llokhande@ups.com> wrote in message
news:e47b0f99d3e67abef2c69dfd5f6943fd$1@www.eclipse.org...
>I am trying to connect to the oracle 9i database. I am using
>oracle.jdbc.xa.client.OracleXADataSource class and classes12-9i.jar file.
> for test connection, getting error "cannot be cast to java.sql.Driver"
> When I am creating new connection from Data Source Explorer, I selected
> "SQL-Model-JDBC Connection" option from the New Connection Profile Wizard.
> (I am not sure what to select here.)
> I am using WTP 2.0
> WebLogic server 8.1
> Oracle 9i.
>
> Any help is appreciated.
> Thanks,
> Lata
>
> Below is the error
>
> java.lang.ClassCastException: oracle.jdbc.xa.client.OracleXADataSource
> cannot be cast to java.sql.Driver
> at
> org.eclipse.datatools.connectivity.db.generic.JDBCConnection .createConnection(JDBCConnection.java:86)
> at
> org.eclipse.datatools.connectivity.DriverConnectionBase.inte rnalCreateConnection(DriverConnectionBase.java:104)
> at
> org.eclipse.datatools.connectivity.DriverConnectionBase.open (DriverConnectionBase.java:53)
> at
> org.eclipse.datatools.connectivity.db.generic.JDBCConnection Factory.createConnection(JDBCConnectionFactory.java:52)
> at
> org.eclipse.datatools.connectivity.internal.ConnectionFactor yProvider.createConnection(ConnectionFactoryProvider.java:77 )
> at
> org.eclipse.datatools.connectivity.internal.ConnectionProfil e.createConnection(ConnectionProfile.java:354)
> at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.ja va:57)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
>

Report message to a moderator

Previous Topic:	Survey about label decorations (with decoration icons)
Next Topic:	How to install updated server adapters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 04:17:55 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter