How to pull out the graphical management interface of Cloudscape database and related problems

Data | database | graphics | questions
How to bring up the graphical management interface of Cloudscape database and related problems you can type Java COM.cloudscape.tools.cview at the command line. What's the reason? First, you want to see your JDK version right, is not 1.3.1_02 above or 1.4. Second, the key of the key, the original sun in the Java EE Cloudview is not in his accompanying cloudscape4.0.6 work (I really do not know what Sun is doing:) Here is a quote on the IBM website: the Java 2 SDK, Enterprise Edition v. 1.3.1 includes Cloudscape 4.0.6 but includes a version of Cloudview which won't function with the 4.0.6 system. So the gay door goes to the next one!

Common error: Java.lang.ClassNotFoundException:COM.cloudscape.core.JDBCDriver English explanation: to "found" 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.: $J 2ee_home/lib/cloudscape /system/cloudscape.jar: $J 2ee_home/lib/cloudscape/cloudclient.jar: $J 2ee_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 would, you can also look at the "cloudscape" command (Cloudscape.bat under Windows) What jar files it adds to its CLASSP Ath.

We like also to give you a hint regarding missing classes. If Some class cannot be loaded, even though it should to be somewhere, this indicates that the class isn't "visible" in Clas Spath for a class loader. To find the class, 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 $J 2ee_home/lib/cloudscape/system/the Follo Wing Jar TVF Cloudscape.jar | grep jdbcdriver

In particular, the driver class COM.cloudscape.core.JDBCDriver be packaged in%j2ee_home%\lib\cloudscape Ystem\cloudscap E.jar (under UNIX in $J 2ee_home/lib/cloudscape/system/cloudscape.jar)

The emphasis is set on Rmijdbc.jar, Cloudclient.jar and System/cloudscape.jar

Points to note:

1. Modify the resource.properties, need to restart the Java EE Server2. When using Cloudview, the Cloudscape database must be shut down, set up to restart the database 3.deploy modify the default SQL, the left side of the image of the SQL name, the right side of the SQL, after the modification must point to the left of this SQL name, so that the update, If you go directly to the other SQL name, it will be out of order. See the front some of the brothers said to change the click OK, otherwise it will be messy, in fact, not necessarily. 5. Do not know how the Cloudscape database, anyway, Oracle in SQL without "" "will ignore the case." For example: SELECT * FROM employee where employeeid= ' 123 ' and select * from employee where employeeid= ' 123 ' are the same, but the default SQL in deploy is "" So that the SELECT * from "Employee" where "employeeID" = ' 123 ' is different from the SELECT * from "Employee" where "employeeID" = ' 123 '. Some of the previous friends said that the problem of field capitalization is estimated here. 4.deploy after the end of the need to save, or JSP input ID, point submit will be a whiteboard piece.