Configure Stardog as JNDI for WAS

[justforthe...@gmail.com]

We have been looking for information all around but couldn't find anything.

Is there any example to configure a JNDI connection over a WAS (like Tomcat 8)?

Ex.  http://docs.oracle.com/javaee/6/tutorial/doc/bncjj.html

https://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html

We have seen the examples to create the connection pool with code, but in a Web project, the server should manage it for us (this is how we have it with our relational database). Basically we need to know how to fill this structure:

<Context>

    <Resource name="...." type="javax.sql.DataSource"

        maxActive="100" maxIdle="30" maxWait="10000" 

        url="...."

        driverClassName="???"

        username="admin" password="admin" />

</Context>

Thank you in advance.

NOTE: We have seen there is a Spring project, but we don't use Spring.

[Kendall Clark]

What version of Stardog are you using? Developer or Community?

--
-- --
You received this message because you are subscribed to the C&P "Stardog" group.
To post to this group, send email to sta...@clarkparsia.com
To unsubscribe from this group, send email to
stardog+u...@clarkparsia.com
For more options, visit this group at
http://groups.google.com/a/clarkparsia.com/group/stardog?hl=en

[justforthe...@gmail.com]

Community.

Thanks.

[justforthe...@gmail.com]

Anybody has experience with this?  Or can share a pointer to the right information source?

Any help is greatly appreciated

[Zachary Whitley]

I haven't done it myself but I'd start here [1]

You'd need to register either a ConnectionPool or Connection which is probably going to take a little work to get just right. It would be great if you could post the results for anyone interested in following in your footsteps. Let me know if you have any trouble and I'll try to help. 

[1] https://tomcat.apache.org/tomcat-6.0-doc/config/context.html#Resource%20Definitions

---
You received this message because you are subscribed to the Google Groups "Stardog" group.
To unsubscribe from this group and stop receiving emails from it, send an email to stardog+u...@clarkparsia.com.

[Jeremy Iron]

Thanks for your help, I will update my results.

I knew about your pointer, that is how normally you will load MySQL for example. But when it comes to Stardog we are a bit lost... Because as seen at [http://tomcat.apache.org/tomcat-8.0-doc/jndi-resources-howto.html#JDBC_Data_Sources]  this information has to be provided:

<Context>

    <Resource name="...." type="javax.sql.DataSource"

        maxActive="100" maxIdle="30" maxWait="10000" 

        url="...."

        driverClassName="???"

        username="admin" password="admin" />

</Context>

As the documentation says, "Use of the JDBC Data Sources JNDI Resource Factory requires that you make an appropriate JDBC driver available to both Tomcat internal classes and to your web application.". Normally the driverClassName is a single JAR file provided by, for example, MySQL, Oracle or MSSQL. So I am a bit lost about what to use in the case of Stardog.

I have found some hints "NOTE: Stardog does not ship with JDBC drivers." at [https://github.com/Complexible/stardog-docs/blob/master/src/doc/virtual-graphs.ad], but it doesn't seem to apply to my case, since it is about Stardog Virtual Graphs using relational databases.

---
You received this message because you are subscribed to a topic in the Google Groups "Stardog" group.
To unsubscribe from this topic, visit https://groups.google.com/a/clarkparsia.com/d/topic/stardog/fJvAOQ8HOIo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to stardog+u...@clarkparsia.com.

[Zachary Whitley]

On Apr 21, 2016, at 7:01 AM, Jeremy Iron <justforthe...@gmail.com> wrote:

Thanks for your help, I will update my results.

I knew about your pointer, that is how normally you will load MySQL for example. But when it comes to Stardog we are a bit lost... Because as seen at [http://tomcat.apache.org/tomcat-8.0-doc/jndi-resources-howto.html#JDBC_Data_Sources]  this information has to be provided:

<Context>

    <Resource name="...." type="javax.sql.DataSource"

        maxActive="100" maxIdle="30" maxWait="10000" 

        url="...."

        driverClassName="???"

        username="admin" password="admin" />

</Context>

As the documentation says, "Use of the JDBC Data Sources JNDI Resource Factory requires that you make an appropriate JDBC driver available to both Tomcat internal classes and to your web application.". Normally the driverClassName is a single JAR file provided by, for example, MySQL, Oracle or MSSQL. So I am a bit lost about what to use in the case of Stardog.

I know they make it very easy to work with jdbc data sources but I don't think it can only be used with them. 

I have found some hints "NOTE: Stardog does not ship with JDBC drivers." at [https://github.com/Complexible/stardog-docs/blob/master/src/doc/virtual-graphs.ad], but it doesn't seem to apply to my case, since it is about Stardog Virtual Graphs using relational databases.

You'd need to set that up in Stardog assuming your running it as a stand alone instance and not in the server container which would probably require even more configuration to set up. 

[Zachary Whitley]

Here yay go, custom resource factories. https://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howto.html#Adding_Custom_Resource_Factories

I don't think you mentioned what version of tomcat you're targeting. 

On Apr 21, 2016, at 7:01 AM, Jeremy Iron <justforthe...@gmail.com> wrote:

[Jeremy Iron]

Mmmm.. I will check these days if this works with a Custom resource factory. I have used that before, but just to provide objects. This will supply only connections and keep a static ConnectionPool. Not sure if a close/destroy method can be implemented too (I have experienced before having a pool in Java still active while it has been closed by Stardog). Will check and will get back.

I'm using v8, but v7 is fine too.

[Jeremy Iron]

I will check this as well:

https://github.com/Complexible/stardog-spring/blob/master/stardog-spring/src/main/java/com/complexible/stardog/ext/spring/DataSource.java

By the way, every time I see an IF without the corresponding block { } I think of GOTOFAIL  [https://nakedsecurity.sophos.com/2014/02/24/anatomy-of-a-goto-fail-apples-ssl-bug-explained-plus-an-unofficial-patch/]

[Al Baker]

The DataSource in the Spring extension was modeled after matching the typical JDBC workflow common to Tomcat/Spring apps. There is a corresponding SnarlTemplate that mirrors JdbcTemplate.

Pull requests welcome too :)

Al

[Jeremy Iron]

Thanks Al. I think that code will help me as well.