Re: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread Matthew Kerle
Hi Chris my experience has been: one tomcat instance per dev/test/prod, & the webapp on each instance always points to the same database (dev tomcat->dev db, test tomcat -> test db etc), so the database connection on a /single/ instance never changes. However when promoting code from dev to t

Re: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread Hassan Schroeder
On 8/16/07, Len Popp <[EMAIL PROTECTED]> wrote: > You're right that putting server-specific info in context.xml in the > .war is no good when the app could be installed on different servers. Isn't that what build.properties files are for? :-) -- Hassan Schroeder [EMAIL

Re: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread Len Popp
The reason is that server.xml is for the whole server, so when you change something you have to restart the whole server rather than just the one application. You're right that putting server-specific info in context.xml in the .war is no good when the app could be installed on different servers.

Re: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread David Smith
In my experience, a resource is usually only relevant to one webapp. There's no need to put it in server.xml as a GlobalNamingResource unless you want that resource available in all your webapps. Moving the resource to the block of a context.xml file also makes it so resources can come and g

Re: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Matt, Matthew Kerle wrote: > I never > understood why, and personally doing things that way is a serious pain > for me since it means I need to build a separate deployment descriptor > for dev, test & prod, which means I need to know the prod database

Re: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread Matthew Kerle
ing ashish shrivastava <[EMAIL PROTECTED]>: check this http://evolutionnext.com/blog/2005/10/13/1129259088959.html On 8/16/07, Matthew Kerle <[EMAIL PROTECTED]> wrote: hmm, you have an interesting problem! first thing I'd say is use this opportunity to upgrade to the o

Re: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread Matthew Kerle
Hi David David Smith wrote: My only editorial comment on the page is to NOT place your or definition in server.xml as recommended on the page. Place it in context.xml or myapp.xml as I describe above. Just quickly, I was wondering why you recommend this? I know the tomcat docs have chang

Re: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread David Smith
Hi Ian. ojdbc14.jar needs to ONLY be in common/lib. It won't work in myapp/WEB-INF/lib and won't work if you have the jar in both places. Additionally you should take a look at the JDBC howto docs regarding what your config in your myapp/META-INF/context.xml or conf/Catalina

RE: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread Propes, Barry L
Sent: Thursday, August 16, 2007 10:27 AM To: Tomcat Users List Subject: Re: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12 Thanks for your advice so far I've upgraded to the latest Oracle ojdbc14.jar and placed it the myapp\WEB-INF\lib folder, I also

Re: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread ian . blenk
TECTED]>: > check this > > http://evolutionnext.com/blog/2005/10/13/1129259088959.html > > > > On 8/16/07, Matthew Kerle <[EMAIL PROTECTED]> wrote: > > > > hmm, you have an interesting problem! > > > > first thing I'd say is use this opportu

Re: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread ashish shrivastava
check this http://evolutionnext.com/blog/2005/10/13/1129259088959.html On 8/16/07, Matthew Kerle <[EMAIL PROTECTED]> wrote: > > hmm, you have an interesting problem! > > first thing I'd say is use this opportunity to upgrade to the > ojdbc14.jar, which is the lat

Re: JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread Matthew Kerle
hmm, you have an interesting problem! first thing I'd say is use this opportunity to upgrade to the ojdbc14.jar, which is the latest oracle jdbc driver and allows lots of nice enhancements. second, I'm assuming that since the error is a servlet exception, that there's so

JDBC driver of class '' for connect URL 'null' in Tomcat 5.5.12

2007-08-16 Thread ian . blenk
not create JDBC driver of class '' for connect URL 'null' ". Basically I've included the same details form the Tomcat4 server.xml file into the tomcat 5.5 server.xml, rediting where necessary. Things I have tried.. Placing the context into fragment files located

RE: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle

2007-08-08 Thread Propes, Barry L
yeah, possibly, and my apologies if it appears I hijacked the thread in anywayeven though it's marked OT. -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:35 AM To: Tomcat Users List Subject: Re: [OT] JDBC pr

Re: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle

2007-08-08 Thread Jon Wingfield
From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:13 AM To: Tomcat Users List Subject: Re: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle It's a long time since my last Oracle project ;) The OP was finding milli

