I spent 7 days trying install dbAnywhere under Windows-95 and JDK (Java Development Kit) 1.0.2, and another afternoon redoing it for JDK 1.1.3 and about an hour for database development edition. In the interest of saving you a little time, here are the magic incantations I discovered. I can’t guarantee all these steps are necessary, but they are sufficient. These instructions were written for the version of dbAnywhere that comes with Visual Café Database Development Edition 2.5a.
Unfortunatey dbAnywhere has been discontinued. Visual Cafe now uses the standard less intelligent JDBC interface.
C:\sqlany\win32\dbinit.exe -p1024 mydatabase.dbNone of the documented Sybase techniques for creating a database work:
start "sqlany" dbeng50.exe C:\MyDir\mydatabase.db -b -c 17000For Win95 you start the database engine like this:
|CREATE TABLE PEOPLE|
|(ACCT||integer NOT NULL,|
|SURNAME||char(30) NOT NULL,|
|GIVEN_NAME||char(30) NOT NULL,|
|PRIMARY KEY (ACCT));|
SELECT table_name from SYS.SYSTABLE
LOAD TABLE PEOPLE FROM 'C:\MyOld\PEOPLE.LOD';You can then check that the data actually loaded with statements like this:
SELECT COUNT(*) FROM PEOPLE;or
SELECT * FROM PEOPLE;
In a simple case, here is how Symantec’s proprietary dbAnywhere/SQL interface works. The interface is quite a bit more advanced than JDBC or JSQL (Java Standard Query Language). There is considerable detailed documentation, but no overview of how it all fits together.
The component itself is no longer responsible for notifying dbAnywhere when the value changes or even of tracking if the screen value has changed via keystroke activity. dbAnywhere will invoke theComponent.getData or setData when it wants to using the ProjectionBeanHelper object which has a pointer to the component itself. This is quite a simplication for dbAware components over JDK 1.0.2.
available on the web at:
optional Replicator mirror
Please email your feedback for publication, letters to the editor, errors, omissions, typos, formatting errors, ambiguities, unclear wording, broken/redirected link reports, suggestions to improve this page or comments to Roedy Green : . If you want your message, your name or email kept confidential, not considered for public posting, please explicitly specify that. Unless you state otherwise, I will treat your message as a letter to the editor that I may or may not publish in the feedback section. After that, it will be too late to retract it. If you disagree with something I said, especially when sending an ad-hominem attack, a rant composed mainly of obscenities or a death threat, please quote the offending passage and cite the web page where you found it, tell me why you think it is wrong, and, if possible, provide some supporting evidence. I can’t very well fix erroneous or ambiguous text if I can’t find it.
Your face IP:[184.108.40.206]
|Feedback||You are visitor number 16,077.|