Re: SQL Error on fetch

Yes... what I meant to say was that I upgraded to a new connector and using that new class path seemed to work better... Gino > On 11 Feb 2020, at 02:41, Tim W wrote: > > Hi Gino: > > Were you not specifying the database driver class in Properties before this? > Driver class and PlugIn class

Re: SQL Error on fetch

Hi Gino: Were you not specifying the database driver class in Properties before this? Driver class and PlugIn class definitely should always be specified. Tim > On Feb 10, 2020, at 5:37 AM, Gino Pacitti via Webobjects-dev > wrote: > > What seems to have fixed is adding this in my properties

Re: SQL Error on fetch

What seems to have fixed is adding this in my properties file for the connection dictionary: mymodel.DBDriver = com.mysql.cj.jdbc.Driver I installed the latest JDBC adaptor from MySQL and updated the Drive info… The last few days I have had no issues… Gino > On 7 Feb 2020, at 17:36, Tim W wr

Re: SQL Error on fetch

Hi Gino: I think I might have seen this error when the MySQLPlugin is not in the app classpath? In other words, some SQL that the frameworks are trying to build for a transaction are subsequently not being customized properly for MySQL before being sent to the DB. The errors makes sense in tha

Re: SQL Error on fetch

Isn’t that just when the adaptor needs to reconnect after a period of rest? > On Feb 4, 2020, at 4:00 PM, Gino Pacitti via Webobjects-dev > wrote: > > Hi > Has anyone encountered this sort of error before? > > It does not happen all the time but just on occasion. > > mysql Ver 14.14 Distrib

Re: SQL Error on fetch

Gino, I can be completely wrong, but it looks like two problem logs interspersed, which stinks by a threading issue, along with the fact it happens intermittently. If possible, I'd check race conditions and try to synchronize (or lock) where needed. Quite possibly someone other would give a m

Re: SQL Exeption Error upgrading to mysql 5.6.41 - SOLVED

Useful Resource : https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-configuration-properties.html > On 14 Oct 2018, at 15:02, Gino Pacitti wrote: > > use sendFractionalSeconds=false in the connection string :) > >> On 14 Oct 2018, at 12:46, Gino Pacitti wrote: >> >> Im loo

Re: SQL Exeption Error upgrading to mysql 5.6.41 - SOLVED

use sendFractionalSeconds=false in the connection string :) > On 14 Oct 2018, at 12:46, Gino Pacitti wrote: > > Im looking and looking but the error seems to be here: > > Invocations of setNanos() are illegal. > java.lang.IllegalStateException: com.webobjects.foundation.NSTimestamp is an > imm

Re: SQL Exeption Error upgrading to mysql 5.6.41

