This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 31662 - Unable to connect to sample pointbase database in debugging mode
Summary: Unable to connect to sample pointbase database in debugging mode
Status: CLOSED FIXED
Alias: None
Product: debugger
Classification: Unclassified
Component: Code (show other bugs)
Version: -S1S-
Hardware: PC Other
: P3 blocker (vote)
Assignee: issues@debugger
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-03-04 19:12 UTC by kishm
Modified: 2010-04-29 09:12 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description kishm 2003-03-04 19:12:53 UTC
FULL PRODUCT VERSION :
See System Info

>System Info:
  Product Version       = Sun ONE Studio 4
update 1, Community Edition (Build 021108)
  IDE Versioning        = IDE/1 spec=1.43.3.1
impl=021108
  Operating System      = Windows 2000 version
5.0 running on x86
  Java; VM; Vendor      = 1.4.0; Java HotSpot
(TM) Client VM 1.4.0-b92; Sun Microsystems Inc.
  Java Home             = D:\j2sdk1.4.0\jre
  System Locale; Encod. = el_GR; Cp1253
(f4j_ce)
  Home Dir; Current Dir = D:\Documents and
Settings\Jim; D:\Program Files\s1studio\ce\bin
  IDE Install; User Dir = D:\Program
Files\s1studio\ce; C:\My documents\my
works\java\forte
  CLASSPATH             = D:\Program
Files\s1studio\ce\lib\patches\openide-
compat.jar;D:\Program
Files\s1studio\ce\lib\locale\core_ja.jar;D:\Program
 
Files\s1studio\ce\lib\locale\openide_ja.jar;D:\Prog
ram
Files\s1studio\ce\lib\locale\core_f4j_ce.jar;D:\Pro
gram
Files\s1studio\ce\lib\locale\core_f4j.jar;D:\Progra
m 
Files\s1studio\ce\lib\locale\core_f4j_ce_ja.jar;D:  Program
Files\s1studio\ce\lib\locale\core_f4j_ja.jar;D:\Prog
ram
Files\s1studio\ce\lib\locale\openide_f4j.jar;D:\Pro
gram
Files\s1studio\ce\lib\locale\updater_ja.jar;D:\Progr
am Files\s1studio\ce\lib\core.jar;D:\Program
Files\s1studio\ce\lib\openide.jar;D:\Program
Files\s1studio\ce\lib\ext\locale\ddl_ja.jar;D:\Progr
am
Files\s1studio\ce\lib\ext\locale\logger_ja.jar;D:\Pr
ogram
Files\s1studio\ce\lib\ext\terminalemulator.jar;D:\P
rogram
Files\s1studio\ce\lib\ext\ddl.jar;D:\Program
Files\s1studio\ce\lib\ext\logger.jar;D:\Program
Files\s1studio\ce\lib\ext\jh.jar;D:\Program
Files\s1studio\ce\lib\ext\xerces.jar;D:\Program
Files\s1studio\ce\lib\ext\regexp.jar;D:\Program
Files\s1studio\ce\lib\ext\parser.jar;D:\Program
Files\s1studio\ce\lib\ext\crimson.jar;D:\Program
Files\s1studio\ce\lib\ext\cmd.jar;D:\Program
Files\s1studio\ce\lib\ext\fjscript.jar;D:\Program
Files\s1studio\ce\lib\ext\bsh-1_0-
fj.jar;D:\Program Files\s1studio\ce\lib\ext\jaxp-
api.jar;D:\Program
Files\s1studio\ce\lib\ext\jaas.jar;D:\Program
Files\s1studio\ce\lib\ext\pbclient.jar;D:\Program
Files\s1studio\ce\lib\ext\jdbc20x.zip;D:\j2sdk1.4.
0\lib\dt.jar;D:\j2sdk1.4.0\lib\tools.jar

A DESCRIPTION OF THE PROBLEM :
While I am fully able to connect to a database
when I execute the program, I cannot do that in
debugging mode. This is the actual program, it is
shown here to show I'm not doing anything fancy,
just basic calls.

[code]
package gr.uom.java.db;
import java.sql.*;
public class Test {
    private static final String URL
= "jdbc:pointbase:server://localhost:9092/sample"
;
    private static final String DRIVER
= "com.pointbase.jdbc.jdbcUniversalDriver";
    private static final String USER = "pbpublic";
    private static final String PASSWORD
= "pbpublic";
    
