El 18/05/12 00:21, Alessio Stalla escribió:
On Thu, May 17, 2012 at 11:04 PM, Francisco Vides Fernández <fvides@igaleno.com> wrote:
Hello everyone
I intend to use ABCL in one of my projects. I've started to connectiing to a postgresq database via jdbc. I've tried something like:
-------8<------- (add-to-classpath (merge-pathnames #p".m2/repository/postgresql/postgresql/8.4-702.jdbc4/postgresql-8.4-702.jdbc4.jar" (user-homedir-pathname)))
(jstatic "forName" "java.lang.Class" "org.postgresql.Driver") -------8<-------
But it always returns -------8<------- Java exception 'java.lang.ClassNotFoundException: org.postgresql.Driver'. [Condition of type JAVA-EXCEPTION] -------8<------- The jar file exists, and has the proper class inside. I've read the manual, and googled a bit, but still get the same error. I'm using Ubuntu Linux, with OpenJDK 1.6.0_24, and the latest and greatest ABCL downloaded as a binary from ABCL website. Can someone point me what I'm doing wrong? TL;DR: use (java:jclass "org.postgresql.Driver"). [snip]
Yes, that did the trick, but now I've the following code: --------------8x-------------- (java:jclass "org.postgresql.Driver") #<java.lang.Class class org.postgresql.Driver {67AFF9E8}> ;; the driver loads, yay! (java:jstatic "getConnection" "java.sql.DriverManager" "jdbc:postgresql://localhost:5432/test") --------------8x-------------- Throws: --------------8x-------------- Java exception 'java.sql.SQLException: No suitable driver found for jdbc:postgresql://localhost:5432/test'. [Condition of type JAVA-EXCEPTION] --------------8x-------------- But the equivalent java code works: --------------8x-------------- public class JdbcConn { public static void main(String[] args) { try { Class.forName("org.postgresql.Driver"); java.sql.Connection c = java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/test"); } catch(Exception e) { e.printStackTrace(System.err); } } } --------------8x-------------- I fail to see how the ClassLoader machinery affects this. The org.postgresql.Driver class self-registers with driver manager, in a static block of code: --------------8x-------------- java.sql.DriverManager.registerDriver(new Driver()); --------------8x-------------- But apparently that isn't happening. I've even tried to do that by hand but nothing. Some clue on what's happening? -- +----------------- | Francisco Vides Fernández <fvides@igaleno.com> | Gerente | Teléfono fijo: 952 60 29 59 | Fax: 952 60 29 59 | igaleno http://www.igaleno.com/ +------