Skip Menu |

This queue is for tickets about the Inline-Java CPAN distribution.

Report information
The Basics
Id: 22366
Status: resolved
Priority: 0/
Queue: Inline-Java

People
Owner: Nobody in particular
Requestors: joe.workman [...] gs.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: Connecting to Oracle 10 via JDBC
Date: Fri, 20 Oct 2006 16:58:51 +0100
To: <bug-Inline-Java [...] rt.cpan.org>, <inline [...] perl.org>
From: "Workman, Joe" <joe.workman [...] gs.com>

Message body is not shown because sender requested not to inline it.

Download debug.gz
application/x-gzip 2.5m

Message body not shown because it is not plain text.

I am not sure if this is a bug or not but I thought I would ask first. Please let me know if you need me to submit this as a bug. I will more than happily do this. I am using the code attached just fine with Oracle 9.2. However, when I connect to an Oracle 10 instance, I get the error below: You are not allowed to invoke method createStatement in class oracle.jdbc.driver.T4CConnection: Class InlineJavaUserClassLink can not access a member of class oracle.jdbc.driver.PhysicalConnection with modifiers "public synchronized" at (eval 52) line 4561 at ./oracle_jdbc.pl line 22 I have also attached a debug output with PERL_INLINE_JAVA_DEBUG=5 <<orajdbc.pl>> <<debug.gz>> Environment: Solaris 5.8 Generic_108528-18 sun4u sparc SUNW,Ultra-80 perl v5.8.6 Inline::Java v0.51 JDBC v0.01 Oracle 10.1.0 Cheers Joe
Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC
Date: Fri, 20 Oct 2006 17:20:06 -0400
To: bug-Inline-Java [...] rt.cpan.org
From: "Patrick LeBoutillier" <patrick.leboutillier [...] gmail.com>
Joe, Show quoted text
> > I am not sure if this is a bug or not but I thought I would ask first. > Please let me know if you need me to submit this as a bug. I will more > than happily do this.
Hard to tell. I found someone with a similar error (outside of Inline::Java) here: http://mail-archives.apache.org/mod_mbox/db-ojb-user/200404.mbox/%3CF520B214418AD4119F7000508BD90CC205E8F3D9@ivhqsr02%3E but that doesn't really mean it doesn't have anything to do with Inline::Java. I would recommend you write a small Java program that does the same thing and see if it works on both 9 and 10. If so, then we could try lokking into it further. Patrick -- ===================== Patrick LeBoutillier Laval, Québec, Canada
Subject: RE: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC
Date: Mon, 23 Oct 2006 16:43:49 +0100
To: <bug-Inline-Java [...] rt.cpan.org>
From: "Workman, Joe" <joe.workman [...] gs.com>
I have attached the java program that works on both Oracle 9 & 10. I have also attached the identical version of that java in perl using Inline::Java. The perl code does not work on Oracle 10. I still get the following error: oracle.jdbc.driver.T4CConnectionYou are not allowed to invoke method createStatement in class oracle.jdbc.driver.T4CConnection: Class InlineJavaUserClassLink can not access a member of class oracle.jdbc.driver.PhysicalConnection with modifiers "public synchronized" at (eval 52) line 4653 at ./orajdbc.pl line 15 Cheers Joe Show quoted text
-----Original Message----- From: Patrick LeBoutillier via RT [mailto:bug-Inline-Java@rt.cpan.org] Sent: Friday, October 20, 2006 10:20 PM To: Workman, Joe Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > Joe,
> > I am not sure if this is a bug or not but I thought I would ask first. > Please let me know if you need me to submit this as a bug. I will more > than happily do this.
Hard to tell. I found someone with a similar error (outside of Inline::Java) here: http://mail-archives.apache.org/mod_mbox/db-ojb-user/200404.mbox/%3CF520B214418AD4119F7000508BD90CC205E8F3D9@ivhqsr02%3E but that doesn't really mean it doesn't have anything to do with Inline::Java. I would recommend you write a small Java program that does the same thing and see if it works on both 9 and 10. If so, then we could try lokking into it further. Patrick -- ===================== Patrick LeBoutillier Laval, Québec, Canada

