db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pranav Aggarwal <pranav.aggar...@altair.com>
Subject Re: derby-user Digest 9 Feb 2007 18:46:30 -0000 Issue 466
Date Tue, 13 Feb 2007 04:21:13 GMT
derby-user-digest-help@db.apache.org wrote:
> derby-user Digest 9 Feb 2007 18:46:30 -0000 Issue 466
>
> Topics (messages 6126 through 6130):
>
> Re: connection to derby failed
> 	6126 by: Pranav Aggarwal
> 	6127 by: Rajesh Kartha
> 	6128 by: Thomas J. Taylor
>
> Problem with create table in Derby 10.2.2.0
> 	6129 by: Leo Alberto
> 	6130 by: Mamta Satoor
>
> Administrivia:
>
> ---------------------------------------------------------------------
> To post to the list, e-mail: derby-user@db.apache.org
> To unsubscribe, e-mail: derby-user-digest-unsubscribe@db.apache.org
> For additional commands, e-mail: derby-user-digest-help@db.apache.org
>
> ----------------------------------------------------------------------
>   
>
> ------------------------------------------------------------------------
>
> Subject:
> ref: connection to derby failed
> From:
> Pranav Aggarwal <pranav.aggarwal@altair.com>
> Date:
> Fri, 09 Feb 2007 09:06:20 +0530
> To:
> Derby Discussion <derby-user@db.apache.org>
>
> To:
> Derby Discussion <derby-user@db.apache.org>
>
>
> Hi all,
>
> I am new to Derby, just trying a small program which makes connection 
> to derby DB.
> Following program I have written:
> import java.sql.*;
>                                                                                     
                                   
>
> class derby_connect
> {
>       void connect() throws Exception
>       {
>               String driver="org.apache.derby.jdbc.EmbeddedDriver";
>               String dbName="mydb";
>               String connectionURL="jdbc:derby:"+dbName;
>                                                                                     
                                   
>
>               Connection conn=null;
>               try
>               {
>                       Class.forName(driver);
>               }catch(java.lang.ClassNotFoundException e)
>               {
>                       e.printStackTrace();
>               }
>               try
>               {
>                       conn=DriverManager.getConnection(connectionURL);
>                       System.out.println("Connection established!!!");
>               }
>               catch(Throwable e)
>               {e.printStackTrace();}
>               finally {conn.close();}
>                                                                                     
                                   
>
>       }//end of connect()
>       public static void main(String args[]) throws Exception
>       {
>               derby_connect dc=new derby_connect();
>               dc.connect();
>       }
> }//end of class
>                                                                                     
                                   
>
> The program resides in same directory where DB is residing. Now when I 
> run, I get the following error:
>
> $ java derby_connect
> java.sql.SQLException: Failed to start database 'mydb', see the next 
> exception for details.
>       at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown 
> Source)
>       at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown 
> Source)
>       at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown 
> Source)
>       at 
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>       at 
> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown 
> Source)
>       at 
> org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
>       at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown 
> Source)
>       at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown 
> Source)
>       at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown 
> Source)
>       at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown 
> Source)
>       at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
>       at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
>       at java.sql.DriverManager.getConnection(DriverManager.java:582)
>       at java.sql.DriverManager.getConnection(DriverManager.java:207)
>       at derby_connect.connect(derby_connect.java:21)
>       at derby_connect.main(derby_connect.java:32)
> Caused by: java.sql.SQLException: Failed to start database 'mydb', see 
> the next exception for details.
>       at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
> Source)
>       at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown

> Source)
>       ... 16 more
> Exception in thread "main" java.lang.NullPointerException
>       at derby_connect.connect(derby_connect.java:26)
>       at derby_connect.main(derby_connect.java:32)
> Can any one help me with this?   
>
> ------------------------------------------------------------------------
>
> Subject:
> Re: ref: connection to derby failed
> From:
> Rajesh Kartha <kartha02@gmail.com>
> Date:
> Thu, 08 Feb 2007 20:25:00 -0800
> To:
> Derby Discussion <derby-user@db.apache.org>
>
> To:
> Derby Discussion <derby-user@db.apache.org>
>
>
> Hi Pranav,
>
> In the embedded mode,  a Derby database can be booted only by a single 
> JVM (use the
> Network server if you want multiple applications to access the db). 
> Looking at the
> error you mentioned the first thing is to *ensure *no other 
> application (tools like 'ij') is using
> (connected to) the 'mydb' while you are running you little test program.
>
> The test program in your mail is very straight forward and I don't see 
> why the connect should not work
> if the 'mydb' is present and is currently not being used by other 
> applications.
>
> -Rajesh
>
> Pranav Aggarwal wrote:
>> Hi all,
>>
>> I am new to Derby, just trying a small program which makes connection 
>> to derby DB.
>> Following program I have written:
>> import java.sql.*;
>>                                                                                 
                                       
