Hello all,
when will the version for the MySQL connection?
Greetings
Stefan
Floreantpos/MySQL (17 posts)
Source code will be published soon. So wait!
If you are an advanced user you can recompile it doing the following
Find mysql connector for Java and add that libary. Replace all the instances of
- org.hibernate.dialect.DerbyDialect with org.hibernate.dialect.MySQLDialect
- org.apache.derby.jdbc.ClientDriver with com.mysql.jdbc.Driver
- in database connecting string use "jdbc:mysql:///posdb"
Where you host your mysql databases you have to create a DB named posdb and then system should build the tables automatically.
If you are an advanced user you can recompile it doing the following
Find mysql connector for Java and add that libary. Replace all the instances of
- org.hibernate.dialect.DerbyDialect with org.hibernate.dialect.MySQLDialect
- org.apache.derby.jdbc.ClientDriver with com.mysql.jdbc.Driver
- in database connecting string use "jdbc:mysql:///posdb"
Where you host your mysql databases you have to create a DB named posdb and then system should build the tables automatically.
Robert sent a message regarding mysql connectivity. Connection string had a typo in last message. you have to use "jdbc:mysql:// server ip/ posdb "(no space) and posdb database should be blank.
for me it was not space problem cause i don't use copy/paste.
I have that blank posdb but its useless. I tried to enter data manually the same they are in derby but the program say "there is no shift for this time"
Shift table in mysql have the same data as shift table in derby.
Any help???
I have that blank posdb but its useless. I tried to enter data manually the same they are in derby but the program say "there is no shift for this time"
Shift table in mysql have the same data as shift table in derby.
Any help???
Robert,
Which files did you modified, despite the hibernate config xml?
I'm trying to do the same and keep getting the 'connection failed' message.
Greetings.
Which files did you modified, despite the hibernate config xml?
I'm trying to do the same and keep getting the 'connection failed' message.
Greetings.
Now FloreantPOS is working with mysql!
Modify hibernate.cfg.xml
Export tables from derby to mysql database
and run!
Modify hibernate.cfg.xml
Export tables from derby to mysql database
and run!
Robert,
Is there any modifications to the code that needs to be done?
Can you provide more detail?
Cheers...
Is there any modifications to the code that needs to be done?
Can you provide more detail?
Cheers...
I am having really hard time migrating to MySql, can someone pls help me out. btw I did all instances replacements (in hibernate.cfg.xml and _RootDAO.java)
Netbeans connecting to mysql but no luck with mysql.
Also somebody pls export databse in mysql and send the sql file
Netbeans connecting to mysql but no luck with mysql.
Also somebody pls export databse in mysql and send the sql file
gotta add the latest mysql driver file in classpath in that of project.properities that file which fixes the problem, now how do I export tables and data from Derby to MySql, help plz
Can someone send me the dump of MySql file to my mail 99rays@gmail.com
Chuck41 unfortunelly I haven't the clean mysql data, but you can download Squirrel SQL software, connect at the same time at derby and mysql databases and use the DBCopy plugin to copy tables and data, else, I can give yo a dump with a few data from my configuration and later you delete my data...
Thanks Imigueldiaz, this indeed help me in migrating data from derby to MySql in a breeze, However I have another issue surfacing, I am able to connect to the MySql database from the connection dialogue, but when tried to access database tables hibernate is throwing "JDBC Driver class not found: com.mysql.jdbc.Driver" exception. any idea what is causing this
fyi, I am using Netbeans IDE
fyi, I am using Netbeans IDE
class is indeed at lib/mysql-connector-java-3.1.8-bin.jar
could you send the stack trace to imigueldiaz at gmail dot com ? could be It gives me any idea...
could you send the stack trace to imigueldiaz at gmail dot com ? could be It gives me any idea...
Any additional clues as to how to configure this?
Do you edit it in the .jar file or do you have to edit in the source then recompile?
Which files do you have to edit besides the hibernate.cfg.xml and is there support for the latest version of the mysql-connector-java-5.1.17-bin.jar?
If you have working files or the source code with instructions or any help please email me KollanH at gmail dot com.
Do you edit it in the .jar file or do you have to edit in the source then recompile?
Which files do you have to edit besides the hibernate.cfg.xml and is there support for the latest version of the mysql-connector-java-5.1.17-bin.jar?
If you have working files or the source code with instructions or any help please email me KollanH at gmail dot com.
has anyone even written up how to do this correctly yet? I havent seen anything and tried everything to get the pos to connect to the Mysql server. Anyone care to help?
I have a list of changes that I need to have done, one is getting the POS to work on postgres, I can attempt mysql at the same time and write up a HOW TO.
Log in to reply this topic