Hi List,
I'm trying to migrate a DB from remote to my pc using
ERXJDBCUtilities._copyDatabaseDefinedByEOModelAndConnectionDictionaryToDatabaseWithConnectionDictionary
but I'm getting this error
ERROR er.extensions.ERXJDBCUtilities - could not commit destCon
java.sql.SQLException: Syntax error 61. Expected Identifier not found.
at
com.frontbase.jdbc.FBJErrorMetaData.errorMessageAtIndex(FBJErrorMetaData.java:162)
the connections dictionaries are (usernames and password are corrects):
sourceDict.setObjectForKey("jdbc:FrontBase://lanserver1/GW_SUPPORT", "URL");
sourceDict.setObjectForKey("com.frontbase.jdbc.FBJDriver",
"driver");
sourceDict.setObjectForKey(Boolean.FALSE.toString(), "autoCommit");
sourceDict.setObjectForKey(Boolean.TRUE.toString(), "readOnly");
sourceDict.setObjectForKey(Boolean.TRUE.toString(), "quote");
destDict.setObjectForKey("jdbc:FrontBase://localhost/GW_SUPPORT", "URL");
destDict.setObjectForKey("com.frontbase.jdbc.FBJDriver", "driver");
destDict.setObjectForKey(Boolean.FALSE.toString(), "autoCommit");
destDict.setObjectForKey(Boolean.FALSE.toString(), "readOnly");
destDict.setObjectForKey(Boolean.FALSE.toString(), "quote");
I was thinging to change the quote to TRUE in the dest dict, but I get this
error:
ERROR er.extensions.ERXJDBCUtilities - could not commit destCon
java.sql.SQLException: Semantic error 116. Referenced TABLE -
_SYSTEM.GWS_ACTIVATION - does not exist.
at
com.frontbase.jdbc.FBJErrorMetaData.errorMessageAtIndex(FBJErrorMetaData.java:162)
of course, the TABLE exits, but now I start to think that something of
really problematic occurs using FrontBase under leopard, I say this because
I cannot imports backups made on others machines on my leoparded iMac, when
on other Tiger machines it work without problems.
Does anyone know if there are problems with frontbase under leopard?
2008/5/12 Guido Neitzer <[EMAIL PROTECTED]>:
> On 11.05.2008, at 17:45, Joshua Paul wrote:
>
> The Frontbase site is not available right now, so I figured I'd turn here
> > for help...
> >
> > Does anyone know how to dump data out of one FB database for use in
> > another?
> >
>
> I'd say your best bet is:
>
>
> ERXJDBCUtilities._copyDatabaseDefinedByEOModelAndConnectionDictionaryToDatabaseWithConnectionDictionary
>
> to transfer the data. It's documented how to use it.
>
> Some hints:
>
> - create destination database without foreign key constraints
> - transfer data
> - create foreign key constraints
>
> Helped me to transfer from FrontBase to PostgreSQL a couple of years ago.
>
> 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/ildenae%40gmail.com
>
> This email sent to [EMAIL PROTECTED]
>
--
Daniele Corti
AIM: S0CR4TE5
Messenger: [EMAIL PROTECTED]
--
Computers are like air conditioners -- they stop working properly if you
open
WINDOWS
--
What about the four lusers of the apocalypse? I nominate:
"advertising", "can't log in", "power switch" and "what backup?"
--Alistair Young
_______________________________________________
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]
