Non DBCP Solutions

2003-03-31 Thread Marco Rossi
Hi,
it's possible to configure Tomcat 4.1.24 to use a Oracle DataSource, and not DBCP?

Thanks in advance,
marco

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: how to print multi page report from jsp

2003-03-31 Thread Marco Rossi
Try JasperReports (http://jasperreports.sourceforge.net/); it's an open source project 
to create reports server-side.

Marco

>Hi,
>I have developed an intranet application using jsp/servlets. I need to
>print a multipage report which have common header and footer. Also I have to
>specify the page size and font. For single page printing I was using
>javascript function window.print(). But it is impossible to use in it in
>this case. Also I want to avoid the print dialog of the browser. All client
>machines are using IE 5 or above. Is there any open source java api which
>can be run inside to generate the report and print it. Or is there any HTML
>way for it.
>Thanx in advance.
>Anto
>
>
>-
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



DataSource implementation

2003-03-31 Thread Marco Rossi
Hi,
it's possible to configure Tomcat 4.1.24 to use another DataSource implementation, and 
not DBCP?

Thanks,
marco

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Casting DBCP Connection to OracleConnection

2003-03-31 Thread Marco Rossi
I have the same problem. If you find a solution, please reply

>
>HI,
>
>I am using Tomcat 4.1.18 with Oracle 9i. When I try to cast the
>Connection returned from DBCP to OracleConnection I get a
>ClassCastException .
>
>Anyone here know how to cast correctly ?
>
>Thanks
>
>-
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: Casting DBCP Connection to OracleConnection - Solved IT!

2003-03-31 Thread Marco Rossi
Where do you find ojdbc_g.jar?

>I was using ojdbc_g.jar instead of classes12.zip ( i.e classes12.jar )
>
>Sundar
>
>-Original Message-
>From: Chakravarthy, Sundar 
>Sent: Monday, March 31, 2003 11:11 AM
>To: Tomcat Users List
>Subject: RE: Casting DBCP Connection to OracleConnection
>
>Strange .. the getDelegate().getClass().getName() returns
>"oracle.jdbc.driver.OracleConnection" . But the cast fails at runtime.
>
>Sundar
>
>-Original Message-
>From: Filip Hanik [mailto:[EMAIL PROTECTED] 
>Sent: Monday, March 31, 2003 11:05 AM
>To: Tomcat Users List
>Subject: RE: Casting DBCP Connection to OracleConnection
>
>hi Sundar,
>as an alternative, why don't you print the class names to know what you
>are
>doing
>
>for example
>
>System.out.println("delegate="+conn.getDelegate().getClass().getName());
>
>and do that for all of the things you try to cast, that way you can see
>what
>you are accessing before you try to cast it
>
>Filip
>
>> -Original Message-
>> From: Chakravarthy, Sundar [mailto:[EMAIL PROTECTED]
>> Sent: Monday, March 31, 2003 7:57 AM
>> To: Tomcat Users List
>> Subject: RE: Casting DBCP Connection to OracleConnection
>>
>>
>>
>> Run-time failure using both getInnermostDelegate() and getDelegate().
>> Any other alternatives ?
>>
>> -Sundar
>>
>> -Original Message-
>> From: Tim Funk [mailto:[EMAIL PROTECTED]
>> Sent: Monday, March 31, 2003 10:49 AM
>> To: Tomcat Users List
>> Subject: Re: Casting DBCP Connection to OracleConnection
>>
>> Compile fail or run-time fail?
>>
>> If compile fail - you need a nightly of dbcp.
>> If run-time fail, you may need to use getInnermostDelegate() instead
>>
>> -Tim
>>
>> Chakravarthy, Sundar wrote:
>> > I tried the following with no success,
>> >
>> > 1. PoolableConnection pc = (PoolableConnection)conn;
>> > 2. OracleConnection oc = (OracleConnection)pc.getDelegate();
>> >
>> > Fails in line 2
>> >
>> > -Sundar
>> >
>> >
>> > -Original Message-
>> > From: Tim Funk [mailto:[EMAIL PROTECTED]
>> > Sent: Monday, March 31, 2003 10:34 AM
>> > To: Tomcat Users List
>> > Subject: Re: Casting DBCP Connection to OracleConnection
>> >
>> > All dbcp objects have a getDelegate() method (I think). But you'll
>> need
>> > to do 2 casts.
>> > - dbcpConn = (DBCPClassCast)conn--> The dbcp connection
>> > - myOraConn = (OraClassCast)dbcpConn.getDelegate() --> Get the
>> > underlying implementation
>> >
>> > Look at the DBCP javadocs for the correct class names.
>> >
>> > BUT you'll need to use a nightly build of dbcp to do this since the
>> > version shipped with tomcat doesn't have the getDeletgate() methods.
>> >
>> > -Tim
>> >
>> > Marco Rossi wrote:
>> >
>> >>I have the same problem. If you find a solution, please reply
>> >>
>> >>
>> >>
>> >>>HI,
>> >>>
>> >>>I am using Tomcat 4.1.18 with Oracle 9i. When I try to cast the
>> >>>Connection returned from DBCP to OracleConnection I get a
>> >>>ClassCastException .
>> >>>
>> >>>Anyone here know how to cast correctly ?
>> >>>
>> >>>Thanks
>> >>>
>> >
>> >
>> >
>> >
>-
>> > To unsubscribe, e-mail: [EMAIL PROTECTED]
>> > For additional commands, e-mail: [EMAIL PROTECTED]
>> >
>> >
>> >
>-
>> > To unsubscribe, e-mail: [EMAIL PROTECTED]
>> > For additional commands, e-mail: [EMAIL PROTECTED]
>> >
>> >
>> >
>>
>>
>> -
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>> -
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>
>
>-
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>-
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>-
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



RE: Casting DBCP Connection to OracleConnection - Solved IT!

2003-03-31 Thread Marco Rossi
I'm sorry, but i think to have an old release of commons-dbcp.jar, and i don't' find 
the getDelegate() method. It's in org.apache.commons.dbcp.PoolableConnection class??

>In my tomcat common/lib; apparently it is the debug version of Oracle's
>jdbc implentation. Download classes12.zip ( and rename to classes12.jar
>) from Oracle site.
>
>Sundar
>
>-Original Message-
>From: Marco Rossi [mailto:[EMAIL PROTECTED] 
>Sent: Monday, March 31, 2003 11:25 AM
>To: Tomcat Users List
>Subject: RE: Casting DBCP Connection to OracleConnection - Solved IT!
>
>Where do you find ojdbc_g.jar?
>
>>I was using ojdbc_g.jar instead of classes12.zip ( i.e classes12.jar )
>>
>>Sundar
>>
>>-Original Message-
>>From: Chakravarthy, Sundar 
>>Sent: Monday, March 31, 2003 11:11 AM
>>To: Tomcat Users List
>>Subject: RE: Casting DBCP Connection to OracleConnection
>>
>>Strange .. the getDelegate().getClass().getName() returns
>>"oracle.jdbc.driver.OracleConnection" . But the cast fails at runtime.
>>
>>Sundar
>>
>>-Original Message-
>>From: Filip Hanik [mailto:[EMAIL PROTECTED] 
>>Sent: Monday, March 31, 2003 11:05 AM
>>To: Tomcat Users List
>>Subject: RE: Casting DBCP Connection to OracleConnection
>>
>>hi Sundar,
>>as an alternative, why don't you print the class names to know what you
>>are
>>doing
>>
>>for example
>>
>>System.out.println("delegate="+conn.getDelegate().getClass().getName())
>;
>>
>>and do that for all of the things you try to cast, that way you can see
>>what
>>you are accessing before you try to cast it
>>
>>Filip
>>
>>> -Original Message-
>>> From: Chakravarthy, Sundar [mailto:[EMAIL PROTECTED]
>>> Sent: Monday, March 31, 2003 7:57 AM
>>> To: Tomcat Users List
>>> Subject: RE: Casting DBCP Connection to OracleConnection
>>>
>>>
>>>
>>> Run-time failure using both getInnermostDelegate() and getDelegate().
>>> Any other alternatives ?
>>>
>>> -Sundar
>>>
>>> -Original Message-
>>> From: Tim Funk [mailto:[EMAIL PROTECTED]
>>> Sent: Monday, March 31, 2003 10:49 AM
>>> To: Tomcat Users List
>>> Subject: Re: Casting DBCP Connection to OracleConnection
>>>
>>> Compile fail or run-time fail?
>>>
>>> If compile fail - you need a nightly of dbcp.
>>> If run-time fail, you may need to use getInnermostDelegate() instead
>>>
>>> -Tim
>>>
>>> Chakravarthy, Sundar wrote:
>>> > I tried the following with no success,
>>> >
>>> > 1. PoolableConnection pc = (PoolableConnection)conn;
>>> > 2. OracleConnection oc = (OracleConnection)pc.getDelegate();
>>> >
>>> > Fails in line 2
>>> >
>>> > -Sundar
>>> >
>>> >
>>> > -Original Message-
>>> > From: Tim Funk [mailto:[EMAIL PROTECTED]
>>> > Sent: Monday, March 31, 2003 10:34 AM
>>> > To: Tomcat Users List
>>> > Subject: Re: Casting DBCP Connection to OracleConnection
>>> >
>>> > All dbcp objects have a getDelegate() method (I think). But you'll
>>> need
>>> > to do 2 casts.
>>> > - dbcpConn = (DBCPClassCast)conn--> The dbcp connection
>>> > - myOraConn = (OraClassCast)dbcpConn.getDelegate() --> Get the
>>> > underlying implementation
>>> >
>>> > Look at the DBCP javadocs for the correct class names.
>>> >
>>> > BUT you'll need to use a nightly build of dbcp to do this since the
>>> > version shipped with tomcat doesn't have the getDeletgate()
>methods.
>>> >
>>> > -Tim
>>> >
>>> > Marco Rossi wrote:
>>> >
>>> >>I have the same problem. If you find a solution, please reply
>>> >>
>>> >>
>>> >>
>>> >>>HI,
>>> >>>
>>> >>>I am using Tomcat 4.1.18 with Oracle 9i. When I try to cast the
>>> >>>Connection returned from DBCP to OracleConnection I get a
>>> >>>ClassCastException .
>>> >>>
>>> >>>Anyone here know how to cast correctly ?
>>> >>>
>>> >>>Thanks
>>> >>>
>>> >
>>> >
>>> >
>>> >
>>

RE: Casting DBCP Connection to OracleConnection - Solved IT!

2003-04-01 Thread Marco Rossi
Now it's working!!
Thanks guys!

>I'm sorry, but i think to have an old release of commons-dbcp.jar, and i don't' find 
>the getDelegate() method. It's in org.apache.commons.dbcp.PoolableConnection class??
>
>>In my tomcat common/lib; apparently it is the debug version of Oracle's
>>jdbc implentation. Download classes12.zip ( and rename to classes12.jar
>>) from Oracle site.
>>
>>Sundar
>>
>>-Original Message-
>>From: Marco Rossi [mailto:[EMAIL PROTECTED] 
>>Sent: Monday, March 31, 2003 11:25 AM
>>To: Tomcat Users List
>>Subject: RE: Casting DBCP Connection to OracleConnection - Solved IT!
>>
>>Where do you find ojdbc_g.jar?
>>
>>>I was using ojdbc_g.jar instead of classes12.zip ( i.e classes12.jar )
>>>
>>>Sundar
>>>
>>>-Original Message-
>>>From: Chakravarthy, Sundar 
>>>Sent: Monday, March 31, 2003 11:11 AM
>>>To: Tomcat Users List
>>>Subject: RE: Casting DBCP Connection to OracleConnection
>>>
>>>Strange .. the getDelegate().getClass().getName() returns
>>>"oracle.jdbc.driver.OracleConnection" . But the cast fails at runtime.
>>>
>>>Sundar
>>>
>>>-Original Message-
>>>From: Filip Hanik [mailto:[EMAIL PROTECTED] 
>>>Sent: Monday, March 31, 2003 11:05 AM
>>>To: Tomcat Users List
>>>Subject: RE: Casting DBCP Connection to OracleConnection
>>>
>>>hi Sundar,
>>>as an alternative, why don't you print the class names to know what you
>>>are
>>>doing
>>>
>>>for example
>>>
>>>System.out.println("delegate="+conn.getDelegate().getClass().getName())
>>;
>>>
>>>and do that for all of the things you try to cast, that way you can see
>>>what
>>>you are accessing before you try to cast it
>>>
>>>Filip
>>>
>>>> -Original Message-
>>>> From: Chakravarthy, Sundar [mailto:[EMAIL PROTECTED]
>>>> Sent: Monday, March 31, 2003 7:57 AM
>>>> To: Tomcat Users List
>>>> Subject: RE: Casting DBCP Connection to OracleConnection
>>>>
>>>>
>>>>
>>>> Run-time failure using both getInnermostDelegate() and getDelegate().
>>>> Any other alternatives ?
>>>>
>>>> -Sundar
>>>>
>>>> -Original Message-
>>>> From: Tim Funk [mailto:[EMAIL PROTECTED]
>>>> Sent: Monday, March 31, 2003 10:49 AM
>>>> To: Tomcat Users List
>>>> Subject: Re: Casting DBCP Connection to OracleConnection
>>>>
>>>> Compile fail or run-time fail?
>>>>
>>>> If compile fail - you need a nightly of dbcp.
>>>> If run-time fail, you may need to use getInnermostDelegate() instead
>>>>
>>>> -Tim
>>>>
>>>> Chakravarthy, Sundar wrote:
>>>> > I tried the following with no success,
>>>> >
>>>> > 1. PoolableConnection pc = (PoolableConnection)conn;
>>>> > 2. OracleConnection oc = (OracleConnection)pc.getDelegate();
>>>> >
>>>> > Fails in line 2
>>>> >
>>>> > -Sundar
>>>> >
>>>> >
>>>> > -Original Message-
>>>> > From: Tim Funk [mailto:[EMAIL PROTECTED]
>>>> > Sent: Monday, March 31, 2003 10:34 AM
>>>> > To: Tomcat Users List
>>>> > Subject: Re: Casting DBCP Connection to OracleConnection
>>>> >
>>>> > All dbcp objects have a getDelegate() method (I think). But you'll
>>>> need
>>>> > to do 2 casts.
>>>> > - dbcpConn = (DBCPClassCast)conn--> The dbcp connection
>>>> > - myOraConn = (OraClassCast)dbcpConn.getDelegate() --> Get the
>>>> > underlying implementation
>>>> >
>>>> > Look at the DBCP javadocs for the correct class names.
>>>> >
>>>> > BUT you'll need to use a nightly build of dbcp to do this since the
>>>> > version shipped with tomcat doesn't have the getDeletgate()
>>methods.
>>>> >
>>>> > -Tim
>>>> >
>>>> > Marco Rossi wrote:
>>>> >
>>>> >>I have the same problem. If you find a solution, please reply
>>>> >>
>>>> >>
>>>> >>
>>>> >>>HI,
>>>