You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Hervé Guidetti <He...@idbsoft.ch> on 2001/06/05 16:08:38 UTC
Postgres and SQL Server.
Hi,
I'm using Turbine with MySQL for more than one year. It's great.
A client needs an application with transactions. So I need to change the DB
server.
Before I choose another DB, I would like to know if anybody has already used
Postgres and SQL Server (my client has already a SQL Server DB).
Do you have advises about this two database server ?
Thanks,
Hervé
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Postgres and SQL Server.
Posted by Jon Stevens <jo...@latchkey.com>.
You know, you can define your own TurbineUserPeer instead of modifying
the Turbine source...
-jon
On Tue, 5 Jun 2001, Jerome Verleyen wrote:
> Jason van Zyl wrote:
> >
> > I have run into an issue with Postgres and Village. The error
> > I get occurs in flux and most likely has something to do
> > with blobs...
>
> Yes, that is the Hashtable of TurbineUser that pose problem whith
> PostGresql. When I comment the method "setPermStorage" in the
> TurbineUserPeer file from the cvs sources of turbine, all is going
> good...
> If could help..
> jerome verleyen
> If this could
>
>
> --
> fufe veut dire fr.usenet.forums.evolution.
> Franck, c'est Fr.annonces.convocations.kabal
> -+- JPK in: Guide du Cabaliste Usenet - Petit Lexique Illustr� -+-
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Postgres and SQL Server.
Posted by Jerome Verleyen <je...@ibt.unam.mx>.
Jason van Zyl wrote:
>
> I have run into an issue with Postgres and Village. The error
> I get occurs in flux and most likely has something to do
> with blobs...
Yes, that is the Hashtable of TurbineUser that pose problem whith
PostGresql. When I comment the method "setPermStorage" in the
TurbineUserPeer file from the cvs sources of turbine, all is going
good...
If could help..
jerome verleyen
If this could
--
fufe veut dire fr.usenet.forums.evolution.
Franck, c'est Fr.annonces.convocations.kabal
-+- JPK in: Guide du Cabaliste Usenet - Petit Lexique Illustré -+-
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Postgres and SQL Server.
Posted by Jason van Zyl <jv...@apache.org>.
Hervé Guidetti wrote:
>
> Hi,
>
> I'm using Turbine with MySQL for more than one year. It's great.
>
> A client needs an application with transactions. So I need to change the DB
> server.
>
> Before I choose another DB, I would like to know if anybody has already used
> Postgres and SQL Server (my client has already a SQL Server DB).
>
> Do you have advises about this two database server ?
I have run into an issue with Postgres and Village. The error
I get occurs in flux and most likely has something to do
with blobs. When I get back home (I'm in SF right now) I plan
to track the error down. Flux works with Postgres in Tambora
but we are using village 1.3 so something has gone amiss
somewhere. I will find it soon.
I am also building a box which will have all the supported
turbine databases installed on it and I'm going to set up
a testing harness with the TDK so that the TDK sample
application will be build over and over again using all
the database configurations to make sure things keep
working over time.
>
> Thanks,
>
> Hervé
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
--
jvz.
Jason van Zyl
jvanzyl@apache.org
http://jakarta.apache.org/velocity
http://jakarta.apache.org/turbine
http://jakarta.apache.org/commons
http://tambora.zenplex.org
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
RE: Postgres and SQL Server.
Posted by Sean Leach <sl...@netlojix.com>.
Looking at the source code, it will look at the TurbineResources file for
all of the
database.adaptor
entries, and if it matches one in the
java/org/apache/turbine/util/db/adapter
source directory, it will load it, otherwise it will fail with that error
message.
Try putting
database.adaptor=DBMSSQL
database.adaptor.DBMSSQL=weblogic.jdbc.mssqlserver4.Driver
into your TurbineResources.properties file.
Looks like that driver just uses the Sybase adapator code.
Turbine developers - let me know if I am way off :)
Sean
-----------------------------------------------------
Sean Leach
Director of Technology | eBusiness Services
NetLojix Communications, Inc. NASDAQ: NETX
e - sleach@netlojix.com
v - 805.884.6375
f - 805.883.5627
w - www.netlojix.com
-----Original Message-----
From: turbine-user-return-2281-sleach=netlojix.com@jakarta.apache.org
[mailto:turbine-user-return-2281-sleach=netlojix.com@jakarta.apache.org]
On Behalf Of michele porceddu cilione
Sent: Tuesday, June 05, 2001 7:52 AM
To: turbine-user@jakarta.apache.org
Subject: Re: Postgres and SQL Server.
----- Original Message -----
From: "Sean Leach" <sl...@netlojix.com>
To: <tu...@jakarta.apache.org>
Sent: Tuesday, June 05, 2001 4:33 PM
Subject: RE: Postgres and SQL Server.
> I have never personally used SQL Server with turbine (driver problem I
> mentioned), when I said production, I have used it with Cold Fusion and
Site
> Server on several projects. As for turbine, it has all of the velocity
> files for mssql etc., so I would assume setting the properties correctly
in
> build.properties with the correct JDBC URL etc. and the type to mssql
would
> be good. What kind of problem are you having?
to be exact, I'm triyng to use MSsql with jetspeed...so, as the db
"interface" for jetspeed is provided by turbine, I'm indirectly using it
with turbine
in fact, one of the jetspeed configuration files, named
"TurbineResources.properties" is designated to contain the db connection URL
for your jetspeed webapp, by means of four lines looking like this
database.default.driver=weblogic.jdbc.mssqlserver4.Driver
database.default.url=jdbc:weblogic:mssqlserver4:turbine_jetspeed@localhost:1
433
database.default.username=sa
database.default.password=
the parameters are correct, but the stack trace present me with:...
Error=Turbine.handleException: Error in
BasePeer.initTableSchema(TURBINE_USER):
Database type weblogic.jdbc.mssqlserver4.Driver not implemented.
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Postgres and SQL Server.
Posted by michele porceddu cilione <po...@pow2.com>.
----- Original Message -----
From: "Sean Leach" <sl...@netlojix.com>
To: <tu...@jakarta.apache.org>
Sent: Tuesday, June 05, 2001 4:33 PM
Subject: RE: Postgres and SQL Server.
> I have never personally used SQL Server with turbine (driver problem I
> mentioned), when I said production, I have used it with Cold Fusion and
Site
> Server on several projects. As for turbine, it has all of the velocity
> files for mssql etc., so I would assume setting the properties correctly
in
> build.properties with the correct JDBC URL etc. and the type to mssql
would
> be good. What kind of problem are you having?
to be exact, I'm triyng to use MSsql with jetspeed...so, as the db
"interface" for jetspeed is provided by turbine, I'm indirectly using it
with turbine
in fact, one of the jetspeed configuration files, named
"TurbineResources.properties" is designated to contain the db connection URL
for your jetspeed webapp, by means of four lines looking like this
database.default.driver=weblogic.jdbc.mssqlserver4.Driver
database.default.url=jdbc:weblogic:mssqlserver4:turbine_jetspeed@localhost:1
433
database.default.username=sa
database.default.password=
the parameters are correct, but the stack trace present me with:...
Error=Turbine.handleException: Error in
BasePeer.initTableSchema(TURBINE_USER):
Database type weblogic.jdbc.mssqlserver4.Driver not implemented.
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
RE: Postgres and SQL Server.
Posted by Sean Leach <sl...@netlojix.com>.
I have never personally used SQL Server with turbine (driver problem I
mentioned), when I said production, I have used it with Cold Fusion and Site
Server on several projects. As for turbine, it has all of the velocity
files for mssql etc., so I would assume setting the properties correctly in
build.properties with the correct JDBC URL etc. and the type to mssql would
be good. What kind of problem are you having?
Sean
-----Original Message-----
From: turbine-user-return-2279-sleach=netlojix.com@jakarta.apache.org
[mailto:turbine-user-return-2279-sleach=netlojix.com@jakarta.apache.org]
On Behalf Of mip
Sent: Tuesday, June 05, 2001 7:31 AM
To: turbine-user@jakarta.apache.org
Subject: Re: Postgres and SQL Server.
----- Original Message -----
From: "Sean Leach" <sl...@netlojix.com>
To: <tu...@jakarta.apache.org>
Sent: Tuesday, June 05, 2001 4:15 PM
Subject: RE: Postgres and SQL Server.
> We have used both in a production environment, and they both work well.
sean, have you got any suggestion about how to make SQL Server work with
turbine?
I'm trying to make it with BEA's weblogicSQL driver (type 4), but to no
avail...
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Postgres and SQL Server.
Posted by mip <po...@pow2.com>.
----- Original Message -----
From: "Sean Leach" <sl...@netlojix.com>
To: <tu...@jakarta.apache.org>
Sent: Tuesday, June 05, 2001 4:15 PM
Subject: RE: Postgres and SQL Server.
> We have used both in a production environment, and they both work well.
sean, have you got any suggestion about how to make SQL Server work with
turbine?
I'm trying to make it with BEA's weblogicSQL driver (type 4), but to no
avail...
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
RE: Postgres and SQL Server.
Posted by Sean Leach <sl...@netlojix.com>.
We have used both in a production environment, and they both work well. SQL
Server is actually a very good database, though we prefer *nix stuff. I
would recommened PostgreSQL over it though since it's free and open source.
I think (pretty sure) the only good JDBC drivers for SQL Server are
commercial, except JDBC-ODBC and the freetds stuff, which is not recommended
for a production environment. Any one used a non-commercial JDBC driver in
the wild with SQL Server?
Sean
-----Original Message-----
From: turbine-user-return-2277-sleach=netlojix.com@jakarta.apache.org
[mailto:turbine-user-return-2277-sleach=netlojix.com@jakarta.apache.org]
On Behalf Of Hervé Guidetti
Sent: Tuesday, June 05, 2001 7:09 AM
To: Turbine User (E-mail)
Subject: Postgres and SQL Server.
Hi,
I'm using Turbine with MySQL for more than one year. It's great.
A client needs an application with transactions. So I need to change the DB
server.
Before I choose another DB, I would like to know if anybody has already used
Postgres and SQL Server (my client has already a SQL Server DB).
Do you have advises about this two database server ?
Thanks,
Hervé
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Postgres and SQL Server.
Posted by Jon Stevens <jo...@latchkey.com>.
on 6/6/01 10:51 AM, "Daniel Rall" <dl...@finemaltcoding.com> wrote:
> This is only a recent development, btw. You may need to upgrade your
> MySQL installation.
More than a year ago now...
<http://www.mysql.com/news/article-18.html>
Sure, it might not have been 100% stable up until a few months ago, but it
has been in there for quite some time.
-jon
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Postgres and SQL Server.
Posted by Rodney Schneider <ro...@bicamera.com>.
Hi,
Given that this is a recent development, has anyone actually had any
experience with the MySQL transaction support? Is it considered ready to
be used in a production environment?
I know this is off-topic, but I am considering using MySQL transactions
with Turbine in my current project. Any comments would be really
appreciated.
Thanks,
-- Rodney
On 6 Jun 2001, Daniel Rall wrote:
> This is only a recent development, btw. You may need to upgrade your
> MySQL installation.
>
> Jon Stevens <jo...@latchkey.com> writes:
>
> > MySQL supports transactions.
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Postgres and SQL Server.
Posted by Daniel Rall <dl...@finemaltcoding.com>.
This is only a recent development, btw. You may need to upgrade your
MySQL installation.
Jon Stevens <jo...@latchkey.com> writes:
> MySQL supports transactions.
>
>
> On Tue, 5 Jun 2001, [iso-8859-1] Hervé Guidetti wrote:
>
> > Hi,
> >
> > I'm using Turbine with MySQL for more than one year. It's great.
> >
> > A client needs an application with transactions. So I need to change the DB
> > server.
> >
> > Before I choose another DB, I would like to know if anybody has already used
> > Postgres and SQL Server (my client has already a SQL Server DB).
> >
> >
> > Do you have advises about this two database server ?
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: Postgres and SQL Server.
Posted by Jon Stevens <jo...@latchkey.com>.
MySQL supports transactions.
On Tue, 5 Jun 2001, [iso-8859-1] Herv� Guidetti wrote:
> Hi,
>
> I'm using Turbine with MySQL for more than one year. It's great.
>
> A client needs an application with transactions. So I need to change the DB
> server.
>
> Before I choose another DB, I would like to know if anybody has already used
> Postgres and SQL Server (my client has already a SQL Server DB).
>
>
> Do you have advises about this two database server ?
>
> Thanks,
>
> Herv�
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org