Dear All,
what about the database schema?
http://kjkoster.org/java/ Hunt around in the menue for MySQL connection for
Orion. It's somewhere near the Tomcat tutorial.
Kees Jan
=
You can't have everything. Where would you put it?
I will be out of the office from the afternoon of Wednesday April 24th through the
afternoon of Friday April 26th.
If you have an emergency problem with the website, please contact Russell Dodds.
thanks,
Jen
what about the database schema?
On Mon, 4 Mar 2002, Joacim J?keborn wrote:
Can anybody tell me how to set up a connection pool with
a mysql
database? Anybody have a guide on how to do this? Is it
even possible?
Checkout
orggjtmmmysqljdbc2optionalMysqlConnectionPoolDataSour
ce
This guide is a good start, although someone else may have a mysql
specific setup that they would like to share.
http://kb.atlassian.com/content/orion/docs/datasource-configuration/datasource-configuration.html
Cheers,
Scott
Clay Mitchell wrote:
Can anybody tell me how to set up a
Can anybody tell me how to set up a connection pool with
a mysql
database? Anybody have a guide on how to do this? Is it
even possible?
Checkout
org.gjt.mm.mysql.jdbc2.optional.MysqlConnectionPoolDataSour
ce
Download the lastest driver from:
http://sourceforge.net/projects/mmmysql/
//
you need to use another schema definition: this example is for sqlserver
data-source
class=com.evermind.sql.DriverManagerDataSource
name=SQLServer
schema=database-schemas/ms-sql.xml
location=jdbc/SQLServerCoreDS
xa-location=jdbc/xa/SQLServerXADS
ejb-location=jdbc/SQLServerDS
You're missing a line in your date sources file:
Quoting John Hogan [EMAIL PROTECTED]:
data-sources.xml
=
?xml version=1.0?
!DOCTYPE data-sources PUBLIC Orion data-sources
http://www.orionserver.com/dtds/data-sources.dtd;
data-sources
!--
An
Harald,
This link has many examples that you can install on Orion:
http://kb.atlassian.com/directory/examples
Can I suggest the Orion CMP Primer?
Cheers,
Scott
--
Scott Farquhar :: [EMAIL PROTECTED]
Atlassian :: http://www.atlassian.com
Supporting YOUR J2EE World
Harald Kirschner
recall having used that method on mySQL JDBC with success in the past.
Justin
-Original Message-
From: Emeline Barns [mailto:[EMAIL PROTECTED]]
Sent: 22 September 2001 08:10
To: Orion-Interest
Subject: Re: mySQL
Hi Ray,
Thank you very much for your help. Yes, I amusing jdbc-odbc bridge
[EMAIL PROTECTED]
Reply-To: Orion-Interest [EMAIL PROTECTED]
To: Orion-Interest [EMAIL PROTECTED]
Subject: RE: mySQL
Date: Wed, 26 Sep 2001 12:15:06 +0200
If you have to rely on how many columns a query returns it is very likely
that your database is not properly normalised so look there first
Emeline -
Go to http://mmmysql.sourceforge.net/ and you can pick up the latest jdbc driver jar
file (works
anywhere). You should be able to export your access tables to delimited files and then
load them
into mysql. With Access, you can use the JDBC-ODBC bridge to get at the data if you
are
still do not know how to find the real number of columns selected.
Elena
From: Ray Harrison [EMAIL PROTECTED]
Reply-To: Orion-Interest [EMAIL PROTECTED]
To: Orion-Interest [EMAIL PROTECTED]
Subject: Re: mySQL
Date: Sat, 22 Sep 2001 02:57:41 -0700 (PDT)
Emeline -
Go to http://mmmysql.sourceforge.net
Hi gurus,
I have databases created in MS Access and using JDBC-ODBC for connection
which is not great.
My application have to hold under 30 connections. I tested my PC to run 20
instances of the program, and it worked. Does this mean that it will be
working when installed on shared drive?
I
Title: MYSQL, Orion, EJB and transactions ??
You could always use Interbase which now is
opensource..
http://www.interbase.com
- Original Message -
From:
Laufer, Michael
To: Orion-Interest
Sent: Friday, October 27, 2000 10:41
AM
Subject: MYSQL, Orion, EJB and
"Laufer, Michael" wrote:
Hi there,
If I understood it correctly, that would mean, that it should be
possible to use mysql with entity beans. Am I right ??
What's confusing to me is the fact, that I only find news in
mailing-list, that mysql is not supporting transactions.
Havent been
Title: MYSQL, Orion, EJB and transactions ??
I
would use the Hypersonic db that ships with Orion as you have to do nothing to
set it up, and it works great.
Don't
bother with MySQL.
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Laufer,
I have used it in the past, it works fine for me but you have to be aware
that it is per Db session and if you are using connection pooling you may
get the wrong last statement. I solved the problem by putting my id into a
bean, and then using that as for the where for my updates.
Statement
Interest
Cc: Orion-Interest
Betreff: RE: MySql?
MySQL can be used with EJB's, but entities will have to be
written in such
a way as to get around the lack of transaction support, ie.
using table
locks (Yuck!). THis however alone does not guarantee data
integrity, as a
connec
From what point of view? As a datasource? No. Just through a JDBC
driver as part of an application, yes.
Brian
--
Capital Internet
http://www.capital-internet.net
Voice: (414) 291-3500 x1004
On Wed, 16 Aug 2000, Steven Punte wrote:
Has anyone ever use the database "mysql" successfully with
From what point of view? As a datasource? No. Just through a JDBC
driver as part of an application, yes.
Has it been demonstrated in a production worthy manner that
the facilities of this server, (i.e. db pooling, EJB-CMP) operate
with mysql?
Steve
Brian
--
Capital
MySQL can be used with EJB's, but entities will have to be written in such
a way as to get around the lack of transaction support, ie. using table
locks (Yuck!). THis however alone does not guarantee data integrity, as a
connection that is dropped in the middle of a set of queries, will result
in
21 matches
Mail list logo