Blacknight91titi Messages postés Date d’inscription jeudi 17 juin Dernière intervention 9 mars 1 6 nov. I attempted to perform an installation based upon the instructions presented by EasyTrieve with the following results:. JDBC technology-enabled drivers Vous pourrez affiner votre recherche en fonction de plusieurs critères: Comment charger un driver? I tried to get this to work on OpenOffice 4.

Seems the first time I tried this it failed because there actually was NO Native connector present. Il existe quatre types de drivers JDBC cf. Populate controls with previous record using a query. En effet, les quatre types de drivers disposent de leurs avantages, inconvénients et spécificités. How do I set creation and modification dates automatically in my table rows?

Here is where I am stuck at the moment:. I think the Datasource URL should be set to either mysql: Or do you need each? As I searched for an answer to this I found a reference to setting up this screen, which I still don’t have a clue about so perhaps you could help explain that to:.

I’m using LO 5. This is tested to work for Mariadb Also below are some tips for possibly using MySQL. I tried to get this to work on OpenOffice 4. First it wanted me to select the java class path archive in the home space rather than the root. I was able to manually type in the real address for it from the root. But then I got stopped when I tried to open the database below after I had entered the correct info in, especially « org.

Driver », but it comes back with the wrong driver class:. I think I like it better than phpMyAdmin. You’ll want to have the server stopped while editing these, especially if moving the path to the database files by changing the datadir parameter.

You’re looking jdbf the « Universal » OS version it’s Java after all and will run on any OSnot the source, but you can also get the source if you like to peek inside to investigate the file hierarchy naming which will be used below. The important thing is you need the mariadb-java-client It’s a little confusing because it’s sometimes called a connectorand sometimes a clientand it’s both.

I had a hard time finding where to copy it to. Another post suggested this I’m not sure what you could mean by  » I was really looking for a more comprehensive answer Driver » is arrived at. If you wanted « pictures » I would have pointed you here – Creating a DB but it doesn’t have the links for the connectors.

Before you re-write more of the existing documentation, you may want to peruse what is in existence – click here. EasyTrieve – sometimes good to have details but if you look at my edited answer things can change. EasyTrieve Just found this today while testing different DB performance on different.

Connexion par JDBC à une base de données Mysql

You may know this already but just in case I’ll pass it on. Native is the myxql way to connect – many times faster through my testing. Did find this one which did work – click here. The problem is that it replaces the installed one and I can’t seem to mmysql where to get the original again.

Even reloading LO didn’t work. To me that is a problem because the one which works for MariaDB in v5. EasyTrieve Just a correction.

Seems the first time I tried this it failed because there actually was NO Native connector present. I also found my copy of the. RatslingerI hear you but I’m confused. If you install this drivet it mess up LO, « The problem is that it replaces the installed one and I can’t seem to find where to get the original again. Also it only says works with LO 4. My memory is failing, but I thought there used to be a native option and it was removed for some reason.

Now I don’t see Native under Connect to an existing database. EasyTrieve Sorry for the confusion. The location is here.

Installer le pilote JDBC

ODF is a generic term not an actual file extension. So an ODF spreadsheet has an extension. The Class Path is .mar but is nothing more than pointing to using Add Archive .jad connector.

This is where you enter the connection properties:. I attempted to perform an installation based upon the instructions presented by EasyTrieve with the following results:. Start with almost newly installed OS of Debian 8. During the installation drover, you will be asked for a password for root account. Signing on was a bit of a pain – mentioned instructions were overly stated. You just need mysql -u root -p for first time sign-in. Then prompted for password from the installation step.

Signed in so listed databases:. Not even the « test » database stated in the instructions here. LOas mentioned, was installed. Tried to get v1. Signed up but even when asking to v1.

Installer le pilote JDBC [Fermé]

JRE works fine in Linux and Windows. If you look, a lot of those answers are from me. See this post and also the link from there. While that may be true, there are other softwares which either require or benefit from JDK, it usually won’t hurt to have it instead. Also, at least on Ubuntu, there’s no way to install just JRE the canon way. I think they came to the same conclusion: Other software doesn’t necessarily have anything to do with LO. I’m on Xubuntu and Mint.

I install from Oracle .ajr LO. Seen a number of problems using distro installs. Glad to hear that the Relationship issue is confirmed. Possibly missing or criver connection parameters?? For what drivfr worth, did you try org. Yes tried everything I could imagine with the maria db connector.

The worst was the web site. Sign in, ask for 1. RatslingerMy dgiver. Revised my answer, and my comment to you above last night, but comment revisions didn’t seem to take. Also, sorry, but I had a mistake showing above. Was showing wrong driver path. Appreciate you checking my work.

MariaDB connector was my fault. I was trying to use com. Also confirmed my suspicions – mariadb-java-client I keep it in my home directory. Good news as there is a lack of good tools my opinion for it in Linux. Ratslinger yes that is right. I made this mistake too, at first.

As well as changing the name when they forked, they mover from com to org top level just to rub in the point that jdbf are not-for-profit. Don’t see the purpose of the comment.

I don’t even use MariaDB. Only did myssql for testing purposes to answer question. Actually moving away from MySQL also. Views and queries are visible. Upgraded to XUbuntu How do I set creation and modification dates automatically in my table rows? Populate controls with previous record using a query.

Check out the FAQ! Here is where I am stuck at the moment: As I searched for an answer to this I found a reference to setting up this screen, which I still don’t have a clue about so perhaps you could help explain that to: Are Archive or Folder alternatives? First uninstall Java 7 and install Development Kit 8u, which you’ll need.