RE: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle

2007-08-08 Thread Propes, Barry L
no I think they will, you just have to alter the session's NLS date format, correct? To see them, I mean? -Original Message- From: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:13 AM To: Tomcat Users List Subject: Re: [OT] JDBC pr

Re: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle

2007-08-08 Thread Jon Wingfield
ent: Wednesday, August 08, 2007 4:49 AM To: Tomcat Users List Subject: Re: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle That looks ok. Timestamp is the correct thing to use. You have two systems: one that works, one that doesn't. So, che

RE: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle

2007-08-08 Thread Propes, Barry L
: Jon Wingfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 4:49 AM To: Tomcat Users List Subject: Re: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle That looks ok. Timestamp is the correct thing to use. You have two systems:

Re: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle

2007-08-08 Thread Jon Wingfield
That looks ok. Timestamp is the correct thing to use. You have two systems: one that works, one that doesn't. So, check for differences in the SQL sub-systems between the two: Are the drivers of the same (uptodate) version? Are the database schemas using the same column type? (ie the one that f

Re: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle

2007-08-07 Thread Jose Gargallo
This is the code: java.sql.Timestamp time = new Timestamp(System.currentTimeMillis()); ... pstmt = this.conexion.prepareStatement(INSERT); ... pstmt.setTimestamp(1, time); should I use java.sql.Date instead of java.util.Data? thanks Christopher Schultz escribió: -BEGIN PGP SIGNED MESSAGE--

Re: JDBC problems

2007-08-07 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yazan, Yazan Jber wrote: > I'm having a concurrency problem that seems to be caused by the way > tomcat handles JDBC connections. I'm guessing it's the way your application handles connections, not Tomcat. > My probl

JDBC problems

2007-08-07 Thread Yazan Jber
I'm having a concurrency problem that seems to be caused by the way tomcat handles JDBC connections. My problem happens in a database procedure that is supposed to lock a cretin raw in the database, preventing any other call to the procedure from acuiring the same raw, but this behavior is

Re: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle

2007-08-07 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Barry, Propes, Barry L wrote: > and what date type are you using? sql.date or util.date? I'm pretty sure that's going to be the problem. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http

RE: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle

2007-08-07 Thread Propes, Barry L
and what date type are you using? sql.date or util.date? -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 8:55 AM To: Tomcat Users List Subject: Re: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in

Re: [OT] JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle

2007-08-07 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jose, I marked this as off-topic because it doesn't have anything to do with Tomcat. Tomcat doesn't do anything to your SQL queries, etc. See below. Jose Gargallo wrote: > I have a J2EE application that runs in Oracle and Postgres databases > and OC4

Re: JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle

2007-08-06 Thread Jose Gargallo
I still have te same problem, any help? Jose Gargallo escribió: Hi all, I have a J2EE application that runs in Oracle and Postgres databases and OC4J and Tomcat servers. I've got a problem using the PreparedStatement.setTimestamp function runing TOMCAT 5.5 + Oracle 9i becouse it ignores the m

JDBC problem: PreparedStatement.setTimestamp function ignores milliseconds in TOMCAT + ddbb Oracle

2007-08-03 Thread Jose Gargallo
Hi all, I have a J2EE application that runs in Oracle and Postgres databases and OC4J and Tomcat servers. I've got a problem using the PreparedStatement.setTimestamp function runing TOMCAT 5.5 + Oracle 9i becouse it ignores the milliseconds. It works fine runing in OC4J 10.1.3 and Oracle 9i.

