Definetly its not working at all. not even iwth the example from http://wiki.objectstyle.org/confluence/display/WOL/Using+Entity+Modeler . Im gonan make a clean install of everyting and see

Regards

Gus
On Mar 11, 2008, at 9:16 PM, Chuck Hill wrote:


On Mar 11, 2008, at 7:13 PM, Gustavo Pizano wrote:

I dont get that first line when I generate the sql

so the problem is soemwhere else... Im following the instrucciont form the manual.. whats the url you have?

At this point, I have no idea what it is that you are doing. :-)


Try following these instructions:

http://wiki.objectstyle.org/confluence/display/WOL/Using+Entity +Modeler

Chuck


On Mar 11, 2008, at 9:00 PM, Chuck Hill wrote:

Are you just copying _part_ of the SQL out of Entity Modeler? What you have below gives me the same error that it give you. BUT if I add the first line that Entity Modeler generates:

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, LOCKING PESSIMISTIC;

Then it works:

--
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, LOCKING PESSIMISTIC;

CREATE TABLE "DisplayBoard" (
        "bigImage" BLOB,
"creationDate" TIMESTAMP CONSTRAINT NOT_NULL_DisplayBoard__creationDate NOT NULL,
        "description" CLOB,
        "eoid" INTEGER CONSTRAINT NOT_NULL_DisplayBoard__eoid NOT NULL,
"lastModifiedDate" TIMESTAMP CONSTRAINT NOT_NULL_DisplayBoard__lastModifiedDate NOT NULL,
        "mimeType" VARCHAR(20),
        "thumbnail" BLOB,
"title" VARCHAR(200) CONSTRAINT NOT_NULL_DisplayBoard__title NOT NULL
);

SET UNIQUE = 1000000 FOR "DisplayBoard";

ALTER TABLE "DISPLAYBOARD" ADD CONSTRAINT PRIMARY_KEY_DisplayBoard_eoid PRIMARY KEY ("EOID") NOT DEFERRABLE INITIALLY IMMEDIATE;
--

That is a bad error message, but what it means is that you have the wrong isolation level (I think) for that type of statement.

Chuck



On Mar 11, 2008, at 6:51 PM, Gustavo Pizano wrote:

This is the sql that EM is generation

CREATE TABLE "DisplayBoard" (
        "bigImage" BLOB,
"creationDate" TIMESTAMP CONSTRAINT NOT_NULL_DisplayBoard__creationDate NOT NULL,
        "description" CLOB,
        "eoid" INTEGER CONSTRAINT NOT_NULL_DisplayBoard__eoid NOT NULL,
"lastModifiedDate" TIMESTAMP CONSTRAINT NOT_NULL_DisplayBoard__lastModifiedDate NOT NULL,
        "mimeType" VARCHAR(20),
        "thumbnail" BLOB,
"title" VARCHAR(200) CONSTRAINT NOT_NULL_DisplayBoard__title NOT NULL
);

SET UNIQUE = 1000000 FOR "DisplayBoard";

ALTER TABLE "DISPLAYBOARD" ADD CONSTRAINT PRIMARY_KEY_DisplayBoard_eoid PRIMARY KEY ("EOID") NOT DEFERRABLE INITIALLY IMMEDIATE;

the verification says there are no error


Gus

On Mar 11, 2008, at 8:33 PM, Chuck Hill wrote:

Unzip it and replace the FrontBasePlugIn.framework that is on your app's classpath.


On Mar 11, 2008, at 6:27 PM, Gustavo Pizano wrote:

Should I just replace the FrontBase.plugin folder?

Gus

On Mar 11, 2008, at 7:55 PM, Chuck Hill wrote:

Here is mine, try it.

<FBPlugin.tgz>

On Mar 11, 2008, at 5:28 PM, Gustavo Pizano wrote:

This is what I have

rw-r--r-- 1 GustavPicora staff 45241 Apr 18 2006 frontbaseplugin.jar
-rw-r--r--@ 1 root          staff  11907 Mar 10 00:22 src.jar


Gus
On Mar 11, 2008, at 12:10 PM, Chuck Hill wrote:

Does yours look like this (might be in /Library):

ls -l ~/Library/Frameworks/FrontBasePlugIn.framework/ Resources/Java/
total 72
-rw-r--r-- 1 chuck wheel 23392 Feb 28 20:06 FrontBasePlugIn.jar
-rw-r--r--  1 chuck  wheel  11446 Feb 28 20:06 src.jar

Chuck


On Mar 11, 2008, at 10:02 AM, Gustav P wrote:

Hello, well the problme persist, I keep trying to execute the SQL but the IO conection error still is comming out. The plugin FrontBase plugin is the one I have checked. is there any other?


Regards
Gustavo



On Tue, Mar 11, 2008 at 11:56 AM, Guido Neitzer <[EMAIL PROTECTED] > wrote:
On 11.03.2008, at 15:03, Gustavo Pizano wrote:

> Ok so what to do?
> Change the db manager?

I was only saying that the FrontBasePlugIn from Project WOnder has no problem with WO 5.4. If you installed Project WOnder and included the plugin from /Library/Frameworks it should be the one from Wonder.

I haven't followed the rest of the discussion, so I don't know much
about the rest of the problem.

cug

--
http://www.event-s.net


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected] )
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net

This email sent to [EMAIL PROTECTED]

--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects








--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects








--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects







--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects








--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects






_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to