Message body is not shown because sender requested not to inline it.

Download dbquery.java
application/octet-stream 778b

Message body not shown because it is not plain text.

Subject: RE: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC
Date: Mon, 23 Oct 2006 19:36:58 +0100
To: "Workman, Joe" <joe.workman [...] gs.com>, <bug-Inline-Java [...] rt.cpan.org>
From: "Workman, Joe" <joe.workman [...] gs.com>
This code works as well . . . Not sure if this helps at all. Sorry my java skills are pretty nil. Cheers Joe Show quoted text
-----Original Message----- From: Workman, Joe Sent: Monday, October 23, 2006 4:44 PM To: 'bug-Inline-Java@rt.cpan.org' Subject: RE: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC I have attached the java program that works on both Oracle 9 & 10. I have also attached the identical version of that java in perl using Inline::Java. The perl code does not work on Oracle 10. I still get the following error: oracle.jdbc.driver.T4CConnectionYou are not allowed to invoke method createStatement in class oracle.jdbc.driver.T4CConnection: Class InlineJavaUserClassLink can not access a member of class oracle.jdbc.driver.PhysicalConnection with modifiers "public synchronized" at (eval 52) line 4653 at ./orajdbc.pl line 15 Cheers Joe
-----Original Message----- From: Patrick LeBoutillier via RT [mailto:bug-Inline-Java@rt.cpan.org] Sent: Friday, October 20, 2006 10:20 PM To: Workman, Joe Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > Joe,
> > I am not sure if this is a bug or not but I thought I would ask first. > Please let me know if you need me to submit this as a bug. I will more > than happily do this.
Hard to tell. I found someone with a similar error (outside of Inline::Java) here: http://mail-archives.apache.org/mod_mbox/db-ojb-user/200404.mbox/%3CF520B214418AD4119F7000508BD90CC205E8F3D9@ivhqsr02%3E but that doesn't really mean it doesn't have anything to do with Inline::Java. I would recommend you write a small Java program that does the same thing and see if it works on both 9 and 10. If so, then we could try lokking into it further. Patrick -- ===================== Patrick LeBoutillier Laval, Québec, Canada

