Win a copy of Five Lines of Code this week in the OO, Patterns, UML and Refactoring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

how to use MSSQL Database?

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
One user already made the sqlserver port, but I don't have it in hands yet. I can made it available for download when I get the files, and then you can integrate with your jforum installation.

If you want this, please keep an eye here

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,

I'm evaluatung java based forum software and I loke what I see here at JForum

Is there any way to use a MS SQL Server as database backend?
I have some java experience, I could perhaps do some coding on that feature


thanks
Jens
[originally posted on jforum.net by Ansorg]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
great, I will watch this space
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Ansorg wrote:hi,

I'm evaluatung java based forum software and I loke what I see here at JForum

Is there any way to use a MS SQL Server as database backend?
I have some java experience, I could perhaps do some coding on that feature


thanks
Jens



Probably tomorrow I will send the new implementation to Rafael and then u can use the application with MSSQL ;)
[originally posted on jforum.net by andre_a_s]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's done
Now it's on Rafael's ;)
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yep, support for sql-server is commited to the cvs.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Great news!

I checked out code from CVS, I added an option for sqlserver to the template install.htm, tried to set up te forum: get an error about



Does the sqlserver structure exist yet?
I could try to create this myself based on the other database structures.

[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ups, that last anonymous was me

hm, looking at the database_structure.dat and dump.dat now ... there is some SQL inside but it's not plain SQL files. How are they made?


[originally posted on jforum.net by Ansorg]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please use manual installation for now. The .dat files are serialized ArrayLists, where each entry is a SQL statement to execute.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There is a much better driver for SQL Server than the microsoft one. Get it here http://jtds.sourceforge.net/
[originally posted on jforum.net by campers]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you.
I will update this lib.
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've developed a forum for one of our clients using MySQL, and at the last minute their IT department is all "we don't know MySQL, we're scared, boo hoo" so they want us to change it to MSSQLServer. I'm using 2.0.2, would using this implementation work or would I need to update to the CVS version?
[originally posted on jforum.net by mattcoz]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You need to get the cvs version. I'll not include support for sqlserver or Oracle in the incoming 2.1 release, because I didn't tested the code (which is a port made by someone else). I guess it is working, but it's up to you.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Rafael,

Do you have any date in mind for Oracle or MSSQL to be incorporated into binary download? I would like to use JForum but Oracle/MSSQL feature is essential for me.

Thanks.

Win
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Support for sqlserver is not complete.. it lacks pagination and some other issues. You can always get it from cvs and finish it.
Oracle support also needs to be finished, but it's much more complete than sqlserver. Alone I can't support and test all databases.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Our first order of business must be this tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic