如何調出cloudscape資料庫的圖形管理介面及相關問題

來源:互聯網
上載者:User
資料|資料庫|圖形|問題
如何調出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就會是白板一塊。


相關文章

Beyond APAC's No.1 Cloud

19.6% IaaS Market Share in Asia Pacific - Gartner IT Service report, 2018

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。