>>
>> class derby_connect
>> {
>>       void connect() throws Exception
>>       {
>>               String driver="org.apache.derby.jdbc.EmbeddedDriver";
>>               String dbName="mydb";
>>               String connectionURL="jdbc:derby:"+dbName;
>>                                                                                 
                                       
>>
>>               Connection conn=null;
>>               try
>>               {
>>                       Class.forName(driver);
>>               }catch(java.lang.ClassNotFoundException e)
>>               {
>>                       e.printStackTrace();
>>               }
>>               try
>>               {
>>                       conn=DriverManager.getConnection(connectionURL);
>>                       System.out.println("Connection established!!!");
>>               }
>>               catch(Throwable e)
>>               {e.printStackTrace();}
>>               finally {conn.close();}
>>                                                                                 
                                       
>>
>>       }//end of connect()
>>       public static void main(String args[]) throws Exception
>>       {
>>               derby_connect dc=new derby_connect();
>>               dc.connect();
>>       }
>> }//end of class
>>                                                                                 
                                       
>>
>> The program resides in same directory where DB is residing. Now when 
>> I run, I get the following error:
>>
>> $ java derby_connect
>> java.sql.SQLException: Failed to start database 'mydb', see the next 
>> exception for details.
>>       at 
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown 
>> Source)
>>       at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown 
>> Source)
>>       at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown 
>> Source)
>>       at 
>> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>>       at 
>> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown 
>> Source)
>>       at 
>> org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
>>       at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown 
>> Source)
>>       at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown 
>> Source)
>>       at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown 
>> Source)
>>       at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown 
>> Source)
>>       at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
>>       at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
>>       at java.sql.DriverManager.getConnection(DriverManager.java:582)
>>       at java.sql.DriverManager.getConnection(DriverManager.java:207)
>>       at derby_connect.connect(derby_connect.java:21)
>>       at derby_connect.main(derby_connect.java:32)
>> Caused by: java.sql.SQLException: Failed to start database 'mydb', 
>> see the next exception for details.
>>       at 
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
>> Source)
>>       at 
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown

>> Source)
>>       ... 16 more
>> Exception in thread "main" java.lang.NullPointerException
>>       at derby_connect.connect(derby_connect.java:26)
>>       at derby_connect.main(derby_connect.java:32)
>> Can any one help me with this?   
>
>
> ------------------------------------------------------------------------
>
> Subject:
> Re: ref: connection to derby failed
> From:
> "Thomas J. Taylor" <Thomas.Taylor@Miami.edu>
> Date:
> Fri, 09 Feb 2007 01:55:50 -0500
> To:
> Derby Discussion <derby-user@db.apache.org>
>
> To:
> Derby Discussion <derby-user@db.apache.org>
>
>
> Hi Pranav,
>
> If the database doesn't already exist, don't forget to include the 
> 'create=true' property.
>
> For example,
> **jdbc:derby:sampleDB;create=true**
> Further explained in the Derby documentation:
> http://db.apache.org/derby/docs/10.2/ref/rrefattrib26867.html
>
> Thomas
>
> Pranav Aggarwal wrote:
>> Hi all,
>>
>> I am new to Derby, just trying a small program which makes connection 
>> to derby DB.
>> Following program I have written:
>> import java.sql.*;
>>                                                                                 
                                       
