struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabriel Belingueres <belingue...@gmail.com>
Subject Re: MySQL + JDBC
Date Tue, 15 Dec 2009 13:53:10 GMT
I don't think it is directly related to Struts.

>From what I googled, seems more like a 32-bit/64-bit component
mismatch than a Struts issue.

On what JDK/JRE version are you running your app server? it is a 32
bit version of java? or a 64 bits version?

Your odbc driver is 32 bits or 64 bits? are you sure you installed it correctly?

I particularly don't know how the JDBC-ODBC bridge driver hooks on win
64 bits, but I would guess that it depends on the java vm version you
have installed...may be you can ask in a Sun support forum.

HTH
Gabriel

2009/12/15 Todd Grigsby <strutsuser@tgrigsby.com>:
>
> Yes, thank you Nils-H, I have been digging around in there as well.
>  Unfortunately, the problem only occurs from my Struts apps, and judging
> from the MySQL forums, not many other people experience this issue.
>
> TG
>
>
> Nils-Helge Garli Hegvik wrote:
>>
>> Have you tried asking over at the MySQL forum? I don't think this is
>> related to Struts 2.
>>
>> Nils-H
>>
>> On Tue, Dec 15, 2009 at 8:26 AM, Todd Grigsby <strutsuser@tgrigsby.com>
>> wrote:
>>
>>>
>>> (Beating head on keyboard...)
>>> "So one more time for the folks at home: Is there anyone out there who
>>> has
>>> managed to get MySQL 64-bit to work via ODBC?"
>>>
>>> For those who aren't aware, MySQL has an ODBC connector called, oddly
>>> enough, Connector/ODBC.  In previous versions it was called MyODBC.  It
>>> does
>>> work, as evidenced by the fact that I can connect from Windows apps with
>>> ease. What doesn't work, and the only thing I'm looking for an answer to
>>> is,
>>> why do I get the error, "The specified DSN contains an architecture
>>> mismatch
>>> between the Driver and Application" when connecting from within Struts 2?
>>>  But at this point I'd be happy hearing from anyone that has gotten
>>> "MySQL
>>> 64-bit to work via ODBC."
>>>
>>> TG
>>>
>>> Lee Clemens wrote:
>>>
>>>>
>>>> Not to sound like a jerk, but have you gotten JDBC (MySQL Connector/J)
>>>> working with a MySQL 64-bit server?  Or is this specifically a Struts
>>>> issue?
>>>> If so, what message/condition do you receive?
>>>>
>>>> Or are you merely asking if MySQL 64-bit is compatible with ODBC [OT]?
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: Todd Grigsby [mailto:strutsuser@tgrigsby.com] Sent: Monday,
>>>> December
>>>> 14, 2009 9:57 PM
>>>> To: Struts Users Mailing List
>>>> Subject: Re: MySQL + JDBC
>>>>
>>>>
>>>>
>>>> Not that I wanted to get into a debate about the usefulness of ODBC, but
>>>> the Java-based web services we have aren't the only things that connect
>>>> to
>>>> these databases, and going through ODBC has been, for the last 10 years,
>>>> a
>>>> very nice and consistent way to connect across all our applications and
>>>> utilities.  We have, at one time or another, supported all of the
>>>> following:
>>>>
>>>>   MySQL
>>>>   Oracle
>>>>   SQL Server
>>>>   Informix
>>>>   DB2
>>>>   mSQL
>>>>   Pervasive SQL
>>>>   MS Access (pre-Jet)
>>>>
>>>> And a few others, and we have connected to these databases via ODBC all
>>>> along the way.  Keeping the connection mechanism consistent has made
>>>> development work in a number of languages simple.  So while I certainly
>>>> appreciate everyone's enthusiasm for talking directly to MySQL, I have a
>>>> legacy code base that works *REALLY* well through ODBC, and I'd like to
>>>> stick with it.
>>>>
>>>> So one more time for the folks at home: Is there anyone out there who
>>>> has
>>>> managed to get MySQL 64-bit to work via ODBC?
>>>>
>>>> TG
>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>
>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>>> For additional commands, e-mail: user-help@struts.apache.org
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>>> For additional commands, e-mail: user-help@struts.apache.org
>>>
>>>
>>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
>> For additional commands, e-mail: user-help@struts.apache.org
>>
>>
>>
>>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


Mime
View raw message