I want to make a C# app query (select, insert, update, delete) a JDBC based database, specifically one called Derby by Apache. But I do not want to get a 3rd party anything for this.
Surely, someone has made a way to bridge C# to JDBC? I'd even consider raw socket programming, so long as it did not require downloading any 3rd party tools.
Thanks Lorris for the reply, but all of those links are from something else, other than C#/.NET, using JDBC, to SQL-Server and/or an otherwise ADO.NET compliant database.
I need the reverse, I need C#/.NET to connect to a JDBC based database, namely a Derby database. Do you know of any solution for this?
I had checked out Codemesh, and Easysoft, and a few others, but they were proprietary, to my knowledge, and required one to purchase a license.
I was hoping to find something free-ware. Also, the second link you gave "using JDBC from .NET article" did not come through, could you please repost that link.
Ah, thanks again Lannie. Sadly, I'm still stuck, as codemesh is a licensed 3rd party product. It seems strange that no JDBC-Driver for ADO.NET exists. I'd even take pure socket communication to a JDBC/Derby based connection if I could.
Member
3 Points
107 Posts
HOWTO Connect to a JDBC/Apache-Derby Data Source without any 3rd party.
Jul 20, 2015 11:22 AM|J-S-B|LINK
Please help,
I want to make a C# app query (select, insert, update, delete) a JDBC based database, specifically one called Derby by Apache. But I do not want to get a 3rd party anything for this.
Surely, someone has made a way to bridge C# to JDBC? I'd even consider raw socket programming, so long as it did not require downloading any 3rd party tools.
Member
580 Points
142 Posts
Re: HOWTO Connect to a JDBC/Apache-Derby Data Source without any 3rd party.
Aug 12, 2015 04:29 AM|Lorris|LINK
Hi J-S-B,
From your description, I'm not sure which kind of database you are using in your application.
Here are some relevant articles about connecting to SQL Server with the JDBC Driver, perhaps they can help you.
https://msdn.microsoft.com/en-us/library/ms378672(v=SQL.110).aspx
http://ccm.net/faq/29441-connecting-to-a-database-using-jdbc
https://msdn.microsoft.com/en-us/library/Aa478977.aspx
http://blogs.msdn.com/b/brian_swan/archive/2011/03/02/getting-started-with-the-sql-server-jdbc-driver.aspx
Best Regards,
Lorris
Member
3 Points
107 Posts
Re: HOWTO Connect to a JDBC/Apache-Derby Data Source without any 3rd party.
Aug 12, 2015 07:58 AM|J-S-B|LINK
Thanks Lorris for the reply, but all of those links are from something else, other than C#/.NET, using JDBC, to SQL-Server and/or an otherwise ADO.NET compliant database.
I need the reverse, I need C#/.NET to connect to a JDBC based database, namely a Derby database. Do you know of any solution for this?
Contributor
3382 Points
1316 Posts
Re: HOWTO Connect to a JDBC/Apache-Derby Data Source without any 3rd party.
Aug 12, 2015 09:26 AM|Lannie|LINK
http://codemesh.com/products/juggernet/examples/jdbc.html
using JDBC from .NET article
Member
3 Points
107 Posts
Re: HOWTO Connect to a JDBC/Apache-Derby Data Source without any 3rd party.
Aug 12, 2015 09:57 AM|J-S-B|LINK
Thanks Lannie.
I had checked out Codemesh, and Easysoft, and a few others, but they were proprietary, to my knowledge, and required one to purchase a license.
I was hoping to find something free-ware. Also, the second link you gave "using JDBC from .NET article" did not come through, could you please repost that link.
Contributor
3382 Points
1316 Posts
Re: HOWTO Connect to a JDBC/Apache-Derby Data Source without any 3rd party.
Aug 12, 2015 01:32 PM|Lannie|LINK
second one was just formatted underline by TYPO, not a link
Member
3 Points
107 Posts
Re: HOWTO Connect to a JDBC/Apache-Derby Data Source without any 3rd party.
Aug 12, 2015 01:39 PM|J-S-B|LINK
Ah, thanks again Lannie. Sadly, I'm still stuck, as codemesh is a licensed 3rd party product. It seems strange that no JDBC-Driver for ADO.NET exists. I'd even take pure socket communication to a JDBC/Derby based connection if I could.
I did find this: http://derby-net.win7dwnld.com/ and its link on source-forge here: http://sourceforge.net/projects/derbynet/
Sadly, this is still a 3rd party, with no source-code, so I can't trust it either.