>>
>> class derby_connect
>> {
>>       void connect() throws Exception
>>       {
>>               String driver="org.apache.derby.jdbc.EmbeddedDriver";
>>               String dbName="mydb";
>>               String connectionURL="jdbc:derby:"+dbName;
>>                                                                                 
                                       
>>
>>               Connection conn=null;
>>               try
>>               {
>>                       Class.forName(driver);
>>               }catch(java.lang.ClassNotFoundException e)
>>               {
>>                       e.printStackTrace();
>>               }
>>               try
>>               {
>>                       conn=DriverManager.getConnection(connectionURL);
>>                       System.out.println("Connection established!!!");
>>               }
>>               catch(Throwable e)
>>               {e.printStackTrace();}
>>               finally {conn.close();}
>>                                                                                 
                                       
>>
>>       }//end of connect()
>>       public static void main(String args[]) throws Exception
>>       {
>>               derby_connect dc=new derby_connect();
>>               dc.connect();
>>       }
>> }//end of class
>>                                                                                 
                                       
>>
>> The program resides in same directory where DB is residing. Now when 
>> I run, I get the following error:
>>
>> $ java derby_connect
>> java.sql.SQLException: Failed to start database 'mydb', see the next 
>> exception for details.
>>       at 
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown 
>> Source)
>>       at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown 
>> Source)
>>       at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown 
>> Source)
>>       at 
>> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>>       at 
>> org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown 
>> Source)
>>       at 
>> org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
>>       at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown 
>> Source)
>>       at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown 
>> Source)
>>       at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown 
>> Source)
>>       at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown 
>> Source)
>>       at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
>>       at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
>>       at java.sql.DriverManager.getConnection(DriverManager.java:582)
>>       at java.sql.DriverManager.getConnection(DriverManager.java:207)
>>       at derby_connect.connect(derby_connect.java:21)
>>       at derby_connect.main(derby_connect.java:32)
>> Caused by: java.sql.SQLException: Failed to start database 'mydb', 
>> see the next exception for details.
>>       at 
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
>> Source)
>>       at 
>> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown

>> Source)
>>       ... 16 more
>> Exception in thread "main" java.lang.NullPointerException
>>       at derby_connect.connect(derby_connect.java:26)
>>       at derby_connect.main(derby_connect.java:32)
>> Can any one help me with this?   
>
>
> ------------------------------------------------------------------------
>
> Subject:
> Problem with create table in Derby 10.2.2.0
> From:
> "Leo Alberto" <Alberto.Leo@ssi.it>
> Date:
> Fri, 9 Feb 2007 19:07:58 +0100
> To:
> <derby-user@db.apache.org>
>
> To:
> <derby-user@db.apache.org>
>
>
> Hy
> I'm try to using Derby 10.2.2.0 
> <http://db.apache.org/derby/releases/release-10.2.2.0.cgi> in embedded 
> mode with the integrated plug-in environment in Eclipse 3.2.0. 
> Environment jre 1.6.0
> I would create a table with this code :
>
> *public* *boolean* tableCreation(Connection currentConn, String Table)
>
>                     *throws* DatabaseDriverException {
>
> *boolean* doCreateTable = *true*;
>
>              Statement stmt = *null*;
>
>              String createString = "create table " +
>
> Table +
>
> "(SAMPLE_ID int not null generate always as increment, " +
>
> "KEY_ID long, " +
>
> "KEY_INST_COUNT int, " +
>
> "DATAOBJ blob (102400), " +
>
>              "unique(KEY_ID))";
>
>             
>
>              *try* {
>
>  
>
>                     currentConn.setAutoCommit(*false*);
>
>                     stmt = currentConn.createStatement();
>
>                     DatabaseMetaData md = currentConn.getMetaData();
>
>                     ResultSet rs = md.getTables(*null*, *null*, "%", 
> *null*);
>
>                     *while* (rs.next()) {
>
> System./out/.println("Elenco tabelle nel db " + rs.getString(3));
>
>                            *if* (rs.getString(3).equals(tabella)) {
>
>                                   doCreateTable = *false*;
>
>                                   *break*;
>
>                            }
>
>                     }
>
>                     *if* (doCreateTable) {
>
>                            // execute
>
>                            stmt.execute(createString); // _I'm 
> arriving here ang got the error_
>
>                            doCreateTable = *true*;
>
>                     }
>
>                     currentConn.commit();
>
>                     stmt.close();
>
>  
>
>              } *catch* (SQLException e) {
>
>                     *throw* *new* DatabaseDriverException("Error 
> create table", e);
>
>              }
>
>              *return* doCreateTable;
>
>        }/* End tableCreation */
>
> the error is:
>
> Syntax error: Encountered "," at line 1, column 88.
>
>        at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown 
> Source)
>
>        at 
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>
>        at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown 
> Source)
>
>        at 
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown 
> Source)
>
>        at 
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
>
>        at 
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
>
>        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown 
> Source)Error create table
>
>  
>
>        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown 
> Source)
>
>        at dds.dbdrivers.DerbyDriver.tableCreation(_DerbyDriver.java:257_)
>
>        at provaDB.main(_provaDB.java:39_)
>
> Caused by: _java.sql.SQLException_: Syntax error: Encountered "," at 
> line 1, column 88.
>
>        at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
> Source)
>
>        at 
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown

