hi,
thanks for your answer. We need MSSQL2000/2005/2008 and in jetspeed
2.1.3 it works correctly.
The connectin is now ok, but I get following error:
org.apache.jetspeed.serializer.SerializerException: Creating an instance
from a
serialized representation of SecurityDomains failed with message Could
not creat
e default and / or system domains!
OJB operation; bad SQL grammar []; nested exception is
java.sql.SQLException: Un
g³ltiger Objektname 'SECURITY_DOMAIN'.
at
org.apache.jetspeed.serializer.JetspeedSecuritySerializer.recreateSec
urityDomains(JetspeedSecuritySerializer.java:256)
kind regards,
Frank
Ate Douma schrieb:
Frank Otto wrote:
Thanks, but I have no artifact properties for mssql jdbc driver.
The property "org.apache.jetspeed.production.jdbc.drivers.path"
doesn't work.
That property is no longer used for Jetspeed 2.2.0
Please use the instructions as described here:
http://portals.apache.org/jetspeed-2/buildguide/maven-2-build.html
An example mssql configuration I've used myself (quite) sometime ago
which worked for an earlier build of Jetspeed-2.2-SNAPSHOT
would be the following:
<org.apache.jetspeed.production.database.default.name>mssql</org.apache.jetspeed.production.database.default.name>
<org.apache.jetspeed.production.jdbc.driver.groupId>net.sourceforge.jtds</org.apache.jetspeed.production.jdbc.driver.groupId>
<org.apache.jetspeed.production.jdbc.driver.artifactId>jtds</org.apache.jetspeed.production.jdbc.driver.artifactId>
<org.apache.jetspeed.production.jdbc.driver.version>1.2.2</org.apache.jetspeed.production.jdbc.driver.version>
<org.apache.jetspeed.production.database.driver>net.sourceforge.jtds.jdbc.Driver</org.apache.jetspeed.production.database.driver>
<org.apache.jetspeed.production.database.url>
<![CDATA[jdbc:jtds:sqlserver://localhost:1433/j2;socketTimeout=150]]>
</org.apache.jetspeed.production.database.url>
<org.apache.jetspeed.production.database.user>j2</org.apache.jetspeed.production.database.user>
<org.apache.jetspeed.production.database.password>j2</org.apache.jetspeed.production.database.password>
Be aware though that AFAIK the mssql support in the current 2.2.0
released version might not be up to par with the other databases.
The problem with mssql is that it requires manual definition of its
database schema. Its so much different and lacking in certain areas of
standard SQL support that automatically generating the schema like we do
for all other databases just isn't doable.
We do have some handling for that, overriding the schema generation with
hand written mssql scripts, but AFAIK those might not be fully updated
yet with some recent model changes.
FYI, these mssql scripts are defined here (and applied during database
creation):
http://svn.apache.org/repos/asf/portals/jetspeed-2/portal/trunk/jetspeed-portal-resources/src/main/resources/ddl/mssql
As none of the jetspeed committers has clients using mssql anymore
(either moved to more standard databases or elsewhere),
the priority to keep supporting mssql has dwindled a bit.
That doesn't mean we don't want or will keep supporting mssql, but for
that we have to rely on the community to support us with error reports
and patches.
The above configuration is know to work if you check out the
http://svn.apache.org/repos/asf/portals/jetspeed-2/portal/branches/JETSPEED-2.2-PRE-PLUTO-2-SNAPSHOT
branch, but using that branch really is not advisable.
If you really need to use mssql, I advise just trying the above
configuration out and see if/where it breaks.
From there, you can try to determine the changes needed (like comparing
it against the generated schema scripts for other databases)
and we'll be happy to help out applying patches and fixes.
Regards,
Ate
The maven build doesn't find the jdbc driver.
Vivek Kumar schrieb:
See this
http://portals.apache.org/jetspeed-2/buildguide/maven-2-build.html
Vivek
Frank Otto wrote:
how are the settings for mssql database in jetspeed2.2?
I find no informations on jetspeed2.2 documentation (only for
derbydb and mysql).
kind regards
frank
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscr...@portals.apache.org
For additional commands, e-mail: jetspeed-user-h...@portals.apache.org
Delivered-To: fireveloc...@gmail.com
Received: by 10.239.145.203 with SMTP id t11cs510731hba;
Fri, 29 May 2009 02:10:40 -0700 (PDT)
Received: by 10.114.192.17 with SMTP id
p17mr3544424waf.196.12435882393 <http://www.snapanumber.com/>52;
Fri, 29 May 2009 02:10:39 -0700 (PDT)
Return-Path:
<jetspeed-user-return-26685-firevelocity=gmail....@portals.apache.org>
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
by mx.google.com with SMTP id
26si1159924pxi.115.2009.05.29.02.10.38;
Fri, 29 May 2009 02:10:39 -0700 (PDT)
Received-SPF: pass (google.com: domain of
jetspeed-user-return-26685-firevelocity=gmail....@portals.apache.org
designates 140.211.11.3 as permitted sender) client-ip=140.211.11.3;
Authentication-Results: mx.google.com; spf=pass (google.com: domain
of
jetspeed-user-return-26685-firevelocity=gmail....@portals.apache.org
designates 140.211.11.3 as permitted sender)
smtp.mail=jetspeed-user-return-26685-firevelocity=gmail....@portals.apache.org
Received: (qmail 81426 invoked by uid 500); 29 May 2009 09:10:37 -0000
Mailing-List: contact jetspeed-user-h...@portals.apache.org; run by
ezmlm
Precedence: bulk
List-Help: <mailto:jetspeed-user-h...@portals.apache.org>
List-Unsubscribe: <mailto:jetspeed-user-unsubscr...@portals.apache.org>
List-Post: <mailto:jetspeed-user@portals.apache.org>
List-Id: <jetspeed-user.portals.apache.org>
Reply-To: "Jetspeed Users List" <jetspeed-user@portals.apache.org>
Delivered-To: mailing list jetspeed-user@portals.apache.org
Received: (qmail 81416 invoked by uid 99); 29 May 2009 09:10:37 -0000
Received: from athena.apache.org (HELO athena.apache.org)
(140.211.11.136)
by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 29 May 2009
09:10:37 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of o...@delta-barth.de
designates 80.243.61.50 as permitted sender)
Received: from [80.243.61.50] (HELO po.depag.de) (80.243.61.50)
by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 29 May 2009
09:10:29 +0000
Received: from localhost (unknown [127.0.0.1])
by po.depag.de (Postfix) with ESMTP id 400958D110
for <jetspeed-user@portals.apache.org>; Fri, 29 May 2009
11:13:30 +0200 (CEST)
Received: from tati.lr3.depag.de (tati.lr3.depag.de [10.1.0.22])
by po.depag.de (Postfix) with ESMTP id 74CE88D104
for <jetspeed-user@portals.apache.org>; Fri, 29 May 2009
11:13:28 +0200 (CEST)
Received: from [10.1.21.120] (unknown [10.1.21.120])
by tati.lr3.depag.de (Postfix) with ESMTP id 0BD6E8D84
for <jetspeed-user@portals.apache.org>; Fri, 29 May 2009
11:10:06 +0200 (CEST)
Message-ID: <4a1fa66d.6010...@delta-barth.de>
Date: Fri, 29 May 2009 11:10:05 +0200
From: Frank Otto <o...@delta-barth.de>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
To: Jetspeed Users List <jetspeed-user@portals.apache.org>
Subject: Jetspeed 2.2: mssql database maven configuration
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS perl-11
X-Virus-Checked: Checked by ClamAV on apache.org
Hi,
how are the settings for mssql database in jetspeed2.2?
I find no informations on jetspeed2.2 documentation (only for
derbydb and mysql).
kind regards
frank
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscr...@portals.apache.org
For additional commands, e-mail: jetspeed-user-h...@portals.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscr...@portals.apache.org
For additional commands, e-mail: jetspeed-user-h...@portals.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscr...@portals.apache.org
For additional commands, e-mail: jetspeed-user-h...@portals.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscr...@portals.apache.org
For additional commands, e-mail: jetspeed-user-h...@portals.apache.org
