The following sections are some common faults and tips. For a complete list of troubleshooting tips, please visit sources that are listed in the Product Support section of the Appendix.
If the Virtuoso DBMS server won't start, there could be 3 reasons.
When the DBMS server starts up, it creates a file in the bin directory named "virtuoso.lck". If this file is present, a new instance cannot run. If you are certain that the DBMS isn't running, then you can delete the virtuoso.lck file and then start it from the Services icon in the Control Panel, or by using the command "virtuoso +service start" in the virtuoso directory. You can check if virtuoso is running from the Task Manager, and you can shut it down using the command "virtuoso +service stop".
![]() |
Figure: 3.14.2.1. Command Prompt |
Whenever a database object is referenced, all names (schema, owner, table and column) should preferably be placed in double-quotes, exactly as it appears in the catalog. This way, the object name in the Virtuoso catalog will be correctly referenced. If names are not quoted, then the case of the object name will be determined by the value of the CaseMode property in the virtuoso.ini file. The default mode is case sensitive (CaseMode = 1). This means that all unquoted objects names will be processed exactly as supplied. This may result in messages indicating that an object could not be found. If CaseMode is set to 0, then all objects will be translated to upper case. When using certain tools such as Microsoft Query (which is used by Microsoft Excel) object references are not enclosed in quotes. As a result, it may be necessary to change from CaseMode=1 to CaseMode=0, or vise-verse before starting up the DBMS if the application that you use does not enclose identifiers in double quotes. Virtuoso itself will always use the object names that were identified when the table was attached when it communicates with a back-end database.
The following table describes when an identifier name will match the catalog entry.
CaseMode | Identifiers in Virtuoso Catalog | Unquoted Identifiers In Query | Result |
---|---|---|---|
0 - Case Sensitive | Lower/Mixed case | Lower/Mixed case | Will match |
0 - Case Sensitive | Lower/Mixed case | Upper case | Will not match |
0 - Case Sensitive | Upper case | Lower/Mixed case | Will not match |
0 - Case Sensitive | Upper case | Upper case | Will match |
1 - Translate to Upper | Lower/Mixed case | Lower/Mixed case | Will not match |
1 - Translate to Upper | Lower/Mixed case | Upper case | Will not match |
1 - Translate to Upper | Upper case | Lower/Mixed case | Will match |
1 - Translate to Upper | Upper case | Upper case | Will match |
![]() |
Figure: 3.14.3.2. Virtuoso.ini file in notepad |
Previous
Third-Party Runtime Typing, Hosting & User Defined Types |
Chapter Contents |
Next
Contents of Sample ODBC & JDBC Applications |