RE: Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-29 Thread Leonardo Augusto
=true See you! -Original Message- From: daniel steel [mailto:[EMAIL PROTECTED] Sent: sexta-feira, 29 de junho de 2007 14:55 To: Tomcat Users List Subject: Re: Update Tomcat 5 -> 6 .. JDBC driver problem if we configure the

Re: Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-29 Thread daniel steel
#x27;s good info, but only barely related to the question at hand and they said they had it working in tomcat 5.5.23 -- just failing in tomcat 6. Given it works in one version of tomcat and not another, I highly doubt the mysql jdbc url is at fault. The OP needs to post portions of their co

Re: Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-29 Thread David Smith
That's good info, but only barely related to the question at hand and they said they had it working in tomcat 5.5.23 -- just failing in tomcat 6. Given it works in one version of tomcat and not another, I highly doubt the mysql jdbc url is at fault. The OP needs to post portions of

Re: Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-29 Thread Martin Gainty
MySQL Connector/J doc says "The JDBC URL format for MySQL Connector/J is as follows, with items in square brackets ([, ]) being optional: jdbc:mysql://[host][,failoverhost...][:port]/[database] » [?propertyName1][=propertyValue1][&propertyName2][=propertyValue2]... If the hostna

Re: Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-29 Thread gregory hans
i using tomcat6 right now and i put my jdbc in my lib directory and that's okay. can you post your error to me so i can figure what's going on. David Smith <[EMAIL PROTECTED]> wrote: In tomcat 6, the new common/lib is simply lib as I understand it. Could you post your confi

Re: Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-28 Thread Jon Wilmoth
AIL PROTECTED]> To: Tomcat Users List Sent: Thursday, June 28, 2007 5:29:11 AM Subject: Re: Update Tomcat 5 -> 6 .. JDBC driver problem In tomcat 6, the new common/lib is simply lib as I understand it. Could you post your config? The error you originally posted typically indicates a

Re: Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-28 Thread David Smith
x.x/lib* will be just fine. 2007/6/28, Rene Guenther <[EMAIL PROTECTED]>: Thanks for your reply. Unfortunately I am still getting the same error with tomcat 6.0.13 Regards René On Thu, 28 Jun 2007 02:34:10 -0700 (PDT) gregory hans <[EMAIL PROTECTED]> wrote: > try to put your jdb

Re: Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-28 Thread Omar de Carvalho
Hi Rene, I have problems in the past with tomcat and jdbc driver assigned as zip file and not jar. Outside tomcat I could open classe12.zip driver and inside tomcat not. Mind in the name of your driver... Regards, Omar Neto Rene Guenther <[EMAIL PROTECTED]> wrote:

Re: Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-28 Thread Rene Guenther
PROTECTED]> wrote: > try to put your jdbc in your web application >(WEB-INF/LIB/). stop the service first, put the jdbc then >start again... > > Rene Guenther <[EMAIL PROTECTED]> wrote: >Hello, > > I am getting the following exception with tomcat 6.0.13: > &g

Re: Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-28 Thread Allen 孙
PROTECTED]> wrote: > try to put your jdbc in your web application >(WEB-INF/LIB/). stop the service first, put the jdbc then >start again... > > Rene Guenther <[EMAIL PROTECTED]> wrote: >Hello, > > I am getting the following exception with tomcat 6.0.13: > > Canno

Re: Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-28 Thread Rene Guenther
Thanks for your reply. Unfortunately I am still getting the same error with tomcat 6.0.13 Regards René On Thu, 28 Jun 2007 02:34:10 -0700 (PDT) gregory hans <[EMAIL PROTECTED]> wrote: try to put your jdbc in your web application (WEB-INF/LIB/). stop the service first, put the jdb

Re: Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-28 Thread gregory hans
try to put your jdbc in your web application (WEB-INF/LIB/). stop the service first, put the jdbc then start again... Rene Guenther <[EMAIL PROTECTED]> wrote: Hello, I am getting the following exception with tomcat 6.0.13: Cannot create JDBC driver of class '' for connect U

Update Tomcat 5 -> 6 .. JDBC driver problem

2007-06-28 Thread Rene Guenther
Hello, I am getting the following exception with tomcat 6.0.13: Cannot create JDBC driver of class '' for connect URL 'null' This exception I dont get with tomcat 5.5.23 I put the mysql jdbc driver (version 5.x) into apache-tomcat-x.x.x/common/lib Anyone knows what

Re: Tomcat 6.0.10 DataSourceRealm says "Name jdbc is not bound in this Context"

