ij problem?
Hi All, I'm trying to create my initial database tables using ij. here's what I get: C:\java -Dij.protocol=jdbc:derby: org.apache.derby.tools.ij ij version 10.1 ij connect 'c:\db-derby-10.1.2.1-bin\data\NetMgt;create=true'; ij run 'c:\mgt\sql\tablex1.sql'; ij CREATE TABLE users (user_id INTEGER PRIMARY KEY, first_name VARCHAR(20), last_name VARCHAR(20), user_level INTEGER, user_name VARCHAR(20), user_password VARCHAR); ERROR 42X01: Syntax error: Encountered ) at line 1, column 161. ij Come on! I can't find anything wrong with that, and I can't find any more info on the error message in the docs. In fact it never mentions 'ERROR 42X01'.. No matter how I try to modify the SQL statement, it doesn't like it. I did find that if I manually type it in, and leave off the last column, it doesn't complain.. I'm using: C:\java -version java version 1.5.0 Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0-b64) Java HotSpot(TM) Client VM (build 1.5.0-b64, mixed mode) And Windows XP. Thanks, Joe Siebenmann __ Yahoo! DSL Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com
RE: ij problem?
Perhaps you made a typo when you posted this but from what I see you did not specify the length of the user_password field you simply indicated the datatype VARCHAR. -Samer -Original Message- From: Joe Siebenmann [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 06, 2005 12:07 PM To: derby-user@db.apache.org Subject: ij problem? Hi All, I'm trying to create my initial database tables using ij. here's what I get: C:\java -Dij.protocol=jdbc:derby: org.apache.derby.tools.ij ij version 10.1 ij connect 'c:\db-derby-10.1.2.1-bin\data\NetMgt;create=true'; ij run 'c:\mgt\sql\tablex1.sql'; ij CREATE TABLE users (user_id INTEGER PRIMARY KEY, first_name VARCHAR(20), last_name VARCHAR(20), user_level INTEGER, user_name VARCHAR(20), user_password VARCHAR); ERROR 42X01: Syntax error: Encountered ) at line 1, column 161. ij Come on! I can't find anything wrong with that, and I can't find any more info on the error message in the docs. In fact it never mentions 'ERROR 42X01'.. No matter how I try to modify the SQL statement, it doesn't like it. I did find that if I manually type it in, and leave off the last column, it doesn't complain.. I'm using: C:\java -version java version 1.5.0 Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0-b64) Java HotSpot(TM) Client VM (build 1.5.0-b64, mixed mode) And Windows XP. Thanks, Joe Siebenmann __ Yahoo! DSL - Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com
Re: ij problem?
Hi Joe,I think your problem is that VARCHAR needs a length, so the ")" in the "user_password VARCHAR)" (at position 161) was unexpected. It expected (20) before the closing ")".Best,CraigOn Dec 6, 2005, at 10:06 AM, Joe Siebenmann wrote:Hi All,I'm trying to create my initial database tables using ij.here's what I get:C:\java -Dij.protocol=jdbc:derby: org.apache.derby.tools.ijij version 10.1ij connect 'c:\db-derby-10.1.2.1-bin\data\NetMgt;create=true';ij run 'c:\mgt\sql\tablex1.sql';ij CREATE TABLE users (user_id INTEGER PRIMARY KEY, first_nameVARCHAR(20), last_name VARCHAR(20), user_level INTEGER, user_nameVARCHAR(20), user_password VARCHAR);ERROR 42X01: Syntax error: Encountered ")" at line 1, column 161.ijCome on! I can't find anything wrong with that, and I can'tfind any more info on the error message in the docs. In factit never mentions 'ERROR 42X01'..No matter how I try to modify the SQL statement, it doesn'tlike it. I did find that if I manually type it in, and leave offthe last column, it doesn't complain..I'm using:C:\java -versionjava version "1.5.0"Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0-b64)Java HotSpot(TM) Client VM (build 1.5.0-b64, mixed mode)And Windows XP.Thanks,Joe Siebenmann __ Yahoo! DSL – Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com Craig Russell Architect, Sun Java Enterprise System http://java.sun.com/products/jdo 408 276-5638 mailto:[EMAIL PROTECTED] P.S. A good JDO? O, Gasp! smime.p7s Description: S/MIME cryptographic signature
Re: ij problem?
Craig L Russell wrote (2005-12-06 10:31:57): Hi Joe, I think your problem is that VARCHAR needs a length, so the ) in the user_password VARCHAR) (at position 161) was unexpected. It expected (20) before the closing ). For the record: VARCHAR without length is a non-standard feature allowed by some databases. Derby requires length and is thus compliant with the SQL standards (all of them). Bernt -- Bernt Marius Johnsen, Database Technology Group, Sun Microsystems, Trondheim, Norway pgpyfcGxl5uVd.pgp Description: PGP signature
Re: Get-together at ApacheCon
David W. Van Couvering wrote (2005-12-06 11:11:12): Hi, all. Many of us will be at ApacheCon in San Diego next week. There is a Derby BoF from 9:30 - 10:30 on Tuesday night. I was thinking that perhaps those of us who are there could meet for an informal, Dutch Treat (meaning we all pay for our own meals) dinner before this. If you're interested and can commit to being there, let me know, and I'll look into getting a reservation. I'll close the polls in 48 hours. +1 -- Bernt Marius Johnsen, Database Technology Group, Sun Microsystems, Trondheim, Norway pgpxcfUiErpj8.pgp Description: PGP signature
Derby start up problems on linux.
I'm using Linux Fedora core 4 and working through the eclipse derby plugin help section. I start the server from within eclipse and it seems ok. I getServer is ready to accept connections on port 1527.When I run netstat, port 1527 is in the LISTEN mode. Also I can see the process active.using IJ I get the following. ij connect 'jdbc:derby://localhost:1527/myDB;create=true;user=me;password=mine'; ERROR (no SQLState): java.security.PrivilegedActionException : Error opening socket to server localhost on port 1527 with message : nullWhen I look at the derby.log there is no evidence of a connection. When I try to do a shutdown I get Could not connect to Derby Network Server on the host localhost, port 1527.I have also tried t he ping argument in NetworkServerControl with no success.I have used telnet to make a connection, and when I submit a message I get a protocol failure which makes sense. The failure also shows up in the log file.I'm open to suggestions. Thanks.
Re: Derby start up problems on linux.
Hi Mike,This may not be related, but I have seen problems on Linux when starting the network server using the word "localhost". From within Eclipse, bring up the properties for the project you've added the plug-ins to and set the Apache Derby Network Server Host value to the ip address of your linux host (instead of localhost.)Restart the server and see if this works.Thanks,Susan MIKE SCHWEIGER [EMAIL PROTECTED] wrote:I'm using Linux Fedora core 4 and working through the eclipse derby plugin help section. I start the server from within eclipse and it seems ok. I getServer is ready to accept connections on port 1527.When I run netstat, port 1527 is in the LISTEN mode. Also I can see the process active.using IJ I get the following.ij connect'jdbc:derby://localhost:1527/myDB;create=true;user=me;password=mine';ERROR (no SQLState): java.security.PrivilegedActionException : Erroropening socket to server localhost on port 1527 with message : nullWhen I look at the derby.log there is no evidence of a connection. When I try to do a shutdown I get Could not connect to Derby Network Server on the host localhost, port 1527.I have also tried t he ping argument in NetworkServerControl with no success.I have used telnet to make a connection, and when I submit a message I get a protocol failure which makes sense. The failure also shows up in the log file.I'm open to suggestions. Thanks.
Re: Derby start up problems on linux.
On Tuesday 06 December 2005 4:46 pm, Susan Cline wrote: If you're looking at localhost, then try the IP address of 127.0.0.1 Hi Mike, This may not be related, but I have seen problems on Linux when starting the network server using the word localhost. From within Eclipse, bring up the properties for the project you've added the plug-ins to and set the Apache Derby Network Server Host value to the ip address of your linux host (instead of localhost.) Restart the server and see if this works. Thanks, Susan MIKE SCHWEIGER [EMAIL PROTECTED] wrote: I'm using Linux Fedora core 4 and working through the eclipse derby plugin help section. I start the server from within eclipse and it seems ok. I get Server is ready to accept connections on port 1527. When I run netstat, port 1527 is in the LISTEN mode. Also I can see the process active. using IJ I get the following. ij connect 'jdbc:derby://localhost:1527/myDB;create=true;user=me;password=mine'; ERROR (no SQLState): java.security.PrivilegedActionException : Error opening socket to server localhost on port 1527 with message : null When I look at the derby.log there is no evidence of a connection. When I try to do a shutdown I get Could not connect to Derby Network Server on the host localhost, port 1527. I have also tried t he ping argument in NetworkServerControl with no success. I have used telnet to make a connection, and when I submit a message I get a protocol failure which makes sense. The failure also shows up in the log file. I'm open to suggestions. Thanks.
Re: Get-together at ApacheCon
David W. Van Couvering wrote: Hi, all. Many of us will be at ApacheCon in San Diego next week. There is a Derby BoF from 9:30 - 10:30 on Tuesday night. I was thinking that perhaps those of us who are there could meet for an informal, Dutch Treat (meaning we all pay for our own meals) dinner before this. If you're interested and can commit to being there, let me know, and I'll look into getting a reservation. I'll close the polls in 48 hours. David Sure, count me in. -jean
Re: [VOTE] Apache Derby logo
David W. Van Couvering wrote: 10. [X] (these all belong together...) http://issues.apache.org/jira/secure/attachment/12321022/derby_logo_only.jpg http://issues.apache.org/jira/secure/attachment/12321023/derby_with_text.jpg http://issues.apache.org/jira/secure/attachment/12321055/roger_full_showcase.jpg -jean
Re: [VOTE] Apache Derby logo
Entry 10 is good, but the hat does not look like a Derby hat, hence 9. [X ] http://issues.apache.org/jira/secure/attachment/20155/derby4.jpg Regards, Rajesh
Re: Get-together at ApacheCon
+1 Bernt M. Johnsen wrote: David W. Van Couvering wrote (2005-12-06 11:11:12): Hi, all. Many of us will be at ApacheCon in San Diego next week. There is a Derby BoF from 9:30 - 10:30 on Tuesday night. I was thinking that perhaps those of us who are there could meet for an informal, Dutch Treat (meaning we all pay for our own meals) dinner before this. If you're interested and can commit to being there, let me know, and I'll look into getting a reservation. I'll close the polls in 48 hours. +1
[VOTE] Apache Derby logo
I like the Derby with text logo...very nice !!10. [X] (these all belong together...)http://issues.apache.org/jira/secure/attachment/12321022/derby_logo_only.jpg http://issues.apache.org/jira/secure/attachment/12321023/derby_with_text.jpg http://issues.apache.org/jira/secure/attachment/12321055/roger_full_showcase.jpgGrant Hutchison