how to use MSSQL Database?

[Migrated From Jforum.net]

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]

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]

great, I will watch this space
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

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]

It's done
Now it's on Rafael's ;)
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Yep, support for sql-server is commited to the cvs.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

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

java.io.FileNotFoundException: C:\MYAPPS\resin-2.1.11\webapps\jforum_cvs\install\sqlserver_structure.dat (The system cannot find the file specified)

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]

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]

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]

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]

Thank you.
I will update this lib.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

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]

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]

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]

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]