Orion and MySQL config
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 and the information it contains including any attachment, is confidential and may be subject to legal privilege. If you are not the intended recipient, you must not peruse, use, disseminate, disclose or copy this transmission. If you have received this transmission (or any copy) in error, please notify us immediately by reply e-mail to [EMAIL PROTECTED] Please delete the original transmission(including any attachment) and its contents and destroy or return to us any hard copy. Please note that any electronically transmitted material that purports to commit Sun Hung Kai & Co. Ltd., or any of its subsidiaries or associates, to any obligation or in any other way whatsoever, unless subsequently confirmed by fax or letter signed (in either case) by our duly authorized officer(s) may not be relied on. Material transmitted to you should also be checked by reference to the hard copy of the material printed directly by us.
Short Orion/remote MySQL howto
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 You are only young once, but you can stay immature all your life.
Re: orion with mysql?
[...] 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 restart Orion, you shouldn't perceive any update problems. Greetings Armin
RE: orion with mysql?
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 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 inclination is that its the mm.mysql driver itself, and the real problem is just that transaction support is not implimented in a way that complies with the EJB spec (e.g. javax.transaction doesn't occur anywhere in the source). So, while you can use MySQL with Orion you can't do EJB unless you switch over to SAPdb, PostgresSQL, or db. -Original Message- From: Geoff Marshall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 3:52 PM To: Orion-Interest Subject: Re: orion with mysql? 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 direct (415) 625-0349 San Francisco, CA 94103 fax (415) 625-0306 ... From: Peter Peltonen [EMAIL PROTECTED] Organization: Fivetec Solutions Oy Reply-To: Orion-Interest [EMAIL PROTECTED] Date: Wed, 04 Apr 2001 19:42:44 +0300 To: Orion-Interest [EMAIL PROTECTED] Subject: orion with mysql? 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 the db gets confused. At least the changes we make in JBuilder don't get updated. Any ideas about a good open-source db that would work with both Orion and JBuilder would be appreciated! Regards, Peter
RE: orion with mysql?
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, April 05, 2001 3:31 AM To: Orion-Interest Subject: RE: orion with mysql? 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 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 inclination is that its the mm.mysql driver itself, and the real problem is just that transaction support is not implimented in a way that complies with the EJB spec (e.g. javax.transaction doesn't occur anywhere in the source). So, while you can use MySQL with Orion you can't do EJB unless you switch over to SAPdb, PostgresSQL, or db. -Original Message- From: Geoff Marshall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 3:52 PM To: Orion-Interest Subject: Re: orion with mysql? 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 direct (415) 625-0349 San Francisco, CA 94103 fax (415) 625-0306 ... From: Peter Peltonen [EMAIL PROTECTED] Organization: Fivetec Solutions Oy Reply-To: Orion-Interest [EMAIL PROTECTED] Date: Wed, 04 Apr 2001 19:42:44 +0300 To: Orion-Interest [EMAIL PROTECTED] Subject: orion with mysql? 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 the db gets confused. At least the changes we make in JBuilder don't get updated. Any ideas about a good open-source db that would work with both Orion and JBuilder would be appreciated! Regards, Peter
RE: orion with mysql?
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 transactions the way the specification wants them to. -Original Message- From: Kiss Tibor [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 1:31 AM To: Orion-Interest Subject: RE: orion with mysql? 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 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 inclination is that its the mm.mysql driver itself, and the real problem is just that transaction support is not implimented in a way that complies with the EJB spec (e.g. javax.transaction doesn't occur anywhere in the source). So, while you can use MySQL with Orion you can't do EJB unless you switch over to SAPdb, PostgresSQL, or db. -Original Message- From: Geoff Marshall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 3:52 PM To: Orion-Interest Subject: Re: orion with mysql? 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 direct (415) 625-0349 San Francisco, CA 94103 fax (415) 625-0306 ... From: Peter Peltonen [EMAIL PROTECTED] Organization: Fivetec Solutions Oy Reply-To: Orion-Interest [EMAIL PROTECTED] Date: Wed, 04 Apr 2001 19:42:44 +0300 To: Orion-Interest [EMAIL PROTECTED] Subject: orion with mysql? 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 the db gets confused. At least the changes we make in JBuilder don't get updated. Any ideas about a good open-source db that would work with both Orion and JBuilder would be appreciated! Regards, Peter
Re: orion with mysql?
Sounds like you need to turn off exclusive-write-access in orion-ejb-jar.xml while you're putzing with the database outside of the application. We're running with SQL Server 7 (*gasp*) and Orion will try to "fix" any manual changes we make to the database through the admin console. Otherwise, we have to shutdown Orion, make the changes, and restart. The performance hit is huge, so you wouldn't want to leave it turned off, but Orion will basically go talk to the database at every accessor to make sure that it's got the latest data and not assume that Orion knows best. 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 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 restart Orion, you shouldn't perceive any update problems. Greetings Armin
Re: orion with mysql?
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 install dir = /db-3.2.9a cd /mysql ./configure --with-berkeley-db=/db-3.2.9a (to enable transaction tables. 3.2.9a is the patch version for mysql 3.23.xx versions) this will then start the server for the first time. must set pwd for root bin/mysqladmin -u root password 'xx' after that you'll have to option to create transactional tables which can be used with EJBs - Original Message - From: "Kemp Randy-W18971" [EMAIL PROTECTED] To: "Orion-Interest" [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 9:09 PM Subject: RE: orion with mysql? 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, April 05, 2001 3:31 AM To: Orion-Interest Subject: RE: orion with mysql? 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 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 inclination is that its the mm.mysql driver itself, and the real problem is just that transaction support is not implimented in a way that complies with the EJB spec (e.g. javax.transaction doesn't occur anywhere in the source). So, while you can use MySQL with Orion you can't do EJB unless you switch over to SAPdb, PostgresSQL, or db. -Original Message- From: Geoff Marshall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 3:52 PM To: Orion-Interest Subject: Re: orion with mysql? 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 direct (415) 625-0349 San Francisco, CA 94103 fax (415) 625-0306 ... From: Peter Peltonen [EMAIL PROTECTED] Organization: Fivetec Solutions Oy Reply-To: Orion-Interest [EMAIL PROTECTED] Date: Wed, 04 Apr 2001 19:42:44 +0300 To: Orion-Interest [EMAIL PROTECTED] Subject: orion with mysql? 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 the db gets confused. At least the changes we make in JBuilder don't get updated. Any ideas about a good open-source db that would work with both Orion and JBuilder would be appreciated! Regards, Peter
orion with mysql?
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 the db gets confused. At least the changes we make in JBuilder don't get updated. Any ideas about a good open-source db that would work with both Orion and JBuilder would be appreciated! Regards, Peter
Re: orion with mysql?
Try SapDB (www.sapdb.org)as one of your evaluations. I don't use JBuilder, but other tools I have used have been able to see SapDB tables no problem. Although it doesn't really make sense that JBuilder can't see PostgreSQL tables using the jdbc driver. --- Peter Peltonen [EMAIL PROTECTED] 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 with the db the db gets confused. At least the changes we make in JBuilder don't get updated. Any ideas about a good open-source db that would work with both Orion and JBuilder would be appreciated! Regards, Peter __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text
Re: orion with mysql?
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 direct (415) 625-0349 San Francisco, CA 94103 fax (415) 625-0306 ... From: Peter Peltonen [EMAIL PROTECTED] Organization: Fivetec Solutions Oy Reply-To: Orion-Interest [EMAIL PROTECTED] Date: Wed, 04 Apr 2001 19:42:44 +0300 To: Orion-Interest [EMAIL PROTECTED] Subject: orion with mysql? 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 the db gets confused. At least the changes we make in JBuilder don't get updated. Any ideas about a good open-source db that would work with both Orion and JBuilder would be appreciated! Regards, Peter
RE: orion with mysql?
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 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 direct (415) 625-0349 San Francisco, CA 94103 fax (415) 625-0306 ... From: Peter Peltonen [EMAIL PROTECTED] Organization: Fivetec Solutions Oy Reply-To: Orion-Interest [EMAIL PROTECTED] Date: Wed, 04 Apr 2001 19:42:44 +0300 To: Orion-Interest [EMAIL PROTECTED] Subject: orion with mysql? 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 the db gets confused. At least the changes we make in JBuilder don't get updated. Any ideas about a good open-source db that would work with both Orion and JBuilder would be appreciated! Regards, Peter The contents of this email are confidential. If you are not the intended recipient, you must not disclose, copy or use the contents in any way. If you have received this email in error, please delete it and notify us immediately by return email. It is the recipient's responsibility to screen this message and any attachments for computer viruses. Any views expressed in this email are not to be taken as the views of the company or any related business entity unless expressly stated to the contrary.
RE: orion with mysql?
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 inclination is that its the mm.mysql driver itself, and the real problem is just that transaction support is not implimented in a way that complies with the EJB spec (e.g. javax.transaction doesn't occur anywhere in the source). So, while you can use MySQL with Orion you can't do EJB unless you switch over to SAPdb, PostgresSQL, or db. -Original Message- From: Geoff Marshall [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 3:52 PM To: Orion-Interest Subject: Re: orion with mysql? 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 direct (415) 625-0349 San Francisco, CA 94103 fax (415) 625-0306 ... From: Peter Peltonen [EMAIL PROTECTED] Organization: Fivetec Solutions Oy Reply-To: Orion-Interest [EMAIL PROTECTED] Date: Wed, 04 Apr 2001 19:42:44 +0300 To: Orion-Interest [EMAIL PROTECTED] Subject: orion with mysql? 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 the db gets confused. At least the changes we make in JBuilder don't get updated. Any ideas about a good open-source db that would work with both Orion and JBuilder would be appreciated! Regards, Peter
Orion and mysql: turning autocommit off?
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 Error in bean Cabin java.sql.SQLException: Can't call commit when autocommit=true at org.gjt.mm.mysql.Connection.commit(Connection.java:520) at com.evermind.sql.an.commit(JAX) at com.evermind.sql.aj.commit(JAX) at com.evermind.server.ejb.DataSourceConnection.commit(JAX) at CabinHome_EntityHomeWrapper2.create(CabinHome_EntityHomeWrapper2.java:429) at java.lang.reflect.Method.invoke(Native Method) at com.evermind.server.rmi.bd.run(JAX) at com.evermind.server.rmi.bb.hy(JAX) at com.evermind.server.rmi.bb.run(JAX) at com.evermind.util.f.run(JAX) [end snip] I've tried to use the property: jdbc.nontx.autocommit=false in the orion.properties file, but this does not turn off autocommit. I've also tried turning autocommit off in the MySQL DB (SET AUTOCOMMIT=0) itself, but with no effect. Has any one found out how to turn off autocommit? Regards Henrik -Original Message- From: Tim Endres [mailto:[EMAIL PROTECTED]] Sent: 30. januar 2001 22:16 To: Orion-Interest Subject: Re: orion and mysql? 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 versions support transactions. tim.
RE: Orion and mysql: turning autocommit off?
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 can be managed with AUTOCOMMIT off. But this is more of an inconvenience than a real showstopper. But more importantly the JDBC driver itself seems to not quite be ready for handling CMP transactions. For example, the class org.gjt.mm.mysql.MysqlDataSource works if you instantiate it and set the properties yourself but it doesn't follow the spec so theres no way for Orion to properly configure it. Even more important greping through the source code for the driver reveals that there is nothing from javax.transaction package anywhere which is required by the EJB 1.1 spec. So the long and short of it is... I've tried using mySql, it won't work yet. So far as both PostgresSQL and Oracle work very well as alternatives. -Original Message- From: Henrik Rn (LMD) [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 7:58 AM To: Orion-Interest Subject: Orion and mysql: turning autocommit off? 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 Error in bean Cabin java.sql.SQLException: Can't call commit when autocommit=true at org.gjt.mm.mysql.Connection.commit(Connection.java:520) at com.evermind.sql.an.commit(JAX) at com.evermind.sql.aj.commit(JAX) at com.evermind.server.ejb.DataSourceConnection.commit(JAX) at CabinHome_EntityHomeWrapper2.create(CabinHome_EntityHomeWrapper2.java:429) at java.lang.reflect.Method.invoke(Native Method) at com.evermind.server.rmi.bd.run(JAX) at com.evermind.server.rmi.bb.hy(JAX) at com.evermind.server.rmi.bb.run(JAX) at com.evermind.util.f.run(JAX) [end snip] I've tried to use the property: jdbc.nontx.autocommit=false in the orion.properties file, but this does not turn off autocommit. I've also tried turning autocommit off in the MySQL DB (SET AUTOCOMMIT=0) itself, but with no effect. Has any one found out how to turn off autocommit? Regards Henrik -Original Message- From: Tim Endres [mailto:[EMAIL PROTECTED]] Sent: 30. januar 2001 22:16 To: Orion-Interest Subject: Re: orion and mysql? 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 versions support transactions. tim.
RE: NOVICE Question about orion and mysql
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 this msg. Warning: Unable to create new entry, caught: "javax.ejb.CreateException", message is: "Error creating EntityBean: General error: Unknown database 'addressbookdb'". obviusly i do not know how tell to orion 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 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/config/database-schemas directory. Here is the one I use (named mysql.xml): -- ?xml version="1.0"? !DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema" "http://www.orionserver.com/dtds/database-schemas.dtd" database-schema name="Mysql" not-null="not null" null="" primary-key ="primary key" type-mapping type="java.lang.String" name="varchar(255)" / type-mapping type="int" name="integer" / type-mapping type="float" name="float" / type-mapping type="double" name="double" / type-mapping type="byte" name="smallint" / type-mapping type="char" name="char(1)" / type-mapping type="short" name="integer" / type-mapping type="boolean" name="bit" / type-mapping type="java.util.Date" name="datetime" / disallowed-field name="password" / disallowed-field name="username" / disallowed-field name="date" / disallowed-field name="text" / /database-schema -- Good luck, Doug "Andres Garcia Hourcade" [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent by: cc: owner-orion-interest@orionSubject: NOVICE Question about orion and mysql server.com 02/16/2001 02:31 PM Please respond to Orion-Interest 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 config/datasource.xml data-source name="mysql" class ="com.evermind.sql.DriverManagerDataSource" location ="jdbc/mysqlCore" pooled-location ="jdbc/mysqlPooled" xa-location ="jdbc/xa/mysqlXA" ejb-location ="jdbc/mysql" username ="sist" password ="" url ="jdbc:mysql://10.1.1.107:3306/defaultdb" connection-driver="org.gjt.mm.mysql.Driver" /
RE: NOVICE Question about orion and mysql
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 to defaultdb). The tables will then be automatically created. --- [EMAIL PROTECTED] wrote: 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 database? Just a thought, but I'm not sure. Maybe someone else has more insight. Doug "Andres Garcia Hourcade" [EMAIL PROTECTED] To: Orion-Interest Sent by: [EMAIL PROTECTED] owner-orion-interest@orioncc: server.comSubject: RE: NOVICE Question about orion and mysql 02/20/2001 06:52 AM Please respond to Orion-Interest Thanks a lot, i did what you tell me,but i am still getting this msg. Warning: Unable to create new entry, caught: "javax.ejb.CreateException", message is: "Error creating EntityBean: General error: Unknown database 'addressbookdb'". obviusly i do not know how tell to orion 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 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/config/database-schemas directory. Here is the one I use (named mysql.xml): -- ?xml version="1.0"? !DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema" "http://www.orionserver.com/dtds/database-schemas.dtd" database-schema name="Mysql" not-null="not null" null="" primary-key ="primary key" type-mapping type="java.lang.String" name="varchar(255)" / type-mapping type="int" name="integer" / type-mapping type="float" name="float" / type-mapping type="double" name="double" / type-mapping type="byte" name="smallint" / type-mapping type="char" name="char(1)" / type-mapping type="short" name="integer" / type-mapping type="boolean" name="bit" / type-mapping type="java.util.Date" name="datetime" / disallowed-field name="password" / disallowed-field name="username" / disallowed-field name="date" / disallowed-field name="text" / /database-schema ------ Good luck, Doug "Andres Garcia Hourcade" [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent by: cc: owner-orion-interest@orionSubject: NOVICE Question about orion and mysql server.com 02/16/2001 02:31 PM Please respond to Orion-Interest
NOVICE Question about orion and mysql
Thanks a lot, i did what you tell me,but i am still getting this msg. Warning: Unable to create new entry, caught: "javax.ejb.CreateException", message is: "Error creating EntityBean: General error: Unknown database 'addressbookdb'". obviusly i do not know how tell orion 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 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/config/database-schemas directory. Here is the one I use (named mysql.xml): -- ?xml version="1.0"? !DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema" "http://www.orionserver.com/dtds/database-schemas.dtd" database-schema name="Mysql" not-null="not null" null="" primary-key ="primary key" type-mapping type="java.lang.String" name="varchar(255)" / type-mapping type="int" name="integer" / type-mapping type="float" name="float" / type-mapping type="double" name="double" / type-mapping type="byte" name="smallint" / type-mapping type="char" name="char(1)" / type-mapping type="short" name="integer" / type-mapping type="boolean" name="bit" / type-mapping type="java.util.Date" name="datetime" / disallowed-field name="password" / disallowed-field name="username" / disallowed-field name="date" / disallowed-field name="text" / /database-schema ------ Good luck, Doug "Andres Garcia Hourcade" [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent by: cc: owner-orion-interest@orionSubject: NOVICE Question about orion and mysql server.com 02/16/2001 02:31 PM Please respond to Orion-Interest 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 config/datasource.xml data-source name="mysql" class ="com.evermind.sql.DriverManagerDataSource" location ="jdbc/mysqlCore" pooled-location ="jdbc/mysqlPooled" xa-location ="jdbc/xa/mysqlXA" ejb-location ="jdbc/mysql" username ="sist" password ="" url ="jdbc:mysql://10.1.1.107:3306/defaultdb" connection-driver="org.gjt.mm.mysql.Driver" /
Re: NOVICE Question about orion and mysql
Orion doesn't create databases automatically. Orion does create tables automatically. - Brian On Tue, 20 Feb 2001, Andres Garcia Hourcade wrote: Thanks a lot, i did what you tell me,but i am still getting this msg. Warning: Unable to create new entry, caught: "javax.ejb.CreateException", message is: "Error creating EntityBean: General error: Unknown database 'addressbookdb'". obviusly i do not know how tell orion 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 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/config/database-schemas directory. Here is the one I use (named mysql.xml): -- ?xml version="1.0"? !DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema" "http://www.orionserver.com/dtds/database-schemas.dtd" database-schema name="Mysql" not-null="not null" null="" primary-key ="primary key" type-mapping type="java.lang.String" name="varchar(255)" / type-mapping type="int" name="integer" / type-mapping type="float" name="float" / type-mapping type="double" name="double" / type-mapping type="byte" name="smallint" / type-mapping type="char" name="char(1)" / type-mapping type="short" name="integer" / type-mapping type="boolean" name="bit" / type-mapping type="java.util.Date" name="datetime" / disallowed-field name="password" / disallowed-field name="username" / disallowed-field name="date" / disallowed-field name="text" / /database-schema ------ Good luck, Doug "Andres Garcia Hourcade" [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent by: cc: owner-orion-interest@orionSubject: NOVICE Question about orion and mysql server.com 02/16/2001 02:31 PM Please respond to Orion-Interest 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 config/datasource.xml data-source name="mysql" class ="com.evermind.sql.DriverManagerDataSource" location ="jdbc/mysqlCore" pooled-location ="jdbc/mysqlPooled" xa-location ="jdbc/xa/mysqlXA" ejb-location ="jdbc/mysql" username ="sist" password ="" url ="jdbc:mysql://10.1.1.107:3306/defaultdb" connection-driver="org.gjt.mm.mysql.Driver" /
RE: NOVICE Question about orion and mysql
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 database? Just a thought, but I'm not sure. Maybe someone else has more insight. Doug "Andres Garcia Hourcade" [EMAIL PROTECTED] To: Orion-Interest Sent by: [EMAIL PROTECTED] owner-orion-interest@orioncc: server.comSubject: RE: NOVICE Question about orion and mysql 02/20/2001 06:52 AM Please respond to Orion-Interest Thanks a lot, i did what you tell me,but i am still getting this msg. Warning: Unable to create new entry, caught: "javax.ejb.CreateException", message is: "Error creating EntityBean: General error: Unknown database 'addressbookdb'". obviusly i do not know how tell to orion 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 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/config/database-schemas directory. Here is the one I use (named mysql.xml): -- ?xml version="1.0"? !DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema" "http://www.orionserver.com/dtds/database-schemas.dtd" database-schema name="Mysql" not-null="not null" null="" primary-key ="primary key" type-mapping type="java.lang.String" name="varchar(255)" / type-mapping type="int" name="integer" / type-mapping type="float" name="float" / type-mapping type="double" name="double" / type-mapping type="byte" name="smallint" / type-mapping type="char" name="char(1)" / type-mapping type="short" name="integer" / type-mapping type="boolean" name="bit" / type-mapping type="java.util.Date" name="datetime" / disallowed-field name="password" / disallowed-field name="username" / disallowed-field name="date" / disallowed-field name="text" / /database-schema -- Good luck, Doug "Andres Garcia Hourcade" [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent by: cc: owner-orion-interest@orionSubject: NOVICE Question about orion and mysql server.com 02/16/2001 02:31 PM Please respond to Orion-Interest 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 config/datasource.xml data-source name="mysql" class ="com.evermind.sql.DriverManagerDataSource" location ="j
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. 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/config/database-schemas directory. Here is the one I use (named mysql.xml): -- ?xml version="1.0"? !DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema" "http://www.orionserver.com/dtds/database-schemas.dtd" database-schema name="Mysql" not-null="not null" null="" primary-key ="primary key" type-mapping type="java.lang.String" name="varchar(255)" / type-mapping type="int" name="integer" / type-mapping type="float" name="float" / type-mapping type="double" name="double" / type-mapping type="byte" name="smallint" / type-mapping type="char" name="char(1)" / type-mapping type="short" name="integer" / type-mapping type="boolean" name="bit" / type-mapping type="java.util.Date" name="datetime" / disallowed-field name="password" / disallowed-field name="username" / disallowed-field name="date" / disallowed-field name="text" / /database-schema -- Good luck, Doug "Andres Garcia Hourcade" [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent by: cc: owner-orion-interest@orionSubject: NOVICE Question about orion and mysql server.com 02/16/2001 02:31 PM Please respond to Orion-Interest 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 config/datasource.xml data-source name="mysql" class ="com.evermind.sql.DriverManagerDataSource" location ="jdbc/mysqlCore" pooled-location ="jdbc/mysqlPooled" xa-location ="jdbc/xa/mysqlXA" ejb-location ="jdbc/mysql" username ="sist" password ="" url ="jdbc:mysql://10.1.1.107:3306/defaultdb" connection-driver="org.gjt.mm.mysql.Driver" /
NOVICE Question about orion and mysql
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 config/datasource.xml data-source name="mysql" class="com.evermind.sql.DriverManagerDataSource" location ="jdbc/mysqlCore" pooled-location ="jdbc/mysqlPooled" xa-location ="jdbc/xa/mysqlXA" ejb-location ="jdbc/mysql" username ="sist" password ="" url ="jdbc:mysql://10.1.1.107:3306/defaultdb" connection-driver="org.gjt.mm.mysql.Driver" /
Re: orion and mysql?
Hi, well, i'm more in need of some kind of step-by-step info as i'm new to java, j2ee and orion. So far i couldnt even setup orion to run plain servlets with mm.mysql as orion seems to ignore my classpath setting (or even i guess so). thanks - Original Message - From: "David Morton" [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 variable i had was w/javaexchange's DBBroker, set AutoReconnect=true... so far so good...been using awhile David At 05:20 PM 1/30/01 +0100, you wrote: Hi, is there any simple how-to for setting up mysql with orion available? Or can someone explain me how to do it? thanks
RE: orion and mysql?
If somebody using Interbase successfully, please send your database schema and data-sources.xml part to this list. TIA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Randahl Fink Isaksen Sent: Wednesday, January 31, 2001 10:05 AM To: Orion-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 To: Orion-Interest Subject: RE: orion 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] [mailto:[EMAIL PROTECTED]]On Behalf Of Marc Linke Sent: Tuesday, January 30, 2001 11:21 AM To: Orion-Interest Subject: orion and mysql? Hi, is there any simple how-to for setting up mysql with orion available? Or can someone explain me how to do it? thanks
Re: orion and mysql?
Really you should check out the J2EE specification at java.sun.com and in also grab some further info on JSP and servlets while you are there. Orion is suprisingly compatible with the J2EE spec. For example you should be using WAR deployment of your servlets then you will be able to use 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 of some kind of step-by-step info as i'm new to java, j2ee and orion. So far i couldnt even setup orion to run plain servlets with mm.mysql as orion seems to ignore my classpath setting (or even i guess so). thanks - Original Message - From: "David Morton" [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 variable i had was w/javaexchange's DBBroker, set AutoReconnect=true... so far so good...been using awhile David At 05:20 PM 1/30/01 +0100, you wrote: Hi, is there any simple how-to for setting up mysql with orion available? Or can someone explain me how to do it? thanks
Re: orion and mysql?
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 David At 05:20 PM 1/30/01 +0100, you wrote: Hi, is there any simple how-to for setting up mysql with orion available? Or can someone explain me how to do it? thanks
RE: orion and mysql?
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 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] [mailto:[EMAIL PROTECTED]]On Behalf Of Marc Linke Sent: Tuesday, January 30, 2001 11:21 AM To: Orion-Interest Subject: orion and mysql? Hi, is there any simple how-to for setting up mysql with orion available? Or can someone explain me how to do it? thanks
Re: orion and mysql?
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 versions support transactions. tim.
Re: orion and mysql?
I just switched to latest and greatest of 3.23 tree from the greatest of the 3.22 tree...so far so goodeven updating the working server was easy. It's fantastic for medium size web sitesI haven't played with the Berkeley DB transactions yet. http://www.mysql.com/doc/B/D/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) with support for BDB tables, you will need Berkeley DB Version 3.2.3h or newer which can be downloaded from http://www.mysql.com/downloads/mysql-3.23.html. This is a patched version of Berkeley DB that is only available from MySQL; the standard Berkeley DB will not yet work with MySQL'. Source for DB stuff is at: http://www.mysql.com/downloads/mysql-3.23.html http://www.mysql.com/Downloads/db/db-3.2.3h.tar.gz David At 04:15 PM 1/30/01 -0500, you wrote: 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 versions support transactions. tim.
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 To: Orion-Interest Subject: RE: orion 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] [mailto:[EMAIL PROTECTED]]On Behalf Of Marc Linke Sent: Tuesday, January 30, 2001 11:21 AM To: Orion-Interest Subject: orion and mysql? Hi, is there any simple how-to for setting up mysql with orion available? Or can someone explain me how to do it? thanks
Re: Orion and MySQL
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 "-//Evermind//- Database schema" "http://www.orionserver.com/dtds/database-schemas.dtd"!-- Author : Shailesh Joshi --database-schema name="Mysql" not-null="not null" null="" primary-key="primary key"type-mapping type="java.lang.String" name="varchar(255)" /type-mapping type="int" name="integer" /type-mapping type="float" name="float" /type-mapping type="double" name="double" /type-mapping type="byte" name="smallint" /type-mapping type="char" name="char(1)" /type-mapping type="short" name="integer" /type-mapping type="boolean" name="bit" /type-mapping type="java.util.Date" name="datetime" /disallowed-field name="password" /disallowed-field name="username" /disallowed-field name="date" /disallowed-field name="text" //database-schema 2]Part added to data-sources.xml data-source name="MySQL" class="com.evermind.sql.ConnectionDataSource" location="jdbc/DefaultDS" pooled-location="jdbc/DefaultPooledDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:mysql://IPAddress/Test" [Test is my database] connection-driver="org.gjt.mm.mysql.Driver" username="x" password="x" inactivity-timeout="30" schema="database-schemas/mysql.xml" / Shailesh Joshi Java Programmer Versaware(India) Ltd. - Original Message - From: Dube, Craig To: Orion-Interest Sent: Tuesday, October 10, 2000 1:24 AM Subject: 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 edited the "data-sources.xml" and added a "mysql.xml" file under the database-schemas directory. Here is a piece of the "data-sources.xml" file and a piece of the "mysql.xml": data-sources.xml data-source class="com.evermind.sql.DriverManagerDataSource" name="MySQL" location="jdbc/DefaultCoreDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultDS" pooled-location="jdbc/DefaultPooledDS" connection-driver="org.gjt.mm.mysql.Driver" username="root" password="root" url="jdbc:mysql://localhost/mysql/data/oriondb" inactivity-timeout="30" schema="database-schemas/mysql.xml" / mysql.xml - database-schema name="MySQL" not-null="not null" null="" primary-key="primary key" type-mapping type="java.lang.String" name="char (255)" / type-mapping type="int" name="int" / type-mapping type="long" name="int" / type-mapping type="float" name="float" / type-mapping type="double" name="double" / type-mapping type="byte" name="smallint" / type-mapping type="char" name="char" / type-mapping type="short" name="short" / type-mapping type="java.util.Date" name="timestamp" / disallowed-field name="password" / disallowed-field name="username" / disallowed-field name="date" / disallowed-field name="order" / /database-schema I was very unsure as to what I should use for the "location" tags in the data-sources file. Also, with the "mysql.xml" file, I copied the Hypersonic schema file and removed the boolean type-mapping (I thought this might be my problem). The error I get when I deply states "SQL error: Communication link failure: Bad handshake". If anyone has successfully deployed MySQL with Orion, I would be very much interested in the contents of their xml files. - CJD
Orion and MySQL
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 edited the data-sources.xml and added a mysql.xml file under the database-schemas directory. Here is a piece of the data-sources.xml file and a piece of the mysql.xml: data-sources.xml data-source class=com.evermind.sql.DriverManagerDataSource name=MySQL location=jdbc/DefaultCoreDS xa-location=jdbc/xa/DefaultXADS ejb-location=jdbc/DefaultDS pooled-location=jdbc/DefaultPooledDS connection-driver=org.gjt.mm.mysql.Driver username=root password=root url=jdbc:mysql://localhost/mysql/data/oriondb inactivity-timeout=30 schema=database-schemas/mysql.xml / mysql.xml - database-schema name=MySQL not-null=not null null= primary-key=primary key type-mapping type=java.lang.String name=char (255) / type-mapping type=int name=int / type-mapping type=long name=int / type-mapping type=float name=float / type-mapping type=double name=double / type-mapping type=byte name=smallint / type-mapping type=char name=char / type-mapping type=short name=short / type-mapping type=java.util.Date name=timestamp / disallowed-field name=password / disallowed-field name=username / disallowed-field name=date / disallowed-field name=order / /database-schema I was very unsure as to what I should use for the location tags in the data-sources file. Also, with the mysql.xml file, I copied the Hypersonic schema file and removed the boolean type-mapping (I thought this might be my problem). The error I get when I deply states SQL error: Communication link failure: Bad handshake. If anyone has successfully deployed MySQL with Orion, I would be very much interested in the contents of their xml files. - CJD