Im looking and looking but the error seems to be here: Invocations of setNanos() are illegal. java.lang.IllegalStateException: com.webobjects.foundation.NSTimestamp is an immutable object. Invocations of setNanos() are illegal. at com.webobjects.foundation.NSTimestamp.setNanos(NSTimestam

Re: SQL Exeption Error upgrading to mysql 5.6.41

We got the same problem. Any solution yet? Best regards, Daniel Bietenbeck > Am 14.10.2018 um 13:06 schrieb Gino Pacitti : > > I just updated my mysql server on linux and columns which are DATETIME and > when I am using NSTimestamp for Qualifiers for a query (plus any inserts with > a NSTimes

Re: SQL Exeption Error upgrading to mysql 5.6.41

Could it be something to do with this: https://dev.mysql.com/doc/refman/5.6/en/datetime.html Where Mysql is trying to find microseconds? Gino > On 14 Oct 2018, at 12:06, Gino Pacitti wrote: > > I just updated my mysql server on linux and columns which are DATETIME and > when I am using NSTim

Re: SQL Server plugin framework

016 1:44 PM To: Schoenenberger Dominique Cc: Ress, David A; webobjects-dev@lists.apple.com Subject: Re: SQL Server plugin framework Hi Dominique, I have not touched this in years, so it may need some updating. Chuck From: Schoenenberger Dominique mailto:dominique.schoenenber...@nagra.com&g

Re: SQL Server plugin framework

Hello, I tried the MicrosoftPlugIn from WebObject distribution but it’s not working correctly. In the post below, you mention a plugin you wrote and you provide a link. The link is not working anymore. Could you send me this code ? Thanks, Dominique On 25 Nov 2014, at 22:20, Chuck Hill mail

Re: sql logging

Ted, if Timothy's advice does not help -- I bumped into similar problem lately (along with my weird “prepareForSaveWithCoordinator: Cannot save the object with globalID” problems /whose relatively unsurprising and rather sad results I'm about to write in a moment/), and haven't been able to log

Re: sql logging

Hola! With Wonder you want to do these: # Enable delegate to emit SQL debugging info. The Logger used is log4j.category.er.extensions.ERXAdaptorChannelDelegate.sqlLogging=DEBUG # put this to true if you want to log sql stuff er.extensions.ERXAdaptorChannelDelegate.enabled=true # How long a state

Re: SQL Server plugin framework

Hello, I most struggled with UTF-8 Support and the use of ERMigrations and ERPrototypes ( Mircosoft decided to introduce NVARCHAR and NTEXT to store UTF-8 strings. VARCHAR and TEXT are for 8-bit Chars only ) So I ended in hacking EOJDBCMicrosoftPrototypes.plist, JDBCInfo.plist and the Micro

Re: SQL Server plugin framework

On 2014-11-25, 1:12 PM, "Ress, David A" wrote: Good afternoon, My current question is a development issue: I am using SQL Server and I cannot seem to find its plugin framework within the latest Wonder builds listed at https://github.com/wocommunity/wonder. Could someone please tell me where I

Re: SQL Generation Issue

> Either that or I’m doing something fundamentally wrong. Place your bets! Okay all you people that bet on “SQL generation is busted” are out of luck! Shockingly *I* was doing something wrong. What? Nobody bet against it being my fault? Sigh. Anyway, here’s what I was doing “wrong”: We are us

Re: SQL Generation Issue

On 2014-04-24, 8:05 AM, "David Avendasora" wrote: Lack of good code hygiene beyond pretty formatting has now bit me. I should have had the following like a real developer: protected static ERXEnterpriseObjectCache cacheByPrimaryKey = null; protected static ERXEnterpriseObjectCache cacheByPrimar

Re: SQL Generation Issue

On Apr 24, 2014, at 11:05 AM, David Avendasora wrote: > If ERXEnterpriseObjectCache breaks it, what else can? That was *supposed* to be rhetorical. But, well, guess what? I can tell you at least one other thing that breaks it: ERXFrameworkPrincipal.setUpFrameworkPrincipalClass(Class) Seri

Re: SQL Generation Issue

This is now biting me. I have the following: public static ERXEnterpriseObjectCache cacheByPrimaryKey = new ERXEnterpriseObjectCache(Airport.ENTITY_NAME, "primaryKey", // Cache Key

Re: SQL

i think it's an error in wonder-mysql-plugin 25 апреля 2012 г. 9:22 пользователь Ron X написал: > i think i use MySQL-plugin checkouted from WONDER-repo. > > 25 апреля 2012 г. 1:33 пользователь Pascal Robert написал: > > You have to use the MySQL plugin from Wonder, the bundled plugin coming >>

Re: SQL

i think i use MySQL-plugin checkouted from WONDER-repo. 25 апреля 2012 г. 1:33 пользователь Pascal Robert написал: > You have to use the MySQL plugin from Wonder, the bundled plugin coming > with WO 5.4 have problems. > > > i use MySQL and do migration by the migration java class (not sql-file):

Re: SQL

You have to use the MySQL plugin from Wonder, the bundled plugin coming with WO 5.4 have problems. > i use MySQL and do migration by the migration java class (not sql-file): > > > @Override > public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase > database) throws

Re: SQL

i use MySQL and do migration by the migration java class (not sql-file): @Override public void upgrade(EOEditingContext editingContext, ERXMigrationDatabase database) throws Throwable { ERXMigrationTable albumTable = database.existingTableNamed("Album"); albumTable.newStringCol

Re: SQL

Hi Ron, The m2e plug-in usually respects the order of your dependencies. Always add ERExtensions as your first dependency to avoid problems. Cheers, Henrique On 17/04/2012, at 12:30, Ron X wrote: > i use maven > > 17 апреля 2012 г. 17:17 пользователь Johann Werner написал: > > Am 17.04.201

Re: SQL

i use maven 17 апреля 2012 г. 17:17 пользователь Johann Werner написал: > > Am 17.04.2012 um 15:52 schrieb Ron X: > > compilation error: > The constructor NSArray(String, String) is undefined > > > Then something with your class path is wrong, the Wonder version of > NSArray has the constructor

Re: SQL

Am 17.04.2012 um 15:52 schrieb Ron X: > compilation error: > The constructor NSArray(String, String) is undefined Then something with your class path is wrong, the Wonder version of NSArray has the constructor NSArray(E, E...). Check if ERExtensions comes before the Java* frameworks. > > 17

Re: SQL

compilation error: The constructor NSArray(String, String) is undefined 17 апреля 2012 г. 11:53 пользователь Johann Werner написал: > > Am 17.04.2012 um 09:22 schrieb Ron X: > > NSArray keys = new NSArray(new > String[]{"chart_count", "chart_size_sum"}); > > > don't make it more complica

Re: SQL

Am 17.04.2012 um 09:22 schrieb Ron X: > NSArray keys = new NSArray(new > String[]{"chart_count", "chart_size_sum"}); don't make it more complicated than necessary: keys = new NSArray("chart_count", "chart_size_sum"); > NSArray result = > EOUtilities.rawRowsForSQL(editingCon

Re: SQL

Ron The last parameter needs to be an NSArray not a s String[] Sent from my iPad On Apr 17, 2012, at 3:20 AM, Ron X wrote: > Error! > The method rawRowsForSQL(EOEditingContext, String, String, NSArray) in the > type EOUtilities is not applicable for the arguments (EOEditingContext, > String,

Re: SQL

NSArray keys = new NSArray(new String[]{"chart_count", "chart_size_sum"}); NSArray result = EOUtilities.rawRowsForSQL(editingContext, "legalsounds", "SELECT count(*), sum(songFileSize) FROM `Song`", keys); works fine 17 апреля 2012 г. 10:20 пользова

Re: SQL

Error! The method rawRowsForSQL(EOEditingContext, String, String, NSArray) in the type EOUtilities is not applicable for the arguments (EOEditingContext, String, String, String[]) 13 апреля 2012 г. 21:47 пользователь Larry Mills-Gahl написал: > > > On Apr 13, 2012, at 7:07 AM, Ron X wrote: > > th

Re: SQL

On Apr 13, 2012, at 7:07 AM, Ron X wrote: > thank you very much! very good! > this method considered deprecated - is there non-deprecated method? EOUtilities.rawRowsForSQL(EOEditingContext ec, String modelName, String sqlString, NSArray keys) rawRowsForSQL public static NSArray rawRowsForS

Re: SQL

It may not be the level of database independence that ERXEOControlUtilities offers, but if your dealing with SQL for the foreseeable future it should be pretty safe to do something like: EOUtilities.rawRowsForSQL(ERXEC.newEditingContext(), "MyModelName", "SELECT COUNT(somefield), SUM(somefield

Re: SQL

thank you very much! very good! this method considered deprecated - is there non-deprecated method? maybe you know where can i set timing for sql-query - cuz i have "request too long" exception every query more 5 s? 13 апреля 2012 г. 11:50 пользователь Henrique Gomes написал: > > On Apr 13, 2012

Re: SQL

On Apr 13, 2012, at 9:19 AM, Ron X wrote: > @Override > public WOActionResults defaultAction() { > NSArray result = > EOUtilities.rawRowsForSQL(session().defaultEditingContext(), > Chart.ENTITY_NAME, "SELECT count(*), sum(size)"); > > return pageWithName(Main.cl

Re: SQL

@Override public WOActionResults defaultAction() { NSArray result = EOUtilities.rawRowsForSQL(session().defaultEditingContext(), Chart.ENTITY_NAME, "SELECT count(*), sum(size)"); return pageWithName(Main.class); } ERROR 47.15 MB used/33.91 MB free [WorkerThread0] (ERD2

Re: SQL

EOUtilities.rawRowsForSQL 2012/4/12 Ron X > but how can i do COUNT() and SUM() in ONE query? > aggregateFunctionWithQualifier - name of the function - just one > (count/sum), but i need two (count & sum) > > > 11 апреля 2012 г. 19:17 пользователь Ramsey Gurley < > rgur...@smarthealth.com> напис

Re: SQL

but how can i do COUNT() and SUM() in ONE query? aggregateFunctionWithQualifier - name of the function - just one (count/sum), but i need two (count & sum) 11 апреля 2012 г. 19:17 пользователь Ramsey Gurley написал: > ERXEOControlUtilities.aggregateFunctionWithQualifier > _

Re: SQL

ERXEOControlUtilities.aggregateFunctionWithQualifier On Apr 11, 2012, at 9:09 AM, Ron X wrote: > ok. > for example - i have huge db. > but i need to measure count and sum in 1 sql query. > how can i do this accordingly the EOF/WONDER? > thanx > > 11 апреля 2012 г. 17:03 пользователь David LeBer

Re: SQL

ok. for example - i have huge db. but i need to measure count and sum in 1 sql query. how can i do this accordingly the EOF/WONDER? thanx 11 апреля 2012 г. 17:03 пользователь David LeBer < dleber_wo...@codeferous.com> написал: > Can you clarify what you are looking for Ron? > > > special methods

Re: SQL

Can you clarify what you are looking for Ron? > special methods of framework Do you mean *without* using Wonder? In general, using EOF, we try to avoid writing raw SQL and let the framework do it's job. What are you trying to achieve? -- David LeBer Codeferous Software On 2012-04-11, at 9:55

Re: SQL RTRIM

If you need trimming only for certain fields, yes you can do it in code by having cover methods on the getter. E.g., if you have an attribute called "trimMe", just override that method to trim the value return by super.trimMe() But does calling RTRIM in fetching is really an expansive operation?

Re: SQL RTRIM

hm. but i don't understand this thing: this avoiding RTRIM will be works on SELECT or UPDATE or both? for example i have CMS application. so there i need trimming (of course i can do this in java). but when i do fetching i don't need trimming. 2012/3/13 Chuck Hill > Yes, that is correct. If tha

Re: SQL RTRIM

Yes, that is correct. If that does not work, then there is a bug. Let us know how it works out. Chuck On 2012-03-12, at 11:11 PM, Ron X wrote: > What is the Value Type in the EOModel? << > Data type: String (RTRIM) > External type: VARCHAR > Class: java.lang.String > > as i understood - i n

Re: SQL RTRIM

What is the Value Type in the EOModel? << Data type: String (RTRIM) External type: VARCHAR Class: java.lang.String as i understood - i need just change String (RTRIM) to String and i shall not see all these RTRIMs in SQL-log, right? 2012/3/12 Pascal Robert > > Le 2012-03-12 à 15:06, Pascal Robe

Re: SQL RTRIM

Le 2012-03-12 à 15:06, Pascal Robert a écrit : > > Le 2012-03-12 à 14:55, Chuck Hill a écrit : > >> >> On 2012-03-12, at 11:24 AM, Ramsey Gurley wrote: >> >>> Google's search seems to work better than ours too :-/ If I search for >>> debugger on the wiki, I can't find: >>> >>> http://wiki.

Re: SQL RTRIM

Le 2012-03-12 à 14:55, Chuck Hill a écrit : > > On 2012-03-12, at 11:24 AM, Ramsey Gurley wrote: > >> Google's search seems to work better than ours too :-/ If I search for >> debugger on the wiki, I can't find: >> >> http://wiki.wocommunity.org/display/WOL/Using+the+debugger >> >> But if I

Re: SQL RTRIM

On 2012-03-12, at 11:24 AM, Ramsey Gurley wrote: > Google's search seems to work better than ours too :-/ If I search for > debugger on the wiki, I can't find: > > http://wiki.wocommunity.org/display/WOL/Using+the+debugger > > But if I search google for "debugger site:wocommunity.org" it's th

Re: SQL RTRIM

Maybe it's time to index everything with Elastic Search... > Google's search seems to work better than ours too :-/ If I search for > debugger on the wiki, I can't find: > > http://wiki.wocommunity.org/display/WOL/Using+the+debugger > > But if I search google for "debugger site:wocommunity.org

Re: SQL RTRIM

Google's search seems to work better than ours too :-/ If I search for debugger on the wiki, I can't find: http://wiki.wocommunity.org/display/WOL/Using+the+debugger But if I search google for "debugger site:wocommunity.org" it's the first result. Ramsey On Mar 12, 2012, at 10:36 AM, Chuck H

Re: SQL RTRIM

I HATE wikibooks. But Google loves them. On 2012-03-12, at 10:34 AM, Pascal Robert wrote: > No link to the wikibooks.org site please :-) > > http://wiki.wocommunity.org/display/WO/EOF-Modeling-Common+Pitfalls+and+Troubleshooting > >> Hi Ron, >> >> What is the Value Type in the EOModel? See

Re: SQL RTRIM

No link to the wikibooks.org site please :-) http://wiki.wocommunity.org/display/WO/EOF-Modeling-Common+Pitfalls+and+Troubleshooting > Hi Ron, > > What is the Value Type in the EOModel? See > http://en.wikibooks.org/wiki/WebObjects/EOF/Modeling/Common_Pitfalls_and_Troubleshooting > > Which da

Re: SQL RTRIM

Hi Ron, What is the Value Type in the EOModel? See http://en.wikibooks.org/wiki/WebObjects/EOF/Modeling/Common_Pitfalls_and_Troubleshooting Which database? Chuck On 2012-03-12, at 3:38 AM, Ron X wrote: > hi everybody > is it possible to impact to the framework (EOF) to avoid RTRIM in sql-q

Re: SQL - log

Thank you. Works fine. 2012/2/29 David Holt > This from ERExtensions properties > > # > # ERXAdaptorChannelDelegate > # > ## Enable delegate to emit SQL

Re: SQL - log

This from ERExtensions properties # # ERXAdaptorChannelDelegate # ## Enable delegate to emit SQL debugging info. The Logger used is ## log4j.category.er.

[workaround]: Re: SQL generation problem with Entity Modeler

I found a workaround for my problem: I created a new Eclipse workspace and imported only the framework which contains the EOModels. Then I can create the SQL without problems. This works without the other projects from which the framework projects depends because those are in a compiled form in

Re: SQL logging

On Nov 3, 2009, at 2:19 PM, Lon Varscsak wrote: Is there a way to get SQL logging where it's easily cut and pasted into a sql tool to analyze performance rather than the JDBC version with ?s and parameters? Not that I know of. You could make a plugin subclass to return "false" for the

Re: SQL logging

Yeah, that's not a bad idea since I already am subclassing the existing Sybase plugin. I'll try that, thanks! -Lon On Tue, Nov 3, 2009 at 3:27 PM, Chuck Hill wrote: > > On Nov 3, 2009, at 2:19 PM, Lon Varscsak wrote: > > Is there a way to get SQL logging where it's easily cut and pasted into

Re: SQL logging

Does your database have a setting to log slow queries, or even all queries to a text file . I know MySQL can do this with a property in the my.cnf properties file . Regards, Kieran On Nov 3, 2009, at 5:19 PM, Lon Varscsak wrote: Is there a way to get SQL logging where it's easily cut

Re: SQL logging

pretty sure anjo did this somewhere maybe for the sql stats tracking stuff? i'm 99% sure this code exists in wonder. On Nov 3, 2009, at 5:27 PM, Chuck Hill wrote: On Nov 3, 2009, at 2:19 PM, Lon Varscsak wrote: Is there a way to get SQL logging where it's easily cut and pasted into a

Re: SQL doesn't seem to match complex qualifiers

Joe, Can you build this manually in code with qualifier objects? I would try that and see if the results are the same... Ken On Feb 6, 2009, at 7:06 PM, Joe Moreno wrote: Hi all, It seems my graphical fetch spec is looking different when turned into SQL. I'm using the follow

Re: SQL Server 2005 Support Request 2

On Sep 30, 2008, at 8:57 PM, Shaun Higgins wrote: I am having problems connecting Entity Modeler to SQL Server 2005 DB. I am using webobjects v5.4.3 If you have any choice in the matter, I'd choose a different database. Any other database. First of all I found the last two articles on

Re: SQL Server Driver and Classpath problem

That was it. I never would have found that because for SQL Server 2000 I never had to populate a value for "driver" in my connection dictionary. It always worked just with the url. I don't really understand why that changed or, better, why the adaptor was looking for another driver signatur

Re: SQL Server Driver and Classpath problem

Peter: That was it. I never would have found that because for SQL Server 2000 I never had to populate a value for "driver" in my connection dictionary. It always worked just with the url. I don't really understand why that changed or, better, why the adaptor was looking for another driver

Re: SQL Server Driver and Classpath problem

This just bit me recently as well. Not only has the package changed, but the URL format for the driver has changed as well. It is no longer: jdbc:microsoft:sqlserver://YourServer:1433;databaseName=YourDatabase now it is: jdbc:sqlserver://YourServer:1433;databaseName=YourDatabase Good luck!

Re: SQL Server Driver and Classpath problem

This just bit me recently as well. Not only has the package changed, but the URL format for the driver has changed as well. It is no longer: jdbc:microsoft:sqlserver://YourServer:1433;databaseName=YourDatabase now it is: jdbc:sqlserver://YourServer:1433;databaseName=YourDatabase Good luck!

Re: SQL Server Driver and Classpath problem

Hi Tim, If the version of the JDBC driver supports SQL Server 2005, then the driver class in the eomodel connection dictionary should be "com.microsoft.sqlserver.jdbc.SQLServerDriver" not "com.microsoft.jdbc.sqlserver.SQLServerDriver" as the error states below. Running a query against

Re: SQL Error: This statement has been closed

Hi! It seems multiple EOF stacks and synchronizers are out of the equation. Digging further and thinking on Alentejo... Yours Miguel Arroz On 2008/05/11, at 00:42, Miguel Arroz wrote: Hi! I just found a new reason to avoid sleeping well. I'm running an app in development mode, wit

Re: SQL to EOQualifier

Hi Paulo, On Apr 29, 2008, at 5:02 PM, Paulo Filipe Andrade wrote: Hello, I was wondering if one can translate something like this: select message_id from message m where creator_id = 5 AND (select count(*) from message where message.reply_to_id = m.message_id) > 0; to an EOQualifier. I

Re: SQL Query from EOFetchspecification

On Mar 27, 2008, at 12:15 AM, [EMAIL PROTECTED] wrote: Could some one assist me in generating the sql query from the EOFetchSpecification object? You should be able to get there by creating an EOSQLExpressionFactory object, sending it a selectStatementForAttributes() message, and sending

Re: SQL Query from EOFetchspecification

See ERXSQLHelper in Wonder I believe EOFetchSpecification spec = new EOFetchSpecification("Address", > qual, sort); > > Here I want the SQL query of the "spec" > ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev ma

Re: SQL Query from EOFetchspecification

Hey Rohit, 1. Don't use qualifierWithQualifierFormat, build the EOKey- and EOAndQualifier yourself. 2. Do you want the SQL as a String? Sorry, never need that, so no idea. 3. Do you want to execute the Query? Use EOEditingContexts objectsForFetchSpecification() atze Am 27.03.2008

Re: SQL Schema comparator

I use a simple shell script that does a mysqldump --no-data (basically a schema dump) of both dev and production mysql databases and launches FileMerge with both schema files as args. On Feb 8, 2008, at 2:21 PM, Miguel Arroz wrote: Hi! Subject says it all... the ideia is comparing two S

Re: SQL Schema comparator

I was playing with DB Solo 2 last week. It has a pretty slick GUI schema compare. Dawn > Hi! > > Subject says it all... the ideia is comparing two SQL schemas to > help writing migration stuff. Anyone knows/uses/recommends any > software to do this? > > Yours > > Miguel Arroz > > Miguel Arroz

Re: SQL Schema comparator

Hi! FYI, this is a nice one: . It generates SQL than can be used to migrate from one schema to another. It's very easy to copy/paste the result into SQL files to be used by ERXMigrator, with few or no changes at all. :) Yours Miguel Arroz On 2008/02

Re: SQL Schema comparator

On 09/02/2008, at 7:41 AM, Mike Schrag wrote: Subject says it all... the ideia is comparing two SQL schemas to help writing migration stuff. Anyone knows/uses/recommends any software to do this? To sidestep your question, I write ERX migrations as I'm developing -- I never modify the datab

Re: SQL Schema comparator

An: Miguel Arroz <[EMAIL PROTECTED]> Cc: WebObjects-Dev List Betreff: Re: SQL Schema comparator Hi Miguel, I find "textwrangler" and "FileMerge" (/Developer/Applications/ Utilities/FileMerge) work well for this task if you export the schemas as .sql files. Just compar

Re: SQL Schema comparator

Hi! That will work for relatively small modifications, but I'm doing some big changes and experimentation, so I don't want to be constantly thinking on migration code right now. That would require too much discipline! :) Yours Miguel Arroz On 2008/02/08, at 20:41, Mike Schrag wrote

Re: SQL Schema comparator

all other databases you could take a look at Aqua Data Studio. Oliver Von: David Holt <[EMAIL PROTECTED]> Datum: Fri, 08 Feb 2008 11:39:30 -0800 An: Miguel Arroz <[EMAIL PROTECTED]> Cc: WebObjects-Dev List Betreff: Re: SQL Schema comparator Hi Miguel, I find "textwrangler&q

Re: SQL Schema comparator

Subject says it all... the ideia is comparing two SQL schemas to help writing migration stuff. Anyone knows/uses/recommends any software to do this? If you're developing against SQL Server (which I suppose is unlikely but possible!), Red Gate SQL Compare and SQL Data Compare do a fantast

Re: SQL Schema comparator

Subject says it all... the ideia is comparing two SQL schemas to help writing migration stuff. Anyone knows/uses/recommends any software to do this? To sidestep your question, I write ERX migrations as I'm developing -- I never modify the database directly. That way when you're done with

Re: SQL Schema comparator

Fri, 08 Feb 2008 11:39:30 -0800 > An: Miguel Arroz <[EMAIL PROTECTED]> > Cc: WebObjects-Dev List > Betreff: Re: SQL Schema comparator > > Hi Miguel, > > I find "textwrangler" and "FileMerge" (/Developer/Applications/ > Utilities/FileMerge) work

Re: SQL Schema comparator

Hi Miguel, I find "textwrangler" and "FileMerge" (/Developer/Applications/ Utilities/FileMerge) work well for this task if you export the schemas as .sql files. Just compare the differences line by line as you would for code. David On 8-Feb-08, at 11:21 AM, Miguel Arroz wrote: Hi! Su

Re: SQL from qualifier

On Jan 18, 2008, at 2:57 AM, [EMAIL PROTECTED] wrote: Can body tell me that how to get the sql if I have the qualifier ready with me? You could build the EOSQLExpression using EOSQLExpressionFactory. The generated SQL is sqlExpression.statement(). Aloha, Art ___

Re: SQL Generation and FrontBase 4.1.16

You are using WO 5.4? This is a bug in WO 5.4. Project Wonder has a FrontBase plugin, this might be fixed in that plugin. Or go back to WO 5.3.3 until 5.4.1 (with the needed fixes) is released. Chuck On Nov 25, 2007, at 1:07 PM, David Marioni wrote: Dear list, Is there a solution to re

Re: SQL Generation and FrontBase 4.1.16

David, May I ask what keeps you from upgrading to FB 4.2.7 or 4.2.8? FB 4.1.16 was out ages ago. Since that time the nice folks form FronBase fixed few problems, and improved performance. One thing I am sure - the move to Leo is more problematic then the FB upgrade. We are still testing 4.

Re: SQL Server questions

I am using Microsoft SQLServer 2000 with the MS JDBC driver on my projects and once I started using Chuck's DB context delegate everything has worked just fine. I have not yet upgraded to SQLServer 2005. I can't get away from it, so I've learned to "embrace" it. The dirty feeling goes away,

Re: SQL Server questions

On Nov 19, 2007, at 6:56 AM, Randy Wigginton wrote: Does anyone have experience with connecting new world order WO to a sql server database? You are referring to Microsoft SQL Server or a generic "a sql server database"? I am using MS SQL on the project I am working on now. You may run

Re: SQL Server questions

I've use the jtds jdbc lib and the freetds command line tool in the past. http://jtds.sourceforge.net/ http://www.freetds.org/ I don't have any experience migrating the entire db though. But how hard could that be? ;-) -steve On Mon, 19 Nov 2007, Randy Wigginton wrote: Does anyone have

Re: SQL Server questions

I have similar situation where I need to periodically extract a few gigs of data out out umpteen MS SQL Server tables and put it into MySQL. I tried various different migration tools and had the most success with SQLYog ( http://www.webyog.com/en/ ). It's commercial software ($100, less if

Re: SQL Query Generation

Personally, I would use the CountFetcher class from Jerry Walker...I use it all the time. You give it a fetch specification, and it comes back with the number of rows that would be returned: http://wocode.com/WOCode/Files/CountFetcher.java Ken On Aug 11, 2007, at 6:44 AM, shaun wrote: Mi

Re: SQL Query Generation

Michael Xenakis wrote: All - I'm trying to solve a lil' problem here. The semi-short story is that prior to doing a fetch, I'm going to do a raw SQL fetch to determine how many rows would be returned - i.e., I'll do a "select count(*)" based on the search parameters. If the count is grea

Re: SQL Query Generation

On 10.08.2007, at 16:12, Michael Xenakis wrote: Unfortunately, the where clause being generated by .whereClauseString() is parameterized, e.g., SELECT COUNT(*) FROM PLAYLIST t0, CONTENT_PROVIDER T1 WHERE (((t0.FIRST_PRODUCTION_RELEASE is not ? AND t0.LAST_PRODUCTION_RELEASE is ?) AND T1.CON

Re: SQL Query Generation

WOnder has utility methods for getting a SQL COUNT(*) for a fetch spec and/or qualifier. In EOUtilities.java ... You could use WOnder or use its code. On Aug 10, 2007, at 6:12 PM, Michael Xenakis wrote: All - I'm trying to solve a lil' problem here. The semi-short story is that prior to

Re: sql for qualifier that spans two databases

On Jul 18, 2007, at 7:04 PM, Art Isbell wrote: Instead, you'll need ask EOF to fetch from the join entity(s) in one DB and do the join in your Java code by fetching from the join entity(s) in the other DB based on the objects fetched from the first DB. Yep! That's what we came to suspect a

Re: sql for qualifier that spans two databases

On Jul 18, 2007, at 4:54 AM, Travis Britt wrote: Hoping someone can quickly tell me if this should be possible without writing my own SQL. Two databases. Two EOModels, one for each database. A to-one relationship from an entity in one model to an entity in the other. An EOQualifier is bu

Re: sql for qualifier that spans two databases

On 7/18/07, Travis Britt <[EMAIL PROTECTED]> wrote: Hoping someone can quickly tell me if this should be possible without writing my own SQL. Two databases. Two EOModels, one for each database. A to-one relationship from an entity in one model to an entity in the other. That is no problem u

Re: SQL Logging in wonder.

Thanks. I needed to bump the log4j.logger.er log level up to get the extra detail. On 07/06/2007, at 11:59 PM, Guido Neitzer wrote: On 07.06.2007, at 05:06, Q wrote: In wonder how does one enable logging of the number of rows being returned from an sql query? By activating SQL logging

  1   2   >