While compiling my little java application developed in netbeans, i had the following problem. Initially i had an error of the sort java.sql.sqlException, No suitable driver. After some serious "troubleshooting", I now shows an error: Database 'ManageSite' not found. Where ManageSite is the name of the database. It shows me jdbc:derby://localhost:1527/ManageSite[root on ROOT]. It shows connected, i can view my tables and create more table.
And i can insert data into the database through the SQL command into the database
Can anyone help me Debug
Here is a portion of the code that links and connects the Database

private static final String URL = "jbdc:derby://localhost:1527/MANAGESITE";
private static final String USERNAME = "root";
private static final String PASSWORD = "nbuser";
private Connection connection = null
private static final String Driver = "org.apache.derby.jdbc.EmbeddedDriver";//i also tried ClientDriver instead of EmbeddedDriver
//my constructor
public ClassName () {
try
{
Class.forName(DRIVER);
connection = Driver.getConnection(URL, USERNAME,PASSWORD);
,
,
,
}
catch (ClassNotFoundException cNFException)
{
,
catch (SQLException sqlException)
{
.
.
.
}
}

Hi are u using deby in embedded mode. If you are try this for the db url "jdbc:deby:managesite"

i did that but it now gives an error:java.lang.ClassNotFoundException; org.apache.derby.ClientDriver

i changed the line of code that has EmbeddedDriver to ClientDriver and it still gives the same Error. Can u help further pls.

Thanks for your concern

make sure derbyclient.jar is in ur classpath. This contains the jdbc driver that you will require

Thanks a lot.
The little challenge i now have is that while trying to input data into the database through the form, the app now generates an SQL Error inidcating.
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "VALUE" at line 1, column 59.

The code excerpt for entering data into database table is shown below.

//constructor
public ClassName(){
try
{
Class.forName(DRIVER);
connection = DriverManager.getConnection(URL,USERNAME,PASSWORD)
insertAnotherEntry = connection.prepareStatement("INSERT INTO TABLE" +"(FirstCol, SecondCol, ThirdCol, FourthCol)" + "VALUES (?,?,?,?)";
//insertAnother entry is of type PreparedStatement
//connection of type Connection
}
catch (, )


Pls help me further. i have no idea what the problem is God bless you

i noticed that u don't have spaces before values and the column list.

INSERT INTO TABLE " +"(FirstCol, SecondCol, ThirdCol, FourthCol)" + "  VALUES (?,?,?,?)";

if that doesn't work post the stacktrace of the exception u are getting

i tried it but it did not still work. The stack trace is below

java.sql.SQLSyntaxErrorException: Syntax error: Encountered "VALUE" at line 1, column 59.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at ManageSite.<init>(ManageSite.java:29)
at Add_New_Info.jButton1ActionPerformed(Add_New_Info.java:142)
at Add_New_Info.access$100(Add_New_Info.java:16)
at Add_New_Info$2.actionPerformed(Add_New_Info.java:63)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6038)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
at java.awt.Component.processEvent(Component.java:5803)
at java.awt.Container.processEvent(Container.java:2058)
at java.awt.Component.dispatchEventImpl(Component.java:4410)
at java.awt.Container.dispatchEventImpl(Container.java:2116)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
at java.awt.Container.dispatchEventImpl(Container.java:2102)
at java.awt.Window.dispatchEventImpl(Window.java:2429)
at java.awt.Component.dispatchEvent(Component.java:4240)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Caused by: org.apache.derby.client.am.SqlException: Syntax error: Encountered "VALUE" at line 1, column 59.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
, 30 more

You might need to post all your code for me to see how u are using the prepared statement. looks like an sql syntax error

do u have something like these

insertAnotherEntry.setString(1,"blah"
insertAnotherEntry.executeUpdate()

are the names of the columns in quotes?

Also you might want to change this INSERT INTO TABLE " +"(FirstCol, SecondCol, ThirdCol, FourthCol)" + " VALUES (?,?,?,?)";

to this "INSERT INTO TABLE VALUES (?,?,?,?)"; if you will be inserting to all the columns in your table

This addEntry() method is in the class that manages database connection called ManageSite

public int addEntry(String sname, String smail, String pword, String descriptn)
{
int result = 0;
try
{
insertAnotherEntry.setString(1, sname);
insertAnotherEntry.setString(2, smail);
insertAnotherEntry.setString(3, pword);
insertAnotherEntry.setString(4, descriptn);

result = insertAnotherEntry.executeUpdate();
return result;
}
catch (SQLException sqlException)
{
sqlException.printStackTrace();
close();
}
return 0;//return zero if problem occurs
}

This method is called under the submit button as shown below. method close in catch block of method addentry() is meant to close database connection.



private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

// TODO add your handling code here:
ManageSite manageSite = new ManageSite();
int result = manageSite.addEntry(siteNameTextField.getText(), siteMailTextField.getText(), passwordTextField.getText(), descriptionTextArea.getText());
if (result == 1)
JOptionPane.showMessageDialog(this,"Entry Added!", "Entry Added", JOptionPane.PLAIN_MESSAGE );
else
JOptionPane.showMessageDialog(this,"Entry not Added!","Error", JOptionPane.PLAIN_MESSAGE);
}
Thanks for your care. I'm most grateful.

Let somebody help me PLs

If you were running PHP I am sure someone would have provided the answer to the problem as soon as you posted it.

Another reason to embrace a language that has great support from across the world.

I wish I could help.

Must be a post for the April Fool of 2009. Why will anybody respond with any seriousness to this dead thread?

In any case, I MOSTLY ignore posts like these because I believe a programmer should be self-taught. Such trivial issues are stuff you should figure out yourself (either by tasking your brain or doing a search on the Net).

hymnha:

Let somebody help me PLs

Did you try my last suggestion

Your code looks fine but i think there is a problem with your SQL syntax from the stacktrace you posted.

Also make sure that the types of the columns you are inserting stuff into matches the java types you are tryin to had to it

candylips:

It's obvious the guy did not correct the code (did not leave a space between the closing bracket and 'VALUES' keyword, which you fixed, but he apparently missed the correction). Besides, it's been how many months now? 9 months?

hymnha:

i tried it but it did not still work. The stack trace is below

java.sql.SQLSyntaxErrorException: Syntax error: Encountered "VALUE" at line 1, column 59.
        at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
        at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
        at ManageSite.<init>(ManageSite.java:29)
        at Add_New_Info.jButton1ActionPerformed(Add_New_Info.java:142)
        at Add_New_Info.access$100(Add_New_Info.java:16)
        at Add_New_Info$2.actionPerformed(Add_New_Info.java:63)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        at java.awt.Component.processMouseEvent(Component.java:6038)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
        at java.awt.Component.processEvent(Component.java:5803)
        at java.awt.Container.processEvent(Container.java:2058)
        at java.awt.Component.dispatchEventImpl(Component.java:4410)
        at java.awt.Container.dispatchEventImpl(Container.java:2116)
        at java.awt.Component.dispatchEvent(Component.java:4240)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
        at java.awt.Container.dispatchEventImpl(Container.java:2102)
        at java.awt.Window.dispatchEventImpl(Window.java:2429)
        at java.awt.Component.dispatchEvent(Component.java:4240)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Caused by: org.apache.derby.client.am.SqlException: Syntax error: Encountered "VALUE" at line 1, column 59.
        at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
        at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
        at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
        at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
        at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
        at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
        at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
        at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
        at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
        ,  30 more

close to a hundred line, when will java stop frustrating you guys?

Ur code is correct. from the exception statement,Check the correct name of the columns,and the table name, and also check whether the datatype conforms to the type assigned to the preparedstatement