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
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
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?
Thanks
-Clay
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
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
connection-driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
username=
password=
url=jdbc:microsoft:sqlserver://x:1433
inactivity-timeout=30
/
i saw that there is no predefined schema for mysql so you need to make one
yourself... should be easy if you look at the other
All,
I've gone through the process of configuring Orion and the ejbsamples to run with a
mysql database. Things seem to be nearly correct. Orion connects to the database ok,
but dies trying to create tables. The problem seems to be related to syntax or type
mismatches between hypersonic db
All,
I've gone through the process of configuring Orion and the ejbsamples to run with a
mysql database. Things seem to be nearly correct. Orion connects to the database ok,
but dies trying to create tables. The problem seems to be related to syntax or type
mismatches between hypersonic db
transactional safety and connection pooling.
--
data-source
name=mysql
class=com.evermind.sql.DriverManagerDataSource
location=jdbc/mysql
pooled-location =jdbc/mysqlPooled
xa-location=jdbc/xa/mysql
ejb-location=jdbc/mysql
url=jdbc:mysql:/opt/mysql/mysql/data/menagerie
connection-driver
Folks,
I am new to Orion and look for a brief example of an EJB that accesses a
database table. Who can send me and example like this?
Thanks,
Harald
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
Dear
All,
Any document can help me to
understand how to config the Orion connect to MySQL and create the connection
Pool? Or any expert can teach me how to config it?
Thanks
in advance
Derek
__This transmission
I've just (10 minutes ago) been through this. You need to set
type-mapping type=boolean name=char(1)/.
The MySQL online documentation says that bit and bool gets converted
to char(1), but in reality they where set to tinyint(1), which Orion for
some reason could not use. The above solution
PROTECTED]] On Behalf Of Michael
Simons
Sent: Monday, October 01, 2001 11:14 AM
To: Orion-Interest
Subject: Re: Problems with CMP/MySQL
Roozbeh Ghaffari wrote:
Hi All,
We use Orion CMP features with MySQL. We had problems with boolean and
char fields.
I used P6Spy (www.provision6
Roozbeh Ghaffari wrote:
Hi All,
We use Orion CMP features with MySQL. We had problems with boolean and
char fields.
I used P6Spy (www.provision6.com http://www.provision6.com) to see
SQL commands generated by Orion.
Orion says:
update table_name set boolean_field = 'true
Title: Message
Hi
All,
We use Orion CMP
features with MySQL. We had problems with boolean and char
fields.
I used P6Spy (www.provision6.com) to see SQL
commands generated by Orion.
Orion
says:
update table_name
set boolean_field = 'true'
but MySQL
expects
update table_name
set
-Interest [EMAIL PROTECTED]
Subject: Problems with CMP/MySQL
Date: Sun Sep 30 08:38:18 GMT 2001
Hi All,
We use Orion CMP features with MySQL. We had problems with boolean and
char fields.
I used P6Spy (www.provision6.com) to see SQL commands generated by
Orion.
Orion says:
update table_name set
I'm aware that's a really newbie question but that's what I am ...
Any docs or anything else on this?
thanks in advance, michael
--
Dipl.-Math. (fh) Michael Simons
UNIOPT AG // unique logistic optimization
Maximilianstr. 29; D-93047 Regensburg
phone: ++49(0)941/59578-0
http://www.uniopt.net/
Download the JDBC driver from http://mmmysql.sourceforge.net/ and put
that into your orion/lib directory, then edit
orion/config/data-sources.xml to add in the data-source.
Docs on the data-sources.xml can be found here:
http://www.orionserver.com/docs/data-sources.xml.html
You will need to
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.
It could be that ODBC does not support the number of columns metadata but I
am not sure. Your problems should be solved with your move to mySQL; I
Thank you,Justin. If you tried to run MySQL on Windows NT?
The problem with the JDBC_ODBC bridge than when you select from 2 tables
(like join) then getTableName gives you empty string. So you have to select
at first from first table and then from the second one.
Elena
From: Justin Wood
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
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
tried to switch to mySQL, butcannot yet find the JDBC driver for
WindowsNT(only Linux). Also I need to export my databases from Access to
MySQL which I have not found as well.
May be there are some free JDBC drivers for Access which I am not aware. I
make this program for non=profitable
Hi,
Could anyone tell me how to configure the
orion server to support acccess to mysql DBMS
Thanks in advance,
Krishna
__
Do You Yahoo!?
Get email alerts NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
I use it with FreeBSD and PostgreSQL, but I know that it also works
with MySQL if you configure it for the proper data-source.
Steven
-Original Message-
From: hkhwang [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 12, 2001 9:05 PM
To: orion-interest
Cc: hkhwang
Subject: Does Orion
Hello
Can Orion work with MySQL and FreeBSD?
Any comment would be appreciated.
Regards,
-HK
Hi Nicolai,
: Thank you for your suggestions everybody :) MySQL has always been very
: limited (no subselect, foreign keys, transaction etc) but I had
: positive experiences with it because of it's simplicity.
:
: Does PostgreSQL support transactions? Last time I used it was back in
: 1996
BM == Brendan McKenna [EMAIL PROTECTED] writes:
BM Hi Nicolai, : Thank you for your suggestions everybody :) MySQL
BM has always been very : limited (no subselect, foreign keys,
BM transaction etc) but I had : positive experiences with it
BM because of it's simplicity.
BM :
BM : Does
anybody got any
success stories with mySQL? (still evaluating).
--
Nicolai P Gubahttp://www.gnu.org http://www.frontwire.com
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
GSM: +44 (0)7909 960 751 DDI: +44 (0)20 7368 9708
The latest releases (as of 3.23.34a) of MySQL support transactions by
using Berkley DB.
I'm using MySQL at the moment. The main anoyance I've got is that it
doesn't have sub-selects, apart from that, works great.
I haven't tried using transactions though as my data is read only.
Ray Harrison
Dear All,
I have a boolean property on an CMP entity bean. In the MySQL database I see
this type mapped to TINYINT(1), which is fine I guess.
Question one: I vaguely remember that the JavaBeans spec says that boolean
properties should have setFoo()/isFoo() instead of the setFOo()/getFoo()
combo
Dear All,
I've written a short howto on setting up Orion with MySQL on FreeBSD,
including some info on how set up privileges to connect to a remote MySQL
database.
http://kjkoster.org/java/index.jsp?page=content/packages.jspid=hd07
Kees Jan
[...] We also tried Hypersonic,
but it seems that when both Orion and JBuilder communicate with the db the
db gets confused. At least the changes we make in JBuilder don't get
updated.
That's propably because Orion caches data of the DB. If you stop Orion, then
update the DB and then
The cause for that could be that MySQL does not support transactions...
-Original Message-
From: Aaron Tavistock [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 3:28 AM
To: Orion-Interest
Subject: RE: orion with mysql?
You only need a schema if you intend to do CMP
I believe the latest release of Mysql supports transactions, but I am not sure the
binaries are set with the Berkeley transaction engine. You may have to compile both,
and this is a question for Mysql.
-Original Message-
From: Kiss Tibor [mailto:[EMAIL PROTECTED]]
Sent: Thursday
Actually MySQL does support transactions. You just need to use a database
file format that supports transactions (e.g. Berkeley DB, et al). The
mm.mysql driver also supports transactions, and its easy to setup to work
with transactions. The real problem is that the driver doesn't handle
est.
Rian
- Original Message -
From: Armin Michel [EMAIL PROTECTED]
To: Orion-Interest [EMAIL PROTECTED]
Sent: Thursday, April 05, 2001 12:25 AM
Subject: Re: orion with mysql?
[...] We also tried Hypersonic,
but it seems that when both Orion and JBuilder communicate with the db
the
db get
assuming you are setting up mysql version 3.23.33 in a linux box. need to
download both mysql and the berkeley engine.can be found in www.mysql.com
---
first time installing mysql. log in as root
assume mysql install dir = /mysql and berkeley
Is it possible to use MySQL with Orion? Does it need a db-schema of it's own?
We tried to use PostgreSQL but JBuilder4 didn't cope with it very well
(JBuilder isn't able to show Postgre's tables). We also tried Hypersonic, but
it seems that when both Orion and JBuilder communicate with the db
] wrote:
Is it possible to use MySQL with Orion? Does it need a db-schema of it's own?
We tried to use PostgreSQL but JBuilder4 didn't cope with it very well
(JBuilder isn't able to show Postgre's tables). We also tried Hypersonic, but
it seems that when both Orion and JBuilder communicate
Am using MySQL with Orion without it's own db-schema. No problems, yet.
Be sure to get the MM.MySQL driver...
--
-Geoff Marshall, Director of Development
...
t e r r a s c o p e (415) 951-4944
54 Mint Street, Suite 110
I am also using Orion with mySql without the Schema no problems here :D
jsut have the jar driver in the lib directory
-Original Message-
From: Geoff Marshall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 8:52 AM
To: Orion-Interest
Subject: Re: orion with mysql?
Am using
You only need a schema if you intend to do CMP EJBs. If you're not using
EJB at all then theres no reason you couldn't use MySQL.
But, while its not to hard to make a schema that complies with MySQL
somewhere in between MySQL and the mm.mysql driver the EJB transaction
support falls apart. My
Hi all
In the archive there are several mails describing problems with autocommit when using
MySQL (3.23.32) and the org.gjt.mm.mysql.Driver (2.0.4)
The Cabin example from Monson-Haefel's book, which uses CMP, fails as autocommit is
not turned off:
[snip from application.log]
19-03-01 15:56
I have been playing with Orion at home using mySql and have found the same
problem, and I looked into it a bunch.
While mySql has support for transactions, its still a little immature.
Typically the DBD or Gemini libraries need to be obtained and for mySql to
compile against so that the tables
Check log files of orion and your database
-Original Message-
From: Andres Garcia Hourcade [SMTP:[EMAIL PROTECTED]]
Sent: 20 2001 16:22
To: Orion-Interest
Subject: RE: NOVICE Question about orion and mysql
Thanks a lot, i did what you tell me,but i am still getting
It appears from the error message that you are pointing to the wrong mysql database:
The data-sour
xml file snippet you give below refers (in you URL) to defaultdb and your message
refers to
addressbookdb. In mysql, create a database called addressbookdb (or just change your
references
server that it must create de
addresbookdb, not search it
any ideas ?
-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]En nombre de
[EMAIL PROTECTED]
Enviado el: lunes, 19 de febrero de 2001 13:48
Para: Orion-Interest
Asunto: Re: NOVICE Question about orion and mysql
TECTED]]En nombre de
[EMAIL PROTECTED]
Enviado el: lunes, 19 de febrero de 2001 13:48
Para: Orion-Interest
Asunto: Re: NOVICE Question about orion and mysql
Hi Andres,
I have some custom CMP EJBs working with MySQL 3.23.
My datasource.xml entry is similar to yours. A couple thoughts:
1
Hi Andres,
I'm sorry, I didn't get that error. Orion automatically creates tables
in MySQL for CMP entity beans on my system, after just doing what
I suggested earlier. Your error sounds like the "database" is invalid,
like the URL you're using is pointing to the wrong MySQL data
Hi Andres,
I have some custom CMP EJBs working with MySQL 3.23.
My datasource.xml entry is similar to yours. A couple thoughts:
1. Make sure you have removed the attribute "ejb-location"
from the hsql datasource.
2. Make sure you have a schema for mysql in the
orion/confi
i changed orion-primer-cmp to use mysql 3.22
the mysql server is up and running, the app. works fine with hsql, but in
mysql i have to create database and tables manually, because it cannot
auto-create them
what else may i config, or where i could find any tips ?
thanks in advanced
attached
orton" [EMAIL PROTECTED]
To: "Orion-Interest" [EMAIL PROTECTED]
Sent: Tuesday, January 30, 2001 6:24 PM
Subject: Re: orion and mysql?
I found it very easy...I use:
http://mmmysql.sourceforge.net/ - jdbc driver
http://javaexchange.com/ - connection pooling
One
-Interest
Subject: RE: orion and mysql?
Well then, is there a simple how-to for setting up Interbase with Orion? -
Have you got a database schema which works?
R.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Arno Grbac
Sent: 30. januar 2001 19:08
the
standard classpath detailed in the Java Servlet specification.
dan
- Original Message -
From: "Marc Linke" [EMAIL PROTECTED]
To: "Orion-Interest" [EMAIL PROTECTED]
Sent: Wednesday, January 31, 2001 10:06 AM
Subject: Re: orion and mysql?
Hi,
well, i'm more in need
:
Hi,
is there any simple how-to for setting up mysql with
orion available? Or can someone explain me how to do it?
thanks
not to mention the total lack of transaction support which makes it
impossible to be used with CMP AFAIK
JP
-Original Message-
From: Arno Grbac [mailto:[EMAIL PROTECTED]]
Sent: Martes, 30 de Enero de 2001 15:08
To: Orion-Interest
Subject: RE: orion and mysql?
This doesn't answer your
I found it very easy...I use:
http://mmmysql.sourceforge.net/ - jdbc driver
http://javaexchange.com/ - connection pooling
One variable i had was w/javaexchange's DBBroker, set AutoReconnect=true...
so far so good...been using awhile
Which mysql are you using? Not all
/BDB.html
here are some excerpts:
'Berkeley DB (http://www.sleepycat.com) has provided MySQL with a
transaction-safe table handler. This will survive crashes and also provides
COMMIT and ROLLBACK on transactions. In order to build MySQL Version 3.23.x
(BDB support first appeared in Version 3.23.15
and mysql?
This doesn't answer your question, but take a serious look at InterBase 6
(IT IS FREE AND OPEN SOURCE!!!).
mySQL doesn't have a good locking mechanism yet, ..as well as some missing
data types (last time I checked).
Good luck,
-arno
-Original Message-
From: [EMAIL PROTECTED
;Orion-Interest" [EMAIL PROTECTED]
Sent: Wednesday, November 15, 2000 8:37 AM
Subject: Re: Problems with MySQL and DataSourceUserManager
hi!
i had the same problem with the WebLogic Server.
the problem is that MySQL does not support transactions
as of version 2.22.x.
there is beta
Hi
Is anyone using DataSourceUserManager with MySQL database?
We have been using it with PostgreSQL without any problems,
but when we switched to MySQL, DataSourceUserManager throws
an exception
DataSourceUserManager.getUser
8.11.2000 14:29 ANALYYTIKKO-web: Error in UserManager
hi!
i had the same problem with the WebLogic Server.
the problem is that MySQL does not support transactions
as of version 2.22.x.
there is beta quality transaction support in the
current development branch (2.23.x) but
i had very serious problems with the latest version (lost data).
personally
Hi,
If I use EJB, can I use postgresql? I know that postgresql jdbc driver
is still not jdbc2 complaint.
Louis
- Original Message -
From: "Lars Hoss" [EMAIL PROTECTED]
To: "Orion-Interest" [EMAIL PROTECTED]
Sent: Wednesday, November 15, 2000 8:37 AM
Subject: Re:
I had the same problem. I could not resolve it. I ended up switching to a
new database. I'd love to here if you were able to get it to work.
Dave Ford
Smart Soft - The Java Training Company
http://www.SmartSoftTraining.com
Title: MYSQL, Orion, EJB and transactions ??
Hi there,
I know that the question has been discussed here before, but I'm still a little confused about using
MYSQL together with Orion.
I've just downloaded mysql (version 3.23.22 beta) and the manual announces that mysql is now supporting
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
Title: MYSQL, Orion, EJB and transactions ??
You
can use the database that comes with Orion Hypersonic SQL. Its a java database
and works great for things like that. If you want to use an object database
download forte 2 internat edition (beta), it has the Pointbase database
enclosed
"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.
H
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
Hi,
up to now i always connected to the Hypersonic database. Since i have a mysql database
running on another box, i tried to connect to it, using Shailesh Joshi's
data-sources.xml and database-schemas/mysql.xml (cf. msg# 05137 Re: Orion and MySQL).
This is the errormessage i get when orion
At 17:13 14.10.00 , you wrote:
Hi,
up to now i always connected to the Hypersonic database. Since i have a
mysql database running on another box, i tried to connect to it, using
Shailesh Joshi's data-sources.xml and database-schemas/mysql.xml (cf. msg#
05137 Re: Orion and MySQL).
This is the erro
Title: Orion and MySQL
Hi Dube , Craig .
I have deployedan entity
bean[CMP] inthe MySQL database.
I am
specifyingdatabase-schemas\mysql.xml modifications in
data-sources.xml as it is.
1]database-schemas\mysql.xml
?xml version="1.0"?!DOCTYPE
database-schema PUBLIC &q
Title: Orion and MySQL
I am trying to set up orion to use MySQL instead of HypersonicSQL. I'm looking for some advice on how to properly setup Orion to use the MySQL database that I have installed.
So far I have used the MySQL admin tool to creat a database called oriondb. I have also
Hi,
Does anyone have any code fragments for retrieving a MySQL identity value
using getLastInsertID() [ org.gjt.mm.mysql drivers ] under Orion? The
documentation says that you have to cast the bespoke
statement/preparedstatement to a java.sql statement/preparedstatement?
Every time I get
To: Orion-Interest
Subject: MySQL Identity Columns
Hi,
Does anyone have any code fragments for retrieving a MySQL identity value
using getLastInsertID() [ org.gjt.mm.mysql drivers ] under Orion? The
documentation says that you have to cast the bespoke
statement/preparedstatement to a java.sql
We have Orion 1.1.37 with MySQL (mm.mysql driver). MySQL is used as a non-pooled
data-source. Everything works fine, but when server is left running for the night, at
the morning the DB connection has "crashed":
java.sql.SQLException: Lost connection to server du
Just to drop in a line: We successfully use Interbase 6 as database server
for our entity beans (BMP, so do not ask for a database scheme ;-). It
should fit all the needs the people have that want to use MySQL - first of
all, it's now free... (and, astonishingly, it seems even faster, although i
that can't go wrong will anyway
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jens Stutte
Sent: Thursday, August 17, 2000 09:32
To: Orion-Interest
Subject: AW: MySql?
Just to drop in a line: We successfully use Interbase 6 as database server
for o
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" su
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
I hava been getting the following warning when using Mysql, OrionServer
and Entity beans. Can I get rid of it?
*** WARNING: DATABASE SET AUTO-COMMIT CALL FAILED, THIS DATABASE IS NOT
TRANSACT
IONAL (AND HENCE UNSECURE): Cannot disable AUTO_COMMIT ***
Juha Lehtonen
ry JDBC 2.0
drivers.
/description
urljdbc:mysql://localhost/creative/url
connection-driverorg.gjt.mm.mysql.Driver/connection-driver
usernameweb/username
passwordweb/password
/data-source
I have the mySQL drivers in my classpath in web-application.xml
classpath/usr/local/jdk/ex/mm.mysql.jdbc-2.0pre
86 matches
Mail list logo