File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes couldn't execute insert statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "couldn Watch "couldn New topic
Author

couldn't execute insert statement

sabr sabars
Ranch Hand

Joined: Jan 28, 2003
Posts: 35
Hi All

after created couldscape database and its table inside websphere v6 and tried to execute the insert sql statement inside websphere v6 with the same connection used when created database and its table i got an error saying "problems encountered while trying to establish connection CloudscapeConn. Reason:'Array index out of range:0'

could anyone know why the insert sql statment couldn't be executed inside websphere v6 with the same connection used when create its couldscape database and table

with regards and appreciate your help
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31075
    
233

Can you post the insert statement?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
sabr sabars
Ranch Hand

Joined: Jan 28, 2003
Posts: 35
here is the sql insert statement

INSERT INTO
DBUSER1.ADDRESSTABLE
(
ID,
NAME,
PHONE,
ADDRESS
)
VALUES
(
1,
'Jane',
1234567,
'8200 warden'
)
ID : primary key and Integer
Name and address : VCHAR
phone : interger

with regards and appreciate your help
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31075
    
233

It looks ok. Are you able to run the command at the command line? Are you able to run other commands through WebSphere?
Bougnon Kipre
Greenhorn

Joined: Sep 13, 2007
Posts: 21
Originally posted by sabr sabars:
here is the sql insert statement

INSERT INTO
DBUSER1.ADDRESSTABLE
(
ID,
NAME,
PHONE,
ADDRESS
)
VALUES
(
1,
'Jane',
1234567,
'8200 warden'
)
ID : primary key and Integer
Name and address : VCHAR
phone : interger

with regards and appreciate your help


Can this be correct) extra 'r' phone data type
phone : interger
Shouldn't it read
phone : integer
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: couldn't execute insert statement