如何調出cloudscape數據庫(數據庫培訓 數據庫認證 )的圖形管理界面及相關問題你在命令行方式下敲入java COM.cloudscape.tools.cvIEw很可能會出現錯誤。什麼原因呢?第一、你要看看你的jdk版本對不對,是不是1.3.1_02以上或者1.4的。第二、關鍵中的關鍵,原來sun的J2EE裡的cloudvIEw是不能在他附帶的cloudscape4.0.6下工作的(真不知道sun在搞什麼東東 :))這裡是在ibm網站上的一句原話:The Java 2 SDK, Enterprise Edition v. 1.3.1 includes Cloudscape 4.0.6 but includes a version of CloudvIEw which will not function with the 4.0.6 system。所以同志門就自己去下一個吧!
常見錯誤:Java.lang.ClassNotFoundException: COM.cloudscape.core.JDBCDriver英文解釋:To "find" the missing driver, you need to add to the CLASSPATH the cloudscape jar files RmiJdbc.jar , cloudclient.jar and system/cloudscape.jar which are located under the directory %J2EE_HOME%\lib\cloudscape\ So, under UNIX you should execute: setenv CLASSPATH .:$J2EE_HOME/lib/cloudscape/system/cloudscape.jar:$J2EE_HOME/lib/cloudscape/cloudclIEnt.jar:$J2EE_HOME/lib/cloudscape/RmiJdbc.jar
under Windows, you should add to CLASSPATH the following %J2EE_HOME%\lib\cloudscape ystem\cloudscape.jar;%J2EE_HOME%\lib\cloudscape\cloudclIEnt.jar;%J2EE_HOME%\lib\cloudscape\RmiJdbc.jar
If you will, you can also look at "cloudscape" command (cloudscape.bat under Windows) what jar files it adds to its classpath.
We'd like also to give you a hint regarding missing classes. If some class cannot be loaded, even though it should be somewhere, this indicates that the class is not "visible" in classpath for a class loader. To find the class, you should inspect JAR files under lib directory of a Java environment by using "jar -tvf file.jar" or winzip. For example, to find the driver under UNIX one should execute in the directory $J2EE_HOME/lib/cloudscape/system/ the following jar tvf cloudscape.jar | grep JDBCDriver
In particular , the driver class COM.cloudscape.core.JDBCDriver is packaged in %J2EE_HOME%\lib\cloudscape ystem\cloudscape.jar (under UNIX in $J2EE_HOME/lib/cloudscape/system/cloudscape.jar)
中文解釋:重點是設置對RmiJdbc.jar , cloudclIEnt.jar and system/cloudscape.jar
幾點注意的地方:
1.修改完resource.propertIEs,需要重起J2EE server2.使用cloudvIEw時,cloudscape數據庫必須關閉,設置完以後再重起數據庫3.deploy修改默認SQL的時候,點畫面左邊的SQL名稱,右邊出現SQL文,修改完畢之後必須再點一下左邊的這個SQL名稱,這樣表示更新了,如果直接去點別的SQL名稱,就會亂掉。看到前面有的哥們兒說改一下就按一下OK,否則會亂,其實不必。5.不知道cloudscape數據庫怎麼樣,反正Oracle中在SQL中不加""就會忽略大小寫。比如:select * from employee where employeeID='123'和select * from EMPLOYEE where EMPLOYEEID='123'是一樣的,但是deploy時默認的SQL中是有""的,這樣select * from "employee" where "employeeID"='123'就和select * from "EMPLOYEE" where "EMPLOYEEID"='123'不一樣了。前面有的朋友說字段大小寫的問題估計就在此。4.deploy結束之後需要save,否則JSP中輸入ID,點submit就會是白板一塊。