Re: FB JDBC version?

2024-08-23 Thread OCsite via Webobjects-dev
itely OK. Alas, the bloody Java ignores the classpath and happily loads the JDBC driver from java.ext.dirs, regardless the classpath path :( Thanks, OC > > From: o...@ocs.cz > Sent: Friday, August 23, 2024 6:20 AM > To: Ramsey Gurley ; WebObjects-Dev List > > Subject: Re: F

Re: FB JDBC version?

2024-08-23 Thread Ramsey Gurley via Webobjects-dev
e: FB JDBC version? Ramsey, looks like you are again right. Meantime I've investigated, and it looks like - the bloody Java, despite having an explicit path to the proper driver on classpath (I've checked in runtime logs, it's OK), still ignores it and loads another driver from ja

Re: FB JDBC version?

2024-08-23 Thread ocs--- via Webobjects-dev
OC > On 22. 8. 2024, at 22:51, Ramsey Gurley > wrote: > > Are you sure you don't have more than one jdbc jar floating around in your > application build path? With ant, I forget how it determines which jar wins. > With maven, you can just open the pom.xml in eclipse a

Re: FB JDBC version?

2024-08-23 Thread ocs--- via Webobjects-dev
Jesse, I might be wrong, but I understand this is not the driver version, but a JDBC compatibility level or something like that. Anyway, the FrontBase driver version is three-part (like 2.5.10), not just major.minor. Thanks! OC > On 22. 8. 2024, at 22:48, Jesse Tayler wrote: > > I

Re: FB JDBC version?

2024-08-22 Thread Ramsey Gurley via Webobjects-dev
Are you sure you don't have more than one jdbc jar floating around in your application build path? With ant, I forget how it determines which jar wins. With maven, you can just open the pom.xml in eclipse and check in the Dependency Hierarchy tab. From: O

Re: FB JDBC version?

2024-08-22 Thread Jesse Tayler via Webobjects-dev
at 3:54 PM, OCsite via Webobjects-dev > wrote: > > Hi there, > > how does one properly determine the current FB JDBC driver version? > > Lately we were not sure whether all our installations contain the newest > release, and thus I've added a code to log out the versio

FB JDBC version?

2024-08-22 Thread OCsite via Webobjects-dev
Hi there, how does one properly determine the current FB JDBC driver version? Lately we were not sure whether all our installations contain the newest release, and thus I've added a code to log out the version. The code I've found — is there another, better, and more reliable varian

Re: move to mysql 8 on Catalina jdbc Incorrect DATE value: '??’

2020-11-09 Thread John Pollard via Webobjects-dev
grab of it was in 2015! I have been scared to touch it. Obviously it is a concern that the latest mysql jdbc connector has this problem and I would be interested to know whether anyone else had tried 8.0.22 with success. For now I can work with the 8.0.19 version. Thanks John > On 9 Nov 2

move to mysql 8 on Catalina jdbc Incorrect DATE value: '??’

2020-11-09 Thread John Pollard via Webobjects-dev
Hello WO list, I upgraded my Mac to Catalina and found mysql 5 no longer ran, so installed mysql 8 I switched to the latest mysql-connector-java-8.0.22.jar I note the following error when I run an application: Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is

Re: JDBC adaptor on RHEL 7 - Solved

2018-08-20 Thread Valerio Luccio
On 08/20/2018 01:06 PM, Paul Yu wrote: > Valerio > > If you have the PlugIn framework in your project and you are building > Embedded applications, then you don’t have to install anything in RHEL. > > Paul Hi Paul, mine is a web application that I run and manage via the javamonitor. I don't hav

Re: JDBC adaptor on RHEL 7

2018-08-20 Thread Valerio Luccio
On 08/19/2018 11:35 PM, Steve Peery wrote: > Do you have a connection library included in the application? Even if > you are using a framework like MySQLPlugIn, you still a connection > library (https://dev.mysql.com/downloads/connector/) in the application . What do you know, I thought I had in

Re: JDBC adaptor on RHEL 7

2018-08-19 Thread Steve Peery
Do you have a connection library included in the application? Even if you are using a framework like MySQLPlugIn, you still a connection library (https://dev.mysql.com/downloads/connector/) in the application . > On Aug 19, 2018, at 10:33 PM, Michael Kondratov > wrote: > > Is the app runnin

Re: JDBC adaptor on RHEL 7

2018-08-19 Thread Michael Kondratov
Is the app running on the same machine as the database? Are the frameworks installed? Are you using mysql plugin? Michael > On Aug 19, 2018, at 8:51 PM, Valerio Luccio wrote: > > On 8/19/18 5:00 PM, Michael Kondratov wrote: > >> It appears as your application can’t actually connect to mysql

Re: JDBC adaptor on RHEL 7

2018-08-19 Thread Valerio Luccio
On 8/19/18 5:00 PM, Michael Kondratov wrote: It appears as your application can’t actually connect to mysql server. Double check any port/ ip / firewall issues first. Michael That was the first thing I did, I turned off the firewall. In any case I have no problem connecting to the database

Re: JDBC adaptor on RHEL 7

2018-08-19 Thread Michael Kondratov
It appears as your application can’t actually connect to mysql server. Double check any port/ ip / firewall issues first. Michael > On Aug 19, 2018, at 4:29 PM, Valerio Luccio wrote: > > On 8/19/18 12:46 PM, Michael Kondratov wrote: > >> Valerio, >> What sort of error are you getting? W

Re: JDBC adaptor on RHEL 7

2018-08-19 Thread Valerio Luccio
On 8/19/18 12:46 PM, Michael Kondratov wrote: Valerio, What sort of error are you getting? What DB are you connecting to? Michael Thanks for your reply Michael. So, this is an out-of-the-box MariaDB installation: $ mysql -V mysql Ver 14.14 Distrib 5.5.39, for Linux (x86_64) using rea

Re: JDBC adaptor on RHEL 7

2018-08-19 Thread Michael Kondratov
Valerio, What sort of error are you getting? What DB are you connecting to? Michael > On Aug 19, 2018, at 1:49 AM, Valerio Luccio wrote: > > Hi all, > > I'm deploying an application on a RHEL 7 server. I seem to be having a > problem opening a channel to the database. Running the sam

JDBC adaptor on RHEL 7

2018-08-18 Thread Valerio Luccio
Hi all, I'm deploying an application on a RHEL 7 server. I seem to be having a problem opening a channel to the database. Running the same application on my MacBook I can connect to the database on the server. Is there an issue using the JavaJDBCadaptor on RHEL 7 ? Should I switch to the mari

Re: Question about jdbc connection pool

2016-06-08 Thread Tarun Reddy
JVMs? Or should I really be using another application framework? > > Tarun > > > > On Jun 6, 2016, at 11:48 AM, Chuck Hill wrote: > > I am pretty sure that maps to the ServerSocket’s backlog: “requested > maximum length of the queue of incoming connections” > > >

Re: Question about jdbc connection pool

2016-06-07 Thread Samuel Pelletier
connections” >> >> >> From: > <mailto:webobjects-dev-bounces+chill=gevityinc@lists.apple.com>> on >> behalf of Ramsey Gurley > <mailto:rgur...@smarthealth.com>> >> Date: Monday, June 6, 2016 at 10:44 AM >> To: Leigh Kivenko ma

Re: Question about jdbc connection pool

2016-06-07 Thread Musall Maik
> Am 07.06.2016 um 02:04 schrieb Ramsey Gurley : > > The main reason there’s a single connection and a global lock is to permit > snapshotting. This snapshot cache is central to Apple’s ORM design. AFAIK, if > you open 12 connections to the db, you’re still going to be stuck waiting on > synch

Re: Question about jdbc connection pool

2016-06-06 Thread Ken Anderson
hat maps to the ServerSocket’s backlog: “requested maximum >> length of the queue of incoming connections” >> >> >> From: on behalf >> of Ramsey Gurley >> Date: Monday, June 6, 2016 at 10:44 AM >> To: Leigh Kivenko >> Cc: WebObjects-Dev &

Re: Question about jdbc connection pool

2016-06-06 Thread Pascal Robert
; JVMs? > > > You don’t need multiple VMs to run multiple WO app instances. monitor is not > like tomcat, it can run more than one instance of the same app. Each > application instance gets its own jdbc connection. You can create as many > instances as memory will allow

Re: Question about jdbc connection pool

2016-06-06 Thread Ramsey Gurley
not like tomcat, it can run more than one instance of the same app. Each application instance gets its own jdbc connection. You can create as many instances as memory will allow. In each instance, one OSC is the default. EOObjectStoreCoordinator.defaultObjectStore(). You can create as many OSCs a

Re: Question about jdbc connection pool

2016-06-06 Thread Tarun Reddy
etty sure that maps to the ServerSocket’s backlog: “requested maximum > length of the queue of incoming connections” > > > From: on behalf > of Ramsey Gurley > Date: Monday, June 6, 2016 at 10:44 AM > To: Leigh Kivenko > Cc: WebObjects-Dev > Subject: Re: Question

Re: Question about jdbc connection pool

2016-06-06 Thread Chuck Hill
I am pretty sure that maps to the ServerSocket’s backlog: “requested maximum length of the queue of incoming connections” From: on behalf of Ramsey Gurley Date: Monday, June 6, 2016 at 10:44 AM To: Leigh Kivenko Cc: WebObjects-Dev Subject: Re: Question about jdbc connection pool Off the

Re: Question about jdbc connection pool

2016-06-06 Thread Ramsey Gurley
(by return e-mail or otherwise), and delete the e-mail. > > From: Ramsey Gurley [mailto:rgur...@smarthealth.com] > Sent: Monday, June 06, 2016 12:52 PM > To: Leigh Kivenko > Cc: webobjects-dev@lists.apple.com > Subject: Re: Question about jdbc connection pool > > Yes, one

Re: Question about jdbc connection pool

2016-06-06 Thread Chuck Hill
Gurley Cc: "webobjects-dev@lists.apple.com" Subject: RE: Question about jdbc connection pool Thanks Ramsey. Does that mean there is only 1 database connection shared by all end-users of an app? So if a user hits a query that runs for 3+ seconds all other application users are stuck waitin

Re: Question about jdbc connection pool

2016-06-06 Thread Ramsey Gurley
Sent: Monday, June 06, 2016 12:18 PM > To: Leigh Kivenko > Cc: webobjects-dev@lists.apple.com > Subject: Re: Question about jdbc connection pool > > The ObjectStoreCoordinator opens one connection which everything shares by > default. If you want multiple connections, you have to c

RE: Question about jdbc connection pool

2016-06-06 Thread Leigh Kivenko
es+dev=portfolioaid@lists.apple.com [mailto:webobjects-dev-bounces+dev=portfolioaid@lists.apple.com] On Behalf Of Ramsey Gurley Sent: Monday, June 06, 2016 12:18 PM To: Leigh Kivenko Cc: webobjects-dev@lists.apple.com Subject: Re: Question about jdbc connection pool The ObjectStoreCoord

Re: Question about jdbc connection pool

2016-06-06 Thread Ramsey Gurley
et the jdbc connection pool size? Is there a default if this > isn’t specifically set? > > Thanks, > > Leigh Kivenko | VP, Technology > PortfolioAid > t. 416-479-0523 | e. lei...@portfolioaid.com > > This e-mail may be privileged and confidential. If you received t

Question about jdbc connection pool

2016-06-06 Thread Leigh Kivenko
Hello, How does one set the jdbc connection pool size? Is there a default if this isn't specifically set? Thanks, Leigh Kivenko | VP, Technology PortfolioAid t. 416-479-0523 | e. lei...@portfolioaid.com<mailto:lei...@portfolioaid.com> This e-mail may be privileged and confident

Re: Can I force a reload of a database's JDBC info?

2016-03-04 Thread Paul Hoadley
t would seem to be getting the JDBC info from the database each time, because after the Ident migration in which we add the CITEXT extension, the next call to jdbcInfo() in my subclass finds the CITEXT entry in the dictionary from super.jdbcInfo(). That is, this must be perilously close to wor

Re: Can I force a reload of a database's JDBC info?

2016-03-04 Thread Chuck Hill
o:webobjects-dev@lists.apple.com>> Subject: Re: Can I force a reload of a database's JDBC info? Hi Chuck, I’ve also seen your post about subclassing JDBCPlugIn, which I’ll try shortly, but... On 4 Mar 2016, at 5:31 pm, Paul Hoadley mailto:pa...@logicsquad.net>> wrote: On 4 Mar

Re: Can I force a reload of a database's JDBC info?

2016-03-04 Thread Paul Hoadley
Hi Chuck, I’ve also seen your post about subclassing JDBCPlugIn, which I’ll try shortly, but... On 4 Mar 2016, at 5:31 pm, Paul Hoadley wrote: > > On 4 Mar 2016, at 4:59 pm, Chuck Hill > wrote: > >> Ah, right, protected, I was going to mention that and got distrac

Re: Can I force a reload of a database's JDBC info?

2016-03-04 Thread Chuck Hill
orce a reload of a database's JDBC info? On 4 Mar 2016, at 4:59 pm, Chuck Hill mailto:ch...@gevityinc.com>> wrote: Ah, right, protected, I was going to mention that and got distracted. :-) You will need to find a way to get it it to use a subclass of JDBCAdaptor. Wonder does this

Re: Can I force a reload of a database's JDBC info?

2016-03-03 Thread Paul Hoadley
On 4 Mar 2016, at 4:59 pm, Chuck Hill wrote: > Ah, right, protected, I was going to mention that and got distracted. :-) > You will need to find a way to get it it to use a subclass of JDBCAdaptor. > Wonder does this with ERXJDBCAdaptor. Here’s another potential hack. I know what the keypa

Re: Can I force a reload of a database's JDBC info?

2016-03-03 Thread Chuck Hill
PM To: Chuck Hill mailto:ch...@gevityinc.com>> Cc: WebObjects Development mailto:webobjects-dev@lists.apple.com>> Subject: Re: Can I force a reload of a database's JDBC info? Hi Chuck, On 4 Mar 2016, at 2:45 pm, Chuck Hill mailto:ch...@gevityinc.com>> wrote: Then call JDBC

Re: Can I force a reload of a database's JDBC info?

2016-03-03 Thread Paul Hoadley
Hi Chuck, On 4 Mar 2016, at 2:45 pm, Chuck Hill wrote: > Then call JDBCAdaptor.typeInfoModel(EOModel) get get things setup again. I’m in a migration upgrade() method, and I’ve got to this point. I can get database.adapter() (where database is the ERXMigrationDatabase passed to upgrade()), but

Re: Can I force a reload of a database's JDBC info?

2016-03-03 Thread Chuck Hill
lto:ch...@gevityinc.com>> Cc: WebObjects Development mailto:webobjects-dev@lists.apple.com>> Subject: Re: Can I force a reload of a database's JDBC info? On 4 Mar 2016, at 2:45 pm, Chuck Hill mailto:ch...@gevityinc.com>> wrote: You can remove the jdbc2Info key from the connec

Re: Can I force a reload of a database's JDBC info?

2016-03-03 Thread Paul Hoadley
On 4 Mar 2016, at 2:45 pm, Chuck Hill wrote: > You can remove the jdbc2Info key from the connection dictionary(ies) and then > call setConnectionDictionary on the adaptor for each model (or just one if > they all connect to the same database). Then call > JDBCAdaptor.typeInfoModel(EOModel) ge

Re: Can I force a reload of a database's JDBC info?

2016-03-03 Thread Chuck Hill
orce a reload of a database's JDBC info? Hello, As discussed in a recent thread (“Use case for a "case insensitive equals" qualifier”), I want to use PostgreSQL’s CITEXT extension type on a column (User.username). I’d like to make the change using migrations. Because CITEXT is an extensi

Can I force a reload of a database's JDBC info?

2016-03-03 Thread Paul Hoadley
y database where you want to use it: CREATE EXTENSION IF NOT EXISTS citext; That’s fine: I can just call ERXJDBCUtilities.executeUpdate() in the appropriate migration upgrade(). However, what _seems_ to be going on is that EOF loads the database’s JDBC info at launch, and (because the extens

Re: Suppressing javax.naming.NameNotFoundException: Name "comp/env/jdbc" not found in context

2015-12-14 Thread Chuck Hill
ilto:b...@salient.de>> Date: Monday, December 14, 2015 at 2:02 AM To: webobjects-dev mailto:webobjects-dev@lists.apple.com>> Subject: Re: Suppressing javax.naming.NameNotFoundException: Name "comp/env/jdbc" not found in context Nope. The ConnectionDictionairies of the

Re: Suppressing javax.naming.NameNotFoundException: Name "comp/env/jdbc" not found in context

2015-12-14 Thread René Bock
ppressing javax.naming.NameNotFoundException: Name "comp/env/jdbc" > not found in context > > Hi, > > we are deploying our Application as a servlet container. > > The database connection is configured via Properties and not via JNDI . > > The result is, that

Re: Suppressing javax.naming.NameNotFoundException: Name "comp/env/jdbc" not found in context

2015-12-11 Thread Chuck Hill
December 10, 2015 at 8:22 AM To: webobjects-dev mailto:webobjects-dev@lists.apple.com>> Subject: Suppressing javax.naming.NameNotFoundException: Name "comp/env/jdbc" not found in context Hi, we are deploying our Application as a servlet container. The database connection is confi

Suppressing javax.naming.NameNotFoundException: Name "comp/env/jdbc" not found in context

2015-12-10 Thread René Bock
11:34:40 CET] javax.naming.NameNotFoundException: Name "comp/env/jdbc" not found in context "java:". at com.ibm.ws.naming.ipbase.NameSpace.lookupInternal(NameSpace.java:1228) at com.ibm.ws.naming.ipbase.NameSpace.lookup(NameSpace.j

work-around: The JDBC driver does not show columns of some tables

2015-03-02 Thread OC
torChannel.describeModelWithTableNames > gives me wrong results -- empty attribute sets -- for some tables: since the > JDBC driver does that, too. > > Has perhaps anyone the slightest idea what the darn might be culprit and how > to fix the problem? > > Thanks a big

The JDBC driver does not show columns of some tables

2015-03-01 Thread OC
Hello there, well I have found the reason why EOAdaptorChannel.describeModelWithTableNames gives me wrong results -- empty attribute sets -- for some tables: since the JDBC driver does that, too. Has perhaps anyone the slightest idea what the darn might be culprit and how to fix the problem

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-25 Thread Matthias Jakob
At the End, don’t leave dbConnectURLGLOBAL blank ;-) thats all ;-( Matthias Am 25.04.2014 um 01:47 schrieb Matthias Jakob : > Hi David, > hi Andrew, > hi there, > > after a remote debugging session I’ve found the problem (Remember I will use > a JNDI JDBC Datasource!): &

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-24 Thread Matthias Jakob
Hi David, hi Andrew, hi there, after a remote debugging session I’ve found the problem (Remember I will use a JNDI JDBC Datasource!): In ERXMigrator protected boolean canMigrateModel(EOModel model) { String adaptorName = model.adaptorName(); if ("M

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-24 Thread Matthias Jakob
Hi David, protected void migrationsWillRun(ERXMigrator migrator) { // TODO Auto-generated method stub super.migrationsWillRun(migrator); System.out.println("-->migrationsWillRun<--"); } Is never called, local or in the Appserver ??

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-24 Thread Theodore Petrosky
don’t think migrations have ever been able to > >>> *create* a database. I think you have always needed the DB to exist > >>> first, then migrations can create schemas, tables, constraints, etc. > >>> > >>> It has been a long time since I tri

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-24 Thread John Huss
> >>> I may be incorrect, but I don’t think migrations have ever been able > to *create* a database. I think you have always needed the DB to exist > first, then migrations can create schemas, tables, constraints, etc. > >>> > >>> It has been a long tim

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-24 Thread Matthias Jakob
Clear ;-) Sir! ;-) Am 24.04.2014 um 15:18 schrieb David Avendasora : > > On Apr 24, 2014, at 9:16 AM, David Avendasora > wrote: > >> Override the migrationsWillRun method and stick a breakpoint on it. Let’s >> make sure that it is getting that far. > > Umm… in your subclass of ERXApplicatio

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-24 Thread David Avendasora
On Apr 24, 2014, at 9:16 AM, David Avendasora wrote: > Override the migrationsWillRun method and stick a breakpoint on it. Let’s > make sure that it is getting that far. Umm… in your subclass of ERXApplication, in case that wasn’t clear… It probably was to you, but hey, Future Dave is going t

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-24 Thread David Avendasora
ate* a database. I think you have always needed the DB to exist first, >>>> then migrations can create schemas, tables, constraints, etc. >>>> >>>> It has been a long time since I tried to start from scratch, so it is >>>> entirely pos

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-24 Thread Matthias Jakob
* a database. I think you have always needed the DB to exist first, >>> then migrations can create schemas, tables, constraints, etc. >>> >>> It has been a long time since I tried to start from scratch, so it is >>> entirely possible that I’m completely wrong.

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-24 Thread Theodore Petrosky
ch, so it is >> entirely possible that I’m completely wrong. :-) (shocking, I know) >> >> Sir Socks >> >> >> >> On Apr 22, 2014, at 6:22 PM, Matthias Jakob wrote: >> >>> Hi there! >>> I’ve got a problem with m

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-24 Thread Matthias Jakob
een a long time since I tried to start from scratch, so it is > entirely possible that I’m completely wrong. :-) (shocking, I know) > > Sir Socks > > > > On Apr 22, 2014, at 6:22 PM, Matthias Jakob wrote: > >> Hi there! >> I’ve got a problem with m

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-23 Thread David Avendasora
possible that I’m completely wrong. :-) (shocking, I know) Sir Socks On Apr 22, 2014, at 6:22 PM, Matthias Jakob wrote: > Hi there! > I’ve got a problem with my web.xml JNDI JDBC entry in Servlet Deployment and > migrations. > > Using the web.xml entry > > > M

Re: JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-22 Thread John Huss
o run them yourself. On Tue, Apr 22, 2014 at 5:22 PM, Matthias Jakob wrote: > Hi there! > I’ve got a problem with my web.xml JNDI JDBC entry in Servlet Deployment > and migrations. > > Using the web.xml entry > > > MS SQL Server > jdbc/TEST > javax.sql.DataSource >

JNDI JDBC entry in web.xml Servlet Deployment vs. Migrations

2014-04-22 Thread Matthias Jakob
Hi there! I’ve got a problem with my web.xml JNDI JDBC entry in Servlet Deployment and migrations. Using the web.xml entry MS SQL Server jdbc/TEST javax.sql.DataSource Container Shareable It works fine with an already created database and a „Properties" database config. With an al

Re: Deployment: JDBC jar not found

2013-06-16 Thread Theodore Petrosky
nn > Subject: Deployment: JDBC jar not found > To: webobjects-dev@lists.apple.com > Date: Sunday, June 16, 2013, 7:37 AM > Hallo, > As far as I can see the jdbc mysql adaptor is in the > Klasspath but the app fails to find it. > I put it in the Java folder in the App folder as the ap

Deployment: JDBC jar not found

2013-06-16 Thread ute Hoffmann
Hallo, As far as I can see the jdbc mysql adaptor is in the Klasspath but the app fails to find it. I put it in the Java folder in the App folder as the app contains all Frameworks in its own directory. Has someone an idea what could be wrong? Is the Java Folder in the App Folder the

RE: postgres jdbc driver

2013-03-06 Thread Michael Gargano
tgres jdbc driver Michael, Did my suggestion about the statement_timeout help at all? If you have queries that run for a long time, the statement will time out and Postgres will close the connection. There are both statement and connection timeout parameters in the PG conf file. Karl On 6 Mar

RE: postgres jdbc driver

2013-03-06 Thread Michael Gargano
The statement is closing at random times and it eventually ends up hanging eof and locking the instance. It looks like others have found an issue with the postgres jdbc driver doing this under heavy load, it's all in the statement pooling (some kind of race condition). I've been

Re: postgres jdbc driver

2013-03-06 Thread Kevin Hinkson
On 6 Mar 2013, at 11:46, webobjects-dev-requ...@lists.apple.com wrote: > > Hi all, > >Just taking a quick survey of folks using postgres. I think > we've found an issue with the jdbc driver (any version within the last year > or so). >

Re: postgres jdbc driver

2013-03-06 Thread Karl Gretton
, Michael Gargano wrote: > Hi all, > > Just taking a quick survey of folks using postgres. I think > we’ve found an issue with the jdbc driver (any version within the last year > or so). > Since people don’t update the jdbc driv

Re: postgres jdbc driver

2013-03-06 Thread Ramsey Gurley
Out of curiosity, what sort of issues are you seeing? We use postgresql here, but it's old. (8.3.x) Ramsey On Mar 6, 2013, at 9:37 AM, Michael Gargano wrote: > Hi all, > > Just taking a quick survey of folks using postgres. I think > we’ve found an is

postgres jdbc driver

2013-03-06 Thread Michael Gargano
Hi all, Just taking a quick survey of folks using postgres. I think we've found an issue with the jdbc driver (any version within the last year or so). Since people don't update the jdbc drivers too frequently. What version of driver

Re: Interrupting EOF's evaluateExpression() similar to JDBC

2012-10-06 Thread Ramsey Gurley
aiting on the > results of evaluateExpression()? > > In JDBC if I have the following code: > > ResultSet rs = statement.executeQuery(sql); > > and the thread blocks in the executeQuery() waiting for the results then I > can have a watch dog thread that I spaw

Re: Interrupting EOF's evaluateExpression() similar to JDBC

2012-10-06 Thread Ricardo Parada
Thanks Mike. Ricardo On Oct 6, 2012, at 8:12 AM, Mike Schrag wrote: > There is no api exposed to cancel fetches in EOF … you'd need to do this with > JDBC. Also, never use Thread.stop because it can leave your thread in a > totally unknown state. You could use Thread.interrup

Re: Interrupting EOF's evaluateExpression() similar to JDBC

2012-10-06 Thread Mike Schrag
There is no api exposed to cancel fetches in EOF … you'd need to do this with JDBC. Also, never use Thread.stop because it can leave your thread in a totally unknown state. You could use Thread.interrupt, but it will probably have similar behavior to what you are seeing with stop (th

Interrupting EOF's evaluateExpression() similar to JDBC

2012-10-06 Thread Ricardo Parada
Hi All, Does EOF have a way to interrupt the thread when it is blocked waiting on the results of evaluateExpression()? In JDBC if I have the following code: ResultSet rs = statement.executeQuery(sql); and the thread blocks in the executeQuery() waiting for the results then I can have

Re: Deployment on Linux (jdbc driver pb)

2012-07-18 Thread Daniele Corti
Hi, Or, maybe, you have to manipulate tables with foreign key (so MyISAM is unusable and InnoDB has some, how could you say, "problems" with variable length columns), and millions of records (so MySQL is NOT the solution). After we leave OS X at server side, passing to linux, I've changed to Postg

Re: Deployment on Linux (jdbc driver pb)

2012-07-17 Thread Ramsey Gurley
On Jul 17, 2012, at 12:30 PM, Kieran Kelleher wrote: >> Or just don't use MySQL ;-) I find it's full of fun little surprises like >> this one. > > LOL - only if you don't read the docs - and yeah, it should be plug and play > with sensible default settings, but what ever is nowadays ;-) Me?

Re: Deployment on Linux (jdbc driver pb)

2012-07-17 Thread Kieran Kelleher
inux to wndows, vice >> versa. >> >> - Original Message - From: "Jean Pierre Malrieu" >> To: "Pascal Robert" >> Cc: "WebObjects-Dev Mailing List List" >> Sent: Monday, July 16, 2012 9:48 PM >> Subject: Re: D

Re: Deployment on Linux (jdbc driver pb)

2012-07-17 Thread Ramsey Gurley
That will enable you later to port the database from linux to wndows, vice > versa. > > - Original Message - From: "Jean Pierre Malrieu" > To: "Pascal Robert" > Cc: "WebObjects-Dev Mailing List List" > Sent: Monday, July 16, 2012 9:48 PM &

Re: Deployment on Linux (jdbc driver pb)

2012-07-17 Thread Cheong Hee (Gmail)
y 16, 2012 9:48 PM Subject: Re: Deployment on Linux (jdbc driver pb) Thank you both. It works. Now discovering that on UNIX, mysql table name are case sensitive... G! Le 16 juil. 2012 à 15:00, Pascal Robert a écrit : Le 2012-07-16 à 08:58, Jean Pierre Malrieu a écrit : Meaning you add

Re: Deployment on Linux (jdbc driver pb)

2012-07-16 Thread Kieran Kelleher
table name are case sensitive... G! > > > > Le 16 juil. 2012 à 15:00, Pascal Robert a écrit : > > > >> > >> Le 2012-07-16 à 08:58, Jean Pierre Malrieu a écrit : > >> > >>> Meaning you add it directly in the "Libraries" folder

Re: Deployment on Linux (jdbc driver pb)

2012-07-16 Thread James Cicenia
t; > >> Le 2012-07-16 à 08:58, Jean Pierre Malrieu a écrit : > >> > >>> Meaning you add it directly in the "Libraries" folder and ant build > picks it up? > >> > >> Yes. > >> > >>> Le 16 juil. 2012 à 14:26, Paul Yu a écrit

Re: Deployment on Linux (jdbc driver pb)

2012-07-16 Thread Kieran Kelleher
, Pascal Robert a écrit : > >> >> Le 2012-07-16 à 08:58, Jean Pierre Malrieu a écrit : >> >>> Meaning you add it directly in the "Libraries" folder and ant build picks >>> it up? >> >> Yes. >> >>> Le 16 juil. 2012 à

Re: Deployment on Linux (jdbc driver pb)

2012-07-16 Thread Jean Pierre Malrieu
er and ant build picks it >> up? > > Yes. > >> Le 16 juil. 2012 à 14:26, Paul Yu a écrit : >> >>> I embed the jdbc library in my app bundle, >>> >>> Sent from my iPad >>> >>> On Jul 16, 2012, at 8:07 AM, Jean Pierre Mal

Re: Deployment on Linux (jdbc driver pb)

2012-07-16 Thread Pascal Robert
Le 2012-07-16 à 08:58, Jean Pierre Malrieu a écrit : > Meaning you add it directly in the "Libraries" folder and ant build picks it > up? Yes. > Le 16 juil. 2012 à 14:26, Paul Yu a écrit : > >> I embed the jdbc library in my app bundle, >> >> Sent f

Re: Deployment on Linux (jdbc driver pb)

2012-07-16 Thread Jean Pierre Malrieu
Meaning you add it directly in the "Libraries" folder and ant build picks it up? Le 16 juil. 2012 à 14:26, Paul Yu a écrit : > I embed the jdbc library in my app bundle, > > Sent from my iPad > > On Jul 16, 2012, at 8:07 AM, Jean Pierre Malrieu wrote: > >&g

Re: Deployment on Linux (jdbc driver pb)

2012-07-16 Thread Theodore Petrosky
Drag and drop the .jar for your database jdbc driver into the Library folder of your application in eclipse. right click the listed driver and select "add to build path" Under the Build Path menu that should work. Ted > -- > > Message: 5 >

Re: Deployment on Linux (jdbc driver pb)

2012-07-16 Thread Jean Pierre Malrieu
> >> I am trying my first deployment on LINUX, and thanks to the instructions in >> the wiki, things seem to work more or less (application deployed and >> launched). >> But I have got an exception (cannot obtain database channel) when trying to >> talk to mysql

Re: Deployment on Linux (jdbc driver pb)

2012-07-16 Thread Paul Yu
I embed the jdbc library in my app bundle, Sent from my iPad On Jul 16, 2012, at 8:07 AM, Jean Pierre Malrieu wrote: > Hi, > > I am trying my first deployment on LINUX, and thanks to the instructions in > the wiki, things seem to work more or less (application deployed and

Re: Deployment on Linux (jdbc driver pb)

2012-07-16 Thread probert
ployed and > launched). > But I have got an exception (cannot obtain database channel) when trying to > talk to mysql. > I have installed the jdbc driver, but how do I tell the app where to find it? > > TIA > > JPM > ___ >

Deployment on Linux (jdbc driver pb)

2012-07-16 Thread Jean Pierre Malrieu
Hi, I am trying my first deployment on LINUX, and thanks to the instructions in the wiki, things seem to work more or less (application deployed and launched). But I have got an exception (cannot obtain database channel) when trying to talk to mysql. I have installed the jdbc driver, but how do

Re: jdbc error at start up

2012-06-01 Thread Chuck Hill
Follow the code down... Exceptions don't happen without reason. On 2012-06-01, at 1:54 AM, Ron X wrote: > just a static block: static { ... setting delegate...} > > 2012/6/1 Lachlan Deck > On 31/05/2012, at 11:31 PM, Ron X wrote: > > > hi, i use maven lo load dependencies and enable Java ERJ

Re: jdbc error at start up

2012-06-01 Thread Ron X
just a static block: static { ... setting delegate...} 2012/6/1 Lachlan Deck > On 31/05/2012, at 11:31 PM, Ron X wrote: > > > hi, i use maven lo load dependencies and enable Java ERJDBCAdaptor, but > at star up i've got: > > > > WARN 28.05 MB used/53.01 MB free [main] (ERXNSLogLog4jBridge.java:

Re: jdbc error at start up

2012-06-01 Thread Lachlan Deck
On 31/05/2012, at 11:31 PM, Ron X wrote: > hi, i use maven lo load dependencies and enable Java ERJDBCAdaptor, but at > star up i've got: > > WARN 28.05 MB used/53.01 MB free [main] (ERXNSLogLog4jBridge.java:43) - A > fatal exception occurred: null > [2012-5-31 6:26:9 PDT] java.lang.Exceptio

jdbc error at start up

2012-05-31 Thread Ron X
hi, i use maven lo load dependencies and enable Java ERJDBCAdaptor, but at star up i've got: WARN 28.05 MB used/53.01 MB free [main] (ERXNSLogLog4jBridge.java:43) - A fatal exception occurred: null [2012-5-31 6:26:9 PDT] java.lang.ExceptionInInitializerError at er.jdbcadaptor.PrincipalClass

JDBC

2012-05-04 Thread Ron X
how can i use JavaERJDBCAdaptor instead of JavaJDBCAdaptor? if i add a dependency of JavaERJDBCAdaptor i've got: WARN 27.64 MB used/53.43 MB free [main] (ERXNSLogLog4jBridge.java:43) - Principal class 'er.coolcomponents.ERCoolComponents' not found in bundle ERCoolComponents WARN 27.87 MB used/

Re: JDBC Connection Debugging information

2012-03-24 Thread Daniel Roy
Hi Farrukh, Thanks for the suggestions. We have resolved the problem. Turns out it was a problem with retrieving jdbc2Info from the connection to the DB server. Following the instructions outlined in the following 2008 article resolved the problem. Essentially, we have to force the JDBC

Re: JDBC Connection Debugging information

2012-03-23 Thread Farrukh Ijaz
I suspect the issue is because of inappropriate JDBC driver. Check if it's type 4. If not then download the latest one that is needed for the server you have. Here you can search for jdbc driver: http://jdbc.postgresql.org/download.html#current http://devapp.sun.com/product/jdbc/dr

Re: JDBC Connection Debugging information

2012-03-23 Thread Chuck Hill
g some basic vanilla JDBC connection code and confirmed that there is no > delay updating/selecting, etc on the remote server - the delay only happens > when I run our WO app. The only difference between local DB and remote DB is > the remote DB has SSL enabled, but I'm not connectin

Re: JDBC Connection Debugging information

2012-03-23 Thread Daniel Roy
Thanks Chuck. I enabled some debugging info and I see the following happening when I connect to the remote test DB server. When I configure to run locally, the the local DB server introduces no delay. I have run a test using some basic vanilla JDBC connection code and confirmed that there is

  1   2   3   >