Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
derby_notes [2013/09/24 10:27]
root [Network Configuration]
derby_notes [2013/09/24 10:28] (current)
root [Network Configuration]
Line 1: Line 1:
-Back [[Home]] 
- 
-Back [[Home]] 
- 
-== Derby Configuration == 
- 
-the dev version way that is insecure ​ 
- 
-<code java> 
-java -cp derbynet.jar org.apache.derby.drda.NetworkServerControl start -h localhost -noSecurityManager 
-</​code>​ 
- 
- 
-== Connecting == 
- 
-Start an interactive client 
-<​code> ​ 
-java -jar derbyrun.jar ij 
-</​code>​ 
- 
- 
-<​code>​ 
-> CONNECT '​jdbc:​derby://​localhost:​1527/​sample'​ USER '​Admin'​ PASSWORD '​Admin';​ 
-</​code>​ 
- 
 == Network Configuration == == Network Configuration ==
 Copy and modify the example **server.policy** found at demo/​templates/​server.policy. Copy and modify the example **server.policy** found at demo/​templates/​server.policy.
Line 94: Line 69:
 java -Djava.security.manager -Djava.security.policy=myCustomized.policy org.apache.derby.drda.NetworkServerControl start -h localhost java -Djava.security.manager -Djava.security.policy=myCustomized.policy org.apache.derby.drda.NetworkServerControl start -h localhost
 </​code>​ </​code>​
-== String Functions == 
- 
-|  <​nowiki>​||</​nowiki>​ | (p.description<​nowiki>​||</​nowiki>​v.vendorName) | The concatenation operator combines two values into a new character string. If both values are of type CHAR, the result is also of type CHAR. If the values are of type VARCHAR or a numerical data type, which can be converted to type VARCHAR, the resulting type is VARCHAR. | 
-| LCASE, or LOWER  | LCASE(p.description) | Returns a character string in which all alphabetical characters in the input value have been converted to lowercase. |  
-| LENGTH | LENGTH(p.description) |Returns the number of characters in the input value. Noncharacter data is implicitly converted to a character string. |  
-| LOCATE | LOCATE('​beach',​p.description) | Returns the starting location for the first occurrence of a substring in a search string, or zero if the substring isn't found. The first argument is the substring, the second argument is the search string, and an optional starting position can be supplied as a third argument. |  
-| RTRIM | RTRIM(p.description) | Returns a character string in which all spaces at the end of the input value have been removed. |  
-| LTRIM | LTRIM(p.description) | Returns a character string in which all spaces at the start of the input value have been removed. |  
-| SUBSTR | SUBSTR(p.description,​ 1, 4) | Returns part of an input character string as a VARCHAR, starting at the location specified and continuing until the end of the character string, or to the location specified by the optional third argument. If the starting location is positive, it's relative to the beginning of the string; if it's negative, it's relative to the end of the string. |  
-| UCASE, or UPPER | UCASE(p.description) | Returns a character string in which all alphabetical characters in the input value have been converted to uppercase. |  
- 
-== Stored Procedures ==  
-* [[http://​www.javacodegeeks.com/​2013/​09/​java-stored-procedures-in-java-db.html?​utm_source=feedburner&​utm_medium=feed&​utm_campaign=Feed%3A+JavaCodeGeeks+%28Java+Code+Geeks%29 | Stored procedures]] 
-== Starting as a Network Server ==  
- 
-* the simple way  
-<​code>​ 
-java -jar lib/​derbyrun.jar server start -h 0.0.0.0 & 
-</​code>​ 
- 
-the more managed way  
- 
-<​code>​ 
-java -­Djava.security.manager ​ -­Djava.security.policy=nsrv.policy ​ org.apache.derby.drda.NetworkServerControl start 
-</​code>​ 
- 
-== Comand Line Console ==  
- 
-<​code>​ 
-   ​ij>​ connect '​jdbc:​derby://​localhost:​1527/​MyDbTest;​create=true';​ 
-</​code>​ 
- 
- 
-== Links and Ref == 
-* [[http://​db.apache.org/​derby/​manuals/​index.html#​docs_10.10 | Derby Manual]] 
-* Some good [[http://​javadb.net/​customizing-the-network-server'​s-security-policy.html | derby documentation]] 
 
derby_notes.txt · Last modified: 2013/09/24 10:28 by root
 
RSS - 200 © CrosswireDigitialMedia Ltd