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 <daddy...@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 > <mpar...@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 > > <mpar...@apogeeintegration.com> wrote: > >> > >> Thanks Karl. > >> > >> On Thu, Jan 19, 2012 at 9:44 PM, Karl Wright <daddy...@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 <daddy...@gmail.com> > wrote: > >>> > The ticket for this problem is CONNECTORS-390. > >>> > > >>> > Karl > >>> > > >>> > On Thu, Jan 19, 2012 at 3:05 PM, Matthew Parker > >>> > <mpar...@apogeeintegration.com> wrote: > >>> >> Many thanks. I'll give that a try. > >>> >> > >>> >> On Thu, Jan 19, 2012 at 3:01 PM, Karl Wright <daddy...@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 <daddy...@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 > >>> >>> > <mpar...@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 > >>> >>> >> <mpar...@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 < > daddy...@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 > >>> >>> >>>> <mpar...@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.