Message body is not shown because sender requested not to inline it.

Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC
Date: Wed, 25 Oct 2006 20:00:39 -0400
To: bug-Inline-Java [...] rt.cpan.org
From: "Patrick LeBoutillier" <patrick.leboutillier [...] gmail.com>
Joe, Try adding: use Inline (Java => Config => CLASSPATH => '/opt/ovaa/tomcat/common/lib/ojdbc14.jar' ) ; to your script before you call "use JDBC" and see if that helps. You must also make sure to remove '/opt/ovaa/tomcat/common/lib/ojdbc14.jar' from the CLASSPATH environment variable, i.e. remove: BEGIN { $ENV{CLASSPATH} .= '/opt/ovaa/tomcat/common/lib/ojdbc14.jar'; } Patrick On 10/23/06, Joe Workman via RT <bug-Inline-Java@rt.cpan.org> wrote: Show quoted text
> > Queue: Inline-Java > Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > > > This code works as well . . . Not sure if this helps at all. Sorry my java skills are pretty nil. > > Cheers > Joe > > -----Original Message----- > From: Workman, Joe > Sent: Monday, October 23, 2006 4:44 PM > To: 'bug-Inline-Java@rt.cpan.org' > Subject: RE: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC > > I have attached the java program that works on both Oracle 9 & 10. I have also attached the identical version of that java in perl using Inline::Java. The perl code does not work on Oracle 10. > > I still get the following error: > > oracle.jdbc.driver.T4CConnectionYou are not allowed to invoke method createStatement in class oracle.jdbc.driver.T4CConnection: Class InlineJavaUserClassLink can not access a member of class oracle.jdbc.driver.PhysicalConnection with modifiers "public synchronized" at (eval 52) line 4653 > at ./orajdbc.pl line 15 > > Cheers > Joe > > -----Original Message----- > From: Patrick LeBoutillier via RT [mailto:bug-Inline-Java@rt.cpan.org] > Sent: Friday, October 20, 2006 10:20 PM > To: Workman, Joe > Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC > > > <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > > > Joe, > >
> > > > I am not sure if this is a bug or not but I thought I would ask first. > > Please let me know if you need me to submit this as a bug. I will more > > than happily do this.
> > Hard to tell. I found someone with a similar error (outside of > Inline::Java) here: > > http://mail-archives.apache.org/mod_mbox/db-ojb-user/200404.mbox/%3CF520B214418AD4119F7000508BD90CC205E8F3D9@ivhqsr02%3E > > but that doesn't really mean it doesn't have anything to do with Inline::Java. > > I would recommend you write a small Java program that does the same > thing and see if it > works on both 9 and 10. If so, then we could try lokking into it further. > > Patrick > -- > ===================== > Patrick LeBoutillier > Laval, Québec, Canada > > > >
-- ===================== Patrick LeBoutillier Laval, Québec, Canada
Subject: RE: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC
Date: Thu, 26 Oct 2006 10:48:54 +0100
To: <bug-Inline-Java [...] rt.cpan.org>
From: "Workman, Joe" <joe.workman [...] gs.com>
Houston, that's a negative. . . . :o) I was hopeful but I am still getting the same error. Cheers Joe Show quoted text
-----Original Message----- From: Patrick LeBoutillier via RT [mailto:bug-Inline-Java@rt.cpan.org] Sent: Thursday, October 26, 2006 1:01 AM To: Workman, Joe Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > Joe, Try adding: use Inline (Java => Config => CLASSPATH => '/opt/ovaa/tomcat/common/lib/ojdbc14.jar' ) ; to your script before you call "use JDBC" and see if that helps. You must also make sure to remove '/opt/ovaa/tomcat/common/lib/ojdbc14.jar' from the CLASSPATH environment variable, i.e. remove: BEGIN { $ENV{CLASSPATH} .= '/opt/ovaa/tomcat/common/lib/ojdbc14.jar'; } Patrick On 10/23/06, Joe Workman via RT <bug-Inline-Java@rt.cpan.org> wrote:
> > Queue: Inline-Java > Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > > > This code works as well . . . Not sure if this helps at all. Sorry my java skills are pretty nil. > > Cheers > Joe > > -----Original Message----- > From: Workman, Joe > Sent: Monday, October 23, 2006 4:44 PM > To: 'bug-Inline-Java@rt.cpan.org' > Subject: RE: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC > > I have attached the java program that works on both Oracle 9 & 10. I have also attached the identical version of that java in perl using Inline::Java. The perl code does not work on Oracle 10. > > I still get the following error: > > oracle.jdbc.driver.T4CConnectionYou are not allowed to invoke method createStatement in class oracle.jdbc.driver.T4CConnection: Class InlineJavaUserClassLink can not access a member of class oracle.jdbc.driver.PhysicalConnection with modifiers "public synchronized" at (eval 52) line 4653 > at ./orajdbc.pl line 15 > > Cheers > Joe > > -----Original Message----- > From: Patrick LeBoutillier via RT [mailto:bug-Inline-Java@rt.cpan.org] > Sent: Friday, October 20, 2006 10:20 PM > To: Workman, Joe > Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC > > > <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > > > Joe, > >
> > > > I am not sure if this is a bug or not but I thought I would ask first. > > Please let me know if you need me to submit this as a bug. I will more > > than happily do this.
> > Hard to tell. I found someone with a similar error (outside of > Inline::Java) here: > > http://mail-archives.apache.org/mod_mbox/db-ojb-user/200404.mbox/%3CF520B214418AD4119F7000508BD90CC205E8F3D9@ivhqsr02%3E > > but that doesn't really mean it doesn't have anything to do with Inline::Java. > > I would recommend you write a small Java program that does the same > thing and see if it > works on both 9 and 10. If so, then we could try lokking into it further. > > Patrick > -- > ===================== > Patrick LeBoutillier > Laval, Québec, Canada > > > >
-- ===================== Patrick LeBoutillier Laval, Québec, Canada
Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC
Date: Thu, 26 Oct 2006 19:53:08 -0400
To: bug-Inline-Java [...] rt.cpan.org
From: "Patrick LeBoutillier" <patrick.leboutillier [...] gmail.com>
Joe, On 10/26/06, Joe Workman via RT <bug-Inline-Java@rt.cpan.org> wrote: Show quoted text
> > Queue: Inline-Java > Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > > > Houston, that's a negative. . . . :o)
Unfortunately I have run out of ideas for now... plus I don't have Oracle (and I'm guessing the source for the Oracle JDBC driver is not available) so I don't have much to go on. If anything else comes up let me know (and I'll do the same). Cheers, Patrick Show quoted text
> > I was hopeful but I am still getting the same error. > > Cheers > Joe > > -----Original Message----- > From: Patrick LeBoutillier via RT [mailto:bug-Inline-Java@rt.cpan.org] > Sent: Thursday, October 26, 2006 1:01 AM > To: Workman, Joe > Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC > > > <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > > > Joe, > > Try adding: > > use Inline (Java => Config => > CLASSPATH => '/opt/ovaa/tomcat/common/lib/ojdbc14.jar' > ) ; > > to your script before you call "use JDBC" and see if that helps. You > must also make sure > to remove '/opt/ovaa/tomcat/common/lib/ojdbc14.jar' from the CLASSPATH > environment variable, i.e. remove: > > BEGIN { > $ENV{CLASSPATH} .= '/opt/ovaa/tomcat/common/lib/ojdbc14.jar'; > } > > > Patrick > > > > On 10/23/06, Joe Workman via RT <bug-Inline-Java@rt.cpan.org> wrote:
> > > > Queue: Inline-Java > > Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > > > > > This code works as well . . . Not sure if this helps at all. Sorry my java skills are pretty nil. > > > > Cheers > > Joe > > > > -----Original Message----- > > From: Workman, Joe > > Sent: Monday, October 23, 2006 4:44 PM > > To: 'bug-Inline-Java@rt.cpan.org' > > Subject: RE: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC > > > > I have attached the java program that works on both Oracle 9 & 10. I have also attached the identical version of that java in perl using Inline::Java. The perl code does not work on Oracle 10. > > > > I still get the following error: > > > > oracle.jdbc.driver.T4CConnectionYou are not allowed to invoke method createStatement in class oracle.jdbc.driver.T4CConnection: Class InlineJavaUserClassLink can not access a member of class oracle.jdbc.driver.PhysicalConnection with modifiers "public synchronized" at (eval 52) line 4653 > > at ./orajdbc.pl line 15 > > > > Cheers > > Joe > > > > -----Original Message----- > > From: Patrick LeBoutillier via RT [mailto:bug-Inline-Java@rt.cpan.org] > > Sent: Friday, October 20, 2006 10:20 PM > > To: Workman, Joe > > Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC > > > > > > <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > > > > > Joe, > > > >
> > > > > > I am not sure if this is a bug or not but I thought I would ask first. > > > Please let me know if you need me to submit this as a bug. I will more > > > than happily do this.
> > > > Hard to tell. I found someone with a similar error (outside of > > Inline::Java) here: > > > > http://mail-archives.apache.org/mod_mbox/db-ojb-user/200404.mbox/%3CF520B214418AD4119F7000508BD90CC205E8F3D9@ivhqsr02%3E > > > > but that doesn't really mean it doesn't have anything to do with Inline::Java. > > > > I would recommend you write a small Java program that does the same > > thing and see if it > > works on both 9 and 10. If so, then we could try lokking into it further. > > > > Patrick > > -- > > ===================== > > Patrick LeBoutillier > > Laval, Québec, Canada > > > > > > > >
> > > -- > ===================== > Patrick LeBoutillier > Laval, Québec, Canada > >
-- ===================== Patrick LeBoutillier Laval, Québec, Canada
Subject: RE: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC
Date: Fri, 27 Oct 2006 10:17:19 +0100
To: <bug-Inline-Java [...] rt.cpan.org>
From: "Workman, Joe" <joe.workman [...] gs.com>
I have fallen back to an ODBC connection for the time being. I appreciate the help. I could send you the zip file of classes, but I don't know if that would help . . . Cheers Joe Show quoted text
-----Original Message----- From: Patrick LeBoutillier via RT [mailto:bug-Inline-Java@rt.cpan.org] Sent: Friday, October 27, 2006 12:54 AM To: Workman, Joe Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > Joe, On 10/26/06, Joe Workman via RT <bug-Inline-Java@rt.cpan.org> wrote:
> > Queue: Inline-Java > Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > > > Houston, that's a negative. . . . :o)
Unfortunately I have run out of ideas for now... plus I don't have Oracle (and I'm guessing the source for the Oracle JDBC driver is not available) so I don't have much to go on. If anything else comes up let me know (and I'll do the same). Cheers, Patrick
> > I was hopeful but I am still getting the same error. > > Cheers > Joe > > -----Original Message----- > From: Patrick LeBoutillier via RT [mailto:bug-Inline-Java@rt.cpan.org] > Sent: Thursday, October 26, 2006 1:01 AM > To: Workman, Joe > Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC > > > <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > > > Joe, > > Try adding: > > use Inline (Java => Config => > CLASSPATH => '/opt/ovaa/tomcat/common/lib/ojdbc14.jar' > ) ; > > to your script before you call "use JDBC" and see if that helps. You > must also make sure > to remove '/opt/ovaa/tomcat/common/lib/ojdbc14.jar' from the CLASSPATH > environment variable, i.e. remove: > > BEGIN { > $ENV{CLASSPATH} .= '/opt/ovaa/tomcat/common/lib/ojdbc14.jar'; > } > > > Patrick > > > > On 10/23/06, Joe Workman via RT <bug-Inline-Java@rt.cpan.org> wrote:
> > > > Queue: Inline-Java > > Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > > > > > This code works as well . . . Not sure if this helps at all. Sorry my java skills are pretty nil. > > > > Cheers > > Joe > > > > -----Original Message----- > > From: Workman, Joe > > Sent: Monday, October 23, 2006 4:44 PM > > To: 'bug-Inline-Java@rt.cpan.org' > > Subject: RE: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC > > > > I have attached the java program that works on both Oracle 9 & 10. I have also attached the identical version of that java in perl using Inline::Java. The perl code does not work on Oracle 10. > > > > I still get the following error: > > > > oracle.jdbc.driver.T4CConnectionYou are not allowed to invoke method createStatement in class oracle.jdbc.driver.T4CConnection: Class InlineJavaUserClassLink can not access a member of class oracle.jdbc.driver.PhysicalConnection with modifiers "public synchronized" at (eval 52) line 4653 > > at ./orajdbc.pl line 15 > > > > Cheers > > Joe > > > > -----Original Message----- > > From: Patrick LeBoutillier via RT [mailto:bug-Inline-Java@rt.cpan.org] > > Sent: Friday, October 20, 2006 10:20 PM > > To: Workman, Joe > > Subject: Re: [rt.cpan.org #22366] Connecting to Oracle 10 via JDBC > > > > > > <URL: http://rt.cpan.org/Ticket/Display.html?id=22366 > > > > > Joe, > > > >
> > > > > > I am not sure if this is a bug or not but I thought I would ask first. > > > Please let me know if you need me to submit this as a bug. I will more > > > than happily do this.
> > > > Hard to tell. I found someone with a similar error (outside of > > Inline::Java) here: > > > > http://mail-archives.apache.org/mod_mbox/db-ojb-user/200404.mbox/%3CF520B214418AD4119F7000508BD90CC205E8F3D9@ivhqsr02%3E > > > > but that doesn't really mean it doesn't have anything to do with Inline::Java. > > > > I would recommend you write a small Java program that does the same > > thing and see if it > > works on both 9 and 10. If so, then we could try lokking into it further. > > > > Patrick > > -- > > ===================== > > Patrick LeBoutillier > > Laval, Québec, Canada > > > > > > > >
> > > -- > ===================== > Patrick LeBoutillier > Laval, Québec, Canada > >
-- ===================== Patrick LeBoutillier Laval, Québec, Canada
Sadly there is literally no chance of this problem either a) still materially existing in any working system; b) being solvable. Therefore I am regretfully closing this ticket.