Hi Tom,
some JDBC initialisation code that works:
Java.type("org.apache.derby.jdbc.ClientDriver");
var connection =
java.sql.DriverManager.getConnection("jdbc:derby://localhost:1527/sample;user=app;password=app",
null);
JF
On Feb 1, 2014, at 4:07 PM, Tom McGinn <[email protected]> wrote:
> Thanks Jim -
>
> That's what I needed. Here's the working code:
>
> var driverClass = Java.type("org.apache.derby.jdbc.ClientDriver");
> var driver = new driverClass();
> var conn =
> driver.connect("jdbc:derby://localhost:1527/sample;user=app;password=app",
> null);
> var stmt = conn.createStatement();
> var rs = stmt.executeQuery("SELECT NAME FROM Customer");
> while (rs.next()) {
> print(rs.getString(1));
> }
>
> However, this code does not work:
>
> var driverManager = Java.type("java.sql.DriverManager");
> var conn =
> driverManager.getConnection("jdbc:derby://localhost:1527/sample;user=app;password=app");
>
> A SQLException is thrown: No suitable driver found for
> jdbc:derby://localhost:1527/sample;user=app;password=app
>
> I may have missed this, but I guess that static initialization blocks are not
> executed? DriverManager would have executed
> this during initialization:
>
> static {
> loadInitialDrivers();
> println("JDBC DriverManager initialized");
> }
>
> Thanks again,
>
> Tom
>
>
> On 1/31/2014 8:20 PM, Jim Laskey (Oracle) wrote:
>> Since I don't have the jar handy, I'm just guessing, but why wouldn't you
>> just;
>>
>> jjs> var driverClass = Java.type("org.apache.derby.jdbc.ClientDriver");
>>
>> -- Jim
>>
>> On Jan 31, 2014, at 7:43 PM, Tom McGinn <[email protected]> wrote:
>>
>>> Hello -
>>>
>>> I am trying to create a JS file that illustrates using Java classes mixed
>>> with JS.
>>>
>>> I am trying to connect to the sample JavaDB instance, but am not able to
>>> load the driver class.
>>>
>>> jjs -cp /home/tmcginn/jdk1.8.0/db/lib/derbyclient.jar
>>> jjs> var driver = "org.apache.derby.jdbc.ClientDriver";
>>> jjs> Java.type("java.lang.Class").forName(driver);
>>> java.lang.RuntimeException: java.lang.ClassNotFoundException:
>>> org.apache.derby.jdbc.ClientDriver
>>>
>>> I think I am missing something obvious....
>>>
>>> I am running this on Oracle Linux 6 u3 on an OVM.
>>>
>>> Thanks,
>>>
>>> Tom
>>>
>>> --
>>>
>>>
>>> Tom McGinn | Java Curriculum Developer
>>> OracleServer Technologies Curriculum Development
>>> Phone: +1.781.442.0621
>>> Mail: [email protected]
>>> Blog: Java Training Beat <https://blogs.oracle.com/javatraining/>
>>>
>
> --
>
>
> Tom McGinn | Java Curriculum Developer
> OracleServer Technologies Curriculum Development
> Phone: +1.781.442.0621
> Mail: [email protected]
> Blog: Java Training Beat <https://blogs.oracle.com/javatraining/>
>