2007-06-19 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael, Michael Wesner wrote: > I am sure someone has run across this before. I appreciate any help or > pointers to other threads about this. Ooh! So close... What you are looking for is documented on this page (and unfortunately nowhere else, AF

Tomcat 6.0.10 DataSourceRealm says "Name jdbc is not bound in this Context"

2007-06-19 Thread Michael Wesner
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context What am I doing wrong? I have a default server.xml. I configure everything using META- INF/context.xml and WEB-INF/web.xml context.xml: antiJARLocking="true"> web.xml: (has other things, but here is

RE: Tomcat 6, SQL Server 2005 JDBC Realm not working

2007-06-14 Thread Propes, Barry L
so in one connection string you have user and in the Realm you're using userName? -Original Message- From: Richard Sayre [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 13, 2007 12:42 PM To: users@tomcat.apache.org Subject: Tomcat 6, SQL Server 2005 JDBC Realm not working I have

Re: Tomcat 6, SQL Server 2005 JDBC Realm not working

2007-06-14 Thread Richard Sayre
It turns out I had to RTFM. "Quick Start: 3. Place a copy of the JDBC driver you will be using inside the $CATALINA_HOME/lib directory. Note that only JAR files are recognized!" I only had it in my Web App lib folder On 6/14/07, Richard Sayre <[EMAIL PROTECTED]> wrote:

Re: Tomcat 6, SQL Server 2005 JDBC Realm not working

2007-06-14 Thread Richard Sayre
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) Did anything change in Tomcat 6 for setting up JDBC Realms? I am putting this in the server xml. On 6/13/07, Richard Sayre <[EMAIL PROTECTED]> wrote: I have a web app that connects

Tomcat 6, SQL Server 2005 JDBC Realm not working

2007-06-13 Thread Richard Sayre
ealm works: Does any one have this type of authentication working with MS SQL Server 2005 JDBC driver under Tomcat 6? Thank you, Rich - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTE

Re: Cannot create JDBC driver of class '' for connect URL 'null'

2007-06-05 Thread Foo Shyn
error: Jun 6, 2007 9:36:31 AM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet Faces Servlet threw exception com.sun.rave.web.ui.appbase.ApplicationException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class ''

Re: Cannot create JDBC driver of class '' for connect URL 'null'

2007-06-05 Thread Pranav
() for servlet Faces Servlet threw exception com.sun.rave.web.ui.appbase.ApplicationException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.cleanup(View

Re: Cannot create JDBC driver of class '' for connect URL 'null'

2007-06-05 Thread Martin Gainty
ject: Ref: Cannot create JDBC driver of class '' for connect URL 'null' Hi, I am running an application using tomcat5.x and getting following error: The error log is as follows: Jun 5, 2007 7:12:31 PM org.apache.catalina.core.ApplicationContext log SEVERE: AdminAcct Initi

Re: Ref: Cannot create JDBC driver of class '' for connect URL 'null'

2007-06-05 Thread David Smith
Additionally the tomcat website has some excellent docs on how to set this up. I would refer to those docs for your specific version of tomcat (5.0.x or 5.5.x) --David Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pranav, Pranav wrote: I am running an applic

Re: Ref: Cannot create JDBC driver of class '' for connect URL 'null'

2007-06-05 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pranav, Pranav wrote: > I am running an application using tomcat5.x and getting following error: [snip] > I would appreciate if any one could help me with this. I running the > application using Netbeans 5.5 and have setup the MySql and made the > c

Ref: Cannot create JDBC driver of class '' for connect URL 'null'

2007-06-05 Thread Pranav
: Cannot create JDBC driver of class '' for connect URL 'null' at com.sun.rave.faces.data.CachedRowSetDataModel.executeIfNecessary(CachedRowSetDataModel.java:374) at com.sun.rave.faces.data.CachedRowSetDataModel.isRowAvailable(CachedRowSetDataModel

Re: Strange MySQL-Behaviour with JDBC-Realm

2007-06-04 Thread David Smith
nnoDB), OS is Debian. Tomcat authentication is done via a JDBC-Realm. Every now and then FormAuthenticator is throwing the following Exception: 2007-06-04 01:41:02,762 ERROR localSearch.log [TP-Processor2]:Exception perfo

Re: Strange MySQL-Behaviour with JDBC-Realm

2007-06-04 Thread Gregor Schneider
Hi David, will give that a try. If the exception persists, I'll go for autoreconnect, will report here. Cheers Gregor -- what's puzzlin' you, is the nature of my game gpgp-fp: 79A84FA526807026795E4209D3B3FE028B3170B2 gpgp-key available @ http://pgpkeys.pca.dfn.de:11371

RE: Strange MySQL-Behaviour with JDBC-Realm

2007-06-04 Thread David Short
: Monday, June 04, 2007 1:17 AM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: Strange MySQL-Behaviour with JDBC-Realm Hi David, from http://dev.mysql.com/doc/refman/4.1/en/connector-j-reference-configuration-p roperties.html: [snipp]= If the hostname is not specified

Re: Strange MySQL-Behaviour with JDBC-Realm

2007-06-04 Thread Gregor Schneider
Hi David, from http://dev.mysql.com/doc/refman/4.1/en/connector-j-reference-configuration-properties.html: [snipp]= If the hostname is not specified, it defaults to 127.0.0.1. If the port is not specified, it defaults to 3306, the default port number for MySQL servers. =

RE: Strange MySQL-Behaviour with JDBC-Realm

2007-06-04 Thread David Short
PROTECTED] Sent: Monday, June 04, 2007 12:52 AM To: Tomcat Users List Subject: Strange MySQL-Behaviour with JDBC-Realm Hi guys, we're running Tomcta 5.5 and MySQL 5 (InnoDB), OS is Debian. Tomcat authentication is done via a JDBC-Realm. Every now and then FormAuthenticator is throwin

Strange MySQL-Behaviour with JDBC-Realm

2007-06-04 Thread Gregor Schneider
Hi guys, we're running Tomcta 5.5 and MySQL 5 (InnoDB), OS is Debian. Tomcat authentication is done via a JDBC-Realm. Every now and then FormAuthenticator is throwing the following Exception: 2007-06-04 01:41:02,762 ERROR localSearch.log [TP-Processor2]:Exception perfo

RE: JDBC resource with custom connection pool factory

2007-05-30 Thread Propes, Barry L
do you mean like the amount of users per a pool connection instance? I think you're stuck with configuration inside the WEB-INF level per app. -Original Message- From: Sorin Juco [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 30, 2007 2:41 AM To: users@tomcat.apache.org Subject:

Re: JDBC resource with custom connection pool factory

2007-05-30 Thread Zdeněk Vráblík
factory, so maybe u can write a wrapper around Connection.close() method. - Original Message From: Sorin Juco <[EMAIL PROTECTED]> To: users@tomcat.apache.org Sent: Wednesday, May 30, 2007 1:11:18 PM Subject: JDBC resource with custom connection pool factory Hello, I want to creat

Re: JDBC resource with custom connection pool factory

2007-05-30 Thread Sorin Juco
Thanx for the answers. I just realized that what I want to do is more complex. I use Hibernate and pass the jdbc resource to the Hibernate configuration. Oracle has a temporary table for each session to the database in which you can store 2 varchar arguments for monitoring purposes ( in my case

Re: JDBC resource with custom connection pool factory

2007-05-30 Thread ROOKIE
: Sorin Juco <[EMAIL PROTECTED]> To: users@tomcat.apache.org Sent: Wednesday, May 30, 2007 1:11:18 PM Subject: JDBC resource with custom connection pool factory Hello, I want to create a JDBC resource wich represents a connection pool to an Oracle server. By default Tomcat uses DBCP to provi

Re: JDBC resource with custom connection pool factory

2007-05-30 Thread Zdeněk Vráblík
Hi, I use this Resource: There is OracleDataSourceFactory in ojdbc14.jar. Regards, Zdenek On 5/30/07, Sorin Juco <[EMAIL PROTECTED]> wrote: Hello, I want to create a JDBC resource wich represents a connection pool to an Oracle server. By default Tomcat uses DBCP to provide the conn

JDBC resource with custom connection pool factory

2007-05-30 Thread Sorin Juco
Hello, I want to create a JDBC resource wich represents a connection pool to an Oracle server. By default Tomcat uses DBCP to provide the connection pool implementation. My problem is that I want to execute some custom code each time I get a connection from the pool and also each time I release

RE: JDBC

2007-05-22 Thread Propes, Barry L
Mohammed, for driver value, try the following: oracle.jdbc.OracleDriver -Original Message- From: Mohammed Zabin [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 22, 2007 4:33 AM To: Tomcat Users List Subject: Re: JDBC Thank you Foo for your patience with me, I did imported all the needed

Re: JDBC

2007-05-22 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pid, Pid wrote: > As the previous reply pointed out, your Resource is incorrectly named > 'Name' when it should be 'jdbc/myoracledb'. Unfortunately, someone gave him a bad example, so he didn't have a chance :( - -

Re: JDBC

2007-05-22 Thread Pid
out, your Resource is incorrectly named 'Name' when it should be 'jdbc/myoracledb'. FYI: conf/server.xml - configures hosts & server conf/web.xml - configures application environment(& more) conf/context.xml - configures default Context attributes your

Re: JDBC

2007-05-22 Thread Mohammed Zabin
envContext = (Context)initContext.lookup("java:/comp/env"); 6: DataSource ds = (DataSource)envContext.lookup("jdbc/myoracledb"); 7: Connection conn = ds.getConnection(); 8: 9: out.println( "The Connection Gotted Fin

Re: JDBC

2007-05-22 Thread Foo Shyn
DataSource)envContext.lookup("jdbc/myoracledb"); 7: Connection conn = ds.getConnection(); 8: 9: out.println( "The Connection Gotted Fine" ); 10: %> Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:515) org.apache.jasper.

Re: JDBC

2007-05-22 Thread Mohammed Zabin
: Context envContext = (Context)initContext.lookup("java:/comp/env"); 6: DataSource ds = (DataSource)envContext.lookup("jdbc/myoracledb"); 7: Connection conn = ds.getConnection(); 8: 9: out.println( "The Connection Gotted Fin

Re: JDBC

2007-05-22 Thread Foo Shyn
ql.DataSource" %>* *<% Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup("java:/comp/env"); DataSource ds = (DataSource)envContext.lookup("jdbc/myoracledb"); Connection conn = ds.getConnection(); out.println( "Got the c

Re: JDBC

2007-05-22 Thread Mohammed Zabin
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracledb"); Connection conn = ds.getConnection(); out.println( "Got the connection" ); %>* but, i got the following error: *org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 4 in the js

Re: JDBC

2007-05-22 Thread Foo Shyn
Not both of them. It's context.xml if u're using Tomcat 5.0 or above, or server.xml if u're using Tomcat 4.1 or below, which is located in the conf folder in Tomcat root path. check this link out : http://forums.oracle.com/forums/thread.jspa?messageID=1489914 Hope that helps. FooShyn Mohammed

Re: JDBC

2007-05-22 Thread Mohammed Zabin
taSource ds = (DataSource) ctxt.lookup("java:/comp/env/" + poolName); OracleConnection conn = ds.getConnection(); There is used another datasource type in OC4J http://www.oracle.com/technology/sample_code/tech/java/codesnippet/j2ee/jdbc/JDBC_in_J2EE.html Regards, Zdenek On 5/22/07, M

Re: JDBC

2007-05-22 Thread Mohammed Zabin
Thank you buddy, I have another confusing question for me, I have two web.xml files, one in conf/web.xml and one in my application under WEB-INF, When configuring connection pool, which one shall i use? or shall i put the configuration parameters in both of them?? Thank you On 5/22/07, ben shor

Re: JDBC

2007-05-22 Thread Zdeněk Vráblík
OC4J http://www.oracle.com/technology/sample_code/tech/java/codesnippet/j2ee/jdbc/JDBC_in_J2EE.html Regards, Zdenek On 5/22/07, Mohammed Zabin <[EMAIL PROTECTED]> wrote: Hi All Am new on this, i want to know how to configure Database Connection Pooling to use Oracle Database?? anyhelp will be apprec

Re: JDBC

2007-05-22 Thread ben short
Have a look here.. http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html On 5/22/07, Mohammed Zabin <[EMAIL PROTECTED]> wrote: Hi All Am new on this, i want to know how to configure Database Connection Pooling to use Oracle Database?? anyhelp will be appreciated. Jotnart

JDBC

2007-05-22 Thread Mohammed Zabin
Hi All Am new on this, i want to know how to configure Database Connection Pooling to use Oracle Database?? anyhelp will be appreciated. Jotnarta

RE: Oracle JDBC connection Tomcat 5.5

2007-05-21 Thread Propes, Barry L
well, I had to actually switch jars for my Oracle driver to work properly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Zdenek Vráblík Sent: Wednesday, May 16, 2007 7:19 AM To: Tomcat Users List Subject: Re: Oracle JDBC connection Tomcat 5.5 Hi all

Re: Oracle JDBC connection Tomcat 5.5

2007-05-16 Thread Zdeněk Vráblík
Hi all thanks for help, There is problem in admin web application id doesn't show oracle datasources. I expected to see this datasource as other datasources in this admin console (localhost:8080/admin). I tried to use that pool and it works ... The ojdbc14_g.jar is same as ojdbc14.jar but has

RE: Oracle JDBC connection Tomcat 5.5

2007-05-15 Thread Propes, Barry L
Hi Rashmi, thans for reply. I think that ojdbc14.jar is newer version of oracle drivers and it works fine with standard datasource factory org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory and javax.sql.DataSource. It stops work when I use oracle datasource factory factory="oracle.jdbc.pool

RE: Oracle JDBC connection Tomcat 5.5

2007-05-15 Thread Propes, Barry L
to me, as Oracle had taken it off their site...at least not had it in a place where a user could at all easily find it! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Zdenek Vráblík Sent: Friday, May 11, 2007 12:42 PM To: users@tomcat.apache.org Subject: O

Re: Oracle JDBC connection Tomcat 5.5

2007-05-14 Thread Martin Gainty
ist" ; "Martin Gainty" <[EMAIL PROTECTED]> Sent: Monday, May 14, 2007 6:57 AM Subject: Re: Oracle JDBC connection Tomcat 5.5 Hi Martin, thanks for help. I have tried your suggestion and it works fine - I am able to get OracleConnection. (I had to change String c_sUserNameKey=

Re: Oracle JDBC connection Tomcat 5.5

2007-05-14 Thread Zdeněk Vráblík
here is resource JDBC configuration which works for Tomcat 5.5.23 When is set accessToUnderlyingConnectionAllowed to true DataSource produce connection which implement DelegatingConnection interface. DataSource ds = (DataSource) ctxt.lookup(poolName); conn = ds.getConnection();

Re: Oracle JDBC connection Tomcat 5.5

2007-05-14 Thread Zdeněk Vráblík
Hi Martin, I have solution. There is resource JDBC configuration which works for Tomcat 5.5.23 When is set accessToUnderlyingConnectionAllowed to true DataSource produce connection which implement DelegatingConnection interface. DataSource ds = (DataSource) ctxt.lookup(poolName); conn

Re: Oracle JDBC connection Tomcat 5.5

2007-05-14 Thread Zdeněk Vráblík
Hi Martin, thanks for help. I have tried your suggestion and it works fine - I am able to get OracleConnection. (I had to change String c_sUserNameKey="username"; to String c_sUserNameKey="user";) It works for common Connection, but I need OracleConnection interface. jdbc

Re: Oracle JDBC connection Tomcat 5.5

2007-05-13 Thread Martin Gainty
- Original Message - From: "Rashmi Rubdi" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Sunday, May 13, 2007 3:23 PM Subject: Re: Oracle JDBC connection Tomcat 5.5 On 5/12/07, Zdeněk Vráblík <[EMAIL PROTECTED]> wrote: Hi Rashmi, thans for reply.

Re: Oracle JDBC connection Tomcat 5.5

2007-05-13 Thread Rashmi Rubdi
On 5/12/07, Zdeněk Vráblík <[EMAIL PROTECTED]> wrote: Hi Rashmi, thans for reply. Configuration that is described in link you sent me works fine. Problem is when I change the datasource factory to Oracle datasource factory. Than is not possible to find this datasource through JNDI lookup and th

Re: Oracle JDBC connection Tomcat 5.5

2007-05-12 Thread Zdeněk Vráblík
Vráblík <[EMAIL PROTECTED]> wrote: > Hi all, > > I am configuring jdbc datasources on Tomcat 5.5.23. > > I followed this document to configure orcle database with Tomcat > http://www.microdeveloper.com/html/JNDI_Orcl_Tomcat1p.html Sorry I didn't go through the instructi

Re: Oracle JDBC connection Tomcat 5.5

2007-05-12 Thread Rashmi Rubdi
On 5/11/07, Zdeněk Vráblík <[EMAIL PROTECTED]> wrote: Hi all, I am configuring jdbc datasources on Tomcat 5.5.23. I followed this document to configure orcle database with Tomcat http://www.microdeveloper.com/html/JNDI_Orcl_Tomcat1p.html Sorry I didn't go through the instruct

Oracle JDBC connection Tomcat 5.5

2007-05-11 Thread Zdeněk Vráblík
Hi all, I am configuring jdbc datasources on Tomcat 5.5.23. I followed this document to configure orcle database with Tomcat http://www.microdeveloper.com/html/JNDI_Orcl_Tomcat1p.html I am not able to see datasource in web admin. datasource configuration: Everything works fine with this

Re: Can't create jdbc resource in context.xml

2007-04-25 Thread Martin Gainty
sender immediately by telephone or email and destroy the original message without making a copy. Thank you. - Original Message - From: "Glen Vermeylen" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Wednesday, April 25, 2007 10:07 AM Subject: Re: Can't crea

Re: Can't create jdbc resource in context.xml

2007-04-25 Thread Glen Vermeylen
It also doesn't work with the resource-ref element. The error was "" javax.naming.NameNotFoundException: Name jdbc is not bound in this Context"", but I was able to lookup the jdbc/sandwiches datasource using programmatic jndi lookup. Weird part is that everything

Re: Can't create jdbc resource in context.xml

2007-04-23 Thread Rashmi Rubdi
Hello everybody, I'm trying to move a global jdbc resource out of server.xml so it is application specific. Following is the server.xml (which works fine) . What I did was remove the the and elements from server.xml and put them inside $CATALINA_HOME/co

Re: Can't create jdbc resource in context.xml

2007-04-23 Thread Glen Vermeylen
Thanks for the response, We use tomcat 5.5. -Glen 2007/4/20, Rashmi Rubdi <[EMAIL PROTECTED]>: Hello Glen, What is the version of Tomcat? I'm asking for the version because the JNDI Datasource configuration is different for different version of Tomcat. The one for 4.x is different from the o

Re: Can't create jdbc resource in context.xml

2007-04-20 Thread Rashmi Rubdi
Hello Glen, What is the version of Tomcat? I'm asking for the version because the JNDI Datasource configuration is different for different version of Tomcat. The one for 4.x is different from the one for 6.x for example. -Rashmi --

Can't create jdbc resource in context.xml

2007-04-20 Thread Glen Vermeylen
Hello everybody, I'm trying to move a global jdbc resource out of server.xml so it is application specific. Following is the server.xml (which works fine) What I did was remov

Re: install DBCP and mm.mysql 2.0.14 (JDBC Driver) and test app, get class compile error.

2007-03-06 Thread David Smith
There's no reason I know of to have .classpath or .project in the webapp. The servlet spec doesn't define them and tomcat doesn't use them. I would imagine these are specific to the development environment you are working in. I've seen posts from other people integrating PHP with Tomcat, but don

Re: install DBCP and mm.mysql 2.0.14 (JDBC Driver) and a test app, getting class compile error

2007-03-05 Thread Andre Prasetya
mmm i think its a syntax error at test.jsp see line 7 foo.DBTest On 3/5/07, Wayne Bragg <[EMAIL PROTECTED]> wrote: I am trying to install DBCP and mm.mysql 2.0.14 (JDBC Driver) and a test app to see if it works. I'm not sure I have all the correct steps and configuration, in ot

Re: install DBCP and mm.mysql 2.0.14 (JDBC Driver) and test app, get class compile error.

2007-03-05 Thread Wayne Bragg
x27;t thank you enough for what you have already done! - Original Message - From: "David Smith" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Monday, March 05, 2007 1:36 PM Subject: Re: install DBCP and mm.mysql 2.0.14 (JDBC Driver) and test app, get class c

<    9   10   11   12   13   14   15   16   17   >