Re: [OT] Frontbase Export/Dump
Re: [OT] Frontbase Export/Dump
- Subject: Re: [OT] Frontbase Export/Dump
- From: "Daniele Corti" <email@hidden>
- Date: Mon, 12 May 2008 12:15:10 +0200
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@hidden>:
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?
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to
email@hidden
--
Daniele Corti
AIM: S0CR4TE5
Messenger:
email@hidden--
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden