| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> |
| <head> |
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| <meta name="keywords" content="SMILA/Documentation/General JPA Configuration in SMILA,Using EclipseLink JPA Extensions (ELUG)" /> |
| <link rel="shortcut icon" href="http://wiki.eclipse.org/SMILA/Documentation/favicon.ico" /> |
| <link rel="search" type="application/opensearchdescription+xml" href="http://wiki.eclipse.org/opensearch_desc.php" title="Eclipsepedia (English)" /> |
| <link rel="alternate" type="application/rss+xml" title="Eclipsepedia RSS Feed" href="http://wiki.eclipse.org/index.php?title=Special:Recentchanges&feed=rss" /> |
| <link rel="alternate" type="application/atom+xml" title="Eclipsepedia Atom Feed" href="http://wiki.eclipse.org/index.php?title=Special:Recentchanges&feed=atom" /> |
| |
| |
| <title>SMILA/Documentation/General JPA Configuration in SMILA - Eclipsepedia</title> |
| |
| <style type="text/css" media="screen,projection">/*<![CDATA[*/ @import "/skins/eclipsenova/novaWide.css?116"; /*]]>*/</style> |
| <link rel="stylesheet" type="text/css" media="print" href="http://wiki.eclipse.org/skins/eclipsenova/eclipsenovaPrint.css?116" /> |
| <link rel="stylesheet" type="text/css" media="handheld" href="http://wiki.eclipse.org/skins/eclipsenova/handheld.css?116" /> |
| <link rel="stylesheet" type="text/css" href="http://wiki.eclipse.org/skins/eclipsenova/Nova/css/header.css" media="screen" /> |
| <link rel="stylesheet" type="text/css" href="http://wiki.eclipse.org/skins/eclipsenova/tabs.css" media="screen" /> |
| <link rel="stylesheet" type="text/css" href="http://wiki.eclipse.org/skins/eclipsenova/Nova/css/visual.css" media="screen" /> |
| <link rel="stylesheet" type="text/css" href="http://wiki.eclipse.org/skins/eclipsenova/Nova/css/layout.css" media="screen" /> |
| <link rel="stylesheet" type="text/css" href="http://wiki.eclipse.org/skins/eclipsenova/Nova/css/footer.css" media="screen" /> |
| <!--[if IE]><link rel="stylesheet" type="text/css" href="/skins/eclipsenova/IEpngfix.css" media="screen" /><![endif]--> |
| <!--[if lt IE 5.5000]><style type="text/css">@import "/skins/eclipsenova/IE50Fixes.css?116";</style> <![endif]--> |
| <!--[if IE 5.5000]><style type="text/css">@import "/skins/eclipsenova/IE55Fixes.css?116";</style><![endif]--> |
| <!--[if IE 6]><style type="text/css">@import "/skins/eclipsenova/IE60Fixes.css?116";</style><![endif]--> |
| <!--[if IE 7]><style type="text/css">@import "/skins/eclipsenova/IE70Fixes.css?116";</style><![endif]--> |
| <!--[if lt IE 7]><script type="text/javascript" src="/skins/common/IEFixes.js?116"></script> |
| <meta http-equiv="imagetoolbar" content="no" /><![endif]--> |
| <script type= "text/javascript">/*<![CDATA[*/ |
| var skin = "eclipsenova"; |
| var stylepath = "/skins"; |
| var wgArticlePath = "/$1"; |
| var wgScriptPath = ""; |
| var wgScript = "/index.php"; |
| var wgServer = "http://wiki.eclipse.org"; |
| var wgCanonicalNamespace = ""; |
| var wgCanonicalSpecialPageName = false; |
| var wgNamespaceNumber = 0; |
| var wgPageName = "SMILA/Documentation/General_JPA_Configuration_in_SMILA"; |
| var wgTitle = "SMILA/Documentation/General JPA Configuration in SMILA"; |
| var wgAction = "view"; |
| var wgRestrictionEdit = []; |
| var wgRestrictionMove = []; |
| var wgArticleId = "22054"; |
| var wgIsArticle = true; |
| var wgUserName = null; |
| var wgUserGroups = null; |
| var wgUserLanguage = "en"; |
| var wgContentLanguage = "en"; |
| var wgBreakFrames = false; |
| var wgCurRevisionId = "285859"; |
| var wgVersion = "1.12.0"; |
| var wgEnableAPI = true; |
| var wgEnableWriteAPI = false; |
| /*]]>*/</script> |
| |
| <script type="text/javascript" src="http://wiki.eclipse.org/skins/common/wikibits.js?116"><!-- wikibits js --></script> |
| |
| <!-- Performance mods similar to those for bug 166401 --> |
| <script type="text/javascript" src="http://wiki.eclipse.org/index.php?title=-&action=raw&gen=js&useskin=eclipsenova"><!-- site js --></script> |
| |
| <!-- Head Scripts --> |
| <script type="text/javascript" src="http://wiki.eclipse.org/skins/common/ajax.js?116"></script> |
| <style type="text/css">/*<![CDATA[*/ |
| .source-text {line-height: normal; font-size: medium;} |
| .source-text li {line-height: normal;} |
| /** |
| * GeSHi Dynamically Generated Stylesheet |
| * -------------------------------------- |
| * Dynamically generated stylesheet for text |
| * CSS class: source-text, CSS id: |
| * GeSHi (C) 2004 - 2007 Nigel McNie (http://qbnz.com/highlighter) |
| */ |
| .source-text .de1, .source-text .de2 {font-family: 'Courier New', Courier, monospace; font-weight: normal;} |
| .source-text {} |
| .source-text .head {} |
| .source-text .foot {} |
| .source-text .imp {font-weight: bold; color: red;} |
| .source-text .ln-xtra {color: #cc0; background-color: #ffc;} |
| .source-text li {font-family: 'Courier New', Courier, monospace; color: black; font-weight: normal; font-style: normal;} |
| .source-text li.li2 {font-weight: bold;} |
| |
| /*]]>*/ |
| </style> |
| <style type="text/css">/*<![CDATA[*/ |
| @import "/index.php?title=MediaWiki:Geshi.css&usemsgcache=yes&action=raw&ctype=text/css&smaxage=18000"; |
| /*]]>*/ |
| </style><link rel="stylesheet" type="text/css" href="General_JPA_Configuration_in_SMILA.html" /> </head> |
| <body class="mediawiki ns-0 ltr page-SMILA_Documentation_General_JPA_Configuration_in_SMILA"> |
| <div id="globalWrapper"> |
| |
| |
| <div id="column-one"> |
| <!-- Eclipse Additions for the Top Nav start here M. Ward--> |
| |
| <div id="header"> |
| <div id="header-graphic"> |
| <img src="http://wiki.eclipse.org/skins/eclipsenova/eclipse.png" alt="Eclipse Wiki"> |
| </div> |
| <!-- Pulled 101409 Mward --> |
| |
| <div class="portlet" id="p-personal"> |
| <div class="pBody"> |
| <ul> |
| <li id="pt-login"><a href="http://wiki.eclipse.org/index.php?title=Special:Userlogin&returnto=SMILA/Documentation/General_JPA_Configuration_in_SMILA">Log in</a></li> |
| </ul> |
| </div> |
| </div> |
| |
| <div id="header-icons"> |
| <div id="sites"> |
| <ul id="sitesUL"> |
| <li><a href="http://www.eclipse.org"><img src="http://dev.eclipse.org/custom_icons/eclipseIcon.png" width="28" height="28" alt="Eclipse Foundation" title="Eclipse Foundation" /><div>Eclipse Foundation</div></a></li> |
| <li><a href="http://marketplace.eclipse.org"><img src="http://dev.eclipse.org/custom_icons/marketplace.png" width="28" height="28" alt="Eclipse Marketplace" title="Eclipse Marketplace" /><div>Eclipse Marketplace</div></a></li> |
| <li><a href="https://bugs.eclipse.org/bugs"><img src="http://dev.eclipse.org/custom_icons/system-search-bw.png" width="28" height="28" alt="Bugzilla" title="Bugzilla" /><div>Bugzilla</div></a></li> |
| <li><a href="http://live.eclipse.org"><img src="http://dev.eclipse.org/custom_icons/audio-input-microphone-bw.png" width="28" height="28" alt="Live" title="Live" /><div>Eclipse Live</div></a></li> |
| <li><a href="http://planeteclipse.org"><img src="http://dev.eclipse.org/large_icons/devices/audio-card.png" width="28" height="28" alt="PlanetEclipse" title="Planet" /><div>Planet Eclipse</div></a></li> |
| <li><a href="http://portal.eclipse.org"><img src="http://dev.eclipse.org/custom_icons/preferences-system-network-proxy-bw.png" width="28" height="28" alt="Portal" title="Portal" /><div>My Foundation Portal</div></a></li> |
| </ul> |
| </div> |
| </div> |
| </div> |
| <!-- NEW HEADER STUFF HERE --> |
| <div id="header-menu"> |
| <div id="header-nav"> |
| <ul> <li><a class="first_one" href="http://wiki.eclipse.org/" target="_self">Home</a></li> <li><a href="http://www.eclipse.org/downloads/" target="_self">Downloads</a></li> |
| <li><a href="http://www.eclipse.org/users/" target="_self">Users</a></li> |
| <li><a href="http://www.eclipse.org/membership/" target="_self">Members</a></li> |
| <li><a href="http://wiki.eclipse.org/index.php/Development_Resources" target="_self">Committers</a></li> |
| <li><a href="http://www.eclipse.org/resources/" target="_self">Resources</a></li> |
| <li><a href="http://www.eclipse.org/projects/" target="_self">Projects</a></li> |
| <li><a href="http://www.eclipse.org/org/" target="_self">About Us</a></li> |
| </ul> |
| </div> |
| <div id="header-utils"> |
| <!-- moved the search window here --> |
| <form action="http://wiki.eclipse.org/Special:Search" > |
| <input class="input" name="search" type="text" accesskey="f" value="" /> |
| <input type='submit' onclick="this.submit();" name="go" id="searchGoButton" class="button" title="Go to a page with this exact name if one exists" value="Go" /> |
| <input type='submit' onclick="this.submit();" name="fulltext" class="button" id="mw-searchButton" title="Search Eclipsepedia for this text" value="Search" /> |
| </form> |
| </div> |
| </div> |
| |
| |
| <!-- Eclipse Additions for the Header stop here --> |
| <!-- Additions and mods for leftside nav Start here --> |
| |
| <!--Started nav rip here--> |
| <!-- these are the nav controls main page, changes etc --> |
| <div id="novaContent" class="faux"> |
| <div id="leftcol"> |
| <ul id="leftnav"> |
| <!-- these are the page controls, edit history etc --> |
| <li class="separator"><a class="separator">Navigation   </li> |
| <li id="n-mainpage"><a href="http://wiki.eclipse.org/Main_Page">Main Page</a></li> |
| <li id="n-portal"><a href="http://wiki.eclipse.org/Eclipsepedia:Community_Portal">Community portal</a></li> |
| <li id="n-currentevents"><a href="http://wiki.eclipse.org/Eclipsepedia:Current_events">Current events</a></li> |
| <li id="n-recentchanges"><a href="http://wiki.eclipse.org/Special:Recentchanges">Recent changes</a></li> |
| <li id="n-randompage"><a href="http://wiki.eclipse.org/Special:Random">Random page</a></li> |
| <li id="n-help"><a href="http://wiki.eclipse.org/Help:Contents">Help</a></li> |
| <li class="separator"><a class="separator">Toolbox   </a></li> |
| |
| <li id="t-whatlinkshere"><a href="http://wiki.eclipse.org/Special:Whatlinkshere/SMILA/Documentation/General_JPA_Configuration_in_SMILA">What links here</a></li> |
| <li id="t-recentchangeslinked"><a href="http://wiki.eclipse.org/Special:Recentchangeslinked/SMILA/Documentation/General_JPA_Configuration_in_SMILA">Related changes</a></li> |
| <!-- This is the toolbox section --> |
| <li id="t-upload"><a href="http://wiki.eclipse.org/Special:Upload">Upload file</a></li> |
| <li id="t-specialpages"><a href="http://wiki.eclipse.org/Special:Specialpages">Special pages</a></li> |
| <li id="t-print"><a href="http://wiki.eclipse.org/index.php?title=SMILA/Documentation/General_JPA_Configuration_in_SMILA&printable=yes">Printable version</a></li> <li id="t-permalink"><a href="http://wiki.eclipse.org/index.php?title=SMILA/Documentation/General_JPA_Configuration_in_SMILA&oldid=285859">Permanent link</a></li> </ul> |
| </div> |
| |
| |
| <!-- Additions and mods for leftside nav End here --> |
| |
| |
| <div id="column-content"> |
| <div id="content"> |
| <a name="top" id="top"></a> |
| |
| <div id="tabs"> |
| <ul class="primary"> |
| <li class="active"><a href="General_JPA_Configuration_in_SMILA.html"><span class="tab">Page</span></a></li> |
| <li><a href="http://wiki.eclipse.org/index.php?title=Talk:SMILA/Documentation/General_JPA_Configuration_in_SMILA&action=edit"><span class="tab">Discussion</span></a></li> |
| <li><a href="http://wiki.eclipse.org/index.php?title=SMILA/Documentation/General_JPA_Configuration_in_SMILA&action=edit"><span class="tab">View source</span></a></li> |
| <li><a href="http://wiki.eclipse.org/index.php?title=SMILA/Documentation/General_JPA_Configuration_in_SMILA&action=history"><span class="tab">History</span></a></li> |
| <li><a href="http://wiki.eclipse.org/index.php?title=Special:Userlogin&returnto=SMILA/Documentation/General%20JPA%20Configuration%20in%20SMILA"><span class="tab">Edit</span></a></li> |
| </ul> |
| </div> |
| |
| |
| <script type="text/javascript"> if (window.isMSIE55) fixalpha(); </script> |
| <h1 class="firstHeading">SMILA/Documentation/General JPA Configuration in SMILA</h1> |
| <div id="bodyContent"> |
| <h3 id="siteSub">From Eclipsepedia</h3> |
| <div id="contentSub"><span class="subpages">< <a href="../../SMILA.html" title="SMILA">SMILA</a> | <a href="../Documentation.1.html" title="SMILA/Documentation">Documentation</a></span></div> |
| <div id="jump-to-nav">Jump to: <a href="General_JPA_Configuration_in_SMILA.html#column-one">navigation</a>, <a href="General_JPA_Configuration_in_SMILA.html#searchInput">search</a></div> <!-- start content --> |
| <p> |
| </p> |
| <table id="toc" class="toc" summary="Contents"><tr><td><div id="toctitle"><h2>Contents</h2></div> |
| <ul> |
| <li class="toclevel-1"><a href="General_JPA_Configuration_in_SMILA.html#Overview"><span class="tocnumber">1</span> <span class="toctext">Overview</span></a></li> |
| <li class="toclevel-1"><a href="General_JPA_Configuration_in_SMILA.html#Configuration"><span class="tocnumber">2</span> <span class="toctext">Configuration</span></a> |
| <ul> |
| <li class="toclevel-2"><a href="General_JPA_Configuration_in_SMILA.html#Configuring_usage_of_another_database_vendor"><span class="tocnumber">2.1</span> <span class="toctext">Configuring usage of another database vendor</span></a> |
| <ul> |
| <li class="toclevel-3"><a href="General_JPA_Configuration_in_SMILA.html#persistence.properties"><span class="tocnumber">2.1.1</span> <span class="toctext">persistence.properties</span></a></li> |
| <li class="toclevel-3"><a href="General_JPA_Configuration_in_SMILA.html#including_the_JDBC_driver"><span class="tocnumber">2.1.2</span> <span class="toctext">including the JDBC driver</span></a></li> |
| </ul> |
| </li> |
| <li class="toclevel-2"><a href="General_JPA_Configuration_in_SMILA.html#Correcting_Datatypes_and_lengths"><span class="tocnumber">2.2</span> <span class="toctext">Correcting Datatypes and lengths</span></a></li> |
| </ul> |
| </li> |
| <li class="toclevel-1"><a href="General_JPA_Configuration_in_SMILA.html#Limitations_and_Known_Issues"><span class="tocnumber">3</span> <span class="toctext">Limitations and Known Issues</span></a> |
| <ul> |
| <li class="toclevel-2"><a href="General_JPA_Configuration_in_SMILA.html#Warning:__No_suitable_driver_found"><span class="tocnumber">3.1</span> <span class="toctext">Warning: No suitable driver found</span></a></li> |
| <li class="toclevel-2"><a href="General_JPA_Configuration_in_SMILA.html#Warning:__table_XXX_exists_already"><span class="tocnumber">3.2</span> <span class="toctext">Warning: table XXX exists already</span></a></li> |
| <li class="toclevel-2"><a href="General_JPA_Configuration_in_SMILA.html#Why_does_another_DB_provider_involve_so_much_configuration_.3F"><span class="tocnumber">3.3</span> <span class="toctext">Why does another DB provider involve so much configuration ?</span></a></li> |
| </ul> |
| </li> |
| </ul> |
| </td></tr></table><script type="text/javascript"> if (window.showTocToggle) { var tocShowText = "show"; var tocHideText = "hide"; showTocToggle(); } </script> |
| <a name="Overview"></a><h2> <span class="mw-headline"> Overview </span></h2> |
| <p>This page explains how to configure the general JPA aspects of bundles that use JPA to store information. At the moment EclipseLink (EL) is used as the JPA Provider. |
| </p> |
| <a name="Configuration"></a><h2> <span class="mw-headline"> Configuration </span></h2> |
| <p>To configure JPA you will at least have to edit the <span style="font-family:monospace;"><configuration>/<bundlename>/persistence.properties</span>. These properties are passed to javax.persistence.Persistence.createEntityManagerFactory(String, Map) to initialize EclipseLink . |
| </p><p>These are the default values as shipped, although the URL for <span style="font-family:monospace;">eclipselink.jdbc.url</span> will vary for each bundle: |
| </p> |
| <div dir="ltr" style="text-align: left;"><pre class="source-text"># EclipseLink properties |
| eclipselink.logging.level=INFO |
| eclipselink.target-server=None |
| eclipselink.target-database=org.eclipse.persistence.platform.database.DerbyPlatform |
| eclipselink.jdbc.driver=org.apache.derby.jdbc.EmbeddedDriver |
| eclipselink.jdbc.url=jdbc:derby:workspace/.metadata/.plugins/org.eclipse.smila.binarystorage.persistence.jpa/binarystorage;create=true |
| eclipselink.jdbc.password=smila |
| eclipselink.jdbc.user=smila |
| eclipselink.ddl-generation=create-tables</pre></div> |
| <p>See the <a href="http://wiki.eclipse.org/Using_EclipseLink_JPA_Extensions_%28ELUG%29#Using_EclipseLink_JPA_Extensions_for_JDBC" title="Using EclipseLink JPA Extensions (ELUG)">EL documentation</a> for an in depth discussion. |
| </p><p>This page will discuss only a few common use cases. |
| </p><p><br /> |
| </p> |
| <a name="Configuring_usage_of_another_database_vendor"></a><h3> <span class="mw-headline"> Configuring usage of another database vendor </span></h3> |
| <p>This consists of several steps due to some limitiations of JPA and/or EL: |
| </p> |
| <a name="persistence.properties"></a><h4> <span class="mw-headline"> persistence.properties </span></h4> |
| <p>Here you need to specify at least the values for the new vendor as set forth in its documentation for your setup. The example below shows it for an MSSQL 2005 setup. |
| </p> |
| <pre> |
| eclipselink.target-database=org.eclipse.persistence.platform.database.SQLServerPlatform |
| eclipselink.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver |
| eclipselink.jdbc.url=jdbc:sqlserver://lh:1433;DatabaseName=smila |
| </pre> |
| <a name="including_the_JDBC_driver"></a><h4> <span class="mw-headline"> including the JDBC driver </span></h4> |
| <p>The more correct way to do this is to provide a bundle for the driver and export the package that contains the Driver Class. See the relevant PDE documentation on how this is accompished. |
| </p><p>This bundle then must be imported in the <span style="font-family:monospace;"><plugins>/<bundle>/META-INF/MANIFEST.MF</span>, e.g. like so: |
| </p> |
| <pre> |
| Manifest-Version: 1.0 |
| Bundle-ManifestVersion: 2 |
| Bundle-Name: BinaryStorage Persistence Jpa Plug-in |
| Bundle-SymbolicName: org.eclipse.smila.binarystorage.persistence.jpa |
| Bundle-Version: 0.5.0 |
| Bundle-Vendor: empolis GmbH |
| Import-Package: javax.persistence;version="1.99.0", |
| org.apache.commons.io;version="1.4.0", |
| org.apache.commons.logging;version="1.0.4", |
| org.apache.derby.jdbc;version="10.5.1.1", |
| com.microsoft.sqlserver.jdbc;version="1.0.0", |
| org.eclipse.smila.binarystorage;version="0.5.0", |
| org.eclipse.smila.binarystorage.config;version="0.7.0", |
| org.eclipse.smila.binarystorage.persistence;version="0.7.0", |
| org.eclipse.smila.utils.config;version="0.5.0" |
| JPA-PersistenceUnits: SmilaBinaryObject |
| Eclipse-RegisterBuddy: org.eclipse.smila.binarystorage.impl |
| Export-Package: org.eclipse.smila.binarystorage.persistence.jpa;version="0.5.0" |
| </pre> |
| <p>In this example there was a SQL Server JDBC bundle created that exports the package <span style="font-family:monospace;">com.microsoft.sqlserver.jdbc</span> which package then is imported here. |
| </p><p>Alternativly, for a quick test or hack you my just copy the driver.jar to a folder of the bundle using JPA and put it on the bundle's classpath like so: |
| </p> |
| <pre> |
| Manifest-Version: 1.0 |
| Bundle-ManifestVersion: 2 |
| Bundle-Name: RecordStorage Impl Plug-in (Incubation) |
| Bundle-SymbolicName: org.eclipse.smila.recordstorage.impl |
| Bundle-Version: 0.5.0 |
| Bundle-Vendor: empolis GmbH |
| Import-Package: javax.persistence;version="1.99.0", |
| javax.persistence.spi;version="1.99.0", |
| org.apache.commons.io, |
| org.apache.commons.logging, |
| org.apache.derby.jdbc;version="10.4.1.3", |
| org.eclipse.persistence.annotations, |
| org.eclipse.persistence.config, |
| org.eclipse.persistence.expressions, |
| org.eclipse.persistence.internal.expressions, |
| org.eclipse.persistence.jpa, |
| org.eclipse.persistence.queries, |
| org.eclipse.persistence.sessions, |
| org.eclipse.smila.datamodel.id;version="0.5.0", |
| org.eclipse.smila.datamodel.id.impl;version="0.5.0", |
| org.eclipse.smila.datamodel.record;version="0.5.0", |
| org.eclipse.smila.datamodel.record.impl;version="0.5.0", |
| org.eclipse.smila.recordstorage;version="0.5.0", |
| org.eclipse.smila.utils.collections, |
| org.eclipse.smila.utils.config;version="0.5.0", |
| org.osgi.framework;version="1.4.0", |
| org.osgi.service.component;version="1.0.0" |
| Service-Component: OSGI-INF/recordstorage.xml |
| JPA-PersistenceUnits: SmilaRecord |
| Export-Package: org.eclipse.smila.recordstorage.util;version="0.5.0" |
| Bundle-RequiredExecutionEnvironment: JavaSE-1.6 |
| Bundle-ClassPath: .,META-INF/sqljdbc4.jar |
| </pre> |
| <p> |
| <b>Note:</b> |
| Some JDBC drivers need java 1.6 while others need 1.5. Since SMILA runs with 1.6 make sure it is supported! |
| |
| <a name="Correcting_Datatypes_and_lengths"></a><h3> <span class="mw-headline"> Correcting Datatypes and lengths </span></h3> |
| <p>In SMILA we uses the file <span style="font-family:monospace;">META-INF/orm.xml</span> to define the mapping of the Java classes to the database. If you get errors when creating the tables it might be due to the default mapping that is in place. |
| </p><p>Also check that otherwise the EL default mappings that are defined in the class given in <span style="font-family:monospace;">eclipselink.target-database</span> match your needs. For instance this was not the case for Derby! It defines for byte[] a BLOB(64000) which is not sufficient in binarystorage, so we had to just use BLOB. |
| </p> |
| <a name="Limitations_and_Known_Issues"></a><h2> <span class="mw-headline"> Limitations and Known Issues </span></h2> |
| <a name="Warning:__No_suitable_driver_found"></a><h3> <span class="mw-headline"> Warning: No suitable driver found </span></h3> |
| <p>The log contains entries such as: |
| </p><p><tt> |
| [EL Warning]: 2009.10.17 09:31:39.085--ServerSession(16634203)--java.sql.SQLException: No suitable driver found for jdbc:sqlserver://lh:1433;DatabaseName=smila |
| </tt> |
| </p><p>These log entries can be ignored. They are caused by EL when iterating over all possible drivers to take the specified connecction. Finally it will find one that works if configiation is correct otherwise. |
| </p> |
| <a name="Warning:__table_XXX_exists_already"></a><h3> <span class="mw-headline"> Warning: table XXX exists already </span></h3> |
| <p>This warning can be ignored as well and is cause by the <span style="font-family:monospace;">eclipselink.ddl-generation</span> property. The default value , causes that the table(s) are attempted to be created at startup of the bundle. If you ran SMILA before then this tables already exist, providing that you didnt drop the DB, and hence the error. |
| </p> |
| <a name="Why_does_another_DB_provider_involve_so_much_configuration_.3F"></a><h3> <span class="mw-headline"> Why does another DB provider involve so much configuration ? </span></h3> |
| <p>unfortunately the world is not perfect and the technologies that we use impose those on us until this is fixed there. See |
| </p> |
| <ul><li> <a href="http://www.eclipse.org/forums/index.php?t=msg&th=155948&start=0&S=09a587abaac560de95f6274996584c7b" class="external free" title="http://www.eclipse.org/forums/index.php?t=msg&th=155948&start=0&S=09a587abaac560de95f6274996584c7b" rel="nofollow">http://www.eclipse.org/forums/index.php?t=msg&th=155948&start=0&S=09a587abaac560de95f6274996584c7b</a> |
| </li><li> <a href="http://www.eclipse.org/forums/index.php?t=msg&th=156088&start=0&S=09a587abaac560de95f6274996584c7b" class="external free" title="http://www.eclipse.org/forums/index.php?t=msg&th=156088&start=0&S=09a587abaac560de95f6274996584c7b" rel="nofollow">http://www.eclipse.org/forums/index.php?t=msg&th=156088&start=0&S=09a587abaac560de95f6274996584c7b</a></p> |
| </li></ul> |
| |
| <!-- |
| NewPP limit report |
| Preprocessor node count: 60/1000000 |
| Post-expand include size: 515/2097152 bytes |
| Template argument size: 207/2097152 bytes |
| #ifexist count: 0/100 |
| --> |
| |
| <!-- Saved in parser cache with key wikidb:pcache:idhash:22054-0!1!0!!en!2!edit=0 and timestamp 20120203101244 --> |
| <div class="printfooter"> |
| Retrieved from "<a href="General_JPA_Configuration_in_SMILA.html">http://wiki.eclipse.org/SMILA/Documentation/General_JPA_Configuration_in_SMILA</a>"</div> |
| <div id="catlinks"><p class='catlinks'><a href="http://wiki.eclipse.org/Special:Categories" title="Special:Categories">Category</a>: <span dir='ltr'><a href="http://wiki.eclipse.org/Category:SMILA" title="Category:SMILA">SMILA</a></span></p></div> <!-- end content --> |
| <div class="visualClear"></div> |
| </div> |
| </div> |
| |
| |
| </div> |
| |
| |
| <!-- Yoink of toolbox for phoenix moved up --> |
| |
| |
| </div> |
| </div> |
| <div id="clearFooter"/> |
| <div id="footer" > |
| <ul id="footernav"> |
| <li class="first"><a href="http://www.eclipse.org/">Home</a></li> |
| <li><a href="http://www.eclipse.org/legal/privacy.php">Privacy Policy</a></li> |
| <li><a href="http://www.eclipse.org/legal/termsofuse.php">Terms of Use</a></li> |
| <li><a href="http://www.eclipse.org/legal/copyright.php">Copyright Agent</a></li> |
| <li><a href="http://www.eclipse.org/org/foundation/contact.php">Contact</a></li> |
| <li><a href="http://wiki.eclipse.org/Eclipsepedia:About" title="Eclipsepedia:About">About Eclipsepedia</a></li> |
| </ul> |
| <span id="copyright">Copyright © 2012 The Eclipse Foundation. All Rights Reserved</span> |
| <p id="footercredit">This page was last modified 16:10, 23 January 2012 by <a href="http://wiki.eclipse.org/User:Andreas.schank.attensity.com" title="User:Andreas.schank.attensity.com">A. Schank</a>. Based on work by <a href="http://wiki.eclipse.org/User:Tmenzel.brox.de" title="User:Tmenzel.brox.de">thomas menzel</a>.</p> |
| <p id="footerviews">This page has been accessed 2,108 times.</p> |
| </div> |
| |
| <script type="text/javascript"> |
| var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); |
| document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); |
| </script> |
| <script type="text/javascript"> |
| var pageTracker = _gat._getTracker("UA-910670-4"); |
| pageTracker._trackPageview(); |
| </script> |
| |
| |
| |
| |
| |
| |
| |
| <!-- <div class="visualClear"></div> --> |
| |
| <script type="text/javascript">if (window.runOnloadHook) runOnloadHook();</script> |
| </div> |
| |
| <!-- Served in 0.119 secs. --></body></html> |
