manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karl Wright <daddy...@gmail.com>
Subject Re: Cannot find OracleDriver
Date Mon, 27 Feb 2012 15:27:27 GMT
So if the "Database and Host" field really is "21:16:18:145:1521", try
"21.16.18.145:1521" instead. ;-)

Karl

On Mon, Feb 27, 2012 at 9:22 AM, Matthew Parker
<mparker@apogeeintegration.com> wrote:
> type: JDBC
> Authority: None
> Database Type: ORACLE
> Database and Host: 21:16:18:145:1521
> Instance/Database: main
> User Name: XXXX
> Password: XXXXX
>
>
> On Sun, Feb 26, 2012 at 2:48 PM, Karl Wright <daddywri@gmail.com> wrote:
>>
>> I haven't seen this one.  I'd love to know what the "connect
>> descriptor" it refers to is.
>>
>> Can you tell me what the parameters all look like for the JDBC
>> connection you are setting up?  Are you specifying, for instance, the
>> port as part of the server name?
>>
>> Karl
>>
>> On Sat, Feb 25, 2012 at 1:22 PM, Matthew Parker
>> <mparker@apogeeintegration.com> wrote:
>> > Karl,
>> >
>> > That fixed the driver issue. I just updated my start.jar file by hand
>> > for
>> > now.
>> >
>> > The problem I have now is connecting to ORACLE. I can do it through
>> > NetBeans
>> > on my machine, but
>> > I cannot connect through ManfoldCF with the same settings. I get the
>> > following error:
>> >
>> > Error getting connection. Listener refused the connection with the
>> > following
>> > error.
>> >
>> > ORA-12514. TNS:Listener does not currently know of service requested in
>> > connect descriptor.
>> >
>> > This might be more of an ORACLE issue than Manifold issue, but I was
>> > wondering whether
>> > you've encountered the same thing during testing?
>> >
>> > Regards,
>> >
>> > Matt
>> >
>> > On Fri, Jan 20, 2012 at 10:28 AM, Matthew Parker
>> > <mparker@apogeeintegration.com> wrote:
>> >>
>> >> Thanks Karl.
>> >>
>> >> On Thu, Jan 19, 2012 at 9:44 PM, Karl Wright <daddywri@gmail.com>
>> >> wrote:
>> >>>
>> >>> The problem has been fixed on trunk.  Basically, the instructions
>> >>> changed as did some of the build files.  It turned out to be extremely
>> >>> challenging to get JDBC drivers to run when they were loaded by
>> >>> anything other than the system classloader, so that's what I was
>> >>> forced to insure.
>> >>>
>> >>> Thanks,
>> >>> Karl
>> >>>
>> >>>
>> >>> On Thu, Jan 19, 2012 at 3:33 PM, Karl Wright <daddywri@gmail.com>
>> >>> wrote:
>> >>> > The ticket for this problem is CONNECTORS-390.
>> >>> >
>> >>> > Karl
>> >>> >
>> >>> > On Thu, Jan 19, 2012 at 3:05 PM, Matthew Parker
>> >>> > <mparker@apogeeintegration.com> wrote:
>> >>> >> Many thanks. I'll give that a try.
>> >>> >>
>> >>> >> On Thu, Jan 19, 2012 at 3:01 PM, Karl Wright <daddywri@gmail.com>
>> >>> >> wrote:
>> >>> >>>
>> >>> >>> The problem is that the JDBC driver is using a pool driver
that is
>> >>> >>> in
>> >>> >>> common with the core of ManifoldCF.  So the connector-lib
path,
>> >>> >>> which
>> >>> >>> only the connectors know about, won't do.  That's a bug
which I'll
>> >>> >>> create a ticket for.
>> >>> >>>
>> >>> >>> A temporary fix, which is slightly involved, requires you
to put
>> >>> >>> the
>> >>> >>> ojdbc6.jar in the example/lib area, as you already tried,
but in
>> >>> >>> addition you will need to explicitly include the jar in
your
>> >>> >>> classpath.  Normally the start.jar's manifest describes
all the
>> >>> >>> jars
>> >>> >>> in the initial classpath.  I thought it was possible to
also
>> >>> >>> include
>> >>> >>> additional classpath info through the normal --classpath
>> >>> >>> mechanism,
>> >>> >>> but that doesn't seem to work, so you may be stuck with
modifying
>> >>> >>> the
>> >>> >>> root build.xml file to add the jar to the manifest.
>> >>> >>>
>> >>> >>> I'm going to experiment a bit and see if I can come up
with
>> >>> >>> something
>> >>> >>> quickly.
>> >>> >>>
>> >>> >>> Karl
>> >>> >>>
>> >>> >>>
>> >>> >>> On Thu, Jan 19, 2012 at 2:48 PM, Karl Wright <daddywri@gmail.com>
>> >>> >>> wrote:
>> >>> >>> > I was able to reproduce the problem.  I'll get back
to you when
>> >>> >>> > I
>> >>> >>> > figure out what the issue is.
>> >>> >>> > Karl
>> >>> >>> >
>> >>> >>> > On Thu, Jan 19, 2012 at 2:47 PM, Matthew Parker
>> >>> >>> > <mparker@apogeeintegration.com> wrote:
>> >>> >>> >> I've used the jar file in NetBeans to connect
to the database
>> >>> >>> >> without
>> >>> >>> >> any
>> >>> >>> >> issue.
>> >>> >>> >>
>> >>> >>> >> Seems more like a class loader issue.
>> >>> >>> >>
>> >>> >>> >>
>> >>> >>> >> On Thu, Jan 19, 2012 at 2:41 PM, Matthew Parker
>> >>> >>> >> <mparker@apogeeintegration.com> wrote:
>> >>> >>> >>>
>> >>> >>> >>> I have the latest release from the Apache
Manifold site (i.e.
>> >>> >>> >>> 0.3-incubating).
>> >>> >>> >>>
>> >>> >>> >>> I checked the driver jar file with winzip,
and the driver name
>> >>> >>> >>> is
>> >>> >>> >>> still
>> >>> >>> >>> the same (oracle.jdbc.OracleDriver).
>> >>> >>> >>>
>> >>> >>> >>> I'm running java 1.6.0_18-b7 on Windows XP
SP 3.
>> >>> >>> >>>
>> >>> >>> >>> On Thu, Jan 19, 2012 at 2:27 PM, Karl Wright
>> >>> >>> >>> <daddywri@gmail.com>
>> >>> >>> >>> wrote:
>> >>> >>> >>>>
>> >>> >>> >>>> MCF's Oracle support was written against
earlier versions of
>> >>> >>> >>>> the
>> >>> >>> >>>> Oracle driver.  It is possible that they
have changed the
>> >>> >>> >>>> driver
>> >>> >>> >>>> class.  If the driver winds up in the
dist/connector-lib
>> >>> >>> >>>> directory
>> >>> >>> >>>> (I'm assuming you are using trunk or 0.4-incubating),
then it
>> >>> >>> >>>> should
>> >>> >>> >>>> be accessible.
>> >>> >>> >>>>
>> >>> >>> >>>> Could you please try the following:
>> >>> >>> >>>>
>> >>> >>> >>>> jar -tf ojdbc6.jar | grep "oracle/jdbc/OracleDriver"
>> >>> >>> >>>>
>> >>> >>> >>>> ... assuming you are using Linux?
>> >>> >>> >>>>
>> >>> >>> >>>> If the driver class IS found, then the
other possibility is
>> >>> >>> >>>> that
>> >>> >>> >>>> the
>> >>> >>> >>>> jar is compiled against a later version
of Java than the one
>> >>> >>> >>>> you
>> >>> >>> >>>> are
>> >>> >>> >>>> using to run MCF.
>> >>> >>> >>>>
>> >>> >>> >>>> Please let me know what you find.
>> >>> >>> >>>>
>> >>> >>> >>>> Karl
>> >>> >>> >>>>
>> >>> >>> >>>> On Thu, Jan 19, 2012 at 1:43 PM, Matthew
Parker
>> >>> >>> >>>> <mparker@apogeeintegration.com>
wrote:
>> >>> >>> >>>> > I downloaded MCF and started playing
with the default setup
>> >>> >>> >>>> > under
>> >>> >>> >>>> > Jetty
>> >>> >>> >>>> > and
>> >>> >>> >>>> > Derby. It starts up without any issue.
>> >>> >>> >>>> >
>> >>> >>> >>>> > I would like to connect to our ORACLE
database and import
>> >>> >>> >>>> > data
>> >>> >>> >>>> > into
>> >>> >>> >>>> > SOLR.
>> >>> >>> >>>> >
>> >>> >>> >>>> > I placed the ojdbc6.jar file in the
>> >>> >>> >>>> > connectors/jdbc/jdbc-drivers
>> >>> >>> >>>> > directory
>> >>> >>> >>>> > as stated in the README instruction
file to use the ORACLE
>> >>> >>> >>>> > driver.
>> >>> >>> >>>> >
>> >>> >>> >>>> > I ran "ant build" from the main directory,
and restarted
>> >>> >>> >>>> > the
>> >>> >>> >>>> > example in
>> >>> >>> >>>> > dist/example using Jetty.
>> >>> >>> >>>> >
>> >>> >>> >>>> > When I setup a connector, MCF throws
an exception stating
>> >>> >>> >>>> > that
>> >>> >>> >>>> > it
>> >>> >>> >>>> > cannot
>> >>> >>> >>>> > find oracle.jdbc.OracleDriver class.
>> >>> >>> >>>> >
>> >>> >>> >>>> > Looking in the connector-lib directory,
the oracle jar is
>> >>> >>> >>>> > there.
>> >>> >>> >>>> >
>> >>> >>> >>>> > I also tried placing the ojdbc6.jar
in the dist/example/lib
>> >>> >>> >>>> > directory,
>> >>> >>> >>>> > but
>> >>> >>> >>>> > that didn't fix the problem either.
>> >>> >>> >>>> >
>> >>> >>> >>>> > Can anyone point me in the right
direction?
>> >>> >>> >>>> >
>> >>> >>> >>>> > TIA
>> >>> >>> >>>> >
>> >
>> >
>> >
>> > ------------------------------
>> > This e-mail and any files transmitted with it may be proprietary.
>> >  Please
>> > note that any views or opinions presented in this e-mail are solely
>> > those of
>> > the author and do not necessarily represent those of Apogee Integration.
>> >
>
>
>
>
> --
> Regards,
>
> Matt Parker (CTR)
> Senior Software Architect
> Apogee Integration, LLC
> 5180 Parkstone Drive, Suite #160
> Chantilly, Virginia 20151
> 703.272.4797 (site)
> 703.474.1918 (cell)
> www.apogeeintegration.com
>
> ------------------------------
> This e-mail and any files transmitted with it may be proprietary.  Please
> note that any views or opinions presented in this e-mail are solely those of
> the author and do not necessarily represent those of Apogee Integration.
>

Mime
View raw message