    public static void main(String[] args) {
        try {
            DriverManager.setLogStream
(System.out);
            Class.forName(DRIVER).newInstance();
            Connection con =
DriverManager.getConnection(URL, USER,
PASSWORD);
            Statement st = con.createStatement();
            ResultSet set = st.executeQuery
("SELECT C.NAME FROM CUSTOMER_TBL
C");
            System.out.println(set.getMetaData
().getColumnCount());
            while (set.next()) {
                System.out.println(set.getString(1));
            }
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}
[/code]

If I execute this, it will run fine (assuming
pointbase server is running).

But, If I try to debug it, it is not able to connect to
the database, and the output is the following: (I've
seperated the lines for more readability)

DriverManager.initialize: jdbc.drivers = null

JDBC DriverManager initialized

registerDriver: driver
[className=com.pointbase.jdbc.jdbcUniversalDri
ver,com.pointbase.jdbc.jdbcUniversalDriver@b8f8
2d]

DriverManager.getConnection
("jdbc:pointbase:server://localhost:9092/sample")

    trying driver
[className=com.pointbase.jdbc.jdbcUniversalDri
ver,com.pointbase.jdbc.jdbcUniversalDriver@b8f8
2d]

registerDriver: driver
[className=com.pointbase.jdbc.jdbcDriver,com.
pointbase.jdbc.jdbcDriver@a6aeed]

registerDriver: driver
[className=com.pointbase.jdbc.jdbcEmbedded
Driver,com.pointbase.jdbc.jdbcEmbeddedDriver@
72ffb]

    trying driver
[className=com.pointbase.jdbc.jdbcDriver,com.
pointbase.jdbc.jdbcDriver@a6aeed]

    trying driver
[className=com.pointbase.jdbc.jdbcEmbedded
Driver,com.pointbase.jdbc.jdbcEmbeddedDriver@
72ffb]

getConnection: no suitable driver
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection
(DriverManager.java:532)
        at java.sql.DriverManager.getConnection
(DriverManager.java:171)
        at gr.uom.java.db.Test.main(Test.java:29)
SQLException: SQLState(08001)

"No suitable driver"??? I can't explain this. The
driver registers itself properly, just as in
execution mode. But no connection can be
made. So, I'm not able to debug any jdbc
application, at least with this drive I've tested.



STEPS TO FOLLOW TO REPRODUCE THE PROBLEM :
1. Start pointbase network server.
2. Run my code in debug code, either F7 or Alt-
F5 with or without breakpoints will do.


EXPECTED VERSUS ACTUAL BEHAVIOR :
The results should be identical to the ones I get
in normal execution, ie a ResultSet.

ERROR MESSAGES/STACK TRACES THAT OCCUR :
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection
(DriverManager.java:532)
        at java.sql.DriverManager.getConnection
(DriverManager.java:171)
        at gr.uom.java.db.Test.main(Test.java:29)

Additionally, from ide.log:
[IDE-Exec] Executing:
0 .= D:\j2sdk1.4.0\jre\..\bin\java
1 .= -Xdebug
2 .= -Xnoagent
3 .= -
Xrunjdwp:transport=dt_socket,address=uom-
2:1089,suspend=y
4 .= -Djava.compiler=NONE
5 .= -Xbootclasspath:D:\j2sdk1.4.0
\jre\..\lib\tools.jar;D:\j2sdk1.4.0
\jre\lib\rt.jar;D:\j2sdk1.4.0
\jre\lib\i18n.jar;D:\j2sdk1.4.0
\jre\lib\sunrsasign.jar;D:\j2sdk1.4.0
\jre\lib\jsse.jar;D:\j2sdk1.4.0
\jre\lib\jce.jar;D:\j2sdk1.4.0
\jre\lib\charsets.jar;D:\j2sdk1.4.0
\jre\classes;;D:\j2sdk1.4.0
\jre\lib\ext\dnsns.jar;D:\j2sdk1.4.0
\jre\lib\ext\ldapsec.jar;D:\j2sdk1.4.0
\jre\lib\ext\localedata.jar;D:\j2sdk1.4.0
\jre\lib\ext\sunjce_provider.jar
6 .= -classpath
7 .= C:\My documents\my
works\java\forte\system;C:\My documents\my
works\java\forte\system;D:\Program
Files\s1studio\ce\system;D:\Program
Files\s1studio\ce\modules\ext\j2ee-
1.3.jar;D:\Program
Files\s1studio\ce\modules\ext\jaas-
1.0.jar;D:\Program
Files\s1studio\ce\modules\autoload\activation.jar;
D:\Program Files\s1studio\ce\modules\ext\jms-
1.0.2b.jar;D:\Program
Files\s1studio\ce\modules\ext\jta-
spec1_0_1.jar;D:\Program
Files\s1studio\ce\modules\autoload\mail.jar;D:\Pr
ogram
Files\s1studio\ce\modules\ext\AbsoluteLayout.jar
;D:\Program
Files\s1studio\ce\modules\ext\sql.jar;D:\Program
Files\s1studio\ce\modules\ext\rowset.jar;D:\Progr
am
Files\s1studio\ce\lib\ext\jdbc20x.zip;D:\Program
Files\s1studio\ce\modules\ext\servlet-
2.3.jar;C:\My Documents\My
Works\JAVA\Forte\tomcat401_base;D:\Documen
ts and Settings\Jim\Desktop\JAVA;D:\Program
Files\s1studio\ce\beans\TimerBean.jar;D:\Progra
m 
Files\s1studio\ce\pointbase\server\lib\pbserver.jar
8 .= gr.uom.java.db.Test



REPRODUCIBILITY :
This bug can be reproduced always.

---------- BEGIN SOURCE ----------
[code]
public class Test {
    private static final String URL
= "jdbc:pointbase:server://localhost:9092/sample"
;
    private static final String DRIVER
= "com.pointbase.jdbc.jdbcUniversalDriver";
    private static final String USER = "pbpublic";
    private static final String PASSWORD
= "pbpublic";
    
    public static void main(String[] args) {
        try {
            DriverManager.setLogStream
(System.out);
            Class.forName(DRIVER).newInstance();
            Connection con =
DriverManager.getConnection(URL, USER,
PASSWORD);
            Statement st = con.createStatement();
            ResultSet set = st.executeQuery
("SELECT C.NAME FROM CUSTOMER_TBL
C");
            System.out.println(set.getMetaData
().getColumnCount());
            while (set.next()) {
                System.out.println(set.getString(1));
            }
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}
[/code]

---------- END SOURCE ----------
Comment 1 Jan Jancura 2003-03-05 09:30:35 UTC
Hello Kishore,
can you try to go to menu Tools / Options - Debugging / Debugger Types
/ Default Debugger Type and open customizer for external process
property. Than delete some {bootclasspath} and {bootclasspathswitch}
part of "Arguments" line?
Does it help?
Comment 2 Jan Jancura 2003-03-10 13:32:06 UTC
Should be fixed in the main trunk...
Comment 3 Quality Engineering 2010-04-29 09:12:39 UTC
Verified ... and Closing all issues resolved into NetBeans 6.7 and earlier.