ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From techbysample <tu...@netmille.com>
Subject Ignite JDBC Driver URL Question:
Date Fri, 23 Oct 2015 21:17:56 GMT
Apache Ignite Community,

Given my environment:

Environment
--------------
   Apache Ignite: 1.4
   OS: Windows 8.1

I am attempting to use the Ignite JDBC Driver and Ignite is throwing
errors related to my JDBC URL string.
Basically, my configuration file is located on my system at the following
location
on Windows:

C:\netmilleRoot\tools\apache-ignite-fabric-1.4.0-bin\examples\config\example-ignite.xml

My Code Snippet:

// Register JDBC driver.
    	Class.forName("org.apache.ignite.IgniteJdbcDriver");
    	
    	// Open JDBC connection (cache name is not specified, which means that
we use default cache).
    	Connection conn =
DriverManager.getConnection("jdbc:ignite:cfg//cache=MESSAGECACHE@file:///c:/netmilleRoot/tools/apache-ignite-fabric-1.4.0-bin/examples/config/example-cache.xml");
    	    
    	// Query names of all people.
    	ResultSet rs = conn.createStatement().executeQuery("select * from
Message");
    	 
    	while (rs.next()) {
    	    String name = rs.getString(1);
    	    System.out.println("name " + name);
    	
    	}
    
Error Message:

16:12:49] Ignite node stopped OK [uptime=00:01:30:124]
Exception in thread "main" java.sql.SQLException: URL is invalid:
jdbc:ignite:cfg//cache=MESSAGECACHE@file:///c:/netmilleRoot/tools/apache-ignite-fabric-1.4.0-bin/examples/config/example-cache.xml
	at org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:341)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at
org.apache.ignite.jboss.esb.message.CacheJdbcMessageStoreExampleDriver4.executeJDBC(CacheJdbcMessageStoreExampleDriver4.java:169)
	at
org.apache.ignite.jboss.esb.message.CacheJdbcMessageStoreExampleDriver4.main(CacheJdbcMessageStoreExampleDriver4.java:130)

Any help would be greatly appreciated.

Regards,
techbysample




--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Ignite-JDBC-Driver-URL-Question-tp1685.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message