> Source)
>
>        ... 10 more
>
> from errorlog.txt generated:
>
> ----------------------------------------------------------------
>
> 2007-02-09 17:31:01.452 GMT:
>
>  Booting Derby version The Apache Software Foundation - Apache Derby - 
> 10.2.2.0 - (485682): instance c013800d-0110-a78e-d8b1-ffffa2db3c51
>
> on database directory C:\DdsAppDb\DbDOMAIN_(7) 
>
>  
>
> Database Class Loader started - derby.database.classpath=''
>
> 2007-02-09 17:31:10.786 GMT Thread[main,5,main] (XID = 122), 
> (SESSIONID = 0), (DATABASE = DbDOMAIN_(7)), (DRDAID = null), Cleanup 
> action starting
>
> 2007-02-09 17:31:10.786 GMT Thread[main,5,main] (XID = 122), 
> (SESSIONID = 0), (DATABASE = DbDOMAIN_(7)), (DRDAID = null), Failed 
> Statement is:
>
>  
>
> <my add>
>
> 1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678
>
> create table POSITION (SAMPLE_ID int not null generated always as 
> identity, KEY_ID long, KEY_INST_COUNT int, DATAOBJ blob (102400), 
> unique(KEY_ID))
>
> ERROR 42X01: Syntax error: Encountered "," at line 1, column 88.
>
>        at 
> org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
>
>        at 
> org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown 
> Source)
>
>        at 
> org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
>
>        at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown 
> Source)
>
>        at 
> org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown

