Ignite JDBC Driver URL Question:

[techbysample <tu...@netmille.com>]

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.

Re: Ignite JDBC Driver URL Question:

[techbysample <tu...@netmille.com>]

Apache Community,

I figured out my problem as I was missing the ':' after 'cfg' :(


'jdbc:ignite:cfg://cache=MESSAGECACHE@file:///c:/netmilleRoot/tools/apache-ignite-fabric-1.4.0-bin/examples/config/example-ignite.xml'

Oh well, Thanks!

Regards,
techbysample



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