Help coderanch get a
new server
by contributing to the fundraiser
  • 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

how to use MSSQL Database?

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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]
 
What do you have to say for yourself? Hmmm? Anything? And you call yourself a tiny ad.
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic