openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Markus Herzog (JIRA)" <j...@apache.org>
Subject [jira] Updated: (OPENJPA-106) MappingTool does not function properly when using database-prefix in table-names on mysql
Date Wed, 24 Jan 2007 12:43:49 GMT

     [ https://issues.apache.org/jira/browse/OPENJPA-106?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Markus Herzog updated OPENJPA-106:
----------------------------------

    Attachment: tracelog2.zip
                tracelog1.zip

Hi,

here are two log files with trace output. The first one has no errors, because the databases
(PLAYGROUND and PLAYGROUND2) do not have any tables yet. The tables (PLAYGROUND.FOO and PLAYGROUND2.BAR)
are created properly.
When i run the mapping and schema tool again things start do get strange (see second log file).

this is a piece of my ant script:
<mappingtool action="refresh" schemaFile="${project.etcoutput.dir}/jdo/schema.xml">
	<classpath refid="project.classpath"/>
	<fileset dir="${project.output.dir}">
		<include name="**/package.jdo" />
	</fileset>
</mappingtool>

<schematool action="refresh">
	<fileset dir="${project.etcoutput.dir}/jdo">
		<include name="schema.xml" />
	</fileset>
</schematool>

Thank you very much,
Markus

> MappingTool does not function properly when using database-prefix in table-names on mysql
> -----------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-106
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-106
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>         Environment: OS: Windows and Unix, openjpa-0.9.6-incubating, mysql-5.x, mysql-jdbc-connector
3.?? and 5.0.4
>            Reporter: Markus Herzog
>            Priority: Minor
>         Attachments: tracelog1.zip, tracelog2.zip
>
>
> Hi,
> the problem i'm going to describe here probably only exists when using openjpa together
with mysql. Maybe this is even a bug in the mysql-jdbc-connector.
> The MappingTool (and MappingToolTask) does not notice that a table exists when the name
of the table also contains the name of the database (for example <class name="my.company.MyClass"
table="my_database.MYCLASS" />)
> Everything else is working satisfyingly with this prefix-thingy. As a work around i'm
removing the prefixes from my metadata before using mappingtool and put it back in afterwards.
(I need this prefix after all because i'm using multiple databases at once).
> Maybe when the mappingtool asks the database for the table "my_database.MYCLASS", the
jdbc-connector tells openjpa that no such table exists. If so, can't mappingtool ask the database
differently?
> Thank you for listening and keep up the good work,
> Markus

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message