Discussion:
[Hsqldb-user] NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String; ZZ)Lorg/hsqldb/persist/HsqlProperties;
Andrew Rothstein
2010-07-04 04:36:35 UTC
Permalink
When I try to connect to my database:

the database url is of the form : jdbc:hsqldb:file:/path/to/database

java.lang.NoSuchMethodError:
org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:267)
at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:245)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)

I'm just taking a file based database, archiving it, moving it across
my network, unarchiving it, and then attempt to connect to the clone.
I'm using TEXT TABLEs inside the database but the text files are
arriving on the back end intact.

I've looked at the code and I'm thoroughly confused. I don't see
anything offensive about the line where it's puking in its shoes. Any
suggestions? Has anyone seen this type of error before?

regards, Andrew
Fred Toussi
2010-07-04 08:55:53 UTC
Permalink
This looks like you have different HSQLDB jars on the classpath (both
version 2.0 and 1.8). Also, the jar is probably a beta or RC release
(which should still work when used correctly).

Fred

On Sun, 04 Jul 2010 00:36 -0400, "Andrew Rothstein"
Post by Andrew Rothstein
the database url is of the form : jdbc:hsqldb:file:/path/to/database
org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:267)
at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:245)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
I'm just taking a file based database, archiving it, moving it across
my network, unarchiving it, and then attempt to connect to the clone.
I'm using TEXT TABLEs inside the database but the text files are
arriving on the back end intact.
I've looked at the code and I'm thoroughly confused. I don't see
anything offensive about the line where it's puking in its shoes. Any
suggestions? Has anyone seen this type of error before?
regards, Andrew
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
ibytecoder
2011-07-21 22:32:05 UTC
Permalink
I have added 2.2.5 version of hsqldb.jar and I am getting this message. I
have not anyother hsqldb jar file in the classpath as I have added this to
netbeans project properties. The Netbeans services utility is working
perfectly fine and I have created tables and inserted data through it. But
when I use JDBC with it, an error NoSuchMethod occurs.
Please help..
Post by Fred Toussi
This looks like you have different HSQLDB jars on the classpath (both
version 2.0 and 1.8). Also, the jar is probably a beta or RC release
(which should still work when used correctly).
Fred
On Sun, 04 Jul 2010 00:36 -0400, "Andrew Rothstein"
Post by Andrew Rothstein
the database url is of the form : jdbc:hsqldb:file:/path/to/database
org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:267)
at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:245)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
I'm just taking a file based database, archiving it, moving it across
my network, unarchiving it, and then attempt to connect to the clone.
I'm using TEXT TABLEs inside the database but the text files are
arriving on the back end intact.
I've looked at the code and I'm thoroughly confused. I don't see
anything offensive about the line where it's puking in its shoes. Any
suggestions? Has anyone seen this type of error before?
regards, Andrew
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
--
View this message in context: http://old.nabble.com/NoSuchMethodError%3A-org.hsqldb.DatabaseURL.parseURL%28Ljava-lang-String--ZZ%29Lorg-hsqldb-persist-HsqlProperties--tp29067347p32111557.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.
Fred Toussi
2011-07-22 10:00:51 UTC
Permalink
This error can never occur if you have only the 2.2.5 jar in your
classpath.

Fred
Post by ibytecoder
I have added 2.2.5 version of hsqldb.jar and I am getting this message. I
have not anyother hsqldb jar file in the classpath as I have added this to
netbeans project properties. The Netbeans services utility is working
perfectly fine and I have created tables and inserted data through it. But
when I use JDBC with it, an error NoSuchMethod occurs.
Please help..
Post by Fred Toussi
This looks like you have different HSQLDB jars on the classpath (both
version 2.0 and 1.8). Also, the jar is probably a beta or RC release
(which should still work when used correctly).
Fred
On Sun, 04 Jul 2010 00:36 -0400, "Andrew Rothstein"
Post by Andrew Rothstein
the database url is of the form : jdbc:hsqldb:file:/path/to/database
org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
at org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:267)
at org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:245)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
I'm just taking a file based database, archiving it, moving it across
my network, unarchiving it, and then attempt to connect to the clone.
I'm using TEXT TABLEs inside the database but the text files are
arriving on the back end intact.
I've looked at the code and I'm thoroughly confused. I don't see
anything offensive about the line where it's puking in its shoes. Any
suggestions? Has anyone seen this type of error before?
regards, Andrew
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
--
http://old.nabble.com/NoSuchMethodError%3A-org.hsqldb.DatabaseURL.parseURL%28Ljava-lang-String--ZZ%29Lorg-hsqldb-persist-HsqlProperties--tp29067347p32111557.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
10 Tips for Better Web Security
Learn 10 ways to better secure your business today. Topics covered
Web security, SSL, hacker attacks & Denial of Service (DoS), private
keys,
security Microsoft Exchange, secure Instant Messaging, and much more.
http://www.accelacomm.com/jaw/sfnl/114/51426210/
_______________________________________________
Hsqldb-user mailing list
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
Loading...