> Source)
>
>        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown 
> Source)
>
>        at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown 
> Source)
>
>        at dds.dbdrivers.DerbyDriver.tableCreation(DerbyDriver.java:257)
>
>        at provaDB.main(provaDB.java:39)
>
> Cleanup action completed
>
>  
>
> I would be very glad if someone can help me understand wath is wrong!
>
> thanks in advance
>
> Alberto Leo
>
>  
>
> ------------------------------------------------------------------------
>
> Subject:
> Re: Problem with create table in Derby 10.2.2.0
> From:
> "Mamta Satoor" <msatoor@gmail.com>
> Date:
> Fri, 9 Feb 2007 10:45:51 -0800
> To:
> "Derby Discussion" <derby-user@db.apache.org>
>
> To:
> "Derby Discussion" <derby-user@db.apache.org>
>
>
> Leo,
>  
> You need to use BIGINT rather than long for KEY_ID column.
>  
> Mamta
>
>  
> On 2/9/07, *Leo Alberto* <Alberto.Leo@ssi.it 
> <mailto:Alberto.Leo@ssi.it>> wrote:
>
>     Hy
>     I'm try to using Derby 10.2.2.0
>     <http://db.apache.org/derby/releases/release-10.2.2.0.cgi> in
>     embedded mode with the integrated plug-in environment in Eclipse
>     3.2.0. Environment jre 1.6.0
>     I would create a table with this code :
>
>     *public* * boolean* tableCreation(Connection currentConn, String
>     Table)
>
>                         *throws* DatabaseDriverException {
>
>     *boolean* doCreateTable = *true*;
>
>                  Statement stmt = *null*;
>
>                  String createString = "create table " +
>
>     Table +
>
>     "(SAMPLE_ID int not null generate always as increment, " +
>
>     "KEY_ID long, " +
>
>     "KEY_INST_COUNT int, " +
>
>     "DATAOBJ blob (102400), " +
>
>                  "unique(KEY_ID))";
>
>                 
>
>                  *try* {
>
>      
>
>                         currentConn.setAutoCommit (*false*);
>
>                         stmt = currentConn.createStatement();
>
>                         DatabaseMetaData md = currentConn.getMetaData();
>
>                         ResultSet rs = md.getTables(*null*, *null*,
>     "%", * null*);
>
>                         *while* (rs.next()) {
>
>     System./out/ .println("Elenco tabelle nel db " + rs.getString(3));
>
>                                *if* (rs.getString(3).equals(tabella)) {
>
>                                       doCreateTable = * false*;
>
>                                       *break*;
>
>                                }
>
>                         }
>
>                         *if* (doCreateTable) {
>
>                                // execute
>
>                                stmt. execute(createString); // _I'm
>     arriving here ang got the error_
>
>                                doCreateTable = * true*;
>
>                         }
>
>                         currentConn.commit();
>
>                         stmt.close();
>
>      
>
>                  } *catch* (SQLException e) {
>
>                         *throw* *new* DatabaseDriverException("Error
>     create table", e);
>
>                  }
>
>                  *return* doCreateTable;
>
>            }/* End tableCreation */
>
>     the error is:
>
>     Syntax error: Encountered "," at line 1, column 88.
>
>            at
>     org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
>     Source)
>
>            at
>     org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
>     Source)
>
>            at
>     org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
>     Source)
>
>            at
>     org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
>     Source)
>
>            at
>     org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
>     Source)
>
>            at
>     org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
>     Source)
>
>            at
>     org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown
>     Source)Error create table
>
>      
>
>            at
>     org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
>
>            at dds.dbdrivers.DerbyDriver.tableCreation(_
>     DerbyDriver.java:257_)
>
>            at provaDB.main(_provaDB.java:39 _)
>
>     Caused by: _java.sql.SQLException_ : Syntax error: Encountered ","
>     at line 1, column 88.
>
>            at
>     org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
>     Source)
>
>            at
>     org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
>     Source)
>
>            ... 10 more
>
>     from errorlog.txt generated:
>
>     ----------------------------------------------------------------
>
>     2007-02-09 17:31:01.452 GMT:
>
>      Booting Derby version The Apache Software Foundation - Apache
>     Derby - 10.2.2.0 <http://10.2.2.0/> - (485682): instance
>     c013800d-0110-a78e-d8b1-ffffa2db3c51
>
>     on database directory C:\DdsAppDb\DbDOMAIN_(7) 
>
>      
>
>     Database Class Loader started - derby.database.classpath=''
>
>     2007-02-09 17:31:10.786 GMT Thread[main,5,main] (XID = 122),
>     (SESSIONID = 0), (DATABASE = DbDOMAIN_(7)), (DRDAID = null),
>     Cleanup action starting
>
>     2007-02-09 17:31:10.786 GMT Thread[main,5,main] (XID = 122),
>     (SESSIONID = 0), (DATABASE = DbDOMAIN_(7)), (DRDAID = null),
>     Failed Statement is:
>
>      
>
>     <my add>
>
>     1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678
>
>     create table POSITION (SAMPLE_ID int not null generated always as
>     identity, KEY_ID long, KEY_INST_COUNT int, DATAOBJ blob (102400),
>     unique(KEY_ID))
>
>     ERROR 42X01: Syntax error: Encountered "," at line 1, column 88.
>
>            at
>     org.apache.derby.iapi.error.StandardException.newException(Unknown
>     Source)
>
>            at
>     org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown
>     Source)
>
>            at
>     org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
>
>            at
>     org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
>
>            at
>     org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
>     Source)
>
>            at
>     org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
>
>            at
>     org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
>
>            at
>     dds.dbdrivers.DerbyDriver.tableCreation(DerbyDriver.java:257)
>
>            at provaDB.main(provaDB.java:39)
>
>     Cleanup action completed
>
>      
>
>     I would be very glad if someone can help me understand wath is wrong!
>
>     thanks in advance
>
>     Alberto Leo
>
>      
>
>
Ya Rajesh.... u were correct... its up and working..........!!! thanx..

-- 
Thanks
Pranav Aggarwal
Altair Engineering
www.altair.com


Mime
View raw message